NTSB investigations, 2001, 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
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\") = 2001
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") = 2001 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 CHI02FA059Accident · 2 fatalField investigationFinal reportBorgman Smyth Sidewinder · Independence, KSThe pilot's failure to maintain control of the airplane and the subsequent inadvertant stall during the base to final turn. A factor associated with the accident was that an unqualified person was piloting the airplane.NTSB CHI02LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Olathe, KSThe pilot's failure to maintain directional control during landing resulting in the overload of the nose gear fork. The overload failure of the nose landing gear fork, the embankment, and the remedial action not possible were contributing factors.NTSB CHI02LA047Accident · No injuriesLimited investigationFinal reportDassault Falcon 100 · Lawrence, KSThe copilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the copilot's improper in-flight decision not to execute a go-around, the copilot not performing a go-around, the inadequate crew coordination prior…NTSB CHI02FA034Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spearville, KSthe pilot's failure to maintain aircraft control and his inadvertent flight into known adverse weather conditions. Factors relating to this accident were the pilot's limited ability to see at night, spatial disorientation, the dark night, and the fog.NTSB CHI02LA002Accident · No injuriesLimited investigationFinal reportWorner 1000 STU · Liberal, KSThe pilot's inadvertent flight into adverse weather conditions during cruise flight and the unsuitable landing area encountered during the uncontrolled descent. Factors relating to this accident were the high wind, the pilot's unsuccessful attempt to…NTSB CHI01LA307Accident · No injuriesLimited investigationFinal reportCessna 182RG · Manhattan, KSthe instructor pilot allowing an excessive descent rate to develop and not correcting the excessive descent rate.NTSB CHI01FA291Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Crestline, KSThe airplane's departure from level flight and subsequent impact with the terrain as a result of a maneuver initiated by the pilot, and the pilot's failure to maintain clearance from the terrain. The reason for the pilot's actions were not determined.NTSB CHI01LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ellinwood, KSThe pilot failed to see and avoid the guy wire during an aerial application flight. A factor associated with the accident was the guy wire.NTSB CHI01LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Randolph, KSThe unsuitable terrain encountered by the pilot during the forced landing. Factors to the accident were the loss of engine power for undetermined reasons and the rough/uneven terrain condition.NTSB CHI01MA163Accident · Serious injuriesMajor investigationFinal reportLearjet 25D · Salina, KSThe PIC's delayed remedial action during the elevator system oscillation, resulting in the failure of the aft elevator sector clevis due to reverse bending fatigue caused by vibration, and subsequent loss of elevator control. Factors contributing to the…NTSB CHI01LA137Accident · 1 fatalLimited investigationFinal reportBellanca 14-13-3 · Scott City, KSThe low level roll maneuver the pilot performed on final to runway 17 and his not maintaining clearance from terrain during the maneuver.NTSB CHI01FA130Accident · 2 fatalField investigationFinal reportCessna 172N · Wichita, KSthe student pilot not maintaining clearance from the tower support wire during the practice emergency landing maneuver and the instructor pilot's inadequate supervision of the student pilot. Factors relating to the accident were the static wire and the low…NTSB CHI01LA101Accident · No injuriesLimited investigationFinal reportCessna P206 · Derby, KSThe misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.NTSB CHI01FA067Accident · 2 fatalField investigationFinal reportCessna 182B · Piedmont, KSThe pilot's failure to maintain obstacle clearance. Contributing factors were low altitude maneuvering and the transmission wire.