NTSB investigations: Piper PA-12
11 cases on aircraft the registry lists as Piper PA-12, where the first occurrence was “In flight collision with terrain/water”. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1992 | 2 |
| 1994 | 2 |
| 1998 | 1 |
| 2000 | 3 |
| 2006 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101202')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101202')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 ANC06CA110Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Coldfoot, AKThe pilot's selection of an unsuitable landing area, which resulted in an in-flight collision with terrain during an aborted landing. Factors associated with the accident were wind gusts, and rough and uneven terrain.NTSB ANC00LA095Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilots selection of unsuitable terrain for landing. A factor was high brush along side the landing area.NTSB ANC00LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Delta Junction, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB LAX00FA122Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cima, CAIn-flight collision with terrain for undetermined reasons.NTSB ANC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of a proper touchdown point. Factors associated with the accident were darkness, and the pilot's inadequate preflight planning.NTSB ANC94LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's inadequate in-flight planning and a failure to maintain directional control of the airplane. Factors were the rising, rough/uneven terrain and the tailwind.NTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.NTSB ANC92LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Kasilof, AKThe pilot in command's inadvertant power off stall entry resulting in the collision with the terrain.NTSB ANC92LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-150 · Upper Yantarni, AKPilot in command inadvertant encounter with aerodynamic stall during low level approach turn. Factor affecting the accident was: the pilot's approach procedure/technique to fly VFR approach pattern at 50 feet AGL.NTSB ANC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot misjudged the approach and failed to maintain a proper descent rate. A related factor was trees.NTSB FTW88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Brownsville, TXWhile circling an unlighted private airstrip, the pilot allowed the aircraft to descend into 2 feet of water causing substantial damage.