The 48-year-old had suffered from depression in recent years, dying in a coma resulting from a suicide attempt