NTSB investigations, 2005, 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\") = 2005
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") = 2005 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 ATL06LA028Accident · Serious injuriesLimited investigationFinal reportCessna 177-RG · Locust Grove, GAThe total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.NTSB ATL06CA033Accident · No injuriesData collectionFinal reportCessna 172H · Waycross, GAThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing.NTSB ATL06LA019Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Blairsville, GAThe non-instrument rated pilot's continued flight into known adverse weather and his failure to maintain clearance in mountainous terrain, resulting in an in-flight collision with trees and the ground. A factor in the accident was the pilot's lack of an…NTSB ATL06CA017Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAThe pilot's excessive braking resulted in a nose over during landing roll.NTSB ATL06CA118Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe student pilot's failure to maintain airspeed during a touch-and-go landing on initial takeoff climb, resulting in a hard landing on the departure runway.NTSB ATL06CA010Accident · Minor injuriesData collectionFinal reportRobinson Beta II · Lawrenceville, GAThe pilot's improper use of flight controls which resulted in a collision with a fence.NTSB ATL05CA164Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Guyton, GAThe pilot's improper recovery from a bounced landing, and improper flare, which resulted in a hard landing.NTSB ATL05CA153Accident · No injuriesData collectionFinal reportCessna 172S · Savannah, GAThe instructor's inadequate supervision and failure to maintain directional control, resulting in an on ground collision with terrain.NTSB ATL05LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Colquitt, GAThe pilot's failure to maintain visual lookout and clearance from obstacles while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent uncontrolled descent into the ground.NTSB ATL05FA142Accident · 1 fatalField investigationFinal reportBeech V35B · Ellijay, GAThe pilot's continued cruise flight under visual flight rules into known adverse weather, which resulted in his loss of control of the airplane due to spatial disorientation, and an uncontrolled descent and collision with terrain. A factor associated with the…NTSB ATL05CA133Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Atlanta, GAThe pilot's improper use of normal braking and the failure to maintain directional control during landing. Also causal was the instructor's inadequate supervision of the flight which resulted in a collision with the ground.NTSB ATL05CA132Accident · No injuriesData collectionFinal reportCessna 172P · Savannah, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop, and on ground collision of the right wing with the ground.NTSB ATL05CA131Accident · No injuriesData collectionFinal reportCessna 525A · Newnan, GAThe pilot's delay in aborting the landing and his failure to maintain obstacle clearance. Contributing factors were hydroplaning condition, and the localizer antenna.NTSB ATL05LA126Accident · 1 fatalLimited investigationFinal reportEllsworth Sky Bolt · Cumming, GAThe pilot's improper fuel management while maneuvering resulting in a total loss of engine power due to fuel starvation.NTSB ATL05LA121Accident · 1 fatalLimited investigationFinal reportDenmark Mini-Max · Covington, GAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall, uncontrolled descent, and subsequent collision with the ground.NTSB ATL05LA115Accident · Serious injuriesLimited investigationFinal reportCessna 177A · Rome, GAThe pilot's delay in the use of carburetor heat, which resulted in the formation of carburetor / induction ice and the loss of engine power.NTSB ATL05FA098Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Williamson, GAThe pilot's failure to follow the before takeoff checklist and attempted a takeoff with flaps extended, which resulted in an in-flight collision with trees.NTSB ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.NTSB ATL05CA089Accident · Minor injuriesData collectionFinal reportHughes TH-55 · Cornelia, GAThe pilot's failure to maintain adequate object clearance, which resulted in the in-flight collision with terrain, and the subsequent rollover.NTSB ATL05CA087Accident · No injuriesData collectionFinal reportBeech BE-36 · Dahlonega, GAThe pilot's mismanagment of the fuel supply which resulted in fuel starvation and subsequent loss of engine power.NTSB ATL05CA085Accident · Serious injuriesData collectionFinal reportCanadair CL600 · Augusta, GAThe pilot-in-command's improper use of the flight controls during climb which resulted in the flight attendant injury. A factor was the flight crew failure to follow written procedures during transfer of flight controls.NTSB ATL05LA084Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82-C · Franklin, GAThe total failure of the left magneto resulting in a partial loss of engine power on initial takeoff climb, forced landing, and in-flight collision with wires and the ground.NTSB ATL05CA083Accident · Minor injuriesData collectionFinal reportRand Robinson Engineering KR-2 · Vienna, GAA loss of engine power due to the owner/pilot mechanic's improper balancing of the modification to engine crankshaft which resulted in an overload failure.NTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.NTSB ATL05LA075Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-26AT · Lawrenceville, GAThe pilot's improper landing flare that resulted in a hard landing.NTSB ATL05CA074Accident · No injuriesData collectionFinal reportCessna 172H · Oakwood, GALoss of engine power due to fuel system contamination.NTSB ATL05CA069Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Griffin, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with a ditch.NTSB ATL05CA064Accident · No injuriesData collectionFinal reportPiper PA28-151 · Eastman, GAThe certified flight instructors failure to maintain a visual look out while demonstrating a simulated emergency landing resulting in an in-flight collision with a known transmission wire.NTSB ATL05CA058Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Suches, GAThe pilot's premature liftoff and failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall/mush to the runway and subsequent collision with a fence during aborted takeoff.NTSB ATL05LA046Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402A · Bainbridge, GAThe pilot's inadequate management of the fuel supply, which resulted in fuel starvation.NTSB ATL05CA040Accident · No injuriesData collectionFinal reportChampion 7FC · Soperton, GAThe pilot's failure to maintain directional control of the airplane during takeoff roll, which resulted in an on-ground collision with trees. A factor was the pilot's lack of experience in a tailwheel airplane.