Skip to content

NTSB investigations: Piper J3C-65, SD

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" = 'SD' 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\" = 'SD' 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" = 'SD' 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 CEN09CA608Accident · No injuriesData collectionFinal reportPiper J3C-65 · Spearfish, SDThe pilot's failure to maintain directional control during the takeoff roll.Sep 29, 2009 · N3260N · Substantial damage NTSB CHI07CA061Accident · No injuriesData collectionFinal reportPiper J3C-65 · White Lake, SDThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and a nose over. A factor associated with the accident was the crosswind.Jan 22, 2007 · N98096 · Substantial damage NTSB CHI03LA299Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · South Shore, SDA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the forced landing.Sep 4, 2003 · N38435 · Substantial damage NTSB CHI00LA100Accident · No injuriesLimited investigationFinal reportPiper J-3C · Eureka, SDthe foreign object (shot gun shell) which jammed the control stick. Factors associated with the accident were the low altitude at which the control stick jammed and the rough terrain which the airplane contacted.Mar 30, 2000 · N71060 · Substantial damage NTSB DEN86LA124Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Britton, SDThe acft was observed to climb to apprx 100 ft AGL, then turn & make a forced landing. The plt stated the eng had lost total pwr. The owner of the aircraft said that examination of the eng after the acft did not reveal evidence to explain the reported loss of…May 2, 1986 · N92283 · Substantial damage NTSB DEN84FA064Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Elm Springs, SDThe pilot was flying along a river bottom looking for stray cattle when the acft crashed into the ground. He received a serious head injury & could not recall details of the accident, but he believed that he was flying at about 100 ft AGL. An exam of the…Jan 5, 1984 · N98322 · Substantial damage NTSB MKC76FTK31Accident · Serious injuriesClosedPiper J3C-65 · Onida, SDJul 10, 1976 · N3423N · Substantial damage NTSB MKC75DTK20Accident · No injuriesClosedPiper J3C-65 · Scenic, SDJun 6, 1975 · N3400N · Substantial damage NTSB MKC72DTK20Accident · No injuriesClosedPiper J-3 · Watertown, SDJan 16, 1972 · N88653 · Substantial damage NTSB MKC70F0266Accident · No injuriesClosedPiper J3C-65 · Midland, SDNov 10, 1969 · N87924 · Substantial damage NTSB MKC69D0320Accident · No injuriesClosedPiper J3C-65 · Ferney, SDDec 14, 1968 · N3242N · Substantial damage NTSB MKC68F0545Accident · No injuriesClosedPiper J3L-65 · Northville, SDMay 14, 1968 · N24686 · Substantial damage NTSB MKC68A0046Accident · 2 fatalClosedPiper J-3 · Viborg, SDJan 14, 1968 · N42979 · Destroyed NTSB MKC68A0019Accident · 2 fatalClosedPiper J3F · Estelline, SDSep 4, 1967 · N40907 · Destroyed NTSB MKC67A0023Accident · 1 fatalClosedPiper J3C-65 · Faith, SDSep 14, 1966 · N87964 · Destroyed NTSB MKC67F0081Accident · Serious injuriesClosedPiper J-3 · Bonilla, SDJun 14, 1966 · N98098 · Destroyed NTSB MKC67F0038Accident · Minor injuriesClosedPiper J3C · Parkston, SDJun 14, 1966 · N6318H · Destroyed NTSB MKC66F0443Accident · No injuriesClosedPiper J-3 · Sturgis, SDFeb 26, 1966 · N88392 · Substantial damage NTSB MKC66D0433Accident · No injuriesClosedPiper J-3 · Bijou Hills, SDFeb 13, 1966 · N70542 · Substantial damage NTSB MKC66F0151Accident · Serious injuriesClosedPiper J3C · Pukwana, SDAug 5, 1965 · N88647 · Destroyed NTSB UNK64X3229Accident · No injuriesClosedPiper J3C · Hot Springs, SDAug 5, 1964 · N3477N · Substantial damage NTSB UNK64X1969Accident · Serious injuriesClosedPiper J3 · Doland, SDMay 27, 1964 · N3602N · Destroyed NTSB UNK64X1939Accident · No injuriesClosedPiper J3 · Mansfield, SDMay 24, 1964 · N70294 · Substantial damage NTSB UNK64X1508Accident · No injuriesClosedPiper PA12 · Sioux Falls, SDApr 29, 1964 · N3356N · Substantial damage