NTSB investigations, 1974, MO
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 | 21 |
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\") = 1974
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") = 1974 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 MKC75AK033Accident · 3 fatalClosedPiper PA-28 · Swedeborg, MONTSB MKC75FCG25Accident · No injuriesClosedAero Comdr 560 · Lees Summit, MONTSB MKC75FCG23Accident · Serious injuriesClosedErco 415-D · Sedalia, MONTSB MKC75FCG26Accident · No injuriesClosedPiper PA-30 · Bolivar, MONTSB MKC75AK031Accident · 2 fatalClosedPiper PA-23 · Perryville, MONTSB MKC75FCA19Accident · 1 fatalClosedAmer Avco AA1-B · Fenton, MONTSB MKC75FCG22Accident · No injuriesClosedCessna 182 · Lees Summit, MONTSB MKC75FCA17Accident · No injuriesClosedCessna 150F · Morley, MONTSB MKC75DCG21Accident · No injuriesClosedBellanca 8GCBC · Carthage, MONTSB MKC75DCG19Accident · No injuriesClosedCessna 150 · Corder, MONTSB MKC75FCA16Accident · No injuriesClosedMooney M20E · Vichy, MONTSB MKC75FCA15Accident · No injuriesClosedBeech E18S · Festus, MONTSB MKC75DCG18Accident · No injuriesClosedPiper PA-32 · Boonville, MONTSB MKC75FCA14Accident · Minor injuriesClosedCessna 172 · Wellsville, MONTSB MKC75FCA13Accident · Serious injuriesClosedPiper PA-25 · Poplar Bluff, MONTSB MKC75FCG17Accident · Minor injuriesClosedCessna 210C · Clinton, MONTSB MKC75FCA11Accident · 1 fatalClosedCallair A-9 · Charleston, MONTSB MKC74FCA12Accident · No injuriesClosedAero Comdr A9B · Caruthersville, MONTSB MKC75FCG15Accident · Serious injuriesClosedCessna 172G · Eldon, MONTSB MKC75DCA10Accident · No injuriesClosedAmer Avco AA-1 · Creve Coeur, MONTSB MKC75FCG14Accident · Serious injuriesClosedPiper PA-31 · Duenweg, MONTSB MKC75DCA09Accident · No injuriesClosedCessna 172 · Montgomery Cty, MONTSB MKC74FCA06Accident · No injuriesClosedNavion A · St Charles, MONTSB MKC75FCG12Accident · Serious injuriesClosedCessna 172 · Marshfield, MONTSB MKC75AK015Accident · 2 fatalClosedCessna 150J · Kewanee, MONTSB MKC75AK009Accident · 1 fatalClosedCessna 172D · Shelbyville, MONTSB MKC75FCG07Accident · 1 fatalClosedGrumman G-164A · St Joseph, MONTSB MKC75FCA08Accident · No injuriesClosedCessna 177 · Garwood, MONTSB MKC75AK006Accident · 1 fatalClosedMaule M-4 · Lee'S Summit, MONTSB MKC75AK005Accident · 2 fatalClosedAmer Avco AA1-B · Kansas City, MONTSB MKC74FCG05Accident · No injuriesClosedCessna 210 · Kansas City, MONTSB MKC75FCG08Accident · Serious injuriesClosedPretzer MTC · Reeds Springs, MONTSB MKC75DCG03Accident · No injuriesClosedPiper PA-28 · Columbia, MONTSB MKC75FCG02Accident · Minor injuriesClosedStinson 108-3 · Harrisonville, MONTSB MKC75FCA03Case · Minor injuriesClosedCessna 182L · Fenton, MONTSB MKC75AK002Accident · 2 fatalClosedBeech 95-A55 · Holt, MONTSB MKC75DCG01Accident · No injuriesClosedCessna 172 · Strafford, MONTSB MKC75DCA04Accident · No injuriesClosedCessna 150 · Chesterfield, MONTSB MKC75DCA02Accident · No injuriesClosedCessna 170A · House Springs, MONTSB MKC75FCA05Accident · Serious injuriesClosedCessna 150L · Cuba, MONTSB MKC75FCA01Accident · No injuriesClosedPiper PA-32 · Fredericktown, MONTSB MKC75DCG04Accident · No injuriesClosedCessna 172 · Lebanon, MONTSB MKC74FCG47Accident · Serious injuriesClosedAeronca 11AC · Humphreys, MONTSB MKC74FCA29Accident · No injuriesClosedPiper PA-28 · Fenton, MONTSB MKC74DCG44Accident · No injuriesClosedCessna 172 · Columbia, MONTSB MKC74FCA27Accident · Serious injuriesClosedAeronca 7AC · Wentzville, MONTSB MKC74FCG43Accident · No injuriesClosedCessna 421 · Springfield, MONTSB MKC74DCA30Accident · No injuriesClosedPiper PA-28 · Kahoka, MONTSB MKC74DCG40Accident · No injuriesClosedCessna 120 · Monett, MONTSB MKC74FCA28Accident · Serious injuriesClosedPiper PA-25 · Sikeston, MO