NTSB investigations: Piper PA-28-181, OR
13 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
| 1976 | 1 |
|---|---|
| 1979 | 2 |
| 1982 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 'OR' 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" = 'OR' 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 SEA06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brookings, ORThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.NTSB SEA05LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · The Dalles, ORThe student pilot's improper compensation for the wind condition and the improper rejected landing procedure, which resulted in the collision with terrain. A contributing factor to the accident was the crosswind condition.NTSB SEA02LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Burns, ORThe pilot’s improper decision to continue on en route into an area of forecast reduced visibility without sufficient fuel to divert to a suitable alternate airport, and his subsequent inadvertent exhaustion of the aircraft's fuel supply. Factors include…NTSB SEA01LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · North Bend, ORThe pilot's failure to maintain clearance from the delivery truck while taxing. The pilot being distracted is a factor.NTSB SEA00LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, ORThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. Unsuitable terrain for a landing was a contributing factor.NTSB SEA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Merrill, ORFuel exhaustion and inadequate inflight planning/decision.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB SEA91LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Princeton, ORThe pilot's failure to maintain clearance from obstacles at the side of the runway.NTSB SEA89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Chiloquin, ORThe pilot's inadequate planning and preparation for the flight which resulted in inadequate airspeed and an inadvertent stall while attempting to clear trees off the end of the runway. Contributing factors were: the high density altitude, gusty crosswind,…NTSB SEA82DYM12Accident · No injuriesFinal reportPiper PA-28-181 · Albany, ORWhile proceeding from a restaurant parking area to the runway, the aircraft had to be taxied across a bridge. The bridge was 30 ft wide and 50 ft long. It had no side rails and was used to cross a drainage ditch. A slight right turn was required just before…NTSB SEA79FA053Accident · 4 fatalClosedPiper PA-28 · Paisley, ORNTSB SEA79FA028Accident · 2 fatalClosedPiper PA-28 · Brothers, ORNTSB SEA76AS047Accident · 1 fatalClosedPiper PA-28R · Mt.Jefferson, OR