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.
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" 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 ANC94LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Koliganek, AKThe pilot's inadequate in-flight planning and failure to attain a touchdown point in the landing area. An obstacle (tree) in the landing area was a factor in the accident.NTSB SEA94LA215Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hailey, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was a tailwind.NTSB BFO94FA134Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Grand Lake Strm, METhe pilot attempted a maneuver at an altitude insufficient for recovery. A factor in the accident was pilot physical impairment due to alcohol consumption.NTSB ANC94LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe partial loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB ANC94LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Newtok, AKThe pilot's selection of unsuitable terrain.NTSB ANC94LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's inadequate compensation for the wind conditions during the landing. The gusty wind condition was a factor.NTSB SEA94LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Culbertson, MTThe pilot's failure to maintain directional control. Factors include gusty crosswinds, and a fence near the point of takeoff.NTSB ANC94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKDirectional control not maintained by the pilot in command. A factor in the accident was the inadvertant ground loop/swerve.NTSB ANC94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pilot Point, AKThe Pilot's failure to maintain control of the airplane during takeoff.NTSB CHI94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ottumwa, SDinadequate compensation for wind conditions and the pilot's failure to maintain directional control. Factors related to the accident were the crosswind and the fence posts.NTSB SEA94FA071Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Frenchglen, ORThe pilot's failure to maintain minimum airspeed (vs). The tailwind was a factor.NTSB CHI94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Forks, NDFuel starvation due to the improper positioning of the fuel tank selector by the student pilot.NTSB ANC94FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-160 · Palmer, AKLoss of engine power for undetermined reasons. A factor in the severity of the accident was the failure of the pilot-in-command to maintain control of the airplane when the engine ceased producing power.NTSB SEA94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Missoula, MTThe pilot/passenger's failure to maintain directional control and the pilot in command's failure to properly supervise the landing.NTSB NYC94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Monticello, NYThe pilot allowed the speed of the airplane to get too slow, resulting in an inadvertent stall at too low an altitude to allow recovery.NTSB ANC94LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot-in-command not maintaining the proper clearance from the terrain during the approach.NTSB LAX94FA065Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Payson, AZImproper in-flight planning/decision by the pilot, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. Factors related to the accident were: pilot impairment from improper use of prescription drugs (not approved for…NTSB ANC94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot-in-command's failure to compensate for the wind conditions. The gusty wind was a factor.NTSB ANC94LA012Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Haines, AKFatigue failure in a weld on the right main landing gear oleo strut tubing.NTSB ANC94LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pilot Point, AKThe Pilot-in-command's failure to compensate for the crosswind during taxi. The crosswind was a factor.NTSB ANC93LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Rocky River, AKThe pilot misjudging his altitude on final approach.NTSB ANC93LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot failed to adequately compensate for the wind conditions. A factor was the unfavorable wind.NTSB ANC93LA178Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prudhoe Bay, AKFluid fuel contamination as a result of the pilot-in-commands improper preflight planning/preparation.NTSB ANC93LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mosquito River, AKThe pilot's failure to maintain a proper altitude during the low pass. A factor was the rough/uneven terrain.NTSB ANC93LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Squirrel River, AKThe pilot improperly compensated for the wind conditions.NTSB ANC93LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Victory, AKThe partial failure of the airplane's brake system. Factor was the intentional ground looping by the pilot-in-command.NTSB ANC93LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Happy Valley, AKThe pilot's improper preflight planning/decision, and his failure to maintain directional control of the airplane. A factor was the rough/uneven terrain.NTSB ANC93LA153Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Little Delta Rv, AKThe pilot's failure to maintain control of the airplane during the takeoff climb. Factor was the gusty winds.NTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.NTSB ANC93LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper planning/decision, while on an approach to land behind another airplane.NTSB DEN93LA083Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, COThe pilot's failure to maintain directional control.NTSB ANC93FA114Accident · 4 fatalField investigationFinal reportPiper PA-16 · Fairbanks, AKFailure of the pilots of both airplanes to see and avoid each other, and the alcohol impairment of the pilot-in-command of the PA-16, N5960H. A factor which contributed to the accident was the sunglare.NTSB ANC93LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Uganik River, AKPilot in commands failure to compensate adequately for shifting wind conditions and his selection of unsuitable terrain on which to land. A factor in the accident was the rough uneven terrain landing strip.NTSB ANC93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe pilot in command selected unsuitable terrain on which to land on. A factor in the accident was the rough/uneven, soft terrain.NTSB FTW93TA#07Accident · No injuriesFinal reportPiper PA-18-150 · Del Rio, TXNTSB MIA93LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Pensacola, FLThe pilot-in-command's inadequate compensation for wind conditions and delayed remedical action.NTSB ANC93LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot in command's inadvertent ground loop.NTSB LAX93LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Vacaville, CAthe pilot's failure to maintain directional control after encountering strong and gusty cross winds during the landing flare.NTSB FTW93TA#04Accident · No injuriesFinal reportPiper PA-18-150 · Godley, TXNTSB ANC93FA054Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kashwitna, AKThe pilot in command not maintaining control of the airplane and his inadequate preflight preparation for high mountain terrain big game operations. Factors contributing to the accident were: the high terrain condition and the lack of total experience in the…NTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.NTSB SEA93LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Winnett, MTThe student pilot's failure to maintain directional control. Factors contributing to the accident were the snowbank and lack of total experience in type operation.NTSB DEN93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to evaluate changing weather conditions.NTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB ATL93LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, SCThe loss of engine power which resulted from fuel starvation when the carburetor float valve stuck in the closed position. A factor was the soft field .NTSB FTW93FA032Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Uvalde, TXClearance not maintained by pilot in command.NTSB SEA92LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Smoot, WYThe pilot in command's delayed go-around. Factors contributing to the accident were the pilot in command's selection of unsuitable terrain and trees.NTSB ANC92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Pole, AKPilot's decision to attempt takeoff without removing snow from aircraft surfaces. Factor related to the accident was the snow contaminated wing and other flight surfaces.NTSB ANC92LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Lime Village, AKThe pilot in command not maintaining control of the airplane. A factor in the accident was the wind gusts.NTSB ANC92LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Sparrevohn, AKThe pilot's low pass between trees in crosswind conditions and inflight decision to conduct low altitude flight at a location that was too restricted for safe operation. Factors relating to the accident were: cross wind conditions and obstacles (trees).