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.

NTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.Aug 21, 2009 · N6038D · Substantial damageNTSB WPR09FA379Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Saint Charles, IDThe pilot’s failure to maintain terrain clearance while maneuvering.Aug 7, 2009 · N6905B · DestroyedNTSB CEN09CA376Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Collins, COThe pilot's failure to maintain control of the airplane during a crosswind landing. Contributing to the accident was the instructor's delayed action in regaining control of the airplane.Jun 22, 2009 · N5824D · Substantial damageNTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.May 17, 2009 · N8042D · Substantial damageNTSB ANC09CA043Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane.May 15, 2009 · N1999P · Substantial damageNTSB WPR09FA175Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Sherwood, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in spatial disorientation and a loss of control.Apr 1, 2009 · N9996D · Substantial damageNTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.Nov 1, 2008 · N3758P · Substantial damageNTSB DEN08CA147Accident · No injuriesData collectionFinal reportPiper PA-22 · Star City, ARThe pilot failed to maintain directional control during landing. Contributing to the accident were the crosswinds and the rough terrain near the runway.Sep 1, 2008 · N7253D · Substantial damageNTSB LAX08CA278Accident · No injuriesData collectionFinal reportPiper PA-22 · St. Paul, ORThe pilot's misjudged altitude, speed, and subsequent failure to attain the proper touchdown point while landing.Jul 31, 2008 · N2441P · Substantial damageNTSB LAX08CA232Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ogden, UTThe pilot's failure to maintain directional control of the airplane during landing.Jul 19, 2008 · N5716D · Substantial damageNTSB DFW08FA190Accident · 3 fatalField investigationFinal reportPiper PA-22 · Kemp, TXThe pilot's failure to maintain adequate airspeed while maneuvering, which led to an aerodynamic stall and subsequent loss of control.Jul 19, 2008 · N9980D · DestroyedNTSB CHI08CA167Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Wadena, MNThe pilot's failure to maintain control of the tail wheel airplane during the landing roll. A factor associated with the accident was the pilot's lack of recent experience in tail wheel airplanes.Jun 17, 2008 · N697DM · Substantial damageNTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.Apr 18, 2008 · N2710P · Substantial damageNTSB ANC08LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Pole, AKA loss of engine power for an undetermined reason during an attempted go-around, resulting in a forced landing and a collision with snow-covered terrain. A factor associated with the accident was the lack of suitable terrain for a forced landing.Dec 26, 2007 · N7637D · Substantial damageNTSB NYC08CA055Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Tallahassee, FLThe pilot's misjudged clearance over obstacles during final approach.Dec 8, 2007 · N5921D · Substantial damageNTSB CHI08CA038Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plato Center, ILThe excessive airspeed used by the pilot which resulted in an overrun, impact with a ditch and subsequent nose over. The ditch was a factor.Nov 9, 2007 · N2813Z · Substantial damageNTSB DEN08LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Canon City, COthe failure of the landing gear hinge point attachment for undetermined reasons.Oct 29, 2007 · N2736P · Substantial damageNTSB ANC07CA101Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cooper Landing, AKThe pilot's failure to maintain altitude/clearance from objects, which resulted in an in-flight collision with trees during takeoff/initial climb. A factor contributing to the accident was the pilot's decision to takeoff into known adverse weather.Sep 19, 2007 · N2825Z · Substantial damageNTSB LAX07LA263Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Modesto, CAThe failure of the airplane's exhaust muffler during takeoff that was due to an inadequate annual inspection. Contributing to the accident were the pilot's inadequate inspection to isolate the smoke source, and the pilot's decision to continue flight with an…Sep 2, 2007 · N13WA · DestroyedNTSB MIA07CA057Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Pierce, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in overload failure and subsequent collapse of the right main landing gear.Feb 23, 2007 · N2808P · Substantial damageNTSB SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.Dec 22, 2006 · N7124D · Substantial damageNTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.Dec 20, 2006 · N5811D · Substantial damageNTSB SEA06CA170Accident · No injuriesData collectionFinal reportPiper PA-22-20-150 · Auburn, WAThe flight instructor's delayed remedial action during the landing roll in response to the student's loss of directional control, which resulted in a ground loop. A factor associated with the accident was the student's failure to maintain directional control.Aug 24, 2006 · N8042D · Substantial damageNTSB DEN06CA071Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Rangely, COthe pilot's inadvertent application of the brake during the landing roll. A contributing factor was the pilot's failure to maintain directional control and the flight instructor's inadequate supervision during the landing.May 3, 2006 · N6946B · Substantial damageNTSB ANC06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Birchwood, AKThe flight instructor's delayed remedial action during the landing roll, which resulted in the loss of directional control by the student, a ground-loop, and collapse of the main landing gear. A factor associated with the accident was the student's failure to…Apr 15, 2006 · N7257D · Substantial damageNTSB CHI06CA114Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Drayton, NDThe pilot's failure to maintain directional control during takeoff. A related factor was the high wind condition.Apr 12, 2006 · N2555P · Substantial damageNTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.Mar 26, 2006 · N6123D · Substantial damageNTSB NYC06CA051Accident · No injuriesData collectionFinal reportPiper PA-22 · Jamestown, NYThe pilot's failure to maintain directional control during the landing rollout. Factors included the ice on the runway and the soft terrain.Dec 28, 2005 · N4792A · Substantial damageNTSB MIA06WA036Accident · 2 fatalForeign investigationPiper PA-23-260 · Cali, ColombiaDec 24, 2005 · N7744D · DestroyedNTSB CHI06CA025Accident · Minor injuriesData collectionFinal reportPiper PA22-150 · Canton, ILThe fire for undetermined reasons.Nov 2, 2005 · N9664D · DestroyedNTSB ANC06CA003Accident · No injuriesData collectionFinal reportPiper PA-22 · Willow, AKThe pilot's selection of an unsuitable takeoff area, which resulted in an on ground encounter with a river during an aborted takeoff.Oct 10, 2005 · N5947D · Substantial damageNTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.Sep 1, 2005 · N1829P · Substantial damageNTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.Aug 20, 2005 · N2373P · Substantial damageNTSB LAX05CA268Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Reno, NVThe pilot's inadequate compensation for the crosswind gust and failure to maintain lateral and directional control during the landing flare.Aug 14, 2005 · N6045D · Substantial damageNTSB ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.Aug 6, 2005 · N4774A · Substantial damageNTSB IAD05LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chatham, VAThe pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.Jul 24, 2005 · N3818P · Substantial damageNTSB SEA05CA123Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ontario, ORThe pilot's failure to maintain aircraft control during landing roll. A contributing factor was the cross wind weather condition.Jun 7, 2005 · N5814D · Substantial damageNTSB ANC05LA044Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's excessive taxi speed during a turn while taxiing from landing, which resulted in the collapse of the left main landing gear, and structural damage to the fuselage.Feb 27, 2005 · N6174D · Substantial damageNTSB FTW04LA231Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Mountain Home, TXThe pilot's failure to maintain adequate airspeed which resulted in a stall.Sep 3, 2004 · N2972P · Substantial damageNTSB CHI04CA228Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Elkhart, INThe failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.Aug 15, 2004 · N4303A · Substantial damageNTSB SEA04CA151Accident · No injuriesData collectionFinal reportPiper PA22-20 · Wht Sulphur Spg, MTThe failure of the private pilot receiving flight training for a tail wheel endorsement to maintain aircraft control, and his excessive braking during the landing roll, subsequently nosing over the airplane. A contributing factor was the flight instructor's…Aug 1, 2004 · N3838P · Substantial damageNTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.May 13, 2004 · N1829P · Substantial damageNTSB LAX04CA189Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Minden, NVthe pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control of the airplane, resulting in a collision with terrain.Apr 18, 2004 · N6062D · Substantial damageNTSB NYC04CA020Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Franklin, KYThe pilot's failure to maintain aircraft control during takeoff.Nov 1, 2003 · N3264Z · Substantial damageNTSB MIA03CA103Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Madison, MSThe pilot's failure to maintain control during the landing rollout/which resulted in the airplane veering off the runway and incurring damage.May 3, 2003 · N175W · Substantial damageNTSB SEA03LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lexington, ORThe pilot's inadequate compensation for the cosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.Apr 7, 2003 · N4857A · Substantial damageNTSB NYC03LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot under instruction's failure to maintain directional control, and the flight instructor's delayed remedial action.Mar 23, 2003 · N2968Z · Substantial damageNTSB NYC03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · South Woodstock, CTThe pilot's failure to maintain directional controlMar 8, 2003 · N7342D · Substantial damageNTSB SEA03LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Garryowen, MTThe pilot in command's allowing the aircraft to inadvertently enter into a stall condition at low altitude while maneuvering. A contributing factor was the pilot's intentional low altitude maneuvering.Feb 20, 2003 · N24MF · Substantial damageNTSB CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.Nov 28, 2002 · N4901S · Substantial damage