NTSB investigations, 2014
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
Latest 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\") = 2014
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") = 2014 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 ERA15CA079Accident · No injuriesData collectionFinal reportRobinson Helicopter R66 · Henniker, NHThe pilot's failure to maintain aircraft control while landing, which resulted in a collision with a snow bank. Contributing to the accident was ice that covered the landing surface.NTSB CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.NTSB ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.NTSB ANC14CA021Accident · No injuriesData collectionFinal reportCessna 180 · North Pole, AKThe pilot's failure to maintain directional control of the airplane while taxiing on a snow covered runway, which resulted in a collision with a terrain.NTSB CEN14CA158Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Chisago City, MNThe unsuitable landing area encountered by the pilot due to wet soft snow conditions that resulted in a nose over.NTSB ANC14CA017Accident · Minor injuriesData collectionFinal reportSilvaire Luscombe 8E · Alegnagik, AKThe pilot's failure to determine that the ice that he was taxiing on was safe for operation.NTSB CEN14LA146Accident · No injuriesLimited investigationFinal reportFogg Quicksilver MX II · Holland, MIThe pilot's inability to maintain airplane control after inadvertently landing in an area of deep snow on a frozen lake.NTSB CEN14CA132Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Hartford, WIThe pilot's inadequate preflight planning and failure to inspect the runway before departure.NTSB WPR14LA113Accident · No injuriesLimited investigationFinal reportBell 206 · Bountiful, UTThe pilots' inaccurate assessment of the snow depth on the landing zone, which resulted in a landing on snow deeper than that for which the helicopter was equipped and led to dynamic rollover.NTSB CEN14CA114Accident · No injuriesData collectionFinal reportCessna 340 · Coldwater, MIAirport personnel did not remove the snow banks from the intersecting runway and/or close the intersection runway, which resulted in the airplane impacting the snow banks. Contributing to the accident was the reduced visibility inhibiting the pilot's ability…