I just lost in the most glorious (and stupid) ways ever. Yes; there was much !!FUN!! involved.
I started in a Mirthful forest. There was also an aquifer on the site, but thankfully it was only 2 z-levels and had a bunch of sections where you could tunnel through it safely. There was a river and everything, but it froze in the winter, so I needed an underground water source for power and drinking.
Making the well was easy enough. Just dug a room above the aquifer, channeled a hole in it and put the well over the hole. However, I would eventually also need power, and a water wheel wouldn't work too good on the surface (at least, to my knowledge). So I started a little project. A project that would be my doom.
I dug a nice long trench under the aquifer so that I could pierce the aquifer and have it drain into the ditch. I dug it all the way to the edge of the map thinking the water would exit the map. I did make a gate and lever at the crucial point where I could seal off the tunnel should it start to flood when I pierced the damp stone. Unfortunately, the flooding wasn't immediate like I thought it might be. It fell into the trench nicely and filled it up. Then it started to overflow. It overflowed when I wasn't paying attention, so when I finally notice, it was too late. The gate could not be closed. The water flowed down into the tombs. Then the main dining hall. Then the stock pile and bedrooms, and workshops, until eventually everyone not outside died.
I figured I could salvage the fort. I still had about 14 dwarves who were on the surface hunting, fishing and beekeeping when everyone else drowned. But I didn't have any axes, or picks not submerged under several levels of water, and then I was sieged by goblins before the next caravan arrived to buy some.