One hundred years. Twilight Sparkle is having a tough time stomaching that reality. She has lived a full hundred years in Equestria, and being an immortal princess promises only more centuries to follow. She's not sure if she's ready for the rest of her life.

But Twilight's lifelong friend and mentor has a special gift for her, something that will change her perspective about the future.

Lovely cover art is from Momomistress

After the timeline goes awry for the eighth time, Twilight Sparkle convinces Starlight Glimmer to journey with her through the most recent world she created, using her alicorn magic potion to safely view one of the tragic timelines. As the world spirals farther and farther out of control, Twilight fears the vision may be doing more to strengthen Starlight's resolve than to bring her to an understanding of her mistakes.

Starlight Glimmer vector by itv-canterlot on Deviantart

A good portion of chapters 1-3 debuted in the Writeoff event "Forbidden Knowledge"

Red tags for mild gore and fantasy violence.

This story is a sequel to Single Point of Failure

Love. It's a powerful feeling capable of toppling empires and bringing monarchs to its knees. It can make the sun shine brighter, the birds sing louder, and the world taste sweeter, but everything has its shadow.

A seemingly innocuous sentiment sends Twilight on a journey of discovery to find out just how deep the heart's rabbit hole can go, as she wrestles with that most dangerous aspect of love.

Credit to Meta Four for proofreading.

Changelings and ponies had always been natural enemies of each other, especially with the crystal ponies when they were around. Why wouldn't they be? Changelings were like parasites, feeding off the love that ponies gave off and driving them to illness.

However, Changelings had begun to decline. What started out with as seven hives have diminished down into three, all of which had gone into hiding so well that most ponies didn't know what changelings even were. Even Celestia had not seen one for quite a while, a long feat for an immortal pony.

Until she found a nymph. A new Changeling Queen.

Unable to find it within herself to abandon the changeling, Celestia ends up taking the nymph back to Canterlot under guise as Twilight Sparkle. The plan was simple; find the hive that Twilight belonged to and return her back to be raised with her race.

Of course, despite everything she learned through her long life, she had forgotten that things were never that simple.

For starters, she did not anticipate herself to grow fond of Twilight as time began to pass, or to beam in happiness when Twilight began to refer to her as mom.

Many Many Thanks to my Pre-Readers: Rewrite and Doctor Disco (Welcome to the Team Doctor!)

Before every great journey, there are the trailblazers and adventurers who open the doors to the future. Every significant expedition is built upon the achievements of those who came before, those who worked and sacrificed to make the future possible. For the ponies of Equestria, the forerunners of the future are the crew of the ESA Harmony, a ship lead by Princess Twilight Sparkle and built with one purpose: exploration. The crew have their orders: arrive at a nearby exoplanet, engage in scientific and research operations, then return home with the results. And with those results, more missions will be built, and the future of Equestria will be defined.

But even in our greatest moments, there are those who long for yesterday, and will do everything in their power to prevent change. The crew of the Harmony are not immune to the agents of regression, and when a saboteur strikes in deep space, the crew finds that their mission has changed. Instead of finding the future of ponykind, they find themselves fighting for their survival aboard a crippled vessel. With tensions rising and the mission effectively scrubbed, Twilight Sparkle embarks upon a new mission: identify the saboteur, and return the crew to Equestria, alive and well.

Twilight takes Applejack up on a chance to study new kinds of relationship, but will this experiment end pleasantly, or will their relationship crash and burn around them?

When a dark shadow comes crawling out of the past, the pair may find themselves lost in Ponyville's twilight hours.

Thanks to Meta Four for proofreading.

The caribou are pushing back and pushing hard against Equestria, wanting nothing more then to enslave the whole lot of them and turn all of the mares into willing whores for Diann's pleasure. However... they didn't expect a long dead race... to aid Equestria in their time of need.

Even in death... we fight.

Story hit the feature box 1/24/2017

In the midst of doing a favor for Ember in the dragon lands, Spike tells Rarity about his not-so-secret feelings. Rarity responds with a secret of her own, one that she's guarded for most of her life. They picked the wrong day, and the wrong kingdom, for a quiet heart-to-heart.

Winner of Steadfast Hoof's sparity contest
Featured on Equestria Daily
Pre-read by mrk
Cover art drawn by Pia-sama and designed by Novel Idea

Gamer-type fic, inspired by Clicker Heroes

Reincarnation doesn't always go forward in time. Sometimes it goes in a loop, as in the case of Twilight Sparkle. She lives, she fights, she gets allies. Than she dies, improves herself and friends, and occasionally buys something that makes the world a better place. Finally, she is reborn and lose her memory. Rinse and Repeat.

However, with her rising to Alicorn, she has unlocked a few new things that would make her lives easier. The down side? In order to afford these, the world needs a hard reset. The temptation? She could keep her memories.

Soon Twilight Sparkle will see just how much she has done for the land of Equestria over her many lives, and see first hand what it was to start with. Thankfully, with no sarcasm for once, Discord is here to help her build the world back up.

This story is a sequel to Feedback

A terrible loss has been averted, but even that has a price.

Between the disappearance of several hundred ponies from around the world, strange portals leading to alternate versions of Equestria, an unknown alicorn frequenting Ponyville for secretive reasons, and the arrival of a new race of ponies bringing some ulterior motives, the pieces sowed by Twilight’s fight with the Nameless are set to crash back down.

What happens when friendship fails? Who will take Twilight’s place within the grave?

The Crystal Ball Trilogy is a series of stories which deal with time travel, parallel universes, and other manipulations of time and space. Substitute is the middle story; it is preceded by Feedback and is succeeded by Divergence.

Digital pdf version here
Print book version here

Featured on 7/19/2016!
Goodreads entry~

Ask Me Anything 10/22/16
Ask Me Anything 1/18/17

Edited (with varying degress of contribution) by
sourichan, Kuairu, Thought Prism, Orion Caelum, Corejo, and AlicornPriest