Skip to content

NTSB investigations: Piper PA-28-161, AZ

28 cases on aircraft the registry lists as Piper PA-28-161. 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

19792026

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" = 'AZ' 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 ('7102803', '7102834')) 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\" = 'AZ' 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 ('7102803', '7102834'))
  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" = 'AZ' 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 ('7102803', '7102834'))
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 GAA18CA275Accident · No injuriesData collectionFinal reportAeropro CZ S R O A240 · Chandler, AZThe pilot’s failure to stop and yield to the airplane taxiing on the taxiway, which resulted in a ground collision.May 11, 2018 · N481B · 2 aircraft · Substantial damage NTSB GAA17CA503Accident · No injuriesData collectionFinal reportPiper PA 28 · Mohave, AZThe pilot’s improper airspeed and pitch control during landing in variable, gusting wind conditions, which resulted in an aerodynamic stall and hard landing.Aug 19, 2017 · N536CA · Substantial damage NTSB WPR13CA219Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Cottonwood, AZThe student pilot's decision to attempt a night landing on an unlit runway, which resulted in a misaligned approach and subsequent collision with a fence. Contributing to the accident was the student pilot's improper set-up of the airplane radios, which…May 7, 2013 · N47717 · Substantial damage NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.Oct 5, 2012 · N8115Q · 2 aircraft · Substantial damage NTSB WPR11CA298Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe flight instructor's delayed remedial action and failure to maintain lateral control.Jun 16, 2011 · N434K · Substantial damage NTSB WPR10FA264Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Chandler, AZFailure of the maintenance personnel to ensure adequate torque of a fuel line fitting, which resulted in an in-flight fire.May 26, 2010 · N4122T · Substantial damage NTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.Sep 9, 2009 · N94741 · 2 aircraft · Substantial damage NTSB WPR09CA054Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe failure of the student pilot to maintain directional control during takeoff.Dec 5, 2008 · N268ML · Substantial damage NTSB SEA08LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot's delay in initiating the go-around, and the flight instructor's inadequate supervision of the flight and delayed remedial action. Contributing to the accident were the momentary failure of the engine to respond, the failure of both the…Mar 3, 2008 · N8400A · Substantial damage NTSB LAX06CA026Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Payson, AZa loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…Nov 7, 2005 · N2111P · Substantial damage NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.Jul 12, 2005 · N9886K · Substantial damage NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.Feb 17, 2005 · N80565 · Substantial damage NTSB LAX05CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Roosevelt, AZthe pilot's failure to maintain directional control.Feb 10, 2005 · N973EL · Substantial damage NTSB LAX05CA067Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.Jan 8, 2005 · N8351W · Substantial damage NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.May 13, 2004 · N84245 · Substantial damage NTSB LAX03LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Scottsdale, AZThe pilot's inadequate preflight inspection and failure to refuel the airplane resulting in a loss of engine power due to fuel starvation.Dec 9, 2002 · N2588Y · Substantial damage NTSB LAX03LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Queen Creek, AZa loss of engine power for undetermined reasons.Oct 21, 2002 · N4332W · Substantial damage NTSB LAX98LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of the pilot to maintain directional control of the aircraft during takeoff.Jul 19, 1998 · N2148Y · Substantial damage NTSB LAX93LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZLoss of engine power for an undetermined reason.Feb 26, 1993 · N975MA · Substantial damage NTSB LAX92LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Douglas, AZAn encounter with an unforecasted high velocity wind gust which caused the airplane to nose over to an inverted position.Apr 1, 1992 · N28723 · Substantial damage NTSB LAX92LA020Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Chandler, AZAn engine malfunction produced by exhaust valves stuck in the open position. Contributing to the accident was an unsuitable landing area and a sign adjacent to the landing area.Oct 20, 1991 · N8092A · Substantial damage NTSB LAX90LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot inadvertently stalling the aircraft and an inadequate altitude to perform a stall recovery. Factors in this accident were: lack of total experience and student's anxiety.Apr 24, 1990 · N2110D · Substantial damage NTSB LAX89FA074Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Yucca, AZPilot's failure to maintain directional control. Contributing factors included the pilot's improper in-flight decision which was related to his overconfidence in his personal ability, spatial disorientation upon encountering inclement weather during the…Dec 25, 1988 · N9276M · Destroyed NTSB LAX82DA112Accident · No injuriesFinal reportPiper PA-28-161 · Glendale, AZWhile taxiing for takeoff, the right wing of the aircraft collided with a sign that was located beside the taxiway.Mar 1, 1982 · N2524U · Substantial damage NTSB LAX81DUJ36Accident · No injuriesClosedPiper PA-28 · Apache Jct, AZFeb 28, 1981 · N2235B · Destroyed NTSB LAX80DUJ22Accident · No injuriesClosedPiper PA-28 · Kingman, AZNov 15, 1980 · N2089N · Substantial damage NTSB LAX80FA094Accident · 4 fatalClosedPiper PA-28 · Lk Roosevelt, AZMay 4, 1980 · N45090 · 2 aircraft · Destroyed NTSB LAX79DUK04Accident · No injuriesClosedPiper PA-28 · Taylor, AZJul 28, 1979 · N9810C · Substantial damage