NTSB investigations: Piper J3C-65, SC
17 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
| 1965 | 3 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1976 | 2 |
| 1978 | 2 |
| 1983 | 1 |
| 1987 | 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\" = 'SC' 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" = 'SC' 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 ATL88LA017Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Clarks Hill, SCThe aircraft was circling about 200 feet above the trees when the pilot began a climbing turn. As he leveled the wings the aircraft began to descend. The pilot applied full power and eased forward on the control stick lowering the aircraft nose slightly. When…NTSB ATL83LA296Accident · No injuriesLimited investigationFinal reportCessna T210N · N. Myrtle Beach, SCCessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated…NTSB MIA78DLG26Accident · No injuriesClosedPiper J-3 · Newberry, SCNTSB MIA78FLG25Accident · Serious injuriesClosedPiper J3C · Harleyville, SCNTSB MIA76FLG43Accident · No injuriesClosedPiper J-3 · Aiken, SCNTSB MIA76AM082Accident · 1 fatalClosedPiper J3C · New Ellenton, SCNTSB MIA74FLG08Accident · No injuriesClosedPiper J3C-65 · Ulmers, SCNTSB MIA73FLG06Accident · No injuriesClosedPiper J3C · Cades, SCNTSB MIA72FLG14Accident · No injuriesClosedPiper J3C-65 · Clio, SCNTSB MIA71FLG08Accident · No injuriesClosedPiper J3C-65 · Hartsville, SCNTSB MIA70DLG13Accident · No injuriesClosedPiper J3C · Conway, SCNTSB MIA67A0118Accident · 2 fatalClosedPiper J3-90 · Lake City, SCNTSB MIA67D0143Accident · No injuriesClosedPiper J-3 · Newberry, SCNTSB MIA66F0441Accident · Minor injuriesClosedPiper J3C · Columbia, SCNTSB MIA66D0361Accident · No injuriesClosedPiper J3C-65 · St George, SCNTSB MIA66D0318Accident · No injuriesClosedPiper J3C-65 · Monetta, SCNTSB MIA65F0016Accident · No injuriesClosedPiper J3C · New Ellenton, SC