Final NTSB investigations, GA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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'
    AND c.\"completionStatus\" = 'Completed'
  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.

NTSB ERA20CA301Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Savannah, GAThe pilot's inadequate flare, resulting in a hard landing.Aug 17, 2020 · N21488 · Substantial damageNTSB ERA20CA232Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Perry, GAThe reported malfunction of the aileron flight control system during takeoff for reasons that could not be determined.Jun 27, 2020 · N4032L · Substantial damageNTSB ERA20LA213Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Hampton, GAThe pilot’s excessive maneuvering at low altitude following a partial loss of engine power which resulted in an aerodynamic stall and collision with terrain.Jun 12, 2020 · N553KM · Substantial damageNTSB ERA20LA206Accident · 5 fatalClass 3 · LimitedFinal reportPiper PA 31T · Eatonton, GAThe pilot’s failure to maintain control of the airplane while maneuvering in instrument meteorological conditions, which placed the airplane in an unusual attitude from which the pilot could not recover. Contributing to the accident was the convective and…Jun 5, 2020 · N135VE · DestroyedNTSB ERA20CA200Accident · No injuriesClass 4 · Data collectionFinal reportVans RV8 · Hampton, GAA right main landing gear break malfunction during landing. Contributing to the accident was a worn right main landing gear caliper pin and pressure plate hole.May 21, 2020 · N665HM · Substantial damageNTSB ERA20CA176Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 402 · Hampton, GAA dual total loss of engine power as a result of fuel exhaustion.May 9, 2020 · N4661N · Substantial damageNTSB ERA20CA171Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20K · Athens, GAThe collapse of the left main landing gear for reasons that could not be determined based on the available information.May 3, 2020 · N231DW · Substantial damageNTSB ERA20CA158Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Athens, GAThe pilot's failure to maintain airplane control after an aborted landing, which resulted in collision with trees.Apr 22, 2020 · N1115 · Substantial damageNTSB ERA20CA155Accident · Serious injuriesData collectionFinal reportGrumman AA5 · Bloomingdale, GAThe pilot's failure to maintain airplane control during landing with a gusting quartering tailwind.Apr 21, 2020 · N314JG · Substantial damageNTSB ERA20CA131Accident · No injuriesData collectionFinal reportAmerican Legand AL18 · Social Circle, GAThe pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.Mar 10, 2020 · N23TN · Substantial damageNTSB ERA20LA123Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · McIntyre, GAA total loss of engine power for reasons that could not be determined.Mar 7, 2020 · N9281M · Substantial damageNTSB ERA20CA128Accident · Minor injuriesData collectionFinal reportStolp Starduster Acroduster II SA750 · Senoia, GAThe pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.Mar 7, 2020 · N529FM · Substantial damageNTSB ERA20FA118Accident · 3 fatalClass 3 · FieldFinal reportPiper PA46 · Bishop, GAThe pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather…Mar 3, 2020 · N43368 · DestroyedNTSB ERA20CA112Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 58 · Augusta, GAThe pilot's failure to land and stop the airplane within the available runway, which resulted in a runway overrun. Contributing to the outcome was the pilot's inadvertent feathering of both propellers during approach to landing.Feb 23, 2020 · N60SH · Substantial damageNTSB ERA20FA096Accident · 4 fatalClass 3 · FieldFinal reportCessna 501 · Fairmount, GAThe pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.Feb 8, 2020 · N501RG · Substantial damageNTSB ERA20FA086Accident · 2 fatalClass 3 · FieldFinal reportMustang II · Senoia, GAThe pilot’s exceedance of the airplane’s structural limitations while conducting previous aerobatic maneuvers, which resulted in an in-flight breakup of the airplane.Jan 25, 2020 · UNREG · DestroyedNTSB ERA20LA071Accident · Minor injuriesClass 3 · LimitedFinal reportHughes OH 6A · Preston, GAA partial loss of engine power for reasons that could not be determined based on the available information.Jan 8, 2020 · N6186U · Substantial damageNTSB ERA20FA068Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newborn, GAThe pilot’s impairment/incapacitation from carbon monoxide poisoning due to a degraded muffler. Contributing to the accident was the pilot’s failure to properly maintain the airplane.Jan 6, 2020 · N1612F · DestroyedNTSB ERA20LA045Accident · Minor injuriesClass 3 · LimitedFinal reportYakovlev YAK 52 · Wrightsville, GAA total loss of engine power due to the failure of the No. 5 cylinder exhaust valve, which resulted in an forced off-airport landing.Nov 30, 2019 · N52CY · Substantial damageNTSB GAA20CA080Accident · No injuriesData collectionFinal reportSymphony Aircraft Ind SA · Fitzgerald, GAThe airplane’s impact with a deer while landing.Nov 12, 2019 · N844SA · Substantial damageNTSB ERA20LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Griffin, GAThe pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.Nov 9, 2019 · N686DR · Substantial damageNTSB DCA20IA014Incident · No injuriesClass 3 · IncidentFinal reportEmbraer ERJ170 · Atlanta, GAThe captain’s use of his pitch trim switch, which had been placarded inoperative but not deactivated, resulting in the airplane pitching up when the captain was trying to trim down. The trim commands were reversed due to maintenance personnel’s incorrect…Nov 7, 2019 · N117HQ · No damageNTSB ERA20FA029Accident · 1 fatalClass 3 · FieldFinal reportPavel Tango2 · Cedartown, GAThe pilot's loss of control of the gyroplane for reasons that could not be determined based on available evidence.Nov 4, 2019 · N875FV · Substantial damageNTSB ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.Oct 30, 2019 · N56258 · DestroyedNTSB GAA20CA055Accident · No injuriesData collectionFinal reportCessna 172 · Augusta, GAThe student pilot's failure to attain sufficient airspeed to climb out of ground effect, which resulted in a descent, loss of directional control, runway excursion, and impact with a fence.Oct 28, 2019 · N80931 · Substantial damageNTSB ERA20LA017Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Shellman, GAA partial loss of engine power for reasons that could not be determined based on the available information.Oct 18, 2019 · N762BF · DestroyedNTSB ERA20LA016Accident · Serious injuriesClass 3 · LimitedFinal reportBombardier BD 700 1A10 · Augusta, GAThe first officer's failure to maintain a safe distance from a large turbine-powered airplane while escorting passengers, resulting in a passenger encounter with jet blast.Oct 16, 2019 · N307KP · No damageNTSB GAA20CA022Accident · No injuriesData collectionFinal reportBeech 36 · Douglas, GAThe pilot's failure to extend the landing gear due to intoxication during an unauthorized flight.Oct 14, 2019 · N8047R · Substantial damageNTSB GAA20CA021Accident · No injuriesData collectionFinal reportWingtip To Wingtip Panzl S-330 · Cedartown, GA***This report was modified on June 4, 2020. Please see the docket for this accident to view the original report.*** The departing pilot's failure to see and avoid the arriving airplane as it was turning off the runway from which the departing pilot was…Oct 11, 2019 · N540ML · 2 aircraft · Substantial damageNTSB GAA20CA020Accident · Minor injuriesData collectionFinal reportAyres S2R · Willacoochee, GAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Oct 11, 2019 · N3090C · Substantial damageNTSB ERA19LA286Accident · 1 fatalLimited investigationFinal reportSolo Wings Windlass · Dalton, GAThe pilot's exceedance of the aircraft's critical angle of attack during a turn shortly after takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing was the pilot's lack of experience in the accident aircraft.Sep 28, 2019 · UNREG · Substantial damageNTSB ERA19LA273Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Sardis, GAFatigue failure of the fasteners on the engine crankshaft, which resulted in a partial loss of engine power and a subsequent forced landing.Sep 17, 2019 · N827JE · Substantial damageNTSB ERA19LA238Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Cuthbert, GAThe failure of the No. 1 bearing due to fatigue which resulted in a partial loss of engine power. The reason for the bearing failure could not be determined based on the available information.Jul 25, 2019 · N5680X · Substantial damageNTSB ERA19FA234Accident · 2 fatalClass 2 · FieldFinal reportCirrus SR22 · Americus, GAThe pilot’s decision to depart in dark instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot’s and pilot-rated passenger’s self-induced pressure to…Jul 24, 2019 · N921CD · DestroyedNTSB ERA19LA221Accident · 1 fatalClass 3 · LimitedFinal reportTeam Mini-Max Hi-Max · Monroe, GAA collision with terrain for undetermined reasons.Jul 9, 2019 · UNREG · DestroyedNTSB GAA19CA382Accident · No injuriesData collectionFinal reportPiper PA24 · Brunswick, GAThe pilot's failure to properly lean the fuel mixture in flight, which resulted in fuel exhaustion, a subsequent total loss of engine power, and a forced landing with the landing gear retracted.Jun 29, 2019 · N8294P · Substantial damageNTSB ERA19LA219Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 4 · Williamson, GAThe pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.Jun 27, 2019 · N102GL · Substantial damageNTSB ERA19TA182Accident · No injuriesClass 3Final reportAeronca 7AC · Concord, GAThe pilot's inability to maintain directional control during landing for reasons that could not be determined because postaccident examination of the airplane brake assemblies revealed no anomalies that would have caused the right brake to lock, which…May 27, 2019 · N1797E · Substantial damageNTSB ERA19FA179Accident · 1 fatalField investigationFinal reportCessna TR182 · St. Simons Island, GAThe pilot's loss of airplane control during approach for undetermined reasons.May 25, 2019 · N6123T · DestroyedNTSB DCA19CA151Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 737-8H4 · Waycross, GAan encounter with convectively induced turbulence while penetrating cumulus clouds during descent.May 25, 2019 · N8697C · No damageNTSB GAA19CA373Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Blairesville, GAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in a hard landing and landing gear collapse.May 19, 2019 · N153SW · Substantial damageNTSB GAA19CA310Accident · No injuriesData collectionFinal reportPiper PA23 · Atlanta, GAThe airplane’s impact with a deer on the runway during landing.May 18, 2019 · N6562A · Substantial damageNTSB ERA19LA173Accident · No injuriesClass 3 · LimitedFinal reportHughes 269B · Hampton, GAGround resonance during landing for reasons that could not be determined based on the available information.May 15, 2019 · N9422F · Substantial damageNTSB ERA19IA178Incident · No injuriesClass 3 · IncidentFinal reportCessna 550 · Savannah, GAThe lineman's inadvertent introduction of diesel exhaust fluid (DEF) to the fuel truck fuel system icing inhibitor reservoir, which resulted in fuel contamination and a total loss of engine power. Contributing to the accident was the fixed-base operator's…May 9, 2019 · N744AT · No damageNTSB ERA19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportAcro Super Acro Sport I · Elberton, GAThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Apr 25, 2019 · N20FB · Substantial damageNTSB ERA19LA152Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Dublin, GAA partial loss of engine power on takeoff due to separation of the diffuser assembly as a result of incomplete braze joint surfaces on the vane airfoils.Apr 15, 2019 · N395AE · Substantial damageNTSB DCA19CA146Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD88 · Atlanta, GAfailure of the tug driver to give way to the taxiing airplane.Apr 5, 2019 · N977DL · Substantial damageNTSB GAA19CA191Accident · No injuriesData collectionFinal reportPiper PA32 · Swainsboro, GAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and the landing gear collapsing.Mar 31, 2019 · N75242 · Substantial damageNTSB ERA19CA289Accident · No injuriesData collectionFinal reportPiper PA28 · Winder, GAThe student pilot’s loss of airplane control, the flight instructor's delayed remedial action, and the student's delay in relinquishing the flight controls, which resulted in the airplane striking a runway sign during a go-around.Mar 28, 2019 · N6412W · Substantial damageNTSB ERA19FA134Accident · 1 fatalClass 2 · FieldFinal reportHogan Innovator · Calhoun, GAThe pilot's failure to maintain aircraft control during the airplane's second test flight, which resulted in a collision with terrain. Contributing to the accident was the pilot allowing external pressures to guide his decision to fly the airplane when he…Mar 23, 2019 · N257AR · Substantial damage