NTSB investigations, 1978, 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
Open the mapLatest 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\") = 1978
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") = 1978 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 MKC79DCQ07Accident · No injuriesClosedCessna 172 · Sedgwick, KSNTSB MKC79FCQ06Accident · No injuriesClosedMooney M20F · Cedar Point, KSNTSB MKC79DCQ05Accident · Serious injuriesClosedCessna 182 · Dighton, KSNTSB MKC79DA013Accident · Serious injuriesClosedBarnes AX-7 · Hutchinson, KSNTSB MKC79DCQ04Accident · No injuriesClosedBeech V35 · Liberal, KSNTSB MKC79FA004Accident · 2 fatalClosedBeech G18S · Hays, KSNTSB MKC79FCQ03Accident · Serious injuriesClosedPiper PA-28 · Lyons, KSNTSB MKC79FA001Accident · 4 fatalClosedBeech A23-24 · Lyndon, KSNTSB MKC79DCQ02Accident · Minor injuriesClosedPiper PA-28 · Palco, KSNTSB MKC79DA005Accident · No injuriesClosedBarnes AX-7 · Overland Park, KSNTSB MKC79FCQ01Accident · No injuriesClosedCessna 152 · Oakley, KSNTSB MKC78DA070Accident · No injuriesClosedCessna 401A · Garden City, KSNTSB MKC78FCQ39Accident · Serious injuriesClosedLuscombe 8A · Baxter Springs, KSNTSB MKC78DCG66Accident · No injuriesClosedCessna 152 · Waverly, KSNTSB MKC78FCG65Accident · No injuriesClosedPiper PA-28 · Olathe, KSNTSB MKC78DCG64Accident · No injuriesClosedCessna 152 · Olathe, KSNTSB MKC78FCQ38Accident · No injuriesClosedCessna 177RG · Wellington, KSNTSB MKC78FCG63Accident · No injuriesClosedRyan PT-22 · Hiawatha, KSNTSB MKC78DCQ37Accident · No injuriesClosedCessna 182P · Garden City, KSNTSB MKC78DCQ34Accident · No injuriesClosedCessna 188 · Oxford, KSNTSB MKC78FA063Accident · 3 fatalClosedCessna 177 · Plainville, KSNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSNTSB MKC78FCG57Accident · No injuriesClosedCessna 320 · Olathe, KSNTSB MKC78DCG55Accident · No injuriesClosedPitts S-1 · Olathe, KSNTSB MKC78FCG56Accident · No injuriesClosedCessna 175 · Leawood, KSNTSB MKC78FA059Accident · Serious injuriesClosedCessna 402A · Manhattan, KSNTSB MKC78DCQ35Accident · No injuriesClosedCessna 188 · Sharon Spring, KSNTSB MKC78FCQ33Accident · No injuriesClosedPiper PA-25 · Edson, KSNTSB MKC78DCQ32Accident · No injuriesClosedPitts S1C · Moscow, KSNTSB MKC78FCG51Accident · No injuriesClosedPitts S2A · Ottawa, KSNTSB MKC78FA056Accident · 2 fatalClosedCessna 150 · Columbus, KSNTSB MKC78FCG48Accident · No injuriesClosedCessna 182E · Olathe, KSNTSB MKC78DCG52Accident · No injuriesClosedHughes 269A · Springhill, KSNTSB MKC78DCG49Accident · Minor injuriesClosedPiper PA-22 · Severance, KSNTSB MKC78FCG41Accident · Minor injuriesClosedPiper PA-28 · Olathe, KSNTSB MKC78DCQ30Accident · No injuriesClosedUniv Acft D-16 · Valley Center, KSNTSB MKC78FCG42Accident · Serious injuriesClosedBoeing E75-N1 · Olathe, KSNTSB MKC78FCG39Accident · Serious injuriesClosedBeech A36 · Olathe, KSNTSB MKC78DCQ28Accident · Minor injuriesClosedPiper PA-28R · Smith Center, KSNTSB MKC78FCQ29Accident · No injuriesClosedPiper PA-24 · Wichita, KSNTSB MKC78FCQ27Accident · 3 fatalClosedBeech V35 · Hillsboro, KSNTSB MKC78FA047Accident · 1 fatalClosedCessna 120 · Abilene, KSNTSB MKC78FCQ26Accident · Minor injuriesClosedBell 47J-2 · Onaga, KSNTSB MKC78DCQ25Accident · Minor injuriesClosedCessna 188 · Deerfield, KSNTSB MKC78DCQ24Accident · No injuriesClosedCessna P337G · Meade, KSNTSB MKC78DA040Accident · No injuriesClosedThunder AX7-77 · Lindsborg, KSNTSB MKC78FA038Accident · 1 fatalClosedPiper PA-28 · Scott City, KSNTSB MKC78DCQ23Accident · Minor injuriesClosedBellanca 17-30A · Great Bend, KSNTSB MKC78FCG30Accident · No injuriesClosedCessna 170B · Overbrook, KSNTSB MKC78FCQ22Accident · No injuriesClosedCessna 182 · Augusta, KS