NTSB investigations: Piper PA-28-161, WA
15 cases on aircraft the registry lists as Piper PA-28-161. 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
| 1978 | 1 |
|---|---|
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2008 | 1 |
| 2022 | 1 |
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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834'))
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 WPR22LA260Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Kelso, WAThe student pilot’s inadequate flare resulting in a loss of airplane control during landing with gusting wind conditions.NTSB SEA08CA115Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Twisp, WAThe pilot's failure to maintain adequate clearance from a ground obstacle while taxiing.NTSB SEA03LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stuart Island, WAThe pilot's failure to maintain clearance while maneuvering to land. Contributing factors included the tree and the sunglare condition.NTSB SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.NTSB SEA96LA120Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Seattle, WAAn intentional plan or decision by the pilot to ditch the airplane in Puget Sound.NTSB SEA95LA024Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, WAThe pilot-in-command's not maintaining clearance from the power lines. A factor was the pilot-in-command's not maintaining the proper VASI glideslope.NTSB SEA88LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Snoqualamie Pss, WAThe pilot was advised that with his proposed route of flight VFR was not recommended due to low clouds and marginal visibility. The pilot elected to fly through the area at night and encountered low clouds and marginal visibility. While attempting to climb…NTSB SEA82DA150Accident · No injuriesFinal reportPiper PA-28-161 · Auburn, WAN1338J experienced a brake line failure and taxied into Piper PA-28, N8316A, that was parked in the warm-up area. There were no injuries.NTSB SEA81FA019Accident · 1 fatalClosedPiper PA-28 · Seattle, WANTSB SEA81FA018Accident · 2 fatalClosedPiper PA-28 · Port Angles, WANTSB SEA80DYE45Accident · No injuriesClosedPiper PA-28 · Forks, WANTSB SEA80DYE12Accident · Minor injuriesClosedPiper PA-28 · Yelm, WANTSB SEA79DYM24Incident · No injuriesClosedPiper PA-28 · Green Mountain, WANTSB SEA79DYE10Accident · No injuriesClosedPiper PA-28 · Oak Harbor, WANTSB SEA79FYE04Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WA