Skip to content

NTSB investigations: Piper J3C-65, NJ

24 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" = 'NJ' 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\" = 'NJ' 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" = 'NJ' 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 ERA17LA281Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Green Creek, NJThe pilot's exhaustion of the fuel supply in the selected tank.Aug 20, 2017 · N46286 · Substantial damage NTSB ERA10LA437Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Williamstown, NJThe partial loss of engine power during takeoff due to weak spark plugs on the No. 1 cylinder.Aug 21, 2010 · N209RC · Substantial damage NTSB NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.Aug 12, 2007 · N6429H · Substantial damage NTSB IAD05LA042Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Andover, NJThe pilot receiving instruction's failure to maintain directional control during the landing roll. Factors in the accident were the flight instructors delayed remedial action, and crosswind.Mar 5, 2005 · N87955 · Substantial damage NTSB NYC02LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Andover, NJThe flight instructor's delayed remedial action, and the private pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.Jul 7, 2002 · N9264 · Substantial damage NTSB NYC96LA179Accident · No injuriesLimited investigationFinal reportPiper J-3 · Wildwood, NJThe pilot's failure to maintain sufficient altitude during a low altitude maneuver.Sep 2, 1996 · N92085 · Substantial damage NTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.Jul 31, 1994 · N2313 · 2 aircraft · Minor damage NTSB NYC89LA147Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Erma, NJFailure of the pilot to maintain airspeed during a banner pickup.Jun 10, 1989 · N46286 · Substantial damage NTSB NYC87LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cape May, NJThe Piper J3C-65 made an unsuccessful attempt at a banner pickup and was maneuvering at 400 ft in a climbing left turn for another pickup when a power loss occurred. The pilot made a forced landing in a marsh. The pilot reported the fuel quanity gauge was…Jun 28, 1987 · N42138 · Substantial damage NTSB NYC78FHM28Accident · No injuriesClosedCessna 150 · West Milford, NJSep 10, 1978 · N5459Q · 2 aircraft · Substantial damage NTSB NYC76DHD21Accident · No injuriesClosedPiper J-3 · Bridgeton, NJMar 29, 1976 · N7497H · Substantial damage NTSB NYC75FHD17Accident · Minor injuriesClosedPiper J-3 · Bridgeport, NJAug 27, 1974 · N42843 · Substantial damage NTSB NYC73DHD01Accident · Serious injuriesClosedPiper J-3 · Rio Grande, NJJul 11, 1972 · N92085 · Substantial damage NTSB NYC71DHD58Accident · Minor injuriesClosedPiper J-3 · Mickleton, NJJun 26, 1971 · N75356 · Destroyed NTSB NYC71DHM26Accident · No injuriesClosedPiper J-3 · Colts Neck, NJApr 23, 1971 · N88074 · Substantial damage NTSB NYC70DHD40Accident · No injuriesClosedPiper J-3 · Hammonton, NJJun 24, 1970 · N2224M · Substantial damage NTSB NYC67D0674Accident · No injuriesClosedPiper J-3 · Readington, NJJun 4, 1967 · N98570 · Substantial damage NTSB NYC67D0489Accident · No injuriesClosedCessna 150 · Sewell, NJJan 22, 1967 · N3976J · 2 aircraft · Substantial damage NTSB NYC67D0080Accident · No injuriesClosedPiper J-3 · Erma, NJJul 11, 1966 · N46286 · Substantial damage NTSB NYC66D0535Accident · Minor injuriesClosedPiper J3 · Cherry Hill, NJFeb 7, 1966 · N6384H · Substantial damage NTSB NYC66F0113Accident · No injuriesClosedPiper J-3 · New Market, NJJul 20, 1965 · N42346 · Substantial damage NTSB UNK65X0375Accident · No injuriesClosedPiper J3C65 · Lincoln Park, NJOct 22, 1964 · N42201 · Substantial damage NTSB UNK64X2018Accident · Serious injuriesClosedPiper J3C · Fairfield, NJMay 30, 1964 · N23265 · Destroyed NTSB UNK64X1564Accident · No injuriesClosedPiper J3 · Moorestown, NJMay 2, 1964 · N98814 · Destroyed