The veteran producer, who headed Super Good Films, lost his life in the tragic accident