NTSB investigations, KS
18 cases where NTSB found Altitude.
Cases per year
| 2008 | 1 |
|---|---|
| 2013 | 2 |
| 2014 | 1 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2023 | 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\", '01062012'))
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", '01062012')) 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 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 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 CEN21LA165Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Lake City, KSThe pilot’s failure to maintain clearance from power lines during power line maintenance.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 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 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 CEN19LA086Accident · No injuriesLimited investigationFinal reportBeech 65 · Colby, KSThe pilot’s failure to properly secure the crew hatch door before takeoff, which resulted in his distraction and his failure to maintain airplane control and airspeed.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 GAA18CA573Accident · No injuriesData collectionFinal reportHiller UH 12E · Frankfort, KSThe ground crewmember's improper grabbing of the hovering helicopter's skid during an external load hook-up, which resulted in the helicopter descending and the main rotors striking ground equipment.NTSB GAA17CA390Accident · Minor injuriesData collectionFinal reportBell 407 · Topeka, KSThe pilot’s failure to maintain clearance from a building during landing.NTSB CEN17LA009Accident · Minor injuriesLimited investigationFinal reportAero Smart Solutions Lancair Evolution · Iola, KSWater 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 CEN16CA277Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Topeka, KSThe pilot’s failure to maintain clearance from a wire during an agricultural flight.NTSB GAA16CA107Accident · Minor injuriesData collectionFinal reportPiper PA 46 · Ottawa, KSThe 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 CEN14CA427Accident · Serious injuriesData collectionFinal reportAir Tractor AT 401B · Cimarron, KSThe pilot's failure to maintain clearance from the antenna guy wire during an aerial application pass.NTSB CEN13CA278Accident · No injuriesData collectionFinal reportBalloon Works Firefly 8B-15 · Anthony, KSThe pilot’s failure to monitor the balloon's altitude, which resulted in the balloon impacting an airport rotating beacon tower.NTSB CEN13LA254Accident · Serious injuriesLimited investigationFinal reportMason Robert Kolb Mark 3X · Lawrence, KSThe noncertificated pilot’s improper decision to depart with a tailwind.NTSB DEN08FA059Accident · 2 fatalField investigationFinal reportCessna 414A · Benton, KSThe pilot's failure to maintain clearance from the trees. Contributing to the accident was the pilot's flight into known adverse weather conditions and the low clouds and visibility.