NTSB investigations: Piper PA-28-140, 2009
12 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\") = 2009
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") = 2009
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 ERA10FA099Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Heflin, ALThe student pilot's failure to maintain adequate airspeed during night, adverse weather conditions, which resulted in an aerodynamic stall/spin. Contributing to the accident was the student pilot's decision to attempt a flight that he was not qualified for…NTSB ERA10LA066Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Newcomb, NYThe pilot’s failure to maintain clearance from mountainous terrain during descent at night, with low clouds and fog.NTSB WPR10CA035Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Angwin, CAThe pilot's failure to properly identify the runway surface for takeoff and his subsequent failure to abort the takeoff when he realized he was not on the runway. Contributing to the accident was the pilot’s failure to select the appropriate radio frequency…NTSB ERA10CA016Accident · Minor injuriesData collectionFinal reportPiper PA28 · Meadville, PAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ERA10CA006Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Gainesboro, TNThe pilot's failure to maintain clearance from trees. Contributing to the accident were the rising terrain and night light conditions.NTSB CEN09CA453Accident · No injuriesData collectionFinal reportPiper PA28 · Malvern, ARThe pilot's failure to maintain adequate airspeed during the approach to landing.NTSB WPR09LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taylor, AZThe loss of engine power for undetermined reasons.NTSB CEN09CA422Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hibbing, MNThe pilot mistakenly using a closed taxiway for takeoff, which resulted in the airplane striking a construction barricade.NTSB ERA09CA287Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Danville, PAThe student pilot's failure to maintain control during a landing.NTSB CEN09CA282Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Seminole, OKThe pilot's failure to maintain directional control during takeoff.NTSB WPR09CA193Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Dubois, WYThe pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.NTSB ERA09LA176Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ridgeland, SCThe pilot's failure to maintain control of the airplane during a precautionary landing. Contributing to the accident was a partial loss of engine power for undetermined reasons.