# Fatal NTSB investigations: 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 LAX04LA249](https://openairdocs.org/ntsb/LAX04LA249.md): Bell 206B · Mesa, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 25, 2004 · N97AZ · Substantial damage
  > the pilot's failure to adequately clear the left skid of obstacles resulting in a dynamic rollover of the helicopter and collision with terrain. A factor in the accident was the dark nighttime lighting conditions.
- [NTSB LAX92LA030](https://openairdocs.org/ntsb/LAX92LA030.md): Bell 47-G5A · Kosrae · Accident · 1 fatal · Limited investigation · Final report · Oct 31, 1991 · N7162R · Destroyed
  > The pilot-in-command's improper preflight inspection of the helicopter resulting in a tiedown strap not being removed from the right skid and subsequent roll over on takeoff.
- [NTSB LAX88FA085](https://openairdocs.org/ntsb/LAX88FA085.md): Bell 47G-2A1 · San Diego, CA · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1988 · XBDGH · Destroyed
  > Pilots complacency in performing the preflight inspection. His failure to disconnect the two tie downs straps attached to the right side of the helicopter resulted the roll.
- [NTSB CHI85FA198](https://openairdocs.org/ntsb/CHI85FA198.md): Bell 47G-2 · Burlington, MI · Accident · 1 fatal · Field investigation · Final report · May 16, 1985 · N3755J · Substantial damage
  > The helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.
- [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."highestInjuryLevel" = 'Fatal'
  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?fatal=1&occurrence=380

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