NTSB investigations, UT
17 cases where NTSB found Tailwind.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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\" = 'UT' 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" = 'UT' 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 WPR25LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · West Jordan, UTThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot inadvertently using a runway that resulted in a tailwind condition and the flight instructors delayed remedial action.NTSB WPR24LA220Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Cedar City, UTThe pilot’s failure to maintain directional control during the landing roll, with gusty tailwind.NTSB WPR24LA016Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235C · Provo, UTThe pilot’s failure to maintain directional control during landing.NTSB GAA20CA032Accident · Minor injuriesData collectionFinal reportFlight Design Ctls · Monument Valley, UTThe pilot's failure to maintain lateral control and to attain adequate altitude during takeoff with a quartering tailwind in gusting wind conditions, which resulted in impact with a sandy berm left of the runway.NTSB GAA17CA269Accident · No injuriesData collectionFinal reportJohnson Kenneth Super CUB Sport · Spanish Fork, UTThe pilot's decision to land with a gusting tailwind and his subsequent failure to maintain directional control.NTSB GAA16CA496Accident · No injuriesData collectionFinal reportCessna 172 · Delta, UTThe student pilot’s improper landing flare, which resulted in a hard, porpoised landing.NTSB GAA15LA131Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Escalante, UTThe pilot’s inadequate preflight planning and his subsequent decision to attempt to climb over rising terrain with the helicopter over maximum gross weight while operating in high-density altitude conditions with a tailwind, which resulted in its inability to…NTSB GAA15CA004Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Hurricane, UTThe pilot's failure to maintain directional control during the landing roll.NTSB WPR15LA013Accident · No injuriesLimited investigationFinal reportBeech H35 · Bountiful, UTThe pilot's loss of directional control during a tailwind landing.NTSB WPR13LA307Accident · Serious injuriesLimited investigationFinal reportBoson RV-4 · Hurricane, UTThe pilot’s incorrect approach/descent path with a tailwind, which resulted in a long landing at an excessive groundspeed and a subsequent runway excursion.NTSB WPR13CA153Accident · No injuriesData collectionFinal reportAndre Kostrzewa Mustang 2 · Bountiful, UTThe pilot’s failure to maintain airplane control during the landing flare in tailwind conditions, which resulted in a hard landing.NTSB WPR12GA243Accident · 2 fatalFinal reportLockheed P2V-7 · Modena, UTThe flight crew's misjudgment of terrain clearance while maneuvering for an aerial application run, which resulted in controlled flight into terrain. Contributing to the accident was the flight crew's failure to follow the lead airplane's track and to…NTSB WPR10CA355Accident · No injuriesData collectionFinal reportLeonard Trudy Kitfox III · Monument Valley, UTThe pilot's inadequate compensation for the wind effects and failure to maintain directional control during an attempted go-around from a landing.NTSB WPR09CA105Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Bountiful, UTThe pilot's improper decision to fly at low altitude while maneuvering in mountainous terrain in a canyon and inadvertently exceeding the climb capability of the helicopter. Contributing to the accident were a high density altitude, mountainous terrain, and a…NTSB WPR09LA043Accident · 1 fatalLimited investigationFinal reportCessna 170B · Hanna, UTThe flight's encounter with adverse tailwinds and downdrafts in mountainous terrain that exceeded the airplane's climb capability.NTSB LAX08LA179Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Beaver, UTThe pilot's failure to attain and maintain an adequate airspeed during the initial climb as a result of his inadequate preflight planning and improper use of the mixture control. Contributing to the accident were the tailwind and high density altitude.NTSB LAX08CA167Accident · No injuriesData collectionFinal reportCessna 182 · Moab, UTThe pilot's inadequate compensation for the tailwind condition, and improper use of additional power while taxiing. Contributing to the accident was soft ground and a gusting tailwind.