NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 ATL81FA030Accident · 6 fatalClosedCessna 172M · Aberdeen, MSNTSB ATL81FA025Accident · 1 fatalClosedCessna 152 · Ft Adams, MSNTSB ATL80DLT01Accident · No injuriesClosedVolksplane 2 · Ripley, MSNTSB ATL81IA009Incident · No injuriesClosedBeech A60 · Leaksville, MSNTSB ATL81FKQ02Accident · No injuriesClosedAir Tractor AT-301 · Canton, MSNTSB ATL81FKQ01Accident · Minor injuriesClosedPiper 601P · Greenwood, MSNTSB ATL80DKQ23Accident · No injuriesClosedCessna 188B · Ovett, MSNTSB ATL80FKQ22Accident · No injuriesClosedGrumman G-164 · Clarksdale, MSNTSB ATL80DKQ21Accident · No injuriesClosedCessna A188B · Hurley, MSNTSB ATL80DKQ20Accident · Minor injuriesClosedBeech 23 · Collins, MSNTSB ATL80FKQ19Accident · No injuriesClosedCessna A188B · Merigold, MSNTSB ATL80FLT10Accident · No injuriesClosedBeech 23 · Holly Springs, MSNTSB ATL80FKQ18Accident · Serious injuriesClosedCessna A188B · Yazoo City, MSNTSB ATL80FA077Accident · 1 fatalClosedBellanca 8GCBC · Banks, MSNTSB ATL80DKQ17Accident · No injuriesClosedCessna 188B · Belzoni, MSNTSB ATL80FKQ16Accident · Minor injuriesClosedTomcat Mark 5 · Tutwiler, MSNTSB ATL80FKQ15Accident · No injuriesClosedCessna 152 · Ocean Springs, MSNTSB ATL80FLT09Accident · No injuriesClosedGrumman G-164 · Olive Branch, MSNTSB ATL80FKQ13Accident · No injuriesClosedCessna 188 · Charleston, MSNTSB ATL80DKQ14Accident · No injuriesClosedCessna T188C · Tutwiler, MSNTSB ATL80FA070Accident · 1 fatalClosedAero Comdr 680V · Jackson, MSNTSB ATL80FKQ12Accident · Minor injuriesClosedCessna A188B · Hollandale, MSNTSB ATL80DKQ11Accident · No injuriesClosedAeronca 7AC · Leland, MSNTSB ATL80DKQ10Accident · No injuriesClosedCessna 188B · Leland, MSNTSB ATL80FKQ09Accident · No injuriesClosedGrumman G-164B · Clarksdale, MSNTSB ATL80DKQ08Accident · Minor injuriesClosedCessna A188B · Philipp, MSNTSB ATL80FA053Accident · 2 fatalClosedGrumman AA-1C · Delisle, MSNTSB ATL80FKQ07Accident · Minor injuriesClosedPiper PA-22 · Brookhaven, MSNTSB ATL80FKQ06Accident · Minor injuriesClosedAir Tractor AT301 · Flora, MSNTSB ATL80DKQ05Accident · No injuriesClosedCessna 188T · Hollandale, MSNTSB ATL80FKQ04Accident · No injuriesClosedGrumman G-164A · Boyle, MSNTSB ATL80FKQ03Accident · No injuriesClosedGrumman G-164A · Clarksdale, MSNTSB ATL80FA047Accident · 1 fatalClosedPiper PA-34 · Enterprise, MSNTSB ATL80DKQ02Accident · No injuriesClosedCessna T188T · Belzoni, MSNTSB ATL80FKQ01Accident · Serious injuriesClosedCessna 150 · Prentiss, MSNTSB MIA80FA052Accident · Serious injuriesClosedCessna 414 · Gulfport, MSNTSB MIA80FKQ06Accident · Minor injuriesClosedCessna 337 · Madison, MSNTSB MIA80FKQ05Accident · Serious injuriesClosedAmateur PDQ-2 · Greenville, MSNTSB MIA80FKQ04Accident · No injuriesClosedCessna 140 · Drew, MSNTSB MIA80FKQ03Accident · Minor injuriesClosedGrumman G-164A · Flora, MSNTSB MIA80FLT02Accident · Minor injuriesClosedAero Comdr S2R · Eudora, MSNTSB MIA80FLT01Accident · 1 fatalClosedCessna 188 · Tunica, MSNTSB MIA80FKQ02Accident · 1 fatalClosedErco 415-C · Mooreville, MS