A raccoon was rescued from a drainpipe after a 24 hour ordeal, only to collapse and die hours after reaching freedom