NTSB investigations, KS
167 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 10 |
| 2010 | 7 |
| 2011 | 10 |
| 2012 | 8 |
| 2013 | 9 |
| 2014 | 9 |
| 2015 | 15 |
| 2016 | 14 |
| 2017 | 12 |
| 2018 | 7 |
| 2019 | 14 |
| 2020 | 8 |
| 2021 | 6 |
| 2022 | 6 |
| 2023 | 5 |
| 2024 | 8 |
| 2025 | 4 |
| 2026 | 2 |
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 c.\"eventStateOrRegion\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0106')) 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 CEN26LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Beloit, KSThe pilot’s failure to maintain directional control during the landing with a quartering headwind. Contributing to the accident was the pilot’s runway selection based on the variable and gusting wind conditions.NTSB CEN26LA104Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Augusta, KSThe student pilot’s failure to maintain control during the takeoff.NTSB CEN25LA370Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Benton, KSThe pilot's failure to maintain clearance from a moving vehicle during an evasive maneuver from a perceived conflict with another airplane. Contributing to the accident was the pilot of the other airplane’s non-standard phraseology and inaccurate position…NTSB CEN25LA354Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Baldwin City, KSThe pilot’s decision to continue the night landing without runway lights which resulted in the runway overrun.NTSB CEN25LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Wichita, KSThe student pilot’s failure to maintain directional control during the takeoff that resulted in a runway excursion.NTSB CEN25LA208Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E90 · New Century, KSThe flight instructor’s inadequate fuel planning that resulted in a loss of engine power to the left engine due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate supervision of the flight that resulted in diminished…NTSB CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Lawrence, KSThe pilot’s failure to maintain directional control during takeoff.NTSB CEN24LA262Accident · No injuriesClass 4 · LimitedFinal reportSkystar Kitfox · Hackney, KSThe pilot’s failure to maintain directional control during the landing roll in a gusting wind condition.NTSB CEN24FA248Accident · 1 fatalClass 3 · FieldFinal reportRotorway Scorpion 133 · Andale, KSThe pilot’s abrupt control inputs, which resulted in a low-G condition, main rotor mast bumping, and subsequent severing of the tailboom by the main rotor blades.NTSB CEN24FA243Accident · 2 fatalClass 3 · FieldFinal reportWaco YKC · Selden, KSThe pilot's inadvertent visual flight into instrument meteorological conditions, which had not been forecast at the time of departure, and which resulted in a loss of control due to spatial disorientation.NTSB CEN24LA238Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Fort Leavenworth, KSThe pilot’s failure to maintain directional control after landing.NTSB CEN24LA166Accident · No injuriesClass 4 · LimitedFinal reportRans S-6ES · Emporia, KSThe pilot’s failure to maintain control during the landing flare.NTSB CEN23LA425Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Herington, KSThe design of the spray valve control lever, which restricted the range of the left rear rudder and brake pedal and resulted in a loss of control during landing.NTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.NTSB CEN23LA279Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Chapman, KSThe pilot’s failure to maintain clearance from the power line during an agricultural application pass.NTSB CEN23LA303Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Ulysses, KSThe pilot’s failure to maintain clearance from a cable during spray operations.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 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 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 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 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 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 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 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 CEN21LA165Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Lake City, KSThe pilot’s failure to maintain clearance from power lines during power line maintenance.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 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 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.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 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.