NTSB investigations: Piper PA-12, 1995
7 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\") = 1995
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") = 1995
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 ANC95LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions. A factor relating to the accident was: the gusty crosswind condition.NTSB ANC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Ketchikan, AKThe pilot's inadequate preflight preparation and the water in the airplane's fuel system. A factor in the accident was the rough water in the forced landing area.NTSB ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.NTSB ANC95LA111Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's improper use of carburetor heat which led to carburetor icing and a partial loss of engine power. Factors contributing to the accident are prevailing carburetor icing conditions, and the pilot's failure to properly judge the airplane's distance…NTSB NYC95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Meriden, CTThe pilot's failure to adequately compensate for wind conditions. Contributing factors were wind gusts, crosswinds, and the pilot's lack of experience in type.NTSB ANC95FA078Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe failure of both pilots to maintain adequate visual lookout.NTSB ANC95LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe flight instructor's inadequate remedial action. Factors include the dual student's failure to maintain directional control, and the rear pilot's station not having brakes installed.