NTSB investigations, WY
12 cases where NTSB found Ceiling/visibility/precip.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2018 | 1 |
| 2024 | 2 |
Where
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\" = 'WY' 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\", '030350'))
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.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030350')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR25LA029Accident · Serious injuriesClass 3 · LimitedFinal reportDaher TBM700 · Pinedale, WYThe pilot’s failure to ensure that the airplane was free of snow contamination before takeoff and to follow the manufacturer’s anti-icing procedure during continued snowfall, which resulted in an aerodynamic stall and loss of control shortly after liftoff.…NTSB WPR24FA257Accident · 7 fatalClass 3 · FieldFinal reportPilatus PC-12/47E · Recluse, WYThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an in-flight breakup. Contributing to the accident was the pilot’s distraction from the autopilot disconnecting due to an…NTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.NTSB WPR14FA188Accident · 2 fatalField investigationFinal reportMooney M20C · Cody, WYThe non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.NTSB WPR13FA138Accident · 1 fatalField investigationFinal reportCessna 172M · Saratoga, WYThe pilot’s decision to attempt flight into approaching adverse weather, which led to his low-level flight, encounter with mountain obscuration and moderate turbulence, and his subsequent loss of airplane control. Contributing to the severity of the pilot’s…NTSB WPR13FA053Accident · 1 fatalField investigationFinal reportCessna 182D · Bondurant, WYThe noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.NTSB WPR13FA008Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Laramie Peak, WYThe noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.NTSB WPR12FA164Accident · 1 fatalField investigationFinal reportCessna 320D · Green River, WYThe pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.NTSB WPR12FA040Accident · 1 fatalField investigationFinal reportCessna T337 · Casper, WYThe pilot's failure to maintain airspeed and airplane control while maneuvering in low visibility and icing conditions.NTSB WPR11FA228Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Rock Springs, WYThe pilot’s decision to continue flight into an area of known adverse weather, which resulted in an accumulation of structural ice that led to a loss of control and in-flight breakup. Also causal was the pilot’s inadequate preflight weather planning.NTSB WPR11FA082Accident · 3 fatalField investigationFinal reportAero Commander 114B · Lander, WYThe non-instrument-rated pilot's decision to continue visual flight in instrument or marginal visual meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of…NTSB 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.