NTSB investigations, UT
10 cases where the sequence of events included Roll over.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '097' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR26LA137Accident · No injuriesClass 4 · LimitedFinal reportSalt Lake Gyrocopters Calidus · Fairfield, UTThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was nose wheel misalignment at touchdown.NTSB WPR25LA222Accident · Minor injuriesClass 4 · LimitedFinal reportRotorsport UK Rotorsport UK Cavalon · Hurricane, UTThe pilot’s failure to maintain pitch control during takeoff, which resulted in an unintended liftoff from the runway and a subsequent loss of control.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 GAA19CA077Accident · No injuriesData collectionFinal reportScott Taylor Eclipse 10 · Kanab, UTThe pilot's failure to maintain directional control during takeoff from an unimproved dirt road.NTSB GAA18CA127Accident · No injuriesData collectionFinal reportHughes 369 · Heber City, UTThe pilot’s failure to maintain clearance from an elk while maneuvering at a low altitude.NTSB WPR15CA040Accident · Minor injuriesData collectionFinal reportAerospatiale AS350BA · Panguitch, UTThe flight instructor's delayed reaction in taking control of the helicopter during a student pilot's loss of control while landing.NTSB WPR11CA121Accident · No injuriesData collectionFinal reportRobinson R44 · Ogden, UTThe certified flight instructor’s failure to maintain adequate main rotor blade rpm during a practice autorotation, resulting in a hard landing and rollover.NTSB WPR10LA232Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Mendon, UTA loss of engine power due to a failure of the magnetos as a result of inadequate maintenance.NTSB LAX08CA159Accident · No injuriesData collectionFinal reportRobinson R22 · Salt Lake City, UTThe student's improper use of the anti torque pedals during a practice hover autorotation, which resulted in the helicopter rolling over. Additional causes of the accident were the certificated flight instructor's inadequate supervision of the maneuver and…