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.

This story is a sequel to Avatar: Legend of Diamond Tiara. Book 1: Harmony

Silver Spoon has embraced her role as the Avatar of Discord and Diamond has fallen... or so it seems. Is all hope truly lost? As the world of ponies and spirits begin to mix and ponies rise up to, once again, fight off the power of Discord, more questions arise and the true roles and destiny of the Avatar begins to take hold. Will this be the true end of Harmony, or just the beginning of a new world entirely? The final book in the Avatar series and the culmination of years of work, plotting and scheming awaits.

Image by Silfoe, Amazing work as always.
Special thanks to Angel_Bunny for editing the chapters for me.
Please enjoy!
Full collection:
Avatar the Last Alicorn:
Book 1.
Book 2.
Book 3.
Book 4.

Legend of Diamond Tiara:
Book 1.
Book 2.
Book 3.
Book 4.

Disclaimer: "Avatar: the Last Airbender" and all associated characters, storylines, and materials belong to Nickelodeon and were created by Bryan Konietzko and Michael Dante DiMartino.
My little pony: Friendship is magic and all associated characters, storylines, and materials belong to Hasbro, and was made incredibly awesome by Lauren Faust.

Gather around children, and I will tell you stories of a time long ago. Back in the days when Princess Luna strode the night sky, bringing beauty and joy to the hearts of all ponies who truly appreciated the night, before she was banished to the moon by a jealous and cruel elder sister. It was Luna who created us and gave us our gifts, and someday if we are all loyal and follow the guidance she has left behind, we will see her return to take her place as our glorious Queen of the Night.

So pay heed, and listen closely. For it all started on a night like this...

(Started as a response to Aegis Shield's 60-Minute Writing Challenge. Parts of this show up in Genealogy (or the Mating Habits of Nocturnes Pegasi) as part of the Nocture Saga that I have been putting together.

Update: With an excellent narration by Bad Horse with the most amazing peacock I have ever heard.

There’s a Zebra in my Bed - Narrated by Bad Horse

Trixie is anything but an ordinary stage magician, so it goes without saying that only a unique kind of assistant should accompany her.

Without even intending it, that's exactly what she gets, along with all the headaches and life lessons that come with it.

Set in the Trio-verse, an AU where Celestia was banished instead, and Luna took up Sunset, Trixie and Twilight as her students. Cover art provided by Cloureed.

This story is a sequel to Midnight's Radiance

'By Shadow's Flare, dreams swallowed in Nightmare.'

Eternal night, unwaking slumber.
When everypony in Equestria is trapped within their own nightmares, it's up to one pony to save them.
Okay, one pony, and a changeling queen ... and maybe a former enemy. And also a baby dragon, as well as a shy filly?
No, wait-
There's only one pony to save them! A pony who will dive into her friends worst nightmares without even batting an eye! A pony that'll uncover ancient secrets in order to end this eternal night!
Who is this pony, you may ask? Why, none other then The Great and Powerful Trixie~!
Rest assured, Equestria is in good hooves.

Thanks to Cloureed for the cover, as always~!
Set in the Trio-verse, an AU where Celestia was banished, and Luna took up Sunset, Trixie and Twilight as her students. Recommend reading Luna's Protégé and Midnight's Radiance first.

This story is a sequel to Luna's Protégé

'Or through Midnight's Radiance, the Sun extracts obedience.'

Things are looking up for Sunset Shimmer.
She's been a proud student of Princess Luna for over twelve years, has the best friends a pony could ask for, a young dragon she cares for dearly, and ambitions on the cusp of completion.
And even better, it looks like everypony will be spending the Winter Solstice together! Assuming of course, that Celestia's return doesn't end up ruining everything...

Distant sequel to Luna's Protégé
Thanks to Cloureed again for the cover!
Set in the Trio-verse.

Celestia is far from an ordinary filly. The wings on her back and horn on her head have made that quite clear. In the corrupt, poverty-ridden world of steam and grime that she calls home, judgement against alicorns is swift and final by order of the Lord of Chaos that ponies have learned to worship.

The road to safety is far from welcoming, and fate has greater ambitions in mind than freedom for Equestria's last surviving alicorns.

(A steampunk-ish interpretation of Celestia's origin story and Equestria's historical past. Book One of a planned Three) Special thanks to Ice Star for prereading and editing help

Sunset heard about a new game that peaked her interest. Dungeons and Dragons. It was a game of imagination and where the only boundaries were those of your own mind. Sunset took a while and studied, researched, and got the required books she would need to host her own adventure. When she felt she was ready she brought the idea to her friends and they were all aboard. Now join them every week as they journey through the lands of Valatorium.

Tragedy strikes.
A nation affected.
Old, the young, rich or poor, all alike to the touch of sorrow and fear.
All are affected.
All have stories to tell...

The various side stories of The Secret Life of Rarity. If you think of a good story for this universe, please send it to me and I shall include it!

Years before six brave mares faced off against a returned Nightmare Moon, a young mare by the name of Sauer Kraut lived on her family’s farm in the Mysterious South at the foot of Macintosh Hills.

Her biggest issues in life were the constant search for new challenges and projects as well as her family's unenthused reactions to them. But was it really her fault that nopony got the brilliance behind her ideas?

However, her entire life got turned upside down the day a patrol of the Southern Equestrian Legion shot down a mysterious creature flying right overhead.

Big thank you to Recon777, Alcatraz, Civviq Writer, Silver Lighnen, Turning Gears,
Iryerris and last but not least KeyframeProductions for advise, brainstorming and proof reading!