NTSB investigations, 2016
10 cases where NTSB found Snow/slush/ice covered surface.
Cases per year
| 2008 | 22 |
|---|---|
| 2009 | 12 |
| 2010 | 17 |
| 2011 | 15 |
| 2012 | 17 |
| 2013 | 13 |
| 2014 | 10 |
| 2015 | 4 |
| 2016 | 10 |
| 2017 | 13 |
| 2018 | 9 |
| 2019 | 15 |
| 2020 | 13 |
| 2021 | 12 |
| 2022 | 12 |
| 2023 | 10 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 7 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2016
AND 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 year(c."eventDate") = 2016 AND 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 GAA17CA106Accident · Minor injuriesData collectionFinal reportMaule M7 · Palouse, WAThe pilot’s failure to maintain directional control on an ice- and snow-covered runway during taxi with a crosswind, which resulted in a runway excursion.NTSB GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.NTSB GAA17CA101Accident · No injuriesData collectionFinal reportMaule MX 7 · Willow, AKThe pilot’s failure to ensure that the runway was clear of any obstacles before departure, which resulted in the airplane impacting a snowdrift.NTSB GAA16CA516Accident · No injuriesData collectionFinal reportPiper PA 18 · Kotzebue, AKThe pilot’s selection of unsuitable terrain for an off-airport precautionary landing, which resulted in a nose-over.NTSB ANC16LA071Accident · No injuriesLimited investigationFinal reportHelio H-295 · Delta Junction, AKThe pilot’s decision to take off from a wet, snowy airstrip and his delayed decision to abort the takeoff, which resulted in a runway excursion.NTSB GAA16CA191Accident · No injuriesData collectionFinal reportBeech C23 · Frenchville, METhe pilot's failure to maintain directional control during the takeoff roll on a runway contaminated with ice and snow, which resulted in a runway excursion and an impact with a snowbank.NTSB ANC16CA014Accident · No injuriesData collectionFinal reportCessna 180 · Sleetmute, AKThe pilot's decision to make contact with an unsuitable landing surface, resulting in a nose over.NTSB GAA16CA120Accident · Minor injuriesData collectionFinal reportCessna 210 · Park Valley, UTThe pilot's decision to drag the left main landing gear on a snow covered dry lake bed, which resulted in a loss of directional control and a nose over during an aborted landing.NTSB DCA16CA070Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Newark, NJthe ground crew's misjudgment of the distance between the B767 wingtip and the MD-88 tail. Contributing to the accident was the slushy condition of the ramp which limited the maneuvering space available.NTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.