# NTSB investigations: Allison 250-C30 series: Not determined, general

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 ERA23LA309](https://openairdocs.org/ntsb/ERA23LA309.md): Bell 206-L4 · Caldwell, OH · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 23, 2023 · N482TJ · Substantial damage
  > The helicopter’s uncontrolled vertical descent and impact with terrain for reasons that could not be determined.
- [NTSB CEN14FA286](https://openairdocs.org/ntsb/CEN14FA286.md): Bell 206 L4 · South Timbalier Platform · Accident · 2 fatal · Field investigation · Final report · Jun 11, 2014 · N207MY · Destroyed
  > The pilot's loss of helicopter control for reasons that could not be determined based on the available information.
- [NTSB CEN10IA314](https://openairdocs.org/ntsb/CEN10IA314.md): Bell 206L-3 · Gulf of Mexico · Incident · Minor injuries · Incident investigation · Final report · Jun 10, 2010 · N108PH · Minor damage
  > A suspected failure of the tail rotor for undetermined reasons. A contributing factor was the failure of the emergency floats to properly inflate due to improper installment and inspection by maintenance personnel.
- [NTSB CEN09IA254](https://openairdocs.org/ntsb/CEN09IA254.md): Bell 206 · Vick, TX · Incident · No injuries · Incident investigation · Final report · Apr 8, 2009 · N295AE · Minor damage
  > Undetermined.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03015')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '05000000')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/05000000/cases?engine=03015

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
