One that held a specific fear for me was the book Sum of All Fears by Tom Clancy. It did get a movie adaptation but I didn't care for the film as it strayed pretty far from the book. I have kind of a love/hate thing for Tom Clancy books because, having been in the US Army in a Military Intelligence unit where I worked with CIA, DEA and once even Border Patrol agents I like the accuracy and attention to detail the books have for how government spy agencies really work. At the same time this makes the books much scarier as everything sounds very realistic and very plausible.
Anyway, in the book Sum of All Fears a terrorist group gets its hands on an old nuke that got lost during the 6 day war in Isreal. They reconfigure the nuke so it can be put in a van and detonated at a preset time and date. Their plan is to disguise the van as a news van and park it right at the main entrance to Denver's Mile High Stadium so it can detonate during half time of the Super Bowl. This freaked me out because at the time I was reading the book my wife and I had just moved to Colorado. In fact I was working in downtown Denver and passed Mile High Stadium during my commute everyday. At this time Denver was building a new football stadium so I got to see the old Mile High Station torn down a demolished, which was an added unnerving visual that I got to go along with the events in the book.