NTSB investigations, 2008, 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\") = 2008
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") = 2008 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 CEN09CA064Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Stafford, KSA loss of engine power for undetermined reasons.NTSB CEN09CA038Accident · No injuriesData collectionFinal reportBeech A36 · Salina, KSThe pilot's failure to properly manage the available fuel supply, which resulted in fuel starvation and subsequent loss of engine power.NTSB CEN09CA007Accident · No injuriesData collectionFinal reportLet Blanik · Gardner, KSThe pilot's decision to attempt a takeoff when the climb performance of the tow plane and the glider were inadequate. Contributing to the accident were the high density altitude and the terrain-induced turbulence.NTSB DFW08FA234Accident · No injuriesField investigationFinal reportCessna E162 · Douglas, KSThe airplane's inability to recover from an intentional spin, despite proper control inputs by the flight test pilot. Contributing to the accident was the failure of the airplane's ballistic parachute system to properly deploy.NTSB DFW08CA236Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Augusta, KSA loose oil line that resulted in a total loss of engine oil, causing the engine to cease.NTSB DEN08CA156Accident · No injuriesData collectionFinal reportCessna 177RG · Ellsworth, KSThe student pilot's failure to maintain directional control during the landing roll.NTSB DFW08CA213Accident · Serious injuriesData collectionFinal reportAerotrike Spirit · Vinland Valley, KSThe flight instructor's failure to maintain control of the sport aircraft on takeoff.NTSB DEN08CA133Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe student pilot's failure to maintain control of the airplane. Contributing to the accident were the flight instructor's inadequate supervision, turbulence, airspeed was not maintained, and compensation for the wind conditions was inadequate.NTSB DEN08LA125Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402B · Deerfield, KSThe pilot inadvertently stalling the airplane. Contributing factors in this accident were the pilot intentionally performing low altitude maneuvers (side slips), unporting and starving the engine of fuel, and his initiating a climb at low airspeed.NTSB DFW08CA174Accident · No injuriesData collectionFinal reportCessna 177 · Baldwin City, KSThe pilot's loss of directional control resulting from a hard landing and failure to recover from a bounced landing. Contributing to the accident was the crosswind.NTSB DFW08LA169Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olathe, KSA loss of engine power for undetermined reasons.NTSB DEN08FA114Accident · 2 fatalField investigationFinal reportAero Commander 500S · Linwood, KSThe pilot-in-training inadvertently shutting off both engine fuel control valves causing a loss of power in both engines, and the pilot's failure to maintain control of the airplane resulting in a stall. Contributing to the accident was the chief pilot's…NTSB DEN08LA108Accident · No injuriesLimited investigationFinal reportMercer Avid Flyer Mk IV · Augusta, KSFailure of the engine cooling system's thermostat, causing the engine to overheat and seize. Contributing to the accident was the fence.NTSB DEN08LA103Accident · No injuriesLimited investigationFinal reportCessna A188B · Lyons, KSthe loss of engine power for undetermined reasons. A contributing factor was the dirt embankment.NTSB DFW08CA158Accident · No injuriesData collectionFinal reportAeros Venture · Baldwin City, KSthe pilot's failure to maintain proper runway alignment and the instructor's delayed remedial action to abort the landing, which resulted in a collision with a mailbox and hangar. A factor was the crosswind.NTSB DFW08CA156Accident · No injuriesData collectionFinal reportAyres S-2R · McDonald, KSThe pilot's failure to maintain aircraft control during the takeoff. Contributing to the accident was the soft terrain.NTSB DFW08CA145Accident · No injuriesData collectionFinal reportWeatherly 201B · Nickerson, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB DFW08LA135Accident · Serious injuriesLimited investigationFinal reportBailey Varieze · Phillipsburg, KSThe pilots failure to maintain aircraft control during an emergency landing. Contributing factors were the reported smoke and prevailing gusty wind conditions.NTSB DFW08LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Emporia, KSA total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.NTSB DFW08LA095Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G36 · El Dorado, KSThe improper installation of the fuel manifold valve's brass plug. Contributing to the accident was the unsuitable landing area for the forced landing.NTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.NTSB DEN08CA068Accident · No injuriesData collectionFinal reportPiper PA-28-150 · Mankato, KSthe student pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the fence and trees.NTSB DFW08CA086Accident · No injuriesData collectionFinal reportAir Tractor At-301 · Plains, KSA loss of engine power as a result of a blocked carburetor. A factor was the lack of suitable terrain for the forced landing.NTSB DEN08CA063Accident · No injuriesData collectionFinal reportPiper PA-22 · Nickerson, KSthe pilot's failure to maintain directional control during the landing roll resulting in a departure from the runway environment. Contributing to the accident was the soft runway surface.NTSB DEN08FA059Accident · 2 fatalField investigationFinal reportCessna 414A · Benton, KSThe pilot's failure to maintain clearance from the trees. Contributing to the accident was the pilot's flight into known adverse weather conditions and the low clouds and visibility.NTSB DEN08FA058Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sterling, KSThe loss of pitch control during cruise flight resulting from the separation of the stabilator trim actuator due to inadequate maintenenace.NTSB DEN08LA053Accident · Serious injuriesLimited investigationFinal reportPhillips Flite Bike · Valley Center, KSThe pilot's failure to maintain airspeed during an emergency descent resulting in an inadvertent stall/mush. Contributing to the accident was the pilot's failure to turn on the fuel tank valve resulting in fuel starvation and the loss of engine power.