NTSB investigations, 2014, MT
5 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 5 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 2 |
| 2013 | 7 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 2 |
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.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR15FA049Accident · 1 fatalField investigationFinal reportCessna 170B · Alzada, MTThe pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.NTSB WPR15LA036Accident · Serious injuriesLimited investigationFinal reportChampion 7AC · Darby, MTThe pilot's failure to maintain airspeed while maneuvering in gusting wind conditions, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB WPR14FA231Accident · 1 fatalField investigationFinal reportGrumman G 21A · Sula, MTThe pilot's decision to continue flight into deteriorating weather conditions in an airplane not maintained for instrument flight, which resulted in a loss of control due to spatial disorientation.NTSB WPR14LA233Accident · 1 fatalLimited investigationFinal reportNorth Wing Apache Sport · Polson, MTThe pilot’s loss of airplane control during initial climb due to his experiencing an incapacitating medical event.NTSB WPR14LA198Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Medicine Lake, MTThe pilot’s failure to maintain airplane control and sufficient altitude to clear terrain during a low-altitude maneuver.