# Final NTSB investigations, UT: Dynamic rollover

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR23LA009](https://openairdocs.org/ntsb/WPR23LA009.md): Bell Helicopter Textron Canada 505 · Moab, UT · Accident · Serious injuries · Class 4 · Limited · Final report · Oct 8, 2022 · N874BB · Substantial damage
  > The pilot’s loss of helicopter control during landing, that resulted in a dynamic roll over.
- [NTSB WPR22LA157](https://openairdocs.org/ntsb/WPR22LA157.md): Robinson Helicopter R44 II · Salt Lake City, UT · Accident · No injuries · Class 4 · Limited · Final report · Apr 16, 2022 · N3297Q · Substantial damage
  > The student pilot’s failure to maintain lateral control and terrain clearance while hovering, and the flight instructor’s delayed remedial action which resulted in a dynamic rollover.
- [NTSB WPR14CA373](https://openairdocs.org/ntsb/WPR14CA373.md): Bell 407 · Moab, UT · Accident · Minor injuries · Data collection · Final report · Sep 11, 2014 · N142MA · Substantial damage
  > The pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.
- [NTSB WPR14LA113](https://openairdocs.org/ntsb/WPR14LA113.md): Bell 206 · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Feb 5, 2014 · N3211N · Substantial damage
  > The pilots' inaccurate assessment of the snow depth on the landing zone, which resulted in a landing on snow deeper than that for which the helicopter was equipped and led to dynamic rollover.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '231')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/231/cases?state=UT&status=final

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
