NTSB investigations: WSK PZL Mielec M-18 DROMADER, AR
6 cases on aircraft the registry lists as WSK PZL Mielec M-18 DROMADER. 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
| 1995 | 2 |
|---|---|
| 1996 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2004 | 1 |
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\" = 'AR' 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 ('9810104'))
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" = 'AR' 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 ('9810104'))
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 FTW04LA127Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Brinkley, ARThe pilots failure to attain flying airspeed after takeoff. A factor was the overloading of agricultural chemicals that exceeded the airplane's maximum takeoff weight.NTSB CHI03LA156Accident · No injuriesLimited investigationFinal reportDromader M-18 · Dumas, ARThe pilot's delay in aborting the takeoff and his intentional maneuver to avoid the obstruction at the end of the runway. Contributing factors were the road and ditch.NTSB FTW99LA161Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Dewitt, ARThe pilot's inadvertent flight into adverse weather, which resulted in a loss of aircraft control. A factor was the downdraft weather condition.NTSB FTW96LA260Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Prescott, ARThe loss of engine power due to improper fuel. Factors were the pilot's inadequate preflight and lack of suitable terrain for the forced landing.NTSB FTW95LA290Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · De Witt, ARThe pilot's failure to maintain airspeed and the resulting inadvertent stall/mush.NTSB FTW95LA162Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromadier · Pine Bluff, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain minimum required airspeed for flight, resulting in an inadvertent stall. A factor was the pilot's diverted attention.