The first destination is the judgment seat of Christ: It is appointed unto men once to die, and after this the judgment (Heb 9:27). And again, For we must all appear before the judgment seat of Christ, that each one may receive what is due him for the things done while in the body, whether good or bad. (2 Cor 5:10)
From here are three possible destinations. Many do go to Heaven, the ultimate destination of all who believe in the Lord and, by his grace, die in love, and friendship with him, and are perfected.
But most of the heaven-bound likely first experience Purgatory where those who die in friendship with God, but are not yet fully perfected in His love, are purified and then drawn to heaven (cf 1 Cor 3:12-15).
Finally, some go from judgment to Hell, for by their own choice they rejected God and the values of the Kingdom. It is wrong, as some do, to dismiss Hell as an unlikely possibility since the Lord Jesus taught frequently of it, and warned that many were on the wide road that led there.
"Building our Catholic faith one question at a time."