NTSB investigations

219 cases where NTSB found Snow/slush/ice covered surface.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023015'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ERA09LA282Accident · No injuriesLimited investigationFinal reportDassault/Sud FAN JET · Jamestown, NYThe inability to stop the airplane on the remaining runway because of icy runway conditions. A factor was the failure of the drag chute to properly deploy.Dec 21, 2008 · N165TW · Substantial damageNTSB CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.Dec 17, 2008 · N845D · Substantial damageNTSB CEN09LA093Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-50 · Madison, WIThe collision between the tug and the airplane during towing as a result of sliding on the snow covered runway.Dec 3, 2008 · N782NC · Substantial damageNTSB ANC09CA010Accident · No injuriesData collectionFinal reportCessna 172M · Girdwood, AKThe pilot's decision to attempt to take off on a snow-covered runway. Contributing to the accident was the snow-covered runway.Nov 8, 2008 · N9099H · Substantial damageNTSB ANC09CA006Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Skwentna, AKThe pilot's selection of unsuitable terrain for landing.Oct 17, 2008 · N57446 · Substantial damageNTSB ANC08CA065Accident · No injuriesData collectionFinal reportde Havilland DHC-3 · Talkeetna, AKThe pilot's selection of an unsuitable landing site, which resulted in an overload failure of the tail ski assembly during the landing roll.Apr 28, 2008 · N565TA · Substantial damageNTSB ANC08CA041Accident · No injuriesData collectionFinal reportCessna 185 · Takotna, AKThe pilot's selection of unsuitable terrain for takeoff.Mar 5, 2008 · N1224F · Substantial damageNTSB CHI08CA088Accident · No injuriesData collectionFinal reportShaffer KR-2 · Fremont, OHThe loss of engine power for undetermined reasons during takeoff.Feb 24, 2008 · N455JS · Substantial damageNTSB SEA08LA082Accident · Serious injuriesLimited investigationFinal reportRaytheon 1900D · Kayenta, AZThe flight crew's failure to execute a missed approach, which resulted in a runway excursion after landing. Contributing to the accident were the inoperative lights, weather conditions below published approach minimums, and the slush contaminated runway.Feb 22, 2008 · N305PC · Substantial damageNTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.Feb 15, 2008 · N3047Q · Substantial damageNTSB NYC08LA099Accident · No injuriesLimited investigationFinal reportBeechcraft 390 · Leesburg, VAThe airplane's runway excursion during landing roll following an encounter with ice. Contributing to the accident was the ice-covered runway, and the airport personnel's lack of knowledge regarding the runway condition.Feb 13, 2008 · N16DK · Substantial damageNTSB CHI08CA081Accident · No injuriesData collectionFinal reportCessna 425 · Cahokia, ILThe pilot not maintaining clearance from the runway sign during taxi for takeoff. A factor contributing to the accident was an icy taxiway.Feb 13, 2008 · N67726 · Substantial damageNTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.Feb 6, 2008 · N9483L · Substantial damageNTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.Feb 5, 2008 · N120SC · Substantial damageNTSB SEA08LA069Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Parowan, UTThe pilot's improper in-flight decision not to over fly/inspect the snow covered runway prior to landing, and his failure to align the airplane over the centerline of the runway. Contributing to the accident was the snow covered runway, the airport operator's…Feb 4, 2008 · N73BL · Substantial damageNTSB LAX08CA053Accident · Minor injuriesData collectionFinal reportCessna 172N · Beaver Marsh, ORThe pilot's inadequate in-flight planning/decision to land on a snow covered runway without first determining the depth of the snow.Jan 25, 2008 · N734KU · Substantial damageNTSB CHI08CA069Accident · No injuriesData collectionFinal reportCessna 172N · South St. Paul, MNThe student pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident were the snow-covered runway and the gusty wind conditions.Jan 22, 2008 · N738UE · Substantial damageNTSB ANC08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's selection of unsuitable terrain for landing. Contributing to the accident were snow-covered terrain, blowing snow and flat lighting conditions.Jan 15, 2008 · N454SF · Substantial damageNTSB MIA08CA037Accident · No injuriesData collectionFinal reportCessna 170A · Ellsworth, METhe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's selection of an unsuitable landing area.Jan 6, 2008 · N5407C · Substantial damage