Skip to content

NTSB investigations: Piper PA-22-135, CA

43 cases on aircraft the registry lists as Piper PA-22-135. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'CA' 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 ('7102206')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'CA' 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 ('7102206'))
  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" = 'CA' 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 ('7102206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR15FA174Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Livermore, CAA loss of control for reasons that could not be determined, because examination of the airframe and engine revealed no anomalies that would have precluded normal operation.Jun 2, 2015 · N1348C · Destroyed NTSB LAX08CA061Accident · No injuriesData collectionFinal reportPiper PA-22 · El Cajon, CAThe failure of both pilots to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.Feb 17, 2008 · N3316A · Substantial damage NTSB LAX02LA197Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Brownsville, CAa loss of engine power for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed during a turn to reverse course back to the runway, resulting in a stall and collision with terrain.Jun 14, 2002 · N3329B · Destroyed NTSB LAX99LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Novato, CAThe failure of the pilot to adequately compensate for the wind conditions and to maintain directional control of the aircraft while landing. A factor is the airport's failure to follow proper procedure in ensuring adequate obstacle and object free clearance…Mar 31, 1999 · N1244C · Substantial damage NTSB LAX96LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Davis, CAthe pilot's failure to maintain directional control during the takeoff roll by diverting his attention.Oct 31, 1995 · N3562A · Substantial damage NTSB LAX91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe failure of the CFI aboard N25378 to adequately supervise the flight and the dual student pilot's improper use of the normal brakes.Mar 3, 1991 · N25378 · 2 aircraft · Minor damage NTSB LAX84LA477Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Byron, CADuring takeoff, the eng lost power as the acft was climbing between 400 & 600 ft. subsequently, the right gear collapsed when the acft was landed on rolling terrain. The plt estimated there was about 2 gal of fuel on board.Sep 1, 1984 · N77G · Substantial damage NTSB LAX83LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Jackson, CAThe acft went off the rwy and collided with a ditch during landing. The tailwheel acft touched down on rwy 19 about 200 ft past the threshold and bounced. The pilot applied power to recover and lost control of the acft. The acft veered off the rwy to the…Jun 22, 1983 · N1526P · Substantial damage NTSB OAK78FVG71Accident · No injuriesClosedPiper PA-22 · Fair Oaks, CAAug 5, 1978 · N3562A · Substantial damage NTSB LAX78FUM19Accident · Minor injuriesClosedPiper PA-22 · Santee, CAApr 16, 1978 · N8682C · Substantial damage NTSB LAX78FA019Accident · 3 fatalClosedPiper PA-22 · Devore, CAJan 4, 1978 · N1511P · Destroyed NTSB LAX77FVM24Accident · No injuriesClosedPiper PA-22 · S.Luis Obispo, CAAug 19, 1977 · N2278A · Substantial damage NTSB LAX77FUQ02Accident · No injuriesClosedPiper PA-22 · Lancaster, CAOct 17, 1976 · N8625C · Substantial damage NTSB OAK76DVG46Accident · No injuriesClosedPiper PA-22 · Auburn, CAFeb 28, 1976 · N3780A · Substantial damage NTSB LAX75DUQ26Accident · No injuriesClosedPiper PA-22 · Castaic, CAApr 23, 1975 · N1228C · Substantial damage NTSB LAX75DUM13Accident · Minor injuriesClosedPiper PA-22 · Julian, CAJan 6, 1975 · N1327C · Substantial damage NTSB LAX74FUA24Accident · No injuriesClosedPiper PA-22 · Long Beach, CAJun 23, 1974 · N3523A · Substantial damage NTSB LAX74FUD05Accident · No injuriesClosedPiper PA-22 · Compton, CAMar 8, 1974 · N1542P · Substantial damage NTSB OAK74AP023Accident · 2 fatalClosedPiper PA-22 · Concord, CADec 19, 1973 · N8245C · Destroyed NTSB OAK74AP014Accident · 2 fatalClosedPiper PA-22 · Millville, CASep 29, 1973 · N8974C · Destroyed NTSB LAX74DUG08Accident · No injuriesClosedPiper PA-28 · Joshua Tree, CAJul 8, 1973 · N8692C · Substantial damage NTSB OAK73FVA22Accident · No injuriesClosedPiper PA-22 · Riverdale, CAOct 1, 1972 · N2540A · Substantial damage NTSB LAX73DUQ08Accident · Minor injuriesClosedPiper PA-22 · Van Nuys, CAAug 27, 1972 · N8730C · Substantial damage NTSB LAX72DUQ45Accident · No injuriesClosedPiper PA-22 · Lancaster, CANov 16, 1971 · N2241A · Substantial damage NTSB LAX71FUQ79Accident · No injuriesClosedPiper PA-22 · Quartz Hill, CAMay 9, 1971 · N3616A · Substantial damage NTSB LAX69D0353Accident · No injuriesClosedPiper PA-22 · Temecula, CAMay 27, 1969 · N8697C · Substantial damage NTSB OAK69D0214Accident · No injuriesClosedPiper PA-22 · Ukiah, CANov 27, 1968 · N1610P · Substantial damage NTSB LAX69D0081Accident · No injuriesClosedPiper PA-22 · Fontana, CAAug 9, 1968 · N1161C · Substantial damage NTSB OAK68D0332Accident · No injuriesClosedPiper PA-22 · Eureka, CAMar 10, 1968 · N1348C · Substantial damage NTSB LAX68D0315Accident · No injuriesClosedPiper PA-22 · Thermal, CAJan 27, 1968 · N8697C · Substantial damage NTSB LAX68D0227Accident · No injuriesClosedPiper PA-22 · Santee, CADec 6, 1967 · N1540P · Substantial damage NTSB LAX68A0035Accident · 2 fatalClosedPiper PA-22 · Carpinteria, CASep 24, 1967 · N1439C · Destroyed NTSB LAX68D0168Accident · Minor injuriesClosedPiper PA-22 · Needles, CASep 23, 1967 · N1521P · Substantial damage NTSB OAK68A0026Accident · 2 fatalClosedPiper PA-22 · Crescent City, CASep 7, 1967 · N3621A · Destroyed NTSB LAX67D0434Accident · Minor injuriesClosedPiper PA-22 · Laverne, CAMay 3, 1967 · N1311C · Substantial damage NTSB OAK67D0274Accident · No injuriesClosedPiper PA-22 · Rch Cordova, CAApr 22, 1967 · N3308B · Substantial damage NTSB OAK67D0073Accident · No injuriesClosedPiper PA-22 · Sonoma, CAAug 1, 1966 · N1244C · Substantial damage NTSB LAX66D0173Accident · No injuriesClosedPiper PA-22 · Fullerton, CAOct 24, 1965 · N2476A · Substantial damage NTSB OAK66F0077Accident · No injuriesClosedPiper PA-22 · Sacramento, CASep 16, 1965 · N3268B · Substantial damage NTSB OAK65D0074Accident · No injuriesClosedPiper PA-22 · Fair Oaks, CAMay 15, 1965 · N3311B · Substantial damage NTSB UNK65X1091Accident · No injuriesClosedPiper PA-22 · Palm Springs, CADec 22, 1964 · N2678A · Destroyed NTSB UNK64X2350Accident · No injuriesClosedPiper PA22 · Natl City, CAJun 18, 1964 · N1327C · Substantial damage NTSB UNK64X1331Accident · Serious injuriesClosedPiper PA22 · Blythe, CAApr 15, 1964 · N3559A · Destroyed