NTSB investigations: Piper PA-12, SC
13 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.
Cases per year
| 1970 | 2 |
|---|---|
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1991 | 2 |
| 1995 | 1 |
| 1998 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2022 | 1 |
| 2023 | 1 |
Where
Open the mapLatest 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.\"eventStateOrRegion\" = 'SC' 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" = 'SC' 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" DESCRun 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 ERA23LA356Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA22FA243Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · North Myrtle Beach, SCThe pilot's exceedance of the airplane's critical angle of attack, which resulted in a subsequent aerodynamic stall at an altitude that was too low for recovery.NTSB ERA09CA275Accident · No injuriesData collectionFinal reportPiper PA-12 · Georgetown, SCThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot’s lack of experience in the make and model airplane.NTSB MIA08LA158Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ATL98LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe pilot's inadequate preflight planning of fuel required for the flight that resulted in fuel exhaustion and the total loss of engine power. A factor was the pilot continued flight operation with known deficiencies in equipment.NTSB ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.NTSB ATL91LA125Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Myrtle Beach, SCThe failure of the number 4 cylinder exhaust valve. Factors in the accident were the lack of a suitable landing site and the water ditching.NTSB ATL91LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Conway, SCFailure of the number two exhaust valve, which resulted in loss of engine power.NTSB MIA79FLG05Accident · No injuriesClosedPiper PA-12 · N.Myrtle Bch, SCNTSB MIA75AM019Accident · 2 fatalClosedPiper PA-12 · Summerville, SCNTSB MIA73DLG40Accident · No injuriesClosedPiper PA-12 · Kinards, SCNTSB MIA70DLG23Accident · Minor injuriesClosedPiper PA-12 · Mt Pleasant, SCNTSB MIA70FLG06Accident · No injuriesClosedPiper PA-12 · Calhoun Falls, SC