Skip to content

NTSB investigations: Piper J3C-65, NE

34 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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 CHI03LA244Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Chadron, NEInadequate preflight planning by the pilot to ensure the required takeoff distance was utilized, as well as a failure to abort the takeoff. Contributing factors were the uphill gradient and the hangar.Aug 2, 2003 · N70522 · Substantial damage NTSB CHI96FA135Accident · 2 fatalField investigationFinal reportPiper J-3 · Raymond, NEfailure of the pilot to ensure that the fuel selector was properly positioned to the full 'on' position before takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb after takeoff; and the pilot's failure to maintain…Apr 18, 1996 · N6510H · Destroyed NTSB MKC90FA038Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Lynch, NEAirspeed was not maintained by the pilot resulting in a stall/spin.Dec 17, 1989 · N6874H · Destroyed NTSB MKC85LA135Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · York, NEThe plt reported that he had completed a landing & had come to a near stop, then he applied power & was on the brakes for control. He stated that the left brake locked & the acft went off the rwy into hi weeds & rough terrain. There was no damage due to…Jun 20, 1985 · N92253 · Substantial damage NTSB MKC84FA157Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Norfolk, NEThree witnesses stated the acft entered a steep climb after lift-off and continued climbing to an alt of aprx 250 to 350 ft AGL, stalled and spun to the rwy. The acft impacted the rwy 1100 ft from the apch end in a nose low and left wing low attitude.Jun 3, 1984 · N42497 · Substantial damage NTSB MKC84LA061Accident · No injuriesLimited investigationFinal reportPiper J-3 · Battle Creek, NEThe acft as taxiing on a hard packed snow covered field when the right main landing gear collapsed. Visual inspection did not show any signs of fatigue. Slight bending and overload separtion of the shock strut tubing was evident.Jan 9, 1984 · N6839H · Substantial damage NTSB MKC83LA096Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Minatare, NEThe plt reported that he was making a low pass to look over a possible landing area, when he allowed the acft to inadvertently touch down on soft soil beside the strip. The acft bounced, then landed hard and the main gear collapsed.Apr 27, 1983 · N23472 · Substantial damage NTSB MKC81DCJ27Accident · No injuriesClosedPiper PA-25 · Lodgepole, NEAug 31, 1981 · N70612 · Substantial damage NTSB MKC80FCJ06Accident · Serious injuriesClosedPiper J3C · Milburn, NEJan 30, 1980 · N2764C · Substantial damage NTSB MKC76DCJ37Accident · No injuriesClosedPiper J3C-65 · Ashland, NEMay 31, 1976 · N88431 · Substantial damage NTSB MKC76FCJ29Accident · Serious injuriesClosedPiper J3C-65 · Alliance, NEMar 17, 1976 · N3426K · Substantial damage NTSB MKC74DCJ24Accident · No injuriesClosedPiper J3C-65 · Spalding, NEJan 13, 1974 · N3523K · Substantial damage NTSB MKC73DCJ44Accident · No injuriesClosedPiper J3C-65 · Lodgepole, NEJun 2, 1973 · N6786H · Substantial damage NTSB MKC72FCJ34Accident · Serious injuriesClosedPiper J3C-65 · Atkinson, NEOct 24, 1971 · N73418 · Destroyed NTSB MKC71DCJ33Accident · Minor injuriesClosedPiper J3C-65 · Indianola, NEDec 13, 1970 · N92449 · Substantial damage NTSB MKC70DCJ18Accident · No injuriesClosedPiper J3L-65 · Ashland, NEApr 28, 1970 · N30504 · Substantial damage NTSB MKC70FCJ10Accident · Serious injuriesClosedPiper J3C-65 · Dunbar, NEFeb 15, 1970 · N3482K · Substantial damage NTSB MKC70D0276Accident · No injuriesClosedPiper J-3 · Burwell, NENov 16, 1969 · N32843 · Substantial damage NTSB MKC70D0174Accident · Minor injuriesClosedPiper J3C-65 · Broken Bow, NESep 5, 1969 · N98422 · Substantial damage NTSB MKC69D0385Accident · Minor injuriesClosedPiper J3C-65 · Ewing, NEDec 11, 1968 · N31026 · Destroyed NTSB MKC68F0565Accident · Minor injuriesClosedPiper J3C-65 · Valentine, NEApr 28, 1968 · N92327 · Substantial damage NTSB MKC68D0364Accident · No injuriesClosedPiper J3C-65 · Curtis, NENov 19, 1967 · N35210 · Substantial damage NTSB MKC68D0315Accident · Minor injuriesClosedPiper J-3 · Gothenburg, NEOct 28, 1967 · N42663 · Substantial damage NTSB MKC68F0170Accident · No injuriesClosedPiper J-3 · Lincoln, NEAug 20, 1967 · N92244 · Substantial damage NTSB MKC67D0407Accident · No injuriesClosedPiper J3C-65 · Gordon, NEJan 27, 1967 · N3423N · Substantial damage NTSB MKC67D0386Accident · No injuriesClosedPiper J3C-65 · Silver Creek, NEDec 29, 1966 · N6637H · Substantial damage NTSB MKC66F0442Accident · No injuriesClosedPiper J3C-65 · Broken Bow, NEMar 11, 1966 · N4790T · Substantial damage NTSB MKC66F0107Accident · No injuriesClosedPiper J-3 · Giltner, NEJul 25, 1965 · N3340N · Substantial damage NTSB MKC65A0077Accident · 1 fatalClosedPiper J3C · Nebraska City, NEJun 21, 1965 · N6149H · Destroyed NTSB MKC66D0001Accident · Minor injuriesClosedPiper J3-C · Nebraska City, NEMay 12, 1965 · N3482K · Destroyed NTSB MKC65F0053Accident · Minor injuriesClosedPiper J-3 · Loma, NEMar 20, 1965 · N3575K · Destroyed NTSB MKC65F0019Accident · Serious injuriesClosedPiper J-3 · Marquette, NEJan 31, 1965 · N92253 · Substantial damage NTSB UNK64X2691Accident · 1 fatalClosedPiper J3 · Tekamah, NEJul 6, 1964 · N98775 · Destroyed NTSB UNK64X0459Accident · No injuriesClosedPiper J3C · Taylor, NEFeb 4, 1964 · N42453 · Substantial damage