NTSB investigations, 2008, WY

11 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2008, WY per year, 2008–2026: 96 cases
200811
20091
20102
201112
20128
20135
20143
201510
20167
20177
20185
20197
20201
20211
20223
20232
20245
20252
20264

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\") = 2008
    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\" = '470' 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 SEA08LA213Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woods Landing-Jelm, WYThe pilot's encounter with a loss of tail rotor effectiveness event and his failure to maintain directional control while maneuvering. Contributing to the accident were the tailwind condition and the sloping, uneven terrain.Sep 27, 2008 · N59611 · Substantial damageNTSB LAX08CA275Accident · No injuriesData collectionFinal reportPiper PA-11 · Sheridan, WYThe pilot's inadequate compensation for the existing gusty wind conditions and likely windshear encounter and his failure to maintain an adequate airspeed that resulted in a stall/mush.Aug 21, 2008 · N1106T · Substantial damageNTSB LAX08FA265Accident · 3 fatalField investigationFinal reportCessna R172K · Rock Springs, WYThe failure of both pilots to see and avoid each other's aircraft.Aug 10, 2008 · N758NH · 2 aircraft · DestroyedNTSB LAX08CA249Accident · No injuriesData collectionFinal reportFowler SX300 · Cheyenne, WYLoss of engine power due to fuel starvation.Jul 30, 2008 · N99F · Substantial damageNTSB LAX08LA230Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Rock Springs, WYA total loss of engine power due to the failure of the No. 1 bearing for undetermined reasons.Jul 15, 2008 · N3276T · Substantial damageNTSB LAX08CA189Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Laramie, WYThe pilot's failure to attain and maintain an adequate airspeed during a go around, that resulted in a stall/mush. Contributing to the accident was the tailwind condition.Jun 24, 2008 · N877CM · 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 LAX08LA103Accident · Serious injuriesLimited investigationFinal reportArtic S-1B2 · Rock River, WYThe pilot's failure to maintain an adequate airspeed while maneuvering that led to an inadvertent stall. A contributing factor in the accident was the low altitude of the flight that reduced the time available for recovery from an upset.Apr 14, 2008 · N73WY · Substantial damageNTSB SEA08LA105Accident · 1 fatalLimited investigationFinal reportGlasair Glasair III · Cheyenne, WYThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, snow and whiteout conditions.Apr 7, 2008 · C-GGTM · Substantial damageNTSB DEN08LA054Accident · No injuriesLimited investigationFinal reportMacAdams Titan Tornado 912 · Rock Springs, WYThe loss of engine power for undetermined reasons. Contributing to the accident was the snow covered ravine.Jan 24, 2008 · N142TT · 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