NTSB investigations: Piper PA-22-150
1,313 cases on aircraft the registry lists as Piper PA-22-150. 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 ('7102210'))
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 ('7102210'))
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 CHI83LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Romeoville, ILThe pilot flew over the airport at night, saw the runway lights and entered the traffic pattern for landing. On final approach, he saw a rotating beacon and thought an aircraft was holding short of the runway. As he continued on final, he saw that the beacon…NTSB MKC82DA167Accident · Minor injuriesFinal reportPiper PA-22-150 · Higginsville, MOWhile attempting a power-off landing at a private airstrip, the pilot added power for a go-around. The engine sputtered, lost power and the pilot made a forced landing in a terraced area. The nose gear collapsed and the aircraft nosed over. Water was found in…NTSB FTW82FQG20Accident · Serious injuriesFinal reportPiper PA-22-150 · Clovis, NMThe eng quit immediately after takeoff & the acft flipped over during a forced landing in a plowed field. A 4 inch piece of gasket that was installed between the carburetor air filter & carburetor air box had come loose & was found lodged in the carburetor…NTSB ANC82DA072Accident · Serious injuriesFinal reportPiper PA-22 · Icy Bay, AKWhile on a cross country flight, the pilot landed on a small lake to add fuel to the aircraft from cans carried in the aircraft. After departing the lake he encountered weather and attempted to transition to instrument flight when a hole he was using to climb…NTSB ATL82DA177Accident · Minor injuriesFinal reportPiper PA-22-150 · Hixson, TNThe pilot elected to takeoff on a dark night without runway lights. He stated that the runway lights were not available at the time since the operator was out of town. According to the pilot and other witnesses, at least part of the airport environment was…NTSB ATL82DA148Accident · No injuriesFinal reportPiper PA-22-150 · Williamston, NCThe pilot stated that while cruising at 11,000 ft the engine started missing and losing power. After repeated attempts to restore power the pilot landed in a field. During roll out the nose wheel became lodged in soft sand and the aircraft turned over. Engine…NTSB NYC82DA102Accident · Minor injuriesFinal reportPiper PA-22-150 · Seneca Falls, NYWhile trying to roll out of a left turn on downwind the pilot experienced a jammed rudder control. Full aileron control was not available because of the aileron-rudder interconnect system and a considerable buffet was induced during an attempt to level the…NTSB CHI82DA167Accident · No injuriesFinal reportPiper PA-22-150 · Harrison, MIDuring takeoff the pilot failed to clear a chain link fence. The aircraft collided with a ditch and the left main landing gear collapsed.NTSB CHI82DA142Accident · No injuriesFinal reportPiper PA-22-150 · Lancaster, OHThe pilot was practicing takeoffs and landings on runway 10. On the second landing the aircraft bounced and drifted. The aircraft touched down on the runway a second time collapsing the nose gear. The wind was reported as 010 degrees at 13 KTS. Gusts to 15…NTSB MKC82DCJ01Accident · Serious injuriesFinal reportPiper PA-22-150 · Alliance, NEAfter landing and dropping off one passenger the pilot attempted to takeoff. The airport manager stated that due to the unusually warm weather the frost was out of the ground and the runway had many gopher mounds which were very soft. He further stated that…NTSB DEN82DA027Accident · No injuriesFinal reportPiper PA-22 · Trinidad, COThe pilot reported that the aircraft started to veer left as the tail came up during the takeoff roll. He corrected with rudder, but did not maintain directional control. As a ground loop developed, he noted there was insufficient airspeed to lift off and…NTSB CHI82DEX02Accident · No injuriesClosedPiper PA-22 · Anderson, INNTSB FTW82DPJ03Accident · No injuriesClosedPiper PA-22 · Seiling, OKNTSB CHI82FEC05Accident · Serious injuriesClosedPiper PA-22 · Howell, MINTSB CHI82DER02Accident · No injuriesClosedPiper PA-22 · Austin, MNNTSB LAX81DXQ35Accident · Serious injuriesClosedPiper PA-22 · Jackpot, NVNTSB MIA81DLD62Accident · Minor injuriesClosedPiper PA-22 · Captiva, FLNTSB CHI81FEI21Accident · No injuriesClosedPiper PA-22 · North Canton, OHNTSB ATL81DKG32Accident · Serious injuriesClosedPiper PA-22 · Griffin, GANTSB MKC81DCQ45Accident · No injuriesClosedPiper PA-22 · Moran, KSNTSB LAX81FVG40Accident · Minor injuriesClosedPiper PA-22 · Weaverville, CANTSB ATL81FA080Accident · 1 fatalClosedPiper PA-22 · Chapel Hill, NCNTSB SEA81FYK08Accident · Minor injuriesClosedPiper PA-22 · Medford, ORNTSB ATL81FKW18Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNNTSB MKC81FCG24Accident · No injuriesClosedPiper PA-22 · Bethany, MONTSB FTW81DPG12Accident · Serious injuriesClosedPiper PA-22 · Rogers, ARNTSB CHI81FEM06Accident · No injuriesClosedPiper PA-20 · Newaygo, MINTSB ANC81DAG18Accident · No injuriesClosedPiper PA-22 · Kenai, AKNTSB FTW81FA019Accident · 1 fatalClosedPiper PA-22 · Oklahoma City, OKNTSB MKC81FCG15Accident · No injuriesClosedPiper PA-22 · Independence, MONTSB ANC81DAG04Accident · Minor injuriesClosedPiper PA-22 · Tulakes, AKNTSB SEA81FYP01Accident · Serious injuriesClosedPiper PA-22 · Waterville, WANTSB CHI80FEP54Accident · Minor injuriesClosedPiper PA-22 · Howard, WINTSB CHI80FEI37Accident · Serious injuriesClosedPiper PA-22 · Shelby, OHNTSB LAX80FXQ32Accident · No injuriesClosedPiper PA-22 · Carson City, NVNTSB CHI80FEC24Accident · No injuriesClosedPiper PA-22 · Troy, MINTSB SEA80DYE38Accident · Minor injuriesClosedPiper PA-22 · Silverdale, WANTSB FTW80FRG52Accident · No injuriesClosedPiper PA-22 · Pipecreek, TXNTSB NYC80FHA20Accident · No injuriesClosedPiper PA-22 · Hallstead, PANTSB IAD80FID17CaseClosedPiper PA-22 · Easterville, VANTSB MKC80FCJ10Accident · No injuriesClosedPiper PA-22 · Lincoln, NENTSB ANC80FAA10Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKNTSB IAD80DID13Accident · No injuriesClosedPiper PA-22 · Tye River, VANTSB LAX80DVD20Accident · No injuriesClosedPiper PA-22 · Novato, CANTSB MIA80FKG21Accident · Minor injuriesClosedPiper PA-22 · Register, GANTSB LAX80DUJ35Accident · No injuriesClosedPiper PA-22 · Phoenix, AZNTSB IAD80FA024Accident · 1 fatalClosedPiper PA-22 · Clear Spring, MDNTSB LAX80FUA06Accident · No injuriesClosedPiper PA-22 · Dana Point, CANTSB CHI80DEM10Accident · Minor injuriesClosedPiper PA-20 · Ithaca, MINTSB SEA80FTA05Accident · No injuriesClosedPiper PA-22 · Laurel, MT