He played for the Psychedelic Furs, hung out with an overdosing Phil Lynott, fingered Andy Warhol’s bullet wounds and once tipped a pint of beer over singer Richard Butler. Duncan Kilburn remembers his years of living dangerously