The really serious threat is the New Madrid Fault.
We in the Pacific Northwest are due for an 8.5 to 9.0 quake, based on our history. Until 1995 or so buildings (including the Space Needle) were built to withstand an 8.0 because geologists thought that was the biggest we could expect. Then a geologist from the U of Washington at Seattle spent a year in Tokyo researching the "Orphan Tsunami" of January, 1700. An "orphan" tsunami is a wave that comes in with no earthquake before it. In this case he hypothosized that the earthquake had happened at the edge of the San Juan de Fuca plate and found a lot of evidence that we had had a very large tsunami and land sinking at that time based on tree ring work.
So now our building codes require building to withstand a 9.0 and in about thirty more years most buildings will be built to withstand that, including some retrofitting. So we are getting ready. There is an Indian reservation that has petitioned congress to move, since it will be completely submerged, and most coastal cities are building large land "bumps" for refuge.
However, the New Madrid Fault is still poorly understood, though the last time it sprang was December, 1811, and it knocked over buildings in Boston and in Charleston, SC. It is due to spring again in this century and will likely damage Chicago, St. Louis, Kansas City, Memphis, New Orleans, and Little Rock. Given what little is known about the fault, it is possible that it will submerge some of the Mississippi Valley. Unfortunately, none of those cities (except, I think, Chicago) have seismic building codes.