NTSB investigations, 1966, 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
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\") = 1966
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") = 1966 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 MIA67F0381Accident · No injuriesClosedChampion 7ECA · Bainbridge, GANTSB MIA67A0069Accident · 2 fatalClosedBeech 35 · St.Marys, GANTSB MIA67D0347Accident · No injuriesClosedCessna 150 · Montrose, GANTSB MIA67D0341Accident · No injuriesClosedErco 415-D · Logansville, GANTSB MIA67D0324Accident · Minor injuriesClosedCessna 172 · Lakeland, GANTSB MIA67F0321Accident · No injuriesClosedCessna 210 · Atlanta, GANTSB MIA67A0063Accident · No injuriesClosedCessna 320D · Mcrae, GANTSB MIA67A0061Accident · Minor injuriesClosedDouglas A-26B · Dorchester, GANTSB MIA67F0279Accident · No injuriesClosedBellanca 14-13 · T. Simons Isle, GANTSB MIA67F0274Accident · Serious injuriesClosedBoeing A75N1 · Vienna, GANTSB MIA67F0275Accident · No injuriesClosedPiper PA-23 · Atlanta, GANTSB MIA67F0239Accident · No injuriesClosedBeech 35 · Jonesboro, GANTSB MIA67A0047Accident · 3 fatalClosedCessna 210 · Fairburn, GANTSB MIA67D0227Accident · No injuriesClosedPiper J4A · Warner Robins, GANTSB MIA67D0223Accident · No injuriesClosedCessna 182 · Carrollton, GANTSB MIA67F0291Accident · Minor injuriesClosedN.American P-51D · Chamblee, GANTSB MIA67F0246Accident · No injuriesClosedCessna 182A · Cairo, GANTSB MIA67D0197Accident · No injuriesClosedPiper PA-32 · Calhoun, GANTSB MIA67D0205Accident · No injuriesClosedCessna 210 · Elberton, GANTSB MIA67A0036Accident · Serious injuriesClosedDouglas DC-8 · Macon, GANTSB MIA67D0196Accident · No injuriesClosedPiper PA-30 · Milledgeville, GANTSB MIA67F0209Accident · No injuriesClosedStinson 108-3 · Marietta, GANTSB MIA67D0177Accident · No injuriesClosedBeech 95-B55 · Douglas, GANTSB MIA67F0250Accident · No injuriesClosedMooney M20C · Augusta, GANTSB MIA67F0179Accident · Minor injuriesClosedCessna 150 · Milan, GANTSB MIA67D0178Accident · No injuriesClosedCessna 172 · Lithonia, GANTSB MIA67D0204Accident · No injuriesClosedCessna 150 · Plains, GANTSB MIA67D0149Accident · No injuriesClosedPiper PA-22 · Villa Rica, GANTSB CHI67F0195Accident · Serious injuriesClosedPiper PA-25 · Sylvania, GANTSB MIA67F0202Accident · Serious injuriesClosedPiper PA-25 · Sylvester, GANTSB MIA67F0159Accident · No injuriesClosedCessna 172F · Cochran, GANTSB MIA67F0226Accident · Serious injuriesClosedPiper J3C-65 · Millen, GANTSB MIA67F0237Accident · No injuriesClosedPiper PA-25 · Rosier, GANTSB MIA67F0176Accident · Minor injuriesClosedPiper J3 · Roberta, GANTSB MIA67F0172Accident · No injuriesClosedPiper PA-25 · Cordele, GANTSB MIA67F0133Accident · No injuriesClosedPiper PA-22 · Claxton, GANTSB MIA67F0194Accident · No injuriesClosedPiper PA-25 · Shellman, GANTSB MIA67F0170Accident · No injuriesClosedPiper PA-24 · Townsend, GANTSB MIA67D0135Accident · No injuriesClosedCessna 310 · Tifton, GANTSB MIA67F0173Accident · No injuriesClosedAero Cmdr 200-D · Albany, GANTSB MIA67D0150Accident · No injuriesClosedCessna 210-5A · Columbus, GANTSB MIA67D0116Accident · Minor injuriesClosedPiper PA-28 · Autreyville, GANTSB MIA67D0117Accident · No injuriesClosedCessna 172 · Nashville, GANTSB MIA67A0018Accident · 1 fatalClosedStearman A75N1 · Edison, GANTSB MIA67F0146Accident · No injuriesClosedCallair A-5T · Oliver, GANTSB MIA67F0107Accident · No injuriesClosedCessna 310 · Atlanta, GANTSB MIA67F0092Accident · Serious injuriesClosedPiper PA-25 · Metter, GANTSB MIA67F0083Accident · No injuriesClosedCallair A-6 · Baconton, GANTSB MIA67F0076Accident · No injuriesClosedPiper PA-24 · Marietta, GANTSB MIA67A0010Accident · No injuriesClosedHughes 269B · Americus, GA