NTSB investigations: Piper J3C-65, KY
9 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.
Cases per year
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1976 | 1 |
| 1987 | 1 |
| 2014 | 1 |
| 2019 | 1 |
| 2022 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'KY' 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" = 'KY' 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" DESCRun 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 ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.NTSB CEN19LA184Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Vine Grove, KYThe pilot’s failure to maintain a proper visual lookout during the approach, which resulted in inadequate clearance from a tree.NTSB ERA14LA253Accident · Serious injuriesLimited investigationFinal reportPiper J3C - 65 · Hopkinsville, KYThe failure of the pilot to identify poor engine performance during the engine run-up before takeoff. Also causal to the accident was the mistimed right magneto and the poor condition of the spark plugs in the No. 4 cylinder.NTSB ATL87LA246Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Greenville, KYThe flt was being conducted as part of a 'clown act' at an air show. The eng lost pwr shortly after takeoff as the plt was performing pitching maneuvers. He unsuccessfully attempted to regain pwr by 'pumping' the throttle. The airplane subsequently impacted…NTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYNTSB CHI70DGJ18Accident · Serious injuriesClosedPiper J-3 · Whitesburg, KYNTSB CHI70D0021Accident · No injuriesClosedPiper J3C-65 · Shepherdsville, KYNTSB CHI69F0322Accident · Minor injuriesClosedPiper J3C-65 · Nicholasville, KYNTSB CHI67D0074Accident · No injuriesClosedPiper J-3 · Columbia, KY