NTSB investigations, KS

7 cases where NTSB found Tree(s).

Cases per year

20082026
NTSB investigations, KS per year, 2008–2026: 7 cases
20082
20121
20161
20181
20192

Latest 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\", '03022020'))
  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 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 GAA19CA161Accident · Minor injuriesData collectionFinal reportCessna L19 · Benton, KSThe pilot's receiving instruction’s failure to maintain directional control during the landing roll, which resulted in impact with trees and a house.Mar 11, 2019 · N4431C · Substantial damageNTSB 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.Apr 24, 2018 · N9281E · Substantial damageNTSB GAA17CA053Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Valley Center, KSThe pilot's failure to maintain directional control during the landing roll and to see and avoid the airplane stopped on the edge of the runway.Oct 22, 2016 · N68117 · 2 aircraft · Substantial damageNTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.Apr 7, 2012 · N5981F · Substantial damageNTSB DEN08CA068Accident · No injuriesData collectionFinal reportPiper PA-28-150 · Mankato, KSthe student pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the fence and trees.Mar 28, 2008 · N50GM · Substantial damageNTSB 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.Feb 17, 2008 · N41LP · Destroyed