The private equity pioneer died from a self-inflicted gunshot wound at his Manhattan office, local media report.