The one thing that leaps to mind is the Japanese real estate speculation in the 1980’s. Everyone claimed, very logically, that Japan is a mountainous island with very limited space, so real estate would be almost sure to go up in value. Ultimately, the market crashed, and hasn’t recovered even 25 years later.
Curiously, at the height of the housing crisis homes were about 5.5 times the median national income. In San Francisco right now (another place where supply looks limited by the water) homes there are 17.2 times the median national income.