I know this isnt the answer you were hoping for but if windows doesnt even see it there isnt really anything you can do. I was about to get a drive working for about 30 minutes after freezing it for 24h and got data off it it but your failure sounds different, but on another drive which was making the clicking noises it didnt work. If the data is really that important bring it to some data recovery professionals.
Thinking about it I'm not sure whether Windows could still see the drive that was failing or not (before it locked the machine and crashed), I was so focused on finding out which drive it was and disabling it that I didn't pay a lot of attention.
It's getting late now but I'll be investigating it more tomorrow, I'll try plugging it in using an Icybox USB enclosure and see what happens...fingers crossed!