NTSB investigations: Piper PA-28-181, 2010
11 cases on aircraft the registry lists as Piper PA-28-181. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1976 | 16 |
| 1977 | 16 |
| 1978 | 29 |
| 1979 | 23 |
| 1980 | 28 |
| 1981 | 36 |
| 1982 | 21 |
| 1983 | 24 |
| 1984 | 10 |
| 1985 | 33 |
| 1986 | 26 |
| 1987 | 23 |
| 1988 | 21 |
| 1989 | 10 |
| 1990 | 20 |
| 1991 | 19 |
| 1992 | 9 |
| 1993 | 19 |
| 1994 | 20 |
| 1995 | 22 |
| 1996 | 12 |
| 1997 | 17 |
| 1998 | 20 |
| 1999 | 16 |
| 2000 | 10 |
| 2001 | 15 |
| 2002 | 10 |
| 2003 | 10 |
| 2004 | 20 |
| 2005 | 15 |
| 2006 | 9 |
| 2007 | 14 |
| 2008 | 8 |
| 2009 | 8 |
| 2010 | 11 |
| 2011 | 7 |
| 2012 | 8 |
| 2013 | 7 |
| 2014 | 12 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 13 |
| 2019 | 8 |
| 2020 | 6 |
| 2021 | 9 |
| 2022 | 7 |
| 2023 | 19 |
| 2024 | 15 |
| 2025 | 13 |
| 2026 | 11 |
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\") = 2010
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832'))
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") = 2010
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832'))
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 WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB ERA10CA473Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's inadequate compensation for crosswind conditions which resulted in a hard landing and loss of directional control.NTSB ERA10CA441Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oakland, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA10CA337Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.NTSB CEN10FA316Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Umpire, ARThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation.NTSB ERA10CA303Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Block Island, RIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with a fence.NTSB WPR10CA267Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Palo Alto, CAA total loss of engine power on final approach due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB WPR10CA172Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe flight instructor's failure to attain and maintain adequate airspeed while demonstrating a soft-field takeoff.NTSB WPR10FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot’s decision to take off in marginal visual flight rules conditions, which resulted in an encounter with low clouds, and the pilot's failure to maintain clearance from wires while maneuvering in the traffic pattern for landing.NTSB ERA10CA122Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's improper approach, failure to perform a go-around, and failure to maintain directional control while braking after a long landing.NTSB WPR10LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Apple Valley, CAThe pilot's loss of directional control during the landing roll and the check airman’s delayed remedial response.