NTSB investigations: Piper PA-18-150

109 cases on aircraft the registry lists as Piper PA-18-150, where the sequence of events included Collision with terr/obj (non-CFIT). 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 ('7101828', '7104221', '7102835')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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 ANC14CA063Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilots excessive use of the airplanes brakes during the landing roll, which resulted in a nose over. Contributing to the accident was the flight instructor's inadequate supervision of the training flight.Aug 11, 2014 · N8979D · Substantial damageNTSB WPR14CA342Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll in variable wind conditions, resulting in a ground-loop.Jul 21, 2014 · N3997Z · Substantial damageNTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…Jul 12, 2014 · N91106 · Substantial damageNTSB ANC14CA053Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Prudhoe Bay, AKThe pilot's failure to maintain directional control during landing and attempted go-around, resulting in contact with terrain and a ground loop.Jul 11, 2014 · N3971Z · Substantial damageNTSB ERA14CA211Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Woodbine, NJThe flight instructor's delayed reaction to the loss of directional control, which resulted in a ground loop.Apr 27, 2014 · N4615Y · Substantial damageNTSB ERA14CA140Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Mayaguez, PRThe pilot's loss of directional control of the airplane during landing, which resulted in a runway excursion.Mar 1, 2014 · N929SC · Substantial damageNTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.Feb 24, 2014 · N9563P · Substantial damageNTSB WPR14CA109Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Willcox, AZThe pilot's decision to land off airport on unsuitable terrain that resulted in a collision with hidden objects.Jan 26, 2014 · N9683P · Substantial damageNTSB ANC13CA107Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Wasilla, AKThe pilot's improper preflight inspection, and failure to remove heavy frost from the airplane prior to attempting a takeoff.Sep 30, 2013 · N40579 · Substantial damageNTSB ANC13CA096Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Talkeetna, AKThe pilot's delayed decision to go-around, which resulted in a collision with water.Sep 8, 2013 · N4483Z · Substantial damageNTSB ANC13LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Paxson, AKThe partial loss of engine power due to a loose throttle cable clamp.Aug 13, 2013 · N44RT · Substantial damageNTSB ANC13CA078Accident · No injuriesData collectionFinal reportPiper PA-18-150 · McCarthy, AKThe pilot's loss of directional control during takeoff.Aug 12, 2013 · N3897Z · Substantial damageNTSB WPR13CA339Accident · No injuriesData collectionFinal reportPiper PA-18 · Challis, IDThe pilot's failure to maintain directional control during the takeoff roll.Jul 25, 2013 · N4249Z · Substantial damageNTSB ANC13CA019Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for an off-airport landing, which resulted in a ground-loop.Jan 4, 2013 · N7780Y · Substantial damageNTSB CEN13CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Okaton, SDThe pilot's failure to perform an adequate preflight inspection of the airplane and obstruction of the aileron control system by snow and ice, which led to a loss of control during flight.Dec 11, 2012 · N3471Z · Substantial damageNTSB ANC12CA110Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's loss of directional control during takeoff in gusting wind conditions from an off-airport site, which resulted in a collision with terrain and a nose over.Sep 21, 2012 · N3802Z · Substantial damageNTSB ANC12CA101Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Ekwok, AKThe pilot's diverted attention during the initial climb, which resulted in a collision with trees.Sep 5, 2012 · N4127Z · Substantial damageNTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.Aug 28, 2012 · N4316Z · Substantial damageNTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.Aug 1, 2012 · N7808Z · Substantial damageNTSB ERA12LA453Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCThe pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.Jul 15, 2012 · N8048D · Substantial damageNTSB CEN12CA454Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Jenks, OKThe pilot's failure to achieve a proper touchdown point during landing, which resulted in a runway overrun and impact with obstructions.Jul 15, 2012 · N83604 · Substantial damageNTSB ANC12LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kenai, AKThe in-flight separation of a propeller tip due to an unauthorized and undocumented propeller repair.Jul 14, 2012 · N7154Z · Substantial damageNTSB ANC12CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tynoek, AKThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.Jul 11, 2012 · N4272Z · Substantial damageNTSB ANC12CA069Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's selection of an unsuitable off-airport landing site, which resulted in a loss of control during the landing roll.Jul 6, 2012 · N623JE · Substantial damageNTSB ANC12CA043Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s failure to maintain directional control while landing in a gusting crosswind.May 29, 2012 · N3772Z · Substantial damageNTSB ANC12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Gakona, AKThe pilot’s decision to take off in variable wind conditions, which resulted in a loss of control and the airplane striking an object after takeoff.May 10, 2012 · N999JV · Substantial damageNTSB CEN12CA183Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Fort Collins, COThe pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.Mar 8, 2012 · N2986P · Substantial damageNTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.Oct 18, 2011 · N8485D · Substantial damageNTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.Oct 15, 2011 · N929SC · Substantial damageNTSB ERA12CA015Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Elizabethton, TNThe failure of the pilot to maintain airspeed during the initial climb after takeoff, which resulted in an aerodynamic stall.Oct 7, 2011 · N3491Z · Substantial damageNTSB ANC11FA093Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · McGrath, AKThe pilot inadvertently switched off the engine magnetos during short final approach, which resulted in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches in the cabin.Sep 4, 2011 · N13973 · Substantial damageNTSB ANC11CA089Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe pilot inadvertently switching off the engine magnetos during the initial climb, resulting in a loss of engine power. Contributing to the accident was the manufacturer's placement of the magneto switches.Aug 30, 2011 · N82448 · Substantial damageNTSB ANC11CA086Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Beluga Lake, AKThe pilot's decision to takeoff with an unfavorable wind which resulted in a loss of directional control, and collision with terrain.Aug 25, 2011 · N8491Y · Substantial damageNTSB WPR11CA402Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Emmett, IDThe pilot's failure to maintain directional control during landing.Aug 22, 2011 · N4376Z · Substantial damageNTSB WPR11FA390Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Forsyth, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in a stall/mush, loss of control, and impact with terrain.Aug 18, 2011 · N7666D · Substantial damageNTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.Aug 16, 2011 · N4205Z · Substantial damageNTSB ANC11CA021Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chicken Lake, AKThe pilot's failure to maintain adequate clearance from terrain.Mar 27, 2011 · N91117 · Substantial damageNTSB ANC11CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Clear, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to water/ice in the fuel system.Dec 23, 2010 · N40283 · Substantial damageNTSB ANC10CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Skwentna, AKThe pilot's rapid application of throttle and carburetor heat causing the engine to hesitate and lose power during takeoff following an aborted landing.Sep 21, 2010 · N24P · Substantial damageNTSB ANC10CA077Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain directional control during landing, resulting in a runway excursion and nose over.Aug 27, 2010 · N9730P · Substantial damageNTSB ANC10CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Port Moller, AKThe loss of the left rudder cable retaining bolt during base to final turn, resulting in a loss of control and impact with terrain.May 6, 2010 · N3774Z · Substantial damageNTSB ANC10TA028Accident · No injuriesFinal reportPiper PA-18-150 · Stony River, AKThe pilot's failure to maintain directional control of the airplane during taxi from landing, which resulted in the airplane sliding into trees.Apr 3, 2010 · N82732 · Substantial damageNTSB ANC10TA017Accident · No injuriesFinal reportPiper PA-18-150 · King Cove, AKA total loss of engine power due to the pilot's failure to use carburetor heat in conditions conducive to carburetor ice.Feb 11, 2010 · N278Z · Substantial damageNTSB ANC10CA008Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's decision to land and attempt to takeoff from an unsuitable off-airport site.Nov 14, 2009 · N3797Z · Substantial damageNTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.Oct 24, 2009 · N83281 · Substantial damageNTSB CEN10CA013Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Bingham, NEThe pilot's impairment due to alcohol consumption and failure to maintain aircraft control.Oct 9, 2009 · N54750 · Substantial damageNTSB ANC09CA101Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Tok, AKThe pilot's selection of an unsuitable landing/takeoff area, resulting in a runway excursion and a nose over during takeoff.Sep 17, 2009 · N874SC · Substantial damageNTSB ANC09CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKA tailwheel malfunction that limited directional control, which resulted in a runway excursion, and collision with a building.Sep 7, 2009 · N54182 · Substantial damageNTSB ANC09CA082Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kaktovik, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.Aug 14, 2009 · N83278 · Substantial damageNTSB ANC09CA051Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed on final approach, which resulted in an aerodynamic stall and hard landing.Jun 6, 2009 · N7796Y · Substantial damage