After an existential journey goes wrong, a man finds himself in Equestria. With no way to return home he has no choice but to find a path in a new body. Will he discover a place to belong once again in this new land, or be forced to carve one out?

Currently rewriting first eight chapters and editing the rest of the story. Plot will be fundamentally the same, just the quality will significantly increase. There will be some story and character changes.

As of right now the story ramps in quality with some bumps due to edits.

Twilight Sparkle wakes up one morning to a harsh dose of unreality. She is stranded, without her friends, on an island which matches no known locale on Equestria. Surrounded and harried on all sides by the alien and the dangerous, she will find her mettle sorely tested, and find perhaps that the best friends you will ever have in your life are the ones you make when your back is to the wall...

Thanks to CedricBale and noobie56xx for tracking down the name of the artist so I could give them credit.

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

An alarm sounds. There's a planet nearby. I wonder if anyone can hear me.

This is the story of the end. This is the story of the death of Equestria. It is the story of the reign of her royal majesty, Princess Twilight Sparkle of the Fading Sun.

The alicorn sisters are dead and Equestria has turned to Twilight Sparkle to guide it. However, just maintaining a dim sun a fraction as bright as her mentor's keeps the new princess near her limits.

Years have passed and Twilight Sparkle is sure of only one thing. Equestria is dying.

NOTE: Written before "It's about Time" in season 2. Everything after "Read it and Weep" was ignored throughout this story.

Humans.

Truth or myth? Ancient lost civilization or just an old pony's tale?

No pony has ever seen one, and most haven't even heard of them. But Lyra knows that these wonderful creatures are more than just old legends, and she's going to find out... and possibly drive her roommate insane in the process.

Tall Tales didn't intend to be in Ponyville for long. It was supposed to be a brief stop on the way to the storytellers' gathering in Connemara, and nothing more. How was he to know he'd be offered the opportunity to show southerners real storytelling? More to the point, how was he supposed to refuse? And just what does this pink pony want with him, anyway?
Now he's shanghaied himself into performing, and must use all his skill to stay on stage, on target, and within the bounds of sanity. So gather round, pull up a bollard, and listen to some proper Equestrian folk tales.
Or watch one stallion go slowly mad in public. Either way, you're in for a treat.

Persuaded by Pinkie Pie to loosen up, Twilight Sparkle uncharacteristically deviates from her routine and finds a street that does not exist on any map, a street that should not be there. Down this road is both a threat, and an answer, one that may help us all reconcile the troubling inconsistencies between Season One, and all subsequent seasons of MLP:FIM.

♥ As Featured On Equestria Daily!

Finding herself with wings and unusually powerful magic, Twilight Sparkle proceeds to have breakdown after breakdown, until with the help of her friends, she confronts Celestia and Luna about it... And learns that she's a far more important little pony than she ever imagined - for all the wrong reasons.

Awesome painting by Drezzer can be found here!

20 megapixel version is here (10MB JPEG, 210dpi strangely, 24"x20")!

Thanks, man!

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