Skip to content

NTSB investigations: WSK PZL Mielec M-18A

65 cases on aircraft the registry lists as WSK PZL Mielec M-18A. 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, newest first

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')) 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'))
  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'))
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 MIA96GA138Accident · 1 fatalFinal reportWsk Pzl Mielec M18A · Kinston, NCa 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…May 11, 1996 · N2065K · Destroyed NTSB FTW96LA159Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A · Hughes, LAthe pilot exceeding the maximum authorized crosswind component of the airplane. Factors were the crosswind and the side sloping runway.Apr 3, 1996 · N2159K · Destroyed NTSB LAX96LA113Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18-A · Blythe, CAthe pilot's premature lift-off and subsequent loss of control due to his failure to monitor the airspeed indicator during the takeoff roll.Feb 16, 1996 · N92640 · Destroyed NTSB CHI96LA035Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Montrose, MIa loss of engine power as a result of the separation of the throttle push-pull cable.Nov 20, 1995 · N2296J · Substantial damage NTSB FTW95LA345Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Wilmot, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 16, 1995 · N2065S · Substantial damage NTSB CHI95LA232Accident · Serious injuriesLimited investigationFinal reportPZL-Mielec M-18A · Carrington, NDthe pilot's inadequate preflight planning/preparation. Factors relating to the accident were: the airplane's excessive gross weight, and the unfavorable wind conditions.Jul 22, 1995 · N80225 · Destroyed NTSB CHI95LA221Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Clinton, MOthe pilot's not using the flight manual and not understanding the fuel management for this particular airplane. Factors were the fuel system vent partial blockage and information unclear (phraseology) for the fuel management valve.Jul 14, 1995 · N168RA · Substantial damage NTSB FTW95LA192Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Gerome, ARThe pilot's use of unsuitable terrain for landing.May 6, 1995 · N8025Y · Substantial damage NTSB FTW94LA281Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Wheatley, ARTotal loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.Aug 27, 1994 · N148RA · Substantial damage NTSB SEA94LA201Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18S · Royal City, WAThe pilot's inadequate remedial action. Factors include high density altitude and unfavorable winds.Jul 30, 1994 · N81705 · Substantial damage NTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.Sep 23, 1993 · N452TC · Destroyed NTSB FTW93LA195Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A Dromader · Wheatley, ARThe pilot's operation of the airplane beyond its takeoff performance limitations and inadvertent stall. A factor was high density altitude.Jun 23, 1993 · N116RA · Substantial damage NTSB SEA92LA190Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Mattawa, WAThe inadvertent locking of the acft brakes while landing by the PIC, resulting in an acft nose over on the gravel strip.Aug 25, 1992 · N2252Z · Substantial damage NTSB FTW90DPG06Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARLoss of part of the engine exhaust collector, as result of improper maintenance replacement/installation.Jul 28, 1990 · N81699 · Destroyed NTSB FTW90DPG05Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARThe pilot's continued operation with a known malfunctioning engine.Jul 26, 1990 · N8154V · Destroyed