NTSB investigations: Piper PA-12
817 cases on aircraft the registry lists as Piper PA-12. 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 ('7101202'))
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 ('7101202'))
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 SEA93FA151Accident · 1 fatalField investigationFinal reportPiper PA-12 · Laramie, WYPoor inflight planning and an inadvertent stall.NTSB MIA93LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tampa, FLthe improper welding/repair by maintenence personnel of the exhaust system, which eventually failed allowing hot exhaust gasses and flame to burn a fuel line and start a fire.NTSB ANC93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Anchorage, AKThe complete loss of engine power due to undetermined reasons. Factor was the deep water forced landing area.NTSB CHI93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-12 · White Bear Lake, MNThe pilot selected unsuitable terrain for landing. The snow covered runway was a factor.NTSB FTW93LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-108 · Vilonia, ARThe pilot's failure to execute a go-around.NTSB SEA93FA010Accident · 2 fatalField investigationFinal reportPiper PA-12 · Lowman, IDThe pilot's failure to maintain adequate terrain clearance. Factors include mountainous/hilly terrain, trees, and the pilot's diverted attention.NTSB ATL93FA012Accident · 2 fatalField investigationFinal reportPiper PA-12 · Cedar Springs, GAThe private pilot's failure to maintain airspeed above stalling speed, and his failure to maintain a proper altitude, which resulted in an inadvertent, low altitude stall. A factor was the gusty wind condition at the time of the accident.NTSB ANC92LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Kasilof, AKThe pilot in command's inadvertant power off stall entry resulting in the collision with the terrain.NTSB ANC92LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-150 · Upper Yantarni, AKPilot in command inadvertant encounter with aerodynamic stall during low level approach turn. Factor affecting the accident was: the pilot's approach procedure/technique to fly VFR approach pattern at 50 feet AGL.NTSB SEA92LA196Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cokeville, WYFatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.NTSB ANC92LA143Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Harding Lake, AKThe partial loss of engine power for undetermined causes, and the unsuitable terrain.NTSB ANC92LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Talkeetna, AKThe pilot's improper in flight planning/decision, and his premature touch down. Contributing to the accident were the downdraft and the unsuitable terrain.NTSB NYC92LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot diverted his attention from flying the airplane and did not maintain a visual lookout, which resulted in a collision with trees.NTSB ATL92LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Southport, NCThe failure of the pilot to maintain clearance from obstacles. A factor was the dusk lighting condition.NTSB ANC92LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kantishna, AKThe pilot in command's excessive taxi speed. Factors relating to the accident were the crosswind and dusk light conditions.NTSB MIA92LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bradenton, FLThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ANC92LA087Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Klutina Lake, AKThe pilo'ts poor inflight planning. Factors include downdrafts, and mountainous/ hilly terrain.NTSB ANC92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Heiden, AKEngine power loss for undetermined causes. Contributing to the accident was the unsuitable terrain.NTSB ANC92LA076Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Birchwood, AKThe loss of engine power for undetermined reasons. A factor relating to the accident was the pilot's intentional ground loop.NTSB ANC92LA081Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Port Bainbridge, AKCarburetor ice and the pilot's failure to follow procedure. A factor relating to the accident was the rough/uneven terrain in the forced landing area.NTSB BFO92LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Easton, PAThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control.NTSB CHI92LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Roscoe, ILOperation of an aircraft with known deficiencies and deterioration/failure of the magneto(s). Factors related to the accident were: the lack of an annual inspection and non-compliance with an airworthiness directive (AD).NTSB ANC91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKFuel contamination and the pilot's failure to perform an adequate preflight of the airplane. Contributing to the accident was the rough, uneven terrain of the tundra landing area.NTSB NYC91LA200Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Alton, NHThe pilot's improper use of carburetor heat, which resulted in a loss of engine power.NTSB ANC91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Palmer, AKThe pilot's failure to maintain airspeed and inadvertent stall during low level maneuvering flight. Contributing to the accident was the high terrain.NTSB ATL91LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe failure of the number 4 cylinder exhaust valve. Factors in the accident were the lack of a suitable landing site and the water ditching.NTSB CHI91LA213Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stockton, IACompensation for wind conditions not performed, wrong runway selected and aircraft control not maintained by the pilot. Factors related to the accident were a tailwind/crosswind component and a rough runway.NTSB ANC91LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Merrill Pass, AKThat the pilot failed to maintain an airspeed above stall speed. Contributing to the accident was the turbulence.NTSB ATL91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Conway, SCFailure of the number two exhaust valve, which resulted in loss of engine power.NTSB ANC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot-in-command's improper preflight and the contaminated fuel system. A factor was the rough, uneven terrain.NTSB MIA91LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Stuart, FLAn inadequate annual inspection which failed to detect corrosion on the rudder cable. The pilot lost direction control during landing when the rudder cable broke.NTSB ANC91LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's lack of currency with the type of landing gear involved.NTSB ANC91LA036Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Moose Creek, AKThe pilot-in-command's failure to maintain aircraft control, proper altitude not maintained, and failure to maintain flying speed. Contributing to the accident was the high altitude terrain.NTSB NYC90LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Franconia, NHThe landing of the airplane in unsuitable terrain, due to the mechanical failure of the engine center muffler baffle, which blocked the exhaust flow, resulting in a loss of power.NTSB ANC90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Healy, AKThe pilot-in-command's failure to maintian airspeed.NTSB ANC90LA190Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Cathedral Rapid, AKThe pilot's failure to maintain adequate altitude above the terrain which resulted in a loss of airspeed and a stall/spin while maneuvering to avoid terrain. The mountainous terrain, high winds, and high density altitude were factors which contributed to the…NTSB ANC90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kustatan River, AKThe pilot selected unsuitable terrain for landing. The terrain was a contributing factor.NTSB MIA90FA085Accident · 3 fatalField investigationFinal reportCessna 152 · Miramar, FLThe failure of the local controller to provide adequate traffic advisories to N7510H, the local controller's improper clearance to N7510H to descend through the traffic pattern, and the failure of the pilots of both aircraft to see and avoid each other.…NTSB ANC90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nome, AKThe failure of the left gear axle due to corrosion and fatigue.NTSB DEN90FA063Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Milliken, COThe pilot's poor judgement, intentional buzzing, and failure to see and avoid the obstruction (inadequate visual lookout). Factors related to the accident were: the power line and the absence of shoulder harnesses in the aircraft.NTSB LAX90LA052Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Placerville, CAThe student pilot's failure to maintain directional control.NTSB NYC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Palmyra, NYThe pilot failed to maintain airspeed during a tight closed pattern turn to final. Contributing factor(s) was: the pilot initiating flight into known adverse weather conditions, which included fog and reduced visibility.NTSB ANC89LA175Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cottonwood Crk, AKImproper inflight planning/decision by the pilot and his failure to maintain adequate airspeed. Factors related to the accident were: the pilot's low pass over rising terrain and the aircraft's subsequent impact with alder bushes (high vegetation).NTSB ANC89LA140Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Rainy Pass, AKPilot-in-command's failure to maintain control of the airplane during landing, due to misjudgement of airspeed and distance to the landing touch-down point.NTSB ANC89FA144Accident · 2 fatalField investigationFinal reportPiper PA-12 · Windy Fork, AKFailure of the pilot to maintain airspeed while operating to or from the gravel bar, which resulted in an inadvertent stall. The rising terrain was considered a contributing factor.NTSB FTW89FA127Accident · 2 fatalField investigationFinal reportPiper PA-12 · Sanger, TXFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall at low altitude.NTSB ANC89LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Anaktuvuk Pass, AKThe pilot failed to adequately compensate for downdrafts encountered after departing a gravel bar that was surrounded by mountainous terrain.NTSB ANC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot misjudged the approach and failed to maintain a proper descent rate. A related factor was trees.NTSB MKC89LA028Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lino Lakes, MNShortly after takeoff and climbing to about 150 AGL, the pilot said the engine began sputtering and losing power. Attempts to correct the situation by pumping the throttle and working the engine primer failed to correct the situation, and shortly thereafter…NTSB ANC89FA009Accident · 2 fatalField investigationFinal reportPiper PA-12 · Little Heart Lk, AKThe pilot-in-command called a local pilot in the talkeetna area for weather and the conditions of the lake to determine if the lake's surface had frozen. He then departed for the lake at 1800 adt and was not heard from again. The airplane wreckage was located…