NTSB investigations, UT
6 cases where NTSB found Yaw control.
Cases per year
| 2011 | 1 |
|---|---|
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 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\" = '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\", '01062024'))
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", '01062024')) 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 WPR25LA006Accident · Minor injuriesClass 4 · LimitedFinal reportAgustawestland AW109SP · Kamas, UTThe pilot’s exceedance of the helicopter’s available power while landing in a confined area, which resulted in a loss of tail rotor effectiveness and a hard landing.NTSB WPR23LA147Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Midway, UTThe pilot’s failure to maintain aircraft control during a pinnacle landing that resulted in a hard landing and subsequent roll over.NTSB GAA19CA359Accident · Minor injuriesData collectionFinal reportAutogyro Cavalon · Nephi, UTThe pilot's insufficient rudder input during takeoff, which resulted in a loss of yaw control and a hard landing.NTSB GAA18CA484Accident · Minor injuriesData collectionFinal reportAirgyro Tercel · Spanish Fork, UTThe student pilot’s failure to maintain pitch and yaw control during takeoff.NTSB WPR15LA203Accident · No injuriesLimited investigationFinal reportBeech C 99 · Salt Lake City, UTThe airplane’s unmanageable right yaw during takeoff for reasons that could not be determined because postaccident examination of the rudder and rudder assembly did not reveal any anomalies that would have precluded normal operation.NTSB WPR11LA151Accident · No injuriesLimited investigationFinal reportBell 206B-III · Tooele, UTThe pilot did not maintain yaw control of the helicopter during a maneuvering hover. Contributing to the accident was the pilot’s lack of experience in the make and model helicopter.