# NTSB investigations: Allison 250-C20B, 2012

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 ERA13LA057](https://openairdocs.org/ntsb/ERA13LA057.md): Hughes 369D · Corning, NY · Accident · 2 fatal · Limited investigation · Final report · Nov 15, 2012 · N369AW · Substantial damage
  > The pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.
- [NTSB ERA12CA304](https://openairdocs.org/ntsb/ERA12CA304.md): Bell 206B · Hershey, PA · Accident · Serious injuries · Data collection · Final report · Apr 27, 2012 · N16EP · Substantial damage
  > The pilot's diverted attention while performing aerial application at low altitude, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to adjust the control friction to the position he was accustomed.
- [NTSB CEN12LA141](https://openairdocs.org/ntsb/CEN12LA141.md): Bell 206B · Irving, TX · Accident · No injuries · Limited investigation · Final report · Jan 22, 2012 · N555NB · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.

## 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 year(c."eventDate") = 2012
  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&year=2012

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