I always figured Accardo and Aiuppa had Mooney offed because they didn't want him regaining any power and possibly posing a threat to them. Even though he was in failing health and had been out of the loop for several years (as elmwood says) it was still probably a wise business decision on their part.