# NTSB investigations: Allison 250-C47 series, 2002

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 LAX03GA001](https://openairdocs.org/ntsb/LAX03GA001.md): McDonnell Douglas 600N · Rialto, CA · Accident · Serious injuries · Final report · Oct 4, 2002 · N625SB · Substantial damage
  > an engine deceleration event due to a loose HMU fuel line fitting, which was a result of inadequate maintenance procedures in the 100/300-hour inspection. Also causal was the flying pilot's and pilot-in-command's delayed recognition of the power loss, as well…
- [NTSB ATL02LA095](https://openairdocs.org/ntsb/ATL02LA095.md): McDonnell Douglas MD-600N · Deland, FL · Accident · No injuries · Limited investigation · Final report · May 10, 2002 · N810LA · Substantial damage
  > The pilot's failure to follow the FADEC malfunction checklist that resulted in the loss of rotor RPM, and the pilot's improper use of the flight controls during the precautionary landing that resulted in a hard landing. A factor was the malfunction of the…

## 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") = 2002
  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=2002

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