NTSB investigations, 1971, 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\") = 1971
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") = 1971 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 MKC72AK042Accident · Serious injuriesClosedBoeing 727 · Kansas City, MONTSB CHI72AC054Accident · 2 fatalClosedPiper PA-30 · Chesterfield, MONTSB MKC72AK035Accident · 2 fatalClosedPiper PA-28 · Success, MONTSB MKC72FCA18Accident · Serious injuriesClosedPiper PA-30 · Scott City, MONTSB MKC72AK032Accident · 2 fatalClosedPiper PA-28 · Rutledge, MONTSB MKC72AK031Accident · 4 fatalClosedBeech H35 · Bland, MONTSB MKC72FCA17Accident · No injuriesClosedCessna 172K · Fenton, MONTSB MKC72FCA16Accident · No injuriesClosedN.American SNJ-4 · Chesterfield, MONTSB MKC72DCG23Accident · No injuriesClosedPiper PA-24 · Joplin, MONTSB MKC72DCA14Accident · No injuriesClosedBeech H18 · Bonne Terre, MONTSB MKC72DCA13Accident · No injuriesClosedPiper PA-22 · Vichy, MONTSB MKC72FCA11Accident · No injuriesClosedCessna 150B · Creve Coeur, MONTSB MKC72DCA15Accident · No injuriesClosedCessna 182 · Jefferson City, MONTSB MKC72DCG30Accident · No injuriesClosedN. American SNJ-5 · Grain Valley, MONTSB MKC72FCG31Accident · No injuriesClosedPiper PA-22 · Buffalo, MONTSB MKC72FCA12Accident · No injuriesClosedCessna 182H · Dexter, MONTSB MKC72FCG24Accident · No injuriesClosedBeech B35A · Warrensburg, MONTSB MKC72AK025Accident · 1 fatalClosedCessna 150L · Stover, MONTSB MKC72DCG27Accident · Minor injuriesClosedAero Comdr 100 · Grain Valley, MONTSB MKC72DCG25Accident · No injuriesClosedCessna 140 · Independence, MONTSB MKC72DCA09Accident · No injuriesClosedPiper PA-25 · Kewanee, MONTSB MKC72FCA10Accident · No injuriesClosedAero Comdr A-9B · Clarkton, MONTSB MKC72AK024Accident · 2 fatalClosedNavion A · Macon, MONTSB MKC72DCG32Accident · No injuriesClosedCessna 310D · Lamar, MONTSB MKC72DCG23Accident · No injuriesClosedHelio Acft H-550A · Nevada, MONTSB MKC72DCG28Accident · No injuriesClosedLuscombe 8E · Waldron, MONTSB MKC72FCG20Accident · No injuriesClosedPiper PA-32 · Boonville, MONTSB MKC72FCG16Accident · Serious injuriesClosedGlobe GC-1B · Brunswick, MONTSB MKC72DCG19Accident · No injuriesClosedPiper PA-22 · Brookfield, MONTSB MKC72FCG22Accident · No injuriesClosedCessna 310N · Mound City, MONTSB MKC72FCG17Accident · Serious injuriesClosedStinson 108-3 · Amazonia, MONTSB MKC72FCG18Accident · No injuriesClosedCessna 206A · Richmond, MONTSB MKC72FCG15Accident · No injuriesClosedPiper PA-18 · Lexington, MONTSB MKC72DCA06Accident · No injuriesClosedCessna 150C · Poplar Bluff, MONTSB MKC72FCA07Accident · No injuriesClosedPiper PA-28 · Augusta, MONTSB MKC72FCG14Accident · Serious injuriesClosedCessna 210F · Bolivar, MONTSB MKC72DCA05Accident · No injuriesClosedCessna 150J · Ft Leonard Wd, MONTSB MKC72FCG12Accident · No injuriesClosedCessna 310K · New Boston, MONTSB MKC72FCG11Accident · Minor injuriesClosedHiller UH-12A · Springfield, MONTSB CHI72FEV09Accident · No injuriesClosedPiper PA-25 · Perryville, MONTSB MKC72DCG10Accident · No injuriesClosedPiper PA-28 · Osage City, MONTSB MKC72DCA03Accident · No injuriesClosedAero Comdr A9B · Fulton, MONTSB MKC72IK008Incident · Serious injuriesClosedBell 47G · St Louis, MONTSB MKC72DCG13Accident · Minor injuriesClosedPiper PA-12 · Chariton, MONTSB MKC72FCG09Accident · No injuriesClosedMong Sport MS-2-K · Grain Valley, MONTSB MKC72FCA04Accident · No injuriesClosedBoeing E75N1 · St.Charles, MONTSB MKC72DCG08Accident · No injuriesClosedCessna 170A · Gainsville, MONTSB MKC72FCG07Accident · Serious injuriesClosedPiper PA-28 · Stockton, MONTSB MKC72FCA02Accident · 1 fatalClosedPiper PA-25 · Old Monroe, MONTSB MKC72IK006Incident · No injuriesClosedLockheed T-33 · R.Gebaur Afb, MO