Skip to content

NTSB investigations: Piper PA-28-180, OR

33 cases on aircraft the registry lists as Piper PA-28-180. 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 ('7102808')) 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 ('7102808'))
  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 ('7102808'))
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 WPR15LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Bend, ORA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat after takeoff and during the climb.Oct 10, 2014 · N32150 · Substantial damage NTSB LAX07CA232Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Eagle Point, ORFuel exhaustion due to the pilot's inadequate fuel consumption calculations.Aug 3, 2007 · N919CA · Substantial damage NTSB SEA98LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Manzanita, ORThe pilot's failure to maintain directional control during the aborted takeoff. Factors include a crosswind gust during the takeoff roll.Jun 20, 1998 · N6556J · Substantial damage NTSB SEA94LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brookings, ORThe pilot's inadequate preflight planning/preparation, and icing of the induction air filter/screen. Factors include weather conditions conducive to icing, and rough/uneven terrain in the area of attempted landing.Nov 22, 1993 · N8829J · Substantial damage NTSB SEA91LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wamic, ORThe pilot's selection of an empty fuel tank for takeoff.Apr 1, 1991 · N7119W · Destroyed NTSB SEA90LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yamhill, ORPilot did not maintain an adequate airspeed after takeoff which resulted in a loss of control and aborted takeoff. The pilot did not maintain directional control of the airplane and did not properly correct the situation before colliding with trees and a…Jun 15, 1990 · N9765J · Substantial damage NTSB SEA90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hillsboro, ORFuel contamination and the pilots lack of peflight inspection. Contributing to the accident was the soft terrain.Nov 12, 1989 · N8470W · Substantial damage NTSB SEA90LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · White City, ORThe pilot did not maintain direction control of the airplane during the landing roll and took inadequate remedial action. Factors contributing to the accident include terrain and the pilot's lack of total expereince.Oct 14, 1989 · N8199W · Substantial damage NTSB SEA86FA232Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · John Day, ORThe non-instrument rated pilots departed hermiston en route to burns, Oregon. Visual meteorological conditions prevailed; however, mountain tops along the route of flight were occasionally obstructed by local cloud layers. During the course of the flight the…Aug 30, 1986 · N3618R · Destroyed NTSB SEA84FA215Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · The Dalles, ORN6499J departed The Dalles municipal arpt shortly after 0930 PDT on a flt to vancouver, WA. N4622T departed chenoweth airfield ( aprx 4 NM west of The Dalles) at about 0930 PDT on a flt to The Dalles municipal arpt. A witness who observed both acft before the…Sep 1, 1984 · N6499J · 2 aircraft · Destroyed NTSB SEA82FA010Accident · 1 fatalClosedPiper PA-28 · Mill City, ORDec 6, 1981 · N8415W · Destroyed NTSB SEA79FYM30Accident · Serious injuriesClosedPiper PA-28 · Sandy, ORApr 28, 1979 · N7142W · Destroyed NTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORMar 18, 1978 · N1844T · Destroyed NTSB SEA78DYK05Accident · No injuriesClosedPiper PA-28 · Agness, ORDec 23, 1977 · N56759 · Substantial damage NTSB SEA76DYI14Accident · No injuriesClosedPiper PA-28 · La Pine, ORMar 26, 1976 · N15285 · Substantial damage NTSB SEA76FYC09Accident · No injuriesClosedPiper PA-28 · Mulino, ORAug 11, 1975 · N9577J · Substantial damage NTSB SEA76AS007Accident · 1 fatalClosedPiper PA-28 · Sheridan, ORJul 27, 1975 · N9183J · Destroyed NTSB SEA75DYC23Accident · Minor injuriesClosedPiper PA-28 · Baker, ORJan 2, 1975 · N32763 · Substantial damage NTSB SEA74DYC50Accident · No injuriesClosedPiper PA-28 · Mulino, ORMay 15, 1974 · N15285 · Substantial damage NTSB SEA74DYA04Accident · Serious injuriesClosedPiper PA-28 · Ironside, ORJul 20, 1973 · N7259W · Substantial damage NTSB SEA73DYC18Accident · No injuriesClosedPiper PA-28 · Oregon City, ORFeb 10, 1973 · N8081W · Substantial damage NTSB OAK73AP011Accident · 1 fatalClosedPiper PA-28 · Baker, ORNov 16, 1972 · N5365L · Destroyed NTSB SEA73DYC12Accident · No injuriesClosedPiper PA-28 · Grand Ronde, ORNov 11, 1972 · N9526J · Substantial damage NTSB SEA72FYC18Accident · No injuriesClosedPiper PA-28 · Portland, ORSep 4, 1971 · N7603W · Substantial damage NTSB SEA71FYC39Accident · No injuriesClosedPiper PA-28 · Troutdale, ORApr 30, 1971 · N7746N · Substantial damage NTSB SEA70DWA03Accident · Minor injuriesClosedPiper PA-28 · Redmond, ORFeb 7, 1970 · N4901L · Destroyed NTSB SEA70D0063Accident · No injuriesClosedPiper PA-28 · Brookings, ORAug 9, 1969 · N9446J · Substantial damage NTSB OAK69A0030Accident · 1 fatalClosedPiper PA-28 · Durkee, ORNov 10, 1968 · N7273W · Substantial damage NTSB SEA69A0015Accident · 2 fatalClosedPiper PA-28 · Dorena, ORAug 26, 1968 · N5385L · Destroyed NTSB SEA69F0019Accident · Minor injuriesClosedPiper PA-28 · Paisley, ORApr 30, 1968 · N8925J · Destroyed NTSB SEA68D0207Accident · No injuriesClosedPiper PA-28 · Albany, ORSep 19, 1967 · N7349W · Substantial damage NTSB SEA67D0257Accident · No injuriesClosedPiper PA-28 · Arlington, ORFeb 10, 1967 · N7960W · Substantial damage NTSB SEA67A0012Accident · No injuriesClosedPiper PA-28 · Mitchell, ORAug 7, 1966 · N7409W · Substantial damage