NTSB investigations, GA
8 cases where NTSB found Runway/land/takeoff/taxi surface.
Cases per year
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2022 | 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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030230'))
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030230')) 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 ERA23LA072Accident · Serious injuriesClass 4 · LimitedFinal reportDaniel Anthony Proctor M24 Orion Plus · Suches, GAThe pilot's decision to take off from the runway midpoint with a tailwind, which resulted in impact with terrain.NTSB GAA17CA535Accident · No injuriesData collectionFinal reportMooney M20J · Whitesburg, GAThe pilot’s unstabilized approach while landing with a tailwind and his subsequent failure to go around, which resulted in a hard landing.NTSB ERA17CA157Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Kingsland, GAThe pilot's improper landing flare, which resulted in a hard landing and subsequent nose-over.NTSB GAA16CA240Accident · No injuriesData collectionFinal reportMills Gregory T AIR Commander LRT · Tybee Island, GAThe pilot's decision to perform a touch-and-go on unsuitable terrain, which resulted in a loss of directional control and a rollover.NTSB ERA16LA120Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Atlanta, GAA total loss of engine power due to fuel vapor lock. Contributing to the accident was the absence of a fuel return line.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.NTSB ERA12FA567Accident · Minor injuriesField investigationFinal reportBeech 400 · Macon, GAThe pilot’s failure to maintain proper airspeed, which resulted in the airplane touching down too fast on the wet runway with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the landing overrun were the flight crewmembers’…NTSB ERA10CA447Accident · No injuriesData collectionFinal reportCessna T206H · Clayton, GAThe pilot's improper touchdown point while landing on the wet grass.