Dana Carvey shared a statement about his son’s demise on Friday via X (formerly Twitter) and expressed his grief