Skip to content

NTSB investigations: Piper PA-12, ID

23 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19682026

Where

Latest cases

Query with SQL

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" = 'ID' 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

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\" = 'ID' 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" = 'ID' 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

Run 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 WPR26LA234Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Dixie, IDThe pilot's delayed decision to initiate a go-around and subsequent failure to maintain clearance from rising terrain.Jun 23, 2026 · N3013M · Substantial damage NTSB WPR25LA026Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Aberdeen, IDThe pilot’s failure to maintain back pressure on the control stick during a landing attempt on gravel, which resulted in a nose over.Oct 25, 2024 · N2524M · Substantial damage 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.Sep 2, 2018 · N4077M · Substantial damage 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.Jul 14, 2015 · N3795M · Substantial damage NTSB SEA07CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Lewiston, IDthe inadvertent use of the rudder by the passenger, which resulted in an inadvertent ground loop.Feb 23, 2007 · N2343M · Substantial damage NTSB SEA97FA206Accident · 1 fatalField investigationFinal reportPiper PA-12 · Horseshoe Bend, IDthe pilot's failure to maintain clearance from transmission wires. The wires were a factor.Sep 9, 1997 · N3637M · Destroyed NTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.Jan 21, 1994 · N7805H · Substantial damage 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.Oct 25, 1992 · N3743M · Destroyed NTSB SEA87LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Sun Valley, IDAfter landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence.Jul 5, 1987 · N3438M · Substantial damage NTSB SEA83LA001Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Salmon, IDThe plt reported that the strip had about 1,500 ft of usable length, the remaining 3,050 ft consisted of unpacked snow &slush. The usable width of the first 1,500 ft was reported as 8-12 ft. at the time of takeoff the first 1,500 ft was covered with hard…Sep 30, 1982 · N2343M · Substantial damage NTSB SEA81FA011Accident · 2 fatalClosedPiper PA-12 · Rexburg, IDDec 12, 1980 · N78709 · Destroyed NTSB SEA77DYA23Accident · No injuriesClosedPiper PA-12 · Marsing, IDJun 4, 1977 · N4018H · Substantial damage NTSB SEA76DYG59Accident · Minor injuriesClosedPiper PA-12 · Worley, IDJun 30, 1976 · N3131M · Substantial damage NTSB SEA7KDYA40Accident · No injuriesClosedPiper PA-12 · Homedale, IDMay 11, 1975 · N4018H · Destroyed NTSB SEA75DYA22Accident · No injuriesClosedPiper PA-12 · Mccall, IDSep 20, 1974 · N3729M · Substantial damage NTSB SEA72DYA41Accident · No injuriesClosedPiper PA-12 · Middleton, IDJun 28, 1972 · N4401M · Substantial damage NTSB SEA72DYA02Accident · No injuriesClosedPiper PA-12 · Wendell, IDJul 18, 1971 · N3580M · Substantial damage NTSB SEA71FXM09Accident · Serious injuriesClosedPiper PA-12 · Rigby, IDSep 4, 1970 · N2965M · Destroyed NTSB SEA68D0309Accident · No injuriesClosedPiper PA-12 · Grangeville, IDMay 22, 1968 · N2402M · Substantial damage NTSB SEA68D0273Accident · No injuriesClosedPiper PA-12 · Cascade, IDMar 31, 1968 · N3729M · Substantial damage NTSB SEA68D0255Accident · No injuriesClosedPiper PA-12 · Driggs, IDMar 3, 1968 · N2965M · Substantial damage NTSB SEA68D0243Accident · No injuriesClosedPiper PA-12 · Mccall, IDFeb 6, 1968 · N2577M · Substantial damage NTSB SEA68D0248Accident · No injuriesClosedPiper PA-12 · Elk River, IDFeb 3, 1968 · N2505M · Substantial damage