NTSB investigations: Piper PA-24-250, 2016
6 cases on aircraft the registry lists as Piper PA-24-250. 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 | 152 |
|---|---|
| 1965 | 130 |
| 1966 | 124 |
| 1967 | 137 |
| 1968 | 63 |
| 1969 | 60 |
| 1970 | 52 |
| 1971 | 55 |
| 1972 | 54 |
| 1973 | 43 |
| 1974 | 41 |
| 1975 | 36 |
| 1976 | 34 |
| 1977 | 43 |
| 1978 | 27 |
| 1979 | 24 |
| 1980 | 25 |
| 1981 | 16 |
| 1982 | 19 |
| 1983 | 13 |
| 1984 | 11 |
| 1985 | 19 |
| 1986 | 8 |
| 1987 | 16 |
| 1988 | 15 |
| 1989 | 14 |
| 1990 | 14 |
| 1991 | 15 |
| 1992 | 4 |
| 1993 | 12 |
| 1994 | 15 |
| 1995 | 8 |
| 1996 | 13 |
| 1997 | 14 |
| 1998 | 3 |
| 1999 | 13 |
| 2000 | 7 |
| 2001 | 13 |
| 2002 | 10 |
| 2003 | 6 |
| 2004 | 8 |
| 2005 | 6 |
| 2006 | 8 |
| 2007 | 8 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 4 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 5 |
| 2014 | 8 |
| 2015 | 5 |
| 2016 | 6 |
| 2017 | 1 |
| 2018 | 10 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 8 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 5 |
| 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\") = 2016
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404'))
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") = 2016
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102404'))
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 ERA17CA039Accident · No injuriesData collectionFinal reportPiper PA 24-250 · Houlton, MEA total loss of engine power due to fuel starvation, which resulted from the pilot’s mismanagement of the available fuel.NTSB GAA17CA037Accident · No injuriesData collectionFinal reportPiper PA24 · Wagoner, OKThe pilot's failure to maintain directional control during landing in gusting wind conditions.NTSB GAA16CA471Accident · No injuriesData collectionFinal reportPiper PA24 · Hillsboro, OHThe pilot's descent below the intended glidepath during the approach, which resulted in an impact with a ditch prior to the runway.NTSB GAA16CA277Accident · Minor injuriesData collectionFinal reportPiper PA 24 · Loda, ILThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing, runway excursion, and impact with a…NTSB CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…NTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.