NTSB investigations, 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, newest first
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 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 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 CEN09LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Johnson County Exec Airport, KSFailure of the pilot of the Cessna 172S to ensure the taxiway was clear prior to initiating the turn. Contributing to the accident was the failure of the pilot of the Cessna 172N to obtain taxi clearance prior to entering the movement area.NTSB CEN09CA229Accident · No injuriesData collectionFinal reportCessna 172 · Manhattan, KSThe pilot's improper recovery from a bounced landing.NTSB CEN09CA158Accident · Minor injuriesData collectionFinal reportCessna 170 · Cottonwood Falls, KSThe decision of the pilot to attempt operations outside the forward center of gravity limit. Contributing to the accident was the pilot's selection of an inadequate runway for the conditions.NTSB CEN09LA145Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Wichita, KSThe failure of line personnel to ensure that the airplane was serviced with the proper fuel. Contributing to the accident was the Federal Aviation Administration's approval of a Supplemental Type Certificate (STC) which allowed an improper fuel filler…NTSB CEN09CA141Accident · No injuriesData collectionFinal reportCessna 172S · Emporia, KSThe pilot's inadequate compensation for the wind conditions during the touch-and-go. Contributing to the accident were the gusty crosswinds.NTSB CEN09LA124Accident · Minor injuriesLimited investigationFinal reportLavigna Lancair IV P · Iola, KSThe total loss of engine power for undetermined reasons.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.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.