Houston had 500-year floods consecutively in 2015, 2016, and 2017. Oh and one in 2001. Must be a terrifically unlucky place.
In practice it's calculated with models that are tuned with historical data (among other things), so if you fail to notice some important changes and update your models you might be wildly off.