NTSB investigations: Piper J3C-65
18 cases on aircraft the registry lists as Piper J3C-65, where the first occurrence was “On ground/water collision with object”. 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
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100510')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7100510')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
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 MIA07CA097Accident · Minor injuriesData collectionFinal reportPiper J3-C-65 · Byron, GAThe pilots failure to maintain directional control of the airplane during takeoff.NTSB FTW02LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Paris, TXthe failure of the pilot of the other aircraft to maintain adequate visual lookout during taxi.NTSB SEA01LA065Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Seattle, WAThe pilot's failure to visually detect the barricade, resulting in a collision with the barricade. Factors included the barricade, and inadequate information on the ATIS broadcast.NTSB MIA00LA230Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · New Smyrna Bch., FLthe pilot's failure to maintain control of the airplane during the landing roll. Factors in this accident were; a crosswind, and the pilot lack of experience in this kind of aircraft.NTSB SEA99LA055Accident · No injuriesLimited investigationFinal reportPiper J-3 · Vancouver, WAThe failure of the pilot of the other aircraft to maintain clearance from the pilot's stationary aircraft.NTSB CHI98LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Mankato, MNthe pilot's inadequate compensation for the wind conditions and not maintaining proper alignment. Factors contributing to the accident were the snow covered terrain and the lack of depth perception it produced.NTSB CHI96LA078Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Mount Horeb, WIfailure of the pilot to see-and-avoid the pedestrian. Factors relating to the accident were: the pilot's inadequate preflight preparation, his landing on a closed airstrip, and the snow covered terrain.NTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.NTSB MIA94LA138Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Belleair, FLImproper maintenance inspection of the crankcase breather tube resulting in failure to detect blockage of the tube.NTSB NYC92LA132Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ocean City, MDThe pilot's inadequate visual look out for objects while taxing.NTSB BFO91LA051Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar STP1 · Quinton, VAThe pilot's failure to maintain adequate clearance from a moving aircraft.NTSB MIA85LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · St.Petersburg, FLThe acft collided with a parked acft while taxiing in from landing. The plt complained after the accident that the parked acft were too close to the taxiway. The tailwheel equipped acft had been engaged in banner towing operations prior to the taxi accident.NTSB FTW85LA023Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kilgore, TXAfter taxiing north to the end of the strip a 180 deg turn was made prior to takeoff to the south. Out of the turn the acft was lined up with the left wing tip close to the fence. The plt intended to correct his line-up during the roll. According to the plt,…NTSB LAX84LA145Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Lompoc, CADuring taxi from landing N42077 taxied into N6592B which had pulled to the right side of the taxiway and stopped to avoid the on-coming acft. The plt of N42077 stated to an FAA inspector that he 'used poor judgement in taxiing.'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 NYC83IA013Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Augusta, METhe student and flight instructor (CFI) of Cessna 172, N5742T, started to taxi while the student and CFI of Piper JC3-65, N25973, were landing. The Cessna aircrew saw the Piper land and turn off onto the same taxiway that they were on, but from the opposite…NTSB FTW82FPD10Accident · No injuriesFinal reportPiper J3C-65 · Grand Prairie, TXWhile the pilot was taxiing to the engine run-up area, his right wing struck the propeller of a Piper PA-24 (N7545P) that was positioned at the edge of the taxiway. The pilot believed that if he had been making sharper s-turns while taxiing, he would have…NTSB NYC82IA058Incident · No injuriesIncident investigationFinal reportPiper J3C-65 · Bayport, NYThe pilot taxied into the parking area and stopped in a position that was facing Cessna 172, N7909G. The pilot of N40627, while sitting in the aft seat, reached forward and accidently caught his coat sleeve on the throttle. The throttle was pushed forward.…