You have overall 4 valence electrons in the carbon atom. They can be involved either in sigma-bonds or in pi-bonds. All atomic orbitals involved in bonding do so as molecular orbitals (remember LCAO as mathematical approach).
When a carbon is involved in single bonds only, its ${s}$- and three ${p}$-orbitals are ${sp^3}$-hybridized. When a carbon is involved in a double bond (alkenes, carbonyls etc.), three of four orbitals are ${sp^2}$-hybridized, because the double bond consists of one $\pi$-bond and one $\sigma$-bond. When a carbon is involved in a triple bond (alkynes, nitriles etc.) two of four orbitals are ${sp}$-hybridized, because the triple bond consists of two $\pi$-bonds and one $\sigma$-bond.