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.

After an argument with Luna, Celestia realizes that she is the only creature in Equestria who cannot sleep in. She enlists Twilight to help, and the two of them come up with a spell that will allow her to spend the night on a different world. Unfortunately, all their research failed to reveal that the world they sought was populated. Now, the Princess must decide whether to continue with contact, or destroy the only non-Equestrian witness to their existence.

Cover art is called "Sleeping Celestia" by Briskby

After escaping the Changeling gladiator arena at the cost of a friend's life, Equestria's lone human is attacked and befriended by Twilight Sparkle. This begins a long, strange, and confusing adventure to return home, and discover why he even arrived.

Complete, and edited twice... but If you see something I missed, I'd greatly appreciate it if you'd leave a comment.

Cover art made in Blender.

Though most view them as simply immortal powerful rulers, some ponies worship the Princesses as actual Goddesses. Some families with deep Earth Pony roots worship the old Nature Spirits of their ancestors.
But some ponies turn to darker forces. They worship monsters and demons, praying for plagues and misfortunes upon those they despise.

One day, Discord finds out that in his "extended absence", a cult formed with him as the Central Deity. Unfortunately, it's not exactly what he would want. These ponies will soon find out it's a bad idea to anger your god.

Edit 5/18/18: New cover art courtesy of the illustrious Mix-up. Check out the original here.

This story is a sequel to Project Sunflower: Harmony

In every tale, there are unseen details. Small stories, often going unnoticed. This is a collection of those stories that relate to Project Sunflower: Harmony.

It isn't recommended to read these stories without reading the main story. Without the context provided in Project Sunflower: Harmony, it isn't likely that these chapters will make much sense.

Every chapter will have an author's note detailing where it fits in the main storyline. These chapters are intended to be optional to read, and are intended to add some depth and color to the main story.

Cover art by Genbulein

This story is a sequel to Project: Sunflower

After the events of Project: Sunflower, Erin Olsen has returned to Ponyville, happy to pursue her studies in magic. After everything that happened the year before, she's looking forward to spending her days studying and having fun with her friends.

Meanwhile, on the newly discovered world of Harmony, humans and ponies work together to study this strange new world. However, their arrival causes something ancient to begin stirring. Something that may end up changing everything.

Erin will need all of her courage, all of her cleverness and, of course, all of her friends to see herself through what happens next.

Cover art by Valkyrie-Girl
Editing provided by:
Brilliant Point, Coandco, Ekevoo, Ludicrous Lycan, Merlos the Mad and Razalon the Lizardman.

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

Deep in the Royal Library is a book. A terrible book that is said to send whoever reads it mad. A book so dangerous that it has to be hidden away and secured with chains to prevent it from ever being opened.

A book which has just been accidently checked out by Spike on behalf of Twilight Sparkle.

The Star In Yellow is rising once more, and only Rainbow Dash and Spike can save Twilight before it's too late. Ideas live forever. Ponies do not.

This fic is loosely inspired by the 19th century story 'The King In Yellow'.

Celestia and Scootaloo are homeless in a Ponyville alleyway together. They like to talk about things.

These are the things they talk about.

Note: The crayon scribbles of a plot is done, but the ride never ends story still updates.

Celestia comes to visit Twilight and Starlight after Hearth's Warming Eve festivities die down for the night.

Starlight, figuring she'll never have a chance like this again, asks the immortal alicorn about what went down all those years ago.

Reading by TheArchitect!

Second reading by _NeighlyReads_!