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 ATL01LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Homer, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.NTSB MIA01LA002Accident · No injuriesLimited investigationFinal reportHarwell/Gardner WAG-AERO Cubby · Stockbridge, GAThe pilot's failure to maintain a visual lookout during a forced landing resulting in an on-ground collision with a berm on landing roll out. Contributing to the accident was a reported loss of engine power for undetermined reasons.NTSB ATL00LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Adel, GAThe pilot's selection of a closed runway for landing. Contributing factors were his inadequate inflight planning/decision and the wood block on the runway..NTSB MIA00LA267Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GAan in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.NTSB ATL00LA092Accident · Serious injuriesLimited investigationFinal reportBombardier CRJ · Atlanta, GAThe inadvertent flight into turbulent weather conditions.NTSB MIA00LA245Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Berlin, GAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and collision with terrain.NTSB ATL00FA082Accident · 1 fatalField investigationFinal reportBeech B60 · Austell, GAThe pilot's failure to preflight plan adequate fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL00FA081Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · Lumber City, GAPilot's failure to follow instrument procedures and descended below approach minimums and collided with trees. A factor was low clouds.NTSB ATL00FA079Accident · 3 fatalField investigationFinal reportCessna 172H · Peachtree City, GAThe pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.NTSB ATL00LA078Accident · 1 fatalLimited investigationFinal reportSolo Wings Aquilla · Chatsworth, GAThe pilot's failure to maintain clearance from trees while maneuvering that resulted in the collision with trees and the ground.NTSB ATL00FA075Accident · 3 fatalField investigationFinal reportPiper PA-46-350P · Augusta, GAImproper preflight planning/preparation by the pilot, which resulted in taking off with the airplane exceeding the weight and balance limitations. Factors to the accident were the improper loading of the airplane, taking off from a short, up sloping runway…NTSB ATL00FA069Accident · 3 fatalField investigationFinal reportEurocopter AS350B · Sumner, GAThe pilot experienced spatial disorientation, which resulted in a loss of control of the helicopter. Contributing factors was the dark night.NTSB MIA00LA228Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL II Sport · Clyo, GAThe failure of the pilot to maintain control of the aircraft due to impairment by use of drugs, and the resultant uncontrolled descent and in-flight collision with the terrain.NTSB MIA00LA226Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilots failure to calculate his takeoff distance for the conditions, resulting in an in-flight collision with a fence, trees, and the terrain. A factor in the accident is the FAA's failure to require of the manufacturer and the manufacturer's failure to…NTSB MIA00LA223Accident · No injuriesLimited investigationFinal reportCessna 172P · Jesup, GAThe failure of the student pilot to maintain directional control during takeoff resulting in an excursion off the runway and collision with adjacent foliage. A factor in the accident was the student's decision to takeoff downwind.NTSB MIA00LA210Accident · Minor injuriesLimited investigationFinal reportJames Browning Midget MUSTANG-I · Waycross, GAthe pilot's failure to maintain control during initial climb that resulted in the aircraft colliding with the ground and incurring damage. A factor in the accident was the pilot's diverted attention, when he inadvertently knocked the spectacles off his face…NTSB MIA00LA199Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Albany, GAThe dual student's failure to purge the fuel lines of air after a fuel tank was run dry on the previous flight and the failure of the electric fuel boost pump on or low position due to a loose wire which resulted in failure of the engine due to air in the…NTSB MIA00TA189Accident · Serious injuriesFinal reportBell OH-58 · Rome, GAThe pilots failure to ensure the helicopter was on level terrain after landing. The left skid came off the ground after the passenger exited the helicopter, the slope capability was exceeded, the helicopter encountered dynamic rollover, and rolled over on its…NTSB ATL00LA063Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Hampton, GAA total loss of engine power due to foreign object damage to the turbine wheel assembly.NTSB MIA00LA180Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Stockbridge, GAan in-flight collision with trees while maneuvering, which was the result of the pilot not allowing adequate altitude to clear the trees before starting a turn.NTSB MIA00LA174Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Milledgeville, GAThe operation of the airplane by the pilot-in-command in an over gross weight condition, the failure of the pilot to maintain airspeed (Vs) after takeoff, and the intentional stalling of the airplane by the pilot-in-command for his attempting to bank while…NTSB MIA00LA162Accident · No injuriesLimited investigationFinal reportCessna A150M · Gainesville, GAThe pilot's failure to use proper soft field landing technique while attempting a forced landing to an open field following a loss of engine power which resulted in a hard landing. Factors in the accident were weather conditions conducive to formation of…NTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.NTSB ATL00LA055Accident · Minor injuriesLimited investigationFinal reportJackson Velocity RG · Kennesaw, GAA separation of the lower engine cowling and subsequent partial separation of propeller blades during a low high-speed pass. A factor was the recent maintenance work performed by the owner/pilot mechanic.NTSB MIA00LA145Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Metter, GAthe pilot's failure to maintain an adequate lookout resulting in a collision with a transmission wire that resulted in a forced landing and substantial damage to the helicopter.NTSB ATL00LA045Accident · No injuriesLimited investigationFinal reportCessna 150 · Waycross, GAThe student pilot's inaccurate fuel consumption calculation that resulted in the total loss of engine power due to fuel exhaustion and the subsequent collision with a utility pole.NTSB ATL00LA044Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colquitt, GAA loss of engine power for undetermined reasons.NTSB MIA00LA135Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Athens, GAthe pilot's failure to maintain control of the helicopter resulting in his misjudging the flare and a subsequent hard landing. Factors in this accident were, the pilot's inadequate planned approach in trail of two heavier helicopters, a crosswind landing…NTSB MIA00LA123Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Leesburg, GAThe failure of the pilot to maintain clearance during a spray pass resulting in the in-flight collision with the raised rows of the field.NTSB ATL00LA038Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Springfield, GAThe pilot's inadequate preflight planning resulting in fuel exhaustion.NTSB MIA00LA108Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Athens, GAThe flight attendant's failure to seat and belt herself during an inflight encounter with turbulence in clouds resulting in her losing foothold and falling against a passenger seat, sustaining a fractured ankle.NTSB ATL00LA036Accident · 2 fatalLimited investigationFinal reportTrike Unknown · Dalton, GAThe pilot's failure to maintain appropriate clearance with objects during final approach to landing. A factor was the tree.NTSB ATL00LA032Accident · No injuriesLimited investigationFinal reportBellanca 260 B · Cornelia, GAThe pilot's failure to use the checklist, resulting in a wheels-up landing and post-crash fire.NTSB ATL00FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Chamblee, GAThe S76 helicopter pilot's failure to follow ATC landing sequence clearance, which resulted in the PA-28's encounter with the helicopters wake turbulence. A factor was the air traffic controllers clearance procedure.NTSB MIA00LA091Accident · No injuriesLimited investigationFinal reportBeech F90 · Monroe, GAchafed wiring that resulted in an electrical short which initiated the landing gear retraction cycle when cabin heat was activated, resulting in the main landing gear retracting during taxi.NTSB MIA00LA076Accident · No injuriesLimited investigationFinal reportCessna 150L · Statesboro, GAThe partial loss of engine power due to undetermined reasons and unsuitable terrain encountered by the pilot-in-command (CFI), during the forced landing.NTSB MIA00LA074Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincolnton, GAThe pilot's failure to remove ice from the wings prior to takeoff resulting in the aircraft not climbing after takeoff and colliding with a tree.NTSB MIA00LA067Accident · No injuriesLimited investigationFinal reportSwearingen SX300 · Jekyll Island, GAfailure of the left main landing gear attachment during the landing/flare touchdown for undetermined reasons, resulting in the loss of directional control and the airplane exiting the runway and colliding with a runway light.NTSB ATL00FA023Accident · 2 fatalField investigationFinal reportBeech 23 · Macon, GAThe loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.NTSB ATL00FA017Accident · 1 fatalField investigationFinal reportCessna 551 · Cordele, GAThe pilot's failure to follow the published missed approach procedures, and to maintain proper altitude. Factors contributing to the severity of the accident were the low ceilings and trees.NTSB ATL00FA009Accident · 1 fatalField investigationFinal reportCessna 210N · Chamblee, GAThe failure of the flex hydraulic line and the chaffing of an electrical line under the pilot seat that resulted in an inflight fire. The pilot's inflight decision to continue flight with a known airplane deficiencies.NTSB MIA00LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Cornelia, GAthe pilot misjudged the flare, causing the airplane to porpoise, and subsequently impact with the runwayNTSB ATL00LA008Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, GAThe pilot's improper flare that resulted in a hard landing.NTSB MIA99LA272Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Atlanta, GAFAA approach/departure controller's improper service and failure to coordinate and resolve a conflict between aircraft prior to effecting a frequency change, and the improper application of visual separation rules to a flight in the clouds, resulting the crew…NTSB MIA99FA267Accident · Serious injuriesField investigationFinal reportLearjet 24 · Gainesville, GAThe inadequate inspection of the main landing gear brake assemblies, which lead to operation of the aircraft with worn brakes that failed during the landing roll. Contributing factors were the descending terrain, roadway and ditch.NTSB MIA99LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Covington, GAthe pilot's decision to take off from unsuitable terrain, which resulted in a collision with trees.NTSB MIA99FA263Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Moreland, GAThe pilot's failure to maintain the minimum descent altitude while executing a localizer approach. Contributing factors were low ceilings and dark night conditions as well as the trees.NTSB ATL99LA130Accident · No injuriesLimited investigationFinal reportCessna 182P · Summerville, GAThe missing throttle linkage bolt from the carburetor due to an improper engine installation by maintenance personnel. Factors were the tailwind present during the landing roll and the trees.NTSB MIA99LA256Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Canton, GAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during.NTSB MIA99LA251Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30 · Athens, GAThe pilot's improper fuel management resulting in loss of engine power on approach due to fuel starvation and damage to the aircraft during the subsequent forced landing.