NTSB investigations, KS
20 cases where the sequence of events included Other weather encounter.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 1 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 5 |
| 2018 | 3 |
| 2020 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '400' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN25LA314Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Goodland, KSThe pilot’s failure to maintain aircraft control during the landing and go-around with variable wind direction and speed.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 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 CEN20CA356Accident · No injuriesClass 4 · Data collectionFinal reportMaule M5 · Olathe, KSThe pilot's loss of directional control during landing.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 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 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 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 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 GAA17CA123Accident · No injuriesData collectionFinal reportPiper PA 28R · Wichita, KSThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA17CA003Accident · No injuriesData collectionFinal reportAndrew Harold Stol CH 701 · Berryton, KSThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion.NTSB GAA16CA379Accident · Minor injuriesData collectionFinal reportJesse Saint/Troy Townsend/Etha CH-801 · Beaumont, KSThe pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard bounced landing and a nose over.NTSB GAA16CA028Accident · No injuriesData collectionFinal reportMaule M5 · Goodland, KSThe pilot's inadequate crosswind compensation and subsequent loss of directional control during the landing roll, resulting in a runway excursion and nose over.NTSB CEN15CA201Accident · Minor injuriesData collectionFinal reportFiebich Paul Dean Airbike RX40 · Derby, KSThe pilot's inadequate compensation for wind conditions during the landing, which resulted in a hard landing and separation of the left main landing gear.NTSB CEN15CA184Accident · No injuriesData collectionFinal reportCessna T188C · Burdett, KSThe pilot did not maintain directional control of the airplane in gusting wind conditions.NTSB CEN10CA479Accident · No injuriesData collectionFinal reportBeech A23-19 · Wichita, KSThe pilot’s loss of airplane control while landing with a gusting wind.NTSB CEN10LA068Accident · No injuriesLimited investigationFinal reportBeech V35 · Dodge City, KSThe 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 CEN09CA141Accident · No injuriesData collectionFinal reportCessna 172S · Emporia, KSThe pilot's inadequate compensation for the wind conditions during the touch-and-go. Contributing to the accident were the gusty crosswinds.