NTSB investigations, 1981, KS
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
| 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\") = 1981
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") = 1981 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 MKC82FCG15Accident · Serious injuriesClosedVarga 2150A · Topeka, KSNTSB MKC82FCG14Accident · No injuriesClosedCessna 421C · Olathe, KSNTSB MKC82FA012Accident · 2 fatalClosedCessna 172N · Hillsboro, KSNTSB MKC82DCQ07Accident · No injuriesClosedPiper PA-28 · Moscow, KSNTSB MKC82DCQ06Accident · No injuriesClosedCessna 182 · Garden City, KSNTSB MKC82FA009Accident · 5 fatalClosedCessna 177A · Ellinwood, KSNTSB MKC82FCG11Accident · Serious injuriesClosedCessna 182P · Olathe, KSNTSB MKC82DCQ05Accident · No injuriesClosedCessna 182 · Yates Center, KSNTSB MKC82DCQ04Accident · No injuriesClosedCessna P210N · Fort Scott, KSNTSB MKC82DCQ03Accident · No injuriesClosedPiper PA-24 · Wichita, KSNTSB MKC82FCG04Accident · No injuriesClosedPiper PA-28R · Kansas City, KSNTSB MKC82DCQ02Accident · No injuriesClosedPiper PA-23 · Goodland, KSNTSB MKC82FCQ01Accident · Minor injuriesClosedBeech M35 · Garden City, KSNTSB MKC81DCQ51Accident · No injuriesClosedCessna 152 · Hays, KSNTSB MKC81FA053Accident · 4 fatalClosedAero Comdr 685 · Kansas City, KSNTSB MKC81FCQ48Accident · Minor injuriesClosedCessna T210N · Wichita, KSNTSB MKC81FCQ49Accident · Minor injuriesClosedCessna 177RG · Leoti, KSNTSB MKC81DCQ50Accident · No injuriesClosedPiper PA-25 · Ness City, KSNTSB MKC81FCG53Accident · Serious injuriesClosedFlybaby 1A-BIS · Paola, KSNTSB MKC81DCQ47Accident · No injuriesClosedSpartan 7W · Phillipsburg, KSNTSB MKC81DA047Accident · 1 fatalClosedPitts S-1 · Dodge City, KSNTSB MKC81FA043Accident · 4 fatalClosedBeech 58TC · Kansas City, KSNTSB MKC81FCG51Accident · No injuriesClosedCessna 210J · Olathe, KSNTSB MKC81DCQ46Accident · No injuriesClosedCessna 150 · Coldwater, KSNTSB MKC81DCQ45Accident · No injuriesClosedPiper PA-22 · Moran, KSNTSB MKC81FA040Accident · 1 fatalClosedCessna 404 · Belton, KSNTSB MKC81FCG41Accident · No injuriesClosedTravel Air D4D · Kansas City, KSNTSB MKC81DCQ44Accident · No injuriesClosedBeech C23 · Fowler, KSNTSB MKC81DCQ43Accident · No injuriesClosedBell 47G-2 · Sublette, KSNTSB MKC81FCQ42Accident · No injuriesClosedCessna U206C · Wichita, KSNTSB MKC81FCG39Accident · No injuriesClosedCessna 182Q · Paola, KSNTSB MKC81DCQ41Accident · Minor injuriesClosedGrumman AA-5A · Beaumont, KSNTSB MKC81DCQ40Accident · No injuriesClosedCessna A152 · Eldorado, KSNTSB MKC81FCQ39Accident · No injuriesClosedPiper PA-24 · Emporia, KSNTSB MKC81FCQ35Accident · Minor injuriesClosedStinson 108-2 · Valley Center, KSNTSB MKC81DCQ37Accident · No injuriesClosedCessna 172L · Sublette, KSNTSB MKC81DCQ36Accident · No injuriesClosedCessna A188-B · Murdock, KSNTSB MKC81FCQ38Accident · No injuriesClosedCessna 180 · Mankato, KSNTSB MKC81FA037Accident · Minor injuriesClosedCessna 210N · Olathe, KSNTSB MKC81FCQ34Accident · Minor injuriesClosedCessna 177RG · Newton, KSNTSB MKC81FA036Accident · 2 fatalClosedCessna 172 · Carbondale, KSNTSB MKC81DCQ33Accident · Serious injuriesClosedPiper PA-25 · Ingalls, KSNTSB MKC81DCQ31Accident · No injuriesClosedCessna 172 · Manhattan, KSNTSB MKC81DCQ32Accident · No injuriesClosedPitts S-1S · Conway Springs, KSNTSB MKC81FCQ30Accident · No injuriesClosedCessna 188 · Selden, KSNTSB MKC81FCQ29Accident · Serious injuriesClosedCessna 172 · Cullison, KSNTSB MKC81FCQ28Accident · 1 fatalClosedAyers S2R-34 · Hillsboro, KSNTSB MKC81FCQ27Accident · Serious injuriesClosedCessna 188B · Roxbury, KSNTSB MKC81FCQ25Accident · Minor injuriesClosedCessna A188B · Mcpherson, KSNTSB MKC81DCQ26Accident · No injuriesClosedCessna 182 · Moundridge, KS