NTSB investigations, 2013, MT
7 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\") = 2013
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") = 2013 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 WPR14CA067Accident · Serious injuriesData collectionFinal reportBeech 58P · Kalispell, MTThe pilot's failure to maintain airplane control during the landing sequence.NTSB WPR13FA368Accident · 1 fatalField investigationFinal reportBeech E35 · West Yellowstone, MTThe pilot's failure to maintain airplane control while aligning the airplane with the runway for landing, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's…NTSB WPR13FA343Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Thompson Falls, MTThe pilot's failure to maintain helicopter control while operating in conditions conducive to a loss of tail rotor effectiveness.NTSB WPR13CA325Accident · No injuriesData collectionFinal reportBoeing E75 · Bozeman, MTThe pilot’s failure to maintain adequate airspeed during a turn, which resulted in a loss of lift and collision with terrain.NTSB WPR13LA303Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Missoula, MTThe pilot's failure to prevent the helicopter from settling with power and to maintain proper position relative to an external load, which resulted in a loss of control and subsequent hard landing.NTSB WPR13FA183Accident · 1 fatalField investigationFinal reportCessna 182C · Circle, MTThe pilot’s failure to maintain airplane control as a result of spatial disorientation. Contributing to the accident was the pilot’s decision to continue flight into low visibility conditions.NTSB WPR13CA117Accident · No injuriesData collectionFinal reportCessna 170B · Sunburst, MTThe pilot's failure to compensate for the strong, gusting wind conditions, which resulted in a loss of airplane control during takeoff.