Skip to content

NTSB investigations: Piper PA-22-108, CA

34 cases on aircraft the registry lists as Piper PA-22-108. 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 ('7102204')) 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 ('7102204'))
  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 ('7102204'))
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 WPR11LA318Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frazier Park, CAThe pilot’s geographic disorientation, which resulted in an off-airport precautionary landing in soft terrain and a subsequent nose over.Jul 8, 2011 · N4901Z · Substantial damage NTSB LAX05LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Big Pine, CAoil exhaustion due to an improper oil breather tube installation, which became plugged in flight due to frozen moisture build-up. The blocked breather tube then created a crankcase over pressure that caused a failure of the crankshaft seal. The rough, uneven…Nov 28, 2004 · N4913Z · Substantial damage NTSB LAX02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Tehachapi, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in an attempt to gain altitude, which resulted in an inadvertent stall/mush. The high density altitude was a factor in the accident.Jan 11, 2002 · N4895Z · Substantial damage NTSB LAX99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hayward, CAThe pilot-in-command's failure to maintain directional control. A factor in this accident was the inadvertent ground loop swerve.Jan 2, 1999 · N4556Z · Destroyed NTSB LAX91FA022Accident · 3 fatalField investigationFinal reportPiper PA-22-108 · Oceanside, CAThe pilot initiating an instrument flight without operating air/ground communications equipment, and his failure to maintain adequate terrain clearance after apparently deciding to return to the airport. Factors contributing to the accident were inoperative…Oct 29, 1990 · N5052Z · Destroyed NTSB LAX86LA349Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · El Monte, CAThe aircraft rolled to the right as the student pilot and his instructor neared the runway. The instructor took the controls and the acft continued the right turn. The acft impacted storage buildings approximately 300 feet to the right of the rwy. A business…Sep 14, 1986 · N5066Z · Substantial damage NTSB LAX83LA352Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Mammoth Lakes, CAThe acft collided with trees while trying to maneuver through a mountain pass at 13000 ft MSL with the temperature at 82DEGREES. The plt stated that the acft started a high sink rate. He checked the throttle, mags and mixture but was forcedto settle into the…Jul 22, 1983 · N5737Z · Destroyed NTSB LAX80FA056Accident · 2 fatalClosedPiper PA-22 · Oxnard, CAFeb 21, 1980 · N4685Z · Destroyed NTSB LAX80FUM11Accident · Minor injuriesClosedPiper PA-22 · Ocotillo Well, CAFeb 10, 1980 · N4659Z · Substantial damage NTSB LAX77FA071Accident · 1 fatalClosedPiper PA-22 · Malibu, CASep 9, 1977 · N75FC · Destroyed NTSB LAX75DUG28Accident · No injuriesClosedPiper PA-22 · Chino, CADec 14, 1975 · N5806Z · Substantial damage NTSB LAX76DUG06Accident · No injuriesClosedPiper PA-22 · Big Bear, CAJul 6, 1975 · N5107Z · Substantial damage NTSB OAK74DVD39Accident · No injuriesClosedPiper PA-22 · Hayward, CAJun 22, 1974 · N5870Z · Destroyed NTSB OAK73DVA37Accident · No injuriesClosedPiper PA-22 · Visalia, CAJan 25, 1973 · N5052Z · Substantial damage NTSB LAX72AL020Accident · 3 fatalClosedPiper PA-22 · W.Los Angls, CASep 9, 1971 · N4928Z · 2 aircraft · Destroyed NTSB LAX71AL072Accident · 1 fatalClosedPiper PA-22 · Escondido, CAJun 5, 1971 · N4887Z · Destroyed NTSB LAX71DUM40Accident · No injuriesClosedPiper PA-22 · Jacumba, CAMay 14, 1971 · N5344Z · Substantial damage NTSB OAK68D0378Accident · No injuriesClosedPiper PA-22 · Haward, CAApr 20, 1968 · N5350Z · Substantial damage NTSB OAK68D0314Accident · No injuriesClosedPiper PA-22 · Travis Afb, CADec 21, 1967 · N4901Z · Substantial damage NTSB OAK67D0243Accident · Minor injuriesClosedPiper PA-22 · Clearlake, CAFeb 19, 1967 · N4996Z · Substantial damage NTSB OAK67D0139Accident · Minor injuriesClosedPiper PA-22 · Chowchilla, CAOct 2, 1966 · N5066Z · Substantial damage NTSB LAX67D0034Accident · No injuriesClosedPiper PA-22 · Hesperia, CAJun 29, 1966 · N5527Z · Substantial damage NTSB OAK67F0040Accident · No injuriesClosedPiper PA-22 · Vacaville, CAJun 28, 1966 · N5134Z · 2 aircraft · Substantial damage NTSB OAK67F0026Accident · Minor injuriesClosedPiper PA-22 · Sonoma, CAJun 11, 1966 · N5536Z · Substantial damage NTSB LAX66A0084Accident · 1 fatalClosedPiper PA-22 · Costa Mesa, CAMay 7, 1966 · N5196Z · Substantial damage NTSB LAX66D0236Accident · Minor injuriesClosedPiper PA-22 · Chino, CAJan 16, 1966 · N4962Z · Substantial damage NTSB OAK66F0181Accident · No injuriesClosedCessna 150D · Lincoln, CADec 18, 1965 · N4316U · 2 aircraft · Substantial damage NTSB OAK65F0050Accident · Minor injuriesClosedPiper PA-22 · Sacramento, CAMar 23, 1965 · N5411Z · Destroyed NTSB LAX65A0066Accident · 1 fatalClosedPiper PA-22 · Orcutt, CAFeb 12, 1965 · N5097Z · Destroyed NTSB UNK65X0989Accident · Minor injuriesClosedPiper PA-22 · Blythe, CADec 12, 1964 · N5861Z · Substantial damage NTSB UNK64X1723Accident · No injuriesClosedPiper PA22 · Santa Barbara, CAMay 11, 1964 · N5158Z · Substantial damage NTSB UNK64X1424Accident · No injuriesClosedPiper PA22 · San Francisco, CAApr 23, 1964 · N5350Z · Substantial damage NTSB UNK64X0647Accident · No injuriesClosedPiper PA22 · Santa Susan, CAFeb 22, 1964 · N4616Z · Substantial damage NTSB UNK64X0547Accident · No injuriesClosedPiper PA22 · 29 Palms, CAFeb 12, 1964 · N4974Z · Substantial damage