NTSB investigations: Piper PA-18-135, 2002
4 cases on aircraft the registry lists as Piper PA-18-135. 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
| 1964 | 7 |
|---|---|
| 1965 | 3 |
| 1966 | 6 |
| 1967 | 4 |
| 1968 | 1 |
| 1969 | 7 |
| 1970 | 4 |
| 1971 | 4 |
| 1972 | 5 |
| 1973 | 3 |
| 1974 | 5 |
| 1975 | 1 |
| 1976 | 4 |
| 1977 | 4 |
| 1978 | 4 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 2 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 6 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 2 |
| 1996 | 5 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 2 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 3 |
| 2008 | 4 |
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2025 | 2 |
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\") = 2002
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101820'))
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") = 2002
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101820'))
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 SEA02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Payette, IDThe pilot's failure to adequately compensate for the wind conditions during landing resulting in a ground loop/swerve. Wind gusts were a contributing factor.NTSB SEA02LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Lewiston, IDThe pilot's failure to maintain directional control during the landing resulting in the aircraft departing the runway environment and the wing impacting the ground. Contributing factors were the dustdevil/whirlwind which the aircraft encountered and the ditch.NTSB ATL02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe failure of the pilot to use proper wind correction technique, resulting in a loss of directional control of the aircraft.NTSB ATL02LA047Accident · No injuriesLimited investigationFinal reportPiper PA -18 · Winter Haven, FLThe pilot's improper flare during an attempted landing on water. A factor was glassy water.