Dave Michelson wrote:

Hmmm. How many ST episodes featured a comet? The first season TOS
episode "Balance of Terror" did.

Wait. Someone has already researched this:

http://memory-alpha.org/en/wiki/Comet

Don't forget the one in the opening credits for DS9's sixth season.

Pat