NTSB investigations, 2004, 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\") = 2004
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") = 2004 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 CHI05LA015Accident · 1 fatalLimited investigationFinal reportStrissel Pitts S1S · Liberal, KSThe pilot's failure to maintain control of the airplane while performing aerobatic flight maneuvers resulting in an in-flight collision with terrain.NTSB CHI05CA003Accident · No injuriesData collectionFinal reportSinclair Zenith 701 · Augusta, KSThe manufacturer's inadequate design/production of the landing gear axle leading to its separation and the airplanes subsequent nose over during the landing roll.. A factor was the axle's separation from its spring.NTSB CHI04LA280Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Kingman, KSThe lack of engine oil due to the mechanic's improper maintenance in not securing the loose "B" nut for the oil pressure line to the turbocharger leading to the loss of engine power while maneuvering. An additional cause was the unsuitable terrain the pilot…NTSB CHI04LA264Accident · Minor injuriesLimited investigationFinal reportCessna 401 · New Century, KSA loss of engine power due to fuel starvation and the pilot's failure to maintain directional control during approach to an alternate airport. Contributing to the accident was the pilot's failure to obtain a weather briefing, his flight into adverse weather,…NTSB CHI04CA230Accident · No injuriesData collectionFinal reportBowles Questair Venture · Liberal, KSThe loss of directional control during landing for undetermined reasons.NTSB CHI04CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Cambridge, KSThe pilot not jettisoning his chemical load during initial climb with the reported loss of airplane performance. Factors were the reported loss of aircraft performance and the tree.NTSB CHI04CA216Accident · No injuriesData collectionFinal reportGlasflugel H301 · Hutchinson, KSThe pilot's improper decision to change the landing area at a low altitude and the inadequate flare that resulted in a hard landing.NTSB CHI04FA215Accident · 1 fatalField investigationFinal reportJorgensen Velocity XL-RG · Belvidere, KSThe non-instrument rated pilot's VFR flight into known instrument meteorological conditions and his failure to maintain aircraft control which resulted in an inverted flat spin, in-flight breakup, and explosion.NTSB CHI04LA238Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Eudora, KSA loss of engine power due to fuel starvation resulting from the pilot's selection of a fuel tank with an insufficient quantity remaining.NTSB CHI04CA241Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe student pilot flared too high and failed to recover from a bounced landing.NTSB CHI04CA209Accident · Minor injuriesData collectionFinal reportCessna 172M · Sublette, KSThe student pilot's inadequate compensation for the crosswind condition, and her failure to maintain aircraft control during landing. Factors contributing to the accident included the student pilot's unsuccessful recovery from the bounced landings and the…NTSB CHI04LA295Accident · Serious injuriesLimited investigationFinal reportAero Commander Callair A-9B · Norton, KSThe fire in the area of the fuel line and the unsuitable terrain encountered during an emergency landing by the pilot. Contributing factors were the pole.NTSB CHI04FA157Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Great Bend, KSThe pilot's inadequate preflight planning due to his failure to obtain a weather briefing prior to takeoff. Additional causes were the pilot's inadvertent flight into adverse weather and his failure to maintain clearance with the terrain during his attempt to…NTSB CHI04CA156Accident · No injuriesData collectionFinal reportYoukey Lancair 235 · Hays, KSThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the gusty crosswind, the runway marker sign, and the taxiway lights…NTSB CHI04CA141Accident · Minor injuriesData collectionFinal reportDoerr Raymond R RV-9A · Fort Scott, KSThe vapor lock of the airplane fuel system and the ditch encountered during the emergency landing..NTSB CHI04LA148Accident · Serious injuriesLimited investigationFinal reportBoeing 737-7H4 · Liberal, KSThe adverse weather encountered during cruise flight by the flight crew and the flight attendant not being restrained. A contributing factor was the convective activity.NTSB CHI04CA135Accident · Minor injuriesData collectionFinal reportCessna T210L · Wichita, KSThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB CHI04CA121Accident · No injuriesData collectionFinal reportCessna 172C · Fort Leavenwort, KSThe inadequate flare by the pilot.NTSB CHI04CA115Accident · No injuriesData collectionFinal reportVilleneuve RV-3 · Mayetta, KSThe pilot failed to maintain airspeed and aircraft control during final approach, which resulted in a stall/mush flight condition. A factor to the accident was the crosswind and the trees.NTSB CHI04LA101Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Overland Park, KSThe pilot's inadequate fuel calculations and the pilot's improper in-flight decision which resulted in fuel exhaustion. Contributing factors were the trees and the night conditions.NTSB CHI04CA090Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Yoder, KSThe pilot's failure to secure the elevator Louis L'Hotellier connector with a safety pin or wire as directed in several airworthiness directives and his inadequate preflight inspection of the sailplane, both of which resulted in the in-flight loss of elevator…NTSB CHI04CA092Accident · No injuriesData collectionFinal reportCessna 150J · Gardner, KSThe pilot's inadequate visual lookout and failure to maintain clearance from the post. A factor was the post.NTSB CHI04LA086Accident · No injuriesLimited investigationFinal reportBeech 1900D · Manhattan, KSThe captain's improper decision due to his attempt to taxi back onto the runway after coming to a stop in the grass, and the resulting collapse of nose landing gear. Contributing factors were the inoperative nose wheel steering, the pilot's inability to…NTSB CHI04FA066Accident · 3 fatalField investigationFinal reportBeech B90 · Dodge City, KSThe pilot failed to maintain clearance with terrain due to pilot fatigue (lack of sleep).NTSB CHI04FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Rozel, KSThe inadvertent flight into instrument meteorological conditions, the spatial disorientation, and aircraft control not maintained by the pilot during cruise flight. Contributing to the accident were the night instrument meteorological conditions due to low…