NTSB investigations, 1980, 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
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\") = 1980
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") = 1980 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 ATL81FKG06Accident · No injuriesClosedCessna 152 · Americus, GANTSB ATL81FKG05Accident · No injuriesClosedBeech 200 · Alma, GANTSB ATL81FA027Accident · Serious injuriesClosedBeech G-185 · Atlanta, GANTSB ATL81FA028Accident · 1 fatalClosedPiper PA-28 · Valdosta, GANTSB ATL81FKG04Accident · Minor injuriesClosedAeronca 7CCM · Douglasville, GANTSB ATL81IA023Incident · No injuriesClosedDouglas DC-8 · Atlanta, GANTSB ATL81IA017Incident · No injuriesClosedCessna 340A · Rome, GANTSB ATL81FKG03Accident · No injuriesClosedChampion 7ECA · Madison, GANTSB NYC81FKG02Accident · Minor injuriesClosedCessna 140 · Stockbridge, GANTSB ATL81FA013Accident · 2 fatalClosedCessna T210N · Baxley, GANTSB ATL81FA011Accident · 1 fatalClosedCessna T210M · Pearson, GANTSB ATL81FA010Accident · 1 fatalClosedBellanca 8KCAB · Woodland, GANTSB ATL81FA008Accident · 4 fatalClosedCessna 310 · Milledgeville, GANTSB ATL81DLA01Accident · No injuriesClosedMustang II · Nashville, GANTSB ATL81FKG01Accident · No injuriesClosedCessna A188B · Buena Vista, GANTSB ATL81FA001Accident · 1 fatalClosedCessna 210 · Cartersville, GANTSB ATL80FKG29Accident · No injuriesClosedBellanca 17-31 · Hampton, GANTSB ATL80FKG30Accident · Minor injuriesClosedPiper PA-25 · Claxton, GANTSB ATL80FKG28Accident · Minor injuriesClosedPiper PA-23 · Cartersville, GANTSB ATL80IA098Incident · No injuriesClosedConvair 440 · Brunswick, GANTSB ATL80FKG27Accident · Minor injuriesClosedAerostar 601P · Peachtree City, GANTSB ATL80FKG26Accident · Minor injuriesClosedCessna 150 · Covington, GANTSB ATL80DKG25Accident · No injuriesClosedCessna 172A · Athens, GANTSB ATL80FA094Accident · Minor injuriesClosedLear Jet 24 · Chamblee, GANTSB ATL80DLA15Accident · Serious injuriesClosedCessna T188C · Moultrie, GANTSB ATL80FKG24Accident · Serious injuriesClosedCessna 172N · Atlanta, GANTSB ATL80FA090Accident · 1 fatalClosedCessna 172 · Milledgeville, GANTSB ATL80DLA14Accident · No injuriesClosedGrumman G-164A · Berlin, GANTSB ATL80FKG22Accident · No injuriesClosedPiper PA-38 · Jefferson, GANTSB ATL80DLA13Accident · No injuriesClosedHughes 269B · Meigs, GANTSB ATL80FA088Accident · 1 fatalClosedAerostar 601P · Summerville, GANTSB ATL80FKG23Accident · No injuriesClosedCessna T210N · Jonesboro, GANTSB ATL80DLA12Accident · No injuriesClosedCessna 172 · Jekyll Island, GANTSB ATL80FLA10Accident · No injuriesClosedPiper PA-30 · Valdosta, GANTSB ATL80FLA11Accident · No injuriesClosedCessna A188 · Hopeful, GANTSB ATL80FKG21Accident · No injuriesClosedCessna 182 · Douglas, GANTSB ATL80DKG20Accident · No injuriesClosedCessna 152 · Lawrenceville, GANTSB ATL80DLA08Accident · No injuriesClosedRockwell S-2R · Colquitt, GANTSB ATL80DLA07Accident · No injuriesClosedGrumman G-164A · Cairo, GANTSB ATL80DLA09Accident · Serious injuriesClosedBell 47G · Blakely, GANTSB ATL80FLA06Accident · No injuriesClosedTom Cat MK-5A · Quitman, GANTSB ATL80DKG19Accident · No injuriesClosedCessna 188 · Albany, GANTSB ATL80FKG18Accident · Minor injuriesClosedCessna R182 · Chamblee, GANTSB ATL80FLA05Accident · No injuriesClosedCessna A188B · Moultrie, GANTSB ATL80FKG16Accident · Serious injuriesClosedPiper PA-25 · Unadilla, GANTSB ATL80DKG15Accident · Minor injuriesClosedCessna 177B · Stone Mt, GANTSB ATL80DKG14Accident · No injuriesClosedPiper PA-25 · Dudley, GANTSB ATL80DKG11Accident · No injuriesClosedCessna 152 · Griffin, GANTSB ATL80FKG13Accident · No injuriesClosedCessna 310G · Jasper, GANTSB ATL80FKG10Accident · No injuriesClosedCessna 150H · Stockbridge, GA