NTSB investigations, 1981, 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\") = 1981
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") = 1981 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 ATL82FA018Accident · 1 fatalClosedCessna 425 · Natchez, MSNTSB ATL82FKQ08Accident · Serious injuriesClosedBeech F33A · Grenada, MSNTSB ATL82FKQ07Accident · Serious injuriesClosedGrumman G-164B · Hollandale, MSNTSB ATL82FKQ06Accident · 2 fatalClosedBeech 77 · Brandon, MSNTSB ATL82FKQ05Accident · No injuriesClosedCessna 177RG · Pascagoula, MSNTSB ATL82FKQ04Accident · Serious injuriesClosedTaylorcraft BL-65 · Pascagoula, MSNTSB ATL82FKQ03Accident · Serious injuriesClosedAero Cmndr 520 · Biloxi, MSNTSB ATL82FKQ01Accident · No injuriesClosedCessna 172N · Ocean Springs, MSNTSB ATL81FKQ02Accident · No injuriesClosedBellanca 14-19 · Benoit, MSNTSB ATL81FKQ29Accident · Serious injuriesClosedCessna A188B · Gore Springs, MSNTSB ATL81FKQ28Accident · No injuriesClosedCessna 182 · Batesville, MSNTSB ATL81FKQ27Accident · Minor injuriesClosedCessna 188 · Shelby, MSNTSB ATL81FKQ26Accident · No injuriesClosedCessna A188B · Cleveland, MSNTSB ATL81DKQ25Accident · No injuriesClosedGrumman G-164 · Rochdale, MSNTSB ATL81FLT13Accident · Minor injuriesClosedMooney 20C · Coldwater, MSNTSB ATL81FKQ23Accident · No injuriesClosedAir Tractor AT-301 · Charleston, MSNTSB ATL81FKQ24Accident · 1 fatalClosedPiper PA-25 · Bentonia, MSNTSB ATL81FKQ21Accident · No injuriesClosedCessna A188B · Hazlehurst, MSNTSB ATL81FKQ22Accident · No injuriesClosedPiper PA-12 · Ocean Springs, MSNTSB ATL81FKQ20Accident · 1 fatalClosedCessna 152 · Magee, MSNTSB ATL81FKQ19Accident · Serious injuriesClosedCessna A188B · Benoit, MSNTSB ATL81FA087Accident · 4 fatalClosedPiper PA-32R · Vicksburg, MSNTSB ATL81FKQ18Accident · No injuriesClosedCessna A188B · Carpenter, MSNTSB ATL81DA085Accident · No injuriesClosedBell 47G-4 · Jackson, MSNTSB ATL81FKQ16Accident · Serious injuriesClosedBeech A23 · Lyman, MSNTSB ATL81DKQ17Accident · No injuriesClosedGrumman G-164A · West Point, MSNTSB ATL81DKQ15Accident · No injuriesClosedEmair MA-1B · Webb, MSNTSB ATL81FLT11Accident · No injuriesClosedCessna 310R · Olive Branch, MSNTSB ATL81DKQ14Accident · No injuriesClosedCessna A188B · Mound Bayou, MSNTSB ATL81FKQ13Accident · Serious injuriesClosedGrum Amer AA-5A · Liberty, MSNTSB ATL81DKQ12Accident · No injuriesClosedGrumman G-164A · Holly Bluff, MSNTSB ATL81FKQ11Accident · 1 fatalClosedAyres S2R · Hollandale, MSNTSB ATL81DKQ10Accident · No injuriesClosedPiper PA-38 · Canton, MSNTSB ATL81DKQ09Accident · No injuriesClosedDassault DA-10 · Greenville, MSNTSB ATL81DKQ08Accident · Minor injuriesClosedCessna A188B · Hollandale, MSNTSB ATL81FKQ07Accident · Minor injuriesClosedTaylorcraft DL-65 · Laurel, MSNTSB ATL81FA061Accident · 1 fatalClosedCessna 188B · Hernando, MSNTSB ATL81FLT05Accident · No injuriesClosedCessna 188 · Byhalia, MSNTSB ATL81FKQ06Accident · Serious injuriesClosedAero Comdr 112 · Brookhaven, MSNTSB ATL81FKQ05Accident · Minor injuriesClosedCessna 150 · Poplarville, MSNTSB ATL81FLT04Accident · Minor injuriesClosedAir Tractor AT-301 · Crenshaw, MSNTSB ATL81FLT03Accident · No injuriesClosedPiper PA-28 · Olive Branch, MSNTSB ATL81FA036Accident · 1 fatalClosedSchleicher ASW-20 · Bay St Louis, MSNTSB ATL81FK004Accident · No injuriesClosedPiper PA-38 · Tylertown, MSNTSB ATL81FKQ03Accident · Serious injuriesClosedAeronca 7BCM · Greenwood, MS