NTSB investigations, 1965, KS
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
| 1963 | 2 |
|---|---|
| 1964 | 134 |
| 1965 | 112 |
| 1966 | 134 |
| 1967 | 136 |
| 1968 | 109 |
| 1969 | 106 |
| 1970 | 92 |
| 1971 | 91 |
| 1972 | 81 |
| 1973 | 65 |
| 1974 | 84 |
| 1975 | 84 |
| 1976 | 91 |
| 1977 | 85 |
| 1978 | 67 |
| 1979 | 83 |
| 1980 | 60 |
| 1981 | 71 |
| 1982 | 59 |
| 1983 | 63 |
| 1984 | 49 |
| 1985 | 55 |
| 1986 | 52 |
| 1987 | 35 |
| 1988 | 36 |
| 1989 | 16 |
| 1990 | 35 |
| 1991 | 28 |
| 1992 | 23 |
| 1993 | 25 |
| 1994 | 32 |
| 1995 | 33 |
| 1996 | 30 |
| 1997 | 30 |
| 1998 | 22 |
| 1999 | 32 |
| 2000 | 20 |
| 2001 | 14 |
| 2002 | 19 |
| 2003 | 20 |
| 2004 | 25 |
| 2005 | 18 |
| 2006 | 19 |
| 2007 | 24 |
| 2008 | 27 |
| 2009 | 19 |
| 2010 | 18 |
| 2011 | 15 |
| 2012 | 22 |
| 2013 | 24 |
| 2014 | 15 |
| 2015 | 24 |
| 2016 | 20 |
| 2017 | 18 |
| 2018 | 17 |
| 2019 | 19 |
| 2020 | 11 |
| 2021 | 15 |
| 2022 | 15 |
| 2023 | 21 |
| 2024 | 13 |
| 2025 | 9 |
| 2026 | 11 |
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\" = 'KS' 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" = 'KS' 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 MKC66F0336Accident · Minor injuriesClosedCessna U206 · Augusta, KSNTSB MKC66D0371Accident · No injuriesClosedMooney M20A · Kansas City, KSNTSB MKC66D0335Accident · No injuriesClosedCessna 182 · Wichita, KSNTSB MKC66D0334Accident · Minor injuriesClosedCessna 172 · Wichita, KSNTSB MKC66D0436Accident · No injuriesClosedCessna 170 · Russell, KSNTSB MKC66D0348Accident · No injuriesClosedAeronca 7AC · Lincoln, KSNTSB UNK66X0113Accident · No injuriesClosedErcoupe 415-C · Stafford, KSNTSB MKC66A0033Accident · 1 fatalClosedAeronca 11AC · Iola, KSNTSB MKC66F0309Accident · No injuriesClosedBeechcraft J35 · Salina, KSNTSB MKC66F0318Accident · Minor injuriesClosedPiper PA-22 · Salina, KSNTSB MKC66F0304Accident · No injuriesClosedLuscombe 8C · Wellington, KSNTSB MKC66F0350Accident · Serious injuriesClosedForney F-1 · Burrton, KSNTSB MKC66F0319Accident · Serious injuriesClosedGlobe GC-1B · Salina, KSNTSB MKC66F0302Accident · No injuriesClosedCessna 210 · Oakley, KSNTSB MKC66D0299Accident · No injuriesClosedPiper PA-28 · Wichita, KSNTSB MKC66F0275Accident · No injuriesClosedMooney M20C · Carbondale, KSNTSB MKC66D0310Accident · No injuriesClosedLuscombe 8A · Coffeyville, KSNTSB MKC66D0281Accident · Minor injuriesClosedCessna 140 · Holton, KSNTSB MKC66F0354Accident · No injuriesClosedPiper PA-28 · Mcpherson, KSNTSB MKC66F0264Accident · No injuriesClosedCessna 310I · Wichita, KSNTSB MKC66D0282Accident · No injuriesClosedCessna 180 · Oakley, KSNTSB MKC66A0021Accident · 1 fatalClosedCessna 188 · Wichita, KSNTSB MKC66F0232Accident · Serious injuriesClosedChampion 7FC · Bonner Sprgs, KSNTSB MKC66F0262Accident · No injuriesClosedPiper PA-24 · Wichita, KSNTSB NYC66F0224Accident · Minor injuriesClosedCessna 150F · Gardner, KSNTSB MKC66D0240Accident · No injuriesClosedCessna 140 · Castleton, KSNTSB MKC66A0017Accident · 4 fatalClosedBeechcraft B-95 · Newton, KSNTSB MKC66F0247Accident · No injuriesClosedPiper PA-22 · Atchison, KSNTSB MKC66D0274Accident · No injuriesClosedCessna 150 · Lacygne, KSNTSB MKC66F0246Accident · No injuriesClosedCallair A-5 · Munden, KSNTSB MKC66D0212Accident · No injuriesClosedCessna 180 · Maize, KSNTSB MKC66F0223Accident · No injuriesClosedBeechcraft 23 · Wichita, KSNTSB MKC66A0014Accident · 2 fatalClosedBeech M35 · Hutchinson, KSNTSB MKC66F0204Accident · No injuriesClosedStinson 108-1 · Derby, KSNTSB MKC66F0193Accident · No injuriesClosedMooney M-20 · Kingman, KSNTSB MKC66F0173Accident · No injuriesClosedCessna 210E · Wichita, KSNTSB MKC66F0177Accident · No injuriesClosedCessna 180 · Wichita, KSNTSB MKC66A0010Accident · Serious injuriesClosedBoeing B-720B · Leavenworth, KSNTSB MKC66F0167Accident · No injuriesClosedCessna 172 · Wichita, KSNTSB MKC66D0172Accident · Minor injuriesClosedCessna 210 · Ottawa, KSNTSB MKC66F0155Accident · No injuriesClosedCessna 182H · Leawood, KSNTSB MKC66F0171Accident · No injuriesClosedPiper PA-24 · Wichita, KSNTSB MKC66F0120Accident · No injuriesClosedAeronca 7DC · Hill City, KSNTSB MKC66F0110Accident · No injuriesClosedBeechcraft B-50 · Emporia, KSNTSB MKC66A0006Accident · No injuriesClosedBell 47D-1 · Wichita, KSNTSB MKC66F0143Accident · No injuriesClosedPiper PA-28 · Kansas City, KSNTSB MKC66F0109Accident · No injuriesClosedLear Jet 23 · Wichita, KSNTSB MKC66F0096Accident · No injuriesClosedCessna 210E · Mccracken, KSNTSB MKC66D0103Accident · No injuriesClosedCessna 182 · Gardner, KSNTSB MKC66F0141Accident · Minor injuriesClosedBoeing E75 · Dodge City, KS