NTSB investigations: Piper PA-28-180, 2015
10 cases on aircraft the registry lists as Piper PA-28-180. 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 | 47 |
|---|---|
| 1965 | 72 |
| 1966 | 117 |
| 1967 | 131 |
| 1968 | 107 |
| 1969 | 92 |
| 1970 | 98 |
| 1971 | 99 |
| 1972 | 78 |
| 1973 | 85 |
| 1974 | 82 |
| 1975 | 64 |
| 1976 | 76 |
| 1977 | 54 |
| 1978 | 59 |
| 1979 | 37 |
| 1980 | 38 |
| 1981 | 26 |
| 1982 | 21 |
| 1983 | 29 |
| 1984 | 16 |
| 1985 | 24 |
| 1986 | 18 |
| 1987 | 23 |
| 1988 | 21 |
| 1989 | 29 |
| 1990 | 20 |
| 1991 | 12 |
| 1992 | 25 |
| 1993 | 17 |
| 1994 | 18 |
| 1995 | 21 |
| 1996 | 21 |
| 1997 | 16 |
| 1998 | 24 |
| 1999 | 17 |
| 2000 | 17 |
| 2001 | 13 |
| 2002 | 18 |
| 2003 | 17 |
| 2004 | 18 |
| 2005 | 19 |
| 2006 | 9 |
| 2007 | 13 |
| 2008 | 7 |
| 2009 | 15 |
| 2010 | 9 |
| 2011 | 15 |
| 2012 | 12 |
| 2013 | 10 |
| 2014 | 9 |
| 2015 | 10 |
| 2016 | 11 |
| 2017 | 10 |
| 2018 | 11 |
| 2019 | 12 |
| 2020 | 9 |
| 2021 | 11 |
| 2022 | 6 |
| 2023 | 24 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 10 |
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 ('7102808'))
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 ('7102808'))
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 ERA16LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Lawrenceville, GAThe flight instructor's inadequate fuel management, which resulted in a total loss of engine power during initial climb due to fuel starvation and a subsequent forced landing.NTSB ERA16FA032Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Cornelia, GAThe pilot's decision to initiate the flight into known adverse weather conditions, which resulted in his spatial disorientation and loss of airplane control.NTSB ERA16FA012Accident · 2 fatalField investigationFinal reportPiper PA 28-180 · Lake Worth, FLA loss of control for reasons that could not be determined based on the available information.NTSB WPR16LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Compton, CAA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA240Accident · No injuriesData collectionFinal reportPiper PA 28-180 · DeFuniak Springs, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion, and collision with a ditch.NTSB GAA15CA239Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Susanville, CAThe pilot's failure to maintain airspeed control during the landing in gusty wind conditions, resulting in an abnormal runway contact, and collision with terrain.NTSB GAA15CA149Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Novato, CAThe pilot's improper pitch control which resulted in a bounced landing, runway excursion, and collision with terrain.NTSB GAA15CA103Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Steele, NDThe pilot's failure to maintain directional control during landing, which resulted in a collision with objects while attempting to abort the landing.NTSB GAA15CA050Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Deer Lodge, MTThe pilot's inadequate recovery from a bounced landing, resulting in a loss of control and collision with terrain.NTSB WPR15CA107Accident · No injuriesData collectionFinal reportPiper PA28 - 180 · Garfield, WAThe pilot did not maintain clearance from a power line while maneuvering at a low altitude.