NTSB investigations, 1976, 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\") = 1976
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") = 1976 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 MKC77FA010Accident · 1 fatalClosedCessna 210L · Fenton, MONTSB MKC77FCA07Accident · No injuriesClosedCessna 182H · Monticello, MONTSB MKC77FCA06Accident · No injuriesClosedCessna 172K · Fenton, MONTSB MKC77FA006Accident · No injuriesClosedPiper PA-30B · St Louis, MONTSB MKC77FCG07Accident · No injuriesClosedCessna 182M · Grain Valley, MONTSB MKC77DCG09Accident · No injuriesClosedPiper PA-28 · Fayette, MONTSB MKC77FCA04Accident · No injuriesClosedPiper PA-28R · Chesterfield, MONTSB MKC77FCG03Accident · Minor injuriesClosedCessna 120 · Waldron, MONTSB MKC77DCG04Accident · No injuriesClosedLuscombe 8A · Carthage, MONTSB MKC77FCG01Accident · No injuriesClosedCessna 205 · Point Lookout, MONTSB MKC77FCA01Accident · No injuriesClosedHawker H HH1 · Cape Girardeau, MONTSB MKC77DCA02Accident · Minor injuriesClosedGrumman G-164 · Hayti, MONTSB MKC76FCA46Accident · No injuriesClosedCessna 140 · Vandalia, MONTSB MKC76DCG99Accident · No injuriesClosedBeech A23-19 · Clinton, MONTSB MKC76FCG98Accident · No injuriesClosedBell 47G-5 · King City, MONTSB MKC76FCA45Accident · Minor injuriesClosedCessna 177 · Creve Coewr, MONTSB MKC76AK081Accident · Serious injuriesClosedPiper PA-23 · Independence, MONTSB MKC76AK080Accident · 1 fatalClosedErco 415-C · Saint James, MONTSB MKC76DCG97Accident · No injuriesClosedCessna 210 · Kansas City, MONTSB MKC76DCG96Accident · No injuriesClosedCessna 140 · Salisbury, MONTSB MKC76FCA41Accident · No injuriesClosedPiper PA-34 · Fenton, MONTSB MKC76FCA42Accident · Minor injuriesClosedCessna 172M · Centerville, MONTSB MKC76DCA43Accident · No injuriesClosedCessna A188B · Portageville, MONTSB MKC76AK074Accident · 1 fatalClosedBeech B55 · Washington, MONTSB MKC76AK073Accident · 2 fatalClosedBell 47J-2A · Branson, MONTSB MKC76FCA40Accident · Serious injuriesClosedPiper PA-28 · Festus, MONTSB MKC76FCA39Accident · No injuriesClosedBell 47J · St Louis, MONTSB MKC76DCG94Accident · No injuriesClosedBellanca 8KCAB · Excelsior Spgs, MONTSB MKC76AK072Accident · 6 fatalClosedBeech 58 · Chillicothe, MONTSB MKC76DCA38Accident · No injuriesClosedStinson 108-2 · Cape Girardeau, MONTSB MKC76DCG93Accident · No injuriesClosedBeech B55 · Kansas City, MONTSB MKC76AK071Accident · No injuriesClosedCessna 401 · Farmington, MONTSB MKC76FCG92Accident · No injuriesClosedPiper PA-24 · Joplin, MONTSB MKC76FCG91Accident · No injuriesClosedNavion G · Springfield, MONTSB MKC76AK069Accident · 5 fatalClosedPiper PA-28R · Huntsville, MONTSB MKC76FCG89Accident · Minor injuriesClosedBeech M35 · Grain Valley, MONTSB MKC76DCA37Accident · No injuriesClosedCessna 150 · Cuba, MONTSB MKC76DCA36Accident · Serious injuriesClosedBriegleb BG-12B · Painton, MONTSB MKC76FCG88Accident · No injuriesClosedPiper J-3 · Springfield, MONTSB MKC76FCG86Accident · Serious injuriesClosedBarnes AX6 · Liberty, MONTSB MKC76FCA35Accident · Minor injuriesClosedBell 47G · Chesterfield, MONTSB MKC76DCA34Accident · No injuriesClosedCessna 177 · Fenton, MONTSB MKC76FCA33Accident · No injuriesClosedAero Comdr 680 · Bunker, MONTSB MKC76DCA32Accident · No injuriesClosedGrumman G-164A · Fisk, MONTSB MKC76FCG85Accident · Serious injuriesClosedCessna 177 · Eldon, MONTSB MKC76DCA30Accident · Minor injuriesClosedCessna 182 · Belleview, MONTSB MKC76FCG83Accident · No injuriesClosedPiper PA-22 · Carthage, MONTSB MKC76FCA31Accident · Serious injuriesClosedEnstrom F-28A · Lutesville, MONTSB MKC76FCG80Accident · Minor injuriesClosedCessna 172L · Lees Summit, MONTSB MKC76DCG82Accident · No injuriesClosedPiper PA-28 · Lamar, MO