In a heated discussion about appearances, Rainbow Dash accidentally reveals a personal secret! What will Rarity do with this knowledge?...

On a return from a frustratingly dull mission, Captain James Tiberius Kirk and his crew stumble across Equestria, but soon discover a Klingon plot to devastate the entire planet, and eventually, conquer the Fedaration. Join Captain Kirk and his crew in:

Star Trek VII: The Equestrian Frontier

Luna discovers something hidden from Celestia for twenty years, now, with emotions running high, she enlists the help of the Mane 6... but what seemed to be a single mystery, soon reveals a darker and much more complicated plot that will soon decide the fate of Equestria.

Check out the Empty Room TV Tropes Page (Warning: Spoilers!)

Revised chapters edits and proofing (with many thanks) by: lammy, Trevor, Nick Nack, Fifth Alicorn

Over the course of a thousand years of monotonous rule, Celestia no longer understands how to connect to ponies, and doesn't bother. But when Twilight Sparkle makes her bombastic appearance, the Princess cannot help be interested.

Featured on Equestria Daily, December 29, 2011

Harry Potter was a lonely boy who one day wished for a friend. Luna, trapped on the moon, wished for the same. And so their wishes are granted. How will the two deal with each other? And what about Nightmare Moon? Needless to say, their lives are going to change in both expected and unexpected ways...

Other stories in the Lonelyverse:
Hooves, Plush, and Magic: The Untold Tales
The Wizard and the Lonely Princess: Hallowe'en Special
A Nightmare Christmas

Chapters 9-11 now re-written.

The Princesses find an alien creature barely clinging to life at the scene of a terrifying crash. Can the Combined Power of the Elements of Harmony save it, or more importantly, should they save it? Will the arrival of this strange creature tear Equestria apart?

TV Tropes
https://tvtropes.org/pmwiki/pmwiki.php/FanFic/Article2

This story is a sequel to The Dresden Fillies: Strange Friends

Almost a year has gone by for Harry Dresden since he left Equestria. He'd have written, but between saving his newly discovered brother and destroying a scourge of vampires he's been a little busy. Then out of the blue he receives a strange letter from Twilight asking him to return. With no cases at the moment he eagerly accepts, but his friends aren't the only ponies expecting him. There's been a lot of rumors since his last visit and some ponies aren't too keen on seeing him come back.

A sequel to The Dresden Fillies: Strange Friends.

What if ponies replaced humans in the Mass Effect universe? Will Commander Sparkle save the day like Shepard did?

Special thanks to vimbert and 108Echoes from Ponychan's /fic/ for proofreading and conceptual ideas.

The GDoc links, if FimFiction does not fancy you. This is both my working copy and the originals that was published on Equestria Daily.

Harry Dresden, Chicago's only professional wizard, accidentally travels to Equestria after being attacked in the Nevernever. Twilight is none too amused with their newest 'guest', but trouble is brewing. Somepony is planning something sinister and the mane six may need Dresden's help however little some of them want it.

Story Image by: Lynxgriffin
Cover arrangement by: Novel Idea

A not so standard human-in-Equestria story including but not limited to: democracy, tequila, and robots.

Things escalate from there.

TV Tropes page

Now translated into Korean