A police investigation was launched after cancer patient Donald Gough deteriorated and died unexpectedly