NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 MKC81FCQ07Accident · Minor injuriesClosedScorpion 133 · Ulysses, KSNTSB MKC81FCQ06Accident · No injuriesClosedPiper PA-28 · Wellington, KSNTSB MKC81FA010Accident · No injuriesClosedSwearingen SA226T · Kansas City, KSNTSB MKC81FCQ04Accident · No injuriesClosedPiper PA-28 · Wichita, KSNTSB MKC81FCG16Accident · No injuriesClosedBellanca 17-31 · Kansas City, KSNTSB MKC81FCQ05Accident · Minor injuriesClosedVarieze 01 · Pittsburg, KSNTSB MKC81DA011Accident · No injuriesClosedBarnes AX-7 · Topeka, KSNTSB MKC81DCQ03Accident · No injuriesClosedCassutt 3M · Liberal, KSNTSB MKC81DCQ02Accident · No injuriesClosedCessna 182A · Cedar Vale, KSNTSB MKC81FCG03Accident · No injuriesClosedBeech 58 · Olathe, KSNTSB MKC81DCQ01Accident · No injuriesClosedHelio Acft H-295 · Johnson, KSNTSB MKC81DCG01Accident · No injuriesClosedStinson 108-1 · Olathe, KSNTSB MKC80DCG48Accident · No injuriesClosedCessna 172 · Holton, KSNTSB MKC80FA058Accident · 1 fatalClosedCessna 172M · Cassoday, KSNTSB MKC80DCQ34Accident · No injuriesClosedCessna 150 · Mcpherson, KSNTSB MKC80FCG46Accident · No injuriesClosedCessna 150 · Desoto, KSNTSB MKC80FA053Accident · 2 fatalClosedTaylorcraft BC12-D · Sedan, KSNTSB MKC80DCG44Accident · No injuriesClosedBeech 95-B55 · Olathe, KSNTSB MKC80DCQ33Accident · No injuriesClosedCessna 188 · Protection, KSNTSB MKC80DCQ32Accident · No injuriesClosedCessna 172 · Wichita, KSNTSB MKC80FA052Accident · No injuriesClosedGlobe GC-1B · Benton, KSNTSB MKC80FCQ31Accident · No injuriesClosedCessna 177B · Dodge City, KSNTSB MKC80FCG42Accident · No injuriesClosedCessna 182G · Ft Leavenworth, KSNTSB MKC80DCQ30Accident · No injuriesClosedGrumman G-164B · Cimarron, KSNTSB MKC80DCG39Accident · No injuriesClosedCessna 150J · Horton, KSNTSB MKC80DCQ29Accident · No injuriesClosedCessna 172 · Hoxie, KSNTSB MKC80DCQ28Accident · No injuriesClosedVarieze 01 · Dodge City, KSNTSB MKC80DCQ27Accident · No injuriesClosedCessna 140 · El Dorado, KSNTSB MKC80DCQ26Accident · No injuriesClosedCessna 152 · Norwick, KSNTSB MKC80FCQ25Accident · 1 fatalClosedPiper PA-25 · Garden City, KSNTSB MKC80FCG34Accident · No injuriesClosedBeech 58 · Kansas City, KSNTSB MKC80DCG33Accident · No injuriesClosedRose A&M Parake · Ottawa, KSNTSB MKC80FA044Accident · No injuriesClosedCessna P210N · Winfield, KSNTSB MKC80DCQ23Accident · No injuriesClosedPiper PA-32 · Kiowa, KSNTSB MKC80DCQ24Accident · Minor injuriesClosedCessna 210P · Pratt, KSNTSB MKC80FCQ22Accident · Minor injuriesClosedCessna 150L · Mcpherson, KSNTSB MKC80DCQ21Accident · No injuriesClosedPiper PA-36 · Kanorado, KSNTSB MKC80DCQ20Accident · No injuriesClosedCessna 172 · Coldwater, KSNTSB MKC80FCQ19Accident · 1 fatalClosedBenchmark 01 · Newton, KSNTSB MKC80FA040Accident · Serious injuriesClosedCessna 337B · Olathe, KSNTSB MKC80DCG24Accident · No injuriesClosedCessna 206 · Atchinson, KSNTSB MKC80FA038Accident · 4 fatalClosedPiper PA-28 · Brookville, KSNTSB MKC80DCQ18Accident · No injuriesClosedCessna 172 · Quinter, KSNTSB MKC80DCG23Accident · No injuriesClosedPiper PA-28 · Perry, KSNTSB MKC80FA034Accident · 1 fatalClosedPitts S2S · Olathe, KSNTSB MKC80FCQ14Accident · Minor injuriesClosedBucker Jung BU131 · Colwich, KSNTSB MKC80DCQ16Accident · No injuriesClosedBeech 23 · Beaumont, KSNTSB MKC80FCQ15Accident · No injuriesClosedPiper PA-34 · Hays, KSNTSB MKC80FCQ13Accident · Serious injuriesClosedCessna A188B · Winfield, KSNTSB MKC80DCG20Accident · No injuriesClosedGrumman AA1B · Lebo, KS