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 GAA17CA053Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Valley Center, KSThe pilot's failure to maintain directional control during the landing roll and to see and avoid the airplane stopped on the edge of the runway.NTSB GAA17CA003Accident · No injuriesData collectionFinal reportAndrew Harold Stol CH 701 · Berryton, KSThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion.NTSB GAA17CA008Accident · No injuriesData collectionFinal reportBeech 35 · Lawrence, KSThe flight instructor’s delayed remedial action, which resulted in an unstabilized approach and collision with runway approach lights.NTSB CEN17LA009Accident · Minor injuriesLimited investigationFinal reportAero Smart Solutions Lancair Evolution · Iola, KSWater contamination of the fuel due to the pilot’s inadequate preflight inspection, which led to a total loss of engine power. Contributing to the accident was the pilot’s failure to complete the engine-out checklist, which resulted in an excessive loss of…NTSB CEN16LA381Accident · No injuriesLimited investigationFinal reportScottish Series 100 MDL 101 · Wichita, KSThe pilot’s improper preflight inspection during which he relied on the fuel totalizer and failed to ensure that sufficient fuel was onboard for the flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA16CA484Accident · No injuriesData collectionFinal reportCessna 182 · Olathe, KSThe pilot’s failure to reduce the throttle during the landing roll resulting in a loss of directional control.NTSB CEN16LA334Accident · Serious injuriesLimited investigationFinal reportPiper PA 25-235 · Bushton, KSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN16CA277Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Topeka, KSThe pilot’s failure to maintain clearance from a wire during an agricultural flight.NTSB GAA16CA379Accident · Minor injuriesData collectionFinal reportJesse Saint/Troy Townsend/Etha CH-801 · Beaumont, KSThe pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard bounced landing and a nose over.NTSB CEN16LA266Accident · 1 fatalLimited investigationFinal reportToevs Titanium Explorer · Whitewater, KSThe loss of aircraft control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB GAA16CA364Accident · No injuriesData collectionFinal reportCessna 172RG · Manhattan, KSThe flight instructor and pilot receiving instruction's omission to use an appropriate checklist and extend the landing gear prior to landing, which resulted in substantial damage to the aircraft's fuselage and bulkhead.NTSB GAA16CA331Accident · No injuriesData collectionFinal reportBeech F33 · Salina, KSThe flight instructor's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall and a collision with terrain.NTSB CEN16LA230Accident · No injuriesLimited investigationFinal reportGlaeser Nieuport 11 · Gardner, KSThe pilot's diverted attention during the approach for the precautionary landing, which resulted in low airspeed, an exceedance of the airplane’s critical angle of attack, and a subsequent aerodynamic stall. Contributing to the accident was the control system…NTSB GAA16CA224Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Oberlin, KSThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, and a ground loop.NTSB CEN16LA177Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Osage City, KSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA200Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Madison, KSThe pilot's incorrect brake application during the landing roll, which resulted in a nose over.NTSB CEN16LA129Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wichita, KSThe total loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel management.NTSB GAA16CA107Accident · Minor injuriesData collectionFinal reportPiper PA 46 · Ottawa, KSThe flight crews encounter with un-forecasted freezing rain resulting in an uncontrolled descent, forced landing, and substantial damage to the airplane's firewall, and forward pressure bulkhead.NTSB CEN16LA093Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Wichita, KSThe pilot’s failure to maintain the minimum-recommended approach airspeed in icing conditions, which resulted in a loss of airplane control.NTSB GAA16CA070Accident · Minor injuriesData collectionFinal reportStinson 108 · Sharon, KSThe pilot's decision to continue the unstabilized approach and landing and his delayed decision to go around with an insufficient climb rate, which resulted with collision with trees.NTSB CEN16LA022Accident · 1 fatalLimited investigationFinal reportDelwyn Schmidt No model · Bennington, KSThe unregistered airplane’s loss of engine power due to piston seizure. Contributing to the accident was the pilot’s loss of airplane control while maneuvering back to the runway.NTSB GAA16CA028Accident · No injuriesData collectionFinal reportMaule M5 · Goodland, KSThe pilot's inadequate crosswind compensation and subsequent loss of directional control during the landing roll, resulting in a runway excursion and nose over.NTSB DCA16CA010Accident · Serious injuriesData collectionFinal reportBoeing 737-924ER · Plevna, KSAn inadvertent encounter with clear air turbulence resulting in a serious injury to a flight attendant.NTSB CEN16LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Century, KSThe pilot’s application of excessive brake pressure to maintain a safe taxi speed during a long, slightly downhill taxi with a strong quartering tailwind, which resulted in a brake fire.NTSB CEN15LA431Accident · Serious injuriesLimited investigationFinal reportEdward M Van Morlan Rans S-12 · Gardner, KSThe pilot's inadequate airspeed control and the airplane’s exceedance of its critical angle-of-attack during the forced landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to fuel starvation caused by…NTSB CEN15FA425Accident · 1 fatalField investigationFinal reportCessna T310Q · Wichita, KSThe separation of the attachment hardware connecting the elevator trim tab pushrod to the elevator trim actuator, which resulted in the elevator trim tab jamming in a position outside the limits of normal travel and a subsequent loss of airplane control.NTSB GAA15CA274Accident · No injuriesData collectionFinal reportCessna 172N · Herington, KSThe pilot's failure to maintain pitch control during the landing roll, which resulted in a porpoise.NTSB GAA15CA301Accident · No injuriesData collectionFinal reportCessna 182 · Rose Hill, KSThe pilot's improper pitch control during the landing flare, which resulted in a porpoise and subsequent hard landing.NTSB GAA15CA226Accident · No injuriesData collectionFinal reportStick & Rag Flying Club CB 1 · Kingman, KSThe separation of the left wheel from the landing gear assembly during the landing touchdown, which precipitated a loss of directional control, runway excursion, and nose over.NTSB CEN15LA330Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Emmett, KSThe engine failure due to several loose, damaged cylinder stud nuts and hold-down bolts. Contributing to the accident was maintenance personnel’s failure to detect that the cylinder nuts and hold-down bolts were not properly secured during the engine’s most…NTSB GAA15CA178Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Newton, KSThe failure of the right main landing gear down-lock micro switch, which resulted in a landing gear collapse during landing, and the pilot/owner's unfamiliarity with the emergency landing gear extension procedure. Contributing to the accident was the flight…NTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB GAA15CA136Accident · No injuriesData collectionFinal reportCessna 172H · Cottonwood Falls, KSThe pilot's failure to attain adequate airspeed to climb the airplane out of ground effect, which resulted in an aerodynamic stall and a collision with terrain.NTSB CEN15FA240Accident · 1 fatalField investigationFinal reportYakovlev YAK 52 · Syracuse, KSThe pilot’s failure to maintain airplane control while maneuvering at low altitude, which resulted in the airplane’s wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall .NTSB GAA15CA077Accident · No injuriesData collectionFinal reportCessna 150M · Wellington, KSThe student pilot's improper flare and loss of control which resulted in a hard landing.NTSB CEN15LA226Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Dighton, KSThe pilot's failure to follow the Preflight checklist and his inadequate preflight inspection, during which he failed to detect the water contamination of the fuel, which resulted in a partial loss of engine power during initial climb.NTSB CEN15FA187Accident · 2 fatalField investigationFinal reportAircraft Mfg & Dvlpmt CH601XL · Pleasanton, KSThe pilot's excessively high angle-of-attack on rotation that prevented the airplane from climbing sufficiently to avoid the approaching trees.NTSB CEN15CA201Accident · Minor injuriesData collectionFinal reportFiebich Paul Dean Airbike RX40 · Derby, KSThe pilot's inadequate compensation for wind conditions during the landing, which resulted in a hard landing and separation of the left main landing gear.NTSB CEN15CA184Accident · No injuriesData collectionFinal reportCessna T188C · Burdett, KSThe pilot did not maintain directional control of the airplane in gusting wind conditions.NTSB CEN15FA163Accident · 1 fatalField investigationFinal reportAhrens Gerd H RV 6 · Pratt, KSA hard landing, which resulted in the pilot’s loss of directional control and the airplane’s subsequent nose-over.NTSB CEN15LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-180 · Haviland, KSThe loss of torque on the No. 4 cylinder through bolts, which led to the subsequent failure of the piston, the liberation of the connecting rod, the separation of the No. 4 cylinder from the crankcase in cruise flight, and the airplane’s subsequent impact…NTSB CEN15LA117Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Goodland, KSThe pilot's improper fuel management and failure to conduct the engine failure emergency procedures and his improper conduct of the forced landing, which resulted in fuel starvation, a total loss of engine power, and the subsequent high-energy impact with…NTSB CEN15LA107Accident · Serious injuriesLimited investigationFinal reportCessna 210J · Dodge City, KSThe loss of engine power on approach due to fuel exhaustion, which resulted from the pilot's improper preflight fuel planning and inspection.NTSB CEN15FA034Accident · 4 fatalField investigationFinal reportRaytheon B200 · Wichita, KSThe pilot's failure to maintain lateral control of the airplane after a reduction in left engine power and his application of inappropriate rudder input. Contributing to the accident was the pilot's failure to follow the emergency procedures for an engine…NTSB CEN14LA461Accident · No injuriesLimited investigationFinal reportCessna 310K · El Dorado, KSA fatigue failure of the left engine’s throttle cable, which resulted in the loss of left engine power.NTSB CEN14LA436Accident · No injuriesLimited investigationFinal reportCessna 170B · Augusta, KSThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CEN14CA427Accident · Serious injuriesData collectionFinal reportAir Tractor AT 401B · Cimarron, KSThe pilot's failure to maintain clearance from the antenna guy wire during an aerial application pass.NTSB CEN14LA376Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 401B · Ellis, KSThe noninstrument-rated pilot’s inadequate preflight weather planning and subsequent inadvertent encounter with instrument meteorological conditions, which resulted in spatial disorientation and the loss of airplane control. Contributing to the accident was…NTSB CEN14LA375Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Fairview, KSThe backfire of the engine and its loss of power for reasons that could not be determined based on the available evidence.NTSB CEN14LA357Accident · No injuriesLimited investigationFinal reportCessna TR182 · Wichita, KSMaintenance personnel’s improper landing gear system repair, which resulted in a hydraulic leak and subsequent gear collapse during landing.