NTSB investigations: Piper PA-12, 1994
18 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\") = 1994
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") = 1994
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 FTW95LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · La Porte, TXLoss of engine power due to fuel starvation as result of the failure of the glass bowl on the gascolator. A factor was the lack of suitable terrain at the pilot's disposal to execute a forced landing.NTSB ANC95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's selection of unsuitable terrain for landing/taxi. Factors associated with the accident were the soft and snow covered terrain.NTSB ANC94LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nondalton, AKThe pilot's improper flare during the landing touchdown. The pilot's lack of familiarity with the aircraft make and model was a factor in the accident.NTSB ANC94LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's inadequate in-flight planning and a failure to maintain directional control of the airplane. Factors were the rising, rough/uneven terrain and the tailwind.NTSB LAX94LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Riverside, CAa total loss of engine power for undetermined reasons.NTSB SEA94FA199Accident · 2 fatalField investigationFinal reportPiper PA-12 · Salem, ORFailure of the pilot to see-and-avoid the occupied canoe. Factors related to the accident were: the pilot's improper planning/decision and excessive taxi speed.NTSB ANC94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Eagle, AKUndetermined.NTSB FTW94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Watson, ARWas the excessive airspeed during approach and the pilot's failure to execute a missed approach.NTSB BFO94LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Germansville, PAThe pilot failed to maintain a proper descent rate which resulted in an undershoot.NTSB ANC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's excessive use of the wheel brakes.NTSB ANC94LA063Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot's selection of an unsuitable landing area.NTSB SEA94LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Nashua, MTAirspeed was not maintained. Factors include an inadvertent stall.NTSB CHI94LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Wausaukee, WIthe pilot's inadequate preflight of the airplane.NTSB MIA94FA114Accident · 1 fatalField investigationFinal reportPiper PA-12 · Merritt Island, FLThe loss of elevator control due to jamming by the tow rope which prevented the pilot from being able to control the airplane.NTSB FTW94LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Rayville, LAThe pilot's failure to maintain adequate airspeed during the turn to final approach.NTSB ATL94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Smithfield, NCThe pilot's failure to maintain adequate clearance from power lines. Factors were the unmarked power lines located under the final approach path, and the sun glare that existed at the time of the accident.NTSB ANC94FA032Accident · 1 fatalField investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's failure to maintain airspeed while maneuvering at low altitude. A factor in the accident was the student pilot's inadequate training.NTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.