# NTSB investigations: WSK PZL Mielec M-18A, NC

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 ERA16LA209](https://openairdocs.org/ntsb/ERA16LA209.md): WSK PZL Mielec M 18A · Brunswick, NC · Accident · 1 fatal · Limited investigation · Final report · Jun 10, 2016 · N2283M · Destroyed
  > The failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…
- [NTSB MIA96GA138](https://openairdocs.org/ntsb/MIA96GA138.md): Wsk Pzl Mielec M18A · Kinston, NC · Accident · 1 fatal · Final report · May 11, 1996 · N2065K · Destroyed
  > a cracked/fractured #5 cylinder and subsequent failure/jamming of the #5 exhaust valve, which resulted in a partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall and collision with the terrain. Factors…

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

This list as a web page: https://openairdocs.org/ntsb?model=9810103&state=NC

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