"He was a legendary musician, but his favorite accomplishment was being a husband and father. His biggest dreams came true," his band and wife wrote in a joint statement.