NTSB investigations: Piper PA-18-150, 1990
23 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\") = 1990
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") = 1990
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 ANC91LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Thorne Bay, AKThe pilot's delay in aborting the takeoff.NTSB DEN91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Englewood, COThe failure of the pilot to maintain directional control.NTSB ANC90LA185Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotes Lakes, AKThe pilot-in-command's encounter with turbulence while on final approach, and failure to maintain aircraft control.NTSB ANC90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to adequately remove snow from the airplane and his delay in aborting the takeoff.NTSB ANC90LA176Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Heiden, AKThe pilot-in-command's failure to maintain aircraft control during a strong crosswind.NTSB ANC90LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB ANC90T#A02Accident · No injuriesClass 3Final reportPiper PA-18-150 · Kotzebue, AKNTSB ANC90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big River, AKThe improper use of brakes by the pilot during the landing roll.NTSB SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB ANC90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canning River, AKThe engine power loss due to fuel contamination, and the lack of suitable terrain on which to land.NTSB ANC90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC90LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot inadvertently stalled the airplane.NTSB ANC90LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Big Lake, AKLoss of engine power for undetermined reasons resulting in an off airport landing in a ditch.NTSB DEN90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Douglas, WYThe accident to be improper installation of aileron control system by maintenance personnel, and failure to perform an aircraft preflight by the pilot in command.NTSB ANC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Wasilla, AKPilot's failure to maintain control of the airplane. Contributing to the accident was the pilot's lack of total experience.NTSB LAX90LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Fullerton, CAFuel starvation due to the pilot's improper fuel management technique. A factor was the improperly modified fuel selector valve.NTSB ANC90LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Mountain, AKPilot-in-command failed to compensate for gusty wind conditions and control of the aircraft during the take off roll.NTSB DEN90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powderville, MTPilot failed to maintain terrain clearance during descent on an aerial application swath run, resulting in an in flight collision with the terrain. That the pilot misjudged the pull up altitude is considered a contributing factor.NTSB ANC90LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe pilot failed to maintain proper altitude and terrain clearance while maneuvering.NTSB ANC90FA051Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot lost directional control during the landing roll as a result of improper braking.NTSB SEA90LA058Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Redmond, ORPilot did maintain directional control of the airplane during the takeoff ground run. The pilot was unable to adequately correct the situation before the airplane exited the runway and ground looped resulting in the collapse of the main landing gear.NTSB LAX90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sonoma Valley, CAThe pilots inability to maintain aircraft control during a critical phase of flight after experienceing a shift in wind.