NTSB investigations, 2010, KS
5 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 1 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 5 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 5 |
| 2023 | 1 |
| 2024 | 3 |
| 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\") = 2010
AND c.\"eventStateOrRegion\" = 'KS' 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") = 2010 AND c."eventStateOrRegion" = 'KS' 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 CEN11LA012Accident · 1 fatalLimited investigationFinal reportNewmann Edward W Challenger II · Easton, KSThe pilot’s failure to maintain control of the airplane for undetermined reasons.NTSB CEN10CA479Accident · No injuriesData collectionFinal reportBeech A23-19 · Wichita, KSThe pilot’s loss of airplane control while landing with a gusting wind.NTSB CEN10FA364Accident · 2 fatalField investigationFinal reportBeech F33A · Perry, KSThe failure of the engine driven fuel pump causing a loss of engine power and the pilot's failure to maintain aircraft control resulting in an inadvertent stall. Contributing to the accident was the pilot’s failure to follow the emergency procedures checklist…NTSB CEN10CA212Accident · No injuriesData collectionFinal reportCessna 172M · Coldwater, KSThe pilot's failure to compensate for gusting crosswinds resultuing in the loss of directional control while landing.NTSB CEN10LA099Accident · 2 fatalLimited investigationFinal reportBuckeye DM · Sublette, KSThe failure of both pilots to see and avoid the other aircraft, which resulted in a midair collision while maneuvering at low altitude.