# NTSB investigations: Allison 250-C20 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 SEA03FA169](https://openairdocs.org/ntsb/SEA03FA169.md): Aerospatiale AS350D · Webb, ID · Accident · Serious injuries · Field investigation · Final report · Aug 13, 2003 · N57731 · Substantial damage
  > An over temperature condition within the gas generator turbine which led to first stage turbine blade fatigue as well as first stage blade track warping and consequent blade tip rub. The fatigue and blade tip rub ultimately led to blade separation and failure…
- [NTSB SEA01LA082](https://openairdocs.org/ntsb/SEA01LA082.md): Schweizer 269D · Nampa, ID · Accident · No injuries · Limited investigation · Final report · May 3, 2001 · N2061D · Substantial damage
  > the pilot's inadequate compensation for strong, gusty, shifting winds while hovering in ground effect. Factors include a sudden directional change and increase in velocity of the gusty wind conditions.
- [NTSB SEA99FA037](https://openairdocs.org/ntsb/SEA99FA037.md): Hiller UH-12E · Yellow Pine, ID · Accident · No injuries · Field investigation · Final report · Feb 28, 1999 · N2239 · Substantial damage
  > Altitude deviation during aerial taxi for undetermined reasons.
- [NTSB SEA98LA024](https://openairdocs.org/ntsb/SEA98LA024.md): Bell 206L · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Dec 16, 1997 · N206LT · Substantial damage
  > loss of engine power for undetermined reason(s). A factor relating to the accident included a dirt berm/ridge in the field where the pilot executed the forced landing.
- [NTSB SEA96LA165](https://openairdocs.org/ntsb/SEA96LA165.md): Bell 206B · Warren, ID · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 1996 · N750LT · Destroyed
  > the pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…

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

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