When I had a house the lake, initially it required flood insurance and then they changed the rules and it became optional, and it had never had flooding in the entire history of that neighborhood as house stood about forty feet above lake level... Sometimes flood maps are not very accurate...
RE: Mistake of not checking the Flood Zone!