NTSB investigations, GA
14 cases where the sequence of events included Other weather encounter.
Cases per year
| 2010 | 1 |
|---|---|
| 2014 | 1 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' 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 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" = '400' 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 ERA25LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Gainesville, GAThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane while landing in gusty crosswind conditions.NTSB ERA25LA017Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · East Ellijay, GAThe pilot’s inadequate compensation for winds during landing., which resulted in a loss of control and an aerodynamic stall.NTSB ERA24LA183Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Conyers, GAAn encounter with shifting wind conditions, which resulted in the airplane using more runway than anticipated, an aborted takeoff, and subsequent runway excursion. Contributing to the accident was the pilot’s failure account for the potential of variable and…NTSB ERA24LA057Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Social Circle, GAAn encounter with a downdraft while maneuvering at low altitude, which resulted in a collision with a fence.NTSB ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.NTSB ERA20CA155Accident · Serious injuriesData collectionFinal reportGrumman AA5 · Bloomingdale, GAThe pilot's failure to maintain airplane control during landing with a gusting quartering tailwind.NTSB ERA20CA131Accident · No injuriesData collectionFinal reportAmerican Legand AL18 · Social Circle, GAThe pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.NTSB GAA19CA373Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Blairesville, GAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in a hard landing and landing gear collapse.NTSB GAA18CA449Accident · No injuriesData collectionFinal reportCessna 182 · Swainsboro, GAThe pilot's unstabilized approach during the initial landing with a right quartering tailwind, which resulted in a hard landing and subsequent go-around and the collapse of the nose landing gear during the subsequent landing.NTSB GAA16CA483Accident · No injuriesData collectionFinal reportCessna 172 · Covington, GAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.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 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.NTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.NTSB ERA10CA366Accident · No injuriesData collectionFinal reportPiper J-3C · Buckhead, GAAn in-flight encounter with a downdraft during a go-around, resulting in a collision with trees and the ground.