NTSB investigations, 2015, WY

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

Cases per year

20082026
NTSB investigations, 2015, WY per year, 2008–2026: 60 cases
20084
20091
20101
20113
20123
20131
20142
20156
20163
20175
20183
20196
20201
20212
20228
20245
20266

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 year(c.\"eventDate\") = 2015
    AND 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 GAA15CA291Accident · No injuriesData collectionFinal reportMaule M 7-235C · Kemmerer, WYA hard landing which resulted in a loss directional control and ground loop.Sep 30, 2015 · N4244L · Substantial damageNTSB GAA15CA264Accident · No injuriesData collectionFinal reportAviat A1 · Rock Springs, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 18, 2015 · N288MD · Substantial damageNTSB GAA15CA168Accident · No injuriesData collectionFinal reportCessna A188B · Saratoga, WYThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion, and a ground loop.Jul 1, 2015 · N60691 · Substantial damageNTSB CEN15LA250Accident · No injuriesLimited investigationFinal reportCessna T188C · Pine Bluffs, WYThe pilot's loss of directional control to the right for reasons that could not be determined during examination of the right main landing gear wheel and brake drum.May 27, 2015 · N1965J · Substantial damageNTSB GAA15LA025Accident · Serious injuriesLimited investigationFinal reportSpaulding Errol Rans S 7 Courier · Pinedale, WYThe pilot’s decision to take off in a crosswind that exceeded the airplane’s maximum demonstrated crosswind capability and his subsequent inability to maintain directional control.Mar 27, 2015 · N4272M · Substantial damageNTSB GAA15CA007Accident · No injuriesData collectionFinal reportAviat A1 - B · Afton, WYThe pilot's failure to maintain directional control during landing.Mar 13, 2015 · C-FTAD · Substantial damage