NTSB investigations: WSK PZL Mielec M-18A

8 cases on aircraft the registry lists as WSK PZL Mielec M-18A, where the first occurrence was “Loss of control - in flight”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19972026

NTSB investigations: WSK PZL Mielec M-18A per year, 1997–2026: 8 cases
1997	1
1999	1
2000	2
2002	1
2003	2
2004	1

Where

Open the map

Latest cases

Query with 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9810103') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9810103')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9810103')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX04GA243Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · St. George, UTThe pilot's failure to maintain an adequate airspeed margin, resulting in a stall and loss of control.Jun 17, 2004 · N8214J · Destroyed NTSB CHI03LA148Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Reydell, ARThe pilot's failure to maintain directional control during initial climb.Jun 2, 2003 · N135RA · Substantial damage NTSB MIA03CA108Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Baxterville, MSThe pilot's decision to continue the takeoff at a low airspeed which resulted in a stall, an uncontrolled descent, and an impact with terrain.May 13, 2003 · N82204 · Substantial damage NTSB ATL02LA146Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A · Indianola, MSThe pilot's failure to maintain airspeed which resulted in a stall and the subsequent uncontrolled collision with the ground while maneuvering for an aerial application run.Jul 31, 2002 · N6236M · Substantial damage NTSB CHI00LA181Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Champion, NEthe undetermined uncontrolled descent.Jul 7, 2000 · N7015K · Substantial damage NTSB FTW00LA157Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec M-18A · Marmaduke, ARThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/mush.May 30, 2000 · N2065S · Destroyed NTSB FTW99LA124Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Hickory Ridge, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall/spin.Apr 28, 1999 · N22524 · Substantial damage NTSB FTW97FA193Accident · 1 fatalField investigationFinal reportPezetel M-18A · Wilmot, ARfailure of the pilot to remove the elevator control lock before the first flight of the day, which resulted in his inability to control the airplane, due to the locked elevator control. Related factors were: the prevailing high winds and the lack of a visible…May 19, 1997 · N8089Z · Destroyed