Skip to content

NTSB investigations: Piper PA-12, MN

25 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

19642026

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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 WPR26LA316Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Bemidji, MNAug 21, 2026 · N7524H · Substantial damage NTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Aug 28, 2009 · N2409M · Substantial damage NTSB CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…Sep 26, 2007 · N2560M · Substantial damage NTSB CHI04LA285Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Perham, MNThe dual student's improper compensation for the crosswind condition and his subsequent failure to maintain control of the airplane. An additional cause was the flight instructor's inadequate remedial action. A contributing factor was the crosswind condition.Sep 29, 2004 · N7977H · Substantial damage NTSB CHI01LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Stillwater, MNThe loss of engine power for undermined reasons and the unsuitable terrain encountered during the forced landing. Additional factors included the power line and the trees.Jul 7, 2001 · N78495 · Substantial damage 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.Feb 2, 1993 · N3854M · Substantial damage 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…Nov 20, 1988 · N12MZ · Substantial damage NTSB CHI83LA252Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Blackduck, MNThe acft made a hard landing in an alfalfa field after loss of engine power. During an enroute portion of this flt the pilot stated that oil consumption was excessive. He planned an intermediate stop for that reason. Before reaching the intermediate stop the…Jun 12, 1983 · N2487M · Substantial damage NTSB CHI81DER18Accident · No injuriesClosedPiper PA-12 · Kelliher, MNFeb 15, 1981 · N2560M · Substantial damage NTSB MKC78FER53Accident · No injuriesClosedPiper PA-12 · St Cloud, MNJun 11, 1978 · N3138M · Substantial damage NTSB MKC73AK060Accident · 2 fatalClosedPiper PA-12 · Bock, MNApr 8, 1973 · N7705H · Destroyed NTSB MKC72DER49Accident · No injuriesClosedPiper PA-12 · Duluth, MNApr 1, 1972 · N3752M · Substantial damage NTSB MKC72DER36Accident · No injuriesClosedPiper PA-12 · Silver Bay, MNFeb 5, 1972 · N7644H · Substantial damage NTSB MKC70D0099Accident · No injuriesClosedPiper PA-12 · Pipestone, MNJul 20, 1969 · N4009M · Substantial damage NTSB MKC69F0277Accident · No injuriesClosedPiper PA-12 · Bagley, MNOct 6, 1968 · N2995M · Substantial damage NTSB MKC69D0190Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNSep 20, 1968 · N3007M · Substantial damage NTSB MKC69D0028Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNApr 28, 1968 · N3643M · Substantial damage NTSB MKC68F0335Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNNov 14, 1967 · N3017M · Substantial damage NTSB MKC68D0276Accident · No injuriesClosedPiper PA-12 · Pipestone, MNOct 19, 1967 · N4061M · Substantial damage NTSB MKC68F0204Accident · Minor injuriesClosedPiper PA-12 · Cloquet, MNAug 27, 1967 · N2453M · Destroyed NTSB MKC66F0437Accident · No injuriesClosedPiper PA-12 · Appleton, MNFeb 16, 1966 · N2511M · Substantial damage NTSB MKC66F0410Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNDec 18, 1965 · N78480 · Substantial damage NTSB MKC66D0183Accident · No injuriesClosedPiper PA-12 · Pipestone, MNAug 6, 1965 · N4061M · Substantial damage NTSB MKC66F0083Accident · No injuriesClosedPiper PA-12 · Spring Valley, MNJun 17, 1965 · N7752H · Substantial damage NTSB UNK64X1578Accident · No injuriesClosedPiper PA12 · Anoka, MNMay 2, 1964 · N78546 · Substantial damage