Where does most of the Carbon produced from burning fossil fuels end up?

It goes into the atmosphere as carbon dioxide. The heat produced by burning fuel comes from forming the carbon-oxygen chemical bonds that creates CO2.