NTSB investigations: Wsk-Pzl-Mielec PZL-M-18, LA
5 cases on aircraft the registry lists as Wsk-Pzl-Mielec PZL-M-18. 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.
Cases per year
| 1981 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 3 |
Where
Open the mapLatest cases
Query with SQL
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.\"eventStateOrRegion\" = 'LA' 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 ('9810102'))
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."eventStateOrRegion" = 'LA' 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 ('9810102'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW88DRD16Accident · No injuriesFinal reportPZL-Mielec M18 · Bastrop, LAThis ag airplane has a hydraulic system that operates the brakes and flaps. The engine driven hydraulic pump provides pressure to the primary system for normal use and also provides pressure to an accumulator for emergency use. The pressure in the accumulator…NTSB FTW88DRD07Accident · Minor injuriesFinal reportPezetel M-18 · Mer Rouge, LAThe ag airplane departed the strip with 3000 lbs of fertilizer. 200 yds later it settled in a rice field and flipped forward to the inverted. No mechanical problems were found. Elevation at takeoff was 150 ft MSL. Density altitude was 2272 ft. max allowable…NTSB FTW88LA093Accident · No injuriesLimited investigationFinal reportPezetel PZL-M-18 · Cheneyville, LAThe pilot said that after takeoff the aircrft seemed extremely tail-heavy and that he used 'both feet and one arm' to hold forward stick. He said the aircraft was almost uncontrollable in pitch and displayed a right turning tendendcy. The pilot returned to…NTSB FTW86FRD25Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M18 · Mer Rouge, LAThe pilot pulled up steeply at the end of a spray run and started a turn-around. During this time he allowed the airspeed to bleed off to the point at which the aircraft stalled and entered a spin without sufficient altitude to recover before ground impact…NTSB FTW81DRJ15Accident · No injuriesClosedWSK PZL M-18 · Crowville, LA