NTSB investigations, 1966, 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
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\") = 1966
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") = 1966 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 MKC67A0039Accident · 3 fatalClosedMooney M20E · Hutchinson, KSNTSB MKC67D0397Accident · No injuriesClosedPiper PA-28 · Liberal, KSNTSB MKC67D0371Accident · No injuriesClosedCessna 310D · Olathe, KSNTSB MKC67D0415Accident · No injuriesClosedBeech K35 · Great Bend, KSNTSB MKC67F0387Accident · No injuriesClosedPiper PA-23 · Augusta, KSNTSB MKC67D0432Accident · No injuriesClosedMooney M20C · Wichita, KSNTSB MKC67F0420Accident · Minor injuriesClosedCessna 150 · Goddard, KSNTSB MKC67F0422Accident · No injuriesClosedCessna 150G · Manhattan, KSNTSB MKC67F0498Accident · No injuriesClosedCessna 150G · Bogue, KSNTSB MKC67D0533Accident · No injuriesClosedCessna 206 · Kansas City, KSNTSB MKC67F0424Accident · Serious injuriesClosedCessna 150F · Ft.Riley, KSNTSB MKC67D0343Accident · No injuriesClosedPiper PA-28 · Lawrence, KSNTSB MKC67D0342Accident · No injuriesClosedCessna 150 · Olathe, KSNTSB MKC67D0317Accident · No injuriesClosedCessna 180 · Basehor, KSNTSB MKC67D0285Accident · No injuriesClosedPiper J-3 · Bonner Sprgs, KSNTSB MKC67D0332Accident · No injuriesClosedPiper PA-28 · Olathe, KSNTSB MKC67D0348Accident · No injuriesClosedBeech A23 · Hutchinson, KSNTSB MKC67D0316Accident · No injuriesClosedPiper PA-24 · Topeka, KSNTSB MKC67D0312Accident · No injuriesClosedBeech A23 · Garden City, KSNTSB MKC67D0305Accident · No injuriesClosedCessna 150 · Cheney, KSNTSB MKC67D0599Accident · No injuriesClosedCessna 310F · Salina, KSNTSB MKC67D0324Accident · No injuriesClosedMooney M20E · Wallace, KSNTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSNTSB MKC67D0331Accident · No injuriesClosedMooney M20 · Ottawa, KSNTSB MKC67D0253Accident · No injuriesClosedMooney M20C · Dexter, KSNTSB MKC67D0250Accident · No injuriesClosedBeech P35 · Wichita, KSNTSB MKC67F0323Accident · Serious injuriesClosedBeech A23-24 · Augusta, KSNTSB MKC67F0258Accident · Serious injuriesClosedPiper PA-24 · Kingman, KSNTSB MKC67F0300Accident · No injuriesClosedBeech 23 · Burden, KSNTSB MKC67D0025Accident · No injuriesClosedCessna 210B · Liberal, KSNTSB MKC67A0028Accident · 2 fatalClosedMooney M20E · Spring Hill, KSNTSB MKC68F0331Accident · No injuriesClosedBeech 95-55 · Great Bend, KSNTSB MKC67F0283Accident · No injuriesClosedBeech 23 · Lawrence, KSNTSB MKC67F0245Accident · No injuriesClosedPiper PA-28 · Dodge City, KSNTSB MKC67F0228Accident · Minor injuriesClosedChampion 7ECA · Stanley, KSNTSB MKC67F0221Accident · Serious injuriesClosedCessna 195 · Hutchinson, KSNTSB MKC67F0248Accident · No injuriesClosedBeech B35 · Ottawa, KSNTSB MKC67D0264Accident · No injuriesClosedPiper PA-28 · Wellington, KSNTSB MKC67D0230Accident · Minor injuriesClosedCessna 172 · Caldwell, KSNTSB MKC67F0217Accident · No injuriesClosedAeronca 65-LA · Rose Hill, KSNTSB MKC67D0220Accident · Minor injuriesClosedCessna 150 · Brewster, KSNTSB MKC67D0212Accident · No injuriesClosedCessna 175 · Ashland, KSNTSB MKC67F0206Accident · No injuriesClosedBeech 35 · Toronto, KSNTSB MKC67D0268Accident · No injuriesClosedPiper PA-22 · Larned, KSNTSB MKC67A0021Accident · 3 fatalClosedPiper PA-28 · Kansas City, KSNTSB MKC67F0180Accident · No injuriesClosedMooney M20 · Wichita, KSNTSB MKC68D0322Accident · No injuriesClosedBeech A-23A · Garden City, KSNTSB MKC67D0150Accident · No injuriesClosedMooney M20C · Winona, KSNTSB MKC67D0232Accident · No injuriesClosedCessna 150E · Hays, KSNTSB MKC67D0227Accident · No injuriesClosedCessna 150 · Wellington, KS