# NTSB investigations, KS: Enroute

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 10 · 500 cases

## Latest cases

- [NTSB CEN27LA017](https://openairdocs.org/ntsb/CEN27LA017.md): Donald K Stovall Pietenpol Aircamper · Syracuse, KS · Accident · Class 3 · Limited · Investigation open · Oct 13, 2026 · N728MK
- [NTSB CEN26LA249](https://openairdocs.org/ntsb/CEN26LA249.md): Cessna 150 · Ellsworth, KS · Accident · No injuries · Class 4 · Limited · Final report · Jul 10, 2026 · N3773J · Substantial damage
  > The pilot’s inadequate preflight fuel planning which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s self-induced pressure to complete the flight.
- [NTSB CEN26LA194](https://openairdocs.org/ntsb/CEN26LA194.md): Lockwood AIR CAM · Hutchinson, KS · Accident · No injuries · Class 4 · Limited · Final report · May 20, 2026 · N32F · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN26LA173](https://openairdocs.org/ntsb/CEN26LA173.md): Cirrus Design SR22T · Chanute, KS · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Apr 23, 2026 · N39VF · Substantial damage
  > On April 23, 2026, at about 1445 central daylight time, a Cirrus SR22T was substantially damaged when it was involved in an accident near Chanute, Kansas. The pilot and pilot-rated passenger sustained minor injuries. The airplane was operated as a Title 14…
- [NTSB CEN25FA166](https://openairdocs.org/ntsb/CEN25FA166.md): Piper J3C-65 · Wilson, KS · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 4, 2025 · N98416 · Destroyed
  > On May 4, 2025, about 1325 central daylight time, a Piper J3C-65 airplane, N98416 was destroyed when it was involved in an accident near Wilson, Kansas. The pilot was fatally injured. The flight was operated under the provisions of Title 14 Code of Federal…
- [NTSB CEN25LA101](https://openairdocs.org/ntsb/CEN25LA101.md): Cessna 177A · Farlinville, KS · Accident · No injuries · Class 4 · Limited · Final report · Feb 20, 2025 · N30413 · Substantial damage
  > A loss of engine power that resulted from fuel contamination when it was treated with a 70% isopropyl alcohol solution (antiseptic) that contained water. Contributing to the accident were vague fuel treatment instructions provided by the operator.
- [NTSB CEN24FA243](https://openairdocs.org/ntsb/CEN24FA243.md): Waco YKC · Selden, KS · Accident · 2 fatal · Class 3 · Field · Final report · Jun 30, 2024 · N14137 · Substantial damage
  > The 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 CEN24LA143](https://openairdocs.org/ntsb/CEN24LA143.md): Bell Helicopter Textron Canada 407 · Moran, KS · Accident · No injuries · Class 4 · Limited · Final report · Mar 29, 2024 · N910GX · Substantial damage
  > An in-flight collision with birds while in cruise flight.
- [NTSB CEN24LA022](https://openairdocs.org/ntsb/CEN24LA022.md): Piper PA-28-181 · Iola, KS · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 22, 2023 · N5324F · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN23LA344](https://openairdocs.org/ntsb/CEN23LA344.md): Beech A36 · Oberlin, KS · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 20, 2023 · N36900 · Substantial damage
  > The blockage of the left fuel tank vent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident of the pilot’s failure to use his checklist to address the loss of engine power.
- [NTSB CEN23LA313](https://openairdocs.org/ntsb/CEN23LA313.md): Pietenpol Aircamper · Gardner, KS · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 19, 2023 · N34KP · Substantial damage
  > A loss of engine power due to lead fouling of a spark plug.
- [NTSB CEN22LA201](https://openairdocs.org/ntsb/CEN22LA201.md): Quicksilver Sport 2S · Osawatomie, KS · Accident · Serious injuries · Class 4 · Limited · Final report · May 13, 2022 · N202JC · Substantial damage
  > The 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 CEN21LA187](https://openairdocs.org/ntsb/CEN21LA187.md): Eurocopter EC120 · LeRoy, KS · Accident · No injuries · Class 3 · Limited · Final report · Apr 9, 2021 · N421PB · Substantial damage
  > The 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 CEN20LA122](https://openairdocs.org/ntsb/CEN20LA122.md): Cessna 208 · LaCrosse, KS · Accident · 1 fatal · Class 3 · Limited · Final report · Mar 17, 2020 · N274PM · Destroyed
  > An infight loss of control as a result of pilot impairment, the cause of which could not be determined.
- [NTSB CEN19FA029](https://openairdocs.org/ntsb/CEN19FA029.md): Beech 55 · Liberal, KS · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2018 · N4817M · Substantial damage
  > The 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 CEN18LA356](https://openairdocs.org/ntsb/CEN18LA356.md): Air Tractor AT 301 · Partridge, KS · Accident · No injuries · Limited investigation · Final report · Aug 29, 2018 · N3164K · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN18FA108](https://openairdocs.org/ntsb/CEN18FA108.md): Beech 58 · Ulysses, KS · Accident · 2 fatal · Field investigation · Final report · Feb 23, 2018 · N678DD · Destroyed
  > An inflight loss of control and collision with terrain for reasons that could not be determined.
- [NTSB GAA18CA124](https://openairdocs.org/ntsb/GAA18CA124.md): Cessna 150 · El Dorado, KS · Accident · No injuries · Data collection · Final report · Feb 4, 2018 · N61024 · Substantial damage
  > The 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 CEN17LA009](https://openairdocs.org/ntsb/CEN17LA009.md): Aero Smart Solutions Lancair Evolution · Iola, KS · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 2016 · N38DM · Substantial damage
  > Water 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 CEN16LA381](https://openairdocs.org/ntsb/CEN16LA381.md): Scottish Series 100 MDL 101 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Sep 22, 2016 · N432BD · Substantial damage
  > The 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 GAA16CA107](https://openairdocs.org/ntsb/GAA16CA107.md): Piper PA 46 · Ottawa, KS · Accident · Minor injuries · Data collection · Final report · Jan 19, 2016 · N113WB · Substantial damage
  > The 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 DCA16CA010](https://openairdocs.org/ntsb/DCA16CA010.md): Boeing 737-924ER · Plevna, KS · Accident · Serious injuries · Data collection · Final report · Oct 24, 2015 · N69838 · No damage
  > An inadvertent encounter with clear air turbulence resulting in a serious injury to a flight attendant.
- [NTSB CEN15LA146](https://openairdocs.org/ntsb/CEN15LA146.md): Piper PA 28R-180 · Haviland, KS · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 2015 · N3918T · Substantial damage
  > The 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 CEN15LA117](https://openairdocs.org/ntsb/CEN15LA117.md): Piper PA-31-350 · Goodland, KS · Accident · No injuries · Limited investigation · Final report · Jan 21, 2015 · N66906 · Substantial damage
  > The 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 CEN14LA376](https://openairdocs.org/ntsb/CEN14LA376.md): Air Tractor AT 401B · Ellis, KS · Accident · 1 fatal · Limited investigation · Final report · Jul 18, 2014 · N4223F · Substantial damage
  > The 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 CEN14LA375](https://openairdocs.org/ntsb/CEN14LA375.md): Grumman Acft ENG Cor-Schweizer G 164A · Fairview, KS · Accident · No injuries · Limited investigation · Final report · Jul 18, 2014 · N6743Q · Substantial damage
  > The backfire of the engine and its loss of power for reasons that could not be determined based on the available evidence.
- [NTSB CEN14FA009](https://openairdocs.org/ntsb/CEN14FA009.md): Cessna 500 · Derby, KS · Accident · 2 fatal · Field investigation · Final report · Oct 18, 2013 · N610ED · Destroyed
  > The airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…
- [NTSB CEN13LA561](https://openairdocs.org/ntsb/CEN13LA561.md): Weatherly 620 · Ulysses, KS · Accident · No injuries · Limited investigation · Final report · Sep 25, 2013 · N4623M · Destroyed
  > An in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.
- [NTSB CEN13LA514](https://openairdocs.org/ntsb/CEN13LA514.md): Challenger II · Emporia, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 2013 · UNREG · Substantial damage
  > The right wing’s folding up in flight for reasons that could not be determined because an examination did not reveal any abnormalities with the airframe that would have precluded normal operation.
- [NTSB CEN13LA280](https://openairdocs.org/ntsb/CEN13LA280.md): Piper PA-36-285 · Galena, KS · Accident · Minor injuries · Limited investigation · Final report · May 14, 2013 · N57719 · Substantial damage
  > The loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.
- [NTSB CEN13LA245](https://openairdocs.org/ntsb/CEN13LA245.md): Raytheon G36 · Hoxie, KS · Accident · No injuries · Limited investigation · Final report · Apr 26, 2013 · N222GL · Substantial damage
  > The loss of engine power due to fuel starvation for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13FA049](https://openairdocs.org/ntsb/CEN13FA049.md): Cessna 208B · Wichita, KS · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2012 · N793FE · Substantial damage
  > The total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.
- [NTSB CEN12LA558](https://openairdocs.org/ntsb/CEN12LA558.md): Beech A36 · Ruleton, KS · Accident · No injuries · Limited investigation · Final report · Aug 17, 2012 · N262EA · Substantial damage
  > The improper installation of the wastegate controller O-ring, which resulted in a partial loss of engine power.
- [NTSB CEN12LA551](https://openairdocs.org/ntsb/CEN12LA551.md): Piper PA-24-260 · Holton, KS · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 2012 · N8546P · Substantial damage
  > The mechanic's failure to adequately torque the right magneto attachment nuts, allowing the right magneto to come loose, which allowed engine oil to escape, causing the engine to seize.
- [NTSB CEN12FA290](https://openairdocs.org/ntsb/CEN12FA290.md): Cessna 401 · Chanute, KS · Accident · 4 fatal · Field investigation · Final report · May 11, 2012 · N9DM · Substantial damage
  > The malfunction of the cabin heater, which resulted in an inflight fire and smoke in the airplane. Contributing to the accident was the pilot’s lack of understanding concerning the status of the airplane's heater system following and earlier overheat event…
- [NTSB CEN12LA288](https://openairdocs.org/ntsb/CEN12LA288.md): Donald K Stovall Pietenpol Aircamper · Rose Hill, KS · Accident · No injuries · Limited investigation · Final report · May 9, 2012 · N728MK · Substantial damage
  > The loss of engine power due to carburetor icing.
- [NTSB CEN11CA679](https://openairdocs.org/ntsb/CEN11CA679.md): Waltman Theodore J Moose · Hays, KS · Accident · No injuries · Data collection · Final report · Sep 30, 2011 · N384JP · Substantial damage
  > Rudder flutter due to the design changes to the airplane's horizontal stabilizer.
- [NTSB CEN11FA634](https://openairdocs.org/ntsb/CEN11FA634.md): Riffel Jerris L RV-7A · Winfield, KS · Accident · 1 fatal · Field investigation · Final report · Sep 7, 2011 · N554JR · Substantial damage
  > The pilot’s in-flight loss of control. Contributing to the pilot’s fatal injury was his failure to use the available restraint systems, which resulted in him falling through the open canopy when the airplane inverted.
- [NTSB CEN10FA364](https://openairdocs.org/ntsb/CEN10FA364.md): Beech F33A · Perry, KS · Accident · 2 fatal · Field investigation · Final report · Jul 1, 2010 · N3071T · Substantial damage
  > The failure of the engine driven fuel pump causing a loss of engine power and the pilot's failure to maintain aircraft control resulting in an inadvertent stall. Contributing to the accident was the pilot’s failure to follow the emergency procedures checklist…
- [NTSB CEN10LA068](https://openairdocs.org/ntsb/CEN10LA068.md): Beech V35 · Dodge City, KS · Accident · No injuries · Limited investigation · Final report · Dec 6, 2009 · N108L · Substantial damage
  > The failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.
- [NTSB CEN09FA193](https://openairdocs.org/ntsb/CEN09FA193.md): Bell 206-L4 · Moundridge, KS · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2009 · N863H · Substantial damage
  > Inflight collision with terrain for undetermined reasons.
- [NTSB DFW08CA236](https://openairdocs.org/ntsb/DFW08CA236.md): Piper PA-32R-300 · Augusta, KS · Accident · No injuries · Data collection · Final report · Sep 18, 2008 · N6822J · Substantial damage
  > A loose oil line that resulted in a total loss of engine oil, causing the engine to cease.
- [NTSB DFW08LA135](https://openairdocs.org/ntsb/DFW08LA135.md): Bailey Varieze · Phillipsburg, KS · Accident · Serious injuries · Limited investigation · Final report · May 10, 2008 · N6553C · Substantial damage
  > The pilots failure to maintain aircraft control during an emergency landing. Contributing factors were the reported smoke and prevailing gusty wind conditions.
- [NTSB DFW08LA133](https://openairdocs.org/ntsb/DFW08LA133.md): Piper PA-32R-300 · Emporia, KS · Accident · Minor injuries · Limited investigation · Final report · May 8, 2008 · N385WR · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a blocked fuel outlet caused by the peeling off of a previously approved fuel tank sealer.
- [NTSB DFW08LA095](https://openairdocs.org/ntsb/DFW08LA095.md): Hawker Beechcraft G36 · El Dorado, KS · Accident · No injuries · Limited investigation · Final report · Apr 9, 2008 · N984W · Substantial damage
  > The improper installation of the fuel manifold valve's brass plug. Contributing to the accident was the unsuitable landing area for the forced landing.
- [NTSB DEN08FA058](https://openairdocs.org/ntsb/DEN08FA058.md): Piper PA-23-250 · Sterling, KS · Accident · 1 fatal · Field investigation · Final report · Feb 13, 2008 · N62793 · Destroyed
  > The loss of pitch control during cruise flight resulting from the separation of the stabilator trim actuator due to inadequate maintenenace.
- [NTSB DEN08LA041](https://openairdocs.org/ntsb/DEN08LA041.md): Mooney M20C · Phillipsburg, KS · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 2007 · N63LH · Destroyed
  > Total loss of engine power due to contamination of the carburetor, total blockage of the fuel inlet screen, and partial blockage of the fuel lines and fittings. Contributing to the accident were the dark night light conditions and the trees.
- [NTSB DEN08LA032](https://openairdocs.org/ntsb/DEN08LA032.md): Gomory Long EZ · LeRoy, KS · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 2007 · N191PS · Substantial damage
  > The loss of engine power due to fuel starvation. Contributing factors were the pilot's improper fuel calculations and in-flight planning.
- [NTSB DEN08IA022](https://openairdocs.org/ntsb/DEN08IA022.md): Douglas DC-8-73F · Wichita, KS · Incident · No injuries · Incident investigation · Final report · Nov 2, 2007 · N880UP · Minor damage
  > Failure of the recirculation fan motor end ball bearing.
- [NTSB DEN08IA030](https://openairdocs.org/ntsb/DEN08IA030.md): Beech C90A · Emporia, KS · Incident · No injuries · Incident investigation · Final report · Sep 22, 2007 · N871KS · No damage
  > The improper installation of the right elevator trim tab attachment hardware by maintenance personnel which resulted in excessive wear, fatigue, and the failure of the push-pull tube.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?state=KS&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?state=KS

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.