NTSB investigations, 2022, GA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 | 27 |
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\") = 2022
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") = 2022 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 ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB ERA23LA083Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-44 · Hawkinsville, GAThe pilot’s inadequate in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Covington, GAA total loss of engine power due to oil starvation as a result of engine operation with low oil pressure. Contributing to the accident was the failure of two separate maintenance facilities to comply with guidance from the engine manufacturer to disassemble…NTSB ERA23LA072Accident · Serious injuriesClass 4 · LimitedFinal reportDaniel Anthony Proctor M24 Orion Plus · Suches, GAThe pilot's decision to take off from the runway midpoint with a tailwind, which resulted in impact with terrain.NTSB ERA23LA074Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Newnan, GAThe flight instructor’s inadequate remedial action during a simulated engine failure and low approach, which resulted in a collision with a runway light.NTSB ERA23LA062Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Perry, GAThe pilot’s failure to maintain directional control during touchdown in a crosswind, which resulted in a runway excursion.NTSB ERA23LA063Accident · No injuriesClass 3 · LimitedFinal reportHagerty Glasair Super IIS-TD · Jasper, GAThe loss of engine power due to the failure of the engine-driven fuel pump and the pilot’s failure to use the electric fuel pump, which resulted in a forced, hard landing.NTSB ERA23LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Athens, GAThe operator’s and the pilot’s continued operation of the airplane with a known electrical problem, resulting in a loss of electrical power and a gear-up landing.NTSB ERA23LA053Accident · Minor injuriesClass 4 · LimitedFinal reportSchmidt Randall M Bushby Mustang II · Statesboro, GAA total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the likely inaccurate right fuel quantity indicating system.NTSB ERA23FA047Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G58 · Alpharetta, GAThe pilot’s loss of aircraft control for unknown reasons.NTSB ERA23LA043Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Roberta, GAThe pilot’s failure to maintain a stabilized approach speed on landing, which resulted in a runway excursion and collision with logs.NTSB ERA23LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech V35A · Shellman Bluff, GAThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA022Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172S · Statesboro, GAThe pilot’s failure to include deplaning procedures as part of a passenger safety briefing and failure to have the passengers remain onboard until the engine was shut down, which resulted in a passenger subsequently being struck by the rotating propeller.NTSB ERA23LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Dacula, GAAn in-flight collision with a bird while on approach.NTSB ERA23LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Milan, GAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during cruise flight due to fuel contamination.NTSB ERA22LA434Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Augusta, GAThe failure of the nose landing gear to fully extend and lock into position for reasons that could not be determined, which resulted in its collapse during landing.NTSB ERA22LA419Accident · No injuriesClass 4 · LimitedFinal reportAutogyro USA Calidus · Jasper, GAThe pilot’s failure to maintain control of the gyroplane during a touch-and-go landing.NTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.NTSB ERA22LA390Accident · No injuriesClass 4 · LimitedFinal reportBell Textron Canada 505 · Chamblee, GAThe pilot’s failure to ensure that the helicopter was properly positioned over a dolly before attempting to land on it, which resulted in a rollover.NTSB DCA22LA178Accident · No injuriesClass 4 · LimitedFinal reportBoeing 757-251 · Atlanta, GAThe overpitch control of the airplane during landing resulting in a tail strike.NTSB ERA22LA335Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Calhoun, GAThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in a loss of directional control, a runway excursion, and substantial damage to the airplane.NTSB ERA22LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Lawrenceville, GAThe student pilot’s failure to maintain directional control while landing with a crosswind.NTSB ERA22LA367Accident · Minor injuriesClass 4 · LimitedFinal reportVickers-Slingsby T65A · Butler, GAThe pilot’s retraction the landing gear just prior to touchdown on the runway.NTSB ERA22LA325Accident · No injuriesClass 4 · LimitedFinal reportRaytheon 400A · Brunswick, GAAn in-flight collision with a bird.NTSB ERA22LA301Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar · Cleveland, GAThe pilot’s failure to maintain control of the airplane on takeoff for unknown reasons.NTSB ERA22LA291Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Warm Springs, GAThe loss of engine power due to fuel starvation as the result of the pilot’s inadequate preflight inspection of the fuel supply before flight and the mismanagement of fuel during flight.NTSB ERA22LA282Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Jasper, GAThe failure of the owner to comply with a service bulletin, which resulted in the failure of the left main landing gear torque tube due to fatigue cracking.NTSB ERA22LA265Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23 · Stockbridge, GAA total loss of right engine power during initial climb for reasons that could not be determined.NTSB ERA22LA246Accident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Perry, GAThe pilot’s failure to properly configure the landing gear before landing.NTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA22LA220Accident · 1 fatalClass 3 · LimitedFinal reportCirrus Design SR22 · Tybee Island, GAA loss of airplane control due to pilot incapacitation, which resulted in an overflight of his destination and subsequent descent into water.NTSB ERA22LA239Accident · No injuriesClass 3 · LimitedFinal reportThrush S2R · Hawkinsville, GAA failure of the electric main fuel pump due to the carbon brushes having completely worn away.NTSB ERA22LA212Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Hampton, GAThe student pilot’s application of excessive left brake during the landing roll, resulting in a loss of directional control and a runway excursion. The flight instructor’s inadequate remedial action was a factor in the accident.NTSB ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlNTSB ERA22FA199Accident · 2 fatalClass 3 · FieldFinal reportCessna 340 · Covington, GAThe private pilot’s loss of control in flight, which resulted in a collision with terrain. Contributing to the accident was the student pilot’s decision to obtain flight instruction from the private pilot and the private pilot's insufficient qualifications to…NTSB ERA22LA188Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Calhoun, GAThe pilot’s failure to maintain clearance from wires during takeoff.NTSB ERA22LA182Accident · Minor injuriesClass 3 · LimitedFinal reportAmerican AA-1 · Kennesaw, GAA loss of engine power due to the formation of carburetor ice.NTSB ERA22LA178Accident · No injuriesClass 4 · LimitedFinal reportExtra 300 · Rome, GAAn inflight collision with a bird while conducting low level aerobatics.NTSB ERA22LA167Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172P · Winder, GAMaintenance personnel’s failure to detect the damaged aileron cable during the most recent inspections, which resulted in the separation of the aileron control cable and subsequent loss of airplane control.NTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA22LA146Accident · No injuriesClass 3 · LimitedFinal reportBeech A35 · Waco, GAThe failure of the fuel pressure indicator line due to corrosion that was not detected during the last annual inspection, which resulted in a total loss of engine power.NTSB ERA22LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-150 · Savannah, GAThe student pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.