NTSB investigations: Piper PA-12, PA
12 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
| 1964 | 2 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1970 | 1 |
| 1974 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 2002 | 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\" = 'PA' 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" = 'PA' 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 NYC02LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Clifford, PAThe pilot's failure to maintain a proper visual lookout for trees. A factor was sunglare.NTSB BFO94LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Germansville, PAThe pilot failed to maintain a proper descent rate which resulted in an undershoot.NTSB BFO92LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Easton, PAThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control.NTSB NYC83LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bernville, PAThe pilot reported that the plane crashed after the right wing tip hit the top of a tree during landing. He reported that he had flown only 2 hrs in the last 90 days. He noted that this was only a 13 minute flight. He thought that he would have been more…NTSB NYC81FA036Accident · Serious injuriesClosedPiper PA-12 · Leroy Township, PANTSB NYC74FGM37Accident · No injuriesClosedPiper PA-12 · Mt Pleasant, PANTSB NYC71DHA10Accident · Minor injuriesClosedPiper PA-12 · Lehighton, PANTSB NYC67F0317Accident · Minor injuriesClosedPiper PA-12 · Clarks Summit, PANTSB NYC67F0139Accident · No injuriesClosedPiper PA-12 · Annville, PANTSB NYC65A0121Accident · 2 fatalClosedPiper PA-12 · Watsontown, PANTSB UNK64X1371Accident · No injuriesClosedPiper PA12 · Morrisville, PANTSB UNK64X0478Accident · No injuriesClosedPiper PA-12 · Bolivar, PA