NTSB investigations, 2013, KS
5 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 6 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 2 |
| 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\" = '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\" = '300' 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" = '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" = '300' 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 CEN14LA008Accident · No injuriesLimited investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Wichita, KSThe pilot’s improper brake application during landing, which resulted in a loss of directional control.NTSB CEN13CA453Accident · No injuriesData collectionFinal reportLuscombe 8A · Ellinwood, KSThe pilot failed to maintain directional control during takeoff.NTSB CEN13CA411Accident · No injuriesData collectionFinal reportLuscombe 8 · Rose Hill, KSThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.NTSB CEN13CA279Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Meriden, KSThe pilot electing to land at an airport with a runway environment that precluded a go-around with the tailwind weather conditions present which resulted in a runway excursion during the landing.NTSB CEN13LA188Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Olathe, KSThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion.