NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1042Accident · No injuriesClosedPiper PA24 · Savannah, GANTSB UNK65X0999Accident · No injuriesClosedBeechraft B50A · Atlanta, GANTSB UNK65X0931Accident · No injuriesClosedPiper PA24 · Athens, GANTSB UNK65X0915Accident · No injuriesClosedCessna 172 · Jonesboro, GANTSB UNK65X0871Accident · No injuriesClosedCessna 210 · Macon, GANTSB UNK65X0745Accident · 6 fatalClosedBeechcraft A35 · Chatsworth, GANTSB UNK65X0696Accident · Minor injuriesClosedChampion 7EC · Villa Rica, GANTSB UNK65X0564Accident · No injuriesClosedCessna 150 · Jonesboro, GANTSB UNK65X0378Accident · No injuriesClosedPiper PA24 · Marietta, GANTSB UNK64X4143Accident · No injuriesClosedCallair A9 · Fort Valley, GANTSB UNK64X4071Accident · No injuriesClosedBeechcraft N35 · Atlanta, GANTSB UNK64X4033Accident · No injuriesClosedCallair A9 · Mill Haven, GANTSB UNK64X3995Accident · Minor injuriesClosedGrumman G164 · Shellnan, GANTSB UNK64X3931Accident · 1 fatalClosedCessna 140 · Darien, GANTSB UNK64X3849Accident · No injuriesClosedCessna 180 · Centralhatchee, GANTSB UNK64X3833Accident · 2 fatalClosedAero Comm 560 · Norcross, GANTSB UNK64X3762Accident · Minor injuriesClosedPiper PA18A · Winder, GANTSB UNK64X3718Accident · Minor injuriesClosedPiper J3 · Unadilla, GANTSB UNK64X3633Accident · No injuriesClosedHughes 269A · Waynesboro, GANTSB UNK64X3594Accident · Serious injuriesClosedPiper J3 · Senoia, GANTSB UNK64X3577Accident · No injuriesClosedCallair A5T · Bainbridge, GANTSB UNK64X3557Accident · No injuriesClosedBeechcraft T34 · Jesup, GANTSB UNK64X3554Accident · No injuriesClosedCessna 175 · Cohutta, GANTSB UNK64X3541Accident · Minor injuriesClosedCallair A5 · Camillia, GANTSB UNK64X3524Accident · 1 fatalClosedCessna 172 · Macon, GANTSB UNK64X3515Accident · Minor injuriesClosedBoeing A75N1 · Edison, GANTSB UNK64X3497Accident · Serious injuriesClosedPiper J3C · Cassville, GANTSB UNK64X3445Accident · No injuriesClosedMooney M18C · Cuthbert, GANTSB UNK64X3420Accident · No injuriesClosedPiper PA12 · Carrolton, GANTSB UNK64X3414Accident · No injuriesClosedPiper PA24 · Cochran, GANTSB UNK64X3404Accident · 1 fatalClosedPiper PA-22 · Dalton, GANTSB UNK64X3350Accident · Serious injuriesClosedBell 47G4 · Blakely, GANTSB UNK64X3218Accident · Serious injuriesClosedPiper PA25 · Berlin, GANTSB UNK64X3217Accident · No injuriesClosedPiper PA24 · Rochelle, GANTSB UNK64X3214Accident · No injuriesClosedPiper PA11 · Tifton, GANTSB UNK64X3121Accident · No injuriesClosedBeechcraft G35 · Nashville, GANTSB UNK64X3076Accident · Minor injuriesClosedHughes 269A · Tennille, GANTSB UNK64X3057Accident · Serious injuriesClosedBoeing A75N1 · Americus, GANTSB UNK64X3011Accident · Minor injuriesClosedPiper PA18 · Lenox, GANTSB UNK64X2972Accident · No injuriesClosedBoeing A75N1 · Dawson, GANTSB UNK64X2971Accident · No injuriesClosedPiper PA25 · Screvin, GANTSB UNK64X2957Accident · Minor injuriesClosedBoing A75N1 · Damascus, GANTSB UNK64X2893Accident · No injuriesClosedPiper PA23 · Atlanta, GANTSB UNK64X2857Accident · No injuriesClosedMooney MK20A · Atlanta, GANTSB UNK64X2846Accident · Minor injuriesClosedCessna 210 · Chamblee, GANTSB UNK64X2818Accident · No injuriesClosedBeechcraft 23 · Columbus, GANTSB UNK64X2736Accident · No injuriesClosedAeronca 7BM · Augusta, GANTSB UNK64X2553Accident · No injuriesClosedPiper PA18 · Atlanta, GANTSB UNK64X2478Accident · No injuriesClosedCessna 172 · Cloudland, GANTSB UNK64X2318Accident · No injuriesClosedCessna 150 · Butler, GA