NTSB investigations, 1964, MS
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 | 54 |
|---|---|
| 1965 | 69 |
| 1966 | 62 |
| 1967 | 58 |
| 1968 | 50 |
| 1969 | 54 |
| 1970 | 40 |
| 1971 | 58 |
| 1972 | 52 |
| 1973 | 32 |
| 1974 | 51 |
| 1975 | 44 |
| 1976 | 36 |
| 1977 | 56 |
| 1978 | 49 |
| 1979 | 44 |
| 1980 | 43 |
| 1981 | 45 |
| 1982 | 36 |
| 1983 | 21 |
| 1984 | 29 |
| 1985 | 23 |
| 1986 | 26 |
| 1987 | 34 |
| 1988 | 26 |
| 1989 | 36 |
| 1990 | 20 |
| 1991 | 25 |
| 1992 | 20 |
| 1993 | 26 |
| 1994 | 20 |
| 1995 | 35 |
| 1996 | 22 |
| 1997 | 22 |
| 1998 | 25 |
| 1999 | 38 |
| 2000 | 24 |
| 2001 | 23 |
| 2002 | 16 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 19 |
| 2006 | 12 |
| 2007 | 20 |
| 2008 | 16 |
| 2009 | 19 |
| 2010 | 8 |
| 2011 | 16 |
| 2012 | 19 |
| 2013 | 13 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 7 |
| 2017 | 11 |
| 2018 | 6 |
| 2019 | 13 |
| 2020 | 7 |
| 2021 | 11 |
| 2022 | 9 |
| 2023 | 8 |
| 2024 | 8 |
| 2025 | 10 |
| 2026 | 7 |
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\" = 'MS' 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" = 'MS' 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 UNK65X1178Accident · Serious injuriesClosedTempco D-16 · Madison, MSNTSB UNK65X1129Accident · No injuriesClosedMooney M21 · Jackson, MSNTSB MIA65 0063Accident · 1 fatalClosedPiper PA-20 · Batesville, MSNTSB UNK65X0948Accident · Serious injuriesClosedCessna 182 · Belzoni, MSNTSB UNK65X0524Accident · 2 fatalClosedAeronca 7AC · Greenville, MSNTSB UNK65X0515Accident · No injuriesClosedBeechcraft 23 · Greenville, MSNTSB UNK65X0393Accident · No injuriesClosedCessna 172 · Marks, MSNTSB UNK65X0351Accident · No injuriesClosedPiper PA30 · Columbus, MSNTSB UNK65X0347Accident · No injuriesClosedCessna 140 · Horn Lake, MSNTSB UNK65X0318Accident · Serious injuriesClosedBell 47G · Walls, MSNTSB UNK65X0216Accident · No injuriesClosedBoeing A75N1 · Yazoo City, MSNTSB UNK64X4086Accident · No injuriesClosedBellanca 1419 · Madison, MSNTSB UNK64X4032Accident · No injuriesClosedBoeing B75N1 · Belizoni, MSNTSB UNK64X3881Accident · Minor injuriesClosedPiper PA25 · Avalon, MSNTSB UNK64X3877Accident · No injuriesClosedBell 47G4 · Canton, MSNTSB UNK64X3872Accident · No injuriesClosedCessna 172 · Louisville, MSNTSB UNK64X3821Accident · Minor injuriesClosedPiper PA25 · Lambert, MSNTSB UNK64X3795Accident · No injuriesClosedPiper PA30 · Wiggins, MSNTSB UNK64X3782Accident · Minor injuriesClosedCessna 150 · Madison, MSNTSB UNK64X3768Accident · No injuriesClosedBeechcraft G35 · Fayette, MSNTSB UNK64X3757Accident · Minor injuriesClosedPiper PA18A · Midnight, MSNTSB UNK64X3716Accident · 1 fatalClosedPiper PA-18A · Greenwood, MSNTSB UNK64X3673Accident · No injuriesClosedPiper PA28 · Laurel, MSNTSB UNK64X3654Accident · Serious injuriesClosedBoeing B75N1 · Nitta Yuma, MSNTSB UNK64X3592Accident · 1 fatalClosedPiper PA18A · Yazoo, MSNTSB UNK64X3403Accident · 2 fatalClosedCessna 150A · Clarksdale, MSNTSB UNK64X3212Accident · No injuriesClosedBoeing A75 · Yazoo City, MSNTSB UNK64X3100Accident · No injuriesClosedLuscombe 8E · Amory, MSNTSB UNK64X3055Accident · Serious injuriesClosedSwift GC1B · Meridian Colo, MSNTSB UNK64X3013Accident · Serious injuriesClosedBoeing A75 · Inverness, MSNTSB UNK64X2911Accident · No injuriesClosedMooney MK20C · Bay Spings, MSNTSB UNK64X2873Accident · No injuriesClosedBoeing A75 · Webb, MSNTSB UNK64X2706Accident · Serious injuriesClosedCntl Copter G47 · Glen Allan, MSNTSB UNK64X2673Accident · 1 fatalClosedCessna 172 · Gulfport, MSNTSB UNK64X2389Accident · Minor injuriesClosedCallair A9 · Vance, MSNTSB UNK64X2239Accident · No injuriesClosedBoeing A75N1 · Minter City, MSNTSB UNK64X2146Accident · No injuriesClosedSmith DSA1 · Madison, MSNTSB UNK64X2102Accident · No injuriesClosedCessna 172E · Canton, MSNTSB UNK64X2090Accident · No injuriesClosedRiviera FN333 · Brookhaven, MSNTSB UNK64X2073Accident · No injuriesClosedAeronca 7AC · Mantee, MSNTSB UNK64X2062Accident · Minor injuriesClosedPiper PA18 · New Albany, MSNTSB UNK64X1858Accident · No injuriesClosedPiper PA22 · Belzoni, MSNTSB UNK64X1507Accident · No injuriesClosedCessna 172 · Picayune, MSNTSB UNK64X1446Accident · No injuriesClosedCessna 182B · Horn Lake, MSNTSB UNK64X1359Accident · No injuriesClosedCessna 120 · Macon, MSNTSB UNK64X1256Accident · No injuriesClosedPiper PA28 · Hattiesburg, MSNTSB UNK64X1221Accident · No injuriesClosedBeechcraft E18S · Columbia, MSNTSB UNK64X0799Accident · No injuriesClosedDouglas DC-3 · Tupelo, MSNTSB UNK64X0681Accident · 2 fatalClosedPiper J3 · Greenville, MSNTSB UNK64X0616Accident · No injuriesClosedBeechcraft E35 · Picayune, MS