Skip to content

NTSB investigations: Piper PA-28-180, UT

25 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" = 'UT' 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\" = 'UT' 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" = 'UT' 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 WPR24LA178Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Nephi, UTThe pilot’s incorrect movement of the fuel selector valve to an off or restricted position, which resulted in fuel starvation and a loss of engine power.May 31, 2024 · N7838W · Substantial damage NTSB WPR23LA329Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Kanab, UTThe pilot's decision to take off in high density altitude conditions, which resulted in a loss of control and subsequent impact with terrain.Aug 30, 2023 · N33094 · Substantial damage NTSB WPR23LA308Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Ritchfield, UTThe pilot’s improper preflight planning that resulted in the loss of engine power due to fuel exhaustion.Aug 8, 2023 · N8823J · Substantial damage NTSB DEN04FA002Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Teasdale, UTThe student pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the student pilot's inadvertent flight into adverse weather conditions, the low ceiling, the rain, the student…Oct 3, 2003 · N7357W · Destroyed NTSB DEN03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Green River, UTpilot's improper preflight planning and failure to maintain obstacle clearance. Contributing factors include improper short field takeoff procedures and the high vegetation at the end of the runway.Jun 19, 2003 · N2537R · Substantial damage NTSB DEN03LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Richfield, UTthe pilot's failure to maintain aircraft control during landing roll resulting in a ground loop/swerve and subsequent nose over. A contributing factor was the gusty wind conditions.Mar 7, 2003 · N8205W · Substantial damage NTSB DEN03LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Vernal, UTthe pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.Nov 27, 2002 · N9020J · Substantial damage NTSB DEN03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Salt Lake City, UTfuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.Oct 18, 2002 · N33170 · Substantial damage NTSB FTW98LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hurricane, UTThe pilot inadvertently inducing a porpoise oscillation, and his failure to maintain directional control. A factor was the excessive landing airspeed.Aug 22, 1998 · N4760L · Substantial damage NTSB DEN89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dutch John, UTInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during the takeoff ground run. Factors related to the accident were: the unfavorable (variable/gusty) wind condition, and the high vegetation and tree beside the…Aug 30, 1989 · N7111W · Substantial damage NTSB DEN85LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28-180N · Delta, UTThe acft was flown by a student plt and his instructor on a local tng flt. During landing the sutdent plt did not flair the acft in time, hit hard and bounced. The instructor took control, made a soft landing followed by the main landing gear collapsing. The…Jun 13, 1985 · N4760L · Substantial damage NTSB DEN81FTM30Accident · No injuriesClosedPiper PA-28 · Roosevelt, UTJun 22, 1981 · N5386L · Substantial damage NTSB DEN80FA047Accident · 4 fatalClosedPiper PA-28 · Logan, UTJan 12, 1980 · N9388J · Substantial damage NTSB DEN99FA057Accident · 4 fatalClosedPiper PA-28 · Fairview, UTAug 22, 1979 · N6445J · Substantial damage NTSB DEN79FTC02Accident · No injuriesClosedPiper PA-28 · Bountiful, UTSep 12, 1978 · N7989W · Substantial damage NTSB DEN76AD011Accident · 4 fatalClosedPiper PA-28 · Mountain Home, UTAug 22, 1975 · N8254W · Destroyed NTSB DEN75FTM05Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTSep 8, 1974 · N7511W · Substantial damage NTSB DEN74DTM21Accident · No injuriesClosedPiper PA-28 · Lake Powell, UTJun 15, 1974 · N5262L · Substantial damage NTSB DEN72FTM71Accident · Minor injuriesClosedPiper PA-28 · Sandy, UTJun 26, 1972 · N5191S · Destroyed NTSB DEN71AD011Accident · 2 fatalClosedPiper PA-28 · Oakley, UTSep 14, 1970 · N6490J · Destroyed NTSB DEN70F0125Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTNov 10, 1969 · N9759J · Substantial damage NTSB DEN69F0200Accident · Minor injuriesClosedPiper PA-28 · Park City, UTMar 9, 1969 · N9301J · Substantial damage NTSB DEN67D0276Accident · Serious injuriesClosedPiper PA-28 · Santaquin, UTApr 14, 1967 · N9210J · Destroyed NTSB DEN67A0014Accident · 5 fatalClosedPiper PA-28 · Vernal, UTAug 6, 1966 · N8300W · Destroyed NTSB DEN66A0033Accident · 1 fatalClosedPiper PA-28 · New Harmony, UTNov 14, 1965 · N7044W · Destroyed