NTSB investigations: Piper PA-18-150, 2002
17 cases on aircraft the registry lists as Piper PA-18-150. 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
| 1963 | 1 |
|---|---|
| 1964 | 35 |
| 1965 | 37 |
| 1966 | 43 |
| 1967 | 47 |
| 1968 | 47 |
| 1969 | 42 |
| 1970 | 36 |
| 1971 | 37 |
| 1972 | 29 |
| 1973 | 36 |
| 1974 | 35 |
| 1975 | 42 |
| 1976 | 50 |
| 1977 | 59 |
| 1978 | 41 |
| 1979 | 46 |
| 1980 | 45 |
| 1981 | 36 |
| 1982 | 28 |
| 1983 | 27 |
| 1984 | 33 |
| 1985 | 18 |
| 1986 | 31 |
| 1987 | 35 |
| 1988 | 14 |
| 1989 | 32 |
| 1990 | 23 |
| 1991 | 19 |
| 1992 | 21 |
| 1993 | 27 |
| 1994 | 26 |
| 1995 | 30 |
| 1996 | 18 |
| 1997 | 28 |
| 1998 | 28 |
| 1999 | 24 |
| 2000 | 23 |
| 2001 | 13 |
| 2002 | 17 |
| 2003 | 30 |
| 2004 | 26 |
| 2005 | 15 |
| 2006 | 13 |
| 2007 | 19 |
| 2008 | 17 |
| 2009 | 19 |
| 2010 | 19 |
| 2011 | 21 |
| 2012 | 25 |
| 2013 | 12 |
| 2014 | 21 |
| 2015 | 18 |
| 2016 | 15 |
| 2017 | 6 |
| 2018 | 19 |
| 2019 | 19 |
| 2020 | 13 |
| 2021 | 14 |
| 2022 | 14 |
| 2023 | 15 |
| 2024 | 13 |
| 2025 | 17 |
| 2026 | 8 |
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 ('7101828', '7104221', '7102835'))
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 ('7101828', '7104221', '7102835'))
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 ANC03LA017Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chenega Bay, AKThe pilot's selection of unsuitable terrain for landing and his failure to maintain obstacle clearance which resulted in the airplane colliding with a tree and a berm.NTSB ANC02LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikolai, AKThe pilot's selection of unsuitable terrain while taxiing for takeoff, which precipitated an on ground collision with a tree stump. Factors contributing to the accident were soft terrain and the presence of tree stumps.NTSB ANC02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Copper Center, AKThe pilot's selection of unsuitable terrain for landing, resulting in a nose-over during the landing roll. A factor contributing to the accident was rough/uneven terrain.NTSB ANC02LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKA jammed flight control system yoke/stick, which made directional control of the airplane not possible, and resulted in an in-flight collision with terrain.NTSB ANC02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during an aborted landing, which resulted in an in-flight collision with a culvert. A factor associated with the accident was a wind gust.NTSB ANC02FA042Accident · No injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's selection of a fuel tank that did not contain a usable quantity of fuel. Factors associated with the accident are the dirt berm, meteorological conditions conducive to carburetor icing, and carburetor ice.NTSB ANC02FA038Accident · 2 fatalField investigationFinal reportPiper PA-18 · Lime Village, AKThe pilot's inadequate evaluation of weather and his inability to maintain aircraft control. A contributing factor was high winds due to thunderstorm outflow activity.NTSB ANC02TA036Accident · No injuriesFinal reportPiper PA-18 · Holy Cross, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was the presence of high vegetation (willows) along the right side of the landing area.NTSB NYC02LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middleville, NYThe pilot's failure to maintain proper alignment with the runway after being struck by a gust of wind. Factors were the gusty winds and the berm struck by the airplane.NTSB SEA02FA063Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Silesia, MTThe non-certificated pilot's inadvertent entry into a stall condition at low altitude.NTSB ANC02LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe inadequate supervision of the student pilot by the instructor. Factors associated with the accident are the snow-covered runway and the loss of directional control by the student pilot.NTSB SEA02LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fort Peck, MTThe pilot's inability to maintain aircraft control and foreign object damage to the aileron and wing. The restricted movement of the flight controls was a factor.NTSB LAX02TA105Accident · No injuriesFinal reportPiper PA-18-150 · Winnemucca, NVThe pilot's inadequate fuel consumption calculations that lead to fuel exhaustion.NTSB FTW02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Houston, TXthe loss of engine power due to fuel starvation as a result of the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.NTSB SEA02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle Point, ORThe pilot inadvertently failed to retract the landing gear for the water landing and the aircraft nosed over.NTSB ANC02LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight. Factors in the accident were the student's failure to maintain directional control of the airplane during the landing roll, icy runway conditions, and snow-covered terrain along the runway edges.NTSB LAX02LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Reno, NVThe pilot failed to maintain directional control resulting in an inadvertent ground loop. A contributing factor was the tailwind.