NTSB investigations, 1991, KS
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1991
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") = 1991 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 CHI92FA028Accident · 1 fatalField investigationFinal reportPiper PA28-236 · Valley Center, KSThe pilot's spatial disorientation, his loss of aircraft control, and his exceeding the aircraft's design limits. Factors in the accident were the pilot's disregard for directives and procedures, and his continued flight into known adverse weather.NTSB CHI92FA027Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Coffeyville, KSThe pilot's failure to maintain sufficient airspeed (above stall speed) during the emergency procedure. Related factors are the pilot's poor planning/decision, inattentiveness, and the weather (low ceiling, gusty tailwinds).NTSB CHI92FA023Accident · 1 fatalField investigationFinal reportCessna 150K · Kiowa, KSThe pilot-in-command's failure to properly utilize the carburetor heat to avoid loss of engine power due to carburetor icing. Factors contributing to the accident were the pilot-in-command's inattention and the encounter of unsuitable terrain during an…NTSB CHI92FA022Accident · 2 fatalField investigationFinal reportRockwell AC 690B · Milton, KSIncapacitation of the pilot in command, followed by the loss of control and an inflight breakup with a unqualified person on the controls.NTSB CHI91LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Atchison, KSDelayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.NTSB CHI91DCQ09Accident · No injuriesFinal reportHispano Aviacion HA200 · Liberal, KSA disconnected ignition harness resulting in an inflight fire during maneuvering flight.NTSB CHI91LA290Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, KSThe pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.NTSB CHI91LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Emporia, KSThe pilot's VFR flight into instrument meteorological conditions (IMC), and his delay in taking remedial action. The weather (fog) was a related factor.NTSB CHI91LA242Accident · Minor injuriesLimited investigationFinal reportAmerican AA1 · Spearville, KSThe pilot's selection of unsuitable terrain on which to perform a precautionary landing. Factors related to the accident were poor in flight/planning decision which resulted in the pilot becoming lost/disoriented.NTSB CHI91FA235Accident · 2 fatalField investigationFinal reportAero Commander 500B · Silica, KSThe failure of both pilots to maintain adequate separation during formation flight. Related factors are overconfidence in personal ability and poor planning/decision.NTSB CHI91LA243Accident · No injuriesLimited investigationFinal reportCessna 172 · Oberlin, KSThe student pilot's failure to maintain directional control during landing. Factors in the accident were the pilot's discontinuing his crosswind compensation and his lack of experience in the type of operation.NTSB CHI91LA232Accident · Serious injuriesLimited investigationFinal reportCessna 305 · Hutchinson, KSFuel consumption calculations misjudged by the pilot resulting in fuel exhaustion. Factors related to the accident were compensation for wind conditions were inadequate and presence of trees during the emergency landing attempt.NTSB CHI91LA227Accident · No injuriesLimited investigationFinal reportAero Commander 500B · Hutchinson, KSThe landing gear handle was placed in the gear up postion prematurely resulting in a gear retraction during takeoff. Factors related to the accident were proper procedures were not followed by the pilot.NTSB CHI91DCQ07Accident · No injuriesFinal reportGrumman G-164A · Sharon Springs, KSAircraft takeoff performance exceeded and disregard of performance data by the pilot. A factor associated with the accident is high density altitude.NTSB CHI91DCQ08Accident · No injuriesFinal reportSebly Amateur Built ACRO-SPORT II · Columbus, KSA loss of engine power for undetermined reasons. A factor associated with the accident is soft terrain in the forced landing area.NTSB CHI91LA200Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Olathe, KSDirectional control was not maintained by the pilot. A factor related to the accident is crosswind.NTSB CHI91DCQ06Accident · No injuriesFinal reportPiper PA-36-300 · Oakley, KSA loss of engine power for an undetermined reason(s).NTSB CHI91LA187Accident · No injuriesLimited investigationFinal reportGrumman American AA1C · Lansing, KSThe pilot became lost/disoriented and attempted a precautionary landing. Factors related to the accident were a low level of fuel and soft terrain (wheat field crop).NTSB CHI91LA174Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Overland Park, KSThe pilot's failure to maintain a proper descent rate during an approach for landing.NTSB CHI91LA147Accident · No injuriesLimited investigationFinal reportBeech 58P · Wichita, KSA go around was not performed resulting in the proper touchdown not being attained by the pilot.NTSB CHI91DCQ05Accident · No injuriesFinal reportCessna A188B · Mingo, KSFailure of the pilot to maintain a visual lookout while performing aerial application. A factor associated with the accident is soft terrain in the selected landing area.NTSB CHI91LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Wichita, KSRemedial action was delayed by the instructor pilot. A factor related to the accident was an excessive rate of descent.NTSB CHI91LA113Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Augusta, KSAn improper autorotation was performed by the dual student and remedial action was delayed by the CFI. Factors related to the accident were: inadequate airspeed and rotor RPM.NTSB CHI91LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Wichita, KSDirectional control was not maintained by the dual student and remedial action was delayed by the CFI. Factors related to the accident were a gusty crosswind and a drainage ditch.NTSB CHI91DCQ04Accident · 1 fatalFinal reportCessna A-188 · Harper, KSThe pilot inadvertently stalling the airplane.NTSB CHI91LA094Accident · No injuriesLimited investigationFinal reportCessna R172K · Herington, KSLoss of engine power due to failure of a connecting rod bolt. A factor related to the accident was: the soft, unsuitable terrain.NTSB CHI91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrence, KSFailure of the student pilot to maintain directional control of the aircraft, which resulted in a ground swerve.NTSB CHI91DCQ03Accident · Serious injuriesFinal reportRans S-11 Pursuit · Hays, KSAn engine failure caused by a seized piston. A factor associated with the accident is the failure of the pilot to maintain a proper descent rate during his forced landing.