NTSB investigations, 2020, OK
5 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 2 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 8 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 5 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 5 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 1 |
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\") = 2020
AND c.\"eventStateOrRegion\" = 'OK' 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") = 2020 AND c."eventStateOrRegion" = 'OK' 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 CEN20LA266Accident · Serious injuriesClass 3 · LimitedFinal reportLancair ES-P · Pauls Valley, OKThe reason for this accident could not be determined based on the available information.NTSB CEN20CA229Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna T188 · McCurtain, OKThe pilot's failure to maintain the proper airspeed during a low altitude aerial application maneuver and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodymanic stall at too low of an altiutde to recover.NTSB CEN20CA226Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 17 30 · Talihina, OKThe pilot's failure to maintain control of the airplane during a crosswind landing, which resulted in a hard landing and runway excursion.NTSB CEN20LA173Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Titan Tornado S · Haskell, OKThe student pilot/builder’s addition of winglets to the stabilator, which resulted in flutter and overstress failure of the stabilator control horn.NTSB CEN20CA152Accident · No injuriesData collectionFinal reportCessna 172 · Enid, OKThe flight instructor's delayed remedial action during a power-off approach and go-around in gusting wind conditions, which resulted in a hard landing, loss of directional control, and a runway excursion onto a field.