So, after 13 years my fortress has finally met an ignoble, watery end. Somehow one of the hatches controlling access to the main water reservoir opened on its own volition and flooded a good portion of the living quarters. No idea how that could've happened, because all 4 hatches are linked to the same lever, so an accidental press would've opened the other three (and of course the lever is still in unpressed state), the hatch itself is perfectly intact (and still has the mechanisms inside), so it wasn't deconstructed, and I am not aware of dorfs or other critters being able to open lever-operated hatches.
Here's a picture:

F1 is the ground floor of the reservoir, in the center is the main fortress staircase. You can see the 4 submerged hatches there, the malfunctioning one is circled in red.
F2 is the floor below, mostly occupied by the food stockpile. The four wells are right below the hatches. In case a refill is needed, they can be blocked off by floodgates
F3 is the next floor, - cemetery and living quarters
F4 is the town's water supply, this is just the top portion of it. The stairway in the middle leads down into the caves and there are 4 floodgates around it, in case I need to flush down a forgotten beast, or wash off nasty extracts.
(It's really only a minor design flaw that all relevant levers, including failsafes are in a room BELOW the reservoir, rendering them completely inaccessible in case of a flood. Then again, after accidentally flooding my fortress once before, I really wasn't planning on doing it again!)
I'm stumped. Help me out here guys.