NTSB investigations, 1965, MO
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1965
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") = 1965 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 MKC66D0340Accident · No injuriesClosedCessna 150 · Faucett, MONTSB MKC66F0427Accident · Serious injuriesClosedCessna 172F · Brigeton, MONTSB MKC66F0375Accident · No injuriesClosedBeech N35 · Springfield, MONTSB MKC66F0325Accident · No injuriesClosedCessna 172F · St Louis, MONTSB MKC66D0341Accident · No injuriesClosedCessna 150 · St Charles, MONTSB MKC66D0314Accident · No injuriesClosedCessna 182 · Cameron, MONTSB MKC66A0329Accident · Serious injuriesClosedPiper PA-28 · Gravois Mills, MONTSB MKC66F0320Accident · No injuriesClosedSwift GC-1B · Republic, MONTSB MKC66F0333Accident · No injuriesClosedPiper PA-22 · Cape Girardeau, MONTSB MKC66F0300Accident · No injuriesClosedMooney M20 · Napoleon, MONTSB MKC66D0357Accident · No injuriesClosedPiper PA-22 · Centerville, MONTSB MKC66F0291Accident · Minor injuriesClosedPiper PA-22 · Trenton, MONTSB MKC66F0328Accident · Minor injuriesClosedCessna 185C · Fenton, MONTSB MKC66F0283Accident · Minor injuriesClosedBeechcraft 35-33 · Marshall, MONTSB MKC66D0290Accident · No injuriesClosedCessna 172 · Reed Springs, MONTSB MKC66A0029Accident · 1 fatalClosedBeech 35 · Green City, MONTSB MKC66D0280Accident · No injuriesClosedCessna 170B · Wheton, MONTSB MKC66F0288Accident · No injuriesClosedPiper PA-22 · Boschertown, MONTSB MKC66A0026Accident · 3 fatalClosedCessna 172E · Kansas City, MONTSB MKC66D0257Accident · No injuriesClosedCessna 172 · Warrensburg, MONTSB MKC66F0389Accident · No injuriesClosedBeech E35 · Kansas City, MONTSB MKC66A0023Accident · 3 fatalClosedCessna 172C · Fulton, MONTSB MKC66A0022Accident · Serious injuriesClosedAir & Space 18A · Creve Coeur, MONTSB MKC66F0249Accident · Minor injuriesClosedBeechcraft T-34 · Dearborn, MONTSB MKC66F0268Accident · Minor injuriesClosedCessna 150 · Warrensburg, MONTSB MKC66F0258Accident · No injuriesClosedMooney M20E · Carrollton, MONTSB MKC66F0279Accident · Minor injuriesClosedCessna 150 · Bloomsdale, MONTSB MKC66F0273Accident · No injuriesClosedLockheed 12A · Kansas City, MONTSB MKC66F0252Accident · No injuriesClosedMooney M20C · Doniphan, MONTSB MKC66D0244Accident · No injuriesClosedPiper PA-23 · Springfield, MONTSB MKC66F0231Accident · No injuriesClosedPiper PA-22 · Bigelow, MONTSB MKC66A0018Accident · No injuriesClosedConvair CV-880 · Kansas City, MONTSB MKC66F0245Accident · Serious injuriesClosedTaylorcraft BC12D · Waldron, MONTSB MKC66D0289Accident · No injuriesClosedCessna 172 · Festus, MONTSB MKC66F0216Accident · No injuriesClosedCessna 182 · Chesterfield, MONTSB MKC66D0256Accident · No injuriesClosedPiper PA-28 · Sedalia, MONTSB MKC66D0220Accident · Minor injuriesClosedNavion B · Lathrop, MONTSB MKC66F0216Accident · No injuriesClosedAero Cmdr 520 · Warrensburg, MONTSB MKC66D0207Accident · No injuriesClosedCessna 210 · Branson, MONTSB MKC66D0353Accident · No injuriesClosedBeechcraft 95-B55 · Grandin, MONTSB MKC66D0185Accident · No injuriesClosedBeechcraft M-35 · Osage Beach, MONTSB MKC66F0211Accident · No injuriesClosedPiper PA-22 · Warrensburg, MONTSB MKC66F0175Accident · No injuriesClosedLuscombe 8A · Excelsior Sps, MONTSB MKC66D0156Accident · No injuriesClosedCessna 172 · Camdenton, MONTSB MKC66F0344Accident · No injuriesClosedRyan ST-3KR · Fenton, MONTSB MKC66D0154Accident · No injuriesClosedCessna 175 · Clinton, MONTSB MKC66D0202Accident · No injuriesClosedCessna 170B · Carthage, MONTSB MKC66D0138Accident · No injuriesClosedPiper PA-28 · Branson, MONTSB MKC66D0153Accident · No injuriesClosedMooney M21 · Cassville, MONTSB MKC66F0145Accident · No injuriesClosedCessna 150 · Montrose, MO