I used to live in CT and I think the New London Naval Base could be a good site for it. Or Bridgeport. I think most of the risks are imagined, but there is a potential for a large explosion is mishandled.

When given the choice between LNG and Nuclear, I'm starting to side with LNG. Even if you assume the worst, which probably has a very small chance - like less than .001% in either case, at at least the LNG explosion would be localized and have no lingering environmental effects. NG is much cleaner than coal or oil making it more environmentally friendly (among the fossil fuels). With Nuclear, a leak or explosion would have increased radiation levels for decades or centuries.

Frankly, though I think we need both. And we really need to do everything we can to increase renewables and get demand growth under control.

An LNG "explosion" would actually be a BLEVE, one of the scariest things to witness.  I saw one from 6 miles away and it was the loudest thing I ever heard (I felt the shockwave before it registered with my brain the 125+ dB that would have my ears ring for the next 8 hours.  The overpressure wave and the thermal radiation damage radius can be impressive.  The only thing missing is the pervasive radioactivity.

While a spill in a harbor would temporarily freeze the water around the spill, the huge heat sink of the water would eventually contribute to the flashing of the LNG to mix with air.  Add a source of ignition and you are toast (literally).  What isn't cooked can be "liquified" by the blast wave.  

The acronym stands for Boiling Liquid Expanding Vapor Explosion, but for those with a dark sense of humor in a plant environment where such things can occur it also stands for Blast Leveling Everything Very Effectively.