NTSB investigations: Piper J3C-65, AZ
18 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 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1978 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2008 | 1 |
| 2014 | 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\" = 'AZ' 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" = 'AZ' 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 WPR14CA202Accident · No injuriesData collectionFinal reportPiper J3C 65 · Tucson, AZThe pilot's failure to maintain directional control during the landing roll.NTSB SEA08CA109Accident · No injuriesData collectionFinal reportPiper J3C-65 · Bisbee, AZThe pilot's failure to obtain/maintain sufficient airspeed after takeoff, which resulted in a stall/mush condition.NTSB ANC04FA016Accident · 4 fatalField investigationFinal reportPiper J3C-65 · Peoria, AZThe inadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft and a subsequent midair collision. A factor associated with the accident was the airplane pilot's failure to determine that…NTSB LAX98LA181Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Mesa, AZFailure of a weld in the engine's throttle control support assembly due to inadequate maintenance which was the ultimate responsibility of the owner-pilot. Contributing factors were the presence of rough terrain, the lack of a suitable forced landing site,…NTSB LAX97FA259Accident · 2 fatalField investigationFinal reportPiper J3C-85 · Bullhead City, AZimproper judgement of the pilot by intentionally performing low level maneuvers, and his misjudgment of a level-off over water.NTSB LAX93LA162Accident · No injuriesLimited investigationFinal reportPiper J3 · Buckeye, AZThe pilot's inadequate visual look-out and failure to maintain clearance from the wires. Lack of experience in the geographical (airport) area was a factor.NTSB LAX92T#A02Accident · No injuriesClass 3Final reportPiper J3 · San Carlos, AZNTSB LAX90LA342Accident · No injuriesLimited investigationFinal reportPiper J-3C-115 · Wickenburg, AZThe pilot's failure to maintain directional control.NTSB LAX87LA269Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Buckeye, AZThe acdnt occurred as the plt was maneuvering to land on a pvt airstrip located on a ranch. He rprtd that while in a right turn toward the rwy, the acft stalled & fell to the ground. No preimpact mechanical failure or malfunction was evident.NTSB LAX85LA405Accident · 2 fatalLimited investigationFinal reportPiper J3 C-65 · Grand Canyon, AZAfter departing pierce ferry, AZ the plt and his passenger flew east, up the Colorado river, at a low level towards kanab point. The plt's notes and charts show that the flt was to turn north for aprx 40 NM, with a refueling stop at kanab, UT. The bright…NTSB LAX83LA281Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Tuba City, AZThe pilot had landed in a river bed due to an encounter with and downdrafts while flying in canyons. Then a storm and flash flood threatened so he decided to takeoff. During takeoff roll a wing struck river rocks.NTSB LAX78DUJ84Accident · No injuriesClosedPiper J-3C · Ganado, AZNTSB LAX78DUJ83Accident · No injuriesClosedPiper J-3 · Wenden, AZNTSB LAX72DUJ58Accident · Minor injuriesClosedPiper J3C-65 · Pearce, AZNTSB LAX68D0355Accident · No injuriesClosedPiper J3C-65 · Tucson, AZNTSB LAX67D0415Accident · No injuriesClosedPiper J3C-65 · Scottsdale, AZNTSB UNK64X4147Accident · No injuriesClosedPiper J3 · Herford, AZNTSB UNK64X1332Accident · No injuriesClosedPiper J3C · Tolleson, AZ