Skip to content

NTSB investigations: Piper PA-25-235, OR

24 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

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 ('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\" = '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 ('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" = '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 ('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 SEA96LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Cornelius, ORthe pilot's inadequate preflight planning, and his failure to see-and-avoid the obstruction (inadequate visual lookout). The transmission wire was a related factor.Jul 25, 1996 · N9624P · Substantial damage NTSB SEA93LA101Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Forest Grove, ORThe pilot in command's inadequate preflight planning. Factors contributing to the accident were the wet terrain, tailwind, trees, and wires.Apr 24, 1993 · N9637P · Substantial damage NTSB SEA85LA152Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Burns, ORDuring aerial applications the pilot cleared a rise, got a down draft, struck trees and then stalled striking the ground with little forward motion. An intense explosion and fire followed. The fire origin was in the area of the fiberglass fuel tank. An…Jun 27, 1985 · N6647Z · Destroyed NTSB SEA84LA093Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Heppner, ORThe plt reported that he was making a turn below the lee side of a ridge line at an alt of about 30 ft AGL. The acft reportedly encountered a downdraft & settled into the ground. During this occurrence, the landing gear collapsed, but no other major damage…Apr 22, 1984 · N9866P · Destroyed NTSB SEA83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235B · La Grande, ORThe acft stalled about 30 feet AGL during a forced landing after the engine quit from fuel exhaustion. The pilot took the acft for a ferry flight without refueling. It had been flown about 1 hour & 15 minutes. It holds about 36 gallons and burns about 14…May 14, 1983 · N7757Z · Destroyed NTSB SEA81DYM29Accident · No injuriesClosedPiper PA-25 · La Grande, ORJun 22, 1981 · N6782Z · Substantial damage NTSB SEA80DYM23Accident · Serious injuriesClosedPiper PA-25 · Antelope, ORMar 18, 1980 · N7077Z · Destroyed NTSB SEA79FYA23Accident · No injuriesClosedPiper PA-25 · Adrian, ORAug 21, 1979 · N6721Z · Substantial damage NTSB SEA79FYK15Accident · Serious injuriesClosedPiper PA-25 · Burns, ORJun 1, 1979 · N4753Y · Substantial damage NTSB SEA76FYC54Accident · Serious injuriesClosedPiper PA-25 · Rickreall, ORMay 26, 1976 · N7436Z · Substantial damage NTSB SEA76FYC42Accident · Serious injuriesClosedPiper PA-25 · Condon, ORMay 3, 1976 · N7664Z · Substantial damage NTSB SEA76DYC01Accident · No injuriesClosedPiper PA-25 · Baker, ORJul 3, 1975 · N6504Z · Substantial damage NTSB SEA7KFYC37Accident · No injuriesClosedPiper PA-25 · Kent, ORMay 14, 1975 · N6638Z · Destroyed NTSB SEA74FYC47Accident · 1 fatalClosedPiper PA-25 · Corvallis, ORApr 24, 1974 · N7276Z · Destroyed NTSB SEA74DYI04Accident · No injuriesClosedPiper PA-25 · Burns, ORJun 22, 1973 · N7374Z · Substantial damage NTSB SEA73DYI04Accident · No injuriesClosedPiper PA-25 · Glide, ORSep 19, 1972 · N7134Z · Substantial damage NTSB SEA73FYA10Accident · No injuriesClosedPiper PA-25 · Ontario, ORSep 8, 1972 · N6887Z · Substantial damage NTSB SEA72DYA40Accident · Minor injuriesClosedPiper PA-25 · Ontario, ORJun 19, 1972 · N7275Z · Destroyed NTSB SEA72FYA37Accident · Serious injuriesClosedPiper PA-25 · Nyssa, ORJun 6, 1972 · N6512Z · Destroyed NTSB SEA71DYA34Accident · Minor injuriesClosedPiper PA-25 · Arock, ORJun 6, 1971 · N7302Z · Destroyed NTSB SEA70FXM19Accident · Serious injuriesClosedPiper PA-25 · Ontario, ORJun 17, 1970 · N7749Z · Destroyed NTSB SEA70FVQ04Accident · Minor injuriesClosedPiper PA-25 · Harrisburg, ORMay 7, 1970 · N7635Z · Destroyed NTSB SEA70D0006Accident · Minor injuriesClosedPiper PA-25 · Vale, ORJun 14, 1969 · N6512Z · Substantial damage NTSB SEA66F0226Accident · No injuriesClosedPiper PA-25 · Hubbard, ORMar 10, 1966 · N7436Z · Substantial damage