Detonation Films:

This is a FANTASTIC site. It has tons of free stock footage including spark hits, muzzle flashes, fire balls and all sorts of shenanigans. But I suggest buying the footage from cafepress to support them and to get the bonus clips! Recently they added HD footage, Bob is a true badass!

Gigantic fireball on a easily key-able blue background. BOOM!

Dirt explosion that can be keyed with a luma key or a transparency mode. I used these bad boys on my Panzer Test II.

Shell casings! One guess what this is useful for..... yeah guns :)

Sparks and the list goes on and on!!
NoControl Cinema.

His titles include- The Super Stock Pack, Explosions, Gun Effects, Blood Hits, Sparks, Fog and fire. And Marco von Moos of NoControl Cinema is one heck of a filmmaker, check out his stuff!
I personally own from footage both places, you can never have enough diversity in your effects. Now that you own this wonderful stock footage what do you do with it? Compositing!
-------