NTSB investigations, GA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 ATL92LA086Accident · 1 fatalLimited investigationFinal reportGlaser-Dirks DG-600/18M · Newnan, GAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall at too low of an altitude to effect recovery.NTSB ATL92FA085Accident · 1 fatalField investigationFinal reportRobinson R-22 · Atlanta, GAThe pilot's inadequate evaluation of the weather (wind condition), and the inflight decision to hover with gusting tailwinds, which resulted in a complete loss of tail rotor control. A factor was gusting tailwinds.NTSB ATL92FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Young Harris, GAThe failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.NTSB ATL92IA078Incident · No injuriesIncident investigationFinal reportMaule M-5-210 · Atlanta, GAThe failure of the engine cylinder as a result of cylinder overtemperature, which resulted from the improper procedure of use of the aircraft in a banner towing operation by the operator.NTSB ATL92LA071Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Cumberland Is., GAThe loss of the spark plug at a critical point in flight which resulted from the inadequate overhaul of the engine by an unknown person; and the inadvertent stall of the airplane when the pilot failed to maintain airspeed. A factor was the high obstructions…NTSB ATL92LA070Accident · No injuriesLimited investigationFinal reportBeech C-23 · Dalton, GAThe pilot's inadequate compensation for gusting winds while taxiing for takeoff which resulted in a lost of control. A factor was gusting quartering tail winds.NTSB ATL92T#A01Accident · No injuriesClass 3Final reportBell 206B III · Jonesboro, GANTSB ATL92LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tifton, GAThe pilot's improper single engine go-around procedure, in that he failed to raise the flaps and landing gear, and failed to maintain minimum control airspeed. A factor was the unfavorable wind conditions.NTSB ATL92LA066Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Kennesaw, GAThe dual student's inadequate compensation for wind conditions and inadequate supervision by the flight instructor. Factors were: wind gusts, wind shear and turbulence.NTSB ATL92LA065Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Hull, GAThe pilot's inadequate preflight and inflight planning, which resulted in fuel exhaustion, and his failure to obtain a proper touchdown point, which resulted in a long landing and collision with terrain.NTSB ATL92LA068Accident · 1 fatalLimited investigationFinal reportMaxair 582 · Willacoochee, GAThe pilot's failure to maintain flying speed which resulted in a loss of flight control, and an inadvertent stall.NTSB ATL92LA061Accident · No injuriesLimited investigationFinal reportCessna 150M · Jesup, GAThe failure of the pilot to properly compensate for the crosswind resulting in failure to maintain directional control during landing. A factor was the crosswind condition.NTSB ATL92LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GALoss of engine power for undetermined reasons.NTSB ATL92LA051Accident · No injuriesLimited investigationFinal reportCessna 172I · Bainbridge, GAThe pilot's failure to maintain airspeed on the initial climbout, and the inadvertent stall/mush which resulted. Factors in this accident were: the high obstructions (trees) near the airstrip.NTSB ATL92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.NTSB ATL92LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Griffin, GAThe excessive speed used by the pilot to land on the short private airstrip. A factor was unfavorable wind.NTSB ATL92LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Millen, GAThe pilot's failure to properly use carburetor heat during icing conditions which resulted in the formation of carburetor ice and subsequent loss of engine power.NTSB ATL92FA032Accident · Serious injuriesField investigationFinal reportPiper PA 28-140 · Blythe, GAThe pilot's failure to apply carburetor heat during the before takeoff check as part of the ground check. A factor was weather conditions favorable for the formation of carburetor ice.NTSB MIA92LA044Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Valdosta, GAThe pilot-in-command's improper in-flight decision to continue flight into deteriorating weather conditions. Contributing to the accident was the pilot's overconfidence in his personal ability to fly in instrument conditions.NTSB DCA92MA011Accident · 9 fatalMajor investigationFinal reportBeech 400 · Rome, GAThe captain's decision to initiate visual flight into an area of known mountainous terrain and low ceilings and the failure of the flightcrew to maintain awareness of their proximity to the terrain.NTSB MIA92LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lawrenceville, GAThe separation of numbers 1,2, and 3 connecting rods for undetermined reasons resulting in loss of engine power.NTSB ATL92FA026Accident · Minor injuriesField investigationFinal reportCessna 210H · Carrollton, GAThe contamination of the aircraft fuel system with ice and water, which was undetectable by the pilot.NTSB ATL92IA025Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Atlanta, GAA short in an electrical connector which resulted in its failure. The reason for the short was not determined. A factor was the improper installation of the connector by an unknown maintenance person.NTSB ATL92LA017Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Rome, GAThe failure of a tail rotor blade for undetermined reasons.NTSB ATL92LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Thomasville, GAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain a proper descent rate during the forced landing attempt.NTSB ATL92LA009Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Whitesburg, GAA sudden wind shift during initial climb which resulted in an uncontrolled descent.NTSB ATL92LA001Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Cartersville, GAThe failure of the pilot to maintain control of the aircraft during the landing roll and the improper remedial action taken by the pilot to regain control of the airplane.NTSB ATL91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lagrange, GAThe J-5 pilot's failure to maintain adequate visual lookout.NTSB ATL91LA180Accident · No injuriesLimited investigationFinal reportContinental Copters MK5A · Franklin, GAAn undetermined failure of the tail rotor control cable, which resulted in an uncontrolled collision with the ground.NTSB ATL91LA169Accident · Minor injuriesLimited investigationFinal reportBates, Frank L Skybolt · Yatesville, GAThe pilot's failure to maintain a proper altitude during maneuvering flight.NTSB ATL91LA168Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe pilot's failure to maintain adequate clearance from objects while practicing aerial application procedures.NTSB ATL91LA167Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Calhoun, GAThe pilot's failure to maintain directional control during the go-around attempt. Factor(s) in this accident were: the excessive airspeed at touchdown, and the pilot's lack of experience in this model of airplane.NTSB ATL91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Stockbridge, GAThe pilot's failure to maintain flying speed after experiencing a partial loss of engine power. Factors in this accident were, loose carburetors, annual inspection not performed, and pilot's lack of recent experience.NTSB MIA91FA209Accident · 2 fatalField investigationFinal reportAeronca 7AC · Dawson, GAThe pilot in command's failure to maintain altitude while maneuvering.NTSB ATL91LA162Accident · 1 fatalLimited investigationFinal reportHarold J. Eagen Pitts Special S-1C · Monroe, GAContamination and water existing in the fuel system which resulted in engine stoppage and the pilot's continued flight with a known aircraft deficiency.NTSB ATL91LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300D · Chamblee, GAThe pilot's premature lift off when he failed to identify rotation airspeed and the subsequent inadvertent stall of the airplane.NTSB ATL91FA161Accident · 3 fatalField investigationFinal reportCessna 402B · Kathleen, GAThe pilot's failure to maintain aircraft control while descending at night. Factors related to the accident were: darkness, fog, the pilot's lack of qualification in multi-engine aircraft, his lack of experience in this type of aircraft, his overconfidence in…NTSB ATL91LA159Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Newton, GAThe failure of the pilot-in-command to maintain an adequate visual lookout for obstacles.NTSB ATL91FA155Accident · No injuriesField investigationFinal reportPiper PA-46-310P · Cartersville, GAThe mechanic's improper replacement of the fuel line b-nut, and the inadequate inspection of the repair work by the quality assurance inspector.NTSB ATL91LA153Accident · No injuriesLimited investigationFinal reportCessna T188C · Quitman, GAA total loss of engine power due to fuel starvation. The reason for the fuel starvation was not determined.NTSB ATL91FA150Accident · Serious injuriesField investigationFinal reportCessna 150J · Jonesboro, GAThe pilot's improper in-flight decision when he landed downwind, and beyond the proper touchdown point. Additionally, he failed to attain a safe climb speed, which resulted in a stall/spin. A factor was the high density altitude.NTSB ATL91LA141Accident · Serious injuriesLimited investigationFinal reportMaridon Starduster TOO · Locust Grove, GAFuel exhaustion which resulted from the failure of the pilots to refuel the airplane. A factor was the local pilot's having become lost.NTSB ATL91LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Jenkinsburg, GAThe separation of the nose wheel, during the landing roll, for undetermined reasons.NTSB ATL91IA134Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Savannah, GAThe inadequate inspection procedures which allowed the loss of torque on the top retraction fitting attachment bolt which subsequently failed in fatigue. Factors were the loss of hydraulic fluid through a severed line, and the corrosion of a hydraulic…NTSB ATL91LA133Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Hawkinsville, GAThe pilot's inadequate preflight planning, his failure to refuel the airplane when he observed his fuel supply getting low, and the resultant exhaustion of his fuel supply.NTSB ATL91LA132Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Social Circle, GAThe airplane collided with the steel pole which supports the windsock while the pilot maneuvered to avoid a collision with a deer on the runway.NTSB ATL91LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hawkinsville, GAA complete loss of engine power for undetermined reasons. A factor in this accident was: the rough, uneven terrain at the forced landing site.NTSB ATL91LA126Accident · Serious injuriesLimited investigationFinal reportMoeckel Bakeng Duce · Dawson, GAThe pilot's abrupt rotation after failing to maintain directional control during takeoff roll, and his failure to maintain airspeed during the initial climb, which resulted in a stall. A factor in the accident was: the pilot's lack of familiarity with the…NTSB ATL91LA123Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Alma, GATurbulence in clouds, which was associated with a dissipating thunderstorm.NTSB ATL91LA037Accident · No injuriesLimited investigationFinal reportBeech T-34B · Cartersville, GAThe dual student allowed the airplane to stall because of improper use of the throttle, which resulted in a touch down short of the proper point. A factor in the accident was the inadequate supervision by the flight instructor.