You get a message if they die from old age. The only time you don't get a message for an agent death is if an enemy assassinates them.