NTSB investigations: Piper PA-12, MT
15 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 per year
| 1964 | 2 |
|---|---|
| 1966 | 1 |
| 1973 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2001 | 2 |
| 2010 | 1 |
| 2012 | 1 |
| 2018 | 1 |
| 2023 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA'
AND 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 WPR23LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Judith Gap, MTThe pilot's decision to take off on a soft field that exceeded the performance capabilities of the airplane, which resulted in an impact with a pole and terrain.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 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 WPR10CA380Accident · No injuriesData collectionFinal reportPiper PA-12 · White Sulphur Springs, MTThe pilot’s loss of directional control while attempting to avoid a herd of antelope crossing the runway during the landing rollout.NTSB SEA01FA106Accident · 1 fatalField investigationFinal reportPiper PA-12 · Augusta, MTThe pilot's failure to maintain adequate airspeed after takeoff resulting in an inadvertent stall at low a altitude.NTSB SEA01LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bozeman, MTThe pilot rated passenger's failure to maintain directional control during the landing. A factor was the snow berm which the aircraft rolled into during the landing.NTSB SEA94LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Nashua, MTAirspeed was not maintained. Factors include an inadvertent stall.NTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.NTSB DEN87FA234Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Anaconda, MTBoth plts were reportedly avid big horn sheep hunters. On the morning of the accident, the 2nd plt picked up topographical charts of the area where the acft crashed. It was an area where the Montana department of fish, wildlife, and parks (fwp) had recently…NTSB DEN87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Opheim, MTThe plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over.NTSB DEN83LA194Accident · No injuriesLimited investigationFinal reportPiper PA-12 · St. Xavier, MTThe acft collided with a fence during an attempted go-around in a field which was estimated to be 500 ft long. The wind was calm and the density alt was calculated to be 4900 ft. after landing and rolling 300 ft the plt decided he would not be able to stop.…NTSB SEA74DTI02Accident · No injuriesClosedPiper PA-12 · Ennis, MTNTSB SEA67F0129Accident · Minor injuriesClosedPiper PA-12 · Thomp. Falls, MTNTSB UNK64X3712Accident · No injuriesClosedPiper PA12 · Belgrade, MTNTSB UNK64X2962AccidentClosedPiper PA12 · Yellowstone, MT