NTSB investigations, 2007, KS
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2007
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") = 2007 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 DEN08LA041Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Phillipsburg, KSTotal loss of engine power due to contamination of the carburetor, total blockage of the fuel inlet screen, and partial blockage of the fuel lines and fittings. Contributing to the accident were the dark night light conditions and the trees.NTSB DEN08LA032Accident · Minor injuriesLimited investigationFinal reportGomory Long EZ · LeRoy, KSThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper fuel calculations and in-flight planning.NTSB DEN08LA038Accident · No injuriesLimited investigationFinal reportRotorway Exec 162-F · New Century, KSWhile on approach the tail rotor spar failed due to metal fatigue .NTSB DEN08IA022Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73F · Wichita, KSFailure of the recirculation fan motor end ball bearing.NTSB DEN08LA013Accident · No injuriesLimited investigationFinal reportLearjet 35A · Goodland, KSThe pilot's failure to maintain aircraft control during the landing.NTSB DEN08LA011Accident · No injuriesLimited investigationFinal reportNorth American NA-265-65 · New Century, KSThe pilot's failure to maintain directional control. Contributing factors in this accident were the sudden wind shift, from calm to a gusty crosswind, the runway light, and the concrete pad.NTSB DEN08LA009Accident · No injuriesLimited investigationFinal reportJackson Pientenpol · Chanute, KSInternal failure of the engine's starter-generator assembly. Contributing factors in this accident were the trees and unsuitable terrain on which to make a forced landing..NTSB DEN08IA030Incident · No injuriesIncident investigationFinal reportBeech C90A · Emporia, KSThe improper installation of the right elevator trim tab attachment hardware by maintenance personnel which resulted in excessive wear, fatigue, and the failure of the push-pull tube.NTSB DEN07LA152Accident · Serious injuriesLimited investigationFinal reportSlingsby Swallow Type T.45 · Hutchinson, KSThe pilot's failure to maintain aircraft control during a low altitude release resulting in an inadvertent stall/spin. Contributing factors were the pilot's decision to turn back to the airport at low altitude and the wind gust.NTSB DEN07LA160Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lawrence, KSTotal failure of the landing gear retraction/extension assembly. Contributing factors in this accident were worn parts in the landing gear retraction/extension assembly, and mechanical binding of the extension assembly.NTSB DEN07LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Newton, KSThe failure of the exhaust gasket on the number 6 cylinder for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07LA142Accident · Serious injuriesLimited investigationFinal reportBell 206-L4 · Mullinville, KSThe pilot's failure to maintain main rotor rpm resulting in an uncontrolled descent, collision with transmission wires, and a hard landing. A contributing factor was the tranmission wires.NTSB DEN07LA137Accident · No injuriesLimited investigationFinal reportMooney M20R · Wichita, KSthe pilot's improper flare and recovery from a bounced landing. Contributing factors are the lack of experience of the pilot and the delayed remedial action of the airline transport pilot rated passenger.NTSB DEN07LA133Accident · Serious injuriesLimited investigationFinal reportWalker Lancair IV · Sylvan Grove, KSA catastrophic engine failure due to oil starvation when an oil line to the turbocharger wastegate actuator came loose. Contributing factors in this accident were the unsuitable terrain on which to make a forced landing.NTSB DEN07LA135Accident · No injuriesLimited investigationFinal reportCessna T188C · Colby, KSThe pilot's failure to maintain directional control during the take-off roll resulting in a ground loop.NTSB DEN07LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Ulysses, KSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07CA097Accident · Minor injuriesData collectionFinal reportStevenson RV-6 · Oakley, KSThe pilot's failure to maintain airspeed during final approach resulting in a inadvertent stall and impact with terrain.NTSB DEN07CA096Accident · No injuriesData collectionFinal reportCessna 172P · Manhattan, KSThe flight instructor's failure to maintain control of the airplane during the landing. A contributing factor was the inadvertent encounter with the military helicopter's rotor wash.NTSB DEN07LA083Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Topeka, KSThe use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…NTSB DEN07CA076Accident · No injuriesData collectionFinal reportCessna 172E · Pleasanton, KSThe pilot's failure to maintain control of the airplane during a go-around. Contributing factors were the gusts and crosswinds.NTSB DEN07CA070Accident · No injuriesData collectionFinal reportMooney M20K · Ingalls, KSThe pilot's inadequate in-flight planning and decision making, and failure to refuel while en route, resulting in loss of engine power during cruise due to fuel exhaustion. Contributing to the accident was the poor weather at the pilot's destination.NTSB DEN07FA059Accident · 1 fatalField investigationFinal reportBeech H-18 · Great Bend, KSThe pilot's failure to maintain aircraft control during the missed approach which resulted in an inadvertent stall and impact with terrain. A contributing factor was the icing conditions.NTSB DEN07CA056Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe pilot's improper flare during landing and failure to maintain directional control during the landing roll. Factors were the gusting winds and the crosswinds.NTSB DEN07LA044Accident · Serious injuriesLimited investigationFinal reportMarino Exec 162F-1995 · Baldwin City, KSthe failure of the tail rotor drive belt for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.