Which debts are forgiven when someone dies?

When a loved one dies, certain types of debts may disappear, but others may impact heirs and the estate.