# NTSB investigations: Pezetel ASZ-621R-M18, 2004

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 SEA04TA147](https://openairdocs.org/ntsb/SEA04TA147.md): WSK PZL Mielec M-18A · Burns, OR · Accident · No injuries · Final report · Jul 26, 2004 · N495WP · Substantial damage
  > The improper installation of the throttle linkage clevis to the throttle control arm by unknown maintenance personnel. Contributing factors were the nylon lock nut separating from its' bolt, which permitted the throttle cable to disconnect from the throttle…
- [NTSB CHI04TA193](https://openairdocs.org/ntsb/CHI04TA193.md): PZL-Mielec M-18T · Pine Ridge, SD · Accident · No injuries · Final report · Jul 12, 2004 · N7077N · Substantial damage
  > The propeller went to an overspeed condition as a result of contamination of the propeller control unit due to improper servicing by the operator and the mechanic. A factor was the hilly terrain.

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

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

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