NTSB investigations: Piper PA-12, WA
17 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 | 1 |
|---|---|
| 1967 | 1 |
| 1970 | 1 |
| 1974 | 1 |
| 1980 | 1 |
| 1993 | 1 |
| 1999 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2026 | 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\" = 'WA' 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" = 'WA' 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 WPR26LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Spanaway, WAThe pilot’s excessive application of brakes, which resulted in the airplane tipping forward onto its nose.NTSB WPR23LA356Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Eatonville, WAThe pilot's failure to maintain directional control during the takeoff roll, in gusty wind conditions, which resulted in a runway excursion.NTSB GAA19CA376Accident · No injuriesData collectionFinal reportPiper PA 12 · Yakima, WAThe separation of the left steering spring from the tailwheel assembly during landing for reasons that could not be determined, which resulted in a ground loop.NTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB WPR15CA095Accident · No injuriesData collectionFinal reportPiper PA 12 · Ridgefield, WAThe pilot's delayed action to use carburetor heat before the engine experienced a total loss of power while operating at cruise flight in conditions conducive to carburetor icing.NTSB WPR11CA007Accident · No injuriesData collectionFinal reportPiper PA-12 · Valley, WAThe pilot's excessive brake application during the landing roll after overshooting the intended touchdown point, resulting in a nose over.NTSB 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…NTSB SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.NTSB LAX07CA211Accident · Serious injuriesData collectionFinal reportPiper PA-12 · Mukilteo, WAFuel exhaustion resulting from the pilot's inadequate preflight inspection and failure to refuel the airplane, either before departure or at any of the alternate airports en route.NTSB SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.NTSB SEA00LA024Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Goldendale, WAThe pilot's failure to maintain directional control. A factor was a rock just off the edge of the runway surface.NTSB SEA94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orting, WAThe pilot in command's failure to maintain aircraft control.NTSB SEA80DYP24Accident · No injuriesClosedPiper PA-12 · Pasco, WANTSB SEA74DYE37Accident · No injuriesClosedPiper PA-12 · Blakely Isle, WANTSB SEA71DWG32Accident · No injuriesClosedPiper PA-12 · Cheney, WANTSB SEA67F0248Accident · No injuriesClosedPiper PA-12 · Bellevue, WANTSB UNK64X3920Accident · No injuriesClosedPiper PA12 · Inchelium, WA