Is suicide an unforgivable sin?

Do we go immediately to Heaven after we die? My brother committed suicide, and I wonder if he could have a second chance with God? Is suicide an unforgivable sin? How did Catholicism perpetuate this idea? What do you think of the Freemasons movement?