(A sequel to Arrow 18 Mission Logs: Lone Ranger)
It all started with an unexpected visitor. A single, curious individual from farther away than anypony could ever have fathomed. At first, a curiosity of a creature to be minded by the Princess' protégé. Then a spectacle as he took ponies where they had never gone before. And finally, an ambassador who brought an entire planet together with the simple realization that there are more important things out there than petty squabbles.

And it all almost went up in a fireball.

But friends don't let friends die so long as they have the power to rend the heavens on sheer force of will.

Now stuck in a hospital bed, Captain Randolph Edwards, commander of the one-man space mission to the anomalous planet known as "Equestria", must wait for a rescue that will be a year in the making... Minimum.

What ever will he do with himself?

(Description written by AdmiralTigerclaw.)

For the first time in a long time, the Apple Family Reunion is being held somewhere other than Sweet Apple Acres. Big Mac decides this is his chance to finally have some time to himself and volunteers to stay behind to look after the homestead. But time alone doesn't mean that the chores can be ignored.

Berry Punch has had her eye on a certain stallion for a while now, and with his family out of the way, it's the perfect chance to test the waters.

This story is a sequel to Celestia Sleeps In

After the accidental discovery of humans, Celestia tasked Lyra with learning about Dale's culture and Dale's language. Two meetings later, a misunderstanding caused Dale and a Coast Guard woman to be inadvertently transported to Equestria. With the two humans hospitalized and communication limited at best, the Equestrians just want to heal them, while back on earth the Coast Guard wants nothing more than to determine what happened to one of their sailors.

This story is a sequel to The Dresden Fillies: False Masks

It's been a while since the girls have seen their good friend Harry Dresden. Discord escaped, Luna attended her first Nightmare Night, the Royal Wedding was crashed by hordes of changelings, and Pinkie Pie threw a statistically improbable number of parties. They tried inviting Dresden, but between his new job and new apprentice, he always claimed to be too busy. The solution was obvious; if he couldn't come to his friends, they needed to go visit him. Besides, they say Earth is lovely this time of year. What could go wrong?

Donut Joe lives a secret second life as an Equestrian Intelligence Agency special operative. A fete at Prince Blueblood's is the perfect opportunity to steal a cursed medallion, but can he work with a partner, if he's not sure where her loyalties lie?

Reading by AShadowOfCygnus

After a devastating fire, Rarity and Sweetie Belle move in with the Apple family, where Rarity gets to know Big Macintosh better.

Featured on EQD, thought I'd throw it up here as well.

On the eve of another world ending crisis Princess Celestia has complete control of the situation. Every detail has been accounted for, every eventuality anticipated. The Elements of Harmony gathered and ready to save the day and even an important side project set up. Yet after planning so carefully there are still a few things that even Celestia couldn't anticipate or prepare herself for.

Celestia X Big Macintosh

Note: Story contains crack shipping, blatant stealing borrowing of Norse mythology due to author appeal, shameless use of Shakespeare quotes for chapter titles and the constant harassment of Princess Luna.

Silver Spoon spins the bottle and becomes rather distraught when it lands on Button Mash instead of — well — anypony else...

Princess Celestia always thought she knew how her kingdom worked. The Unicorns used magic specialized to their jobs. Pegasi flew in the sky and handled the weather. And Earth ponies... Earth ponies... uhhmmm...
Huh. Maybe Princess Celestia didn't know everything about her ponies after all.
Princess Celestia realized this after Applejack came to speak with her about a tax unfair to Earth pony farmers. It was during their conversation that Celestia realized she needed help.
Huh, isn't that odd Princess Celestia has had to leave on emergency business, leaving Luna to raise and set the sun? And hey, is that a new pony living and working at Sweet Apple Acres? I think her name is Sunshine Meadow. Surely, it's just a coincidence. Surely.

A human finds himself in Equestria under very unpleasant circumstances with no explanation.
His reaction: get the heck out of Dodge and start a new life where Equestria and her ponies can't reach him.
But an alicorn's reach is long and the events which brought him here and his treatment in Canterlot are not so easily forgotten by those who did it. How does one say 'go away' to an immortal goddess?

Yay! Featured, thank you all.
A TV Tropes page
Revised 08/31/14 for clarity and grammatical issues, no events changed. I am working on a sequel, but it will be from Fancy's POV.
P.S. Green is NOT Lyra. There are other green unicorns.