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 CEN23LA198Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Wichita, KSThe pilot’s failure to maintain a safe taxi distance from a turbine-powered airplane, resulting in an encounter of the turbine-powered airplane’s jet blast while taxiing.NTSB CEN23LA184Accident · Serious injuriesClass 4 · LimitedFinal reportRans S7 · Gardner, KSThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.NTSB CEN23LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Gardner, KSA total loss of engine power due to failure of the No. 6 connecting rod as a result of detonation.NTSB WPR23LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 441 · Liberal, KSThe pilot’s inadequate preflight inspection, failure to set the parking brake, and his decision to exit the airplane with engines running to remove a wheel chock, resulting in the airplane’s unintended movement and subsequent collision with a hangar.NTSB CEN23LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Olathe, KSThe inflight collision with multiple geese during initial climb.NTSB CEN23LA029Accident · No injuriesClass 4 · LimitedFinal reportMaule M7-235B · Topeka, KSThe pilot’s failure to maintain airplane control during landing with strong gusty surface winds.NTSB CEN23LA012Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Paola, KSThe pilot’s improper positioning of the fuel selector, which resulted in fuel starvation and a loss of engine power during a departure climb.NTSB CEN22LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Benton, KSThe loss of engine power for undetermined reasons.NTSB ERA22FA320Accident · 1 fatalClass 3 · FieldFinal reportKnight AA Nieuport 28 · Basehor, KSThe pilot’s incorrect installation of the left-wing strut, which resulted in a loss of airplane control during takeoff and a subsequent aerodynamic stall and spin from which the pilot could not recover.NTSB WPR22FA254Accident · 1 fatalClass 3 · FieldFinal reportStucky Steven D RV-7 · Topeka, KSThe pilot’s failure to maintain aircraft control while performing an aerobatic maneuver on takeoff, which resulted in exceedance of the airplane’s critical angle of attack, a subsequent aerodynamic stall, and impact with terrain. Contributing to the accident…NTSB CEN22LA279Accident · Serious injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Yoder, KSThe pilot's encounter with sinking air conditions that resulted in a loss of lift and a subsequent loss of control.NTSB CEN22LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Salina, KSThe pilot’s poor pitch control during an aborted takeoff which resulted in a hard landing.NTSB CEN22LA201Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver Sport 2S · Osawatomie, KSThe loss of engine power due to fuel exhaustion and the pilot’s failure to maintain control of the airplane during a forced landing which resulted in an aerodynamic stall.NTSB CEN22LA185Accident · 1 fatalClass 3 · LimitedFinal reportSuperior Culver LFA · Syracuse, KSThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an inadvertent aerodynamic stall while returning to the airport following a partial loss of engine power for reasons that could not be determined.NTSB CEN22LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Manhattan, KSThe pilot’s failure to use carburetor heat during the approach and his unsuitable flight profile for an upsloping runway, which resulted in a partial loss of engine power and an impact with terrain during an attempted go-around.NTSB CEN22LA158Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Garnett, KSThe pilot’s failure to maintain lateral control while hovering which resulted in a dynamic rollover.NTSB CEN22FA119Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Olathe, KSThe unknown emergency that warranted a return to the airport and the airspeed decay which resulted in an aerodynamic stall.NTSB CEN22LA115Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-201 · Olathe, KSThe total loss of engine power for undetermined reasons.NTSB CEN22LA079Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Ellinwood, KSThe pilot's improper brake application during the landing roll, which resulted in a nose-over.NTSB CEN21LA448Accident · No injuriesClass 4 · LimitedFinal reportCessna 305A · Topeka, KSThe loss of control and ground loop due to the mechanical malfunction of the tailwheel lock.NTSB CEN21LA372Accident · Serious injuriesClass 3 · LimitedFinal reportFlying K Enterprises Sky Raider · Augusta, KSA partial loss of engine power for reasons that could not determined based on available information.NTSB CEN21LA362Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Topeka, KSThe pilot’s decision to continue low-level aerial application flight maneuvers after the low fuel warning light illuminated, which resulted in a partial loss of engine power due to fuel exhaustion.NTSB CEN21LA302Accident · Minor injuriesClass 3 · LimitedFinal reportPiper Aerostar 600A · Wichita, KSThe pilot’s improper fuel planning and management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21LA286Accident · Minor injuriesClass 3 · LimitedFinal reportAyres S2R-T34 · Leoti, KSThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in his inability to maintain airplane control during low-level flight and an impact with terrain. Contributing to the accident was the…NTSB CEN21LA274Accident · Minor injuriesClass 3 · LimitedFinal reportBeech U-8F · Goodland, KSMaintenance personnel’s inadequate inspection of the airplane, which failed to detect and correct chafed electrical wiring and a degraded fuel bladder with holes, which resulted in ignition of fuel vapor and a right wing explosion.NTSB CEN21LA225Accident · 1 fatalClass 3 · LimitedFinal reportBell OH58A · Ulysses, KSThe pilot’s failure to maintain clearance from a power line during the aerial application flight, which resulted in collision with the power line and subsequent impact with terrain.NTSB CEN21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 23 · Hutchinson, KSThe pilot’s failure to abort the takeoff and his high pitch attitude after takeoff, which resulted in an exceedance of the critical angle of attack and a subsequent aerodynamic stall.NTSB CEN21LA187Accident · No injuriesClass 3 · LimitedFinal reportEurocopter EC120 · LeRoy, KSThe contamination of the fuel injection manifold filter due to improper maintenance, resulting in a partial loss of engine power during cruise flight. Contributing to the accident was the pilot’s delayed autorotation, which resulted in insufficient main rotor…NTSB CEN21LA184Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Johnson, KSThe pilot's inadequate pedal application during a transition to hover, which resulted in a loss of yaw control and a subsequent impact with terrain.NTSB CEN21LA175Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Augusta, KSInadequate maintenance at the time the carburetor was replaced, which resulted in the improperly installed throttle cable and a partial loss of engine power. Contributing to the accident was an inadequate annual inspection that failed to detect the improper…NTSB CEN21LA165Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Lake City, KSThe pilot’s failure to maintain clearance from power lines during power line maintenance.NTSB CEN21LA174Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Colby, KSThe pilot’s failure to remove the towbar from the nose landing gear before takeoff, which resulted in a sustained adverse yaw condition, and his failure to adequately monitor the fuel system while circling the airport, which resulted in fuel starvation and…NTSB CEN21LA129Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC42-550FG · Larned, KSThe pilot’s failure to allow sufficient time for the brakes to cool after a previous aborted takeoff, resulting in a runway excursion during a second aborted takeoff due to degraded braking performance. Contributing to the accident was the contact of the hot…NTSB CEN21LA069Accident · Minor injuriesClass 4 · LimitedFinal reportGlobe GC1A · Ottawa, KSThe student pilot’s failure to maintain attain proper pitch attitude of the airplane causing it to exceed its critical angle of attack, enter an aerodynamic stall, and subsequently impact terrain, and his poor decision making and lack of experience that led…NTSB CEN21LA066Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lawrence, KSThe student pilot’s improper landing flare/touchdown which resulted in a hard landing.NTSB CEN21LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Johnson City, KSThe pilot’s improper decision to fly the airplane at too low an altitude resulting in the airplane impacting terrain.NTSB ANC21LA004Accident · 2 fatalClass 3 · LimitedFinal reportAutoGyro MTO Sport · Whitewater, KSA loss of control for reasons that could not be determined based on the available evidence.NTSB CEN21LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Geuda Springs, KSThe pilot’s failure to determine the airplane’s takeoff performance from an off-airport field which resulted in an aborted takeoff and impact with a fence and terrain. Contributing to the accident was the delayed aborted takeoff.NTSB CEN20CA356Accident · No injuriesClass 4 · Data collectionFinal reportMaule M5 · Olathe, KSThe pilot's loss of directional control during landing.NTSB CEN20CA334Accident · No injuriesClass 4 · Data collectionFinal reportHughes 369 · Delia, KSForeign object damage sustained to the main rotor blades due to aerial tree trimming.NTSB CEN20LA267Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Tornado · Mankato, KSA total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20CA221Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Hiawatha, KSThe pilot’s decision to attempt the takeoff with a tailwind in high density altitude conditions.NTSB CEN20LA122Accident · 1 fatalClass 3 · LimitedFinal reportCessna 208 · LaCrosse, KSAn infight loss of control as a result of pilot impairment, the cause of which could not be determined.NTSB CEN20TA088Accident · Minor injuriesClass 3Final reportCessna 170 · Valley Center, KSThe pilot's delayed decision to abort the takeoff when the airplane passed the point where he had anticipated the liftoff would occur.NTSB CEN20FA049Accident · 2 fatalClass 3 · FieldFinal reportMooney M20S · Olathe, KSThe pilot’s failure to set the elevator trim properly for takeoff, which resulted in an exceedance of the airplane’s critical angle of attack during climb out, an aerodynamic stall, and the subsequent impact with terrain.NTSB CEN20CA052Accident · No injuriesData collectionFinal reportPiper PA28R · Onaga, KSThe pilot's improper decision to take off with the airplane at a high gross weight from a short, turf runway, which degraded its climb performance and led to a delayed aborted takeoff, a runway excursion, and impact with terrain.NTSB CEN20LA029Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8A · Baldwin City, KSThe pilot's failure to maintain directional control during takeoff, and the flight instructor's delayed remedial action, which resulted in a runway excursion and nose over.NTSB GAA20CA015Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Goddard, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA560Accident · No injuriesData collectionFinal reportThomas Lee Nieuport 11 · Rose Hill, KSThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and an impact with runway lights.