NTSB investigations: Piper J3C-65, TN
14 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
| 1964 | 4 |
|---|---|
| 1966 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1985 | 1 |
| 1996 | 1 |
| 2003 | 1 |
| 2025 | 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\" = 'TN' 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" = 'TN' 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 ERA25FA239Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dunlap, TNOn June 24, 2025, about 18:23 central daylight time, a Piper J3C-65, N28DR, was substantially damaged when it was involved in an accident near Dunlap, Tennessee. The commercial pilot was fatally injured and the passenger was seriously injured. The airplane…NTSB ATL04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 -C65 · Jackson, TNThe pilot's improper us of flight controls during an attempted takeoff, which resulted in an collision with the specially equipped automobile.NTSB ATL96LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Nashville, TNthe failure of the pilot of the Piper PA-28, N26046, to visually clear the intended taxi course.NTSB ATL85LA151Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Tullahoma, TNThe plt was giving a 15 yr old passenger a local area flt. While in level flt at about 200 ft AGL, the acft hit an unmarked/guyed antenna tower & crashed. The plt reported that he did not see the tower. Although the tower had been there for many years, it was…NTSB IAD78FA006Accident · 1 fatalClosedPiper J-3 · Pulaski, TNNTSB IAD76AI090Accident · 1 fatalClosedPiper J-3 · Ooltewah, TNNTSB IAD76FKW19Accident · No injuriesClosedPiper J-3 · Elizabethton, TNNTSB MIA72FKW28Accident · No injuriesClosedPiper J3C-65 · Elizabethton, TNNTSB MIA70A0011Accident · 1 fatalClosedPiper J-3 · Lafayette, TNNTSB MIA67F0232Accident · No injuriesClosedPiper J-3 · Whiteville, TNNTSB UNK65X1187Accident · Minor injuriesClosedPiper J3C · Roellen, TNNTSB UNK64X3977Accident · Serious injuriesClosedPiper J3C · Jonesboro, TNNTSB UNK64X3080Accident · 1 fatalClosedPiper J3C-65 · Springfield, TNNTSB UNK64X0203Accident · Minor injuriesClosedPiper J3C · Cleveland, TN