Skip to content

NTSB investigations: Piper J3C-65, WA

28 cases on aircraft the registry lists as Piper J3C-65. 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 ('7100510')) 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 ('7100510'))
  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 ('7100510'))
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 WPR23LA215Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Belfair, WAThe total loss of engine power due to the fatigue failure of the crankshaft accessory drive gear.Jun 4, 2023 · N77583 · Substantial damage NTSB GAA19CA027Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe student pilot’s failure to maintain directional control during the landing roll.Oct 13, 2018 · N6048H · Substantial damage NTSB GAA17CA506Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe pilot receiving instruction’s failure to maintain directional control during landing.Aug 9, 2017 · N6048H · Substantial damage NTSB WPR14CA223Accident · No injuriesData collectionFinal reportPiper J3C 65 · Bellingham, WAThe pilot's failure to maintain directional control during the landing on a narrow airstrip, which resulted in a collision with trees.Jun 3, 2014 · N1205P · Substantial damage NTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.Oct 3, 2008 · N2146M · Substantial damage NTSB SEA01LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Seattle, WAThe pilot's failure to visually detect the barricade, resulting in a collision with the barricade. Factors included the barricade, and inadequate information on the ATIS broadcast.Mar 17, 2001 · N30616 · Substantial damage NTSB SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.Apr 22, 1999 · N48612 · 2 aircraft · Substantial damage NTSB SEA96LA215Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, WAinadequate visual lookout by the pilot of the Piper J3, and failure of the flight instructor in the Bellance to ensure that clearance was maintained from the other moving aircraft. Factors relating to the accident were: the inherent visual restrictions…Sep 14, 1996 · N8809 · 2 aircraft · Substantial damage NTSB SEA94LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Snohomish, WAPoor in-flight planning/decision. A factor to the accident was: high vegetation.Apr 23, 1994 · N70277 · Substantial damage NTSB SEA88LA161Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Shelton, WAThe pilot reported a complete loss of power in cruise flight while ferrying an aircraft to its home base after an annual inspection. The pilot landed in a small field of rye crop. The pilot stated that the size of the field precluded a normal approach. The…Aug 23, 1988 · N8370H · Substantial damage NTSB SEA87LA033Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Waitsburg, WAThe pilot elected to circle coyotes at a very low altitude. During the second turn the aircraft felt mushy. The aircraft's left wing tip struck the ground followed by the aircraft striking the ground hard and flat.Nov 25, 1986 · N6849H · Substantial damage NTSB SEA85FA171Accident · 2 fatalField investigationFinal reportPiper J3-C-65 · Goose Prairie, WAThe acft contacted trees while the plt was performing low level passes over a boy scout camp. Witnesses reported the plt made three passes over the camp and during one of those passes, the plt dropped a bag of candy bars to the scouts. The fourth, during…Jul 18, 1985 · N70691 · Destroyed NTSB SEA81DYE29Accident · No injuriesClosedPiper J-3 · Bainbridge Isl, WAMay 12, 1981 · N51565 · Substantial damage NTSB SEA79FYM22Accident · Minor injuriesClosedPiper J3C-65 · Camas, WAMar 24, 1979 · N1326N · Substantial damage NTSB SEA78FA061Accident · 2 fatalClosedPiper J3 · Lynden, WASep 4, 1978 · N6391H · Destroyed NTSB SEA78FYP32Accident · Minor injuriesClosedPiper J3C-65 · Moses Lake, WAJun 10, 1978 · N98735 · Substantial damage NTSB SEA77DYM31Accident · No injuriesClosedPiper J-3 · Yacolt, WAMay 14, 1977 · N42448 · Destroyed NTSB SEA76DYG65Accident · No injuriesClosedPiper J3C · Moses Lake, WAJul 10, 1976 · N98735 · Substantial damage NTSB SEA76DYG39Accident · No injuriesClosedPiper J3C · Tonasket, WAApr 4, 1976 · N70957 · Substantial damage NTSB SEA76AS026Accident · 1 fatalClosedPiper J3C-65 · Carbonado, WANov 9, 1975 · N6899H · Destroyed NTSB SEA76AS008Accident · 2 fatalClosedPiper J-3 · Quincy, WAJul 30, 1975 · N98280 · Destroyed NTSB SEA75AS038Accident · 2 fatalClosedPiper J-3C · Ellensburg, WAApr 6, 1975 · N48312 · Destroyed NTSB SEA71FWG22Accident · No injuriesClosedPiper J3C-65 · Coulee Dam, WASep 27, 1970 · N3591K · Substantial damage NTSB SEA69D0021Accident · Minor injuriesClosedPiper J-3 · Kennewick, WAJun 23, 1968 · N87723 · Substantial damage NTSB SEA68F0253Accident · Serious injuriesClosedPiper J3C-65 · Pomeroy, WAMar 2, 1968 · N6951H · Substantial damage NTSB SEA68F0149Accident · Minor injuriesClosedPiper J-3 · Kent, WASep 27, 1967 · N6899H · Substantial damage NTSB UNK65X1036Accident · No injuriesClosedPiper J3 · Birch Bay, WADec 17, 1964 · N92145 · Substantial damage NTSB UNK64X2258Accident · No injuriesClosedPiper J3C · Hartline, WAJun 13, 1964 · N6849H · Substantial damage