Skip to content

NTSB investigations: Piper J3C-65, AR

31 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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN10CA332Accident · No injuriesData collectionFinal reportPiper J3C-65 · Hot Springs, ARA total loss of engine power due to fuel starvation as a result of the pilot's inadvertent closure of the fuel valve. Contributing to the accident were the unmarked fuel shutoff valve and the pilot's inexperience in the accident airplane.Jun 14, 2010 · N70906 · Substantial damage NTSB DFW07CA035Accident · No injuriesData collectionFinal reportPiper J3C-65 · Humnoke, ARThe loss of engine power during initial takeoff climb for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Dec 6, 2006 · N7054H · Substantial damage NTSB DFW06FA184Accident · 2 fatalField investigationFinal reportPiper J3 · Walnut Ridge, ARThe pilot's failure to maintain airspeed and the subsequent stall. Contributing factors were the low altitude and impairment due to drugs.Jul 17, 2006 · N6732H · Destroyed NTSB DFW06LA159Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Stugartt, ARThe pilot's failure to maintain clearance from high brush during takeoff. Contributing factors were the short runway and the high density altitude.Jun 12, 2006 · N3542N · Substantial damage NTSB MKC90LA140Accident · No injuriesLimited investigationFinal reportPiper J-3 · Clarksville, ARFailure of the pilot to maintain flying speed.Jun 23, 1990 · N38348 · Substantial damage NTSB MKC89LA151Accident · Minor injuriesLimited investigationFinal reportPiper J3 "CUB" · Morrilton, ARThe abrupt handling of the airplane by the pilot. He failed to maintain airspeed and inadvertantly stalled and spun the airplane at an altitude insufficient for recovery.Jul 4, 1989 · N1414N · Substantial damage NTSB FTW83LA236Accident · No injuriesLimited investigationFinal reportPiper J3 · Sherrill, ARThe acft nosed over on an emergency downwind landing in a wet rice field after an eng failure. The plt stated that the eng failed as a result of water in the fuel. The operator services his acft from a private underground fuel storage tank. As a result of…May 16, 1983 · N42563 · Substantial damage NTSB FTW82FPG06Accident · 1 fatalClosedPiper J3C-65 · Star City, ARDec 26, 1981 · N20886 · Substantial damage NTSB FTW81FPG60Accident · 1 fatalClosedPiper J3C-65 · Almyra, ARAug 13, 1981 · N7399H · Substantial damage NTSB FTW80FPG02Accident · Serious injuriesClosedPiper J-3 · Pine Bluff, ARNov 6, 1979 · N98667 · Destroyed NTSB FTW79DPG79Accident · No injuriesClosedPiper J-3 · Fresno, ARAug 28, 1979 · N20886 · Substantial damage NTSB FTW79FPG44Accident · Serious injuriesClosedPiper J3C-65 · Crawfordsville, ARJun 4, 1979 · N7900A · Substantial damage NTSB FTW76AF100Accident · 1 fatalClosedPiper J3C · Fordyce, ARJun 10, 1976 · N3408N · Destroyed NTSB FTW75DRJ26Accident · No injuriesClosedPiper J3C-65 · Texarkana, ARMar 30, 1975 · N24962 · Substantial damage NTSB FTW75FPG45Accident · Serious injuriesClosedPiper PA-18A · Pine Bluff, ARMar 25, 1975 · N3538K · Substantial damage NTSB FTW74FPG32Accident · Serious injuriesClosedPiper J3C-65 · Lepanto, AROct 18, 1973 · N33034 · Destroyed NTSB FTW74DPG17Accident · No injuriesClosedPiper J-3 · Stuttgart, ARAug 27, 1973 · N71022 · Substantial damage NTSB FTW74DPG09Accident · No injuriesClosedPiper J-3 · Arkadelphia, ARJul 25, 1973 · N30799 · Substantial damage NTSB FTW72AF016Accident · 2 fatalClosedPiper J3C-65 · Springdale, ARSep 20, 1971 · N3633K · Destroyed NTSB FTW71FPG47Accident · Minor injuriesClosedPiper J3C-65 · Tamo, ARApr 9, 1971 · N3538K · Substantial damage NTSB FTW70FPG18Accident · 1 fatalClosedPiper J3C · Roe, ARApr 24, 1970 · N92450 · Destroyed NTSB FTW69F0302Accident · Serious injuriesClosedPiper J-3 · Hazen, ARNov 5, 1968 · N33206 · Substantial damage NTSB FTW68A0007Accident · 1 fatalClosedPiper J-3C · Parkin, ARJul 17, 1967 · N3511N · Destroyed NTSB FTW67F0339Accident · Minor injuriesClosedPiper J3C-65 · Stuttgart, ARNov 29, 1966 · N77565 · Substantial damage NTSB FTW67A0004Accident · 1 fatalClosedPiper J-3 · Stuttgart, ARJul 6, 1966 · N42418 · Destroyed NTSB FTW66A0114Accident · 1 fatalClosedPiper J3C · Almyra, ARJun 11, 1966 · N98052 · Destroyed NTSB FTW66A0106Accident · 1 fatalClosedPiper J-3 · Corning, ARMay 19, 1966 · N98459 · Destroyed NTSB FTW66D0607Accident · No injuriesClosedPiper J3 · Mt Home, ARMar 31, 1966 · N42733 · Substantial damage NTSB FTW66A0002Accident · 1 fatalClosedPiper J-3 · No.Little Rck, ARJul 7, 1965 · N88371 · Substantial damage NTSB UNK64X3308Accident · Serious injuriesClosedPiper J3C · Gould, ARAug 9, 1964 · N6879H · Substantial damage NTSB UNK64X3116Accident · Minor injuriesClosedPiper J3C · Pine Bluff, ARJul 30, 1964 · N98561 · Substantial damage