Fatal NTSB investigations: Piper PA-28-140, WA
11 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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2017 | 1 |
Where
Latest 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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…NTSB SEA06FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe pilot's inadequate airspeed during his aborted landing takeoff/climb which lead to a series of stall/mushes and subsequent impact with trees. Contributing factors were the pilot's loss of aircraft control during his initial landing approach and his…NTSB SEA04FA143Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Cle Elum, WAThe pilot's failure to obtain and maintain a safe rate of climb after takeoff, due to his failure to perform pre-takeoff weight/balance and takeoff/climb performance calculations. Factors include a high density altitude environment, and trees off the…NTSB SEA01FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Greenwater, WAFailure to maintain clearance from mountainous terrain.NTSB SEA95FAMS1Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Missing, WAUndetermined until the Missing aircraft is located.NTSB SEA88FA032Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Eastsound, WAThe plt depd south from an unattended island arpt at sea level & flew into marginal VFR conds with moderate snowfall. Acquaintances at the arpt rprtd the plt expressed an urgent need to return to snohomish, WA, despite the wx conds. When the acft did not…NTSB SEA85FA043Accident · 1 fatalField investigationFinal reportPiper PA-28-140D · Kent, WAThe acft contacted trees and the terrain aprx 1/2 mile south of the arpt shortly after takeoff. Witnesses stated the eng was running rough and black smoke was trailing from the exhaust during the takeoff. Examination of the eng revealed the spark plugs were…NTSB SEA83FA189Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe acft collided with trees and the ground in an attempt to return to the arpt after takeoff. The acft crashed one milesouth of the arpt in IMC weather in the early hours of the morning. Witnesses said dense fog existed at the time with zero visibility. The…NTSB SEA83FA064Accident · 2 fatalClosedPiper PA-28 · North Bend, WANTSB SEA76AS019Accident · 1 fatalClosedPiper PA-28 · Snoqualme Pass, WANTSB SEA74AS023Accident · 2 fatalClosedPiper PA-28 · Wenatchee, WA