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 LAX97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Madera, CAThe pilot's failure to maintain adequate clearance from obstructions and his inadequate visual outlook.NTSB ANC97LA025Accident · 3 fatalLimited investigationFinal reportPiper PA-22 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent failure to maintain control of the airplane. Factors associated with the accident are the pilot's inadequate weather evaluation, his becoming lost/disoriented, and…NTSB MIA97LA041Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Pensacola, FLfailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve and subsequent collapse of the nose gear. The crosswind was a related factor.NTSB ANC97LA006Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Kasilof, AKthe pilot's misjudgment of distance and altitude on final approach to land, which resulted in an undershoot and collision with a dirt bank before reaching the proper touchdown point. A factor related to the accident was: the proximity of the frozen dirt bank…NTSB ANC97LA003Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Port Ashton, AKThe pilot's inadequate compensation for the gusty crosswind conditions. Factors associated with the accident were the crosswind and wind gusts.NTSB CHI96LA355Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Jordan, MNthe pilot's failure to maintain directional control during the landing roll.NTSB CHI96LA276Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Flushing, MIfuel exhaustion caused by the failure of the pilot to select a fuel tank with fuel remaining.NTSB FTW96LA276Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · El Paso, TXloss of directional control due to the failure of the tailwheel lock. A factor was the crosswind.NTSB NYC96LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Chester, NHThe pilot's misjudged distance and altitude during final approach.NTSB ANC96LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cooper Landing, AKthe pilot's selection of unsuitable terrain for landing. Soft snow conditions were a factor in the accident.NTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.NTSB MIA96LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Quincy, FLThe pilot's inadequate compensation for wind conditions, while beginning a flare to land, which resulted in a loss of aircraft control and collision with the ground.NTSB BFO95LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · South Boston, VALoss of engine power for an undetermined reason. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB ANC95LA123Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Nikiski, AKThe pilot's selection of unsuitable terrain, and his delay in aborting the takeoff. The soft terrain and high grass were related factors.NTSB NYC95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Avoca, PAthe pilot's poor inflight decision and improper fuel management resulting in fuel exhaustion and a subsequent forced landing over rocky terrain.NTSB ANC95LA060Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Koliganek, AKThe pilot's failure to attain the proper approach and landing speed, not maintaining directional control, and his inadequate remedial action(s). A factor in the accident was the loose objects in the landing area.NTSB SEA95LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Rice, WAThe pilot's failure to maintain the proper climb rate. A factor was trees in the flight path.NTSB MIA95FA089Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Staley, NCThe pilot's failure to maintain airspeed (VSO) while maneuvering during a forced landing, resulting in an in-flight loss of control (inadvertent stall), and subsequent in flight collision with terrain. Contributing to the accident was the pilot's inadequate…NTSB SEA95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Forks, WAThe loss of power for undetermined reasons and the lack of suitable terrain for a successful forced landing.NTSB MIA95LA049Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tavares, FLThe failure of the no.3 connecting rod resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.NTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.NTSB ANC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Deadhorse, AKThe separation of the landing gear tube at the spindle due to corrosion. An inadequate annual inspection was a factor in the accident.NTSB LAX94LA297Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Murphy Springs, IDThe pilot's improper in-flight decision to maneuver in a canyon at such low altitude that he could not out climb the adjacent rising terrain.NTSB ANC94LA084Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Talkeetna, AKThe pilot misjudged clearance from a bush.NTSB FTW94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ravenna, TXThe pilot overshooting the landing and his failure to execute a G0-around. The wet grass was a factor.NTSB SEA94LA139Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Melba, IDThe pilot's inadequate remedial action, and his excessive brake application. Factors include improper recovery from a bounced landing, and a crosswind.NTSB NYC94LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Toronto, OHthe pilot's improper flare, which resulted in the nose gear collapsing and the subsequent nose over of the airplane.NTSB ANC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe failure of an exhaust valve. The lack of suitable terrain for a forced landing was a factor.NTSB CHI94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Benton, ILThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the tailwind.NTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.NTSB CHI93LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Clay Center, NEinadequate preflight planning by the pilot. Factors associated with this accident were a soft runway with high grass and the airplane's failure to attain a climb once airborne.NTSB ANC93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Jay Creek, AKThe pilot's selection of unsuitable terrain on which to land.NTSB FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.NTSB BFO93LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Mayville, NYThe pilot's failure to select the proper runway for takeoff, and his failure to maintain clearance with terrain. A factor related to the accident was a prevailing tailwind.NTSB CHI93LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Marysville, INThe pilot's failure to use carburetor heat while flying in carburetor icing conditions.NTSB ANC93LA040Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Iliamna, AKThe pilot in commands attempt to conduct a visual flight during instrument meteorological conditions and his failure to maintain control of the aircraft during the emergency 180 degree turn maneuver to reverse direction. Factors in the accident were the snow…NTSB CHI93LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · South St. Paul, MNThe pilot's inadequate compensation for the existing crosswind condition. The crosswind was a factor.NTSB CHI93LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · La Pointe, WISpatial disorientation of the pilot.NTSB LAX93LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Reno, NVThe pilot's poorly planned approach, inadequate compensation for the existing winds, and failure to maintain airspeed. Contributing to this accident was the pilot's lack of total expereince and inadvertent stall.NTSB BFO92LA138Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Greenville, METhe pilot's inadequate flare resulting in a hard landing.NTSB ANC92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot in commands failure to abort the takeoff and his misjudgment of the distance required to perform a safe takeoff under the conditions present.NTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.NTSB ATL92LA170Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrisburg, NCThe passenger's inadvertent interference with the flight controls.NTSB LAX92LA308Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tucson, AZThe pilot's poorly planned approach and failure to attain the proper descent rate. The loss of engine power for undetermined reasons and the rough terrain conditions in the area of the forced landing were factors in the accident.NTSB ANC92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kugururak River, AKThe failure to maintain directional control during takeoff. Factors include rough/uneven terrain.NTSB ANC92LA094Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Oshetna River, AKThe tailwind and the pilot not understanding the effects. Factors relating to the accident were the attempted precautionary landing and the high vegetation in the forced landing area.NTSB FTW92LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Walnut Ridge, ARThe inadvertent ground loop. A factor was the pilots total lack of experience in type airplane.NTSB FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.NTSB FTW92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terrell, TXThe pilot's alcoholic impairment of efficiency and judgement which led to his inattention to the amount of fuel remaining in the left fuel tank, resulting in fuel starvation and a total loss of engine power. A factor in the accident was the existence of the…NTSB LAX92LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Oxnard, CAThe pilot's failure to maintain control of the airplane during takeoff as a result of his alcoholic impairment of efficiency and judgement. A factor in the accident was the dark night.