Skip to content

NTSB investigations: Piper PA-12, CA

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

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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 GAA19CA586Accident · No injuriesData collectionFinal reportPiper PA 12 · Williams, CAThe pilot's over application of power during recovery from a runway excursion, which resulted in a ground loop and nose over.Sep 27, 2019 · N3985M · Substantial damage NTSB WPR11FA334Accident · Serious injuriesField investigationFinal reportPiper PA-12 · Joshua Tree, CAThe pilot's decision to conduct low altitude flight at a high density altitude and into a box canyon, which resulted in the airplane colliding with rising terrain when its climb capability was exceeded.Jul 18, 2011 · N7510H · Substantial damage NTSB SEA08CA056Accident · No injuriesData collectionFinal reportPiper PA-12 · Santa Ana, CAThe failure of the student to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.Dec 31, 2007 · N2800D · Substantial damage NTSB LAX00FA122Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cima, CAIn-flight collision with terrain for undetermined reasons.Mar 7, 2000 · N7586H · Destroyed NTSB LAX94LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Riverside, CAa total loss of engine power for undetermined reasons.Aug 19, 1994 · N3415M · Substantial damage NTSB LAX90LA052Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Placerville, CAThe student pilot's failure to maintain directional control.Dec 16, 1989 · N3266M · Substantial damage NTSB LAX81DVG48Accident · No injuriesClosedPiper PA-28 · Georgetown, CAJun 28, 1981 · N2087C · Substantial damage NTSB LAX81FA098Accident · 1 fatalClosedPiper PA-12 · Five Points, CAJun 23, 1981 · N12PA · Destroyed NTSB LAX81DVG08Accident · No injuriesClosedPiper PA-12 · Lincoln, CADec 10, 1980 · N4218M · Substantial damage NTSB LAX80FUQ23Accident · No injuriesClosedPiper PA-12 · Van Nuys, CAAug 19, 1980 · N3164M · Substantial damage NTSB LAX80FUG16Accident · Serious injuriesClosedPiper PA-12 · Beaumont, CAJan 12, 1980 · N92795 · Destroyed NTSB LAX74FUM39Accident · Serious injuriesClosedPiper PA-12 · Escondido, CAJun 21, 1974 · N3200M · Substantial damage NTSB LAX73DUG55Accident · No injuriesClosedPiper PA-12 · Rialto, CAMay 27, 1973 · N2555M · Substantial damage NTSB LAX73DUG16Accident · No injuriesClosedPiper PA-12 · Idyllwild, CASep 6, 1972 · N4166M · Substantial damage NTSB OAK71DVA15Accident · No injuriesClosedPiper PA-12 · Fresno, CAAug 3, 1970 · N2392M · Substantial damage NTSB OAK70F0210Accident · Minor injuriesClosedPiper PA-18 · Mariposa, CADec 26, 1969 · N999E · Destroyed NTSB LAX70F0152Accident · Serious injuriesClosedPiper PA-12 · 29 Palms, CASep 18, 1969 · N4439M · Substantial damage NTSB LAX69F0011Accident · Serious injuriesClosedPiper PA-12 · Compton, CAJun 2, 1968 · N3876M · Destroyed NTSB LAX68D0378Accident · No injuriesClosedPiper PA-12 · Bakersfield, CAApr 5, 1968 · N7735H · Substantial damage NTSB OAK68D0096Accident · No injuriesClosedPiper PA-12 · Modesto, CAAug 22, 1967 · N2392M · Substantial damage NTSB LAX66F0326Accident · Serious injuriesClosedPiper PA-12 · Iverside, CAApr 26, 1966 · N3786M · Substantial damage NTSB LAX65D0010Accident · No injuriesClosedPiper PA-12 · Alpine, CAFeb 7, 1965 · N4053H · Substantial damage NTSB UNK64X0351Accident · No injuriesClosedPiper PA12 · Hawthorn, CAJan 25, 1964 · N78532 · Substantial damage