Twilight Sparkle has too much magic, and it will take her decades to learn to control it. Her spectacular loss of control during her entrance exam only proves that fact. She is a danger to herself and others.

After Sunset Shimmer’s disappearance, Princess Celestia needs a new student to bear The Element of Magic to defeat Nightmare Moon. With all of Equestria at stake, Twilight Sparkle…is not the pony she needs.

Princess Celestia seals Twilight Sparkle’s magic with the distant promise of one day teaching her.

But there are two diarchs of Equestria. Amidst a lucid dream, an offer is made.

“Hello, Twilight. Would you like to be my student?”

Cover art provided by Lafiir.

This story is a sequel to The Celestia Code

When the monsters created by the dark crystal engine escape their prison, it's up to Princess Twilight Sparkle to deal with them. She gets help and advice from Princess Luna, but things don't go as planned. In fact, when a pony who relies on logic and rationality tries to navigate the stormy seas of emotional entanglement while simultaneously saving Equestria from a horde of evil creatures intent on destroying everything they encounter, nothing goes as planned.
AUDIOBOOK by VisualPony
WARNING: Major spoilers in the comments.

Book 2 of the Alicorn Adventure series.

Goodreads Page
100% Approved by Twilight's Library!

The Badass Twilight tag applies more than ever, but please note the new tags.

This story is a fairly direct continuation of The Celestia Code. You might be able to follow it without having read The Celestia Code first, but it's better if you do.

The sequel is here: The Twilight Enigma

Most excellent pre-reading/editing done by the erudite AcademicPony and the dapper statoose!

This story is a sequel to The Cadenza Prophecies

Princess Flurry Heart inherited her mother's beauty and grace as well as her father's strength and bravery. The Empire couldn't hope for a better or more suitable heir to the Crystal Throne. Everypony in Equestria admires her and thinks she will be an ideal ruler.

They're wrong.

Young Flurry Heart has no interest at all in being a prim and proper princess, and would much rather have wild and dangerous adventures like her Aunt Twilight.

Book 5 of the Alicorn Adventure series.

Princess Twilight Sparkle discovers a centuries-old mystery hidden in the Royal Archives. Her investigation leads through layer after layer of deception and misdirection, setting her hooves on a path that seems to be leading to a mysterious secret. Along the way, she learns that some friendships can be very, very strange.

Book 1 of the Alicorn Adventure series.

AUDIOBOOK by VisualPony
Featured at the Royal Canterlot Library
TV Tropes Page (Courtesy of Sandtalon)
Goodreads Page (Courtesy of Facedeer)
Equestria Daily Page

WARNING: Major spoilers in the comments. Takes place several months after the end of season four. (Not a Da Vinci Code crossover, BTW!)

Do you see a dark tag? No, you don't. Not dark. Well, okay, there are a couple of dark-ish bits, but that's all. Not enough to warrant a tag. Speaking of tags, there really ought to be "Badass Twilight" and "Friendshipping" ones.

Sequels and side-stories (and more) can be found here Offprint and AO3, and a hardbound two-volume set of all that can be ordered from The Ministry of Image.

My editor for the first edition of this story was Gogito, and I can't thank him enough for all the hard work he did. My editor for the revised version was PresentPerfect, and he did a terrific job of getting the story into excellent shape.

This story is a sequel to The Luna Cypher

Twilight sets out to learn more of the ways of the world, and soon decides that the whole planet is disorganized, insanely dangerous, and desperately needs to be fixed. And she's just the mare to do it... with a little help from her friends.

Also, there are sky-pirates!

Book 3 of the Alicorn Adventure series.

A few extra, slice-o-life chapters are here: On the Rocks

Twilight becomes alicorn of the stars. This is sort of a problem, because Luna kind of already was alicorn of the stars. Oops!

TV Tropes

This story is a sequel to The Code's Apprentice

Sequel To : The Code's Apprentice

The land of Equestria has been changed forever.

New monarchs sit upon the thrones of the Sun and Moon, the once almighty power of Harmony overturned to make way for a new Diarchy of Balance. Political unrest and turmoil have engulfed the land, and at the very center of it all, Princess Celestia - renamed Tia Sunbeam - seeks atonement for the crimes she committed in the name of Eternal Harmony.

With much of her power sealed away, Tia must live amidst the citizens of Ponyville as the world changes all around them. As Ponyville works to rebuild following the struggle between student and teacher, they must cope with the edicts of a new government determined to bring equality to all creatures, beliefs, and ways of life - even those that were long since banished to the dark places of the world.

Tia Sunbeam will struggle with her own deeply held convictions on the way the world should be, versus the way it will now become. She will face a truth she has long since denied, and realize the true meaning of Harmony. And perhaps, most importantly of all... She must make some Friends.

Cover art by SinSays at http://sinsays.tumblr.com/ - Go spend some money with her! :D
Oh, and go check out my new side story - Rise - It's going to become relevant here!
(character tags are not comprehensive! Some are being kept secret! ;3)

A refined mare fresh out of high school and a dropout following her dreams find themselves forced to spend a lot of time together.

With the help of a meddling psychology tutor and their new classmates, can they find what they've been looking for?

French Translation!

Fan Stuff!

[Complete! With TVTropes apparently!]
Also, apparently, an animated trailer.

In a world of brass and steam, Twilight Sparkle had thought she had made a life-changing discovery with the invention of the telescope. For better or worse, she was correct.

Now her discovery has not only changed her life, but the lives of those she seeks out in her desperate attempt to contact the only other creature as lonely as Twilight herself.

It all would have been much simpler, but it had to be the one Twilight could only call The Mare on the Moon.

Decidedly not within walking distance, then.

[Featured on EQD before story was meant to be submitted. 4/03/2015]

[Editing team: Southpaw, Wolfvenom, Maskedferret, SwanSong and BluePaladin42, without whom this story would be a fraction of its current state.]
[Special thanks to Novel-Idea for the updated cover]

When Celestia went on sabbatical into the west, she promised Twilight it would be only a couple of months. A year and a half later, the sun resists control, the country is in ruins, and her teacher is lost in the wilds. Twilight has become the apostate, her faith in her teacher and her teachings waning. In the wake of tragedy, her resentment blossoms into fury and she vows that something must be done. Shadows gather around Canterlot, and old things that should not have been awakened are on the move. The Student goes west, her hope restored by friendship and righteous fury.

The night, at long last, is passing.