NTSB investigations: Piper PA-12, GA

9 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

NTSB investigations: Piper PA-12, GA per year, 1964–2026: 9 cases
1964	1
1965	2
1966	1
1968	1
1969	2
1980	1
1992	1

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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ATL93FA012Accident · 2 fatalField investigationFinal reportPiper PA-12 · Cedar Springs, GAThe private pilot's failure to maintain airspeed above stalling speed, and his failure to maintain a proper altitude, which resulted in an inadvertent, low altitude stall. A factor was the gusty wind condition at the time of the accident.Oct 17, 1992 · N2479M · Destroyed NTSB MIA80FKG15Accident · Serious injuriesClosedPiper PA-12 · Columbus, GAJan 20, 1980 · N2684M · Substantial damage NTSB MIA69A0086Accident · 2 fatalClosedPiper PA-12 · Villa Rica, GAJun 7, 1969 · N2366M · Destroyed NTSB MIA69F0471Accident · No injuriesClosedPiper PA-12 · Tunnel Hill, GAApr 29, 1969 · N3767M · Substantial damage NTSB MIA69F0150Accident · Minor injuriesClosedPiper PA-12 · Portal, GAJul 11, 1968 · N4097M · Destroyed NTSB MIA66F0440Accident · Minor injuriesClosedPiper PA-12 · Forsyth, GAFeb 3, 1966 · N2782M · Substantial damage NTSB MIA65F0064Accident · Minor injuriesClosedPiper PA-12 · Chamblee, GAMay 1, 1965 · N98955 · Destroyed NTSB UNK65X1438Accident · Serious injuriesClosedPiper PA-12 · Dawson, GAFeb 19, 1965 · N7712H · Substantial damage NTSB UNK64X3420Accident · No injuriesClosedPiper PA12 · Carrolton, GAAug 16, 1964 · N2846M · Substantial damage