Fatal NTSB investigations, 2002, 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 per year
| 1964 | 6 |
|---|---|
| 1965 | 12 |
| 1966 | 11 |
| 1967 | 15 |
| 1968 | 19 |
| 1969 | 20 |
| 1970 | 24 |
| 1971 | 21 |
| 1972 | 25 |
| 1973 | 18 |
| 1974 | 17 |
| 1975 | 11 |
| 1976 | 20 |
| 1977 | 21 |
| 1978 | 17 |
| 1979 | 14 |
| 1980 | 19 |
| 1981 | 14 |
| 1982 | 19 |
| 1983 | 17 |
| 1984 | 15 |
| 1985 | 12 |
| 1986 | 12 |
| 1987 | 12 |
| 1988 | 7 |
| 1989 | 16 |
| 1990 | 12 |
| 1991 | 13 |
| 1992 | 10 |
| 1993 | 15 |
| 1994 | 7 |
| 1995 | 12 |
| 1996 | 10 |
| 1997 | 11 |
| 1998 | 7 |
| 1999 | 9 |
| 2000 | 10 |
| 2001 | 12 |
| 2002 | 13 |
| 2003 | 16 |
| 2004 | 11 |
| 2005 | 6 |
| 2006 | 11 |
| 2007 | 10 |
| 2008 | 7 |
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 10 |
| 2012 | 12 |
| 2013 | 6 |
| 2014 | 9 |
| 2015 | 8 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 9 |
| 2019 | 8 |
| 2020 | 7 |
| 2021 | 11 |
| 2022 | 8 |
| 2023 | 10 |
| 2024 | 6 |
| 2025 | 3 |
| 2026 | 5 |
Where
Latest 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\") = 2002
AND c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2002 AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.NTSB ATL03FA017Accident · 1 fatalField investigationFinal reportCessna 182Q · Cornelia, GAThe pilot's failure to follow IFR approach procedures and continue below the minimum descent altitude, which resulted in an inflight collision with trees, and the ground. A factor was the pilot's impairment from a prescription drug.NTSB ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.NTSB MIA02FA152Accident · 1 fatalField investigationFinal reportCessna 150J · Brunswick, GAthe pilot's failure to maintain an adequate airspeed during takeoff, which resulted in an inadvertent stall. A contributing factor was the pilot's decision to takeoff in an over gross weight condition.NTSB MIA02LA115Accident · 2 fatalLimited investigationFinal reportBailey Dragon Fly · Trenton, GAthe pilot-in-command's failure to maintain airspeed while maneuvering, which resulted in the airplane stalling, spinning, and impacting with the ground.NTSB MIA02LA110Accident · 1 fatalLimited investigationFinal reportHarrison Pietenpol Air Camper · Bainbridge, GAa loss of power due to the passenger's inadvertent deactivation and restricting the movement of the throttle, which resulted in a forced landing and subsequent impact with trees.NTSB ATL02FA104Accident · 3 fatalField investigationFinal reportCessna 172C · Ball Ground, GAThe flight instructor's failure to maintain adequate obstacle clearance, which resulted in an inflight collision with trees.NTSB MIA02LA093Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200-Saeta · Perry, GAThe pilots failure to maintain airspeed while performing a turn at a low altitude, which resulted in a inadvertent stall, an uncontrolled descent, and an impact with trees and terrain.NTSB ATL02FA072Accident · 2 fatalField investigationFinal reportNorth American T-6-AT6D · Gainesville, GAA loss of engine power following a supercharger bearing failure and subsequent collision with the ground while maneuvering for an emergency landing.NTSB ATL02FA062Accident · 2 fatalField investigationFinal reportEurocopter France AS355 F1 · Savannah, GAThe pilot's failure to follow operating procedures and, experienced spatial disorientation while attempting a night landing to an offshore platform. A factor was a dark night.NTSB ATL02FA059Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Macon, GAThe pilot's failure to maintain clearance from a tree while maneuvering after takeoff.NTSB ATL02FA057Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hamilton, GAThe loss of engine power for undetermined reasons.NTSB ATL02FA043Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Atlanta, GAThe pilot experienced spatial disorientation that resulted in the loss of control.