NTSB investigations: Piper PA-12, 1983
14 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 | 41 |
|---|---|
| 1965 | 38 |
| 1966 | 39 |
| 1967 | 33 |
| 1968 | 34 |
| 1969 | 30 |
| 1970 | 24 |
| 1971 | 26 |
| 1972 | 24 |
| 1973 | 22 |
| 1974 | 21 |
| 1975 | 18 |
| 1976 | 22 |
| 1977 | 13 |
| 1978 | 15 |
| 1979 | 10 |
| 1980 | 14 |
| 1981 | 14 |
| 1982 | 12 |
| 1983 | 14 |
| 1984 | 15 |
| 1985 | 10 |
| 1986 | 7 |
| 1987 | 14 |
| 1988 | 10 |
| 1989 | 7 |
| 1990 | 7 |
| 1991 | 12 |
| 1992 | 17 |
| 1993 | 10 |
| 1994 | 18 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 14 |
| 1998 | 7 |
| 1999 | 9 |
| 2000 | 7 |
| 2001 | 12 |
| 2002 | 6 |
| 2003 | 8 |
| 2004 | 6 |
| 2005 | 4 |
| 2006 | 8 |
| 2007 | 10 |
| 2008 | 6 |
| 2009 | 9 |
| 2010 | 9 |
| 2011 | 10 |
| 2012 | 6 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 5 |
| 2016 | 2 |
| 2017 | 9 |
| 2018 | 8 |
| 2019 | 9 |
| 2020 | 6 |
| 2021 | 5 |
| 2022 | 7 |
| 2023 | 9 |
| 2024 | 4 |
| 2025 | 6 |
| 2026 | 8 |
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 year(c.\"eventDate\") = 1983
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 year(c."eventDate") = 1983
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 MIA84FA049Accident · 1 fatalField investigationFinal reportPiper PA-12 · Ft. Lauderdale, FLThe acft crashed on the arpt in a steep nose down attitude after dropping a banner it was towing. The plt waved to the ground personnel and turned in a 60 degree bank nose high turn. After 180 degrees of turn the acft stalled, the nosefell through and the…NTSB ANC84IA009Incident · No injuriesIncident investigationFinal reportPiper PA-12 · Anchorage, AKThe plt reported the floats had just been removed from the acft & that he made this flt to refamiliarize himself with flying it with wheels again. After making about 10 touch-go-go landings, the plt elected to make a full stop landing. He reported that after…NTSB CHI84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · East Liverpool, OHThe plt stated that while landing on a downhill grass strip he touched down long. While attempting to apply brakes, the heel of his boot got caught under the rudder pedal & he was unable to stop the acft before it went off the end of the strip down a steep…NTSB ANC83LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Wasilla, AKAccording to the pilot the engine started running intemittently after he was over trees at the departure end of the runway. The engine stopped and the pilot set up for and accomplished a forced landing. After the accident the pilot and a mechanic found water…NTSB ANC83FA177Accident · No injuriesField investigationFinal reportPiper PA-12 · Anchorage, AKWhile approaching merrill field the eng quit. The acft landed on a city road & the gear collapsed. The wx in the vicinity of the accident site had marginal conditions with both rain & fog. The temp/dew point spread was 2 deg f. the plt attributed the eng…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 DEN83LA194Accident · No injuriesLimited investigationFinal reportPiper PA-12 · St. Xavier, MTThe acft collided with a fence during an attempted go-around in a field which was estimated to be 500 ft long. The wind was calm and the density alt was calculated to be 4900 ft. after landing and rolling 300 ft the plt decided he would not be able to stop.…NTSB ANC83LA116Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe acft was damaged while making a forced landing after the engine stopped. The pilot said he was at 1200 feet near point mackenzie when the engine started running rough. The engine stopped operating a few seconds later. The pilot said he had trouble…NTSB FTW83LA306Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · El Paso, TXThe plt was practicing touch-&-go landings & stated that he had been flying with the mixture leaned. After a landing, he applied full throttle, but the eng coughed & sputtered. He then advance the mixture to rich to correct the situation. At about the same…NTSB CHI83LA252Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Blackduck, MNThe acft made a hard landing in an alfalfa field after loss of engine power. During an enroute portion of this flt the pilot stated that oil consumption was excessive. He planned an intermediate stop for that reason. Before reaching the intermediate stop the…NTSB ANC83LA077Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Aniak, AKAccording to the plt, he was taking off downslope & downwind on bumpy muskeg/tundra with full flaps. At aprx 40 to 45 mph, the acft lifted off before reaching the edge of a deep ravine. He began a shallow left turn, then the left wing struck a tree which spun…NTSB ANC83FA064Accident · 2 fatalField investigationFinal reportPiper PA-12 · Glennallen, AKWitnesses reported that after takeoff, the plt flew by a cabin at approximately 200 ft, signaled by rocking the acft's wings, then began a gradual climb. The climb increased in steepness until 1 witness could see the entire top of the acft. It then nosed…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…NTSB ANC83LA039Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe student plt stated that on the landing roll with a 7 kt right x-wind, the acft began drifting to the left. Reportedly, he tried to correct with right rudder, but the fire extinguisher had come loose & became jammed under the right rudder pedal.…