NTSB investigations: Piper PA-18A 150
429 cases on aircraft the registry lists as Piper PA-18A 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 ('7101837'))
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 ('7101837'))
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 SEA04LA183Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Blaine, WAThe instructor pilot's inadequate remedial action during his student's final approach for a simulated engine out water landing.NTSB CHI04CA176Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake City, MIThe pilot's failure to maintain directional control during landing.NTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.NTSB ANC04LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ketchikan, AKThe pilot's failure to maintain adequate airspeed after an aborted landing, which resulted in an inadvertent stall and a ground loop. A factor contributing to the accident was the loss of directional control on the ground.NTSB SEA03LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Laurel, MTAircraft control was not maintained during the landing roll. The aircraft subsequently nosed over.NTSB FTW03LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Roanoke, TXThe flight instructor's inadequate in-flight planning/decision resulting in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Newcastle, WYthe pilot's failure to maintain clearance from the terrain. Contributing factors include inadequate in-flight planning and decision making by the pilot, and the ground.NTSB NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.NTSB ANC02LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane impacting rough terrain. A factor contributing to the accident was the rough/uneven terrain condition.NTSB NYC02FA126Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Farmingdale, NJThe pilot's failure to maintain directional control during takeoff.NTSB ATL02LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Thomaston, GAFailure of the pilot-in-command to maintain directional control on landing, resulting in an inadvertent ground loop.NTSB LAX02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beatty, NVThe pilot failed to maintain control of the airplane.NTSB SEA02LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Brewster, WAThe magneto was inadvertently switched off by the pilot during the climb. A tree was a factor.NTSB ANC01LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Glennallen, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor associated with the accident was a variable wind.NTSB LAX01LA130Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Holbrook, AZFailure of the rudder lower hinge attach point resulting in a loss of rudder control and steerable tailwheel control. A factor was the crosswind condition.NTSB ATL01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-A-150 · Sun City, FLThe loss of engine power for undetermined reasons, a factor was weather conditions favorable for carburetor icingNTSB ANC01LA029Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper use of the carburetor heat control. Factors in the accident were the presence of carburetor icing conditions, and snow-covered terrain that was unsuitable for a forced landing.NTSB ANC00LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Galena, AKThe pilot's inadequate compensation for the wind conditions. Factors were the crosswind, and a snow-covered ridge.NTSB SEA00LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's excessive use of brakes. Contributing factors were the pilot's misjudgment of distance/speed (landing long and fast) and lack of experience in the make/model of aircraft.NTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.NTSB LAX00TA212Accident · Minor injuriesFinal reportPiper PA-18-150 · Austin, NVLoss of engine power caused by a fuel soaked float pontoon causing an over rich fuel/air mixture, in a critical phase of flight.NTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.NTSB ANC99LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKA loss of engine power for an undetermined reason. A factor in the accident was unsuitable terrain for a forced landing.NTSB ANC99FA110Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Anaktuvuk Pass, AKThe inadvertent stall/spin by the pilot. A factor was the box canyon into which he had flown.NTSB SEA99LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Jordan Valley, ORThe pilot's inadvertent stall/mush of the aircraft while attempting a forced landing due to partial power loss of the engine. Factors include carburetor icing conditions and the pilot's improper use of carburetor heat.NTSB NYC99LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Cross Keys, NJThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the gusty wind conditions.NTSB ANC98LA063Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain adequate altitude/clearance from rising terrain. A factor associated with the accident was rising terrain.NTSB ANC98LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's failure to maintain directional control and his inadequate compensation for wind conditions. A factor was the gusting crosswind.NTSB MIA98LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Gulf Of Mexicoloss of engine power for undetermined reason(s), which resulted in a forced landing (ditching) at sea.NTSB MIA97LA247Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Bainbridge, GAthe failure of the pilot to see and avoid the tractor resulting in an on ground collision. A factor in this accident was the limited forward visibility from the cockpit of the airplane.NTSB LAX97LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-18A · Livingston, CAthe pilot's failure to see and avoid power lines. A factor was the pilot's poor judgment in conducting unwarranted low altitude maneuvering.NTSB MIA97WA089Accident · Minor injuriesForeign investigationPiper PA-18 · Valparaiso, ChileNTSB ANC96LA150Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKthe pilot's improper braking action, which resulted in an inadvertent ground swerve and subsequent damage to the airplane. His excessive airspeed during landing was a related factor.NTSB ANC96LA143Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKthe pilot's inadequate compensation for gusty crosswind conditions, which resulted in a loss of directional control and subsequent collision with trees/brush. Factors relating to the accident were: the crosswind and wind gusts.NTSB ANC96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe pilot's misjudgment of distance and altitude to the runway during the approach, and failure to attain the proper touchdown point. A factor relating to the accident was: the ditch.NTSB ANC96LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nikiski, AKThe pilot's premature lift-off during the takeoff roll. The pilot's selection of unsuitable terrain for takeoff was a factor in the accident.NTSB LAX96LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bullhead City, AZThe failure of the pilot/flight instructor to adequately supervise the student pilot resulting in loss of directional control, and his abrupt overcorrection resulting in a waterloop. A contributing factor was the pilot's limited experience as a flight…NTSB NYC95FA212Accident · 1 fatalField investigationFinal reportPiper PA-18A-150 · Egg Harbor, NJFailure of the pilot to maintain adequate airspeed during pull-up from a banner pickup, which resulted in a stall and collision with trees before recovering from the stall.NTSB ANC95LA154Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's adequate compensate for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.NTSB ANC95FA169Accident · 1 fatalField investigationFinal reportPiper PA-18A · Anchorage, AKThe pilot's improper in-flight planning/decision and failure to maintain adequate clearance or altitude from the mountainous terrain, while maneuvering near an airstrip.NTSB ANC95LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Skwentna, AKThe pilot's improper planning/decision. A factor relating to the accident was: the pilot's selection of a short/uneven landing area that required excessive braking action while landing with a tailwind.NTSB ANC95LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Manley Hot Spri, AKThe pilot's failure to correctly compensate for the existing wind conditions. The gusting wind condition was a factor.NTSB ANC94LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selecting a gravel bar for a normal landing. A factor was the soft spot in the gravel bar.NTSB ANC94LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe failure of the pilot to maintain the appropriate airspeed. A factor in the accident was the gusty wind.NTSB SEA94LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Prineville, ORThe pilot's inadequate compensation for wind conditions. A factor was gusty wind conditions.NTSB ANC94T#A01Accident · No injuriesClass 3Final reportPiper PA-18 · Cold Bay, AKNTSB ANC94LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot-in-command's improper preflight planning/preparation. A factor was rising terrain.NTSB ANC93LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe failure of the pilot to maintain directional control on touchdown. A factor in the accident was the gusty crosswind conditions.NTSB MIA93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cape Canaveral, FLLoss of engine power for an undetermined reason.NTSB ANC93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot-in-command's improper positioning of the fuel selector. Factor was the soft condition of the forced landing area.