What would you do if you've gone where no mare has gone before, and have no idea how to get back?

Rainbow Dash found herself alone in a strange, magicless world governed by entirely different natural laws than Equestria, ruled by a race who thought themselves the only sentient species in the universe...

A pianist from Earth is home on a lonely Saturday, getting ready to enjoy his weekend, when he is suddenly summoned to Equestria - only to find himself being held captive by The Great and Powerful Trixie, who plans to use him as a piano-playing slave in her show.

If you came here looking for the sequel, 'The Piano Man: Act II', it can be found here.

Princess Celestia tires of constantly being surrounded by decorum, deference, and formality, and decides to take a day off from being Princess. But visiting Ponyville incognito is harder than she expects. Will she be able to fit in and make friends without blowing her cover?

Applejack finds a strange visitor in her apple orchard one day, with even stranger stories to tell...
MLP/L4D2 crossover. My first story on FiMfiction.net! May add more tags as story progresses.
Credit for the image goes to brokencreation on DeviantArt.

The Piano Man has spent the last month in captivity, forced to play the piano as part of The Great and Powerful Trixie's traveling show. Now he's free, and recovering under the care of the Equestrian monarchy while Trixie awaits trial for her crimes.
All is not well, however. The Piano Man has a long road of recovery ahead, and all the time he must compete with overbearing carers, his own mental trauma, and even discrimination from members of Equestria's unicorn supremacist subculture.

This story is the kinda (can't stress that part enough) better-written sequel to 'The Piano Man'. Because the first story involved some rather dark scenes, I have included a helpful catch-up in the first chapter - so if you have no interest in reading a dark story, then you can ignore the first piece and skip straight ahead to this one.
'The Piano Man: Act II' is most certainly not a dark story, and neither is it sad. The sad tag is in place for scenes in which I reference the previous installment, and nothing else.

The absolutely amazing cover image was created by the even more amazing WIL_I_ZIN, (deviantART) who is just... just awesome, for helping out.

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.

Okay, I don't know if anyone can hear this, or read this, or whatever, but I'm trying my best to use Pinkie Pie's legendary fourth-wall-breaking powers to try and get a message out.

If you can hear this, I need help. I'm in Equestria, and man, this is strange. But I'm also stuck in Pinkie Pie's body, for some reason.

Yes, it's just as weird as it sounds. And now, I need your help... because all the ponies in this town think I'm crazy!

Twilight Sparkle presents a collection of interviews, letters, essays, poetry and prose compiled over several years of her relationship with the human Bellerophon and his "herd", covering subjects as broad as Equestrian social taboos, comparisons of earth and Equestrian mythology, romance and the occasional recipe. Compiled by Twilight Sparkle, with foreword by Her Royal Highness, Princess Celestia.

(This is a bit of an experiment based on the worldbuilding concepts presented in AnonAuthor's Xenophilia [[NSFW] - caveat lector!], which intrigued me enough to want to take a closer look. It's likely you'll be very confused by this unless you read at least some of Xenophilia. Updates will appear as and when an idea pops into my head for a thing to add. And fair warning, some of this might come across very dry and dusty. Thank you academia! And thank you AnonAuthor for letting me have a go, and both AnonAuthor and AnonponyDASHIE for all the collab work they're doing. I'll make up for the dust by tossing in the odd piece of art now and then.)

Note from the Author (3/28/2021)-
Really gotta hate how people don't listen to this segment. Really gotta love it.

Seriously people, FOR THE LOVE OF ALL THAT IS HOLY Please do not comment on, thumbs up, fave this story, or add it to any bookshelves. Years later in all honesty I'm not happy with this story or how I ultimately wrote it. The only reason I don't delete it is because it got featured and because so many folks have it in their bookshelves already.

Hello. If you're reading this, you somehow found my message. Hopefully you are a fellow Brony, and will not simply assume this is the insane ramblings of a crazy person.
Oh, I suppose I should introduce myself, this story is about me, I guess. The name's Cain. Nice to meet ya.
Now, getting to the point of why I sent this out. Ya see, a few months ago, I had a rather unsettling experience. My mind was ripped from my body on Earth and transported to wherever it is our beloved Equestria lies. Normally, this would be nothing to worry about, as it seems to happen all the time, but frankly, this time was different. Instead of being sent to Equestria as a human, or nay, a pony, my mind was placed inside the body of an Equestrian.

Unfortunately for me, it happened to be Diamond Tiara.

Yeah...not what I was expecting either. Now, quick, before the message fades, get me some help!!

Looking for Co-Authors!
Former-HoneyHoneyHoney
Current-Pinklestia
Helpers-Hoopy McGee,CloneBurner, RemareShadows,
shagohad12, Dusty the Royal Janitor

Inspired by Hoopy McGee's Why am I Pinkie Pie?!

It is the year 2038, and the Earth is slowly being consumed by a space-borne monstrosity dubbed the Black Tide, which is using nanotechnology to remake the planet into something hideously alien.

Erin Olsen works for Project Harmonics, humanity's last-ditch effort to find a new world before the Tide can wipe them out. But when that world is found, and it turns out to be occupied, Erin will need to find the courage to face the unknown in order to save the inhabitants of both worlds.

(Many thanks to Easteu for the fantastic cover image for this story!)

Now with its own TV Tropes page

There is now a follow-up to this story: Sunflower - Side Projects
Sequel: Project Sunflower: Harmony