It recently came to my attention that some Star Trek episodes for various series were based on spec scripts, essentially unsolicited (fan) submissions. (And as the cliche goes, that blew my mind)
For example, TNG episode Yesterday's Enterprise (the script was intensely modified, but still).
Is there a list of all spec script episodes (that came in from open submissions) for all Star Trek series?
The original idea for "Yesterday's Enterprise" was generated by Trent Christopher Ganino and submitted to Paramount on 15 April 1989, as a spec script submitted through the open submissions policy introduced by Michael Piller in that year.) This is not a bad list question.