The Social Health Authority (SHA) is mourning the death of its manager, who lost his daughters in a tragic road accident.