NTSB investigations, 2015, IL
5 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 5 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 6 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 5 |
| 2024 | 2 |
| 2025 | 3 |
| 2026 | 1 |
Where
Open the mapLatest 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\") = 2015
AND c.\"eventStateOrRegion\" = 'IL' 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") = 2015 AND c."eventStateOrRegion" = 'IL' 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 GAA16LA086Accident · No injuriesLimited investigationFinal reportHawker Beechcraft 390 · Wheeling, ILThe pilots' decision to conduct an approach and landing in gusting wind conditions, and their failure to maintain control of the airplane during the first approach, which resulted in a wing strike.NTSB CEN15LA411Accident · No injuriesLimited investigationFinal reportBrown Mark Space Walker · Cahokia, ILThe pilot's failure to maintain a proper descent rate during the attempted landing and the flight instructor's delayed attempt to execute a go-around, which resulted in a hard landing, failure of the left main landing gear, and subsequent loss of directional…NTSB GAA15CA129Accident · No injuriesData collectionFinal reportLancair ES - NO Series · Hampshire, ILThe failure of the brake master cylinder which resulted in a loss of brake pressure and the subsequent loss of directional control during the landing roll.NTSB CEN15CA151Accident · No injuriesData collectionFinal reportCessna 172P · Kankakee, ILThe student pilot's improper flight control inputs resulting in the loss of control during the landing flare.NTSB CEN15LA147Accident · No injuriesLimited investigationFinal reportPiper PA 31-350 · Chicago, ILThe collapse of the nose and right main landing gears during landing for reasons that could not be determined because examination of the landing gear system revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.