NTSB investigations, 2020, GA
9 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
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\") = 2020
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") = 2020 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 ERA21LA090Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Locust Grove, GAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.NTSB ERA21LA039Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA40 · Winder, GAThe pilot's loss of directional control while landing, which resulted in a runway excursion.NTSB ERA21LA037Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Warrenton, GAThe pilot’s failure to attain the proper touchdown point which resulted in a runway overrun and collision with trees.NTSB ERA21LA038Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA22 · Warner Robins, GAThe pilot’s improper compensation for shifting wind conditions, which resulted in a runway excursion and a subsequent nose over.NTSB ERA21LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Atlanta, GAA partial loss of engine power during takeoff due to a right magneto anomaly, which resulted in the pilot’s decision to abort the takeoff and the subsequent runway excursion.NTSB ERA20LA311Accident · No injuriesClass 4 · LimitedFinal reportZenith CH650LS · Villa Rica, GAA loss of directional control during the landing roll.NTSB ERA20LA308Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA 1 · Newnan, GAThe flight instructor’s inadequate preflight fuel planning, which resulted in an interruption of the fuel supply to the engine and a subsequent a total loss of engine power due.NTSB ERA20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV8 · Hampton, GAA right main landing gear break malfunction during landing. Contributing to the accident was a worn right main landing gear caliper pin and pressure plate hole.NTSB ERA20CA112Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 58 · Augusta, GAThe pilot's failure to land and stop the airplane within the available runway, which resulted in a runway overrun. Contributing to the outcome was the pilot's inadvertent feathering of both propellers during approach to landing.