Skip to content

NTSB investigations: Piper J3C-65, MD

26 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" = 'MD' 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\" = 'MD' 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" = 'MD' 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 IAD01LA052Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Annapolis, MDpilot's failure to maintain directional control during landing. A factor was the crosswind.Apr 28, 2001 · N26096 · Substantial damage NTSB NYC99LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Frederick, MDThe pilot's failure to maintain directional control. Contributing factors were gusty wind conditions and the sign.Aug 1, 1999 · N70894 · Substantial damage NTSB NYC99FA161Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Dawson, MDThe pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, downdraft, and the pilot's decision to operate at a weight in excess of the maximum allowable gross weight.Jun 26, 1999 · N1548N · Destroyed NTSB NYC99FA160Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Dawson, MDwas the pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, and unfavorable winds.Jun 26, 1999 · N29832 · Substantial damage NTSB IAD96LA097Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Ashton, MDthe pilot's inadequate fuel supply which resulted in a fuel exhaustion and a loss of engine power. A related factor was the pilot's inadequate fuel consumption calculations.Jun 16, 1996 · N58379 · Substantial damage NTSB BFO92LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Frederick, MDThe pilot's improper use of carburetor heat resulting in the formation of carburetor ice. Carburetor icing weather conditions was a factor.Jul 6, 1992 · N92668 · Substantial damage NTSB NYC92LA132Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ocean City, MDThe pilot's inadequate visual look out for objects while taxing.Jun 25, 1992 · N88522 · Substantial damage NTSB BFO85FA062Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Oakland, MDThe acft had been observed on the day of this flt and on the 'past couple of days' to be flying low and very slow at tree top level. Ground witnesses heard the sounds of the crash but could not see the acft at the time. The acft impactedthe ground in a near…Jul 24, 1985 · N70336 · Destroyed NTSB IAD79DIA13Accident · Minor injuriesClosedPiper J-3 · Naylor, MDJun 16, 1979 · N1500N · Substantial damage NTSB IAD78FA092Accident · 1 fatalClosedPiper J-3 · White Marsh, MDAug 10, 1978 · N51537 · Destroyed NTSB IAD78FIG14Accident · Serious injuriesClosedPiper J3C · Westport, MDJul 23, 1978 · N42442 · Substantial damage NTSB IAD76FIG13Accident · Serious injuriesClosedPiper J3C-65 · Mt Airy, MDMar 26, 1976 · N51537 · Destroyed NTSB IAD74FIG10Accident · No injuriesClosedPiper J-3 · College Park, MDSep 23, 1973 · N38004 · Substantial damage NTSB NYC72AN107Accident · 2 fatalClosedPiper J-3 · College Park, MDMar 5, 1972 · N1399V · Destroyed NTSB IAD71DIG25Accident · No injuriesClosedPiper J-3 · College Park, MDMar 6, 1971 · N70294 · Substantial damage NTSB IAD71FIG19Accident · No injuriesClosedPiper J-3 · College Park, MDNov 7, 1970 · N1399V · Substantial damage NTSB DIA69F0161Accident · No injuriesClosedPiper J3C-65 · Edgewater, MDMar 22, 1969 · N98224 · Destroyed NTSB DIA68D0071Accident · No injuriesClosedPiper PA-28 · Edgewater, MDAug 29, 1967 · N4156J · 2 aircraft · Substantial damage NTSB DIA67F0103Accident · Minor injuriesClosedPiper J3C · Cumberland, MDMay 10, 1967 · N22831 · Substantial damage NTSB NYC66D0583Accident · No injuriesClosedPiper J3C · Bowie, MDMar 22, 1966 · N6627H · Destroyed NTSB NYC66D0515Accident · Minor injuriesClosedPiper J-3 · Edgewater, MDFeb 19, 1966 · N70255 · Substantial damage NTSB NYC66F0064Accident · Serious injuriesClosedPiper J3C · Baltimore, MDJul 17, 1965 · N70429 · Substantial damage NTSB UNK65X1222Accident · No injuriesClosedPiper J3 · White Marsh, MDJan 3, 1965 · N23327 · Substantial damage NTSB UNK64X3220Accident · No injuriesClosedPiper J3 · Issue, MDAug 5, 1964 · N6993H · Substantial damage NTSB UNK64X1413Accident · Minor injuriesClosedPiper J3 · Cumberland, MDApr 22, 1964 · N33232 · Substantial damage NTSB UNK64X1069Accident · No injuriesClosedPiper J3 · Elkton, MDMar 28, 1964 · N98195 · Substantial damage