NTSB investigations: Piper J3C-65, LA
29 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 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1968 | 3 |
| 1969 | 3 |
| 1970 | 1 |
| 1971 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 4 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 2 |
| 1987 | 1 |
| 1990 | 1 |
| 2021 | 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\" = 'LA' 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" = 'LA' 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 CEN21LA204Accident · 1 fatalClass 3 · LimitedFinal reportPiper J3C-65 · Slaughter, LAA total loss of engine power for reasons that could not be determined from the available evidence.NTSB FTW91DRD02Accident · 2 fatalFinal reportPiper PA-J3C-65 · Mer Rouge, LAAn inadvertent stall at an altitude too low to allow for recovery.NTSB FTW87FA223Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenwood, LAThe pilot touched down briefly in a small clearing which he had prevously driven to by automobile. He then lifted off and started a climbout. Two separate electrical power lines were located just inside a tree line which was very close to the previously…NTSB FTW85LA200Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Sulphur, LAThe pilot stated he had taken off to the south into the wind. He made a turn to the west to clear trees. At about 150 feet the aircrafts climb ability deteriorated so he turned back into the wind but the nose dropped stalled and the aircraft entered a spin.…NTSB FTW85FA094Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Ferriday, LAAcft was observed in slow flt aprx 40 ft AGL just above stall speed with the eng operating smoothly. The acft then stalled and impacted in an aprx 90 deg nose down attitude. The plt was flying from the front seat. The acft was not equipped with shoulder…NTSB FTW82DRJ05Accident · Minor injuriesClosedPiper JC3-65 · Oil City, LANTSB FTW80DRJ38Accident · No injuriesClosedPiper J-3 · Tallulah, LANTSB FTW79DRJ11Accident · Minor injuriesClosedPiper J-3 · Monterey, LANTSB FTW78FRD49Accident · Serious injuriesClosedPiper J-3 · Welsh, LANTSB FTW78FRJ08Accident · 1 fatalClosedPiper J-3 · Farmerville, LANTSB FTW78DRJ06Accident · No injuriesClosedPiper J3C · Pineville, LANTSB FTW78DRD06Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LANTSB FTW77FRD42Accident · Serious injuriesClosedPiper J3-C65 · Beaux Bridge, LANTSB FTW76DRD62Accident · Minor injuriesClosedPiper J-3 · Lake Charles, LANTSB FTW76FRD20Accident · No injuriesClosedPiper J3C-65 · Melville, LANTSB FTW75FRD19Accident · No injuriesClosedPiper J3C-65 · Baton Rouge, LANTSB FTW71DRD32Accident · Minor injuriesClosedPiper J3 · Easter, LANTSB FTW71AF013Accident · 2 fatalClosedPiper J3C-65 · Newellton, LANTSB FTW70F0306Accident · Serious injuriesClosedPiper J-3 · Esterwood, LANTSB FTW69A0087Accident · 2 fatalClosedPiper J3C-65 · Gurley, LANTSB FTW69A0062Accident · 2 fatalClosedPiper J3C-65 · Tallulah, LANTSB FTW69F0034Accident · Serious injuriesClosedPiper J3C-65 · Gueydan, LANTSB FTW68D0596Accident · Minor injuriesClosedPiper J3 · Andrews, LANTSB FTW68D0456Accident · No injuriesClosedPiper J-3 · Ruston, LANTSB FTW67A0039Accident · 1 fatalClosedPiper J-3 · Kaplan, LANTSB FTW66F0674Accident · No injuriesClosedPiper J3C-65 · Crowville, LANTSB FTW66F0145Accident · No injuriesClosedPiper J3C · Washington, LANTSB UNK64X2253Accident · 1 fatalClosedPiper J3C · Dequincy, LANTSB UNK64X2060Accident · No injuriesClosedPiper J3 · Abbeville, LA