NTSB investigations, WY
25 cases where NTSB found Object/animal/substance.
Cases per year
| 2008 | 3 |
|---|---|
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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\", '030220'))
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", '030220')) 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 WPR26LA083Accident · No injuriesClass 4 · LimitedFinal reportRobinson R44 · Parkman, WYThe pilots’ failure to maintain separation while conducting air work in a common operational area. Contributing to the accident was the pilots’ divided attention associated with the mission activity and unreliable radio communications.NTSB WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…NTSB WPR24LA115Accident · Minor injuriesClass 4 · LimitedFinal reportZenith Zodiac CH601 · Rawlins, WYThe student pilot’s failure to see and avoid powerlines during an unstabilized approach, which resulted the airplane landing short of the runway and coming to rest inverted.NTSB WPR23FA289Accident · Serious injuriesClass 3 · FieldFinal reportCessna 177 · Gillette, WYThe pilot's decision to depart the high-density-altitude airport with the airplane at the maximum gross weight limit.NTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.NTSB WPR22LA334Accident · Serious injuriesClass 3 · LimitedFinal reportBuxbaum Mark Edward Long EZ · Medicine Bow, WYA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve head.NTSB WPR21LA259Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Lander, WYThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a fence.NTSB GAA19CA575Accident · Minor injuriesData collectionFinal reportPiper J3C · Lander, WYThe pilot's failure to maintain lateral control during takeoff with a quartering tailwind, which resulted in the right wing striking the ground, a runway excursion, impact with a fence, and a subsequent noseover.NTSB GAA19CA184Accident · No injuriesData collectionFinal reportPiper PA 16 · Afton, WYThe pilot's improper landing flare, which resulted in a bounced landing and loss of directional control and the airplane’s subsequent impact with a snowbank and nose-over during an attempted go-around.NTSB GAA18CA330Accident · No injuriesData collectionFinal reportSorensen Danny S BF9 2 · Evanston, WYThe pilot’s failure to fuel the biplane’s main fuel tank before the flight and his inadequate preflight inspection, during which he did not verify the fuel quantity, which resulted in fuel exhaustionNTSB GAA18CA098Accident · No injuriesData collectionFinal reportSwearingen SA227 · Rock Springs, WYThe pilot's failure to maintain directional control while taxiing in gusting tailwind conditions.NTSB GAA17CA251Accident · No injuriesData collectionFinal reportBender Joseph KIT Rotoway · Wheatland, WYThe pilot's decision to operate the helicopter in gusting wind and high-density altitude conditions and his positioning of the helicopter such that it resulted in a right quartering tailwind, which resulted in a loss of helicopter control due to a loss of…NTSB GAA17CA019Accident · No injuriesData collectionFinal reportPiper PA18 · Hanna, WYThe pilot's failure to maintain directional control during the landing roll in shifting wind conditions.NTSB GAA16CA354Accident · No injuriesData collectionFinal reportCessna 188 · Saratoga, WYThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in substantial damage.NTSB GAA15CA007Accident · No injuriesData collectionFinal reportAviat A1 - B · Afton, WYThe pilot's failure to maintain directional control during landing.NTSB WPR15LA058Accident · No injuriesLimited investigationFinal reportMcholland Glastar · Sheridan, WYA loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.NTSB WPR14CA047Accident · Minor injuriesData collectionFinal reportAviat A 1B · LaGrange, WYThe pilot's decision to land on a rough surface with hidden obstructions (holes).NTSB WPR12LA301Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Cheyenne, WYThe pilot's failure to maintain clearance with a power line. Contributing to the accident was the sun's glare.NTSB WPR12LA256Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Riverton, WYAn engine overspeed shortly after takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR11LA388Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Pine Bluffs, WYThe pilot's failure to maintain clearance from power lines during an aerial application flight.NTSB WPR11CA399Accident · No injuriesData collectionFinal reportRichmond Jim R CCK-1865 · Dubois, WYThe pilot's failure to maintain clearance from a wire during cruise flight.NTSB WPR11CA299Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Casper, WYAn in-flight collision with a bird at low altitude.NTSB WPR09CA051Accident · No injuriesData collectionFinal reportBeech B60 · Rock River, WYThe pilot's failure to maintain clearance from a power line due to the lack of forward visibility because of an ice-covered windshield. Contributing to the accident was the flight's encounter with icing weather conditions.NTSB 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.NTSB 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.