# NTSB investigations: Bell TH-13T, AL

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 ATL87LA249](https://openairdocs.org/ntsb/ATL87LA249.md): Bell 47G3B1 · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1987 · N38CD · Substantial damage
  > During a practice autorotation, the instructor pilot delayed in appling power to arrest the autorotative descent. The other pilot reported that the autorotation profile was was not the same as the previous successful autorotation. There were no reported…
- [NTSB ATL87DKG04](https://openairdocs.org/ntsb/ATL87DKG04.md): Bell TH-13T · Melvin, AL · Accident · No injuries · Final report · Jun 10, 1987 · N205PS · Substantial damage
  > The plt rprtd that after lndg to reload with herbicide, he got out of the helicopter to check the fuel in the tanks. After a visual inspn, he believed he had 'an adequate amount' of fuel to fly about 1/4 mi to the area to be sprayed, apply the chemical &…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1180813'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1180813&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.