NTSB investigations, 1989, 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\") = 1989
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") = 1989 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 MKC90LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Wichita, KSFuel exhaustion due to poor planning and the pilot's failure to refuel the aircraft.NTSB MKC90LA036Accident · No injuriesLimited investigationFinal reportBurdette Cuby PA-11 · Ashland, KSAn undetermined problem with the fuel system, which resulted in a loss of engine power, and operation of the aircraft by the pilot with the known deficiency. The uneven (terraced) terrain was a contributing factor.NTSB MKC90LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot misjudged distance and altitude to the runway while on final approach to land. Factors related to the accident were: dark night and static wires.NTSB MKC90LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hays, KSThe pilot's failure to properly flare the airplane during landing.NTSB MKC90LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Ellinwood, KSThe partial failure of the engine for undetermined reasons which resulted in a forced landing. A factor related to the accident was the soft dirt.NTSB MKC90LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Yates Center, KSThe pilot's selection of the wrong direction to attempt a takeoff which resulted in the inability to climb sufficiently to aviod trees.NTSB MKC89FA179Accident · 3 fatalField investigationFinal reportMooney M20F · Mound City, KSThe pilot's continued VFR flight into an area of thunderstorms & heavy rain which resulted in a loss of control of the airplane. Factors related to the accident were thunderstorms and heavy rain.NTSB MKC89LA177Accident · No injuriesLimited investigationFinal reportCessna 180 · Topeka, KSThe pilot's poorly planned approach and failure to maintain a proper glidepath. A contributing factor was the failure of the engine to supply power.NTSB MKC89DCQ01Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M-18-A · Ingalls, KSImproper preflight planning by the pilot and his failure to attain inadequate airspeed, which resulted in a stall/spin. As he was attempting to avoid a power transmission line. Factors related to the accident were: rising terrain, tall grass, tailwind and the…NTSB MKC89FA156Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Medicine Lodge, KSThe pilot misjudged clearance above a house (residence) that he was buzzing and allowed the aircraft to collide with the attached antenna.NTSB MKC89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clayton, KSThe failure of the pilot to compensate for the unfavorable wind conditions.NTSB MKC89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Ft Leavenworth, KSThe student pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing to the accident was the student's lack of total experience.NTSB CHI89IA104Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10 · Garden City, KSThe failure of some of the passengers to follow the captain's instructions to fasten their lap belts.NTSB MKC89LA132Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Scandia, KSImproper planning/decision by the pilot and fuel exhaustion. Contributing factors were the pilot becoming lost/disoriented and small trees.NTSB MKC89FA096Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Wellsville, KSThe failure of the pilot to use carburetor heat during the descent for landing which resulted in a loss of engine power at a critical time in flight, a go-around.NTSB MKC89LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodland, KSThe loss of engine power resulting from an exhaust valve failure. Contributing to the accident was the lack of suitable terrain for a forced landing.