Board Thread:Skyrim/@comment-112.198.82.247-20130724121145/@comment-1834116-20131003040642

Tsun mentioned that after his/her count of days The Dragonborn will go to sovngarde, plus the Dragonborn is the chosen champion of the divines his/her soul is protected by the divines (if the Dragonborn is good of course.) so i believe he/she will go to sovngarde.