NTSB investigations: Piper PA-12, ME

11 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

19672026

NTSB investigations: Piper PA-12, ME per year, 1967–2026: 11 cases
1967	2
1969	1
1987	1
1997	1
2001	1
2006	1
2011	1
2020	1
2023	2

Where

Open the map

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" = 'ME' 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\" = 'ME' 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" = 'ME' 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 ERA24LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Rangeley, METhe pilot’s failure to maintain directional control during the landing roll with a crosswind, after the right tailwheel spring separated.Oct 27, 2023 · N3910M · Substantial damage NTSB ERA23LA133Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Ebeemee Township, MEA partial power loss of engine power during initial climb for undetermined reasons.Feb 25, 2023 · N4433M · Substantial damage NTSB ERA20CA268Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Linconville, METhe pilot's improper landing flare, which resulted in a bounced landing and subsequent main landing gear collapse.Jul 18, 2020 · N4365M · Substantial damage 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.Feb 5, 2011 · N3806M · Substantial damage NTSB NYC06LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Orient, METhe pilot's failure to maintain adequate airspeed during the initial climb which resulted in an inadvertent stall. A factor was his inadequate weight and balance calculations and the gusty wind conditions.Sep 22, 2006 · N4459M · Destroyed NTSB NYC02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Ashland, METhe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Oct 2, 2001 · N2528M · Substantial damage NTSB NYC97LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clayton Lake, MEthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall, and uncontrolled descent to the frozen lake surface.Mar 28, 1997 · N2852M · Destroyed NTSB NYC87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencer Lake, METhe flight originated at Spencer Lake and flew north then south to baker lake. South of hedgehog mountain the flight encountered downdrafts and a loss of altitude at 500-600 feet per minute. Upon turning right to return to Spencer Lake the aircraft continued…Jul 16, 1987 · N4202M · Substantial damage NTSB NYC70F0207Accident · No injuriesClosedPiper PA-12S · Raymond, MENov 15, 1969 · N3932M · Destroyed NTSB NYC68A0009Accident · 4 fatalClosedPiper PA-12 · Soldier Pond, MEJul 19, 1967 · N2867M · Destroyed NTSB NYC67D0549Accident · No injuriesClosedPiper PA-12 · Fairfield, MEMar 3, 1967 · N4345M · Substantial damage