NTSB investigations: Piper PA-28-160, WA
11 cases on aircraft the registry lists as Piper PA-28-160. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1972 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 1998 | 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 ('7102806'))
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 ('7102806'))
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 WPR22LA294Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · White Salmon, WAThe pilot’s failure to attain a proper touchdown point, and his delayed decision to go around which, resulted in a collision with trees.NTSB SEA98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Monroe, WAFuel starvation due to the flight instructor's improper in-flight decision to simulate an engine failure by pulling the mixture control toward the lean position until the engine shut down, and his failure to return the mixture to the rich position until after…NTSB SEA95LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Kent, WAThe pilot's failure to maintain clear of the trees. The dark night light condition was a factor.NTSB SEA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Renton, WAThe student pilot was returning from a long solo cross country. The runway was undergoing construction. 2,300 feet remained for landing. Landing needed to be accomplished over barriers. The student pilot had approach flaps set. The tower asked the pilot to…NTSB SEA87LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Odessa, WADuring landing roll on a dirt road, the aircraft drifted to the side, encountered the shoulder ditch and flipped over.NTSB SEA73DYE03Accident · No injuriesClosedPiper PA-28 · Vashon Hghts, WANTSB SEA72DYG47Accident · No injuriesClosedPiper PA-28 · Dusty, WANTSB SEA67D0263Accident · No injuriesClosedPiper PA-28 · Palouse, WANTSB SEA67D0228Accident · No injuriesClosedPiper PA-28 · Bellevue, WANTSB SEA65F0028Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WANTSB UNK65X1183Accident · Serious injuriesClosedPiper PA-28 · North Bend, WA