NTSB investigations, 2021, GA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 per year
| 1962 | 1 |
|---|---|
| 1963 | 2 |
| 1964 | 77 |
| 1965 | 114 |
| 1966 | 113 |
| 1967 | 140 |
| 1968 | 101 |
| 1969 | 126 |
| 1970 | 117 |
| 1971 | 131 |
| 1972 | 142 |
| 1973 | 89 |
| 1974 | 117 |
| 1975 | 77 |
| 1976 | 103 |
| 1977 | 113 |
| 1978 | 120 |
| 1979 | 95 |
| 1980 | 92 |
| 1981 | 83 |
| 1982 | 82 |
| 1983 | 84 |
| 1984 | 79 |
| 1985 | 75 |
| 1986 | 56 |
| 1987 | 63 |
| 1988 | 61 |
| 1989 | 51 |
| 1990 | 60 |
| 1991 | 61 |
| 1992 | 54 |
| 1993 | 38 |
| 1994 | 49 |
| 1995 | 47 |
| 1996 | 48 |
| 1997 | 49 |
| 1998 | 54 |
| 1999 | 38 |
| 2000 | 42 |
| 2001 | 49 |
| 2002 | 49 |
| 2003 | 51 |
| 2004 | 46 |
| 2005 | 32 |
| 2006 | 44 |
| 2007 | 54 |
| 2008 | 49 |
| 2009 | 47 |
| 2010 | 48 |
| 2011 | 44 |
| 2012 | 39 |
| 2013 | 30 |
| 2014 | 34 |
| 2015 | 33 |
| 2016 | 42 |
| 2017 | 35 |
| 2018 | 35 |
| 2019 | 39 |
| 2020 | 36 |
| 2021 | 37 |
| 2022 | 42 |
| 2023 | 37 |
| 2024 | 44 |
| 2025 | 24 |
| 2026 | 28 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2021
AND 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 year(c."eventDate") = 2021 AND 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 ERA22FA083Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Statesboro, GAThe pilot’s decision to initiate a visual flight rules flight into dark night instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control shortly after takeoff.NTSB ERA22LA079Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA46 · Cornelia, GAThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.NTSB ERA22LA074Accident · No injuriesClass 4 · LimitedFinal reportBeech C35 · Perry, GAThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with a parked airplane.NTSB ERA22FA050Accident · 1 fatalClass 3 · FieldFinal reportMooney M20F · Villa Rica, GAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin.NTSB ERA22LA045Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Decatur, GAOil exhaustion due to an oil leak that resulted in a total loss of engine power.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.NTSB 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.NTSB 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.NTSB ERA22LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Wheeler Heights, GAThe airplane’s impact with a bird while in the traffic pattern.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB ERA21LA392Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-16 · Greensboro, GAThe pilot’s inadequate preflight planning and fuel system inspection, which resulted in fuel exhaustion.NTSB 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.NTSB ERA21LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Unadilla, GAThe airplane's impact by a bird during the enroute portion of the flight.NTSB 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.NTSB 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.NTSB ERA21FA355Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8KCAB · Rhine, GAA collision with trees during a low-altitude aerobatic maneuver for unknown reasons.NTSB ERA22LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Kennesaw, GAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB 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.NTSB ERA21LA246Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Kennesaw, GAThe mechanic’s improper installation of the left main wheel assembly.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB DCA21LA094AccidentClass 4 · LimitedFinal reportBell APT70 · Fort Benning, GAfailure of an electronic speed controller that resulted in a descent and impact with trees.NTSB 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.NTSB 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.NTSB ERA21LA105Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Richmond Hill, GAThe pilot’s mismanagement of the fuel supply, which resulted in fuel starvation.