# NTSB investigations: Allison 250 series, 2010

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 WPR10CA470](https://openairdocs.org/ntsb/WPR10CA470.md): Bell 47G · Gaston, OR · Accident · No injuries · Data collection · Final report · Sep 26, 2010 · N7860S · Substantial damage
  > The pilot's failure to maintain tail rotor clearance while landing on a transport trailer positioned on an uneven surface.
- [NTSB WPR10FA440](https://openairdocs.org/ntsb/WPR10FA440.md): Hiller UH 12E · Kamiah, ID · Accident · 3 fatal · Field investigation · Final report · Aug 31, 2010 · N67264 · Substantial damage
  > In-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…
- [NTSB ERA10LA383](https://openairdocs.org/ntsb/ERA10LA383.md): Hiller UH-12E · Holly Hill, SC · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 2010 · N104HH · Substantial damage
  > Maintenance personnel's improper inspection and cleaning of the fuel nozzle, which resulted in a total loss of engine power.

## 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") = 2010
  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&year=2010

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