NTSB investigations, KS
11 cases where the defining event was Collision during takeoff/land.
Cases per year
| 2010 | 1 |
|---|---|
| 2012 | 1 |
| 2013 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '490') 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 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 CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.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 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 CEN18LA148Accident · Serious injuriesLimited investigationFinal reportMaule M 5-235C · Roxbury, KSThe pilot's failure to maintain directional control during takeoff from a road, which resulted in impact with a sign.NTSB GAA17CA390Accident · Minor injuriesData collectionFinal reportBell 407 · Topeka, KSThe pilot’s failure to maintain clearance from a building during landing.NTSB GAA17CA008Accident · No injuriesData collectionFinal reportBeech 35 · Lawrence, KSThe flight instructor’s delayed remedial action, which resulted in an unstabilized approach and collision with runway approach lights.NTSB CEN13CA423Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe pilot did not obtain adequate airspeed and clearance from obstructions during a grass field takeoff.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 CEN12LA373Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Gardner, KSThe pilot's delay in aborting the takeoff when the airplane was not accelerating as expected. Contributing to the accident was a wind shift during takeoff.NTSB CEN10LA575Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Basehor, KSThe pilot's improper touchdown point during landing and his delayed decision to execute a go-around. Contributing to the accident was the pilot's vision being obscured by the rain.