NTSB investigations, 1973, MO
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
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 118 |
| 1965 | 136 |
| 1966 | 155 |
| 1967 | 173 |
| 1968 | 100 |
| 1969 | 83 |
| 1970 | 111 |
| 1971 | 112 |
| 1972 | 80 |
| 1973 | 80 |
| 1974 | 80 |
| 1975 | 98 |
| 1976 | 101 |
| 1977 | 96 |
| 1978 | 111 |
| 1979 | 100 |
| 1980 | 85 |
| 1981 | 95 |
| 1982 | 86 |
| 1983 | 84 |
| 1984 | 74 |
| 1985 | 72 |
| 1986 | 54 |
| 1987 | 59 |
| 1988 | 67 |
| 1989 | 47 |
| 1990 | 41 |
| 1991 | 37 |
| 1992 | 40 |
| 1993 | 58 |
| 1994 | 47 |
| 1995 | 39 |
| 1996 | 28 |
| 1997 | 33 |
| 1998 | 29 |
| 1999 | 43 |
| 2000 | 31 |
| 2001 | 33 |
| 2002 | 30 |
| 2003 | 30 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 27 |
| 2007 | 31 |
| 2008 | 31 |
| 2009 | 23 |
| 2010 | 23 |
| 2011 | 32 |
| 2012 | 33 |
| 2013 | 21 |
| 2014 | 19 |
| 2015 | 31 |
| 2016 | 29 |
| 2017 | 28 |
| 2018 | 22 |
| 2019 | 20 |
| 2020 | 24 |
| 2021 | 15 |
| 2022 | 19 |
| 2023 | 25 |
| 2024 | 22 |
| 2025 | 19 |
| 2026 | 20 |
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\") = 1973
AND c.\"eventStateOrRegion\" = 'MO' 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") = 1973 AND c."eventStateOrRegion" = 'MO' 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 MKC74AK036Accident · No injuriesClosedDouglas DC-3 · Springfield, MONTSB MKC74AK031Accident · 1 fatalClosedBeech 95-B55 · Willow Springs, MONTSB MKC74AK030Accident · 1 fatalClosedBeech A45 · Cabool, MONTSB MKC74AK029Accident · 1 fatalClosedPiper PA-28 · Cuba, MONTSB MKC74DCG15Accident · No injuriesClosedAeronca 11AC · Ava, MONTSB MKC74IK026Incident · No injuriesClosedPiper PA-32 · Readsville, MONTSB MKC74DCA17Accident · No injuriesClosedCessna 182P · Chesterfield, MONTSB MKC74AK025Accident · 2 fatalClosedPiper PA-28R · Columbia, MONTSB MKC74AK020Accident · No injuriesClosedCurtis-Wrt C-46F · St.Louis, MONTSB MKC74FCA15Accident · No injuriesClosedBeech E18S · F.Leonard Wood, MONTSB MKC74FCA16Accident · Serious injuriesClosedPiper PA-32 · Rolla, MONTSB MKC74DCA13Accident · No injuriesClosedCessna 150F · Matthews, MONTSB MKC74FCA14Accident · No injuriesClosedCessna 172M · Shelbyville, MONTSB MKC74FCA12Accident · No injuriesClosedBell 47G-5 · Creve Coeur, MONTSB MKC74DCA11Accident · No injuriesClosedGrumman G-164 · Charleston, MONTSB MKC74AK015Accident · 1 fatalClosedPiper PA-18 · Kennett, MONTSB MKC74FCA10Accident · No injuriesClosedGrumman G-164A · Charleston, MONTSB MKC74DCG12Accident · No injuriesClosedCessna 180 · Kansas City, MONTSB MKC74FCG10Accident · Serious injuriesClosedMiniplane B-1 · Independence, MONTSB MKC74FCA08Accident · No injuriesClosedStinson 108-2 · Kennett, MONTSB MKC74DCG11Accident · No injuriesClosedLuscombe 8F · Lees Summit, MONTSB MKC74FCA07Accident · No injuriesClosedChampion 7ECA · Painton, MONTSB MKC74FCA06Accident · No injuriesClosedBeech E18S · St Louis, MONTSB MKC74AK007Accident · No injuriesClosedPiper PA-30 · Kansas City, MONTSB MKC74FGG09Accident · 1 fatalClosedBensen B8 · Windsor, MONTSB MKC74FCG06Accident · Minor injuriesClosedBell 47G-2 · Branson, MONTSB MKC74FCG07Accident · No injuriesClosedCessna 140 · Kansas City, MONTSB MKC74FCA09Accident · No injuriesClosedBoeing A75N1 · Creve Coeur, MONTSB MKC74DCA05Accident · No injuriesClosedCessna 120 · House Springs, MONTSB MKC74DCA04Accident · No injuriesClosedBoeing A75 · Hannibal, MONTSB MKC74FCG05Accident · No injuriesClosedBeech A35 · Sedalia, MONTSB MKC74FCA03Accident · Minor injuriesClosedMooney M20E · Fenton, MONTSB MKC74AKO03Accident · 4 fatalClosedBellanca 14-19 · Kansas City, MONTSB MKC74DCA01Accident · No injuriesClosedLuscombe 8F · Festus, MONTSB MKC74FCG04Accident · Serious injuriesClosedCessna 310 · Osage Beech, MONTSB DEN74AD004Accident · Serious injuriesClosedBoeing 737 · St.Louis, MONTSB MKC74FCG02Accident · No injuriesClosedBoeing A75N1 · Kansas City, MONTSB DCA74AZ003Accident · 38 fatalClosedFairchild FH227B · St.Louis, MONTSB MKC74DCG03Accident · No injuriesClosedCessna 207 · Kansas City, MONTSB MKC74FCA02Accident · Minor injuriesClosedPiper PA-30 · Summersville, MONTSB MKC74FCG08Accident · Serious injuriesClosedPiper PA-25 · Clifton Hill, MONTSB MKC74FCG01Accident · No injuriesClosedAero Comdr 100 · Missouri City, MONTSB MKC73FCA30Accident · Minor injuriesClosedBell 47G-5 · St Louis, MONTSB MKC73DCA29Accident · No injuriesClosedChampion 7KCAB · Houston, MONTSB MKC73DCG50Accident · No injuriesClosedCessna 150 · Marshall, MONTSB MKC73AK074Accident · 2 fatalClosedAmer Avco AA1-B · Kansas City, MONTSB MKC73FCG49Accident · Serious injuriesClosedAeronca L-3 · Branson, MONTSB MKC73DCG53Accident · Minor injuriesClosedSchweizer 1-23H · Grain Valley, MONTSB MKC73DCG49Accident · No injuriesClosedN.American Navion · Independence, MONTSB MKC73DCG51Accident · No injuriesClosedCessna 150 · Strafford, MO