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 CEN19LA315Accident · No injuriesClass 3 · LimitedFinal reportPiper PA34 · Kingman, KSThe malfunction of the landing gear extension system for reasons that could not be determined with the available evidence.NTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN19FA189Accident · 1 fatalField investigationFinal reportBeechcraft 58 · Hiawatha, KSThe pilot's loss of control for undetermined reasons.NTSB GAA19CA377Accident · No injuriesData collectionFinal reportCessna 177 · Pleasanton, KSThe pilot's loss of yaw control during takeoff with a right quartering headwind in gusting wind conditions, which resulted in a collision with trees.NTSB GAA19CA352Accident · No injuriesData collectionFinal reportAir Tractor AT402 · Liberal, KSThe pilot's failure to see and avoid a windmill tower while maneuvering at low altitude.NTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA328Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Monument, KSThe pilot's failure to maintain altitude due to distraction by ground equipment in the airplane’s path, which resulted in his failure to maintain clearance from crops during an agricultural application flight and resulted in a loss of airplane control.NTSB GAA19CA307Accident · No injuriesClass 4 · Data collectionFinal reportDavid S Meek SUN Devil · Junction City, KSThe pilot rated passenger's failure to maintain directional control during landing. Contributing to the accident was the improperly maintained main landing gear brake pads.NTSB GAA19CA300Accident · Minor injuriesData collectionFinal reportVans RV6 · Rose Hill, KSThe pilot's unintentional engagement of the brakes before landing, which resulted in a nose-over.NTSB GAA19CA041Accident · No injuriesData collectionFinal reportVans RV 6 · Paola, KSThe pilot's failure to maintain directional control, which resulted in a runway excursion during the aborted landing and subsequent impact with vegetation and a nose-over.NTSB GAA19CA206Accident · No injuriesData collectionFinal reportPiper PA28R · Hutchinson, KSThe pilot's failure to extend the landing gear before landing.NTSB CEN19LA111Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Newton, KSThe loss of engine power after the No. 1 connecting rod end separated as a result of oil starvation, which led to the forced landing and nose-over.NTSB GAA19CA161Accident · Minor injuriesData collectionFinal reportCessna L19 · Benton, KSThe pilot's receiving instruction’s failure to maintain directional control during the landing roll, which resulted in impact with trees and a house.NTSB CEN19LA086Accident · No injuriesLimited investigationFinal reportBeech 65 · Colby, KSThe pilot’s failure to properly secure the crew hatch door before takeoff, which resulted in his distraction and his failure to maintain airplane control and airspeed.NTSB CEN19LA046Accident · No injuriesLimited investigationFinal reportCessna 120 · Beaumont, KSThe right brake being locked during the landing roll on the turf runway for reasons that could not be determined during postaccident examinations, which resulted in a noseover.NTSB CEN19FA029Accident · 2 fatalField investigationFinal reportBeech 55 · Liberal, KSThe pilot's improper decision to fly in an area where moderate icing conditions were forecasted in an airplane that was not certified for such conditions, and in the effort to get out of the icing conditions, his decision to fly below the minimum descent…NTSB GAA19CA042Accident · No injuriesData collectionFinal reportCessna 172 · Salina, KSThe student pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA19CA037Accident · No injuriesData collectionFinal reportZenith CH601 · Junction City, KSThe pilot's failure to secure the canopy latch before takeoff, which resulted in the canopy opening in flight and the subsequent loss of airplane control.NTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.NTSB GAA18CA573Accident · No injuriesData collectionFinal reportHiller UH 12E · Frankfort, KSThe ground crewmember's improper grabbing of the hovering helicopter's skid during an external load hook-up, which resulted in the helicopter descending and the main rotors striking ground equipment.NTSB CEN18LA356Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Partridge, KSThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN18LA350Accident · No injuriesLimited investigationFinal reportCessna A188 · Atchison, KSThe partial loss of engine power for reasons that could not be determined during the postaccident examination.NTSB CEN18LA342Accident · No injuriesLimited investigationFinal reportCessna A188 · Whitewater, KSThe partial loss of engine power due to low cylinder compression, which led to the forced landing following a pull-up maneuver. Contributing to the accident was the airplane’s high gross weight.NTSB GAA18CA439Accident · No injuriesData collectionFinal reportWayne D. Teel Waiex · Kinsey, KSThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB CEN18LA286Accident · Serious injuriesLimited investigationFinal reportVans RV6 · Coldwater, KSThe pilot's loss of control while landing a tailwheel-equipped airplane in gusting wind conditions.NTSB CEN18LA246Accident · No injuriesLimited investigationFinal reportCessna 337 · Baldwin City, KSThe loss of hydraulic accumulator pressure for reasons that could not be determined, which prevented the propeller from unfeathering, and the pilot's improper decision to attempt a go-around, which resulted in an off-airport landing and the airplane impacting…NTSB CEN18LA230Accident · No injuriesLimited investigationFinal reportCessna TR182 · Beloit, KSThe mechanic’s failure to properly torque one of the left brake caliper’s back plate attachment bolts while re-installing it during the annual inspection, which resulted in the left main landing gear not extending before landing.NTSB CEN18LA197Accident · Minor injuriesLimited investigationFinal reportFairchild M 62C(PT-23A) · Wichita, KSA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s miscalculation of the fuel consumption rate during preflight planning.NTSB CEN18LA148Accident · Serious injuriesLimited investigationFinal reportMaule M 5-235C · Roxbury, KSThe pilot's failure to maintain directional control during takeoff from a road, which resulted in impact with a sign.NTSB CEN18FA108Accident · 2 fatalField investigationFinal reportBeech 58 · Ulysses, KSAn inflight loss of control and collision with terrain for reasons that could not be determined.NTSB GAA18CA124Accident · No injuriesData collectionFinal reportCessna 150 · El Dorado, KSThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off-airport landing and nose-over.NTSB CEN18LA027Accident · Serious injuriesLimited investigationFinal reportRiggs Kenneth W T Bird II · St Mary's, KSThe loss of engine power due to a propeller failure when the passenger’s hat exited the cockpit and impacted the three-bladed pusher propeller, separating one of the propeller blades.NTSB CEN17LA372Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Westphalia, KSA total loss of engine power due to a fatigue failure of the crankshaft that resulted from main bearing shift and lack of lubrication.NTSB GAA17CA531Accident · No injuriesData collectionFinal reportCessna 210 · Kinsley, KSThe pilot's decision to continue an unstabilized approach for landing in tailwind conditions, which resulted in a runway overrun and a nose-over.NTSB GAA17CA489Accident · No injuriesData collectionFinal reportCessna 170 · Axtell, KSThe pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.NTSB CEN17FA297Accident · 2 fatalField investigationFinal reportPiper PA30 · Topeka, KSThe failure of the pilot and flight instructor to maintain aircraft control while maneuvering in the traffic pattern.NTSB GAA17CA449Accident · No injuriesData collectionFinal reportRadford Darrel F Christen Eagle II · Atchison, KSThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA415Accident · No injuriesData collectionFinal reportCessna 195 · Leavenworth, KSThe pilot’s inadvertent toe brake application during the landing roll, which resulted in a runway excursion and a ground loop.NTSB CEN17FA270Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51 · Cummings, KSThe loss of airplane control while maneuvering at low altitude for reasons that could not be determined.NTSB GAA17CA390Accident · Minor injuriesData collectionFinal reportBell 407 · Topeka, KSThe pilot’s failure to maintain clearance from a building during landing.NTSB GAA17CA351Accident · No injuriesData collectionFinal reportCessna 172 · Lawrence, KSThe student pilot's incorrect control application during landing after a simulated engine failure, which resulted in a hard, bounced landing, and the flight instructor's delayed action to perform a go-around in gusting wind conditions.NTSB GAA17CA319Accident · Minor injuriesData collectionFinal reportMagnaghi Aeronautica SKY Arrow LSA · Chapman, KSThe pilot's failure to maintain lateral/bank control during the takeoff climb in gusting crosswind conditions.NTSB GAA17CA273Accident · No injuriesData collectionFinal reportAdrian George W Europa Classic · Wellington, KSThe pilot’s improper landing flare and exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB CEN17LA176Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Gypsum, KSA total loss of engine power during a low-altitude agricultural application flight for reasons that could not be determined during detailed examinations. Contributing to the accident was the pilot’s failure to follow the airplane manufacturer's emergency…NTSB GAA17CA260Accident · Minor injuriesData collectionFinal reportMooney M20 · Olathe, KSThe separated fuel tank selector knob roll pin, which prevented the fuel selector from moving to the fuel tank position for the tank with usable fuel and resulted in fuel starvation and the subsequent total loss of engine power.NTSB CEN17LA163Accident · No injuriesLimited investigationFinal reportGrumman Schweizer G-164 · Palmer, KSA crack in the cylinder of the radial engine, which resulted in a loss of engine power and a forced landing on unsuitable terrain.NTSB GAA17CA234Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Stafford, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB GAA17CA170Accident · No injuriesData collectionFinal reportMaule M5 · Roxbury, KSThe pilot’s failure to maintain directional control during a go-around.NTSB GAA17CA123Accident · No injuriesData collectionFinal reportPiper PA 28R · Wichita, KSThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA17CA059Accident · Minor injuriesData collectionFinal reportHaring Clay RV6 · Eureka, KSThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion.