NTSB investigations, 2004, GA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2004
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") = 2004 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 ATL05IA025Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Peachtree City, GAThe failure of maintenance personnel to properly torque a fuel line fitting, which resulted in a fuel leak and in-flight engine fire.NTSB ATL05LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Chamblee, GAThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. .NTSB ATL05LA012Accident · No injuriesLimited investigationFinal reportRogers Lancair IVP · Sylvester, GAThe loss of engine power for undetermined reasons.NTSB ATL05FA010Accident · 2 fatalField investigationFinal reportBeech B-55 · Atlanta, GAThe pilot initiated flight into known adverse weather conditions (thunderstorms), which resulted in a loss of control, and subsequent in-flight collision with the ground.NTSB ATL05LA005Accident · Serious injuriesLimited investigationFinal reportMoody Easy Riser · Augusta, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin, and subsequent collision with the ground.NTSB ATL05CA004Accident · Serious injuriesData collectionFinal reportLuscombe LL-8 · Jasper, GAThe pilot's excessive braking during landing roll resulted in a nose over.NTSB ATL04FA190Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Euharlee, GAThe pilot's failure to maintain adequate control of the airplane, which resulted in the pilot exceeding the design limits of the airplane and subsequent in-flight separation.NTSB ATL04LA178Accident · 1 fatalLimited investigationFinal reportSchleicher K6-CR · LaGrange, GAThe pilot's failure to maintain control of the aircraft which resulted in a stall and subsequent impact with terrain. Factors were the pilot's impairment due to marijuana and his unreported mental conditions.NTSB ATL04LA181Accident · Minor injuriesLimited investigationFinal reportHughes HU-369-D · Waynesboro, GAThe tail rotor assembly failed due to a fatigue fracture of the input gearshaft in the tail rotor gearbox assembly, which resulted in a loss of tail rotor control and subsequent collision with trees.NTSB ATL04LA176Accident · 2 fatalLimited investigationFinal reportLemoine Marvin J. Jr. Christian Eagle II · Cleveland, GAThe pilot's failure to maintain clearance from trees while conducting aerobatic maneuvers.NTSB ATL04LA175Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Kennesaw, GAThe loss of engine power for undetermined reasons.NTSB ATL04LA173Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401B · Bainbridge, GAThe pilot's failure to maintain adequate airspeed during an abrupt maneuver which resulted in a stall and collision with the ground.NTSB ATL04CA172Accident · No injuriesData collectionFinal reportCessna 152 · Waycross, GAThe pilot misjudged the approach speed to touchdown, and the hydroplaning of the airplane during the landing roll resulted in the overrun of the runway surface and the subsequent collision with a fence. .NTSB ATL04CA170Accident · Minor injuriesData collectionFinal reportCessna 172R · Atlanta, GAThe intentional interuption of the flight controls in flight that resulted in a uncontrolled descent and collision with a fence.NTSB ATL04LA143Accident · No injuriesLimited investigationFinal reportCessna 172S · Winder, GAThe improper maintenance (over-pressurization) of the nose gear strut, which resulted in an overload failure of the nose gear upper torque link bolt. The airplane subsequently nosed over during an uncontrollable landing roll.NTSB ATL04FA159Accident · 4 fatalField investigationFinal reportBeech 36TC · Sylvester, GAThe pilot's inadequate in-flight planning/decision resulting in flight into thunderstorms resulting in an in-flight breakup of the airframe.NTSB ATL04LA157Accident · Minor injuriesLimited investigationFinal reportBeech A45 · LaGrange, GAThe maintenance personnel under-torquing of the crankcase throughbolts during top overhaul, which resulted in crankcase fretting, and the subsequent fatigue failure of the crankshaft at the No. 4 main journal. A factor was the lack of suitable terrain for…NTSB ATL04IA156Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-233 · Atlanta, GAThe failure of company maintenance personnel to secure the nacelle/cowl doors, which resulted in a separation of the doors during takeoff initial climb.NTSB ATL04CA162Accident · No injuriesData collectionFinal reportCessna 172 · Chamblee, GAThe pilot's improper landing flare that resulted in a hard landing. A factor was a tailwind condition.NTSB ATL04LA152Accident · Serious injuriesLimited investigationFinal reportStein Skybolt Skybolt · Jasper, GAThe pilot's attempt to operate the airplane with known deficiencies in the equipment, and the fuel system contamination that resulted in fuel starvation to the engine. A factor was rough and uneven terrain.NTSB ATL04LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Cumming, GAThe pilot's failure to obtain takeoff performance data, and his intentional takeoff from a closed and short runway which resulted in an in-flight collision with a tree.NTSB ATL04IA132Incident · No injuriesIncident investigationFinal reportPilatus PC-12-45 · LaGrange, GAThe pilot's failure to maintain aircraft control during the landing flare.NTSB ATL04CA144Accident · Minor injuriesData collectionFinal reportMooney M-20E · Thomasville, GAThe pilot's misjudgment of the airspeed and distance during approach to land that resulted in an undershoot and the subsequent collision with the ground.NTSB ATL04FA141Accident · 3 fatalField investigationFinal reportRobinson R44 · Barnesville, GAThe certified flight instructor's in-flight decision to continue VFR flight into IMC, which resulted in spatial disorientation, and the subsequent in a loss of control. A factor was fog.NTSB ATL04CA134Accident · Minor injuriesData collectionFinal reportCessna T210N · Ellijay, GAThe pilot misjudged his airspeed, distance and intended proper touchdown point which resulted in an overrun of the runway surface and the subsequent collision with an embankment.NTSB ATL04CA133Accident · No injuriesData collectionFinal reportCessna 172 · Kennesaw, GAThe student pilot's failure to maintain directional control during landing roll that resulted in the on ground collision with the ground, and the subsequent collapse of the nose gear.NTSB ATL04LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301 · Baxley, GAThe mechanical malfunction of the autopilot pitch servo, and the pilot's inability to maintain adequate control pressure to manually retrim the pitch attitude.NTSB ATL04LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · St. Marys, GAThe pilot failure to use carburetor heat when weather condition were favorable for the for the formation of carburetor ice. .NTSB ATL04LA122Accident · Serious injuriesLimited investigationFinal reportQuicksilver GT-500 · Cleveland, GAThe student pilot's failure to maintain directional control and his inadequate compensation for wind during takeoff. A factor was crosswind condition.NTSB ATL04CA121Accident · No injuriesData collectionFinal reportBeech BE-24 · Chamblee, GAThe pilot's failure to use checklist resulted in a gear-up landing.NTSB ATL04CA120Accident · No injuriesData collectionFinal reportStinson SR-8E · Peachtree City, GAThe pilot's failure to maintain directional control on landing roll out resulting in a loss of control and ground loop.NTSB ATL04IA138Incident · No injuriesIncident investigationFinal reportCessna 172RG · Chamblee, GAThe fatigue fracture of the nosewheel bungee assembly, which restricted the movement of the elevator control. A factor was the inadequate equipment from an unknown source/manufacturer.NTSB ATL04LA109Accident · 1 fatalLimited investigationFinal reportBergmann Rans S-12 XL Airaile · Cummings, GAThe unqualified person's poor judgement and his failed to maintain clearance from power lines and trees while maneuvering for a landing which resulted in the in-flight collision with trees and power lines. Factors were the dark night and the unqualified…NTSB ATL04CA106Accident · Serious injuriesData collectionFinal reportBeech BE-65 (LF-23F) · Winder, GAThe pilot's mismanagement of the fuel supply resulted in fuel starvation and a loss of power in both engines.NTSB ATL04LA110Accident · No injuriesLimited investigationFinal reportCessna 150K · Monticello, GAThe pilot's failure to maintain clearance from trees during taxi from landing.NTSB ATL04CA101Accident · No injuriesData collectionFinal reportBeech D95A · Athens, GAThe pilot's misjudgment of airspeed and distance which resulted in an overshoot of the runway and collision with ground. The tailwind was a factor.NTSB ATL04CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Cedartown, GAThe pilot's improper use of brakes during landing roll which resulted in the airplane nosing over.NTSB ATL04LA094Accident · 1 fatalLimited investigationFinal reportFirefly F8B · Eatonton, GAThe overload failure of the windline quick release tiedown eyebolt.NTSB ATL04CA089Accident · No injuriesData collectionFinal reportCessna 172N · Statesboro, GAThe pilot's failure to establish a positive climb and his failure to maintain clearance during a go-around, which resulted in an in-flight collision with trees. A factor was the gusting winds.NTSB ATL04LA086Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Eden, GALoss of engine power due to improper installation by maintenance personnel which resulted in the mixture control cable becoming disconnected in-flight. Contributing to the severity of the accident was the in-flight collision with trees.NTSB ATL04LA084Accident · No injuriesLimited investigationFinal reportMaule MX-7-180A · Plains, GAThe pilot's misjudgment of the speed/distance/altitude which resulted in a overrun of the runway.NTSB ATL04IA085Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Atlanta, GAThe failure of the tantalum capacitor and the permanent magnet generator input transformer which resulted in total electrical system failure.NTSB ATL04LA076Accident · No injuriesLimited investigationFinal reportBell 206 · Locust Grove, GAThe pilot's failure to maintain directional control of the helicopter while lifting off a dolly to a hover. This resulted in the tail rotor blades and main rotor blades colliding with the ground and subsequent roll over.NTSB ATL04FA075Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Alma, GAThe pilot's inadequate in-flight decision, and his failure to maintain aircraft control which resulted in continued VFR flight into IMC and the subsequent collision with trees during approach.NTSB ATL04FA071Accident · 1 fatalField investigationFinal reportCessna 150G · High Falls, GAThe pilot's impairment due to alcohol which resulted in his failure to maintain adequate airspeed, inadvertent stall, and subsequent in-flight collision with trees.NTSB ATL04LA070Accident · No injuriesLimited investigationFinal reportEurocopter France EC120B · Jonesboro, GAThe instructor's inadequate supervision, and the dual-student's improper flare which resulted in a hard landing.