NTSB investigations, 2016, GA
8 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\") = 2016
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") = 2016 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 GAA17CA085Accident · No injuriesData collectionFinal reportHundley Michael J Vans RV8 · Roopville, GAThe pilot’s overcorrection with the right rudder during the landing roll, which resulted in a loss of directional control and a runway excursion.NTSB ERA17CA047Accident · No injuriesData collectionFinal reportHawker Beechcraft G58 · Atlanta, GAThe pilot’s failure to maintain the proper airspeed during final approach and his subsequent loss of directional control during landing, which resulted in a runway excursion.NTSB ERA16CA294Accident · No injuriesData collectionFinal reportCessna 152 · Newnan, GAThe student pilot's improper decision to land long and maintain excessive speed during the landing roll. Contributing to the accident was the student pilot's decision to maintain full flaps and aft yoke inputs at a higher speed, reducing his ability to stop…NTSB GAA16CA295Accident · No injuriesData collectionFinal reportCessna 172 · Thomson, GAThe student pilot's incorrect landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing, nose wheel collapse, and runway excursion.NTSB GAA16CA254Accident · No injuriesData collectionFinal reportBeech A36 · Griffin, GAThe pilot's decision to land with a tailwind, resulting in a runway overrun and collision with a highway road embankment.NTSB GAA16CA222Accident · No injuriesData collectionFinal reportPiper PA32RT · Gainesville, GAThe pilot's failure to maintain an appropriate descent rate during the landing flare in gusty crosswind conditions, which resulted in a hard landing, left main landing gear collapse, and runway excursion.NTSB GAA16CA169Accident · Minor injuriesData collectionFinal reportAmerican Legend AL3 · Monticello, GAThe pilot's decision to land with a quartering tail wind, and failure to maintain directional control during the landing roll, which resulted in runway excursion, and collision with a tree.NTSB ERA16LA131Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Rome, GAThe pilots’ failure to use available sources of wind information before landing and recognize cues indicating the presence of the tailwind and conduct a go-around, which resulted in their landing with a significant tailwind and a subsequent runway overrun.