NTSB investigations: Piper PA-28-181, WA
12 cases on aircraft the registry lists as Piper PA-28-181. 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 |
|---|---|
| 1980 | 1 |
| 1982 | 2 |
| 1984 | 1 |
| 1985 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 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 ('7102807', '7102832'))
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 ('7102807', '7102832'))
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 WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB LAX08CA087Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Bremerton, WAThe pilot's failure to maintain directional control while taxiing. A contributing factor was the control interference on the rudder pedals created by the pilot's footwear.NTSB LAX07LA268Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lopez Island, WAA loss of engine power due to the fatigue failure of the left idler gear. Inadequate maintenance installation of the recently installed left magneto was also causal.NTSB SEA04LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Seattle, WAThe failure of the pilot to maintain clearance with the parked airplane while taxiing. A factor contributing to the accident was the pilot's inadequate preflight planning.NTSB SEA03FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Eastsound, WAThe pilot's failure to maintain clearance from the water and his failure to reset the altimeter to the local barometric pressure. Contributing factors were fog and night conditions.NTSB SEA01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tekoa, WAThe non-current pilot's failure to maintain sufficient altitude or clearance with wheat crops on short final, and the flight instructor's inadequate remedial action. Factors included wheat crops and a dirt bank on short final, the runway's lack of a visual…NTSB SEA85LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tacoma, WAThe engine ceased operative while on right base for rwy 35 due to fuel exhaustion. The plt ran the left tank dry. The right tank contained full fuel. The plt had been used to flying Cessna's.NTSB SEA84FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Burley, WAThe non-rated plt was employed as an acft cleaner & had access to the ignition keys of several acft, including N6950J. Earlier during the evening, he was seen consuming beer. At about 0024 PDT, he took off from rwy 18. About 1 min later, the acft collided…NTSB SEA82DA069Accident · No injuriesFinal reportPiper PA 28-181 · Port Angeles, WAAbout 10 minutes after takeoff, the pilot realized that he was south of course. After beginning a shallow turn back to course, he realized that he was in close proximity to mountainous terrain. He made an abrupt 40 degree left bank to get away from the…NTSB SEA82DA049Accident · No injuriesFinal reportPiper PA-28-181 · Spokane, WAStudent pilot/copilot reset the aircraft clock in anticipation of the time zone change that would occur in flight. This caused the pilot to think he had another hour of flight time. In addition the fuel gage was found to show fuel in the right tank when all…NTSB SEA80FYE43Accident · Minor injuriesClosedPiper PA-28 · Gardner, WANTSB SEA79FA013Accident · Minor injuriesClosedPiper PA-28 · Bellingham, WA