Princess Celestia always knew that Twilight Sparkle was destined for great things, but she never revealed the source of that knowledge, not even to those closest to her. When the day of Twilight's true destiny finally arrives, can Celestia fulfill an ancient promise to save Equestia's past, present, and future, even it means saying goodbye to Twilight forever? How can Celestia refuse her mother's last wish?

Art by the inimitable Harwick

Centuries after most of her friends have all passed away, Twilight decides to make one last trip into the past. No interacting, no greeting deceased friends, no reunion with her beloved marefriend. Just one quick glance at a life long lost.

However, for better or worse, she'll end up getting much, much more than that.

This story has a prequel entitled The Last Train Home.
Cover art by Swan Song

Twilight Sparkle has too much magic, and it will take her decades to learn to control it. Her spectacular loss of control during her entrance exam only proves that fact. She is a danger to herself and others.

After Sunset Shimmer’s disappearance, Princess Celestia needs a new student to bear The Element of Magic to defeat Nightmare Moon. With all of Equestria at stake, Twilight Sparkle…is not the pony she needs.

Princess Celestia seals Twilight Sparkle’s magic with the distant promise of one day teaching her.

But there are two diarchs of Equestria. Amidst a lucid dream, an offer is made.

“Hello, Twilight. Would you like to be my student?”

Cover art provided by Lafiir.

Idol Hooves holds a special place in Equestria. He's probably the only exiled changeling to serve in the Royal Guard, or at least, that's what he expects, as exiles don't really broadcast that fact. However, it's well known that Princess Celestia loves all of her little ponies, and her guards perhaps more so, and that makes it one of the best ways for a changeling to discreetly feed.

But how does a changeling even get there, let alone get exiled in the first place? For that matter, why would it ever go to Canterlot? Set a number of years before the series proper, before Luna’s redemption, Idol details how he was exiled, the ponies he’s met, and the series of misadventures that led him to joining the Royal Guard, and should continue a good ways into the series, as something of an alternate perspective.

Soon, he’ll have to deal with a boisterous new princess to serve and a royal wedding in the works bringing a third to power. Will his old instincts bring this new life crashing down around him? What precipitates Chrysalis’s ill-fated assault on Canterlot? Is it really so wrong for a changeling to enjoy good craftsmanship to an obsessive degree?

New cover art provided by the fantastic Carnifex

And a TVTropes page here.

And an Ask Blog of questionable canonity!
Out of Idol Curiosity

Fanart by Norad2! Major thanks! Short For a Royal Guard

Art by Egophiliac of Idol and his Daring Duckie Please don't tell him what that brush is meant for.

Rating updated to (T), it's a bit darker than (E)
Comedy Tag added as well
And changed the character tags a bit.

Rainbow Dash knows one thing for sure, she is definitely not a barbarous, uncivilized dolt who doesn't know polite conversation from a hippopotamus's rear end. And also that she's definitely not the one who's wrong. Rarity is wrong. Rainbow Dash is absolutely, totally, a hundred percent sure of it.

But then why did Rainbow just buy a wagon load of apology bouquets?

Distance can drive us apart. It can also bring us closer together.

After all is said and done, and the ponies have gone their separate ways, the only way they have to keep in touch is through letters.

Original Equestria Daily post is here
Russian translation
Chinese translation
Polish translation
Spanish translation

Now with music and audiobook

North of Canterlot, in the far marches of Equestria near the border with the Griffon tribes, there is a mountain that flies.

West of Canterlot, beyond the Galloping Mountains and a desert painted in the pastel hues of a faded rainbow, a tower sits at the edge of the world.

South of Canterlot, past the Everfree forest and the desolate badlands, a city of gardens waits to be born.

The Lost Cities Challenge! Awesome authors who have taken it upon themselves to explore other abandoned places:

- The Land of Glass and Stone, by RazgrizS57
- The City that Breathes, by Pearple Prose
- Aletheia, by Foehn
- Far Kobresia, by Baal Bunny
- Keskiyönnon, by Bradel
- Unknown Architecture, by Not_A_Hat
- The Gentle People, by Bad Horse
- The Seal of Wax and Glass, by DuncanR

Dramatic Reading by Illya Leonov: Chapter 1, Chapter 2, Chapter 3, Chapter 4.

Royal Canterlot Library interview for Lost Cities.

In the wake of the events of "Infernal Machines" and the Nightmare's most pathetic assault on Ponyville yet, Applejack is thrown into an existential crisis, despite her not knowing what the word "existential" means. So when a stranger named Stranger arrives in town, teaching a new way of coupling talent to power using complex machinery, she is quickly suckered in, along with everypony else. Now, it falls to the Most Dependable of Ponies to bring the resulting ruckus down to earth, but can even Applejack's legendary pragmatism stand up to the brain-fizzing horror that is... CONTRAPTIONOLOGY?

Now with a Spanish translation by Spaniard Kiwi!

A brave stallion goes on a quest to save the world by finding a lost princess in an enchanted forest. Things don't work out as he planned.

WARNING: Some spoilers in the comments. Also, a few mild spoilers for the Alicorn Adventure series, though it's not necessary to read those stories to understand this one.

Equestria Daily Page
Goodreads Page
Zabaware/AT&T Natural Voices "reading" by Modoc

Celestia's morning has been difficult enough, between hearing Twilight's confession of love, and then breaking her heart as gently as possible. Mere moments later, her private chambers are rocked by the shockwaves of a time-traveling spell. This marks the arrival of Celestia's alleged lover from five thousand years in the future, Princess Twilight Sparkle—or as she insists on Celestia referring to her, Glitter-Flanks.

Armed with thousands of years of knowledge of which buttons to push and how to make her squirm, Glitter-Flanks has traveled back to this date for one singular purpose: to establish the closed time loop that sets the two of them up as a couple.