# NTSB investigations: Allison 250 series, ID

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 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 SEA99LA031](https://openairdocs.org/ntsb/SEA99LA031.md): Hiller UH-12E · Tensed, ID · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1999 · N67264 · Substantial damage
  > The pilot-in-command's inadequate fuel management which resulted in fuel exhaustion. Contributing factors were the absence of cautionary markings on the fuel gauge, and high trees at the accident site.
- [NTSB SEA76DYG67](https://openairdocs.org/ntsb/SEA76DYG67.md): Hiller Acft UH-12E · Clark Fork, ID · Accident · No injuries · Closed · Sep 27, 1976 · N62409 · Substantial damage

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

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

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