NTSB investigations: Piper PA-22-135
461 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.
Cases, newest first
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 ('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."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" 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 FTW87LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Tulsa, OKDrg the initial climb after takeoff, the acft's eng lost pwr. The plt landed the acft on a median in a residential & shopping area, where it nosed over. An exam & an opnl check of the eng revealed no reason for the loss of pwr.NTSB ANC86LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Chugiak, AKWhile flying in the mountains at about 5000 feet MSL (200 feet AGL), the airplane encountered a downdraft, causing it to crash on a glacier. Pilot estimated the winds to be about 10 knots.NTSB ANC85LA143Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Mccarthy, AKThe plt stated that while executing a 180 deg right turn the acft drifted 50 ft to the east of rwy 19 where it struck a row of trees. The acft continued in a steep descending turn. The acft stalled and crashed into a wooded area.NTSB ANC84LA155Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe acft ran off the rwy during landing. The plt said he lost control of the acft and went on the grass for about 40 ft. the rear seat had been removed for cargo. A 6 year old boy in the back of the acft was seated on top of rope and cans ofgas at the time of…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.NTSB NYC84LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Canton, PAThe pilot performed a runup prior to departure. He used one notch of flaps and approximately 800 feet of runway to break ground. During the climbout at approximately 200 ft the engine 'started skipping then quit.' The pilot was unable to restore power before…NTSB ANC84LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Big Delta, AKThe plt switched the tank selector while cruising in flt and the engine quit. He said he then primed the engine and tried to start it, but failed. A forced landing was made & the acft nosed over. After the accident, the acft was righted, the tank selector was…NTSB MKC84LA140Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Dubuque, IAWhile manuevering over a university a ttl loss of pwr was experienced. Attempts to restart the engine failed. The plt made a hard forced landing which resulted in substantial damage. Inspection of the engine did not reveal any mechanical failure/malfunction.NTSB ATL84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wilmington, NCWhile the plt was taxiing after landing, one wheel of the acft mired in a soft spot. The acft then veered into softer terrain & nosed over.NTSB MIA83LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Okeechobee, FLThe non-rated plt stated that the eng lost power while he was flying over lake Okeechobee. He was unable to restart the eng & subsequently ditched the acft in the lake. After recovery, the eng was inspected, but no preimpact, mechanical failure was evident.NTSB CHI83LA352Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Pittsfield, ILThe student plt was on a personal flt with a passenger on board. During arrival, he landed on rwy 25 (1700 ft long) with a x-wind from 160 deg at 8 KTS. He reported that the landing was made on his 2nd attempt, but he did not get on the ground soon enough to…NTSB CHI83FA291Accident · 2 fatalField investigationFinal reportPiper PA-22 · Rogers, OHThe acft collided with trees immediately after takeoff. The acft was 20 lbs under max gross weight. Density alt was 2,500 ft.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…NTSB NYC83LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Olean, NYThe acft nosed over during taxi after landing when the acft went off the runway into soft dirt. The student pilot had completed a cross-country flight without incident. After landing during taxi at Olean, NY the pilot applied brakes and the acft swerved to…NTSB CHI83LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Lisbon, OHDuring takeoff, the eng lost power when the acft was climbing thru aprx 150 ft AGL. The plt attempted to maneuver back to the airport. Reportedly, he had insufficient altitude to clear over 60 ft trees near the end of the rwy. There was extensive damage to…NTSB NYC83FHA03Accident · Serious injuriesFinal reportPiper PA-22-135 · New Hope, PAThe acft collided with a power line while the pilot and a friend in another plane were flying along the deleware river. The plt reported that as he approached a bridge, he climbed to clear over the bridge and some power lines, then started to descend. He…NTSB MIA83FA031Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Miramar, FLThe aircraft lost power after a touch and go landing and the pilot elected to land in a meadow. The aircraft collided with a ditch after 300 feet of ground roll and the pilot lost control. The aircraft cartwheeled and was destroyed. The pilot was fatally…NTSB SEA82DA148Accident · No injuriesFinal reportPiper PA-22-135 · Weiser, IDDuring a simulated forced landing, the instructor pilot took control of the aircraft at the go-around point. He followed the normal procedure for the go-around (full power) carb heat, etc), except that he continued the low approach to provide the student with…NTSB CHI82FEM05Accident · Serious injuriesClosedPiper PA-22 · Wayland, MINTSB NYC81FNE28Accident · No injuriesClosedPiper PA-22 · Gr Barrington, MANTSB CHI81FEC40Accident · No injuriesClosedPiper PA-22 · Lapeer, MINTSB MKC81FCA17Accident · No injuriesClosedPiper PA-22 · Washington, MONTSB NYC81FFJ12Accident · Minor injuriesClosedPiper PA-22 · Mayville, NYNTSB MKC81FA021Accident · 1 fatalClosedPiper PA-22 · Lohrville, IANTSB DEN81FTC03Accident · No injuriesClosedPiper PA-20 · Cody, WYNTSB FTW81FRJ02Accident · No injuriesClosedPiper PA-22 · Texarkana, TXNTSB SEA80FYM50Accident · Minor injuriesClosedPiper PA-22 · Dallas, ORNTSB ATL80FKQ07Accident · Minor injuriesClosedPiper PA-22 · Brookhaven, MSNTSB MKC80FER29Accident · No injuriesClosedPiper PA-22 · Floodwater, MNNTSB CHI80FA025Accident · 2 fatalClosedPiper PA-22 · Princeton, ILNTSB FTW80FRG20Accident · No injuriesClosedPiper PA-22 · Kingsville, TXNTSB MKC80DCD05Accident · No injuriesClosedPiper PA-22 · Des Moines, IANTSB CHI79FET33Accident · No injuriesClosedPiper PA-22 · Peru, INNTSB FTW79DPG80Accident · Minor injuriesClosedPiper PA-22 · Harrisburg, ARNTSB NYC79DNC79Accident · No injuriesClosedPiper PA-22 · Alexander, MENTSB IAD79FKW15Accident · Minor injuriesClosedPiper PA-22 · Dunlap, TNNTSB DEN79FTM14Accident · Minor injuriesClosedPiper PA-22 · Panguitch, UTNTSB SEA79DTI09Accident · No injuriesClosedPiper PA-22 · Turner, MTNTSB MIA79DLD26Accident · No injuriesClosedPiper PA-22 · Lakeland, FLNTSB SEA79DYP02Accident · No injuriesClosedPiper PA-22 · Nez Perce, IDNTSB CHI79FA009Accident · 4 fatalClosedPiper PA-22 · Tell City, INNTSB LAX78DUK03Accident · Serious injuriesClosedPiper PA-22 · Seligman, AZNTSB ANC78DAH09Accident · No injuriesClosedPiper PA-22 · Chelatna Lake, AKNTSB DEN78DQA52Accident · No injuriesClosedPiper PA-22 · Datil, NMNTSB OAK78FVG71Accident · No injuriesClosedPiper PA-22 · Fair Oaks, CANTSB CHI78FEP51Accident · No injuriesClosedPiper PA-22 · Milwaukee, WINTSB NYC78FNA34Accident · No injuriesClosedPiper PA-22 · Edgartown, MANTSB MKC78DCG34Accident · No injuriesClosedPiper PA-22 · Springfield, MONTSB MKC78DER42Accident · No injuriesClosedPiper PA-22 · Westbrook, MNNTSB LAX78FUM19Accident · Minor injuriesClosedPiper PA-22 · Santee, CA