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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC09CA006Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Skwentna, AKThe pilot's selection of unsuitable terrain for landing.NTSB 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.NTSB ANC08CA041Accident · No injuriesData collectionFinal reportCessna 185 · Takotna, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB CHI08CA088Accident · No injuriesData collectionFinal reportShaffer KR-2 · Fremont, OHThe loss of engine power for undetermined reasons during takeoff.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.