NTSB investigations, 1978, MS
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
| 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
Open the mapLatest 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\") = 1978
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") = 1978 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 MIA79FLT02Accident · No injuriesClosedBell 47G5 · Paden, MSNTSB MIA79FLT01Accident · Serious injuriesClosedBellanca 7GCAA · Walls, MSNTSB MIA79FKQ03Accident · No injuriesClosedCessna 182 · Bay St Louis, MSNTSB MIA79DKQ02Accident · Minor injuriesClosedCessna 172 · Ocean Springs, MSNTSB MIA79FA012Accident · 8 fatalClosedBeech 60 · Jackson, MSNTSB MIA78DKQ01Accident · Minor injuriesClosedMooney M20J · Cleveland, MSNTSB MIA78FKQ42Accident · No injuriesClosedCessna A188B · Leland, MSNTSB MIA78DKQ41Accident · No injuriesClosedCessna 152 · Tylertown, MSNTSB MIA78FKQ39Accident · Serious injuriesClosedCessna 188B · Inverness, MSNTSB MIA78DKQ40Accident · No injuriesClosedGrumman G-164 · Hollybluff, MSNTSB MIA78FA123Accident · 1 fatalClosedCessna 172N · Gautier, MSNTSB MIA78FKQ38Accident · No injuriesClosedGrumman G-164 · Philipp, MSNTSB UNK78X0135Accident · No injuriesClosedCessna A188B · Greenville, MSNTSB MIA78FKQ35Accident · Minor injuriesClosedCessna 150 · Biloxi, MSNTSB MIA78FKQ34Accident · No injuriesClosedCessna 188 · Brookhaven, MSNTSB MIA78FLT02Accident · No injuriesClosedMooney M-21 · Holly Spgs, MSNTSB MIA78DKQ33Accident · No injuriesClosedGrumman G-164B · Benton, MSNTSB MIA78FKQ32Accident · No injuriesClosedGrumman G-164A · Charleston, MSNTSB MIA78DKQ31Accident · Minor injuriesClosedCessna 188 · Water Valley, MSNTSB MIA78DKQ36Accident · No injuriesClosedPiper PA-18 · Mt.Olive, MSNTSB MIA78FKQ29Accident · No injuriesClosedGrumman G-164B · Charlestown, MSNTSB MIA78FKQ28Accident · No injuriesClosedPiper PA-25 · Raymond, MSNTSB MIA78FK030Accident · Minor injuriesClosedGrumman G-164B · Charleston, MSNTSB MIA78FKQ27Accident · No injuriesClosedAyres S2R · Rome, MSNTSB MIA78FKQ26Accident · No injuriesClosedGrumman G-164 · Tutwiler, MSNTSB MIA78FKQ25Accident · Minor injuriesClosedWeatherly 201B · Drew, MSNTSB MIA78DKQ24Accident · No injuriesClosedCessna A188B · Choctaw, MSNTSB MIA78DKQ23Accident · Minor injuriesClosedCessna 188B · Doddsville, MSNTSB MIA78DKQ22Accident · No injuriesClosedPiper PA-25 · Valley Park, MSNTSB MIA78FKQ21Accident · No injuriesClosedPiper PA-36 · Leland, MSNTSB MIA78FKQ20Accident · No injuriesClosedBell 47G3B · Fayette, MSNTSB MIA78KKQ19Accident · No injuriesClosedGrumman G-164A · Sunflower, MSNTSB MIA78FKQ18Accident · No injuriesClosedCessna 152 · Greenwood, MSNTSB MIA78FKQ17Accident · No injuriesClosedPiper PA-25 · Schlater, MSNTSB MIA78FKQ15Accident · Minor injuriesClosedCessna A188B · Philipp, MSNTSB MIA78FKQ12Accident · No injuriesClosedBell 47G3B · Red Lick, MSNTSB MIA78FKQ14Accident · Minor injuriesClosedBell 47G · Fayette, MSNTSB MIA78FKQ11Accident · No injuriesClosedWaco UPF-7 · Meridian, MSNTSB MIA78FKQ10Accident · Serious injuriesClosedPiper PA-34 · Laurel, MSNTSB MIA78FKQ09Accident · No injuriesClosedAero Comdr S2R · Stringtown, MSNTSB MIA78FA069Accident · 1 fatalClosedCessna 172 · Benoit, MSNTSB MIA78FKQ08Accident · Serious injuriesClosedPiper PA-28 · Nachez, MSNTSB MIA78FKQ07Accident · Serious injuriesClosedCessna 150L · Hallandale, MSNTSB MIA78FA065Accident · 2 fatalClosedBellanca 17-30A · Gulfport, MSNTSB MIA78FA050Accident · 2 fatalClosedCessna 310I · Laurel, MSNTSB MIA78DKQ04Accident · No injuriesClosedCessna 188 · Calhoun City, MSNTSB MIA78FKQ05Accident · No injuriesClosedN.American P-51 · Ellisville, MSNTSB MIA78FA031Accident · 5 fatalClosedBeech B-90 · Yazoo City, MSNTSB MIA78FA030Accident · 4 fatalClosedBeech B-58P · Tylertown, MS