Yes I kind of obsess about this but I've got a fun video so it is ok.
I know I'm building off other people's work like drop a sub into Lava ETC. But I've made a recording of a dwarf surviving a fall from good amount of Z levels because he is in 7/7 water and so are the two cubes of 7/7 water below him. Water has been proven to slow down a dwarf's fall but apparently being submerged in falling water works as some kind of impact absorbing gel.
In my recording I have a proof of concept with one test dwarf in the situation described above surrounded by five control dwarfs.
http://mkv25.net/dfma/movie-2369-dropwaterconceptAs you can see the control group (Dwarf 2 through 6) is grievously wounded while the test dwarf (dwarf one) doesn't even register that he's impacted with the ground.
This means dwarfs could be deployed easily from a tall tower/sky fort or into the depths of a cavern with a few levers, a couple of floor hatches and water.
I imagine that this property of dwarf physics could also support a real dwarf drop pod. One that utilizes water as an impact shock absorber. I wish I could make this my self but I don't have the technical skill it would require. (I've never used pumps etc)
Even so I'm very sure my !!Science!! is sound. Below is my late night ramblings on how to construct such a drop pod. Of course my video above shows that a drop pod isn't necessary over to top ridiculousness that can go terribly wrong is always much more interesting.
It would be 3 Z levels and made of cast obsidian.
First you cast a 3 z level tall 3x3 column of obsidian. On the top mount a support on one of the corners that connects to a roof or launch dock or whatever. (that support exists on the 4th Z level connecting to something above it on the 5th) Also there should be a shaft going through the middle from the floor of the 4th Z level going down to the floor of the 1st Z level. Don't dig through the 1st floor. Leave it. Cap this central shaft with a floor hatch. Also access to this part should only be possible with a retractable bridge.
The 3rd Z level is a little tricky. You've got to place a floor grate there. If you can mine a wall, place this then link it to a lever then re-seal it with obsidian that'd be great. Otherwise I suppose a floodgate would do.
2nd Z level is just water storage (a 1x1 room with 8 walls around it)
*1st Z level is the same with one difference: four of the walls are mined out and replaced with floodgates. I'm pretty sure constructions deconstruct when collapsing so they don't need to be linked to anything. This will give our dwarfs four exits to choose from when leaving the pod and also give the water plenty of room to drain. Also note that the floor of this Z level should stay intact (don't mine it out)
Remove the mold the pod was cast in and smooth all the obsidian for style. Maybe carve some engravings of dwarfs falling to their deaths, I donno.
Now your Drop Pod should be hanging by the roof support. Fill it with water (by opening the top hatch) and seal it. Does water evaporate in a sealed container? W/e just fill it with more water later.
Once it is ready and you've got baddies below extend your bridges to give access to the pods, have your drop dwarfs stand on the floor hatches. Open those up and close 'em. You now have a Dwarf Warriors drowning and waiting to go into combat! Pull the level that knocks out the support, your cast Drop Pods fall, crush gobbos and spit out wet angry dwarfs! YES!
*I just remembered reading that the roof of a cast item also collapses. While my drop pod doesn't have a solid roof it does have solid walls on multiple Z levels. Does this mean they would condense into one Z level? If so the bottom 'floor' should be an upward ramp. The 1st Z level would also have to be expanded to include cast upward ramps around the 8 walls. This should allow the dwarf to climb up over the wall and down onto the battlefield. Again this is unnecessary if a cast wall does not condense.