NTSB investigations: Piper PA-28-140, 2010
16 cases on aircraft the registry lists as Piper PA-28-140. 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 | 35 |
|---|---|
| 1965 | 102 |
| 1966 | 177 |
| 1967 | 263 |
| 1968 | 182 |
| 1969 | 227 |
| 1970 | 220 |
| 1971 | 230 |
| 1972 | 189 |
| 1973 | 183 |
| 1974 | 169 |
| 1975 | 141 |
| 1976 | 129 |
| 1977 | 123 |
| 1978 | 118 |
| 1979 | 83 |
| 1980 | 66 |
| 1981 | 76 |
| 1982 | 63 |
| 1983 | 40 |
| 1984 | 48 |
| 1985 | 35 |
| 1986 | 40 |
| 1987 | 42 |
| 1988 | 46 |
| 1989 | 30 |
| 1990 | 45 |
| 1991 | 46 |
| 1992 | 30 |
| 1993 | 31 |
| 1994 | 45 |
| 1995 | 29 |
| 1996 | 25 |
| 1997 | 30 |
| 1998 | 27 |
| 1999 | 21 |
| 2000 | 30 |
| 2001 | 21 |
| 2002 | 24 |
| 2003 | 19 |
| 2004 | 17 |
| 2005 | 21 |
| 2006 | 20 |
| 2007 | 23 |
| 2008 | 16 |
| 2009 | 12 |
| 2010 | 16 |
| 2011 | 8 |
| 2012 | 17 |
| 2013 | 20 |
| 2014 | 15 |
| 2015 | 18 |
| 2016 | 16 |
| 2017 | 15 |
| 2018 | 21 |
| 2019 | 17 |
| 2020 | 16 |
| 2021 | 20 |
| 2022 | 17 |
| 2023 | 18 |
| 2024 | 13 |
| 2025 | 9 |
| 2026 | 12 |
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 ('7102802'))
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 ('7102802'))
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 WPR11LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAFatigue cracking of the upper torque-link attach lugs on the left main landing gear strut, which resulted in separation of the left main landing gear during taxi.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB ERA11CA072Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Andover, NJAn inadvertent collision with a deer on the runway during a night landing.NTSB CEN11CA032Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Rose Hill, KSThe pilot's improper touchdown point during landing, which resulted in a runway overrun.NTSB ERA11CA013Accident · Minor injuriesData collectionFinal reportPiper PA28 · Louisville, KYThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and loss of engine power.NTSB ANC10CA099Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Kenai, AKThe student pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during cruise flight.NTSB CEN10LA575Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Basehor, KSThe pilot's improper touchdown point during landing and his delayed decision to execute a go-around. Contributing to the accident was the pilot's vision being obscured by the rain.NTSB CEN10CA550Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Carthage, TXA total loss of engine power during cruise flight due to fuel exhaustion as a result of the pilot’s improper fuel planning.NTSB CEN10CA518Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Anderson, INThe pilot’s failure to abort the takeoff due to degraded airplane performance.NTSB CEN10LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Glenwood, NMThe pilot's decision to attempt a takeoff from an unimproved airstrip with a high density altitude.NTSB CEN10CA365Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Rogers, ARThe pilot's failure to maintain a proper descent rate during the approach to land.NTSB WPR10LA302Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Richfield, UTThe pilot’s decision to operate the unairworthy airplane with suspected performance deficiencies in a high density altitude and the subsequent partial loss of engine power due to low compression.NTSB CEN10CA237Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Houston, TXThe pilot's failure to attain the proper touchdown point which resulted in an overrun.NTSB CEN10CA147Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Martinsville, INThe pilot's inadequate preflight planning and his exceedance of the airplane's takeoff capability.NTSB CEN10LA129Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gatesville, TXThe pilot’s incapacitation as a result of one or more pre-existing medical conditions.NTSB ERA10CA114Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Collegedale, TNThe pilot’s failure to maintain directional control during the initial climb after takeoff in dark light conditions.