NTSB investigations: Piper PA-28-235, OR
11 cases on aircraft the registry lists as Piper PA-28-235. 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1976 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2013 | 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 ('7102810'))
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 ('7102810'))
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 WPR13LA322Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Albany, ORThe loss of hydraulic fluid, which rendered the brakes ineffective. The reason for the loss of hydraulic fluid could not be determined based on the available evidence.NTSB SEA02LA151Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Creswell, ORThe pilot’s improper management of fuel, which resulted in a loss of engine power due to fuel starvation.NTSB SEA96LA223Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Paisley, ORTotal loss of engine power secondary to geartrain failure.NTSB SEA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mulino, ORthe failure of the pilots to use carburetor heat during a reduced power descent. A factor was the carburetor icing conditions.NTSB SEA90LA056Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Yamhill, ORThe pilot's failure to use the proper touchdown point for landing. The tailwind was a factor related to the accident.NTSB SEA83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Vernonia, ORThe acft was observed high & fast during the approach & touched down about 300 ft from the departure end of the turf rwy. During the go-around the acft struck a wood fence, crossed a road & crashed in a "stumped off" area.NTSB SEA81FYM42Accident · Serious injuriesClosedPiper PA-28 · Medical Spgs, ORNTSB SEA77FA007Accident · 4 fatalClosedPiper PA-28R · Kimberly, ORNTSB SEA68A0011Accident · 4 fatalClosedPiper PA-28 · Sisters, ORNTSB SEA67D0008Accident · No injuriesClosedPiper PA-28 · Sherwood, ORNTSB SEA65F0044Accident · No injuriesClosedPiper PA-28 · Nyssa, OR