A "good natured" recovering alcoholic died when the drainpipe he was climbing to gain entry to his rehabilitation centre collapsed.