NTSB investigations, WY

60 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\" = 'WY' 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 WPR12CA101Accident · No injuriesData collectionFinal reportLearjet 31A · Wheatland, WYThe flight crew’s loss of directional control during landing on an ice- and water-contaminated runway, which resulted in a runway excursion.Feb 11, 2012 · N382AL · Substantial damageNTSB WPR11CA396Accident · No injuriesData collectionFinal reportAviat A-1C-200 · Casper, WYThe pilot's failure to maintain directional control during landing.Aug 19, 2011 · N53WY · Substantial damageNTSB WPR11LA389Accident · No injuriesLimited investigationFinal reportGlasair Sportsman · Pinedale, WYThe pilot's failure to maintain directional control during the landing roll.Aug 8, 2011 · N117CE · Substantial damageNTSB WPR11LA280Accident · No injuriesLimited investigationFinal reportInhofe/ Davis Vans RV-8 · Sheridan, WYThe pilot's inadequate directional control during the landing roll.Jun 22, 2011 · N4546Y · Substantial damageNTSB WPR10CA358Accident · No injuriesData collectionFinal reportAviat A-1B · Casper, WYThe pilot's failure to maintain directional control during landing.Jul 19, 2010 · N115XT · Substantial damageNTSB WPR09CA162Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jackson, WYThe pilot's failure to maintain directional control during the landing roll.Mar 21, 2009 · N3920Z · Substantial damageNTSB WPR09CA067Accident · No injuriesData collectionFinal reportCessna 208B · Rock Springs, WYThe pilot's failure to maintain control of the airplane while taxiing. Contributing to the accident were the gusty winds.Dec 27, 2008 · N890FE · Substantial damageNTSB WPR09CA059Accident · No injuriesData collectionFinal reportCessna 210 · Sheridan, WYMaintenance personnel's failure to reinstall the left front pilot's seat correctly, which resulted in the pilot's loss of control and subsequent impact with a taxiway sign.Dec 17, 2008 · N9619T · Substantial damageNTSB LAX08CA119Accident · No injuriesData collectionFinal reportCarlson Quickie Q2 · Casper, WYA loss of directional control on landing due to the separation of the wing leveler trim knob and resulting reduced aileron control.Apr 19, 2008 · N39425 · Substantial damageNTSB DEN08LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Pine Bluffs, WYThe pilot's failure to maintain control of the airplane. Contributing factors in this accident were the unfavorable wind and the snow bank.Jan 12, 2008 · N12606 · Substantial damage