NTSB investigations, 1981, MO
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
| 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\") = 1981
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") = 1981 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 MKC82FCG16Accident · Minor injuriesClosedCessna 150F · Independence, MONTSB MKC82FCA07Accident · No injuriesClosedBrantly B-2 · Kennett, MONTSB MKC82FA014Accident · 2 fatalClosedPiper PA-28 · Hedrick, MONTSB MKC82DCG13Accident · Minor injuriesClosedPiper PA-28 · St.Joseph, MONTSB MKC82DCA06Accident · No injuriesClosedCessna 150M · Lutesville, MONTSB MKC82FA011Accident · No injuriesClosedCessna 172 · Kansas City, MONTSB MKC82DCG10Accident · No injuriesClosedMustang II · Kearney, MONTSB MKC82DCG12Accident · No injuriesClosedPiper PA-28 · Willow Spgs, MONTSB MKC82FCG09Accident · No injuriesClosedBeech V35 · East Lynne, MONTSB MKC82DCG07Accident · Minor injuriesClosedVolksplane VP-1 · St Joseph, MONTSB MKC82DCA05Accident · No injuriesClosedCessna 172D · Jefferson City, MONTSB MKC82FCA04Accident · No injuriesClosedCessna 182Q · Eunice, MONTSB MKC82FCG08Accident · Minor injuriesClosedBeech J35 · Sedalia, MONTSB MKC82FCA03Accident · No injuriesClosedLuscombe 8A · Bunker, MONTSB MKC82FA005Accident · 1 fatalClosedPitts SPL · Oak Grove, MONTSB MKC82FCG06Accident · Minor injuriesClosedPiper PA-28R · Macomb, MONTSB MKC82FCG05Accident · Minor injuriesClosedCessna 150M · Eldon, MONTSB MKC82FCA02Accident · Minor injuriesClosedCessna 172 · Piedmont, MONTSB MKC82FA004Accident · 2 fatalClosedBeech G33 · Rushville, MONTSB MKC82FCG03Accident · Minor injuriesClosedBensen B-8 · Joplin, MONTSB MKC82DA002Accident · No injuriesClosedBoeing 727 · St Louis, MONTSB MKC82DCG02Accident · No injuriesClosedPiper PA-38 · Forsyth, MONTSB MKC82DCG01Accident · No injuriesClosedCessna 152 · Point Lookout, MONTSB MKC81FCA01Accident · No injuriesClosedPiper PA-38 · Chesterfield, MONTSB MKC81DCA26Accident · No injuriesClosedPiper PA-38 · Poplar Bluff, MONTSB MKC81FCG56Accident · No injuriesClosedCessna 152 · Liberty, MONTSB MKC81DCG57Accident · No injuriesClosedMooney M20C · Brookfield, MONTSB MKC81DCA25Accident · No injuriesClosedCessna 152 · Rollo, MONTSB MKC81FA052Accident · Serious injuriesClosedPiper PA-38 · Clinton, MONTSB MKC81FCG54Accident · No injuriesClosedRockwell 114 · Warrensburg, MONTSB MKC81FA051Accident · No injuriesClosedDouglas DC-9 · St.Louis, MONTSB MKC81FCA23Accident · No injuriesClosedGrumman AA-5B · Wentzville, MONTSB MKC81FCA22Accident · No injuriesClosedGrumman G-164A · Fisk, MONTSB MKC81FA048Accident · 4 fatalClosedPiper PA-28 · Kirksville, MONTSB MKC81FCA21Accident · No injuriesClosedCessna 172 · Fenton, MONTSB MKC81FA046Accident · 1 fatalClosedBensen B-8M · Columbia, MONTSB MKC81FCA24Accident · No injuriesClosedMooney M20F · Licking, MONTSB MKC81FA045Accident · 1 fatalClosedPietenpol A'CAMP · Emma, MONTSB MKC81DCG52Accident · No injuriesClosedCessna 150 · Lees Summit, MONTSB MKC81DCA20Accident · No injuriesClosedGrumman G-164A · Fagus, MONTSB MKC81DCG48Accident · Minor injuriesClosedPiper PA-28 · Trenton, MONTSB MKC81DCA18Accident · No injuriesClosedCessna 182P · Kahoka, MONTSB MKC81FCG50Accident · No injuriesClosedCessna 152 · Liberty, MONTSB MKC81FCA19Accident · No injuriesClosedVarga 2150A · Sullivan, MONTSB MKC81FCG49Accident · No injuriesClosedPiper PA-25 · Knob Noster, MONTSB MKC81FCG46Accident · No injuriesClosedCessna A188B · Orrick, MONTSB MKC81FCG47Accident · No injuriesClosedCessna 182 · Osage Beach, MONTSB MKC81FCG45Accident · No injuriesClosedCessna 182A · Lexington, MONTSB MKC81FA042Accident · 2 fatalClosedCessna 172G · Newburg, MONTSB MKC81FCG44Accident · No injuriesClosedPiper PA-32 · Liberty, MO