Fatal NTSB investigations: Piper PA-12

7 cases on aircraft the registry lists as Piper PA-12, where the sequence of events included Loss of control in flight. 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

20092026
Fatal NTSB investigations: Piper PA-12 per year, 2009–2026: 7 cases
20092
20111
20121
20223

Latest 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.\"highestInjuryLevel\" = 'Fatal'
    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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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.

NTSB ANC22FA066Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Arctic Village, AKThe pilot’s decision to depart in turbulent and gusting wind conditions, which resulted in a loss of control and impact with terrain.Aug 11, 2022 · N3937M · Substantial damageNTSB ERA22FA315Accident · 1 fatalClass 3 · FieldFinal reportPiper PA12 · Middle Township, NJThe pilot’s exceedance of the airplane’s critical angle of attack during a missed banner pickup, which resulted in an aerodynamic stall/spin and loss of control at an altitude too low to recover.Jul 16, 2022 · N3703M · Substantial damageNTSB CEN22FA211Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Seagraves, TXThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and loss of control.May 24, 2022 · N78466 · DestroyedNTSB 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.Aug 31, 2012 · N3031M · Substantial damageNTSB 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…Jul 17, 2011 · N92770 · Substantial damageNTSB WPR10FA009Accident · 1 fatalField investigationFinal reportPiper PA-12 · Burlington, WAThe pilot's in-flight loss of control due to his failure to correctly connect the elevator control cables during the restoration/rebuild of the airplane. Contributing to this accident was the pilot's decision to perform a high-speed taxi test prior to having…Oct 8, 2009 · N2087C · Substantial damageNTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…Sep 22, 2009 · N3234M · Substantial damage