# NTSB investigations: Allison 250 series, FL

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 MIA92LA014](https://openairdocs.org/ntsb/MIA92LA014.md): Bell 47G-5 · La Belle, FL · Accident · No injuries · Limited investigation · Final report · Oct 13, 1991 · N1201W · Substantial damage
  > The pilot in command's improper aft application of cyclic control during an autorotative landing to an open field, resulting in the main rotor blades colliding with the tail boom. Contributing to the accident was the in flight failure of the outer bearing of…
- [NTSB MIA84LA179](https://openairdocs.org/ntsb/MIA84LA179.md): Bell 47G-5 · Jupiter, FL · Accident · No injuries · Limited investigation · Final report · Jun 7, 1984 · N1201W · Substantial damage
  > The acft crashed landed after a partial loss of power. During an exam of the eng, the compressor bleed control valve was found stuck open causing an improper fuel/air mixture.

## 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" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03014', '03019'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=03014&state=FL

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