NTSB investigations, 1964, KS
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1964
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") = 1964 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 UNK65X1160Accident · No injuriesClosedPiper PA28 · Wichita, KSNTSB UNK65X1153Accident · No injuriesClosedCessna 182 · Wichita, KSNTSB UNK65X1130Accident · No injuriesClosedErcoupe 415C · Phillipsbur, KSNTSB UNK65X1121Accident · 1 fatalClosedPiper PA-24 · Hutchinson, KSNTSB UNK65X1079Accident · No injuriesClosedCessna 337 · Wichita, KSNTSB UNK65X1074Accident · No injuriesClosedCessna 140 · Bonner Springs, KSNTSB UNK65X0993Accident · No injuriesClosedCessna 182 · Olathe, KSNTSB UNK65X0987Accident · No injuriesClosedMooney M20B · Emporia, KSNTSB UNK65X0985Accident · Minor injuriesClosedCessna 172 · Larned, KSNTSB UNK65X0983Accident · No injuriesClosedBeechcraft S35 · Plainfield, KSNTSB UNK65X0930Accident · No injuriesClosedPiper PA22 · Marquette, KSNTSB UNK65X0923Accident · No injuriesClosedPiper PA22 · Kansas City, KSNTSB UNK65X0920Accident · No injuriesClosedCessna 170B · Fall River, KSNTSB UNK65X0815Accident · Serious injuriesClosedAeronca 65TC · Salina, KSNTSB UNK65X0810Accident · No injuriesClosedBeechcraft B90 · Newton, KSNTSB UNK65X0792Accident · No injuriesClosedStinson 108 · Emporia, KSNTSB UNK65X0780Accident · No injuriesClosedPiper PA-12 · Atchison, KSNTSB UNK65X0769Accident · No injuriesClosedPiper PA-24 · Olathe, KSNTSB UNK65X0732Accident · Serious injuriesClosedLockheed L-749A · Wichita Kans, KSNTSB UNK65X0641Accident · No injuriesClosedBeechcraft K35 · Kansas City, KSNTSB UNK65X0483Accident · No injuriesClosedBeechcraft 35 · Smith Center, KSNTSB UNK65X0469Accident · No injuriesClosedLuscombe 8A · Olathe, KSNTSB UNK65X0451Accident · No injuriesClosedBeechcraft C35 · Salina, KSNTSB UNK65X0369Accident · No injuriesClosedMooney M20 · Wichita, KSNTSB UNK65X0316Accident · No injuriesClosedPiper PA22 · Topeka, KSNTSB UNK65X0304Accident · No injuriesClosedCessna 206 · Emporia, KSNTSB UNK65X0291Accident · Minor injuriesClosedPiper PA28 · Topeka, KSNTSB UNK65X0246Accident · No injuriesClosedBeechraft 35 · Sabetha, KSNTSB UNK65X0243Accident · No injuriesClosedCessna 182 · Lawrence, KSNTSB UNK65X0241Accident · No injuriesClosedCessna 172 · Windom, KSNTSB UNK65X0220Accident · No injuriesClosedPiper PA24 · Atchison, KSNTSB UNK65X0182Accident · No injuriesClosedBeechcraft 95 · Ness City, KSNTSB UNK64X4205Accident · No injuriesClosedMooney MK21 · Holsinton, KSNTSB UNK64X4190Accident · No injuriesClosedPiper PA-22 · Osage City, KSNTSB UNK64X3942Accident · No injuriesClosedCessna 140 · Bloom, KSNTSB UNK64X3875Accident · No injuriesClosedPiper PA-22 · Liberal, KSNTSB UNK64X3836Accident · Serious injuriesClosedScheibe SF26A · Phillipsburg, KSNTSB UNK64X3801Accident · No injuriesClosedBeechraft 23 · Osawatomie, KSNTSB UNK64X3796Accident · No injuriesClosedMooney M20 · Kansas City, KSNTSB UNK64X3635Accident · 2 fatalClosedCessna P206 · Wichita, KSNTSB UNK64X3628Accident · No injuriesClosedBeechcraft M23 · Liberal, KSNTSB UNK64X3580Accident · No injuriesClosedCessna 182 · Topeka, KSNTSB UNK64X3574Accident · Minor injuriesClosedCessna 170 · Hays, KSNTSB UNK64X3564Accident · Minor injuriesClosedBeechcraft F35 · Haddam, KSNTSB UNK64X3454Accident · No injuriesClosedBeechcraft M23 · Wichita, KSNTSB UNK64X3398Accident · No injuriesClosedCessna 150 · Frankfort, KSNTSB UNK64X3345Accident · No injuriesClosedPiper PA24 · Fall River, KSNTSB UNK64X3316Accident · No injuriesClosedCessna 172 · Hill City, KSNTSB UNK64X3311Accident · No injuriesClosedBell 47D1 · Rose Hill, KSNTSB UNK64X3290Accident · No injuriesClosedBeechcraft 35 · Meade Lake, KS