Skip to content

NTSB investigations: Piper PA-25-235, WA

42 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" = 'WA' 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\" = 'WA' 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" = 'WA' 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 WPR21LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Twisp, WAAn in-flight separation of the control stick from the torque tube assembly, which resulted in a loss of directional control during the landing roll and subsequent on-ground collision.Jun 20, 2021 · N6917Z · Substantial damage NTSB SEA86LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Pullman, WAAfter takeoff during a 180 degree turn the aircraft developed a rapid rate of sink which the pilot was unable to arrest. While attempting to dump 140 pounds of water, the aircraft struck power lines and then struck the ground inverted. The aircraft was then…Jun 26, 1986 · N6490Z · Destroyed NTSB SEA85FA208Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Wenatchee, WAAfter two application runs, plt apparently attempted to shorten the race-track pattern by initiating the inbound turn into a canyon. Acft was observed to climb clear of the canyon wall near completion of turn, but load was jettisoned at this point and the…Sep 7, 1985 · N7340Z · Destroyed NTSB SEA85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-C · Wenatchee, WADuring an aerial applications maneuver the engine ceased operating and a forced landing was made in an orchard in between apple tree rows. Engine and aircraft inspection could not reveal any abnormalities with the exception of a very dirty, partially clogged…Jun 25, 1985 · N7396Z · Substantial damage NTSB SEA82DA048Accident · No injuriesFinal reportPiper PA-25-235 · Basin City, WADuring a return trip to the landing area from a dusting run the engine stopped. The main landing gear caught wires during an attempted landing to a field and the aircraft turned over before colliding with the ground. The fuel tanks were found empty and the…Apr 9, 1982 · N9546P · Substantial damage NTSB SEA81FYP10Accident · Minor injuriesClosedPiper PA-25 · Oaksdale, WAMar 11, 1981 · N7553Z · Substantial damage NTSB SEA80DYE34Accident · No injuriesClosedPiper PA-25 · Sequim, WAJun 4, 1980 · N7763Z · Substantial damage NTSB SEA79DYP33Accident · Minor injuriesClosedPiper PA-25 · Moses Lake, WAJul 6, 1979 · N4603Y · Substantial damage NTSB SEA77FYP45Accident · Minor injuriesClosedPiper PA-25 · Pasco, WASep 21, 1977 · N4566Y · Destroyed NTSB SEA77DYP26Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 28, 1977 · N8850L · Substantial damage NTSB SEA76FYG61Accident · Minor injuriesClosedPiper PA-25 · Othello, WAJun 29, 1976 · N7588Z · Substantial damage NTSB SEA76DYG13Accident · No injuriesClosedPiper PA-25 · Odessa, WASep 7, 1975 · N7491Z · Substantial damage NTSB SEA76DYG05Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 12, 1975 · N9546P · Substantial damage NTSB SEA76DYG04Accident · Minor injuriesClosedPiper PA-25 · Pasco, WAJul 11, 1975 · N6525Z · Substantial damage NTSB SEA75DYG43Accident · Minor injuriesClosedPiper PA-25 · St John, WAMay 17, 1975 · N4544Y · Substantial damage NTSB SEA74FYG31Accident · Minor injuriesClosedPiper PA-25 · Endicott, WAApr 22, 1974 · N4565Y · Destroyed NTSB SEA73FYG03Accident · Serious injuriesClosedPiper PA-25 · Pasco, WAJul 14, 1973 · N7478Z · Destroyed NTSB SEA74FYG02Accident · Minor injuriesClosedPiper PA-25 · Pasco, WAJun 27, 1973 · N7000Z · Destroyed NTSB SEA72DYG36Accident · No injuriesClosedPiper PA-25 · Odessa, WAApr 26, 1972 · N4464Y · Destroyed NTSB SEA72FYG31Accident · Minor injuriesClosedPiper PA-25 · Pullman, WAMar 16, 1972 · N4566Y · Destroyed NTSB SEA71DWG45Accident · Serious injuriesClosedPiper PA-25 · Pullman, WAApr 6, 1971 · N7415Z · Destroyed NTSB SEA71DWG01Accident · Minor injuriesClosedPiper PA-25 · Mesa, WAJul 2, 1970 · N6544Z · Destroyed NTSB SEA69D0228Accident · No injuriesClosedPiper PA-25 · Pomeroy, WAApr 3, 1969 · N7478Z · Substantial damage NTSB SEA69D0202Accident · No injuriesClosedPiper PA-25 · Pomeroy, WAMar 8, 1969 · N7263Z · Substantial damage NTSB SEA69D0100Accident · No injuriesClosedPiper PA-25 · Othello, WASep 3, 1968 · N7610Z · Substantial damage NTSB SEA69D0061Accident · No injuriesClosedPiper PA-25 · Warden, WAJul 28, 1968 · N7415Z · Substantial damage NTSB SEA69D0060Accident · No injuriesClosedPiper PA-25 · Moses Lake, WAJul 19, 1968 · N6654Z · Destroyed NTSB SEA68D0294Accident · No injuriesClosedPiper PA-25 · Palouse, WAApr 27, 1968 · N6807Z · Substantial damage NTSB SEA68F0270Accident · Minor injuriesClosedPiper PA-25 · Colfax, WAApr 3, 1968 · N7118Z · Substantial damage NTSB SEA68D0015Accident · No injuriesClosedPiper PA-25 · Kennewick, WAJun 23, 1967 · N4464Y · Substantial damage NTSB SEA68D0013Accident · Minor injuriesClosedPiper PA-25 · Royal City, WAJun 12, 1967 · N4566Y · Substantial damage NTSB SEA67F0357Accident · No injuriesClosedPiper PA-25 · Spokane, WAJun 5, 1967 · N7597Z · Substantial damage NTSB SEA67D0330Accident · No injuriesClosedPiper PA-25 · Palouse, WAMay 19, 1967 · N6807Z · Substantial damage NTSB SEA67F0280Accident · Minor injuriesClosedPiper PA-25 · Roosevelt, WAMar 30, 1967 · N7132Z · Destroyed NTSB SEA67D0261Accident · No injuriesClosedPiper PA-25 · Colfax, WAFeb 11, 1967 · N7118Z · Substantial damage NTSB SEA66A0069Accident · No injuriesClosedPiper PA-25 · Royal City, WAJun 20, 1966 · N6807Z · Minor damage NTSB SEA66F0268Accident · 1 fatalClosedPiper PA-25 · Kennewick, WAApr 28, 1966 · N6873Z · Destroyed NTSB SEA66F0090Accident · No injuriesClosedPiper PA-25 · Othello, WAAug 18, 1965 · N6900Z · Substantial damage NTSB SEA66F0089Accident · No injuriesClosedPiper PA-25 · Quincy, WAJul 16, 1965 · N6607Z · Substantial damage NTSB UNK64X3758Accident · 1 fatalClosedBoeing A75 · Quincy, WASep 3, 1964 · N49385 · 2 aircraft · Substantial damage NTSB UNK64X2467Accident · No injuriesClosedPiper PA25 · Moses Lake, WAJun 24, 1964 · N6900Z · Substantial damage NTSB UNK64X0982Accident · Minor injuriesClosedPiper PA25 · Walla Walla, WAMar 19, 1964 · N6612Z · Destroyed