I contacted several books about this issue in the past. All of them agreed to pay the family, provided with 1. a death certificate, and 2. proof that the family is entitled to the money (e.g., via a will or other legal document).

The bigger problem is: how would a family find out about all a player's accounts? It might be a good idea to keep a list of active accounts in your safe deposit box with the account info.