Social Security Questions? Ask a Social Security Expert
In my experience, ancestry.com and familysearch.org have accurate interfaces into the Social Security death index. Information such as his birthdate or birthplace, and when he disappeared, could be helpful in adjusting the filters, but if he changed his name, the death index won't help.
Social Security will almost never tell you if a person with a given SSN is alive, and rarely when he is dead.