NTSB investigations, 1965, MS
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1965
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") = 1965 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 MIA66F0350Accident · No injuriesClosedCessna 150 · Waynesboro, MSNTSB MIA66F0348Accident · No injuriesClosedPiper PA-28 · Picayune, MSNTSB MIA66F0346Accident · 1 fatalClosedPiper J4A · Greenville, MSNTSB MIA66D0333Accident · No injuriesClosedAero Cmdr 680 · Picayune, MSNTSB MIA66A0057Accident · 1 fatalClosedErco 415C · Washington, MSNTSB MIA66A0054Accident · Serious injuriesClosedBell 204-B · Baxterville, MSNTSB MIA66F0317Accident · No injuriesClosedBeech J35 · Ripley, MSNTSB MIA66F0312Accident · No injuriesClosedPiper J-3 · Louisville, MSNTSB MIA66A0040Accident · No injuriesClosedLockheed PV-2 · Tupelo, MSNTSB MIA66F0279Accident · Minor injuriesClosedCessna 170B · Mattson, MSNTSB MIA66F0264Accident · No injuriesClosedBeechcraft 35-33 · Greenville, MSNTSB MIA66F0285Accident · No injuriesClosedBoeing B-75N1 · Webb, MSNTSB MIA66F0266Accident · No injuriesClosedNavion B · Golden, MSNTSB MIA66F0255Accident · No injuriesClosedPiper PA-23 · Hollandale, MSNTSB MIA66F0254Accident · No injuriesClosedBoeing B-75M · Belzoni, MSNTSB MIA66F0215Accident · No injuriesClosedCessna 310B · Vicksburg, MSNTSB MIA66F0214Accident · Serious injuriesClosedAeronca 7AC · Columbus, MSNTSB MIA66D0223Accident · No injuriesClosedPiper PA-18 · Pearlington, MSNTSB MIA66D0231Accident · No injuriesClosedCessna 172 · Rural Hill, MSNTSB MIA66A0028Accident · 1 fatalClosedPiper PA-18A · Clarksdale, MSNTSB MIA66F0233Accident · No injuriesClosedCessna 172E · Crowder, MSNTSB MIA66F0218Accident · No injuriesClosedCessna 140 · Meridian, MSNTSB MIA66A0026Accident · 1 fatalClosedPiper PA-18 · Inverness, MSNTSB MIA66A0025Accident · 1 fatalClosedPiper PA-18 · Pace, MSNTSB MIA66D0239Accident · No injuriesClosedCessna 172 · Tchula, MSNTSB NYC66D0185Accident · No injuriesClosedCessna 182 · Leland, MSNTSB MIA66D0209Accident · No injuriesClosedPiper PA-22 · Greenville, MSNTSB MIA66F0208Accident · Minor injuriesClosedBoeing A-75 · Mattson, MSNTSB MIA66A0023Accident · 4 fatalClosedCessna 182B · Logtown, MSNTSB MIA66F0194Accident · No injuriesClosedGrumman T-G164 · Charleston, MSNTSB MIA66A0021Accident · 1 fatalClosedPiper PA-18 · Leland, MSNTSB MIA66F0182Accident · No injuriesClosedPiper PA-18A · Louisville, MSNTSB MIA66F0192Accident · No injuriesClosedPiper PA-24 · Meridian, MSNTSB MIA66F0167Accident · No injuriesClosedPiper PA-18A · Tupelo, MSNTSB MIA66A0018Accident · 4 fatalClosedBeechcraft A35 · Mathiston, MSNTSB MIA66F0091Accident · No injuriesClosedBoeing A-75N1 · Avalon, MSNTSB MIA66F0090Accident · No injuriesClosedGlobe GC-1B · Forest, MSNTSB MIA66D0069Accident · No injuriesClosedCessna 150D · Gillsburg, MSNTSB MIA66F0066Accident · No injuriesClosedBeechcraft 35 · Madison, MSNTSB MIA66F0065Accident · No injuriesClosedPiper PA-22 · Gulfport, MSNTSB MIA66F0050Accident · No injuriesClosedPiper PA-24 · Meridian, MSNTSB MIA66A0008Accident · No injuriesClosedBell Tomcat · Skene, MSNTSB MIA66F0086Accident · No injuriesClosedPiper PA-25 · Batesville, MSNTSB MIA65A0126Accident · 1 fatalClosedBoeing 75N1 · Sunflower, MSNTSB MIA65A0125Accident · 1 fatalClosedPiper PA-12 · Tutwiler, MSNTSB MIA66D0044Accident · Minor injuriesClosedCessna 172B · Starkville, MSNTSB MIA66F0041Accident · No injuriesClosedCallair A-9 · Moorhead, MSNTSB MIA66D0040Accident · No injuriesClosedCessna 172 · Wayside, MSNTSB MIA65A0119Accident · 1 fatalClosedPiper PA-18A · Lambert, MSNTSB MIA66F0019Accident · Serious injuriesClosedCallair A-9 · Doddsville, MS