NTSB investigations, 1990, 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
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\") = 1990
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") = 1990 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 CHI91FA053Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Gardner, KSA loss of engine power for undetermined reasons. Darkness was a related factor.NTSB CHI91DCQ02Accident · No injuriesFinal reportPiper PA-23-250 · Brownell, KSFuel exhaustion, due to the pilot's failure to ensure that the aircraft had been refueled.NTSB CHI91FA033Accident · 2 fatalField investigationFinal reportCessna 150K · Valley Center, KSContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft after becoming spatially disoriented. Factors related to the accident were: darkness, adverse weather conditions, and the…NTSB CHI91DCQ01Accident · 1 fatalFinal reportRobert Bressler Pitts S-1E · St. Francis, KSThe failure of the pilot to maintain aircraft control.NTSB CHI91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oswego, KSFuel starvation due to improper placement of the fuel tank selector by the pilot.NTSB CHI91LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Latham, KSFailure of the pilot to maintain a proper altitude.NTSB CHI91LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Fort Scott, KSThe mixture control was set incorrectly resulting in fuel starvation, and the check list was not followed by the cfi/pic.NTSB CHI91LA005Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ashland, KSThe pilot-in-command's exceeding the proper climb rate of the aircraft, and his not maintaining control of the aircraft to prevent a stall.NTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.NTSB CHI90DCQ01Accident · Minor injuriesFinal reportPiper PA 36-300 · Mingo, KSInadequate airspeed resulting in a stall/mush being encountered by the PIC. Contributing factors were a tailwind and a load jettison not performed.NTSB CHI90LA238Accident · No injuriesLimited investigationFinal reportMooney M20B · Winfield, KSNon-compliance of an airworthiness directive by maintenance personnel.NTSB CHI90LA217Accident · Serious injuriesLimited investigationFinal reportHarper Volksplane WE-1 · Kingman, KSFailure of the pilot in command to maintain airspeed resulting in an inadvertent stall and spin.NTSB MKC90LA149Accident · No injuriesLimited investigationFinal reportCessna 177 · Newton, KSFuel exhaustion and refueling not performed by the pilot in command.NTSB MKC90LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Wichita, KSFuel exhaustion and refueling not performed by the pilot in command.NTSB MKC90FA142Accident · Serious injuriesField investigationFinal reportCessna T210M · Kiowa, KSThe pilot's failure to maintain control of the airplane during takeoff.NTSB MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.NTSB MKC90LA141Accident · No injuriesLimited investigationFinal reportBeech B-60 · Hutchinson, KSEngine failure for undetermined reasons. A factor in the accident was that there was no suitable terrain in which to make a forced landing.NTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.NTSB MKC90LA122Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salina, KSInadvertent flight from VFR into IMC by the pilot in command.NTSB MKC90LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSPoor pre-flight and in-flight planning and refueling not performed by the pilot in command.NTSB MKC90LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Ashland, KSA power plant failure for undetermined causes.NTSB MKC90LA114Accident · No injuriesLimited investigationFinal reportCessna 182RG · Salina, KSGear down and locked not identified, and emergency procedures not performed by the pilot in command.NTSB MKC90LA110Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Gardner, KSAn in-flight fire of undetermined origin.NTSB MKC90LA102Accident · No injuriesLimited investigationFinal reportLightcap PITTS-S-1D · Larned, KSFailure of the main landing gear attachment strut, due to fatigue.NTSB MKC90DCQ02Accident · 1 fatalFinal reportBell UH-1B · Ulysses, KSThe pilot failed to maintain proper rotor RPM, while maneuvering over a high obstruction (power line) at the end of a swath run, which resulted in an inadvertent descent & collision with the terrain. The high obstruction was considered to be a related factor.NTSB MKC90LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Salina, KSFuel exhaustion, fuel calculations misjudged and refueling not performed by the pilot in command.NTSB MKC90DCQ01Accident · 2 fatalFinal reportDaniels BD-4 · Wichita, KSThe pilot failed to maintain flying speed which resulted in an inadvertent stall/spin resulting in collision with terrain.NTSB MKC90LA078Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Belleville, KSThe pilot's inadequate remedial action in response to the loss of power in the right engine, which resulted in his failure to attain the proper touchdown point for landing.NTSB MKC90IA070Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Wichita, KSImproper installation of level arm.NTSB MKC90LA069Accident · No injuriesLimited investigationFinal reportCessna 175 · Derby, KSFailure of the nose gear yoke.NTSB MKC90LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Herington, KSFailure of the #2 exhaust valve, and improper flare by the pilot during the forced landing.NTSB MKC90LA058Accident · No injuriesLimited investigationFinal reportCessna 195 · Garden City, KSDirectional control not maintained by the pilot in command.NTSB MKC90LA050Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Satanta, KSDirectonal control was not maintained by the pilot in command.NTSB MKC90FA044Accident · Serious injuriesField investigationFinal reportCessna P210N · Newton, KSLoss of engine power for an undetermined reason. Darkness and the resultant delay in flaring to land were related factors.NTSB MKC90LA047Accident · Serious injuriesLimited investigationFinal reportBurnett Starduster TOO · Lawrence, KSThe pilot misjudged clearance from tree(s) near the approach end of the runway, while on final approach to land. Factors related to the accident were: sunglare, lack of visual cues to the pilot, and tree(s).