Skip to content

NTSB investigations: Piper J3C-65, MA

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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 ERA11LA379Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Egremont, MAA partial loss of engine power due to the No. 4 intake and exhaust valves becoming lodged in the valve guides, which resulted from a lack of use, improper engine storage preparation, and improper return to service from indefinite storage.Jul 5, 2011 · N98550 · Substantial damage NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.Apr 22, 2011 · N10674 · Substantial damage NTSB NYC07CA165Accident · No injuriesData collectionFinal reportPiper J3C-65 · Uxbridge, MAA partial loss of engine power for undetermined reasons.Jul 17, 2007 · N7088H · Destroyed NTSB NYC03LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Taunton, MAThe pilot's inadequate compensation for the winds, and his failure to maintain airspeed which resulted in the inadvertent stall. A factor in the accident was the tailwind.Apr 2, 2003 · N88387 · Substantial damage NTSB NYC92FA026Accident · 2 fatalField investigationFinal reportPiper L-3 · Plymouth, MAThe improper decision by the non-instrument-rated pilot to attempt VFR flight in instrument meteorological conditions, at a low altitude, which resulted in a collision with the water. Factors related to the accident were: the overconfidence of the pilot in…Nov 3, 1991 · N6AN · Destroyed NTSB NYC84LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Stow, MADuring the landing roll, the acft began drifting to the left & the student plt overcontrolled with the rudder. Subsequently, the acft departed the rwy, collided with a snowbank & nosed over. The instructor (CFI) took control of theacft as the veer was taking…Apr 1, 1984 · N1141V · Substantial damage NTSB NYC83LA089Accident · No injuriesLimited investigationFinal reportPiper J3C-85 · Spencer, MAThe pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the…Apr 9, 1983 · N26182 · Substantial damage NTSB NYC79FNA03Accident · No injuriesClosedPiper J3 · Merrimac, MAOct 8, 1978 · N5719N · Substantial damage NTSB NYC78FNA14Accident · No injuriesClosedPiper J3 · Haverhill, MAJan 29, 1978 · N5719N · Substantial damage NTSB NYC76FNE03Accident · Minor injuriesClosedPiper J-3 · S Deerfield, MAAug 3, 1975 · N7279H · Substantial damage NTSB NYC76AN001Accident · 1 fatalClosedPiper J3 · Stow, MAJul 3, 1975 · N2112M · Substantial damage NTSB NYC74FNE15Accident · No injuriesClosedPiper J3C-65 · Windsor, MAFeb 6, 1974 · N87926 · Substantial damage NTSB NYC73FNA03Accident · No injuriesClosedPiper J3C-65 · Halifax, MAJul 8, 1972 · N42186 · Substantial damage NTSB NYC72FNA20Accident · 1 fatalClosedPiper J3C-65 · Haverhill, MANov 13, 1971 · N3406K · Destroyed NTSB NYC71DFD29Accident · No injuriesClosedPiper J-3 · Stow, MADec 20, 1970 · N6931H · Substantial damage NTSB NYC69F0256Accident · Serious injuriesClosedPiper J3 · Shirley, MAOct 20, 1968 · N42841 · Substantial damage NTSB NYC68F0209Accident · No injuriesClosedPiper J3C-65 · Mashpee, MAAug 24, 1967 · N6362H · Substantial damage NTSB NYC67A0088Accident · 1 fatalClosedPiper J3C-65 · Millis, MANov 24, 1966 · N88669 · Destroyed NTSB NYC67D0329Accident · No injuriesClosedPiper J3C-65 · Agawam, MANov 1, 1966 · N70596 · Substantial damage NTSB NYC67D0128Accident · Minor injuriesClosedPiper J3C-65 · Cheshire, MAJul 31, 1966 · N88179 · Substantial damage NTSB NYC67F0015Accident · Minor injuriesClosedPiper J3 · Tewksbury, MAMay 30, 1966 · N7485H · Destroyed NTSB NYC66F0569Accident · No injuriesClosedPiper J-3 · Tewksbury, MAMar 19, 1966 · N7485H · Substantial damage NTSB NYC66F0518Accident · No injuriesClosedPiper JC3 · Lawrence, MAFeb 6, 1966 · N6340H · Substantial damage NTSB NYC66F0365Accident · No injuriesClosedPiper J3C-65 · Agawam, MANov 12, 1965 · N70596 · Substantial damage NTSB NYC66D0145Accident · No injuriesClosedPiper J-3 · Cheshire, MAJul 31, 1965 · N42165 · Substantial damage NTSB NYC66F0091Accident · No injuriesClosedPiper J3C · Hopedale, MAJul 3, 1965 · N6213H · Substantial damage NTSB NYC66F0013Accident · No injuriesClosedPiper J-3 · Tewksbury, MAJun 3, 1965 · N186CM · Minor damage NTSB UNK64X0333Accident · No injuriesClosedPiper J3C · Fitchburg, MAJan 23, 1964 · N7259H · Substantial damage