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 ATL94LA132Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Tifton, GAThe pilot's failure to follow the aircraft checklist, resulting in an attempted takeoff with the elevator trim improperly set. A factor was the trees at the perimeter of the airstrip.NTSB MIA94LA173Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-32 · Valdosta, GAAn encounter with clear air turbulence that was not forecast nor observable on radar.NTSB ATL94LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Chamblee, GAThe student pilot's improper use of the rudder, and his failure to maintain directional control during takeoff.NTSB ATL94LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Smithville, GAThe failure of # 2 cylinder head.NTSB ATL94LA119Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe inadvertent stall by the pilot during practice agricultural spraying runs.NTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.NTSB ATL94LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Flowery Branch, GAThe maintenance personnel's failure to properly secure the throttle linkage assembly that resulted in a reduction in engine power.NTSB ATL94LA114Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing. Factors which contributed to the accident were: the wet runway and the pilot's inattentiveness due to fatigue.NTSB ATL94GA111Accident · No injuriesFinal reportGrumman G-164A · Savannah, GAThe pilot's improper landing flare which resulted in a hard landing. A factor was the operators failure to provide a formal emergency dump procedure.NTSB ATL94LA100Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Hiram, GAThe inadvertent flight from VMC conditions to IMC conditions by the pilot. A factor in the accident was the ground fog in the area.NTSB ATL94LA094Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Stone Mountain, GAthe pilot's improper vertical takeoff in that he allowed the helicopter to drift rearward, and his failure to maintain clearance from the wire.NTSB ATL94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bainbridge, GAThe unsecured rear seat back which fell forward and jammed the flight controls.NTSB ATL94LA087Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellijay, GAThe inadvertent deployment of the parachute because of the jumpmaster's inattention to the static line.NTSB ATL94LA072Accident · Serious injuriesLimited investigationFinal reportFoote M1 Mustang · Marietta, GAThe failure of the pilot to maintain control of the aircraft. Factors in the accident were the lack of familiarization with the aircraft by the pilot, and throttle cable rigging in the experimental aircraft.NTSB ATL94LA068Accident · No injuriesLimited investigationFinal reportBeech C23 · Dahlonega, GAThe poor in-flight decision by the pilot to divert his attention from the runway on short final in order to retrieve a flashlight.NTSB ATL94LA066Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chamblee, GAThe pilot's failure to compensate for the wind condition during landing. A factor is a tailwind.NTSB ATL94GA065Accident · Serious injuriesFinal reportConsolidated Aeronautics Lake LA-4-200 · Williamson, GALoss of engine power for an undetermined reason. A factor related to the accident was: improper planning/decision by the flight instructor (CFI).NTSB ATL94IA055Incident · No injuriesIncident investigationFinal reportCessna 421B · Lagrange, GAThe pilot's intentional swerve off the taxiway to avoid a ground collision. A factor in the incident was an undetermined malfunction of the airplane's normal brake system.NTSB ATL94LA053Accident · No injuriesLimited investigationFinal reportCessna T210R · Baxley, GADamage to the crankshaft internal oil tube by other maintenance persons during the engine overhaul that resulted in oil starvation.NTSB ATL94LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Stockbridge, GAThe partial blockage of the induction air filter because of water soaking, which resulted in a loss of engine power, and the failure of maintenance personnel to properly wash the aircraft.NTSB ATL94LA042Accident · No injuriesLimited investigationFinal reportCessna 182D · Donalsonville, GAThe pilot's failure to clear the induction systems of excessive fuel.NTSB ATL94LA039Accident · No injuriesLimited investigationFinal reportAir & Space 18A · Atlanta, GAA loss of control for undetermined reasons.NTSB ATL94GA038Accident · Serious injuriesFinal reportHughes 269C · Atlanta, GAThe inadvertent closing of the fuel shutoff valve by the pilot. A factor in the accident was the failure of the pilot to maintain rotor RPM during the autorotation.NTSB ATL94FA036Accident · Serious injuriesField investigationFinal reportCessna 172H · Perry, GAThe pilot's inadequate aircraft preflight inspection, in that he did not remove the flight control gust lock prior to the flight. A factor was the use of an unapproved, unmarked rivet as a flight control lock.NTSB MIA94LA041Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Atlanta, GAFailure of the pilot-in-command to apply power after the airspeed decrease just before touchdown and also failure to recover from the bounced landing. Contributing to the accident was the in-flight encounter with wind gusts while on approach to land.NTSB ATL94FA029Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Covington, GASpatial disorientation experienced by the pilot, resulting in his failure to maintain aircraft control. Factors were the total failure of the engine driven vacuum pump, and the night, cloud conditions prevailing at the time of the accident.NTSB ATL94FA028Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Lagrange, GAWas the pilot's failure to correct a known low battery condition before departing, which resulted in a loss of electrical power during an instrument approach. Factors were the dark night and the low scattered cloud layer.NTSB ATL94LA026Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAFuel starvation caused by foreign matter blockage of the fuel tank vent system.NTSB ATL94LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GAThe pilot's failure to use the carburetor heat system while maneuvering the airplane. A factor was conditions that were favorable for the formation of carburetor ice.NTSB ATL94LA015Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Griffin, GAThe pilot's failure to maintain airspeed while maneuvering following a loss of engine power for unknown reasons.NTSB ATL94FA011Accident · 5 fatalField investigationFinal reportPiper PA-32RT-300T · Wrens, GAWas the fatique failure of the idler gear which resulted in the complete loss of engine power. A factor was the dark night.NTSB ATL94FA010Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Richmond Hill, GAThe pilot's failure to maintain an adequate altitude above the water. And his physical impairment due to drugs.NTSB ATL94FA007Accident · 4 fatalField investigationFinal reportBeech S-35 · Carrollton, GAWas the pilot's failure to maintain control of the airplane during a missed approach which resulted in a stall. A factor was the pilot's failure to follow IFR procedures.NTSB ATL93LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Sylvania, GAWas the pilot's failure to properly plan sufficient fuel for the flight which resulted in fuel exhaustion short of the destination airport.NTSB ATL93LA159Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Atlanta, GAWas the pilot's inaccurate evaluation of weather conditions which resulted in the flight entering an area of turbulence.NTSB ATL93LA158Accident · Serious injuriesLimited investigationFinal reportBeech A-23-19 · Resaca, GANot determined.NTSB ATL93LA154Accident · No injuriesLimited investigationFinal reportCessna 177RG · Valdosta, GAThe pilot's inadequate evaluation of inflight weather conditions which resulted in the inflight encounter with severe turbulence and subsequent overstress of the airframe.NTSB ATL93FA150Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stone Mountain, GAThe pilot-in-command's improper use of the aircraft stabilator during the takeoff, and his failure to maintain airspeed, which resulted in an inadvertant stall. A factor was the high obstructions (trees) located near the departure end of the runway.NTSB ATL93LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108/U · Mccaysville, GAThe loss of engine power for undetermined reasons.NTSB ATL93FA143Accident · 4 fatalField investigationFinal reportBeech C-90 · Augusta, GAWas the pilot's failure to adequately evaluate inflight weather conditions which resulted in a loss of control when the airplane encountered a thunderstorm.NTSB MIA93GA154Accident · 4 fatalFinal reportSikorsky UH-60A · Hortense, GAThe pilot-in-command's inadequate supervision of the flight, the co-pilot's failure to maintain an adequate altitude, and the failure of both pilots to see and avoid the wires. Contributing to the accident was the pilot-in-command's inadequate preflight…NTSB ATL93LA126Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Bainbridge, GAThe failure of the landing gear axle.NTSB ATL93LA125Accident · No injuriesLimited investigationFinal reportPiper J3 · Athens, GAThe dual student's improper application of wheel brakes prior to lowering the tail wheel and inadequate supervision by the CFI.NTSB ATL93LA124Accident · No injuriesLimited investigationFinal reportCessna 177 · Atlanta, GAThe failure of the pilot to maintain directional control of the aircraft.NTSB ATL93LA121Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain adequate clearance from the ground.NTSB ATL93LA119Accident · Minor injuriesLimited investigationFinal reportWaco ATO · Alma, GAThe failure of the aircraft engine master rod bearing.NTSB ATL93LA117Accident · Serious injuriesLimited investigationFinal reportTemco GC-1B · Cleveland, GAThe pilot's improper use of carburetor heat, resulting in a partial loss of engine power during the initial climb. Factors were the carburetor icing conditions, and the trees located at the departure end of the airstrip.NTSB ATL93IA113Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Savannah, GALeakage of the number 7 fuel nozzle, which resulted in an in flight engine fire.NTSB ATL93FA107Accident · 2 fatalField investigationFinal reportCessna TP206 · Epworth, GAThe pilot's failure to maintain vertical clearance above the trees while maneuvering which resulted in the collision with trees.NTSB ATL93LA099Accident · No injuriesLimited investigationFinal reportRockwell 114 · Woodstock, GAThe pilot's inadequate preflight planning which resulted in his failure to abort the takeoff when sufficient runway was available.