NTSB investigations: Piper PA-12
11 cases on aircraft the registry lists as Piper PA-12, where the first occurrence was “In flight encounter with weather”. 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
| 1983 | 2 |
|---|---|
| 1984 | 3 |
| 1987 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 2001 | 2 |
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\" = 240))
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" = 240))
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 DEN01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, COthe pilot's inadequate wind evaluation, and his inadequate planning/decision to land with a tailwind, at a density altitude of 13,418 feet. Contributing factors were the tailwind and the high density altitude weather condition.NTSB ANC01LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's continued VFR flight into instrument metrological conditions during cruise flight. Factors associated in the accident were low ceilings, whiteout conditions, and snow-covered terrain.NTSB ANC91LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Merrill Pass, AKThat the pilot failed to maintain an airspeed above stall speed. Contributing to the accident was the turbulence.NTSB NYC90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Palmyra, NYThe pilot failed to maintain airspeed during a tight closed pattern turn to final. Contributing factor(s) was: the pilot initiating flight into known adverse weather conditions, which included fog and reduced visibility.NTSB ANC87LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot related that he ran out of fuel enroute to his planned refueling stop and made an emergency landing on a highway, substantially damaging the airplane. He said that the enroute portion of his flight took much longer than anticipated due to strong…NTSB NYC87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencer Lake, METhe flight originated at Spencer Lake and flew north then south to baker lake. South of hedgehog mountain the flight encountered downdrafts and a loss of altitude at 500-600 feet per minute. Upon turning right to return to Spencer Lake the aircraft continued…NTSB SEA84LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Juneau, AKOver a mountain pass the acft encountered turbulence the plt described as 'severe'. The acft lost 500 to 1,000 ft and turned 180 deg. A 180 deg climbing turn was initiated and the acft again flew into the turbulence. After the second encounter aileron and…NTSB ANC84FA120Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cantwell, AKImpact occurred at the 3,600 ft level on a steep slope of mountainous terrain. Instrument meteorological conditions were reported by pilots as well as ground personnel in the area. Loose and unstable terrain conditions limited the investigative effort.NTSB DEN84LA132Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Jackson, WYThe acft crashed during takeoff from Jackson airport. Investigation revealed that the plt and CFI were in the process of ferrying the acft to Washington state. The plt stated that during taxi the airport UNICOM reported the wind to be from the northeast at 18…NTSB ANC83LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe acft collided with a ridgeline when the pilot attempted to fly through a pass. The pass was crested at about 3600 ftsurrounded by elevations of over 8000 ft MSL. The pilot stated that he was attempting to get through merrill pass because of hunters that…NTSB DEN83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Coalville, UTThe acft nosed over during an precautionary landing due to deteriorating weather. The plt had received a weather briefing. The wx conditions deteriorated enroute due to a snow storm and the plt elected to land on a private strip to await improved weather. The…