NTSB investigations, WY
15 cases where NTSB found Tailwind.
Cases per year
| 2008 | 3 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2022 | 1 |
| 2024 | 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\", '03034015'))
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", '03034015')) 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 WPR26LA088Accident · No injuriesClass 4 · LimitedFinal reportJordan Valley CCX-2000 · Alcova, WYThe pilot's excessive brake application during the landing roll resulting in a nose over.NTSB ANC24LA070Accident · No injuriesClass 4 · LimitedFinal reportRoberts Jeff Super RV8 · Carter, WYThe pilots encounter with a shifting winds during takeoff, which resulted in a loss of control and runway excursion.NTSB WPR22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Wheatland, WYThe pilot’s improper landing flare which, resulted in a bounced landing and subsequent nose over.NTSB WPR20CA154Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Spotted Horse, WYThe pilot's loss of directional control during an aborted takeoff with a tailwind, which resulted in a noseover.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 GAA19CA394Accident · No injuriesData collectionFinal reportMerit CCX-2000 · Casper, WYThe pilot's failure to maintain directional control during landing with a tailwind, which resulted in a ground loop.NTSB GAA19CA384Accident · No injuriesData collectionFinal reportAmerican AA5 · Cheyenne, WYThe pilot's failure to maintain a proper descent rate and landing flare during landing with a tailwind, which resulted in a hard landing and a subsequent loss of directional control, runway excursion, and collision with objects.NTSB 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 WPR13FA405Accident · 2 fatalField investigationFinal reportKamtz RV-7A · Jackson Hole, WYA loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation. Also causal was the pilot’s failure to adequately compensate for the…NTSB WPR12FA432Accident · 1 fatalField investigationFinal reportKundel Vans RV 7A · Laramie, WYThe pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.NTSB WPR11CA365Accident · No injuriesData collectionFinal reportCessna 162 · Rawlings, WYThe pilot's decision to attempt a takeoff at a density altitude that was outside the performance envelope of the airplane. Also causal was the flight's likely encounter with a sudden tailwind gust.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.NTSB LAX08LA196Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Buffalo, WYThe pilot's attempted downwind takeoff that resulted in an aborted takeoff. Contributing to the accident was the unsuitable terrain.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.