# NTSB investigations, AL: 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 MIA01LA153](https://openairdocs.org/ntsb/MIA01LA153.md): Enstrom F28A · Double Springs, AL · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 2001 · N9565 · Substantial damage
  > The failure of the pilot to maintain clearance between the skid and trailer while attempting to lift from a trailer resulting in dynamic roll-over.
- [NTSB MIA99LA217](https://openairdocs.org/ntsb/MIA99LA217.md): Bell 47G-B3 · Selma, AL · Accident · No injuries · Limited investigation · Final report · Aug 8, 1999 · N6712D · Substantial damage
  > The pilot's failure to maintain the proper touchdown point during landing causing the landing skid to become entangled with the edge of the helipad platform and the resultant rollover and main rotor blade strike of the tow vehicle.
- [NTSB ATL94LA009](https://openairdocs.org/ntsb/ATL94LA009.md): Bell 47G2 · Billingsley, AL · Accident · No injuries · Limited investigation · Final report · Oct 25, 1993 · N866Z · Substantial damage
  > The pilot's improper vertical liftoff which resulted in dynamic roll-over and the main rotor's impact with the ground.

## 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" = 'AL' 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=AL

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