I think the Grand Coulee dam is over 450' thick of reinforced concrete at its base, and over 30' of the same at the top. The gummint itself acknowledges it's unclear that a non-ballistic, large-yield nuclear warhead could breach it. Same with Hoover dam (657' thick at base, 50' at top, arched). Conventional explosives, placed casually...well, it makes for a great tour, I'm sure.
The government posted several reports in the 70's looking specifically at geologic and inflicted vulnerabilities of several dams in the US inventory. Copies were located in the MSU campus library in Bozeman. Perhaps things have changed since then...I have my doubts. The reports said essentially that it was unclear how any single event at that time could breach either Grand Coulee dam, Hoover dam, or any of a number of others.
It's a case of low possibility/high impact risks that humans have the hardest time evaluating rationally.
I'll leave it to the curious to imagine whether a 172 loaded with 50 gallons of avgas, prel, and stupidity could make more than an unfortunate smear that would eventually wear off in the rain.