NTSB investigations, 1973, KS
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1973
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") = 1973 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 MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSNTSB MKC74DCQ21Accident · No injuriesClosedCessna 177 · Great Bend, KSNTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSNTSB MKC74AK033Accident · 2 fatalClosedCessna 310L · Manhattan, KSNTSB MKC74FCQ20Accident · Serious injuriesClosedCessna 182 · Manhattan, KSNTSB MKC74DCQ19Accident · No injuriesClosedCessna 190 · Bennington, KSNTSB MKC74FCG14Accident · Minor injuriesClosedLuscombe T8-F · Lenexa, KSNTSB MKC74FER23Accident · Serious injuriesClosedBeech V35B · St Paul, KSNTSB MKC74FCQ17Accident · No injuriesClosedPiper PA-24 · Larned, KSNTSB MKC74AK024Accident · No injuriesClosedPiper PA-32 · Topeka, KSNTSB MKC74FCQ18Accident · No injuriesClosedPiper PA-23 · Colby, KSNTSB MKC74DCQ16Accident · No injuriesClosedPiper PA-23 · Salina, KSNTSB MKC74AK019Accident · 1 fatalClosedBoeing B75N1 · Spring Hill, KSNTSB MKC74FCG13Accident · No injuriesClosedBeech TC-45J · Lawrence, KSNTSB MKC74DCQ15Accident · No injuriesClosedBoeing A75 · Plains, KSNTSB MKC74AK017Accident · 1 fatalClosedMooney M20E · Cassoday, KSNTSB MKC74DCQ14Accident · No injuriesClosedCessna 172 · Inman, KSNTSB MKC74AK010Accident · 4 fatalClosedCessna 182B · Leawood, KSNTSB MKC74DCQ13Accident · No injuriesClosedSmith Trmite · Goodland, KSNTSB MKC74DCQ12Accident · No injuriesClosedPiper PA-25 · Almena, KSNTSB MKC74AK009Accident · 1 fatalClosedLuscombe 8E · Harper, KSNTSB MKC74AK008Accident · 1 fatalClosedCessna 150J · Emporia, KSNTSB MKC74DCQ10Accident · No injuriesClosedPiper PA-28 · Hays, KSNTSB MKC74DCQ09Accident · No injuriesClosedCessna 140 · Goodland, KSNTSB MKC74DCQ08Accident · No injuriesClosedMooney M20E · Hugoton, KSNTSB MKC74FCQ07Accident · Serious injuriesClosedBeech B19 · Wichita, KSNTSB MKC74DCQ06Accident · No injuriesClosedCessna 188 · Lakin, KSNTSB MKC74DCQ05Accident · No injuriesClosedCessna 210J · Johnson, KSNTSB MKC74FCQ11Accident · No injuriesClosedBoeing A75L · Ingalls, KSNTSB MKC74FCQ04Accident · Serious injuriesClosedFairchild M62C · Garden City, KSNTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSNTSB MKC74DCQ03Accident · Minor injuriesClosedPiper PA-25 · Grove, KSNTSB MKC74DCQ01Accident · No injuriesClosedCessna 188A · Sublette, KSNTSB MKC73DCQ38Accident · No injuriesClosedCessna 188 · North Fowler, KSNTSB MKC73FCQ36Accident · No injuriesClosedHughes 369HS · Wichita, KSNTSB MKC73DCQ37Accident · No injuriesClosedCessna 172D · Councl Grove, KSNTSB MKC73DCQ35Accident · No injuriesClosedAeronca 7AC · Hunter, KSNTSB MKC73DCG48Accident · Minor injuriesClosedBoeing B75N1 · Garnett, KSNTSB MKC73AK071Accident · 1 fatalClosedBeech 95-B55 · Wichita, KSNTSB MKC73AK069Accident · 1 fatalClosedBeech B35 · Mulvane, KSNTSB MKC73FCG42Accident · No injuriesClosedTaylorcraft BL-65 · Leavenworth, KSNTSB MKC73DCQ33Accident · No injuriesClosedPiper PA-28 · Marysville, KSNTSB MKC73DCQ32Accident · No injuriesClosedCessna 182A · Yates Center, KSNTSB MKC73FCQ34Accident · No injuriesClosedCessna 182L · Scandia, KSNTSB MKC73FCG41Accident · Serious injuriesClosedPiper PA-28 · Burlington, KSNTSB MKC73AK067Accident · No injuriesClosedCessna 182P · Yates Center, KSNTSB MKC73DCQ31Accident · No injuriesClosedGrumman G-164A · Mccune, KSNTSB MKC73FCQ30Accident · Serious injuriesClosedPiper PA-25 · Meade, KSNTSB MKC73AK066Accident · 4 fatalClosedBeech E90 · Pratt, KSNTSB MKC73DCQ29Accident · Minor injuriesClosedBoeing A75N1 · Pittsburg, KS