NTSB investigations, GA
130 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 8 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 8 |
| 2013 | 7 |
| 2014 | 8 |
| 2015 | 4 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 9 |
| 2019 | 6 |
| 2020 | 8 |
| 2021 | 10 |
| 2022 | 5 |
| 2023 | 9 |
| 2024 | 9 |
| 2025 | 2 |
| 2026 | 2 |
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\", '0303'))
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", '0303')) 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 ERA26LA272Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Hartwell, GAThe pilot’s failure to compensate for the gusty and variable wind conditions, which resulted in a loss of control and collision with trees during takeoff.NTSB DCA26LA139Incident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C10 · College Park, GAThe captain’s inadequate compensation for gusting crosswind wind conditions while attempting to land and a subsequent go-around.NTSB DCA25LA269Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer-Empresa Brasileira De ERJ 170-200 LR · Jacksonville, GAThe airplane’s encounter with unanticipated moderate turbulence.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 ERA25LA085Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · Loganville, GAThe pilot’s failure to maintain clearance of trees during an attempted go-around in sun glare.NTSB ERA25LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Atlanta, GAThe vehicle driver’s inadequate visual lookout while driving on a non-licensed vehicle roadway in restricted visibility conditions, which resulted in a collision with a taxiing airplane.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 ERA25LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Newnan, GAThe pilot’s inadequate use of carburetor heat during the engine run-up, which resulted in a partial loss of power due to carburetor icing during takeoff.NTSB ERA25FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 336 · Savannah, GAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power to both engines.NTSB DCA24LA255Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Waycross, GAThe aircraft’s encounter with convectively induced turbulence.NTSB DCA24LA174Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757 · Hogansville, GAAn encounter with convectively induced turbulence during descent.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 DCA24LA135Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-232 · Lakeland, GAAn inadvertent encounter with convective turbulence that resulted in a serious injury to a flight attendant.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 ERA23LA376Accident · No injuriesClass 2 · LimitedFinal reportEmbraer S A EMB-545 · St. Simons Island, GAThe control laws of the angle of attack limiter protection system, which precluded the system from disengaging during an approach in gusting wind conditions, limiting the flight crew’s ability to control the airplane’s pitch and resulting in a hard landing.NTSB ERA23FA370Accident · 1 fatalClass 3 · FieldFinal reportErcoupe 415 · Fitzgerald, GAThe pilot’s failure to perform pre-takeoff engine runup and carburetor heat check procedures, which resulted in rotation with inadequate climb performance, and his subsequent failure to maintain adequate airspeed and exceedance of the airplane’s critical…NTSB DCA23FA428Accident · Serious injuriesClass 3 · FieldFinal reportAirbus A350-941 · Atlanta, GAThe flight crew’s unintentional encounter with rapidly developing cumulus clouds which resulted in an encounter with severe convectively induced turbulence.NTSB ERA23FA330Accident · 1 fatalClass 3 · FieldFinal reportCessna P210 · Junction City, GAThe pilot’s continued flight into a known area of adverse weather, which resulted in the penetration of a severe thunderstorm, the pilot’s loss of airplane control, and the airplane’s subsequent in-flight breakup.NTSB ERA23LA268Accident · Minor injuriesClass 3 · LimitedFinal reportJabiru J250 · Louisville, GAThe pilot’s decision to take off in wind conditions that exceeded his ability to maintain directional control, resulting in a runway excursion and substantial damage to the airplane.NTSB ERA23FA182Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Jesup, GAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control while maneuvering for a visual landing in low ceiling and low visibility conditions. Contributing to the…NTSB ERA23LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Atlanta, GAThe flight instructor’s failure to effectively utilize carburetor heat, which resulted in a total loss of engine power during initial climb due to carburetor ice that formed during the engine run-up and taxi.NTSB ERA23FA109Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Dawsonville, GAThe pilot’s decision to initiate a visual flight rules flight into night instrument meteorological conditions, resulting in a loss of control in-flight due to spatial disorientation. Contributing to the accident was the pilot’s lack of qualifications and…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 ERA23LA062Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Perry, GAThe pilot’s failure to maintain directional control during touchdown in a crosswind, which resulted in a runway excursion.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB ERA22LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Lawrenceville, GAThe student pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA22LA182Accident · Minor injuriesClass 3 · LimitedFinal reportAmerican AA-1 · Kennesaw, GAA loss of engine power due to the formation of carburetor ice.NTSB ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB ERA22LA031Accident · 1 fatalClass 3 · LimitedFinal reportVans RV-12 · Folkston, GAThe pilot’s low altitude maneuvering, which resulted in a collision with a utility pole.NTSB ERA22FA014Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-260 · Blairsville, GAThe pilot’s decision to commence the flight in low IFR weather conditions, and making immediate turns after takeoff in IMC, resulting in spatial disorientation and a loss of airplane control.NTSB ERA22FA004Accident · 2 fatalClass 3 · FieldFinal reportDassault Falcon 20 · Thomson, GAThe flight crew’s continuation of an unstable dark night visual approach and the captain’s instruction to use air brakes during the approach contrary to airplane operating limitations, which resulted in a descent below the glide path, and a collision with…NTSB ERA21FA362Accident · 3 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Monticello, GAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions during a dark night and over unlit terrain, which resulted in spatial disorientation and a subsequent loss of helicopter control.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 ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.NTSB ERA21LA158Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Hampton, GAThe student pilot’s improper flare while landing with a gusting crosswind which resulted in a hard landing and separation of the left landing gear.NTSB ERA21FA140Accident · 3 fatalClass 3 · FieldFinal reportCessna R182 · Gainesville, GAThe pilot’s loss of control due to spatial disorientation. Contributing to the accident was the pilot’s decision to depart into low instrument meteorological conditions.NTSB ERA21LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lawrenceville, GAThe pilot's failure to maintain directional control during landing in a gusting crosswind, which resulted in a loss of control and runway excursion.NTSB ERA21LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cleveland, GAA total loss of engine power due to carburetor icing.NTSB ERA21LA085Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210L · Midway, GAThe pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pressure to complete the flight to work in an emergency room.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 ERA20LA306Accident · Serious injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Hawkinsville, GAThe pilot's failure to maintain clearance from an antenna tower while maneuvering during an agricultural application flight while flying directly toward the sun.NTSB ERA20LA206Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA 31T · Eatonton, GAThe pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…NTSB ERA20CA155Accident · Serious injuriesData collectionFinal reportGrumman AA5 · Bloomingdale, GAThe pilot's failure to maintain airplane control during landing with a gusting quartering tailwind.NTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…NTSB ERA20FA096Accident · 4 fatalClass 3 · FieldFinal reportCessna 501 · Fairmount, GAThe pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…NTSB DCA19CA151Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737-8H4 · Waycross, GAan encounter with convectively induced turbulence while penetrating cumulus clouds during descent.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 GAA19CA191Accident · No injuriesData collectionFinal reportPiper PA32 · Swainsboro, GAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and the landing gear collapsing.