NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 MIA66F0389Accident · No injuriesClosedBoeing PT-13 · Atlanta, GANTSB MIA66A0069Accident · 2 fatalClosedPiper J3C-65 · Metter, GANTSB MIA66D0373Accident · No injuriesClosedPiper PA-28 · Savannah, GANTSB MIA66F0387Accident · 1 fatalClosedAeronca 7AC · Claxton, GANTSB MIA66D0380Accident · Minor injuriesClosedAeronca L-16 · Clyattville, GANTSB MIA66A0062Accident · 1 fatalClosedCessna 172 · St Marys, GANTSB MIA66F0381Accident · Serious injuriesClosedCessna 172 · Baxley, GANTSB MIA66A0058Accident · No injuriesClosedBrantly B-2B · Fort Valley, GANTSB MIA66F0388Accident · No injuriesClosedPiper PA-24 · Columbus, GANTSB MIA66F0327Accident · No injuriesClosedWaco UEC · Macon, GANTSB MIA66A0055Accident · 4 fatalClosedBeechcraft M35 · Red Oak, GANTSB MIA66I0053Incident · No injuriesClosedDouglas DC-7 · Atlanta, GANTSB MIA66D0316Accident · No injuriesClosedBeechcraft M-23 · Milledgeville, GANTSB MIA66A0052Accident · Minor injuriesClosedPiper PA-24 · Homer, GANTSB MIA66A0048Accident · No injuriesClosedMartin B-26C · Atlanta, GANTSB MIA66A0045Accident · 2 fatalClosedCessna 205 · St Simons Isle, GANTSB MIA66F0314Accident · No injuriesClosedCessna 172 · Ludowici, GANTSB MIA66F0319Accident · Serious injuriesClosedPiper PA-28 · Chamblee, GANTSB MIA66A0041Accident · 2 fatalClosedBrantly B-2 · Griffin, GANTSB MIA66D0265Accident · No injuriesClosedCessna 120 · Chamblee, GANTSB MIA66D0268Accident · No injuriesClosedPiper PA-28 · Jonesboro, GANTSB MIA66F0271Accident · No injuriesClosedBeechcraft 35 · Pine Mountain, GANTSB MIA66A0033Accident · 1 fatalClosedCessna 170B · Chamblee, GANTSB MIA66F0269Accident · No injuriesClosedPiper PA-25 · Pinehurst, GANTSB MIA66F0272Accident · Serious injuriesClosedPiper PA28 · Valdosta, GANTSB MIA66A0032Accident · 2 fatalClosedCessna 150 · Resaca, GANTSB MIA66D0242Accident · No injuriesClosedCommonwelth 185 · Jonesboro, GANTSB MIA66F0220Accident · No injuriesClosedCessna 150 · Griffin, GANTSB MIA66A0029Accident · No injuriesClosedBeechcraft D-18S · Atlanta, GANTSB MIA66D0230Accident · No injuriesClosedPiper PA-28 · Columbus, GANTSB MIA66D0219Accident · Minor injuriesClosedPiper PA-22 · Savannah, GANTSB MIA66F0197Accident · No injuriesClosedPiper PA-22 · Chamblee, GANTSB MIA66D0203Accident · No injuriesClosedBellanca 14-13 · Dawson, GANTSB MIA66D0235Accident · No injuriesClosedCessna 182 · Hartwell, GANTSB MIA66A0024Accident · No injuriesClosedCurtis C-46F · Atlanta, GANTSB MIA66F0157Accident · No injuriesClosedCallair A-5 · Pelham, GANTSB MIA66F0202Accident · No injuriesClosedPiper PA-25 · Cochran, GANTSB MIA66D0199Accident · No injuriesClosedPiper PA-28 · Chamblee, GANTSB MIA66F0171Accident · No injuriesClosedPiper PA-25 · Harrison, GANTSB MIA66F0168Accident · No injuriesClosedCessna 175 · Rhine, GANTSB MIA66F0172Accident · No injuriesClosedLuscombe 8A · Macon, GANTSB MIA66F0160Accident · No injuriesClosedPiper PA-25 · Girard, GANTSB MIA66F0148Accident · No injuriesClosedGrumman G-164 · Smithville, GANTSB MIA66F0181Accident · Serious injuriesClosedPiper PA-18 · Lenox, GANTSB MIA66F0092Accident · No injuriesClosedPiper PA-25 · Pinehurst, GANTSB MIA66F0155Accident · No injuriesClosedPiper PA-18 · Tifton, GANTSB MIA66F0089Accident · No injuriesClosedAeronca 15AC · Atlanta, GANTSB MIA66F0110Accident · Serious injuriesClosedTaylorcraft BC12D1 · Savannah, GANTSB MIA66D0111Accident · No injuriesClosedSlingsby SL4 · Madison, GANTSB MIA66F0109Accident · Minor injuriesClosedBoeing A-75N1 · Bronwood, GA