# NTSB investigations: Allison 250-C47 series, 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 CEN13FA003](https://openairdocs.org/ntsb/CEN13FA003.md): Bell 407 · Intracoastal City, LA · Accident · 1 fatal · Field investigation · Final report · Oct 5, 2012 · N406AL · Substantial damage
  > The pilot’s decision to attempt a local flight in marginal visual meteorological conditions and his subsequent loss of control following an inadvertent encounter with instrument metrological conditions shortly after takeoff.
- [NTSB ERA12TA538](https://openairdocs.org/ntsb/ERA12TA538.md): Bell 407 · Bath, NY · Accident · Minor injuries · Final report · Aug 31, 2012 · N11SP · Substantial damage
  > The pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…
- [NTSB ANC12FA084](https://openairdocs.org/ntsb/ANC12FA084.md): Mcdonnell Douglas Helicopter 600N · Delta Junction, AK · Accident · 1 fatal · Field investigation · Final report · Aug 8, 2012 · N737TV · Substantial damage
  > The pilot’s failure to clear the left landing gear skid, which resulted in the entanglement of the left landing gear skid with a log, and his subsequent application of collective pitch, which resulted in a dynamic rollover.
- [NTSB CEN12LA242](https://openairdocs.org/ntsb/CEN12LA242.md): Bell 407 · Aberdeen, SD · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 2012 · N509MT · Substantial damage
  > The fatigue failure of two turbine engine blades due to vibration.

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

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