NTSB investigations, 2015, GA
7 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 5 |
| 2010 | 8 |
| 2011 | 4 |
| 2012 | 8 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 7 |
| 2016 | 8 |
| 2017 | 9 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 9 |
| 2021 | 10 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 8 |
| 2025 | 2 |
| 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\" = 'GA' 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" = 'GA' 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 GAA15CA216Accident · No injuriesData collectionFinal reportCessna 150M · Ellijay, GAThe pilot's failure to attain and maintain sufficient airspeed during takeoff which resulted in a descent, loss of directional control, and a runway excursion.NTSB ERA15LA270Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Climax, GAA loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.NTSB GAA15CA071Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe pilot's failure to maintain pitch control during the landing. Contributing to this accident was the pilot's lack of experience with the airplane's performance characteristics during the approach resulting in a hard landing and runway excursion.NTSB GAA15CA047Accident · Minor injuriesData collectionFinal reportPiper PA 16 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA15CA040Accident · No injuriesData collectionFinal reportTrom Wayne Vans RV6A · LaFayette, GAThe pilot's failure to maintain directional control during the landing roll in variable, gusting wind conditions, resulting in a runway excursion, and substantial damage to the airplane.NTSB GAA15CA070Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Cornelia, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB ERA15LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Woodstock, GAThe pilot's failure to attain the proper touchdown point on the short, wet, turf runway. Contributing to the accident was the pilot’s use of a high approach speed.