# NTSB investigations: Allison 250 SER 250HP, 1997

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 IAD97FA123](https://openairdocs.org/ntsb/IAD97FA123.md): Fairchild Hiller FH-1100 · Pittsfield, MA · Accident · 1 fatal · Field investigation · Final report · Sep 27, 1997 · N5045F · Destroyed
  > The first pilot's improper procedures for an autorotation, and improper flare which resulted in a hard landing. Also causal was the second pilot's inadequate remedial action.
- [NTSB FTW97LA326](https://openairdocs.org/ntsb/FTW97LA326.md): Bell 206B · Oak Grove, LA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1997 · N7929J · Substantial damage
  > The disconnect of the #5 tail rotor drive segment due to the debonding of the joint between the shaft tube and the flange fitting. Factors were the improper bead blasting of the tail rotor drive segment by an unknown maintenance personnel, and the lack of…
- [NTSB MIA97FA070](https://openairdocs.org/ntsb/MIA97FA070.md): Bell 206-B3 · Fort Lauderdale, FL · Accident · 4 fatal · Field investigation · Final report · Jan 23, 1997 · N2047R · Destroyed
  > The pilot's incapacitation by carbon monoxide from undetermined sources which led to his diminished ability to see and avoid a radio tower.

## 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") = 1997
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03002', '03003'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=03002&year=1997

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