Skip to content

NTSB investigations: Piper PA-18-150, OR

27 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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" = 'OR' 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 ('7101828', '7104221', '7102835')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'OR' 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 ('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 c."eventStateOrRegion" = 'OR' 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 ('7101828', '7104221', '7102835'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR19FA251Accident · 2 fatalClass 3 · FieldFinal reportPiper PA18 · Hood River, ORThe total loss of engine power shortly after takeoff as a result of the private pilot’s failure to ensure the fuel selector was in the appropriate position and the certified flight instructor’s exceedance of the airplane’s critical angle of attack at the time…Sep 6, 2019 · N14365 · Substantial damage NTSB WPR09CA288Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hell's Canyon, ORThe pilot's failure to maintain clearance from trees.Jun 14, 2009 · N3761Z · Substantial damage NTSB SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.Oct 3, 2007 · N91254 · Substantial damage NTSB SEA07CA206Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Ontario, ORThe pilot's improper recovery from a bounced landing and failure to maintain directional control during landing.Jul 16, 2007 · N7474L · Substantial damage NTSB SEA07CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Prineville, ORThe total loss of engine power due to fuel exhaustion as a result of the pilot failing to correctly read the fuel quantity sight gauges. Factors include soft, brushy terrain, and the pilot's intentional excessive braking during the forced landing.Apr 27, 2007 · N40520 · Substantial damage NTSB SEA06CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Prineville, ORAircraft control not maintained by the private pilot during the initial takeoff climb, and the improper remedial action by the flight instructor. A factor was the wind gust.Dec 9, 2005 · N2584S · Substantial damage 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.Jan 27, 2002 · N4379Z · Substantial damage NTSB SEA00LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Malheur City, ORThe pilot's excessive descent rate during an attempted precautionary landing. Factors include the pilot's intentional operation of his aircraft with a known electrical system deficiency, a malfunction of the electrical system while in flight, the pilot's…Nov 13, 1999 · N82553 · Destroyed NTSB SEA99LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Salem, ORThe pilot's improper decision not to apply carburetor heat during a reduced power descent in conditions conducive to carburetor icing. Factors include weather conditions conducive to carburetor icing, and high vegetation and a fence post in the area where the…May 9, 1999 · N7483L · Substantial damage NTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.Aug 15, 1995 · N6854P · Substantial damage NTSB SEA94FA071Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Frenchglen, ORThe pilot's failure to maintain minimum airspeed (vs). The tailwind was a factor.Mar 2, 1994 · N82951 · Destroyed NTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.Jun 10, 1991 · N3474Z · Destroyed 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.Mar 28, 1990 · N83681 · Substantial damage NTSB SEA89LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Burns Junction, ORThe pilot did not maintain proper airspeed during takeoff.Aug 31, 1989 · N83330 · Substantial damage NTSB SEA83LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Baker, ORThe pilot said the acft veered 180 degrees, hit a depression and then the left wing struck the ground. The pilot was landing on rwy 30 which was closed for resurfacing. The x's had been moved 50 ft off the centerline of the rwy. The acft left landing gear…Aug 10, 1983 · N14332 · Substantial damage NTSB SEA83LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rome, ORThe acft struck a rock during landing and damaged the landing gear. The pilot was on a fishing trip and landed initiallyon a gravel bar. He decided to move the acft to a longer plateau because of increasing density altitude. Upon landing inthis open field the…Jun 26, 1983 · N4436D · Substantial damage NTSB SEA81DYM04Accident · No injuriesClosedPiper PA-18 · Hillsboro, OROct 5, 1980 · N82481 · Substantial damage NTSB SEA79FYM58Accident · No injuriesClosedPiper PA-18 · Heppner, ORAug 18, 1979 · N3765Z · Substantial damage NTSB SEA78FYK08Accident · Serious injuriesClosedPiper PA-18 · Ashland, ORFeb 7, 1978 · N83272 · Destroyed NTSB SEA77DYM46Accident · No injuriesClosedPiper PA-18 · Hermiston, ORJul 7, 1977 · N40523 · Substantial damage NTSB SEA74DYC48Accident · Minor injuriesClosedPiper PA-18 · Echo, ORMay 9, 1974 · N3965Z · Substantial damage NTSB SEA71AS044Accident · 2 fatalClosedPiper PA-18 · Adel, ORMay 19, 1971 · N3596P · Destroyed NTSB SEA71DVQ17Accident · No injuriesClosedPiper PA-18 · Mckenzie Br., ORMar 15, 1971 · N9016Y · Substantial damage NTSB SEA70F0140Accident · Serious injuriesClosedPiper PA-18 · Princeton, OROct 20, 1969 · N4372Z · Destroyed NTSB SEA70F0055Accident · Minor injuriesClosedPiper PA-18 · White City, ORJul 17, 1969 · N7394D · Destroyed NTSB SEA70F0032Accident · No injuriesClosedPiper PA-18 · Esticada, ORMay 23, 1969 · N4270Z · Substantial damage NTSB SEA67D0222Accident · No injuriesClosedPiper PA-18 · Fossil, ORNov 3, 1966 · N3957Z · Substantial damage