NTSB investigations: Piper PA-28-140, 2008
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\") = 2008
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") = 2008
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 ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.NTSB WPR09FA060Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kapolei, HIThe partial loss of engine power during the initial climb due to the failure of both pilots to use carburetor heat during a long descent for landing in carburetor icing conditions, and, the flight instructor's inadequate supervision of the flight.NTSB CEN09CA064Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Stafford, KSA loss of engine power for undetermined reasons.NTSB ERA09CA052Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Tuscaloosa, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion. Contributing to the accident was improper preflight planning.NTSB CEN09LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nacogdoches, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ERA09CA018Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Repton, ALFuel exhaustion due to the pilot's inadequate preflight planning.NTSB CHI08CA296Accident · No injuriesData collectionFinal reportPiper PA28 · Gann Valley, SDThe pilot's inability to gain sufficient altitude during takeoff as a result of inadequate preflight planning.NTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.NTSB DFW08CA207Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Abbeville, LAA total loss of engine power for undetermined reasons. Contributing to the accident was unsuitable terrain for a forced landing.NTSB MIA08CA154Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mc Kinnon, TNThe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.NTSB SEA08LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · East Carbon, UTThe pilot's inadequate in-flight planning and decision to continue flight into a canyon area with questionable aircraft performance. Contributing to the accident was the lack of suitable terrain for the precautionary landing and a high density altitude…NTSB NYC08LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Rockland, METhe non-instrument rated pilot becoming spatially disorientated after inadvertently entering instrument flight conditions.NTSB CHI08FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Stevens Point, WIThe partial loss of engine power for undetermined reasons.NTSB NYC08LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ellijay, GAA loss of engine power for undetermined reasons.NTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.NTSB DFW08CA067Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dallas, TXThe pilot's delay in aborting the landing.