NTSB investigations: Piper PA-28-140, 2003
19 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\") = 2003
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") = 2003
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 FTW04FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Livingston, TXThe pilot's failure to compensate for the wind conditions and maintain control of the airplane during the final approach. Contributing factors were the gusty and high wind conditions.NTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.NTSB DEN04LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Cruces, NMthe CFI's failure to maintain aircraft control during a go-around resulting in an inadvertent stall/mush and impact with terrain. Contributing factors include the CFI's inadequate supervision, the private pilot's delayed relinquishing of control, and the…NTSB NYC03LA195Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJThe pilot's delay in executing a go-around, which resulted in an encounter with wake turbulence from a helicopter. A factor in the accident was the wake turbulence.NTSB SEA03LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Homedale, IDLoss of engine power during descent due to a failed cylinder head.NTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .NTSB ATL03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Winchester, TNA maintenance personnel failure to follow propeller inspection procedures that resulted in a fatigue failure of a propeller blade and the subsequent forced landing.NTSB FTW03WA218Accident · 1 fatalForeign investigationPiper PA-28-140 · Chilpancingo, MexicoNTSB CHI03LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Evansville, INThe pilot's failure to attain the proper touchdown point. The barrels were a factor.NTSB NYC03LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aurora, NYThe pilot's failure to obtain the proper climb rate.NTSB ATL03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hamilton, ALThe pilot's inadequate preflight inspection by his failure to ensure adequate oil supply, which resulted in oil exhaustion and the failure of the connecting rod cap.NTSB FTW03LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Conroe, TXthe student pilot's inadequate compensation for wind. A contributing factor was the gusting wind conditions.NTSB FTW03LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Needham, ARThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA03LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orofino, IDThe pilot's misjudgment of speed and distance resulting in a loss of airspeed, stall and undershoot of runway.NTSB LAX03FA131Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Big Bear Lake, CAthe pilot's inadequate decision regarding a departure route and his failure to maintain clearance with rapidly rising mountainous terrain. A factor in the accident was the pilot's impairment by the effects of exposure to marijuana within the 10-hour period…NTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.NTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.NTSB LAX03LA079Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tehachapi, CAThe pilot's failure to maintain adequate clearance above the surrounding terrain, and his evasive maneuver to avoid a perceived object. A factor in the accident was the dark night.NTSB IAD03LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · New Middleton, OHA jammed throttle control assembly for undetermined reasons.