NTSB investigations, GA
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 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 ERA25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Jefferson, GAThe airplane’s collision with a deer on the runway during landing.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 ERA25LA070Accident · Serious injuriesClass 4 · LimitedFinal reportWilliam M Clapp CLAPP-SABERWING · Valdosta, GAA hard landing and subsequent gear collapse due to the pilot’s failure to securely close the airplane canopy and its subsequent opening on short final.NTSB ERA25LA064Accident · Serious injuriesClass 3 · LimitedFinal reportAMS Flight D O O Carat A · Centralhatchee, GAMaintenance personnel’s failure to comply with the engine manufacturer’s guidance, which resulted in improper valvetrain clearances, unseating of the intake valve keepers, and a total loss of engine power.NTSB ERA25LA055Accident · No injuriesClass 4 · LimitedFinal reportBrunner-Winkle Bird A · Senoia, GAThe pilot’s improper flare, which resulted in a hard landing, and landing gear collapse.NTSB ERA25LA042Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV8-A · Cleveland, GAA nose landing gear collapse on landing and subsequent nose over.NTSB ERA25LA067Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Ball Ground, GAThe pilot and the flight instructor’s failure to maintain control of the airplane during a simulated loss of engine power during takeoff, which resulted in a runway excursion, and collision with a taxiway sign.NTSB ERA25LA040Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 369D · Waycross, GAAn encounter with a foreign object, which resulted in a loss of control and collision with terrain.NTSB ERA25LA019Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Gainesville, GAThe pilot’s sudden incapacitation due to an in-flight cardiac arrest, which necessitated a landing by a non-pilot passenger and resulted in a hard landing and collapse of the nose landing gear.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 · FieldPreliminary reportCessna 336 · Savannah, GAOn October 13, 2024, about 2230 eastern daylight time, a Cessna 336, N336LV, was destroyed when it was involved in an accident near Savannah, Georgia. The commercial pilot was fatally injured, and a pilot-rated passenger sustained minor injuries. The flight…NTSB ERA25LA010Accident · No injuriesClass 4 · LimitedFinal reportDitsler Paul A Dakota Hawk · Nicklesville, GAThe pilot’s inadequate preflight inspection, fuel planning, and improper fuel management during flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport hard landing.NTSB OPS24LA045Incident · No injuriesClass 4 · LimitedFinal reportCessna 525 · Brunswick, GAThe flight crew’s failure to properly identify the airport and runway of intended landing, and the lack of verification of their airplane’s position using all available navigation information.NTSB ERA24LA392Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · LaGrange, GAImproper manufacture of a cylinder exhaust valve guide by the engine manufacturer, which resulted in a stuck exhaust valve and a partial loss of engine power during initial climb.NTSB DCA24FA299Accident · Minor injuriesClass 3 · FieldPreliminary reportAirbus A350-941 · College Park, GAOn September 10, 2024, about 1007 eastern daylight time, Delta Air Lines flight 295, an Airbus A350-941, N503DN, collided with Endeavor Air flight 5526 (dba Delta Air Lines), a Mitsubishi Heavy Industries (MHI) CRJ-900, N302PQ, while taxiing for departure at…NTSB ERA24LA373Accident · Minor injuriesClass 4 · LimitedFinal reportRaytheon 58 · Griffin, GAThe pilot’s failure to conduct a timely aborted landing, which resulted in a runway overrun.NTSB ERA24FA365Accident · 2 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5 · Rockmart, GAA total loss of engine power for undetermined reasons. Also causal was the flight instructor’s failure to maintain adequate airspeed during the forced landing attempt, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic…NTSB DCA24LA295Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330-323 · Atlanta, GADelta Air Lines flight crew’s incorrect evaluation of the clearance between their airplane and the airplane directly ahead of them as they made a 90 degree right turn onto an adjacent taxiway.NTSB ERA24LA360Accident · No injuriesClass 4 · LimitedFinal reportBeech B100 · Jesup, GAA hard landing short of the runway threshold, which resulted in a collapse of the left main landing gear and subsequent runway excursion during landing.NTSB DCA24LA255Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · Waycross, GAThe aircraft’s encounter with convectively induced turbulence.NTSB ERA24LA331Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander 200 · Valdosta, GAAn insect nest in the right main fuel tank’s vent line, which resulted in an inaccurate fuel level reading, fuel starvation, and a total loss of engine power.NTSB ERA24LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Cochran, GAThe airplane’s impact with a bird resulting in substantial damage to the right wing.NTSB ERA24LA303Accident · No injuriesClass 3 · LimitedFinal reportJones LONG-EZ · Thomasville, GAThe pilot reported that he was maneuvering around weather at 11,500 ft mean sea level (msl) when he made a rapid descent to 3,500 ft msl to remain clear of clouds. He reported that he did not exceed the airplane’s maneuvering speed during the descent, and…NTSB ERA24LA297Accident · 1 fatalClass 4 · LimitedFinal reportBuckeye Dream Machine · Bainbridge, GAThe non-certificated pilot’s failure to maintain adequate clearance from powerlines while maneuvering at low altitude. Contributing to the accident was the pilot’s impairment due to alcohol and methamphetamine use.NTSB ERA24LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Toccoa, GAThe pilot’s failure to set the engine speed control fully forward during takeoff, resulting in an engine surge and subsequent loss of control during landing.NTSB ERA24LA298Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC1B · Peachtree City, GAA right main landing gear collapse during landing.NTSB ERA24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportGarlick Helicopters OH-58A+ · Cisco, GAA reported total loss of engine power for reasons that could not be determined.NTSB ERA24FA266Accident · Serious injuriesClass 3 · FieldFinal reportLockheed 12 · Jackson, GAMaintenance personnel’s failure to properly secure the right brake line, which resulted in a loss of right brake effectiveness during the landing roll and a subsequent runway excursion.NTSB ERA24LA258Accident · Serious injuriesClass 3 · LimitedFinal reportClapp Saberwing · Valdosta, GAThe total loss of engine power due to the shearing of the woodruff key that indexed the crankshaft gear and hub assembly to the crankshaft, which resulted in the gear and hub rotating from their indexed position and caused the crankshaft-to-camshaft timing to…NTSB ERA24LA251Accident · Minor injuriesClass 4 · LimitedFinal reportWilliam Loren Noggle JA30 Superstol · Tennille, GAThe loss of elevator control during flight due to the elevator control rod and its hardware disconnecting from its installation area, which resulted in an uncontrolled descent into trees and terrain. Contributing to the accident was the pilot’s inadequate…NTSB ERA24LA248Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Colquitt, GAThe failure of the fuel shutoff valve from corrosion, which allowed the valve stem to obstruct the internal fuel port, resulting in a restriction of fuel flow to the engine.NTSB ERA24FA221Accident · 1 fatalClass 3 · FieldFinal reportRadley Vincent Quicksilver Sport 2S · Cleveland, GAThe pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…NTSB ERA24FA206Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · Augusta, GAThe pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.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 ERA24LA158Accident · Serious injuriesClass 3 · LimitedFinal reportJmmt Vans RV9A · Jasper, GAThe total loss of engine power due to fuel starvation for reasons that could not be determined due to impact-related damage.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 ERA24LA143Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Blackshear, GAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power.NTSB ERA24LA141Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Winokur, GAA total loss of engine power due to the unseating and subsequent failure of the No. 4 piston connection rod bushing.NTSB ERA24LA226Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Griffin, GAThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB ERA24LA125Accident · No injuriesClass 4 · LimitedFinal reportWaco UPF-7 · Atlanta, GAThe pilot’s failure to maintain directional control during the landing in gusting crosswind conditions.NTSB ERA24LA099Accident · No injuriesClass 3 · LimitedFinal reportSwissdrones Operating SDO 50 V2 · Antioch, GAA partial loss of engine power due to a reduction of fuel flow for undetermined reasons. Contributing to the accident was the UAS manufacturer’s lack of instructions for a partial loss of engine power landing.NTSB ERA24FA072Accident · 1 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Buford, GAA loss of engine power for reasons that could not be determined due to significant thermal damage from postimpact fire.NTSB ERA24LA085Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Griffin, GAThe pilot’s misidentification of a taxiway as the intended runway, which resulted in a collision with a utility pole and trees.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 ERA24LA056Accident · No injuriesClass 3 · LimitedFinal reportRaytheon 400A · Atlanta, GAThe collapse of the airplane’s left main landing gear during the landing roll for undetermined reasons.NTSB ERA24LA049Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Valdosta, GAThe pilot’s failure to extend the landing gear before landing.NTSB ERA24LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Atlanta, GAThe flight instructor’s inadequate remedial action and the student pilot’s failure to relinquish the flight controls as directed by the flight instructor, resulting in a loss of control and nose over.