Skip to content

NTSB investigations: Piper PA-25-235, AZ

40 cases on aircraft the registry lists as Piper PA-25-235. 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

19642026

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 ('7102504')) 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 ('7102504'))
  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 ('7102504'))
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 LAX04LA240Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's failure to maintain a proper pitch attitude during tow operations and his failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.Jun 13, 2004 · N4602Y · Substantial damage NTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.Sep 21, 1995 · N8551L · Substantial damage NTSB LAX95LA253Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Maricopa, AZan undetermined internal failure of the carburetor.Jul 6, 1995 · N9188T · Substantial damage NTSB LAX95LA183Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Peoria, AZthe pilot's inflight loss of control due to his delay in releasing the glider after the towed glider experienced an unplanned altitude gain on takeoff when it encountered a dust devil.May 11, 1995 · N7403Z · Destroyed NTSB LAX90FA250Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Pleasant Valley, AZAn inadvertent spin after failure to maintain airspeed. Factors include inadequate preflight, and an improperly maintained lap belt.Jul 11, 1990 · N6763Z · Substantial damage NTSB LAX87DUJ09Accident · No injuriesFinal reportPiper PA-25-235 · San Simon, AZDuring a pull up from an aerial application swath run, the aircraft struck a power line. The accident occurred during daylight in visual meteorological conditions.Aug 12, 1987 · N7328Z · Substantial damage NTSB LAX86FUJ01Accident · No injuriesFinal reportPiper PA-25-235 · Phoenix, AZThe acft collided with the ground rt wing first after a high sink rate developed in a 45 degree intercept to final with 30 degrees of bank and full flaps. The plt felt the acft sinking and attemtped to stop it with power and reduced angle of bank. He stated…Apr 19, 1986 · N6661Z · Substantial damage NTSB LAX84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · New River, AZThe tow pilot reported that during a takeoff tow with both acft still on the ground, he started to drift right as a gust of wind caught him. The glider pilot decided to release. The tow acft then went 100 yards off the rwy and collided with a parked glider.…Oct 24, 1983 · N4361Y · Substantial damage NTSB LAX83LA389Accident · Serious injuriesLimited investigationFinal reportPiper PA25-235 · Somerton, AZThe acft collided with the ground during a turn in turbulent air to abort an aerial application mission because of weather. The pilot stated that he had made two passes at the field he was spraying when he noticed the flagman and farmers waving him off due to…Aug 16, 1983 · N7104Z · Destroyed NTSB LAX81FUJ57Accident · 1 fatalClosedPiper PA-25 · New River, AZMay 2, 1981 · N4367Y · Destroyed NTSB LAX80DUJ78Accident · No injuriesClosedPiper PA-25 · Maricopa, AZJun 30, 1980 · N9182T · Substantial damage NTSB LAX79DUJ52Accident · No injuriesClosedPiper PA-25 · Maricopa, AZFeb 27, 1979 · N6705Z · Substantial damage NTSB LAX78FUJ88Accident · No injuriesClosedPiper PA-25 · Maricopa, AZJul 28, 1978 · N9182T · Substantial damage NTSB LAX77FUK03Accident · No injuriesClosedPiper PA-25 · Maricopa, AZSep 14, 1977 · N6601Z · No damage NTSB LAX77FUJ73Accident · Serious injuriesClosedPiper PA-25 · Roll, AZJul 13, 1977 · N6788Z · Destroyed NTSB LAX77DUJ28Accident · No injuriesClosedPiper PA-25 · Poston, AZFeb 3, 1977 · N4916Y · Substantial damage NTSB LAX76DUK12Accident · Minor injuriesClosedPiper PA-25 · Safford, AZSep 27, 1976 · N7670Z · Substantial damage NTSB LAX75FUJ20Accident · No injuriesClosedPiper PA-25 · Tucson, AZAug 9, 1974 · N9585P · Substantial damage NTSB LAX74DUJ14Accident · No injuriesClosedPiper PA-25 · Picacho, AZAug 28, 1973 · N6661Z · Substantial damage NTSB LAX73DLJ29Accident · No injuriesClosedPiper PA-25 · Marana, AZOct 8, 1972 · N4817Y · Substantial damage NTSB LAX73DUJ09Accident · No injuriesClosedPiper PA-25 · Picacho, AZJul 27, 1972 · N6877Z · Substantial damage NTSB LAX72FUJ50Accident · 1 fatalClosedPiper PA-25 · Wellton, AZOct 9, 1971 · N6979Z · Destroyed NTSB LAX72DUJ22Accident · No injuriesClosedPiper PA-25 · Parker, AZAug 5, 1971 · N6570Z · Substantial damage NTSB LAX71DUJ31Accident · Minor injuriesClosedPiper PA-25 · Poston, AZSep 16, 1970 · N4917Y · Destroyed NTSB LAX71DUJ14Accident · No injuriesClosedPiper PA-25 · Poston, AZJul 22, 1970 · N4976Y · Substantial damage NTSB LAX70F0050Accident · 1 fatalClosedPiper PA-25 · Casa Grande, AZJul 23, 1969 · N7437Z · Destroyed NTSB LAX70D0033Accident · Minor injuriesClosedPiper PA-25 · Elfrida, AZJul 6, 1969 · N7613Z · Destroyed NTSB LAX69D0139Accident · No injuriesClosedPiper PA-25 · Surprise, AZSep 4, 1968 · N7074Z · Destroyed NTSB LAX69F0142Accident · 1 fatalClosedPiper PA-25 · Elfrida, AZAug 30, 1968 · N4834Y · Destroyed NTSB LAX69F0118Accident · No injuriesClosedPiper PA-25 · Aguila, AZAug 30, 1968 · N6555Z · Destroyed NTSB LAX69D0002Accident · No injuriesClosedPiper PA-25 · Maricopa, AZJul 30, 1968 · N7680Z · Substantial damage NTSB LAX69D0089Accident · Minor injuriesClosedPiper PA-25 · Willcox, AZJul 24, 1968 · N4528Y · Substantial damage NTSB LAX69F0046Accident · 1 fatalClosedPiper PA-25 · Maryvale, AZJul 9, 1968 · N4482Y · Destroyed NTSB LAX69D0094Accident · No injuriesClosedPiper PA-25 · Maryvale, AZJun 16, 1968 · N4483Y · Destroyed NTSB LAX68D0233Accident · No injuriesClosedPiper PA-25 · Litchfield, AZNov 22, 1967 · N4483Y · Substantial damage NTSB LAX68F0087Accident · 1 fatalClosedPiper PA-25 · Maricopa, AZJul 16, 1967 · N7434Z · Destroyed NTSB LAX67D0014Accident · No injuriesClosedPiper PA-25 · Chinle, AZJun 13, 1966 · N7395Z · Substantial damage NTSB DEN66D0036Accident · Serious injuriesClosedPiper PA-25 · Goodyear, AZJul 3, 1965 · N6492Z · Destroyed NTSB UNK64X3755Accident · Minor injuriesClosedPiper PA25 · Eloy, AZSep 3, 1964 · N6821Z · Substantial damage NTSB UNK64X3242Accident · Serious injuriesClosedPiper PA-25 · Roll, AZAug 6, 1964 · N6713Z · Destroyed