NTSB investigations, 1970, KS
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1970
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") = 1970 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 MKC71DCG37Accident · No injuriesClosedPiper PA-16 · Topeka, KSNTSB MKC71AK033Accident · 3 fatalClosedCessna 172 · Garden City, KSNTSB MKC71DCQ25Accident · No injuriesClosedLuscombe 8E · Hugoton, KSNTSB DEN71ID027Incident · No injuriesClosedBoeing 747 · Hill City, KSNTSB MKC71DCQ24Accident · No injuriesClosedCessna 182M · Manhattan, KSNTSB MKC71FCG34Accident · No injuriesClosedCessna 310 · Lawrence, KSNTSB MKC71AK027Accident · 2 fatalClosedRepublic F-105D · Wichita, KSNTSB MKC71FCG33Accident · No injuriesClosedErco 415-E · Gardner, KSNTSB MKC71FCG30Accident · Serious injuriesClosedBeech V35A · Kansas City, KSNTSB MKC71FCQ22Accident · No injuriesClosedCessna 172K · El Dorado, KSNTSB MKC71DCQ21Accident · No injuriesClosedCessna 180 · Sharon Sprgs, KSNTSB MKC71AK017Accident · No injuriesClosedMooney M20E · Enterprise, KSNTSB MKC71DCG27Accident · No injuriesClosedCessna 177 · Topeka, KSNTSB MKC71FCQ20Accident · No injuriesClosedSmith DSA-1 · Goodland, KSNTSB MKC71FCQ19Accident · No injuriesClosedPiper PA-17 · Hutchinson, KSNTSB MKC71AK012Accident · 2 fatalClosedCessna 150G · Stanley, KSNTSB MKC71DCQ18Accident · No injuriesClosedBrantly 305 · Emporia, KSNTSB MKC71FCQ17Accident · Minor injuriesClosedCessna A188A · Edson, KSNTSB MKC71FCG24Accident · Minor injuriesClosedBeech A23-19 · Leawood, KSNTSB MKC71DCQ16Accident · Minor injuriesClosedPiper PA-28R · Concordia, KSNTSB MKC71FCQ14Accident · No injuriesClosedPiper PA-22 · Dighton, KSNTSB MKC71FCQ15Accident · No injuriesClosedCessna 401 · Baxter Sprgs, KSNTSB MKC71DCG18Accident · No injuriesClosedBeech S35 · Topeka, KSNTSB MKC71FCG20Accident · Serious injuriesClosedSlingsby T-49B · Desoto, KSNTSB MKC71FCQ11Accident · No injuriesClosedPiper PA-25 · Friend, KSNTSB MKC71DCG15Accident · No injuriesClosedMooney M20E · Kansas City, KSNTSB MKC71FCQ10Accident · Serious injuriesClosedSchultz BB · Harper, KSNTSB MKC71AK005Accident · 2 fatalClosedPiper PA-30 · St John, KSNTSB MKC71DCQ09Accident · No injuriesClosedBeech M-23 · Bazine, KSNTSB MKC71DCQ08Accident · No injuriesClosedPiper PA-18 · Scott City, KSNTSB MKC71DCQ07Accident · No injuriesClosedNavion A · Meade, KSNTSB MKC71DCQ06Accident · No injuriesClosedCessna 172E · Lincoln, KSNTSB MKC71DCQ05Accident · No injuriesClosedBeech B-23 · Emporia, KSNTSB MKC71DCQ04Accident · No injuriesClosedCessna 172 · Clay Center, KSNTSB MKC71DCQ02Accident · No injuriesClosedBeech B23 · Wellington, KSNTSB MKC71FCG04Accident · No injuriesClosedCessna 182 · Kansas City, KSNTSB MKC71DCQ03Accident · No injuriesClosedCessna 150 · Dodge City, KSNTSB MKC71FCQ13Accident · Minor injuriesClosedNavion A · Rolla, KSNTSB MKC71AK002Accident · No injuriesClosedCessna 182L · Ottawa, KSNTSB MKC71FCQ12Accident · No injuriesClosedBeech 95-B55 · Wichita, KSNTSB MKC71FCQ01Accident · 1 fatalClosedPiper PA-25 · Harper, KSNTSB MKC70FCG35Accident · Serious injuriesClosedPiper J5A · Vinland, KSNTSB MKC70DCQ31Accident · No injuriesClosedCessna 188 · Dodge City, KSNTSB MKC70DCQ29Accident · No injuriesClosedCessna A188 · Ness City, KSNTSB MKC70DCQ27Accident · No injuriesClosedPiper J3C-65 · Sterling, KSNTSB MKC70DCQ28Accident · No injuriesClosedSnow S2A · Atwood, KSNTSB MKC70IK070Incident · No injuriesClosedBoeing 747 · Salina, KSNTSB MKC70AK069Accident · 2 fatalClosedPiper PA-28 · Lyndon, KSNTSB MKC70FCQ26Accident · No injuriesClosedPiper PA-28 · Wichita, KSNTSB MKC70FCG30Accident · Serious injuriesClosedPiper PA-25 · Holton, KS