# NTSB investigations: Allison 250-C20B, HI

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 WPR16FA072](https://openairdocs.org/ntsb/WPR16FA072.md): Bell 206B · Honolulu, HI · Accident · 1 fatal · Field investigation · Final report · Feb 18, 2016 · N80918 · Substantial damage
  > The in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.
- [NTSB WPR13CA406](https://openairdocs.org/ntsb/WPR13CA406.md): Hughes 369D · Kalalau, HI · Accident · Minor injuries · Data collection · Final report · Sep 12, 2013 · N519PA · Substantial damage
  > The entanglement of a tarp in the helicopter's main rotor from a nearby trash bundle.
- [NTSB LAX94LA076](https://openairdocs.org/ntsb/LAX94LA076.md): Hughes 369D · Waimea, Kauai, HI · Accident · No injuries · Limited investigation · Final report · Dec 22, 1993 · N115HD · Substantial damage
  > An inadequate engine compressor cleaning procedure specified in the manufacturer's service letter, which resulted in the total loss of engine power due to contamination, blockage, and collapse of the fuel nozzle inlet screen. Factors in the accident were: the…

## 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" = 'HI' 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 ('03081'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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