NTSB investigations, KS

65 cases where the sequence of events included Loss of control on ground.

Cases, newest first

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\" = '230' 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.

NTSB CEN12CA117Accident · No injuriesData collectionFinal reportLuscombe 8E · Atchison, KSThe pilot's inadequate directional control during the landing roll.Dec 17, 2011 · N71911 · Substantial damageNTSB CEN11CA685Accident · No injuriesData collectionFinal reportCessna A185F · Hays, KSThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Sep 6, 2011 · N550DP · Substantial damageNTSB CEN11CA447Accident · Minor injuriesData collectionFinal reportArion Lightning LS-1 · Garden City, KSThe pilot's failure to maintain aircraft control while landing.Jul 3, 2011 · N125GD · Substantial damageNTSB CEN11CA256Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Wichita, KSThe pilot's failure to maintain directional control during the landing roll.Mar 25, 2011 · N68117 · Substantial damageNTSB CEN09CA609Accident · No injuriesData collectionFinal reportAeronca 11AC · Augusta, KSThe pilot's failure to maintain directional control while landing with a quartering tailwind.Sep 26, 2009 · N9204E · Substantial damageNTSB CEN09CA507Accident · Serious injuriesData collectionFinal reportBoeing A75L300 · Salina, KSThe pilot's failure to maintain directional control during a touch-and-go.Aug 10, 2009 · N75263 · Substantial damageNTSB CEN09CA395Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Pittsburg, KSThe pilot's loss of directional control resulting in a ground-loop.Jun 27, 2009 · N702KB · Substantial damageNTSB 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.Jan 18, 2009 · N2465H · Substantial damageNTSB DEN08CA156Accident · No injuriesData collectionFinal reportCessna 177RG · Ellsworth, KSThe student pilot's failure to maintain directional control during the landing roll.Sep 18, 2008 · N8276G · Substantial damageNTSB DFW08CA174Accident · No injuriesData collectionFinal reportCessna 177 · Baldwin City, KSThe pilot's loss of directional control resulting from a hard landing and failure to recover from a bounced landing. Contributing to the accident was the crosswind.Jun 28, 2008 · N3337T · Substantial damageNTSB DFW08CA156Accident · No injuriesData collectionFinal reportAyres S-2R · McDonald, KSThe pilot's failure to maintain aircraft control during the takeoff. Contributing to the accident was the soft terrain.May 25, 2008 · N4002R · Substantial damageNTSB DFW08CA145Accident · No injuriesData collectionFinal reportWeatherly 201B · Nickerson, KSThe pilot's failure to maintain directional control during the takeoff roll.May 15, 2008 · N1264W · DestroyedNTSB 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 DFW08CA086Accident · No injuriesData collectionFinal reportAir Tractor At-301 · Plains, KSA loss of engine power as a result of a blocked carburetor. A factor was the lack of suitable terrain for the forced landing.Mar 26, 2008 · N4427S · Substantial damageNTSB DEN08CA063Accident · No injuriesData collectionFinal reportPiper PA-22 · Nickerson, KSthe pilot's failure to maintain directional control during the landing roll resulting in a departure from the runway environment. Contributing to the accident was the soft runway surface.Mar 10, 2008 · N1424A · Substantial damage