NTSB investigations: Piper PA-18-150

1,667 cases on aircraft the registry lists as Piper PA-18-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 ('7101828', '7104221', '7102835'))
  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 WPR13CA279Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Cashmere, WAThe pilot’s improper application of the brakes during the landing ground roll, which resulted in a nose over.Jun 20, 2013 · N6845Z · Substantial damageNTSB ANC13CA044Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.May 7, 2013 · N8899Y · Substantial damageNTSB WPR13CA114Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Worland, WYThe pilot's failure to maintain directional control during landing.Feb 1, 2013 · N83454 · 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 WPR13CA055Accident · No injuriesData collectionFinal reportPiper PA18 · Needles, CAThe flight instructor, while demonstrating a water landing to the pilot receiving instruction, did not maintain proper alignment with the landing surface, which resulted in a hard landing.Nov 24, 2012 · N2224 · Substantial damageNTSB ERA13LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canton, GAA partial loss of engine power due to carburetor icing, which the pilot could not correct by applying carburetor heat because the movement of the carburetor heat control arm was restricted.Nov 13, 2012 · N9764P · 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 ANC12LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Homer, AKThe total loss of engine power for reasons that could not be determined because the engine could not be examined because of the extent of time in salt water.Sep 8, 2012 · N3214D · 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 ANC12LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course.Sep 2, 2012 · N82016 · 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 ANC12CA088Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's loss of control during the landing roll in gusting wind conditions, which resulted in the airplane nosing over.Aug 15, 2012 · N4001Z · 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 ERA12FA465Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Berlin, MDPilot incapacitation of unknown origin, which resulted in the airplane’s loss of control and an inadvertent aerodynamic stall/spin.Jul 19, 2012 · N4330Z · Substantial damageNTSB ERA12LA468Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCA total loss of engine power due to carburetor icing.Jul 18, 2012 · N2991Z · Substantial damageNTSB ANC12CA076Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Whittier, AKThe pilot's failure to maintain clearance from brush during landing, which resulted in a loss of control.Jul 18, 2012 · N3764Z · 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 ANC12LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-180 · Chugiak, AKThe pilot/airplane owner’s loss of directional control after landing, and the instructor pilot's lack of adequate supervision of the training flight.Jul 4, 2012 · N329DP · 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 ERA12CA311Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Eaton, NYThe pilot's improper approach to landing, which resulted in the airplane touching down short of the runway.Apr 29, 2012 · N82398 · Substantial damageNTSB ERA12CA310Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Burlington, NCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Apr 29, 2012 · N91250 · Substantial damageNTSB ANC12TA035Accident · No injuriesFinal reportPiper PA-18-150 · Paxon, AKA separation of the right main landing gear suspension strut assembly due to overstress, which resulted in the collapse of the main landing gear while landing.Apr 28, 2012 · N7059 · 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 WPR12CA028Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll.Oct 30, 2011 · N82213 · Substantial damageNTSB CEN12CA042Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · West Fargo, NDThe pilot's excessive use of brakes during the landing roll before the tailwheel had made sustained contact with the runway.Oct 24, 2011 · N7949 · Substantial damageNTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.Oct 22, 2011 · N82481 · 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 ANC11CA115Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe student pilot's hard landing in a gusting wind.Sep 26, 2011 · N8998Y · Substantial damageNTSB ANC11CA105Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff.Sep 17, 2011 · N82907 · 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 ANC11CA092Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's continued visual flight into instrument meteorological conditions.Sep 4, 2011 · N83283 · 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 ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.Jun 23, 2011 · N6248R · Substantial damageNTSB ANC11CA047Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's loss of directional control while landing in a crosswind.Jun 14, 2011 · N3858Z · Substantial damageNTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.Apr 27, 2011 · N9683P · 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 WPR11LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Twin Falls, IDThe pilot’s failure to compensate for the wind, which resulted in the airplane being blown over after completion of the landing roll.Feb 16, 2011 · N7153Z · Substantial damageNTSB WPR11TA087Accident · No injuriesFinal reportPiper PA-18-180 · Shoshoni, WYA total loss of engine power for undetermined reasons.Jan 2, 2011 · N6774B · Substantial damage