# NTSB investigations, 2004: 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 MIA05CA009](https://openairdocs.org/ntsb/MIA05CA009.md): Robinson R-22 · Vega Baja, PR · Accident · Serious injuries · Data collection · Final report · Oct 19, 2004 · N2314T · Substantial damage
  > The pilot's failure to select a suitable landing area resulting in a tangled skid with vegetation during an aborted landing and subsequent dynamic roll over.
- [NTSB LAX05CA004](https://openairdocs.org/ntsb/LAX05CA004.md): Hughes 369HS · Pacific Ocean (Pacific Ocean) · Accident · No injuries · Data collection · Final report · Oct 6, 2004 · N74AM · Substantial damage
  > the pilot's inadequate preflight inspection to ensure that all tie downs were removed from the helicopter, which resulted in a dynamic rollover.
- [NTSB DEN04LA149](https://openairdocs.org/ntsb/DEN04LA149.md): American Eurocopter AS-350-B3 · Las Cruces, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 2004 · N497AE · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff resulting in the helicopter's skid striking the helipad and the helicopter's subsequent rollover. Factors contributing to the accident were the pilot's improper preflight planning/decision, his…
- [NTSB LAX04CA315](https://openairdocs.org/ntsb/LAX04CA315.md): Bell 206B · Kahului, HI · Accident · Minor injuries · Data collection · Final report · Aug 16, 2004 · N529RS · Substantial damage
  > the pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a dynamic rollover. Contributing factors were the direct crosswind and his lack of total experience in the accident helicopter make and model.
- [NTSB ATL04LA155](https://openairdocs.org/ntsb/ATL04LA155.md): Robinson Helicopter R44 II · Goldsboro, NC · Accident · No injuries · Limited investigation · Final report · Jul 28, 2004 · N442RD · Substantial damage
  > The pilot's failure to obtain the proper touchdown point during landing on a helipad with an exposed edge, which resulted in an in-flight collision with terrain.
- [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 MIA04CA059](https://openairdocs.org/ntsb/MIA04CA059.md): Robinson R22 · Keystone, FL · Accident · No injuries · Data collection · Final report · Mar 12, 2004 · N4370D · Substantial damage
  > The inadequate supervision by the flight instructor by allowing the student to lose excessive altitude resulting in a skid impacting the ground and subsequent roll over of the helicopter.
- [NTSB LAX04CA146](https://openairdocs.org/ntsb/LAX04CA146.md): Robinson R22 Beta · Long Beach, CA · Accident · Minor injuries · Data collection · Final report · Mar 6, 2004 · N7188S · Substantial damage
  > the student pilot's improper use of the cyclic control and the certified flight instructor's inadequate supervision, which resulted in a 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 year(c."eventDate") = 2004
  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&year=2004

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