NTSB investigations: Piper PA-28-161, 2015
7 cases on aircraft the registry lists as Piper PA-28-161. 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 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1977 | 5 |
| 1978 | 19 |
| 1979 | 30 |
| 1980 | 30 |
| 1981 | 37 |
| 1982 | 31 |
| 1983 | 14 |
| 1984 | 16 |
| 1985 | 20 |
| 1986 | 20 |
| 1987 | 26 |
| 1988 | 19 |
| 1989 | 22 |
| 1990 | 28 |
| 1991 | 22 |
| 1992 | 23 |
| 1993 | 21 |
| 1994 | 17 |
| 1995 | 14 |
| 1996 | 13 |
| 1997 | 15 |
| 1998 | 13 |
| 1999 | 15 |
| 2000 | 16 |
| 2001 | 11 |
| 2002 | 11 |
| 2003 | 9 |
| 2004 | 15 |
| 2005 | 14 |
| 2006 | 17 |
| 2007 | 8 |
| 2008 | 22 |
| 2009 | 8 |
| 2010 | 10 |
| 2011 | 13 |
| 2012 | 8 |
| 2013 | 8 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 7 |
| 2017 | 6 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 2 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 3 |
| 2026 | 4 |
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 ('7102803', '7102834'))
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 ('7102803', '7102834'))
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 GAA16CA095Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Fort Worth, TXAn inadvertent collision with a bird while on downwind in the airport pattern.NTSB GAA15CA276Accident · No injuriesData collectionFinal reportPiper PA 28 · Van Nuys, CAThe pilot's failure to compensate for turbulence during the landing flare, which resulted in a hard landing and runway excursion.NTSB ERA15LA369Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Pittsburg, PAAn engine fire, which resulted from the overpriming of a hot engine.NTSB WPR15FA256Accident · 2 fatalField investigationFinal reportPiper PA28 · Santee, CAThe pilots' failure to maintain airplane control following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the partial loss of engine power due to a failure of the right magneto.NTSB ERA15LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Bristow, VAThe student pilot’s failure to maintain altitude during approach, which resulted in controlled flight into terrain. Contributing to the accident was the student’s distraction due to other traffic in the airport traffic pattern.NTSB CEN15LA228Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-161 · Ranger, TXA total loss of engine power during cruise flight due to piston fatigue cracking for reasons that could not be determined due to postfracture smearing damage.NTSB ERA15CA107Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Alexander City, ALThe pilot's failure to properly secure the airplane before hand-propping the engine for startup.