Skip to content

NTSB investigations: Piper J3C-65, IN

15 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

19652026

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN27LA021Accident · 1 fatalClass 3 · LimitedPreliminary reportPiper J3C-65 · Boonville, INOn October 18, 2026, about 1500 central daylight time, a Piper J3C-65 airplane, N88218, was involved in an accident near Boonville, Indiana. The pilot was not injured and a passenger in a vehicle that was struck by the airplane was fatally injured. The…Oct 18, 2026 · N88218 · Substantial damage NTSB CEN21LA359Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Gosport, INA total loss of engine power during cruise flight due to the failure of a cylinder exhaust valve stem, which led to a forced landing during which the airplane impacted terrain.Aug 6, 2021 · N6269H · Substantial damage NTSB CEN19TA293Accident · No injuriesClass 3Final reportPiper J3C · Russiaville, INThe pilot's failure to reinstall the oil cap after adding oil, which resulted to oil starvation and a precaautionary landing.Aug 25, 2019 · N49614 · Substantial damage NTSB CEN14CA231Accident · Minor injuriesData collectionFinal reportPiper J3C 65 · Connersville, INThe pilot's inability to control the airplane while taxiing due to a strong crosswind condition.May 3, 2014 · N6245H · Substantial damage NTSB CHI04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 · Florence, INThe pilot prematurely lifted off during the takeoff with inadequate airspeed which resulted in the airplane stalling. Factors associated with the accident were there unsuitable/rough terrain that the pilot used for takeoff.Oct 8, 2003 · N71027 · Substantial damage NTSB CHI03LA268Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Tocsin, INThe pilot attempting the low altitude turn and his failure to maintain clearance from the corn crop. A factor to the accident was the corn crop.Aug 19, 2003 · N37923 · Destroyed NTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…Apr 8, 2001 · N6460D · Substantial damage NTSB CHI88DEX06Accident · No injuriesFinal reportPiper J3 · Bedford, INAircraft was in cruise flight at 1000 feet AGL when the pilot heard a backfire from the engine followed by immediate and total loss of power. Forced landing was made in rugged, rocky terrain. Landing gear sheared off on rollout. Investigation revealed failure…Jul 1, 1988 · N42684 · Substantial damage NTSB CHI73FEA22Accident · Minor injuriesClosedPiper J3C-65 · Terre Haute, INJan 25, 1973 · N92343 · Destroyed NTSB CHI71DBA33Accident · No injuriesClosedPiper J3 · Mechanicsburg, INMar 26, 1971 · N21811 · Substantial damage NTSB CHI70F0331Accident · Serious injuriesClosedPiper J3C-65 · Rising Sun, INSep 28, 1969 · N26833 · Destroyed NTSB CHI70D0141Accident · No injuriesClosedPiper J-3 · Mentone, INJun 7, 1969 · N24643 · Substantial damage NTSB CHI70D0082Accident · No injuriesClosedPiper J-3 · Richmond, INMay 31, 1969 · N70430 · No damage NTSB CHI68D0552Accident · No injuriesClosedPiper J3C-65 · Greenwood, INJan 18, 1968 · N92012 · Substantial damage NTSB CHI66F0413Accident · Minor injuriesClosedPiper J3C-65 · Greenfield, INNov 7, 1965 · N87851 · Substantial damage