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 GAA19CA385Accident · No injuriesData collectionFinal reportPiper PA 12 · Skwentna, AKThe pilot's use of excessive brakes during an aborted takeoff, which resulted in a nose-over.NTSB GAA19CA202Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Sisters, ORThe pilot's failure to maintain pitch control during the landing roll, which resulted in a nose-over.NTSB GAA19CA178Accident · No injuriesData collectionFinal reportPiper PA 12 · Mecosta, MIThe pilot's failure to maintain directional control during the landing roll, which resulted in impact with a windsock pole.NTSB GAA19CA125Accident · No injuriesData collectionFinal reportPiper PA 12 · Cedar City, UTThe pilot's failure to maintain pitch control while conducting a touch-and-go landing on an unimproved, snow-covered airstrip, which resulted in a nose-over.NTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB ANC19LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Willow, AKThe loss of engine power shortly after takeoff for reasons that could not be determined based on the available information, which resulted in an emergency landing and collision with trees.NTSB ANC18FA071Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Healy, AKAn impact with terrain for reasons that could not be determined based on the available information.NTSB GAA18CA535Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot’s failure to maintain pitch control on uneven terrain during the landing roll, which resulted in a nose-over.NTSB GAA18CA522Accident · No injuriesData collectionFinal reportPiper PA 12 · Rexburg, IDThe pilot's improper landing flare, which resulted in the airplane bouncing and a subsequent loss of directional control, a runway excursion, and impact with a fence.NTSB GAA18CA530Accident · No injuriesData collectionFinal reportPiper PA 12 · Edgewood, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA320Accident · No injuriesData collectionFinal reportPiper PA 12 · Nulato, AKThe pilot’s improper landing flare, which resulted in a hard landing on upsloping terrain, and his subsequent failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in…NTSB WPR18LA118Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Bozeman, MTThe student pilot and flight instructor's failure to see and avoid the stationary airplane during taxi, which resulted in a ground collision.NTSB CEN18LA071Accident · No injuriesLimited investigationFinal reportPiper PA 12 · Angleton, TXThe passenger's inadvertent activation of the left brake during landing, which resulted in a loss of directional control and a runway excursion.NTSB CEN18LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Dickinson, NDThe pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB GAA17CA527Accident · No injuriesData collectionFinal reportPiper PA 12 · Kotzebue, AKThe pilot’s failure to maintain directional control while landing on an unimproved airstrip in gusting wind conditions.NTSB GAA17CA511Accident · No injuriesData collectionFinal reportPiper PA 12 · Gulkana, AKThe pilot’s inadequate in-flight fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB GAA17CA387Accident · No injuriesData collectionFinal reportPiper PA 12 · Chickaloon, AKThe pilot’s improper landing flare on a turf runway, which necessitated a go-around during which he failed to establish a climb.NTSB ANC17LA033Accident · No injuriesClass 2 · LimitedFinal reportPiper PA 12 · Skwentna, AKThe pilot's failure to properly secure the external load, which resulted in the load shifting during flight, interference with the water rudder cable, and a subsequent loss of controlNTSB ERA17FA148Accident · 1 fatalField investigationFinal reportPiper PA 12 · Sanford, FLThe incorrect rigging of the elevator control cables, which resulted in a reversal of elevator control inputs applied by the pilot during the takeoff, an excessive nose-high pitch, and subsequent aerodynamic stall after takeoff. Also causal was the inadequate…NTSB GAA17CA193Accident · No injuriesData collectionFinal reportPiper PA 12 · Palmer, AKThe pilot’s failure to maintain directional control during takeoff, which resulted in a ground loop.NTSB GAA17CA188Accident · No injuriesData collectionFinal reportPiper PA 12 · Anchorage, AKThe pilot’s failure to maintain directional control during the taxi on skis on hard-packed snow in gusting wind conditions.NTSB GAA16CA347Accident · No injuriesData collectionFinal reportPiper PA 12 · Burnet, TXThe student pilot's failure to maintain adequate fuel levels, which resulted in fuel starvation, a loss of engine power, and a forced landing. Contributing to the accident was the flight instructor's failure to monitor the fuel levels.NTSB GAA16CA232Accident · No injuriesData collectionFinal reportPiper PA 12 · Simsbury, CTThe pilot's failure to attain the proper touchdown point and the airplane's subsequent impact with a fence during an attempted aborted landing.NTSB GAA16CA008Accident · No injuriesData collectionFinal reportPiper PA · Glennallen, AKThe pilot's failure to maintain clearance from trees during the approach to land, resulting in a collision with trees.NTSB GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.NTSB GAA15CA012Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Midland, TXThe pilot's excessive braking during the landing roll.NTSB ANC15LA010Accident · No injuriesLimited investigationFinal reportPiper PA 12 · Palmer, AKThe student pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s inadvertent switching of the fuel selector to the “off” position during the attempted engine restart.NTSB WPR15CA095Accident · No injuriesData collectionFinal reportPiper PA 12 · Ridgefield, WAThe pilot's delayed action to use carburetor heat before the engine experienced a total loss of power while operating at cruise flight in conditions conducive to carburetor icing.NTSB ANC14CA088Accident · No injuriesData collectionFinal reportPiper PA 12 · Holy Cross, AKThe pilot's selection of unsuitable terrain for takeoff/landing and failure to maintain control of the aircraft.NTSB ANC14CA072Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot's inadequate recovery from a bounced landing, resulting in a runway excursion and collision with trees.NTSB ANC14FA050Accident · 1 fatalField investigationFinal reportPiper PA 12 · Anchorage, AKThe incorrect (reverse) rigging of the elevator control cables, and the pilot’s inadequate preflight inspection, which failed to detect the misrigging.NTSB ERA14LA103Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Zephyrhills, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing that produced forces beyond the structural capability of the airframe.NTSB ANC13CA060Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot's loss of situational awareness, which resulted in a wrong turn into a box canyon, and an in flight collision with terrain.NTSB ANC12CA112Accident · No injuriesData collectionFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN12FA594Accident · 2 fatalField investigationFinal reportPiper PA-12 · Rye, COThe pilot’s selection of a flightpath toward rising terrain that exceeded the climb capability of the airplane.NTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.NTSB ANC12CA072Accident · No injuriesData collectionFinal reportPiper PA-12 · Quinhagak, AKThe pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.NTSB WPR12CA293Accident · No injuriesData collectionFinal reportPiper PA-12 · Stevensville, MTThe separation of the left rudder control cable from the rudder bellcrank, which resulted in a loss of directional control during landing roll.NTSB ANC11CA113Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot’s decision to take off from an off-airport site in variable wind.NTSB ANC11CA106Accident · No injuriesData collectionFinal reportPiper PA-12 · Beluga, AKThe pilot's decision to take off uphill into rising terrain.NTSB ANC11CA097Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's misidentification of the runway environment in dusk light conditions.NTSB ANC11CA094Accident · No injuriesData collectionFinal reportPiper PA-12 · North Pole, AKThe pilot's failure to maintain adequate airspeed during takeoff, resulting in an aerodynamic stall and collision with the water.NTSB WPR11FA334Accident · Serious injuriesField investigationFinal reportPiper PA-12 · Joshua Tree, CAThe pilot's decision to conduct low altitude flight at a high density altitude and into a box canyon, which resulted in the airplane colliding with rising terrain when its climb capability was exceeded.NTSB ANC11FA065Accident · 1 fatalField investigationFinal reportPiper PA-12 · Delta, AKThe pilot's decision to make a low-altitude turn back to the airport following a loss of engine power, which resulted in an aerodynamic stall and loss of control. Contributing to the severity of the pilot's injuries was the separation of the pilot's seat…NTSB ANC11CA063Accident · No injuriesData collectionFinal reportPiper PA-12 · Gulkana, AKThe pilot's inadequate recovery from a bounced landing.NTSB ANC11CA033Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate preflight inspection, resulting in a departure with the fuel selector in the "off" position, a subsequent loss of engine power, and an off-airport emergency landing.NTSB ANC11CA025Accident · No injuriesData collectionFinal reportPiper PA-12 · Delta Junction, AKThe pilot's misjudged altitude while landing in bright sunlight on an airstrip surrounded by snow, resulting in an undershoot and a nose over.NTSB ERA11CA134Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Sebago Lake, METhe pilot’s initiation of a right turn with insufficient altitude remaining during an aborted landing resulting in a collision with the landing surface.NTSB ANC11CA003Accident · No injuriesData collectionFinal reportPiper PA-12 · Merrill Field Airport, AKThe certificated flight instructor's failure to apply the correct remedial actions to maintain directional control during the takeoff roll.