# NTSB investigations, UT: Roll over

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 SEA08CA002](https://openairdocs.org/ntsb/SEA08CA002.md): Robinson R44 II · Lake Powell, UT · Accident · Minor injuries · Data collection · Final report · Oct 2, 2007 · N644BS · Substantial damage
  > The pilot's inadequate preflight inspection and failure to remove a tie-down strap before departure.
- [NTSB LAX07CA131](https://openairdocs.org/ntsb/LAX07CA131.md): Robinson R22 Beta · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Apr 21, 2007 · N222MQ · Substantial damage
  > The student pilot's improper use of the flight controls, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.
- [NTSB DEN84LA110](https://openairdocs.org/ntsb/DEN84LA110.md): Hiller FH 1100 · Provo, UT · Accident · No injuries · Limited investigation · Final report · Mar 16, 1984 · N5042F · Substantial damage
  > The acft was landed in soggy terrain and the right skid sank into the surface. One of the occupants of the helicopter deplaned to'lighten the load'and the plt overcorrected in an attempt to takeoff. The acrt rolled over onto its left side.
- [NTSB DEN84FA102](https://openairdocs.org/ntsb/DEN84FA102.md): Bell 206B-III · Coalville, UT · Accident · 1 fatal · Field investigation · Final report · Feb 25, 1984 · N16803 · Destroyed
  > The helicopter was equipped with 'bear paws'. Snowshoe-like devices on the skids to distribute weight on soft surfaces. The bear paws on this acft rotated freely around the skids, not tightened down as per design spec. Also, bear paws are not approved for…

## 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 380)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=380&state=UT

---
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.