NTSB investigations: WSK PZL Mielec M-18A, 1997
6 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.
Cases per year
| 1990 | 2 |
|---|---|
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 5 |
| 1996 | 6 |
| 1997 | 6 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 6 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 2 |
| 2007 | 2 |
| 2008 | 2 |
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2021 | 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 year(c.\"eventDate\") = 1997
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"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 year(c."eventDate") = 1997
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" 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 FTW98LA034Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Roanoke, LAloss of engine power for an undetermined reason(s). A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB CHI97LA267Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Coopersville, MIthe pilot inadequate fuel system management which led to a fuel starvation.NTSB MIA97LA207Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Clewiston, FLa forced landing as a result of an undetermined loss of engine power and subsequent impact with a railroad switching unit and nose over.NTSB FTW97LA231Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Waldenburg, ARthe pilot's improper planning/decision. The short runway and failure to use up to 10 degrees of flaps were related factors.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…NTSB FTW97LA159Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Sinton, TXFuel starvation resulting from the failure of the engine driven fuel pump due to an undetermined reason. A factor was the soft terrain.