NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 MIA67F0340Accident · Serious injuriesClosedCessna 180 · Vicksburg, MSNTSB MIA67F0320Accident · No injuriesClosedPiper PA-22 · Starkville, MSNTSB MIA67F0326Accident · No injuriesClosedAero Comdr 500 · Vicksburg, MSNTSB MIA67D0306Accident · No injuriesClosedCessna 150 · Agricola, MSNTSB MIA67F0307Accident · No injuriesClosedN.American SNJ-5 · Picayune, MSNTSB MIA67F0301Accident · No injuriesClosedTemco GC-1B · Agricola, MSNTSB MIA67F0294Accident · No injuriesClosedChampion 7EC · Picayune, MSNTSB MIA67F0272Accident · No injuriesClosedCessna 150 · Icksburg, MSNTSB MIA67F0245Accident · No injuriesClosedCessna 210D · Jackson, MSNTSB MIA67A0050Accident · 2 fatalClosedBell 47J-2A · Leland, MSNTSB MIA67F0213Accident · No injuriesClosedCessna 170B · Shelby, MSNTSB MIA67F0215Accident · No injuriesClosedSnow S2C · Independence, MSNTSB MIA67A0045Accident · 3 fatalClosedPiper PA-24 · Stringer, MSNTSB MIA67D0217Accident · No injuriesClosedPiper PA-24 · Macon, MSNTSB MIA67F0188Accident · No injuriesClosedPiper J-3 · Clarksdale, MSNTSB MIA67A0041Accident · 2 fatalClosedPiper PA-28 · Senatobia, MSNTSB MIA67D0182Accident · No injuriesClosedCessna 150 · Lambert, MSNTSB MIA67F0144Accident · No injuriesClosedBeech S35 · Vicksburg, MSNTSB MIA67D0165Accident · No injuriesClosedPiper J3C · Shelby, MSNTSB MIA67D0148Accident · No injuriesClosedPiper PA-28 · Meridian, MSNTSB MIA67F0142Accident · No injuriesClosedPiper PA-28 · Bruce, MSNTSB MIA67A0029Accident · 1 fatalClosedPiper PA-18 · Cliftonville, MSNTSB MIA67F0129Accident · No injuriesClosedPiper PA-24 · Jackson, MSNTSB MIA67F0139Accident · Minor injuriesClosedPiper PA-25 · Corinth, MSNTSB MIA67F0110Accident · No injuriesClosedGrumman G-164 · Lodi, MSNTSB MIA67F0108Accident · No injuriesClosedBoeing A-75 · Raymond, MSNTSB MIA67F0112Accident · No injuriesClosedGrumman G-164 · Sand Hill, MSNTSB MIA67F0111Accident · Serious injuriesClosedCessna 150 · Hernando, MSNTSB MIA67D0064Accident · No injuriesClosedLuscombe 8F · Picayune, MSNTSB MIA67A0013Accident · 1 fatalClosedPiper J-3 · Hernando, MSNTSB MIA67F0090Accident · No injuriesClosedPiper PA-24 · Jackson, MSNTSB MIA67F0057Accident · Minor injuriesClosedCessna 172 · Lamar, MSNTSB MIA67F0002Accident · No injuriesClosedCessna 180 · Grace, MSNTSB MIA67F0004Accident · No injuriesClosedPiper PA-25 · Brookhaven, MSNTSB MIA67D0010Accident · Minor injuriesClosedCessna 140 · Cherau, MSNTSB MIA66D0629Accident · No injuriesClosedChampion 7FC · Pascagoula, MSNTSB MIA66A0150Accident · 2 fatalClosedDouglas DC-3 · Long Beach, MSNTSB MIA66A0147Accident · Minor injuriesClosedBell 47G2A · Lakeshore, MSNTSB MIA66F0610Accident · No injuriesClosedLuscombe 8A · Meridian, MSNTSB MIA66F0592Accident · No injuriesClosedGrumman G164A · Exingtom, MSNTSB MIA66A0142Accident · 1 fatalClosedAero Comdr 680F · South Haven, MSNTSB MIA66F0566Accident · Minor injuriesClosedPiper PA-18A · Amory, MSNTSB MIA66F0595Accident · Minor injuriesClosedMooney MK20C · Pascagoula, MSNTSB MIA66A0140Accident · No injuriesClosedCessna 310A · Amory, MSNTSB MIA66F0596Accident · No injuriesClosedSpiper PA24 · Nsilver Creek, MSNTSB MIA66F0567Accident · No injuriesClosedBeech A45 · Ocean Sprngs, MSNTSB MIA66D0583Accident · No injuriesClosedPiper PA24 · Laurel, MSNTSB MIA66D0582Accident · No injuriesClosedPiper PA-24 · Walls, MSNTSB MIA66A0130Accident · Minor injuriesClosedHughes 269B · Pascagoula, MSNTSB MIA66D0533Accident · No injuriesClosedCessna 170B · Raymond, MS