I have searched high and low for tutorials on how to simulate a meteor striking earth. I have found some examples of these particle effects. However none look like a meteor striking earth. http://www.centralsource.com/blender/explosions
Dude, on the page you linked there is an effect with the description: “This explosion file was brought to you by SKPjason. This explosion could be used for a meteor hitting a planet.” I think it looks pretty good, too. You could tinker with it.
Thats true, but the breaking up of the comet/asteroid in the atmosphere will look like smoke. Just look at the scenes from deep impact, which is supposed to be accurate in that scene.