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 ATL96LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bessemer, ALThe dual student's failure to maintain control of the aircraft during landing, and the flight instructor's failure to properly supervise the flight.NTSB ANC96LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cantwell, AKThe pilot's inadequate compensation for the crosswind conditions. A factor in the accident was the crosswind.NTSB FTW96FA250Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Monument, COThe pilot's VFR flight into instrument meteorological conditions in an aircraft which not instrument-equipped. Factors were clouds, low ceiling, and rain.NTSB ANC96LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kivalina, AKThe pilot's selection of an unsuitable takeoff area.NTSB ANC96LA073Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cold Bay, AKthe pilot's excessive taxi speed. Factors associated with the accident were: the pilot's improper preflight inspection of the airplane, and the entanglement of the left main landing gear brake and axle with wire.NTSB ANC96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKthe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain clearance from trees after encountering gusty crosswind conditions. The wind condition and close proximity of trees were related factors.NTSB NYC96LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshfield, MAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control, on-ground collision with terrain, and the aircraft nosing over. The sudden windshift was a related factor.NTSB ANC96LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's inadequate compensation for the wind conditions. A factor in the accident was the gusty wind conditions.NTSB ANC96LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKimproper planning/decision by the pilot, and his selection of unsuitable terrain on which to land a ski equipped airplane.NTSB SEA96FA034Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Kapowsin, WAthe pilot's failure to maintain aircraft control and terrain clearance. Turbulence was a factor.NTSB ANC96LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions, and failure to maintain sufficient altitude/clearance from mountainous/hilly terrain.NTSB ANC96LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot's selection of unsuitable terrain for landing. Soft sandy terrain was a related factor.NTSB ANC96LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Red Devil, AKLoss of engine power for an undetermined reason. The lack of suitable terrain for a forced landing was a related factor.NTSB ANC96LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKImproper planning/decision by the pilot concerning his method of testing the landing area. His selection of an unsuitable area was a related factor.NTSB SEA95LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Roberts, IDan improperly performed major rebuild and inadequate inspection of the aircraft by maintenance personnel. Inadequate preflight inspection by the pilot contributed to the accident.NTSB ANC95LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Delta, AKThe pilot's selection of an unsuitable step taxi/takeoff area. The submerged object was a related factor.NTSB ANC95LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKFailure of the pilot to maintain adequate altitude/clearance from terrain, during a low pass over a prospective (off-airport) landing area. Factors relating to the accident were: rain and rising/uneven terrain.NTSB FTW95LA377Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Westcliffe, COFailure by the pilot to maintain directional control. A factor was gusting cross winds.NTSB ANC95FA150Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's improper in-flight planning and decision by flying into a box canyon.NTSB SEA95LA184Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Owyhee, ORThe pilot's failure to maintain directional control. A factor contributing to the accident was his diversion of attention.NTSB FTW95TA390Accident · Minor injuriesFinal reportPiper PA-18-150 · Brackettville, TXThe pilot's improper compensation for wind conditions, and failure to maintain directional control. A factor relating to the accident was: the variable crosswind.NTSB ANC95LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Aniak, AKThe pilot's misjudged landing flare, which resulted in a hard landing and overload failure of the main landing gear.NTSB ANC95LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKFailure of the pilot to maintain proper alignment with the intended takeoff area during the takeoff roll. Factors relating to the accident were: pilot fatigue and the proximity of rocks/boulders to the takeoff area.NTSB ANC95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Alsworth, AKAn in-flight separation of a propeller blade, which resulted in a severe vibration, shutdown of the engine, and a forced landing in alder bushes.NTSB ANC95LA127Accident · No injuriesLimited investigationFinal reportCessna 206 · Sterling, AKFailure of both pilot's to maintain adequate visual lookout. The low angle of the sun was a related factor.NTSB ANC95LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot-in-command's failure to maintain airspeed.NTSB CHI95LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Versailles, MOthe pilot's improper recovery from a bounced landing, which resulted in his failure to maintain directional control of the airplane.NTSB SEA95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mccall, IDImproper planning/decision by the pilot, which resulted in his failure (or inability) to remain clear of terrain after initiating a go-around. Factors relating to the accident were: the unfavorable terrain and wind conditions (including downdrafts).NTSB ANC95LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Palmer, AKThe pilot's failure to maintain directional control, during an off-airport landing on rough/uneven terrain, which resulted in an inadvertent ground swerve. The terrain condition was a related factor.NTSB ATL95LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe pilot's failure to maintain aircraft control which resulted in the uncontrolled descent and collision with terrain.NTSB ANC95LA079Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's inadvertent stall of the airplane.NTSB ANC95TA068Accident · No injuriesFinal reportPiper PA-18-160 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing/takeoff. Factors associated with the accident are the long and wet grass covering the unimproved takeoff area.NTSB ANC95LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Galena, AKThe water contaminating the fuel and the pilot's inadequate preflight which failed to eliminate the water from the fuel system.NTSB FTW95LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-180 · Westcliffe, COThe loss of control due to the encounter with the dust devil.NTSB ANC95LA057Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Hope, AKThe pilot's failure to adequately compensate for wind conditions. Factors associated with the accident are the trees bordering the runway, and a downdraft.NTSB ANC95FA073Accident · 2 fatalField investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall. The pilot's failure to obtain a weather briefing and an encounter with turbulence were factors in the accident.NTSB ANC95GA083Accident · No injuriesFinal reportPiper PA-18 · Copper Center 2, AKThe pilot not using the checklist and landing with the skis pumped down.NTSB CHI95LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Burwell, NEThe pilot's selection of unsuitable terrain for landing and takeoff. A factor was rough/uneven terrain.NTSB ANC95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKA failure of the pilot to perform an adequate pre-flight inspection of the airplane. Factors in the accident were a frozen gascolator, and restricted fuel supply.NTSB ANC95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Juneau, AKThe pilot's selection of unsuitable terrain for the attempted takeoff.NTSB NYC95LA037Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenburn, METhe pilot's (1) improper decision to initiate a takeoff with ice on the wing.NTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.NTSB CHI95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Grand Forks, NDthe fatigue failure of the crankshaft.NTSB ANC94LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to assure that an adequate supply of fuel was available to complete the flight. A factor in the accident was the siphoning of fuel from the fuel cap.NTSB ANC94LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot's failure to maintain a positive rate of climb.NTSB ANC94LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kodiak, AKA failure of the pilot to adequately compensate for crosswind conditions. A crosswind and rough/uneven terrain were factors in the accident.NTSB ANC94LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe failure of the pilot to compensate for a tailwind and maintain directional control of the airplane. A tailwind was a factor in the accident.NTSB ANC94LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe worn cam shaft lobe and worn valve lifter.NTSB ANC94LA124Accident · 2 fatalLimited investigationFinal reportPiper PA-18 · Glenallen, AKAirspeed not maintained. A factor was the gusty wind conditions.NTSB ATL94FA162Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Byromville, GAThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall.