A father of two was blinded in one eye by an explosion at his North Yorkshire home after a bungled repair to a gas fire.