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 MIA96LA210Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Adel, GAthe pilot's misjudgment of clearance between the helicopter and the antenna. A factor relating to the accident was the pilot's use of a drug (medication) that had sedative effects.NTSB ATL96LA117Accident · No injuriesLimited investigationFinal reportGrumman G164 · Dawson, GAloss of engine power for undetermined reason(s), which resulted in an overrun, an encounter with soft terrain, and a nose over.NTSB MIA96LA205Accident · No injuriesLimited investigationFinal reportHampson Velocity · Dublin, GAthe failure of the exhaust of the cylinder Nos. 2 and 4 at each exhaust flange for undetermined reasons. The unsuitable terrain encountered during the forced landing was a factor.NTSB ATL96LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Montezuma, GAfailure of the pilot to maintain adequate visual look out, while maneuvering on an aerial application run, which result in his failure to see-and-avoid a power line.NTSB ATL96LA110Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer 164 · Bainbridge, GAThe pilot's misjudgment of the clearance from the trees during the swath run that resulted in the collision.NTSB ATL96FA103Accident · 2 fatalField investigationFinal reportGeorge Evenson Cuby · Hawkinsville, GAThe failure of the pilot-in-command to maintain airspeed.NTSB ATL96LA099Accident · No injuriesLimited investigationFinal reportCessna 188 · Pelham, GAfailure of the pilot to maintain directional control on the takeoff roll, which resulted in the airplane veering off the runway and colliding with a cotton picker (vehicle).NTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.NTSB ATL96LA092Accident · No injuriesLimited investigationFinal reportCessna 411 · Rome, GAthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power in both engines, due to an inadequate supply of fuel.NTSB ATL96FA090Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Lawrenceville, GAThe pilot's inadequate fuel consumption calculations that resulted in fuel exhaustion. A factor was the pilot's failure to follow the emergency procedure for a forced landing, in that the flaps were not extended.NTSB MIA96LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Barbour Island, GAthe pilot's failure to adequately compensate for gusty wind conditions.NTSB ATL96LA088Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Jesup, GAthe pilot's inadequate preflight planning/preparation, and his failure to remain clear of the fence during takeoff.NTSB MIA96LA143Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Vilarica, GAThe student pilot's failure to maintain airspeed (VSO) during a go-around resulting in an in-flight loss of control (inadvertent stall), and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's improper use of flaps.NTSB ATL96LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Cochran, GAfailure of the flight instructor (CFI) to maintain directional control of the airplane during takeoff, when the airplane encountered an uneven area on the airstrip and becoming airborne prematurely; and his failure to maintain clearance (or altitude) from…NTSB MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB MIA96LA121Accident · No injuriesLimited investigationFinal reportCessna 310D · Palmetto, GAFailure of the pilot-in-command to maintain the proper descent rate resulting in a hard landing and collapse of the right main landing gear.NTSB MIA96LA111Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Plains, GAthe pilot misjudging distance and speed during the approach, and his failure to obtain the proper touchdown point on landing.NTSB ATL96FA066Accident · 1 fatalField investigationFinal reportCessna 310R · Winder, GAThe pilot's failure to maintain visual flight conditions which resulted in the loss of control and subsequent inflight breakup of the airplane when he exceeded the design stress limits of the airframe.NTSB ATL96LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Baxley, GAthe pilot's improper flare, which resulted in a hard landing, a collapsed nose gear, and a subsequent nose over.NTSB ATL96LA062Accident · No injuriesLimited investigationFinal reportCessna 152U · Rincon, GAInaccurate fuel consumption calculations by the pilot, and an inadequate supply of fuel, which resulted in fuel exhaustion and subsequent nose over of the airplane, during a forced landing on uneven terrain with high vegetation (small trees).NTSB ATL96LA060Accident · No injuriesLimited investigationFinal reportCessna 172D · Macon, GAThe pilot's improper planning/decision, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB ATL96LA057Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Cummings, GAthe pilot's abrupt retraction of the flaps and his failure to coordinate airspeed with flap retraction which resulted in the lack of airplane performance.NTSB MIA96LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAthe pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB ATL96IA056Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Savannah, GAthe copilot's misjudgment of the landing touchdown point, and the pilot-in-command's inadequate supervision.NTSB ATL96LA132Accident · No injuriesLimited investigationFinal reportBeech 35 · Griffin, GAfailure of maintenance personnel to properly balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB ATL96FA036Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Peachtree City, GAThe pilot's failure to follow the published instrument approach procedure. The fog was a factor.NTSB ATL96FA035Accident · 1 fatalField investigationFinal reportCessna 150G · Social Circle, GAThe flight instructor's inadequate supervision, and his delay in aborting the takeoff.NTSB ATL96LA028Accident · No injuriesLimited investigationFinal reportBoeing 737-232 · Atlanta, GAFailure of the tug driver, who was towing the Lockheed L-1011, to ensure that clearance was maintained from the Boeing 737, which was standing.NTSB MIA96LA040Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.NTSB ATL96LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Athens, GAThe mechanic's failure to adequately inspect and repair the engine, which resulted in engine oil contamination, and the subsequent loss of engine power. A factor was the low ceiling.NTSB ATL96FA018Accident · 2 fatalField investigationFinal reportNavion D · Canton, GAThe pilot's impairment of judgement and performance due to drugs which led to his overconfidence of personal ability and continued flight into known adverse weather conditions. The weather conditions and dark night were factors.NTSB MIA96LA032Accident · No injuriesLimited investigationFinal reportKoutz Q-200 · Valdosta, GAThe pilot's failure to maintain directional control. The crosswind was a factor.NTSB MIA96LA029Accident · 2 fatalLimited investigationFinal reportBellanca BL-17-30A · Kings Bay, GAa loss of control due to pilot spatial disorientation. Contributing to the accident was: the dark night condition and the pilot's improper decision to turn to an easterly heading with no ground reference lights available.NTSB ATL96LA011Accident · No injuriesLimited investigationFinal reportCessna 421 · Peachtree City, GADeer on the runway during a night landing that resulted in the collision.NTSB MIA96LA022Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Snellville, GAThe pilot's failure to attain the proper touchdown point on landing. The sunglare and wet grass were factors.NTSB ATL96LA007Accident · No injuriesLimited investigationFinal reportBeech 23 · Newnan, GAa loose fuel line fitting, which resulted in a fuel leak and premature emptying of the left fuel tank; failure of the pilot to follow the checklist (select the fullest fuel tank for landing); fuel starvation; and subsequent Loss of engine power, while on…NTSB MIA96LA007Accident · No injuriesLimited investigationFinal reportForney ERCOUPE-2 · Cartersville, GAThe pilot-in-command's decision to continue flight with the inoperative fuel transfer pump which resulted in loss of engine power due to fuel starvation. The inoperative fuel transfer pump and the unsuitable terrain encountered during the forced landing were…NTSB MIA96LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eastman, GAThe failure of the pilot-in-command to perform fuel consumption calculations, and the decision not to refuel. Contributing to the accident was fuel exhaustion, and the pilot- in-command's decision to operate the airplane with the fuel gauges inoperative.NTSB MIA96LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Covington, GAthe pilot's failure to divert to an alternate airport after recognizing a low fuel state existed and his delay to declare an emergency with ATC. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB ATL96LA005Accident · No injuriesLimited investigationFinal reportMooney M20K · Dalton, GAOil starvation for an unknown reason, which resulted in progressive connecting rod failure and subsequent loss of engine power. Factors relating to the accident were: the unfavoable weather and light conditions (low ceiling and fog at dusk), which hampered…NTSB ATL96LA004Accident · 1 fatalLimited investigationFinal reportLopez Lancair 360 · Atlanta, GAthe noninstrument-rated pilot's intentional VFR flight into instrument meteorological conditions which led to a loss of control.NTSB ATL96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot's selection of unsuitable terrain for a precautionary landing, and his failure to maintain clearance from an obstacle (road sign) during the landing.NTSB ATL95LA169Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Plains, GAFailure of the number four cylinder rocker arm housing and pin, which resulted in a closed exhaust valve and loss of engine power.NTSB MIA95FA223Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Dalton, GAthe pilot's improper action by turning off the right engine fuel selector valve after the left engine had failed, and her failure to maintain control of the airplane after losing power in both engines. Factors relating to the accident were: a worn rocker arm…NTSB ATL95LA166Accident · No injuriesLimited investigationFinal reportCessna 170 · Hartwell, GAThe pilot's failure to maintain directional control during the takeoff roll and failure to take appropriate remedial action. A factor was trees.NTSB DCA95MA054Accident · 8 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Carrollton, GAthe in-flight fatigue fracture and separation of a propeller blade resulting in distortion of the left engine nacelle, causing excessive drag, loss of wing lift, and reduced directional control of the airplane. The fracture was caused by a fatigue crack from…NTSB ATL95LA153Accident · No injuriesLimited investigationFinal reportYothment KOLB-FIRESTAR II · Lawrenceville, GAThe pilot's failure to maintain flying speed. A factor was the pilot's lack of familiarity with the aircraft.NTSB MIA95FA207Accident · 1 fatalField investigationFinal reportCessna 210C · Dawsonville, GAThe pilot's disregard of the weather forecast and flight into known adverse weather (instrument flight conditions), resulting in an in-flight collision while maneuvering in mountainous terrain. Contributing to the accident was the pilot's lack of recent…NTSB MIA95LA195Accident · No injuriesLimited investigationFinal reportCessna 195B · Macon, GAa total loss of engine power for undetermined reasons. Contributing to the accident was an engine compartment fire of undetermined origin.