NTSB investigations: Piper PA-25-235, 2015
3 cases on aircraft the registry lists as Piper PA-25-235. 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 | 36 |
|---|---|
| 1965 | 53 |
| 1966 | 45 |
| 1967 | 75 |
| 1968 | 77 |
| 1969 | 65 |
| 1970 | 75 |
| 1971 | 91 |
| 1972 | 60 |
| 1973 | 60 |
| 1974 | 83 |
| 1975 | 58 |
| 1976 | 49 |
| 1977 | 51 |
| 1978 | 44 |
| 1979 | 48 |
| 1980 | 35 |
| 1981 | 36 |
| 1982 | 22 |
| 1983 | 24 |
| 1984 | 13 |
| 1985 | 16 |
| 1986 | 16 |
| 1987 | 14 |
| 1988 | 15 |
| 1989 | 11 |
| 1990 | 11 |
| 1991 | 11 |
| 1992 | 11 |
| 1993 | 8 |
| 1994 | 9 |
| 1995 | 11 |
| 1996 | 10 |
| 1997 | 6 |
| 1998 | 5 |
| 1999 | 6 |
| 2000 | 2 |
| 2001 | 6 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 6 |
| 2006 | 4 |
| 2007 | 4 |
| 2008 | 5 |
| 2009 | 7 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2015
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102504'))
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") = 2015
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102504'))
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 CEN15LA383Accident · No injuriesLimited investigationFinal reportPiper PA 25-235 · Harvey, NDThe partial loss of engine power due to a failed magneto and two cylinders with low compression. Contributing to the accident was the pilot/owner’s decision to operate the airplane with an ongoing engine issue.NTSB CEN15LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA 25-235 · Galveston, TXThe loss of engine power due to a failure of a crankshaft idler gear shaft.NTSB CEN15LA238Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Omega, OKImproper base metal preparation or contamination of the No. 5 cylinder wall before it was coated, which resulted in the coating peeling off of the cylinder wall and contaminating the engine oil and the subsequent partial loss of engine power.