NTSB investigations, 2008, KS
9 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 5 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 5 |
| 2017 | 3 |
| 2018 | 7 |
| 2019 | 1 |
| 2021 | 5 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 1 |
| 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\") = 2008
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\" = '440' 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") = 2008 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" = '440' 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 CEN09CA064Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Stafford, KSA loss of engine power for undetermined reasons.NTSB CEN09CA038Accident · No injuriesData collectionFinal reportBeech A36 · Salina, KSThe pilot's failure to properly manage the available fuel supply, which resulted in fuel starvation and subsequent loss of engine power.NTSB CEN09CA007Accident · No injuriesData collectionFinal reportLet Blanik · Gardner, KSThe pilot's decision to attempt a takeoff when the climb performance of the tow plane and the glider were inadequate. Contributing to the accident were the high density altitude and the terrain-induced turbulence.NTSB DFW08LA169Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olathe, KSA loss of engine power for undetermined reasons.NTSB DEN08LA108Accident · No injuriesLimited investigationFinal reportMercer Avid Flyer Mk IV · Augusta, KSFailure of the engine cooling system's thermostat, causing the engine to overheat and seize. Contributing to the accident was the fence.NTSB DEN08LA103Accident · No injuriesLimited investigationFinal reportCessna A188B · Lyons, KSthe loss of engine power for undetermined reasons. A contributing factor was the dirt embankment.NTSB DFW08LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Emporia, KSA total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.NTSB DFW08LA095Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G36 · El Dorado, KSThe improper installation of the fuel manifold valve's brass plug. Contributing to the accident was the unsuitable landing area for the forced landing.NTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.