An inquest into the death of Cranberries singer Dolores O'Riordan has found that the music star died from drowning due to intoxication from alcohol.