OpenAirDocs.org

NTSB investigations, KS

341 cases where the phase of flight was Initial climb.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 350)
  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.

NTSB CEN26LA163Accident · No injuriesClass 4 · LimitedFinal reportTextron T206H · Wichita, KSThe flight crew’s failure to ensure that the rear cargo door was properly latched before flight.Apr 3, 2026 · N411CV · Substantial damageNTSB CEN23LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210B · Wichita, KSLoss of engine power for reasons that could not be determined.Aug 30, 2023 · N9663X · Substantial damageNTSB CEN23LA264Accident · No injuriesClass 3 · LimitedFinal reportBeech B19 · Scott City, KSA partial loss of engine power as a result of carburetor icing that formed while the engine was operating at a low power setting for an extended period before departure.Jun 24, 2023 · N9721Q · Substantial damageNTSB CEN23LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Olathe, KSThe inflight collision with multiple geese during initial climb.Nov 12, 2022 · N5258Y · Substantial damageNTSB CEN22LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Benton, KSThe loss of engine power for undetermined reasons.Aug 5, 2022 · N97683 · Substantial damageNTSB 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.Apr 28, 2022 · N37888 · DestroyedNTSB 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.Feb 13, 2022 · N2445F · DestroyedNTSB CEN22LA115Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-201 · Olathe, KSThe total loss of engine power for undetermined reasons.Feb 4, 2022 · N5145W · Substantial damageNTSB 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.Aug 15, 2021 · N56179 · Substantial damageNTSB 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.May 1, 2021 · N2378Z · Substantial damageNTSB 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.Jun 27, 2019 · N30257 · Substantial damageNTSB 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.Nov 5, 2017 · N618ER · Substantial damageNTSB 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.Jun 2, 2017 · N600US · Substantial damageNTSB 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.Apr 28, 2016 · N17PY · Substantial damageNTSB 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.Sep 25, 2015 · N301JA · DestroyedNTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.Jul 2, 2015 · N44SN · Substantial damageNTSB 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.May 10, 2015 · N879JA · Substantial damageNTSB 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.Mar 31, 2015 · N623HS · DestroyedNTSB 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…Oct 30, 2014 · N52SZ · DestroyedNTSB 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.Jul 7, 2014 · N4602S · Substantial damageNTSB CEN14LA205Accident · 1 fatalLimited investigationFinal reportQuicksilver GT400 · Hillsboro, KSThe pilot’s failure to maintain control of the unregistered airplane in gusting wind conditions.Apr 18, 2014 · UNREG · Substantial damageNTSB CEN13LA254Accident · Serious injuriesLimited investigationFinal reportMason Robert Kolb Mark 3X · Lawrence, KSThe noncertificated pilot’s improper decision to depart with a tailwind.May 1, 2013 · N125KP · Substantial damageNTSB CEN11LA375Accident · No injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Junction City, KSThe degraded engine performance due to low compression on the cylinder and delayed ignition timing.Jun 4, 2011 · N50052 · Substantial damageNTSB CEN11IA106Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Olathe, KSThe loss of engine power for undetermined reasons.Oct 21, 2010 · N767TP · No damageNTSB CEN10LA234Accident · 1 fatalLimited investigationFinal reportCGS Hawk · Haysville, KSThe pilot’s failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control of the airplane, for undetermined reasons.May 2, 2010 · UNREG · Substantial damageNTSB CEN09CA473Accident · Minor injuriesData collectionFinal reportStinson 108 · Gardner, KSThe pilot's failure to ensure that the fuel selector valve was set properly in its detent prior to takeoff, resulting in fuel starvation.Jul 21, 2009 · N192C · Substantial damageNTSB CEN09CA064Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Stafford, KSA loss of engine power for undetermined reasons.Nov 16, 2008 · N6744W · Substantial damageNTSB DFW08CA213Accident · Serious injuriesData collectionFinal reportAerotrike Spirit · Vinland Valley, KSThe flight instructor's failure to maintain control of the sport aircraft on takeoff.Aug 15, 2008 · N226MB · Substantial damageNTSB 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.Jan 26, 2008 · N31559 · Substantial damageNTSB 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..Oct 10, 2007 · N4400N · Substantial damageNTSB 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.Sep 2, 2007 · N7476 · Substantial damageNTSB 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.Aug 28, 2007 · N7325L · Substantial damageNTSB 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.Jul 9, 2007 · N9076R · Substantial damageNTSB DEN07LA083Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Topeka, KSThe use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…Apr 9, 2007 · N460B · Substantial damageNTSB DEN06LA118Accident · 1 fatalLimited investigationFinal reportScheibe Flugzeugbau SF-24A Motorspatz · Wichita, KSThe pilot's failure to maintain aircraft control. Factors were the low airspeed and the inadvertent stall and spin.Aug 25, 2006 · N41FA · DestroyedNTSB DEN06LA097Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Holcomb, KSthe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 13, 2006 · N4422S · Substantial damageNTSB DEN06CA085Accident · No injuriesData collectionFinal reportBrent W. Brown Murphy Moose · St. Francis, KSthe pilot's failure to open the fuel selector valve, resulting in fuel starvation. Contributing factors were the pilot's failure to use a checklist, his attention being diverted, and the fence.Jun 10, 2006 · N142SR · Substantial damageNTSB DEN06CA081Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Dighton, KSThe broken rocker arm boss causing the number 1 cylinder exhaust valve to stay closed and subsequently the engine failed. A factor contributing to the accident was the soft field the airplane set down in.Jun 1, 2006 · N14RY · Substantial damageNTSB DEN06LA063Accident · No injuriesLimited investigationFinal reportRumble/Williams/Boomhower Starduster II · Junction City, KSVapor lock which resulted in total engine failure and the pilot's abrupt brake application on touchdown. Factors contributing to the accident were the improper design of the fuel system resulting in the misrouting of the fuel lines close to the exhaust pipes,…Apr 14, 2006 · N7JC · Substantial damageNTSB DEN06LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Manhattan, KSA loss of engine power due to the intermittent grounding of the left magneto "P" lead, causing the fuel controller to search and the engine to surge then lose power, and the pilot's failure to attain proper runway alignment. Contributing factors were the…Mar 1, 2006 · N7824T · Substantial damageNTSB DEN06LA039Accident · 1 fatalLimited investigationFinal reportSpane RV-4 · Wichita, KSThe pilot's inadequate preparation prior to takeoff, and his failure to maintain control of the airplane resulting in a stall and subsequent crash. Factors contributing to the accident were the unsecured canopy latch, the pilot's diverted attention, and the…Feb 17, 2006 · N437T · Substantial damageNTSB DEN06LA007Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · New Century, KSloss of engine power due to the pilot's improper use of carbuetor heat and his improper inflight planning/decision. Contributing factors were the inadequate supervision of the student by the flight instructor, conditions conducive to carburetor ice, dark…Oct 12, 2005 · N8875D · Substantial damageNTSB CHI04CA224Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301 · Cambridge, KSThe pilot not jettisoning his chemical load during initial climb with the reported loss of airplane performance. Factors were the reported loss of aircraft performance and the tree.Aug 12, 2004 · N2353W · Substantial damageNTSB CHI04CA090Accident · No injuriesData collectionFinal reportSchleicher ASW-20 · Yoder, KSThe pilot's failure to secure the elevator Louis L'Hotellier connector with a safety pin or wire as directed in several airworthiness directives and his inadequate preflight inspection of the sailplane, both of which resulted in the in-flight loss of elevator…Mar 28, 2004 · N232EM · Substantial damageNTSB CHI03LA186Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Douglass, KSThe pilot's failure to attain adequate airspeed and his premature liftoff, which resulted in a stall. A factor to the accident was the tree.Jun 30, 2003 · N564B · Substantial damageNTSB CHI03LA083Accident · No injuriesLimited investigationFinal reportNabole Steen Skybolt · Chanute, KSThe partial loss of engine power during takeoff-initial climb for undetermined reasons. The pilot's improper decision and unsuitable terrain are contributing factors.Mar 15, 2003 · N75JD · Substantial damageNTSB CHI03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Halstead, KSFailure by the flight crew to execute an aborted takeoff when acceleration degraded and the improper soft field takeoff procedure as flown by the private pilot. Contributing factors were inadequate supervision by the flight instructor and the tailwind…Feb 5, 2003 · N5681P · Substantial damageNTSB CHI02LA283Accident · Serious injuriesLimited investigationFinal reportTerning Sky Scout · Sedan, KSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.Sep 12, 2002 · N174BT · Substantial damageNTSB CHI02LA219Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Abilene, KSThe pilot failed to achieve clearance over the trees and wires. Factors associated with the accident were the pilot failed to use all available runway, a downwind takeoff was performed, the tailwind, trees, and wires.Jul 29, 2002 · N90TC · Substantial damageNTSB CHI02LA143Accident · Minor injuriesLimited investigationFinal reportRose 75% Scale Fokker D8 · Derby, KSInadequate preflight planning and inadequate compensation for the wind conditions which resulted in a failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the trees which the airplane contacted…May 25, 2002 · N2188X · Substantial damage