NTSB investigations: Piper J3C-65, CO
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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1972 | 2 |
| 1974 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2004 | 1 |
| 2009 | 1 |
| 2015 | 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\" = 'CO' 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" = 'CO' 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 GAA16CA058Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot of the following airplane failed to maintain adequate spacing during the taxi to the runway, resulting in a collision with the lead airplane.NTSB CEN09CA249Accident · No injuriesData collectionFinal reportPiper J3C · Montrose, COThe pilot's failure to maintain directional control during the takeoff roll.NTSB DEN05LA035Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Monte Vista, COthe pilot's failure to maintain adequate airspeed which resulted in a stall during low level flight.NTSB DEN99LA069Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Fort Collins, COThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.NTSB FTW97LA298Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Castle Rock, COA partial loss of engine power due to a cylinder exhaust valve jammed in the open position from excessive carbon deposits. A factor was the lack of suitable terrain on which to make a forced landing.NTSB FTW95LA312Accident · No injuriesLimited investigationFinal reportPiper J3C · Englewood, COA partial power loss due to a stuck number four exhaust valve. A factor was the lack of suitable terrain for a forced landing.NTSB DEN93LA088Accident · Serious injuriesLimited investigationFinal reportPiper J3C-90 · Meeker, COFailure of the pilot to maintain adequate terrain clearance. A factor was the intentional low pass performed by the pilot in command.NTSB DEN84LA018Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Parker, CODuring the takeoff portion of a touch & go, the eng went to idle 15 ft AGL. The plt made a left turn & landed in a fieldcollapsing the landing gear. Investigation of the wreckage revealed that the carburetor was hanging in place by the throttle & mixture…NTSB DEN82DA185Accident · Serious injuriesFinal reportPiper J-3 C65 · Durango, COThe pilot reported that he took off with the doors latched open, and after lift-off, the aircraft failed to exceed 42 mph. He reported that an altitude of about 150 ft was attained. Due to the lack of performance and fearful of obstructions ahead, the pilot…NTSB DEN74DTE75Accident · No injuriesClosedPiper J-3 · Delta, CONTSB DEN73DTE21Accident · No injuriesClosedPiper PA-25 · Eckley, CONTSB DEN73FTE13Accident · Serious injuriesClosedPiper J3C-65 · Berthoud, CONTSB DEN70D0114Accident · No injuriesClosedPiper J3C-65 · Denver, CONTSB DEN70D0020Accident · Minor injuriesClosedPiper J3C-65 · Aurora, CONTSB DEN68D0236Accident · No injuriesClosedCessna 150 · Greeley, CONTSB DEN67D0105Accident · Serious injuriesClosedPiper J-3 · Center, CONTSB UNK64X2991Accident · No injuriesClosedPiper PA30 · Longmont, CO