NTSB investigations: Piper PA-12, 1988
10 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\") = 1988
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") = 1988
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 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 MKC89LA028Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lino Lakes, MNShortly after takeoff and climbing to about 150 AGL, the pilot said the engine began sputtering and losing power. Attempts to correct the situation by pumping the throttle and working the engine primer failed to correct the situation, and shortly thereafter…NTSB ANC89FA009Accident · 2 fatalField investigationFinal reportPiper PA-12 · Little Heart Lk, AKThe pilot-in-command called a local pilot in the talkeetna area for weather and the conditions of the lake to determine if the lake's surface had frozen. He then departed for the lake at 1800 adt and was not heard from again. The airplane wreckage was located…NTSB MKC88LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bertrand, NEThe plt rprtd that while practicing takeoffs & ldgs, he believed he had excessive ground speed & elected to go around. He said he waited to long to go around, so he decided to fly under power lines, located at the dep end of the strip. Shortly after lift-off,…NTSB ANC88LA142Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Figure 8 Lake, AKThe pilot-in-command was landing in one foot tall grass near a duck hunting shack and struck a log. He landed the airplane after striking the log and during the landing roll, the main landing gear collapsed. The plt stated that he overflew the lndg area and…NTSB ANC88LA133Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe private pilot stated that he was attempting to land on a gravel bar when the airplane encountered a soft spot and nosed over. He said that a contributing factor in the accident was that he had applied his brakes too strongly early in the landing roll, and…NTSB ANC88LA115Accident · No injuriesLimited investigationFinal reportPiper PA-12 · King Mountain, AKThe pilot-in-command was maneuvering through a valley for the second time. During the second pass the engine lost power. Mixture was full rich, and the pilot applied carburetor heat and when nothing happened he turned the carburetor heat off. He attempted a…NTSB NYC88LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Georges Mills, NHWitnesses reported the wind was gusty and there were whitecaps on the lake when the acft attempted to takeoff. The plt said that when the acft had climbed to a sufficient altitude he began a left turn to climb over the lake. After the turn was started the…NTSB ANC88LA112Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Galena, AKThe student pilot lost directional control of the airplane during landing on the tundra. During the rollout the airplane nosed over on its back. The pilot could not be found to accomplish the required accident report.NTSB ANC88LA092Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Illiamna, AKDuring the takeoff roll on the beach, the aircraft struck a large rock and the pilot lost directional control of the aircraft.