NTSB investigations: Piper PA-12
12 cases on aircraft the registry lists as Piper PA-12, where the first occurrence was “On ground/water encounter 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2006 | 1 |
| 2007 | 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\" = 320))
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" = 320))
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 CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…NTSB ANC06CA132Accident · No injuriesData collectionFinal reportPiper PA-12 · Noatak, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control during the landing roll and a nose over. Factors associated with the accident were soft terrain and the pilot's failure to maintain directional control.NTSB ANC00LA058Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of an unsuitable taxi area, and excessive taxi speed. A factor associated with this accident was a ditch in the taxi area.NTSB ANC99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing the wheel equipped airplane. A factor associated with the accident was the soft snow covering the frozen lake.NTSB ANC98LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tyonek, AKThe aircraft's left wheel encountering a hole as the pilot taxied from landing and his inadequate compensation for wind conditions. Contributing factors were the rough terrain and gusty wind condition.NTSB ANC98LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chugiak, AKThe pilot's inadvertent ground loop of the airplane during the landing roll.NTSB ANC98LA007Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's selection of an unsuitable landing area.NTSB ANC97LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kotzebue, AKthe pilot's selection of unsuitable terrain for taxi and takeoff. Soft/snow covered terrain was a related factor.NTSB ANC96LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chitina, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven landing site.NTSB ANC94LA063Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot's selection of an unsuitable landing area.NTSB DEN87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Opheim, MTThe plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over.NTSB ANC84LA129Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hope, AKThe acft collided with a ditch alongside a short strip used by hunters and fishermen. During interviews with the plt it was revealed that the acft was overloaded and out of CG. During the takeoff the plt decided to abort after passing his decision point but…