NTSB investigations, 1994, KS
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1994
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") = 1994 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 CHI95LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion Citabria 7-GCBC · Ulysses, KSthe pilots improper use of brakes during practice landings, and his lack of total experience in tail wheel equipped airplanes.NTSB CHI95LA057Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Scott City, KSthe pilot's failure to attain compensation for wind conditions. A factor was the crosswind condition.NTSB CHI95LA029Accident · No injuriesLimited investigationFinal reportHughes 269C · Garden City, KSinadvertant engagement of the rotor drive system, while the helicopter had been left unattended by the pilot.NTSB CHI95LA022Accident · No injuriesLimited investigationFinal reportCessna 210A · Manhattan, KStotal loss of engine power for reason(s) undetermined. A factor was the dark night.NTSB CHI94LA339Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, KSthe pilot's failure to maintain directional control during an aborted takeoff. A factor related to the accident was the delay in aborting the takeoffNTSB CHI94LA344Accident · No injuriesLimited investigationFinal reportPrest Eagle II · Wellsville, KSthe pilot-in-command's inadequate visual lookout.NTSB CHI94LA315Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Hanston, KSThe failure of the number two connecting rod. Factors in the accident were the fouled windshield utility wires, the road sign, and the telephone pole.NTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.NTSB CHI94LA303Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gardner, KSundetermined. A factor associated with the accident is a fence at the off-airport landing site.NTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.NTSB CHI94LA254Accident · Serious injuriesLimited investigationFinal reportBeech 33 · Wichita, KSthe pilot's inadequate management of the fuel which resulted in fuel starvation.NTSB CHI94FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Wellington, KSthe pilot's failure to maintain aircraft control during the emergency descent, resulting in a stall-spin. Factors were fuel exhaustion resulting from improper fuel calculations by the pilot.NTSB CHI94LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Tribune, KSthe pilot's failure to maintain clearance above the corn crop during the swath run.NTSB CHI94DCQ02Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Colby, KSfuel starvation resulting from the fuel shutoff valve closing as a result of improper adjustment.NTSB CHI94FA222Accident · 4 fatalField investigationFinal reportBeech A36 · Wichita, KSthe pilot's attempt to take off into known adverse weather and the subsequent stall. Factors were the thunderstorm, the tailwind, and the excessive airplane gross weight and aft center of gravity.NTSB CHI94LA220Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Garden City, KSfuel exhaustion for reason or reasons undetermined. A factor was the rough/uneven terrain.NTSB CHI94LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Levant, KSThe pilot's inadequate evaluation of weather conditions associated with known thunderstorm activity. Factors were the thunderstorm and downdrafts.NTSB CHI94LA184Accident · No injuriesLimited investigationFinal reportCessna 150M · Concordia, KSthe pilot-in-command's misjudging of the altitude of the airplane and his diversion of attention during the landing. A factor was the improper use of the throttle by the pilot-in-command.NTSB CHI94LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSthe pilot-in-command (CFI's) improper compensation for wind conditions and his poor in flight decision making. Factors were a tailwind and a vehicle on the runway.NTSB CHI94LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Anthony, KSthe pilot's failure to obtain sufficient airspeed prior to liftoff. A factor in the accident was the pilot's lack of total experience in type of airplane.NTSB CHI94LA153Accident · No injuriesLimited investigationFinal reportMaule M-4 · Salina, KSFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop/swerve. Factors related to the accident were: the crosswind, and the pilot's lack of experience in the make and model of aircraft.NTSB CHI94LA152Accident · Minor injuriesLimited investigationFinal reportGrumman American TR-2 · Wichita, KSwas the pilot-in-command not performing an aborted landing after the first porpoise event and bounce into the air. Factors associated with this accident were an excessive airspeed and porpoising encountered by the pilot-in-command.NTSB CHI94LA132Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Augusta, KSThe improper touchdown performed by the balloon pilot.NTSB CHI94DCQ01Accident · 1 fatalFinal reportRobert O. ELY STARDUSTER-II SA300 · Baxter Springs, KSthe pilot's failure to maintain altitude during an aerobatic maneuver on takeoff. A factor related to the accident was the pilot performing an aerobatic maneuver.NTSB CHI94LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Beloit, KSthe pilot's failure to maintain sufficient airspeed during the initial takeoff climb.NTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.NTSB CHI94FA097Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Inman, KSAn unintentional spin which occurred during the maneuvering phase of a biennial flight review. A factor related to the accident was: the airplane's lateral-directional characteristics at or near the stall speed.NTSB CHI94LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lindsborg, KSwas the pilot-in-command's failure to refuel the airplane during the flight. Factors were fuel exhaustion, the sign, and the pilot-in-command's lack of total experience in type of airplane.NTSB CHI94LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Concordia, KSthe flight instructor's inadequate remedial action when the student pilot failed to maintain adequate directional control of the airplane during the landing roll. A related factor is the drifted snow.NTSB CHI94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Wichita, KSThe pilot's failure to attain the proper touchdown point and delay in aborting the landing. The pilot's inadequate training was a factor.NTSB CHI94LA073Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Olathe, KSthe pilot's failure to follow procedures and directives regarding the positioning of the fuel tank selector to the fullest tank for the landing portion of flight.NTSB CHI94LA069Accident · Serious injuriesLimited investigationFinal reportPlummer Supercat · Stafford, KSThe pilot's failure to refuel the airplane prior to fuel exhaustion, and his failure to maintain airspeed resulting in an aerodynamic stall. His inadequate training was a factor in the accident.