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 ERA22LA031Accident · 1 fatalClass 3 · LimitedFinal reportVans RV-12 · Folkston, GAThe pilot’s low altitude maneuvering, which resulted in a collision with a utility pole.Oct 26, 2021 · N525AT · DestroyedNTSB ERA22LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Atlanta, GAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and a collision with runway approach lighting equipment.Oct 21, 2021 · N6888A · Substantial damageNTSB ERA22FA014Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-260 · Blairsville, GAThe pilot’s decision to commence the flight in low IFR weather conditions, and making immediate turns after takeoff in IMC, resulting in spatial disorientation and a loss of airplane control.Oct 13, 2021 · N9126P · DestroyedNTSB ERA22LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Wheeler Heights, GAThe airplane’s impact with a bird while in the traffic pattern.Oct 11, 2021 · N263MG · Substantial damageNTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.Oct 9, 2021 · N8592B · Substantial damageNTSB ERA22FA009Accident · 4 fatalClass 3 · FieldFinal reportCessna P210 · Atlanta, GAThe pilot’s failure to ensure that his seat was properly secured before initiating the takeoff, which resulted in a loss of control during the initial climb. Contributing to the accident was the lack of an installed secondary seat stop, and the airplane’s aft…Oct 8, 2021 · N128EE · DestroyedNTSB ERA22FA004Accident · 2 fatalClass 3 · FieldFinal reportDassault Falcon 20 · Thomson, GAThe flight crew’s continuation of an unstable dark night visual approach and the captain’s instruction to use air brakes during the approach contrary to airplane operating limitations, which resulted in a descent below the glide path, and a collision with…Oct 5, 2021 · N283SA · DestroyedNTSB ERA21LA386Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH-12E · Millen, GAThe improper reassembly of the tail rotor gearbox following maintenance, which resulted in fatigue failure of the input pinion gear shaft, and the subsequent loss of tail rotor drive.Sep 29, 2021 · N430NR · Substantial damageNTSB ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.Sep 25, 2021 · N5656H · Substantial damageNTSB ERA21LA382Accident · No injuriesClass 4 · LimitedFinal reportWyder Robert G Marquart MA-5 · Waycross, GAThe pilot’s inadequate fuel management, which resulted in a total loss of engine power on approach due to fuel starvation.Sep 23, 2021 · N79RW · Substantial damageNTSB ERA21LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Unadilla, GAThe airplane's impact by a bird during the enroute portion of the flight.Sep 21, 2021 · N442HG · Substantial damageNTSB ERA21FA362Accident · 3 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Monticello, GAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions during a dark night and over unlit terrain, which resulted in spatial disorientation and a subsequent loss of helicopter control.Sep 16, 2021 · N888DV · DestroyedNTSB ERA21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans Vans RV-8 · Atlanta, GAA loss of directional control and subsequent runway excursion resulting as a result of the inadvertent rudder input by the passenger.Sep 13, 2021 · N798RT · Substantial damageNTSB ERA21FA355Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8KCAB · Rhine, GAA collision with trees during a low-altitude aerobatic maneuver for unknown reasons.Sep 12, 2021 · N390PE · Substantial damageNTSB ERA22LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Kennesaw, GAThe pilot's improper landing flare, which resulted in a hard, bounced landing.Sep 11, 2021 · N9522L · Substantial damageNTSB ERA21LA332Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 · Lindale, GAThe pilot's improper judgment of the helicopter’s height above ground during the landing flare, which resulted in a hard landing with forward airspeed and subsequent bounce and rollover.Aug 18, 2021 · N162LR · Substantial damageNTSB ERA21LA246Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Kennesaw, GAThe mechanic’s improper installation of the left main wheel assembly.Jun 4, 2021 · N10XN · Substantial damageNTSB ERA21LA236Accident · Minor injuriesClass 4 · LimitedFinal reportMaxson Phil Zodiac CH601XL · Winder, GAPilot’s inadequate supervision of the pilot rated passenger’s actions, which led to a high descent rate and collision with obstacles.May 29, 2021 · N601MX · Substantial damageNTSB ERA21LA222Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20K · Dawson, GAMaintenance personnel’s failure to properly secure the No. 4 connecting rod bolt nut with a cotter pin, resulting in a total loss of engine power.May 20, 2021 · N9514R · Substantial damageNTSB CEN21LA224Accident · Serious injuriesClass 3 · LimitedFinal reportDJI Matrice · Young Harris, GAThe remote pilot-in-command’s (RPIC) decision to physically hold onto the drone’s landing gear in flight, which resulted in the rotors striking his hand and causing serious injury. Contributing to the accident was the RPIC’s inadequate preflight planning and…May 6, 2021 · FA3HW43WTF · Minor damageNTSB ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.May 2, 2021 · N6915S · Substantial damageNTSB ERA21LA352Accident · No injuriesClass 4 · LimitedFinal reportHine T L/Johnson R Bush Wacker · Thomaston, GAA loss of directional control upon landing for reasons that could not be determined as a result of a delayed report. Contributing was the pilot’s decision to continue a flight with an unknown airworthiness issue.Apr 16, 2021 · N797RT · Substantial damageNTSB ERA21FA184Accident · 1 fatalClass 3 · FieldFinal reportCessna A188 · Pineview, GAThe pilot’s inadequate visual lookout, which resulted in collision with powerlines during an aerial application flight.Apr 13, 2021 · N4912Q · DestroyedNTSB ERA21LA181Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Stockbridge, GAThe flying pilot’s failure to configure the flaps for a short field takeoff and delayed decision to abort the takeoff, which resulted in a runway overrun.Apr 9, 2021 · N1664H · Substantial damageNTSB ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.Mar 31, 2021 · N3299X · DestroyedNTSB ERA21FA165Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1 · Cave Spring, GAThe pilot's inadequate visual lookout and failure to maintain clearance from a power line.Mar 29, 2021 · N800MH · Substantial damageNTSB ERA21LA155Accident · Minor injuriesClass 3 · LimitedFinal reportSocata MS894A · Monroe, GAMaintenance personnel’s failure to properly inspect and maintain the airplane’s engine cowling latches, which resulted in the in-flight separation of the engine cowling and a subsequent forced landing.Mar 15, 2021 · N42BF · Substantial damageNTSB ERA21LA158Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Hampton, GAThe student pilot’s improper flare while landing with a gusting crosswind which resulted in a hard landing and separation of the left landing gear.Mar 4, 2021 · N150VR · Substantial damageNTSB DCA21LA094AccidentClass 4 · LimitedFinal reportBell APT70 · Fort Benning, GAfailure of an electronic speed controller that resulted in a descent and impact with trees.Mar 1, 2021 · N314AQ · Substantial damageNTSB ERA21FA140Accident · 3 fatalClass 3 · FieldFinal reportCessna R182 · Gainesville, GAThe pilot’s loss of control due to spatial disorientation. Contributing to the accident was the pilot’s decision to depart into low instrument meteorological conditions.Feb 26, 2021 · N3652C · DestroyedNTSB ERA21LA119Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lawrenceville, GAThe pilot's failure to maintain directional control during landing in a gusting crosswind, which resulted in a loss of control and runway excursion.Jan 28, 2021 · N997MC · Substantial damageNTSB ERA21LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Richmond Hill, GAThe pilot’s mismanagement of the fuel supply, which resulted in fuel starvation.Jan 17, 2021 · N919DC · Substantial damageNTSB ERA21LA088Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cleveland, GAA total loss of engine power due to carburetor icing.Dec 27, 2020 · N5939D · Substantial damageNTSB ERA21LA090Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Locust Grove, GAThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control and subsequent runway excursion.Dec 26, 2020 · N75825 · Substantial damageNTSB ERA21LA085Accident · 1 fatalClass 3 · LimitedFinal reportCessna 210L · Midway, GAThe pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pressure to complete the flight to work in an emergency room.Dec 21, 2020 · N2246S · Substantial damageNTSB ERA21LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Atlanta, GAThe Cessna pilot’s failure to tune his radio to the common traffic advisory frequency, which resulted in a lack of awareness of the other aircraft operating at the airport. Contributing to the accident was the Cessna pilot’s lack of understanding of the…Nov 25, 2020 · N8125U · 2 aircraft · Substantial damageNTSB ERA21LA046Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Austell, GAThe flight instructor’s failure to maintain adequate clearance above the gravel surface in a hover, which resulted in a dynamic rollover.Nov 18, 2020 · N442JP · Substantial damageNTSB ERA21LA039Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA40 · Winder, GAThe pilot's loss of directional control while landing, which resulted in a runway excursion.Nov 6, 2020 · N232JP · Substantial damageNTSB ERA21LA037Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Warrenton, GAThe pilot’s failure to attain the proper touchdown point which resulted in a runway overrun and collision with trees.Nov 3, 2020 · N6484X · DestroyedNTSB ERA21LA038Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA22 · Warner Robins, GAThe pilot’s improper compensation for shifting wind conditions, which resulted in a runway excursion and a subsequent nose over.Nov 1, 2020 · N3225B · Substantial damageNTSB ERA21LA030Accident · Minor injuriesClass 3 · LimitedFinal reportGrumman AA5 · Baxley, GAA partial loss of engine power for undetermined reasons.Oct 25, 2020 · N920JL · Substantial damageNTSB ERA21LA024Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Winder, GAMaintenance personnel’s failure to properly secure the engine cooling fan attachment bolts, leading to vibration of the cooling fan, the overextension of the tension belt actuator, the failure of the drive system vee-belts, and the loss of power to the rotor…Oct 18, 2020 · N566BC · Substantial damageNTSB ERA21LA019Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Atlanta, GAA partial loss of engine power during takeoff due to a right magneto anomaly, which resulted in the pilot’s decision to abort the takeoff and the subsequent runway excursion.Oct 11, 2020 · N3595W · Substantial damageNTSB ERA21LA007Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 8KCAB · Ellijay, GAThe pilot's improper landing flare which resulted in a bounced landing and a subsequent noseover.Oct 5, 2020 · N787AC · Substantial damageNTSB ENG20LA046Incident · No injuriesClass 3 · LimitedFinal reportThrush S2R-H80 · Donalsonville, GAA total loss of engine power due to a loose torque meter attachment nut in the reduction gearbox that jammed the planetary gearset causing the power turbine shaft to separate from the power turbine disk, resulting in the power turbine overspeeding and…Sep 28, 2020 · N6216K · Minor damageNTSB ERA20LA329Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Lincolnton, GAThe pilot's loss of airplane control while maneuvering at a low altitude.Sep 22, 2020 · N2601Q · Substantial damageNTSB ERA20LA328Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R · Hamilton, GAThe pilot’s inadequate preflight planning and improper operation of the engine beyond its indicated maximum cruise power setting, which resulted in a total loss of engine power due to fuel exhaustion.Sep 21, 2020 · N7900V · Substantial damageNTSB ERA20LA311Accident · No injuriesClass 4 · LimitedFinal reportZenith CH650LS · Villa Rica, GAA loss of directional control during the landing roll.Sep 5, 2020 · N232PA · Substantial damageNTSB ERA20LA308Accident · No injuriesClass 3 · LimitedFinal reportAmerican AA 1 · Newnan, GAThe flight instructor’s inadequate preflight fuel planning, which resulted in an interruption of the fuel supply to the engine and a subsequent a total loss of engine power due.Sep 5, 2020 · N6107L · Substantial damageNTSB ERA20LA306Accident · Serious injuriesClass 4 · LimitedFinal reportThrush S2R-H80 · Hawkinsville, GAThe pilot's failure to maintain clearance from an antenna tower while maneuvering during an agricultural application flight while flying directly toward the sun.Sep 3, 2020 · N30529 · Substantial damage