Since I've been on Facebook (around 2007) I have had a number of friends pass away. Naturally, it is sad and I read their wall to see what has been posted, but out of respect, I delete their profile as I do not want any of my stuff to show up on their wall like they are still alive or be alerted that they want to be my friend -- after I know they've passed on.
SO, I did find an article on the topic, but to summarize it there are several things that can be done.
1. Nothing. Now, with this being said, it's a poor choice. People who were not friends with them on Facebook who may have friends in common with them will have them constantly showing up in the "Joe wants to be friends" column of your page. Awkward, at best. Creepy, at worst.
2. Contact Facebook To Have Their Page Removed. You naturally have to provide some documents, but this would be one way to do it so that it is completely removed and has no way to be re-activated....or resurrected, if you will.
3. Memorialize The Page. I've seen this a lot with young people who have been killed in car accidents or who tragically die way before their time. People can leave tributes on their wall and a lot of nice things are said. This would be nice to read about for a grieving family and DOES give some family members administrative control as to what is posted and can delete posts. It also removes some personal info from the account as well.
Even though you may not think you are going to die tomorrow, what would you want your loved ones to do??? Now that we are fully immersed into the digital age, a decision like this may be as valid as what songs are sung at your funeral or what you want on your headstone. Anyway, something to think about.
Here's the link, for more information: