Skip to content

NTSB investigations: Piper PA-28-180, MA

27 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

19652026

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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 NYC04CA091Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Norwood, MAThe student pilot failure to recover from a bounced landing. A factor in this accident was the student pilot's lack of solo flight experience.Mar 24, 2004 · N6535J · Substantial damage NTSB IAD02LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, MAThe pilot's delayed aborted landing and his failure to attain obstacle clearance. The pilot's misjudgment of distance is a contributing factor.Jan 14, 2002 · N3997R · Substantial damage NTSB NYC00LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norwood, MAthe pilot's improper bounced landing recovery. A factor was the pilot's lack of total flight experience.Jul 16, 2000 · N2176T · Substantial damage NTSB NYC98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Edgartown, MAThe pilot's inadequate evaluation of the wind direction and his failure to initiate a go-around. Contributing factors were the tailwind, wet runway, and utility pole.Oct 3, 1997 · N7742W · Substantial damage NTSB NYC95LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norfolk, MAThe pilot's misjudgement of speed and distance during the landing, which resulted in a runway overrun. Factors relating to the accident were: heavy rain, wet runway, and hydroplaning conditions.Aug 12, 1995 · N8252W · Substantial damage NTSB BFO93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Byfield, MALoss of engine power during climb for undetermined reasons.Sep 11, 1993 · N4898T · Destroyed NTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.Jul 24, 1993 · N9044J · 2 aircraft · Substantial damage NTSB NYC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Northampton, MAPilot's improper handling of the airplane, resulting in the loss of directional control. Contributing to the accident were gusty wind conditions and the pilot's lack of total experience.Jan 14, 1990 · N8201W · Substantial damage NTSB NYC89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Turners Falls, MALoss of control during landing roll due to ice on the runway, and collision with a snow bank off the runway which sheared the left main landing gear.Jan 14, 1989 · N1057X · Substantial damage NTSB NYC88LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · E.Harwich Port, MAThe pilot departed chatham airport for a local pleasure flight. Shortly after takeoff and while turning left in the pattern, the engine suffered a power loss. The pilot prepared for an emergency landing and transmitted a 'may day'. The aircraft crashed in a…Nov 28, 1987 · N9714J · Destroyed NTSB NYC83FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Plymouth, MAThe aircraft had been repossessed. The purpose of the flight was for the pilot to demonstrate it to one or both of the other occupants. Prior to this flight, the aircraft had not been flown since 5/20/82. During takeoff, the engine lost power at about 200 ft…Nov 19, 1982 · N9103J · Destroyed NTSB NYC81FNA13Accident · No injuriesClosedPiper PA-28 · Hyannis, MAMar 14, 1981 · N4945L · Substantial damage NTSB NYC77FNA29Accident · No injuriesClosedPiper PA-28 · Chatham, MAAug 23, 1977 · N1526X · Substantial damage NTSB NYC7LFNA10Accident · No injuriesClosedPiper PA-28 · Vineyard Haven, MAAug 8, 1975 · N55513 · Substantial damage NTSB NYC75FNA11Accident · Serious injuriesClosedPiper PA-28 · Oak Bluffs, MAAug 16, 1974 · N55405 · Substantial damage NTSB NYC75FNE02Accident · Minor injuriesClosedPiper PA-28 · Pittsfield, MAJul 25, 1974 · N7318W · Substantial damage NTSB NYC74FNA14Accident · Minor injuriesClosedPiper PA-28 · Danvers, MASep 3, 1973 · N9572J · Substantial damage NTSB NYC74AN005Accident · 1 fatalClosedPiper PA-28 · Martha Vinyd, MAJul 10, 1973 · N2679T · Substantial damage NTSB NYC70DFD23Accident · No injuriesClosedPiper PA-28 · Boston, MAJun 30, 1970 · N5317L · Destroyed NTSB NYC69F0306Accident · No injuriesClosedPiper PA-28 · Mendon, MAJan 19, 1969 · N8124W · Substantial damage NTSB NYC69D0062Accident · Minor injuriesClosedPiper PA-28 · Edgartown, MAJul 17, 1968 · N7304W · Substantial damage NTSB NYC68F0200Accident · Serious injuriesClosedPiper PA-28 · Brewster, MAAug 13, 1967 · N7843W · Destroyed NTSB NYC67F0688Accident · Serious injuriesClosedPiper PA-28 · Mendon, MAMay 18, 1967 · N8042W · Destroyed NTSB NYC67D0636Accident · No injuriesClosedPiper PA-28 · Northampton, MAApr 29, 1967 · N7916W · Substantial damage NTSB NYC67D0540Accident · No injuriesClosedPiper PA-28 · North Adams, MAFeb 24, 1967 · N7817W · Substantial damage NTSB NYC67A0111Accident · 1 fatalClosedPiper PA-28 · Dedham, MAFeb 9, 1967 · N9588J · Destroyed NTSB UNK65X1369Accident · No injuriesClosedPiper PA28 · Norwood, MAJan 29, 1965 · N7479W · Substantial damage