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 ANC92FA148Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKMisjudgment by the pilot to insure adequate distance from objects in the takeoff area, which resulted in damage to the main landing gear on takeoff, and the uncontrolled ground loop by the pilot during a landing with the damaged landing gear. Factors related…NTSB ANC92LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKThe pilot's improper preflight planning/preparation, his improper compensation for wind conditions, and his failure to maintain directional control during the takeoff run. Contributing to the accident was the crosswind.NTSB ANC92LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Mackey Lake, AKA loss of power for undetermined reasons. A factor which contributed to the severity of the accident was the pilot inadvertently stalled the airplane.NTSB LAX92FA356Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Incline Village, NVWas the pilot's in flight loss of airplane control due to physical incapacitation.NTSB ANC92LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot failed to maintain airspeed and stalled the airplane. Contributing to the accident was the unfavorable wind condition.NTSB ANC92LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bettles, AKThe pilot's improper in flight planning/decision, and his failure to maintain a proper altitude while operating in the mountains. A contributing factor was the mountainous terrain.NTSB DEN92LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Littleton, COInadvertent stall during final approach to landing.NTSB ANC92T#A07Accident · No injuriesClass 3Final reportPiper PA-18 · Shishmaref, AKNTSB ANC92LA104Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Molly Creek, AKThe pilot misjudged his terrain clearance when planning his takeoff. Factors include high vegetation at the end of the runway.NTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.NTSB MIA92LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · St. Augustine, FLThe pilot-in-command's failure to maintain airspeed while buzzing which resulted in the aircraft stalling and entering a spin.NTSB ANC92LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's failure to maintain directional control. A factor to the accident was: a crosswind.NTSB ANC92LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe left main landing gear ski being partially disconnected at the time of the landing. Contributing factors were the inadequate preflight by the pilot, and the snow covered landing area.NTSB ANC92T#A12Accident · No injuriesClass 3Final reportPiper PA-18-150 · Anchorage, AKNTSB ANC92FA005Accident · Minor injuriesField investigationFinal reportPiper PA-18 · Montague Island, AKThe power loss due to the crankshaft failure. Contributing to the accident was improper maintenance during the last engine overhaul.NTSB DEN92LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COThe pilot flying the aircraft at a height above ground level which was inadequate for recovery from an encounter with down drafts. A factor was: down draft encounter.NTSB ANC91LA155Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle, AKThe damage sustained when striking a rock during the previous takeoff roll which resulted in the main landing gear's collapse during landing.NTSB ANC91LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Noatak, AKWas the pilot's failure to maintain a proper descent rate. Contributing to the accident was the gust of tailwind.NTSB ANC91LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aspen Creek, AKThe partial loss of power for undetermined reasons and the rough terrain.NTSB ANC91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe pilot's failure to maintain adequate airspeed, resulting in a stall, hard landing and collapse of the main landing gear.NTSB ANC91LA121Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the pilot's weather evaluation misjudgment, the high wind, and rough water encountered during takeoff.NTSB ANC91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Willow, AKWas the in-flight collision of the airplane with an object due to the pilot-in-command's lack of an adequate visual lookout. Contributing to the accident was the rough, uneven and narrow condition of the airstrip.NTSB ANC91LA109Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's failure to maintain directional control of the airplane on landing.NTSB ANC91GA087Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot inadvertently switched the magnetos off during the flight. Contributing to the accident was the rough, uneven terrain with loose gravel.NTSB ANC91LA077Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Woods River, AKFailure of the pilot to maintain adequate airspeed, while turning after a low pass, which resulted in an inadvertent stall. The wind gusts and turbulence were related factors.NTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.NTSB ANC91FA067Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · Wasilla, AKThe powerplant failure for undetermined reasons and the collision with the wires.NTSB ANC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKThe pilot's failure to maintain directional control during the attempted takeoff. Contributing to the accident was the rough takeoff area and the trees along the side of the takeoff area.NTSB DEN91LA075Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Elbert, COThe pilot's delay in compensating for wind conditions. Factors were: high winds and a crosswind.NTSB ANC91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKCarburetor icing and the pilot's failure to follow proper procedures and directives pertaining to carburetor heat.NTSB FTW91LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Port Lavaca, TXThe pilot's inadvertent stall at an altitude too low for recovery. A factor was the pilot's low pass.NTSB ANC91LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Alexander Creek, AKThe engine failure resulting from fuel screen contamination . A factor was the lack of suitable terrain for the forced landing.NTSB ANC91LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Thorne Bay, AKThe pilot's delay in aborting the takeoff.NTSB DEN91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Englewood, COThe failure of the pilot to maintain directional control.NTSB ANC90LA185Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotes Lakes, AKThe pilot-in-command's encounter with turbulence while on final approach, and failure to maintain aircraft control.NTSB ANC90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to adequately remove snow from the airplane and his delay in aborting the takeoff.NTSB ANC90LA176Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Heiden, AKThe pilot-in-command's failure to maintain aircraft control during a strong crosswind.NTSB ANC90LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · King Salmon, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB ANC90T#A02Accident · No injuriesClass 3Final reportPiper PA-18-150 · Kotzebue, AKNTSB ANC90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big River, AKThe improper use of brakes by the pilot during the landing roll.NTSB SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB ANC90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canning River, AKThe engine power loss due to fuel contamination, and the lack of suitable terrain on which to land.NTSB ANC90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC90LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot inadvertently stalled the airplane.NTSB ANC90LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Big Lake, AKLoss of engine power for undetermined reasons resulting in an off airport landing in a ditch.NTSB DEN90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Douglas, WYThe accident to be improper installation of aileron control system by maintenance personnel, and failure to perform an aircraft preflight by the pilot in command.NTSB ANC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Wasilla, AKPilot's failure to maintain control of the airplane. Contributing to the accident was the pilot's lack of total experience.NTSB LAX90LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Fullerton, CAFuel starvation due to the pilot's improper fuel management technique. A factor was the improperly modified fuel selector valve.NTSB ANC90LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Mountain, AKPilot-in-command failed to compensate for gusty wind conditions and control of the aircraft during the take off roll.