Skip to content

NTSB investigations: Piper PA-24-250, OR

35 cases on aircraft the registry lists as Piper PA-24-250. 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" = '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 ('7102404')) 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 ('7102404'))
  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 ('7102404'))
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 GAA19CA032Accident · No injuriesData collectionFinal reportPiper PA24 · Madras, ORThe pilot’s failure to extend the landing gear, which resulted in an attempted go-around and subsequent pitchdown and impact with the runway.Oct 18, 2018 · N6263P · Substantial damage NTSB WPR18LA005Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 24-250 · Hillsboro, ORThe student's pilot’s failure to maintain adequate airspeed during approach and subsequent exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall and a subsequent hard landing. Contributing to the accident was…Oct 5, 2017 · N7892P · Substantial damage NTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.Jun 5, 2011 · N511FS · Substantial damage NTSB WPR11CA141Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Aurora, ORThe pilot's failure to lower the landing gear prior to landing.Jan 18, 2011 · N3TP · Substantial damage NTSB WPR10FA239Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Redmond, ORThe pilot's failure to maintain airspeed, which resulted in a stall and collision with terrain.May 14, 2010 · N6967P · Substantial damage NTSB SEA00LA035Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Jordan Valley, ORInadequate preflight planning/preparation. Unsuitable terrain was selected for landing and a road sign were factors.Dec 27, 1999 · N5933P · Substantial damage NTSB SEA98LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sutherlin, ORLoss of engine power for an undetermined reason.Jan 23, 1998 · N8422P · Substantial damage NTSB SEA96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hillsboro, ORthe pilot's inadequate compensation for wind conditions, and his failure to attain a proper touchdown point for landing. A factor relating to the accident was: upsloping terrain short of the threshold.Jun 15, 1996 · N6554P · Substantial damage NTSB SEA90FA166Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Salem, ORThe pilot allowed the design stress limits of the aircraft to be exceeded. Factors related to the accident concerned inadvertent flight by the pilot into known adverse weather conditions.Aug 27, 1990 · N8103P · Destroyed NTSB SEA90LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA24-250 · Lagrande, ORThe pilot did not allow the airplane to attain an adequate airspeed prior to the retraction of flaps and landing gear.Aug 26, 1990 · N5642P · Destroyed NTSB SEA83LA023Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Cascade Locks, ORWhile cruising at 10000 feet MSL, in IMC conditions, the pilot reported that power had been lost. During descent to 2000 feet the engine restarted and failed several times but eventually maintained idle throughout the remainder of the descent. Portland…Nov 20, 1982 · N8185P · Substantial damage NTSB SEA82DYK02Accident · No injuriesClosedPiper PA-24 · Gold Beach, OROct 18, 1981 · N7686P · Substantial damage NTSB SEA80FYM16Accident · Minor injuriesClosedPiper PA-24 · Newport, ORFeb 22, 1980 · N5275P · Destroyed NTSB SEA80FYK05Accident · Serious injuriesClosedPiper PA-24 · Allegany, ORFeb 9, 1980 · N5628P · Substantial damage NTSB SEA79FYM45Accident · No injuriesClosedPiper PA-24 · Salem, ORJul 1, 1979 · N6651P · Substantial damage NTSB SEA77FYM49Accident · No injuriesClosedPiper PA-24 · Silverton, ORJul 25, 1977 · N5457P · Substantial damage NTSB SEA77FA020Accident · 2 fatalClosedPiper PA-24 · Eugene, ORMar 2, 1977 · N8216P · Destroyed NTSB SEA77FYM13Accident · No injuriesClosedPiper PA-24 · Yamhill, ORJan 8, 1977 · N7364H · Substantial damage NTSB SEA76DYC65Accident · No injuriesClosedPiper PA-24 · Madras, ORJul 19, 1976 · N7610P · Substantial damage NTSB SEA76FYC36Accident · No injuriesClosedPiper PA-24 · Estacada, ORApr 3, 1976 · N7586P · Substantial damage NTSB SEA73FYC15Accident · No injuriesClosedPiper PA-24 · Gervais, ORDec 25, 1972 · N6496P · Substantial damage NTSB SEA72DYI07Accident · No injuriesClosedPiper PA-24 · Bend, ORAug 19, 1971 · N6651P · Substantial damage NTSB SEA71DWA10Accident · No injuriesClosedPiper PA-24 · Waldport, ORAug 7, 1970 · N5718P · Substantial damage NTSB SEA71DWA03Accident · No injuriesClosedPiper PA-24 · Cove, ORJul 5, 1970 · N6256P · Substantial damage NTSB SEA69A0053Accident · 2 fatalClosedPiper PA-24 · Baker, ORMay 1, 1969 · N5831P · Destroyed NTSB SEA69A0044Accident · 1 fatalClosedPiper PA-24 · Pendleton, ORJan 26, 1969 · N5787P · Destroyed NTSB SEA68A0048Accident · 1 fatalClosedPiper PA-24 · Medical Spgs, ORJan 15, 1968 · N7435P · Destroyed NTSB SEA68F0205Accident · No injuriesClosedPiper PA-24 · Coos Bay, ORAug 3, 1967 · N5994P · Substantial damage NTSB SEA67F0235Accident · No injuriesClosedPiper PA-24 · Newberg, ORJan 21, 1967 · N8345P · Substantial damage NTSB SEA67F0157Accident · No injuriesClosedPiper PA-24 · Oregon City, ORAug 19, 1966 · N7798P · Substantial damage NTSB SEA66F0275Accident · No injuriesClosedPiper PA-24 · Salem, ORMay 26, 1966 · N5482P · Substantial damage NTSB SEA66A0058Accident · 4 fatalClosedPiper PA-24 · Npilot Rock, ORMay 22, 1966 · N5120P · Destroyed NTSB UNK64X3216Accident · No injuriesClosedPiper PA24 · Astoria, ORAug 4, 1964 · N5506P · Substantial damage NTSB UNK64X2378Accident · No injuriesClosedPiper PA24 · Aurora, ORJun 19, 1964 · N6297P · Substantial damage NTSB UNK64X2172Accident · No injuriesClosedPiper PA24 · Siletz, ORJun 7, 1964 · N6173P · Substantial damage