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 ATL90LA147Accident · No injuriesLimited investigationFinal reportBeech 23 · Stone Mountain, GAThe pilot's improperly planned approach, in that the airplane was high and fast, which resulted in the runway overrun.NTSB ATL90FA145Accident · Serious injuriesField investigationFinal reportCessna 340 · Atlanta, GAThe pilot-in-command's inadequate fuel management, in that he did not select main fuel tanks prior to this approach. This resulted in fuel starvation to the engines, and the subsequent loss of all engine power.NTSB ATL90IA136Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Atlanta, GAInadequate maintenance inspection of the airplane which resulted in operation of the tire while under inflated and its subsequent failure. A factor in the incident was the inadequate quality control by the tire recapping facility which failed to repair a…NTSB ATL90TL#04Accident · No injuriesClass 3Final reportHughes TH-55 · Brunswick, GANTSB ATL90IA126Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAInadequate maintenance inspection by operator personnel which resulted in operation of the tire while under-inflated.NTSB ATL90LA131Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7CCM · Albany, GAFailure of the pilot in command to directional control on takeoff initial climb, and failure to maintain a visual lookout for obstacles.NTSB ATL90DKG04Accident · No injuriesFinal reportAir Command 532 · Rome, GAThe pilot attempted a flat spiraling spin maneuver at an altitude that was too low to effect a safe recovery.NTSB ATL90IA124Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAFailure of the ac cross tie relay, which prevented the generators from being reconnected to the electrical system. A factor in the incident was the loss of the left generator in flight. Factors include inadvertently disconnecting the left generator while…NTSB ATL90LA121Accident · Minor injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Pineora, GAControl interference by the passenger when the throttle was retarded and the pilot's failure to intervene because of his diverted attention.NTSB ATL90FA119Accident · 2 fatalField investigationFinal reportCessna 177 · Canton, GAThe intentional flight into instrument meteorological conditions by the non-instrument rated pilot.NTSB ATL90FA117Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Griffin, GALoss of engine power for an unknown reason. The presence of trees in the emergency landing area was a related factor.NTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.NTSB ATL90LA112Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Chamblee, GAFailure of the student (rated) pilot to maintain control of the helicopter, and insufficient supervision by the instructor pilot (CFI).NTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.NTSB ATL90LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Hahira, GAThe failure of the right main landing gear tire on landing the failure of the pilot to detect an existing cut on the right main landing gear tire during preflight.NTSB ATL90LA106Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cartersville, GAThe pilot's improper use of the engine fuel mixture control which resulted in fuel exhaustion.NTSB ATL90FA105Accident · 1 fatalField investigationFinal reportCessna 172M · Jonesboro, GAPilot-in-command's inadequate preflight and inflight planning, and his delayed climb after execution of a go-around. Contributing factors were his misreading of airfield wind information, his improper utilization of the flaps during climbout, his failure to…NTSB ATL90LA103Accident · No injuriesLimited investigationFinal reportCessna 182 · Griffin, GAImproper flare by the pilot.NTSB ATL90LA097Accident · No injuriesLimited investigationFinal reportCessna T210 · Lafayette, GAThe pilot's failure to properly manage his fuel supply, which resulted in a loss of engine power, due to fuel starvation.NTSB ATL90DKG03Accident · No injuriesFinal reportCorben BABY-ACE · Griffin, GAAn improper fuel system (installed by the home builder), and continued operation of the aircraft with a known deficiency, which resulted in fuel starvation.NTSB ATL90LA096Accident · No injuriesLimited investigationFinal reportCessna 172A · Villa Rica, GAFuel starvation to the engine, initiated by the combination of a blocked fuel tank vent line and a malfunctioning fuel filler cap. A factor in the accident was the pilot's inadequate preflight inspection, in that he did not detect the fuel vent line blockage.NTSB ATL90LA094Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Stone Mountain, GAThe pilot's misjudged approach which resulted in a long, fast landing and subsequent overrun of the departure threshold. Factors in the accident were the pilot's failure to lower the flaps and establish a proper glidepath.NTSB ATL90LA092Accident · No injuriesLimited investigationFinal reportBeech B35 · Brunswick, GAThe pilot's failure to properly manage his fuel supply by switching to a tank with fuel prior to the loss of engine power. Collision with the tree(s) was a factor related to the accident.NTSB ATL90LA090Accident · Serious injuriesLimited investigationFinal reportAlon A-2 · Jonesboro, GALoss of engine power because of carburetor icing conditions. A factor in the accident was the pilot's improper use of carburetor heat.NTSB ATL90FA093Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · East Ellijay, GAThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions.NTSB ATL90TL#01Accident · No injuriesClass 3Final reportHughes 369E · Buford, GANTSB ATL90IA087Incident · No injuriesIncident investigationFinal reportMooney M-20L · Augusta, GAThe reported performance problem during climbout was undetermined. The pilot's decision to land with the landing gear retracted contributed to the minor damage sustained.NTSB FTW90IA086Incident · No injuriesIncident investigationFinal reportBritish Aerospace HS125-800 · Atlanta, GAThe leaking aft lavatory water heater unit.NTSB ATL90FA081Accident · 2 fatalField investigationFinal reportCessna 172N · Montezuma, GAThe failure of the pilot to maintain sufficient airspeed during the takeoff.NTSB ATL90LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ocilla, GAThe aircraft's encounter with low level windshear resulting in an uncontrollable descent.NTSB ATL90IA076Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAInadequate servicing of the airplane by operator maintenance personnel which resulted in the burst tire. Factors in the accident were hydraulic system lines which were fractured by debris from the burst tire and a total failure of the airplane hydraulic…NTSB ATL90LA078Accident · No injuriesLimited investigationFinal reportNorth American T-6 G · Albany, GAA locked brake which prevented the pilot from maintaining directional control during the landing roll. The brake material expanded after becoming water soaked while taxiing.NTSB ATL90FA070Accident · 2 fatalField investigationFinal reportBeech 58 · Demorest, GAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions. Contributing factors were: the pilot's overconfidence, lack of recent flight experience, and the weather conditions.NTSB ATL90LA068Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Canon, GAImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions, and soft terrain.NTSB ATL90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Chamblee, GAThe pilot misjudged the landing flare. Contributing to the accident was the pilot's failure to defrost the windshield during the approach.NTSB ATL90LA059Accident · No injuriesLimited investigationFinal reportCessna 425 · Augusta, GAFailure of the pilot to maintain control of the aircraft during the go-around. A factor related to the accident was: the pilot's delay in initiating the go-around.NTSB DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBeech A100 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…NTSB ATL90LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lithia Springs, GAImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB ATL90LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Danielsville, GAInadequate preflight preparation/planning by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Related factors were: a false fuel quantity indication, trees in the emergency landing area, and failure of the landing gear…NTSB ATL90LA043Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norcross, GAThe student pilot's improper execution of the landing procedure resulting in dynamic roll-over of the helicopter.NTSB ATL90IA033Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Atlanta, GAInadequate maintenance and inspection by the operator.NTSB ATL90FA031Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Helen, GAThe pilot's failure to properly preflight and plan en route refueling stops. The airplane collided with trees during the emergency descent.NTSB ATL90LA026Accident · No injuriesLimited investigationFinal reportLearjet 24 · Atlanta, GAThe pilot in command's failure to insure his airplane was clear of a parked aircraft while maneuvering to park.NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.NTSB ATL90DKG01Accident · Serious injuriesFinal reportPond Midget Mustang · Cordele, GAImproper handling of the aircraft by the pilot, which resulted in his loss of control. His lack of experience in this type of aircraft was a related factor.NTSB ATL90LA018Accident · No injuriesLimited investigationFinal reportBeech A23A · Roopville, GAThe pilot's disregard for a tailwind during landing, his delay in executing a go around when he noted excessive speed during the landing roll, and improper go around procedures.NTSB ATL90LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lafayette, GAThe pilot's failure to abort the takeoff, when the airplane began to veer left during the takeoff roll. Contributing to the accident was the pilot's failure to inspect the airplane wheel for damage after it dropped off the runway during taxi.NTSB ATL90FA016Accident · Minor injuriesField investigationFinal reportCessna T210M · Peachtree City, GAThe improper calibration of the fuel quantity gauges by maintenance personnel, which resulted in erroneous fuel quantity indications and led to fuel starvation. Contributing to the accident were the unsuitable terrain conditions that existed at the…NTSB ATL90LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cumming, GAA lack of fluid in the brake system and an inadequate annual inspection.NTSB ATL90LA020Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAInadequate visual lookout by the pilot (failure to see & avoid the obstruction). Contributing factors were the transmission (power) line and lack of visual cues (pilot's visual perception).