A skydiver whose parachute collapsed as he was photographing skydiving tandems died after crashing through a house roof in Texas.