NTSB investigations: Piper PA-12, 1985
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\") = 1985
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") = 1985
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 SEA86LA025Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Imnaha, ORPrior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes.NTSB ANC85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe plt reported sufficient alt could not be obtained to clear trees during takeoff. The acft stalled and the right wing contacted the water resulting in the acft cartwheeling. Investigation revealed the acft was over gross weight and CG was beyond the aft…NTSB ANC85LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe plt reported that when he departed seward. The fuel gages indicated there was aprx 15 gal on board. About 5 min from the intended destination, the eng lost power from fuel exhaustion while the left fuel gage showed there was 5 gal remaining. During an…NTSB ANC85FA111Accident · 3 fatalField investigationFinal reportPiper PA-12 · Chugiak, AKThe acft crashed in a wooded residential area following a loss of pwr on takeoff. Post accident inspection of the airframe and powerplant disclosed automotive fuel was being used in the acft. Lab tests indicated the fuel was subjectedto high temps which…NTSB ATL85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hickory, NCDuring the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged.NTSB ANC85LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Beluga, AKAcft was doing low alt turns-about-a-point when the eng quit due to fuel starvation. The acft then crashed into trees. Plt stated the acft had aprx 5 gals of fuel an board at the time of the accident.NTSB ANC85FA063Accident · No injuriesField investigationFinal reportPiper PA-12 · Anchorage, AKDuring takeoff roll acft veered left off rwy, hit a snow bank and nosed over onto its back. Acft was 265 lbs over gwt. Two pax were in rear seat. Rear control stick was installed. There was a 10 kt right x-wind.NTSB CHI85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Waynesville, OHThe engine quit at about 500 ft AGL during the initial takeoff climb. The pilot made a forced landing in a plowed field and the main gear sheared off. Water was observed dripping out of the gascolator after the accident.NTSB ANC85LA051Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Skwentna, AKWhile attempting to land, acft stalled in right downwind turn and contacted the ground. Plt was unaware of the 5 to 7 mph wind.NTSB MIA85LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Miramar, FLAn interruption of pwr was experienced as an abrupt steep dive maneuver was entered to release the banner towed by the acft. The plt then attempted a 180 deg turn at an alt of aprx 200 ft AGL to avoid pwr lines. The acft entered a high descent rate and…