NTSB investigations, GA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 ATL95LA145Accident · No injuriesLimited investigationFinal reportBell 47G2 · Montrose, GAThe pilot's inadequate preflight planning and visual lookout.NTSB ATL95LA141Accident · Minor injuriesLimited investigationFinal reportWheeler Fisher Classic · Marietta, GAimproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power; and the pilot's failure to maintain adequate airspeed, while turning to make a forced landing, which resulted in a stall and impact with the terrain.NTSB ATL95LA125Accident · No injuriesLimited investigationFinal reportLuscombe 8A/E · Williamson, GAThe pilot in command's failure to compensate for wind conditions which resulted in a failure to maintain control of the aircraft when a windshear was encountered.NTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.NTSB ATL95LA108Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Garfield, GAThe pilot's failure to maintain flying speed during a climbout from a swath run which resulted in a stall and the subsequent collision with trees.NTSB ATL95LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Peachtree City, GAThe pilot's failure to maintain an adequate lookout while maneuvering on the ramp which resulted in his misjudging the clearance between his airplane and parked aircraft.NTSB ATL95MA106Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-9-32 · Atlanta, GAfailure of Turk Hava Yollari maintenance and inspection personnel to perform a proper inspection of a 7th stage high compressor disc, thus allowing the detectable crack to grow to a length at which the disc ruptured, under normal operating conditions,…NTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.NTSB ATL95LA095Accident · No injuriesLimited investigationFinal reportKolb Firestar II · Cumming, GAThe pilot/owner's failure to inspect the aircraft, which resulted in a loose spark plug lead. A factor was the rough terrain conditions at the landing area.NTSB ATL95FA088Accident · 1 fatalField investigationFinal reportCessna 172N · Atlanta, GAThe pilot's impairment of judgment and performance due to a drug, VFR flight into instrument meteorological conditions, and failure to remain clear of the obstacle (towering smoke stack). Factors relating to the accident were: the adverse weather conditions.NTSB ATL95FA087Accident · 1 fatalField investigationFinal reportDuke, Clarence E. Lancair 360 · Hampton, GAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's lack of recent flying experience.NTSB ATL95LA086Accident · No injuriesLimited investigationFinal reportCessna 182R · Conyers, GAThe pilot's failure to maintain a proper touchdown point during the landing, and his failure to perform a go around when a long landing was imminent. Factors were the sudden windshift resulting in a tailwind condition, and the downhill landing conditions.NTSB ATL95LA082Accident · No injuriesLimited investigationFinal reportCessna 337G · Savannah, GAThe pilot's improper flare and his improper use of the flight controls during landing which resulted in collapse of the nose gear.NTSB ATL95LA074Accident · No injuriesLimited investigationFinal reportCessna 150 · Canton, GAThe student pilot's failure to maintain directional control during a crosswind landing.NTSB ATL95LA070Accident · No injuriesLimited investigationFinal reportRoggio Rotorway Executive · Toccoa, GAThe pilot's failure to use carburetor heat which resulted in the loss of engine power. A factor was weather conditions favorable for the formation of carburetor ice.NTSB ATL95LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Alma, GAThe aircraft's encounter with unforecast clear air turbulence.NTSB ATL95FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Gainesville, GAThe pilots failure to maintain the minimum descent altitude during the approach. The weather and dark night light condition were factors.NTSB ATL95LA058Accident · No injuriesLimited investigationFinal reportCessna 150L · Jefferson, GAThe loss of engine power because of sticking valves. A factor was the continuous use of an improper fuel grade.NTSB MIA95LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Wrightsville, GAThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in a turn. The low altitude at the time of the stall was a factor.NTSB ATL95LA047Accident · 2 fatalLimited investigationFinal reportBrandt Rutan Longeze · Marietta, GAThe pilot's delayed abort of the ground run which resulted in a runway overrun and collision with the ravine.NTSB ATL95FA046Accident · 1 fatalField investigationFinal reportBeech A36 · Chamblee, GAThe pilot's failure to maintain aircraft control after becoming spatially disoriented. Factors relating to the accident were: the pilot's lack of proficiency (recent experience) in instrument flying, and improper approach control service by vectoring the…NTSB MIA95T#A04Accident · No injuriesClass 3Final reportCessna 180 · Camilla, GANTSB ATL95IA043Incident · No injuriesIncident investigationFinal reportBoeing 737-247 · Atlanta, GAThe inadequate inspection of the aircraft by other maintenance personnel, in that they did not properly diagnose discrepancies in the antiskid braking system.NTSB ATL95FA036Accident · 4 fatalField investigationFinal reportCessna 414 · Augusta, GAThe loss of power on the left engine for undetermined reasons. A factor was the failure of the right engine due to maintenance personnel's failure to properly torque the cylinder through bolts.NTSB ATL95LA035Accident · No injuriesLimited investigationFinal reportCessna 310N · Covington, GAThe pilot's improper fuel management which resulted in fuel starvation and loss of engine power.NTSB ATL95LA030Accident · No injuriesLimited investigationFinal reportCessna 150G · Rhine, GAThe failure of the number two cylinder rocker shaft bosses, which resulted in a loss of engine power, and an eventual emergency landing.NTSB ATL95LA029Accident · No injuriesLimited investigationFinal reportCessna 172F · Carrollton, GAThe pilot's inadvertent collision with trees, adjacent to the taxiway, while attempting to avoid a deer that crossed the taxiway.NTSB ATL95FA023Accident · 1 fatalField investigationFinal reportBeech C23 · Statesboro, GAThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, flight into adverse weather conditions, and failure to maintain proper altitude/clearance from wooded terrain. Factors related to the accident were: darkness and…NTSB ATL95FA021Accident · 1 fatalField investigationFinal reportBeech 95B55 · Mableton, GAThe pilot's inadequate weather evaluation in that he failed to account for forecasted winds at altitude that resulted in an increased time en route and fuel exhaustion.NTSB MIA95FA021Accident · 2 fatalField investigationFinal reportPiper PA-18 · Bainbridge, GAInadvertent stall/spin and altitude inadequate for recovery by the pilot-in-command (CFI).NTSB ATL95FA014Accident · 2 fatalField investigationFinal reportCessna 172H · Louisville, GAThe pilot's failure to maintain clearance from trees during a low pass maneuver. A factor was the trees at the vicinity of the low pass.NTSB ATL95FA012Accident · Serious injuriesField investigationFinal reportBeech A36 · Atlanta, GAThe pilot's inadequate management of the fuel supply which resulted in fuel exhaustion and a complete loss of engine power.NTSB ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.NTSB ATL95LA004Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Ashburn, GAThe failure of a blade counterweight bearing shaft, allowing one propeller blade to go to high pitch.NTSB ATL94LA176Accident · No injuriesLimited investigationFinal reportMooney M20J · Chamblee, GAThe pilot's improper flare that resulted a in hard landing, followed by his improper recovery from a bounced landing, and his failure to maintain directional control during the attempted go- around.NTSB ATL94LA169Accident · No injuriesLimited investigationFinal reportCessna T210M · Willacooche, GAThe pilot's excessive fuel leaning during improper use of the mixture control, which resulted in pre-ignition/detonation and a total loss of engine power. Factors were the electrical wires and vehicles.NTSB ATL94T#A02Accident · No injuriesClass 3Final reportCessna 172Q · Louisville, GANTSB ATL94LA160Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Pine Mountain, GAThe pilot's inadequate compensation for existing wind conditions, and his failure to maintain both airspeed and clearance from a fence. Factors were the tailwind and the gusts which existed at the time of the accident.NTSB ATL94FA162Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Byromville, GAThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall.NTSB ATL94LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Coolidge, GAThe pilot's inadequate preflight preparation. A factor was the wet runway.NTSB ATL94FA156Accident · 2 fatalField investigationFinal reportCessna 172RG · Atlanta, GAThe pilot's inadequate preflight planning in that he operated the aircraft at a weight which exceeded the maximum takeoff weight and his improper use of flaps during takeoff.NTSB ATL94LA154Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Vienna, GAThe loss of engine power because of a fractured cylinder.NTSB ATL94LA147Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAThe fatigue failure of the left main landing gear shock absorbing strut that resulted in a loss of control.NTSB ATL94GA148Accident · Minor injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for undetermined reasons.NTSB ATL94LA144Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hephzibah, GAThe pilot's inadequate preflight of the aircraft, resulting in fuel exhaustion, and his improper flare of the helicopter during the autorotation, resulting in a hard landing.NTSB ATL94LA151Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Columbus, GAThe dual student's failure to properly flare the aircraft during the landing. Factors were the dusk light conditions, and the flight instructor's inadequate supervision of the dual student.NTSB ATL94LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Vidalia, GAThe pilot's inadequate preflight planning, and his failure to refuel the aircraft, resulting in fuel exhaustion and engine stoppage. A factor were the trees at the forced landing area.NTSB ATL94LA140Accident · Minor injuriesLimited investigationFinal reportCessna A188A · Cochran, GAThe pilot's failure to maintain airspeed and clearance from trees during an aerial application maneuver. Factors were the trees at the perimeter of the field, and the gusting tail wind conditions at the time of the accident.NTSB ATL94LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, GAThe pilot's inadequate aircraft pre-flight inspection, his failure to abort the takeoff, and his failure to maintain airspeed that resulted in a stall. A factor was the inadequate aircraft inspection that did not identify the worn fuel cell caps.NTSB ATL94LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAInadequate maintenance by the operator, worn piston rings, and failure to overhaul the engine when due.