NTSB investigations: Piper PA-28-151, OR
6 cases on aircraft the registry lists as Piper PA-28-151. 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
| 1975 | 1 |
|---|---|
| 1980 | 1 |
| 1984 | 2 |
| 1987 | 1 |
| 2007 | 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 ('7102805', '7104223'))
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 ('7102805', '7104223'))
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 LAX07LA113Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Lincoln City, ORIn-flight collision with water for undetermined reasons.NTSB SEA87LA110Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ORDuring climbout at about 500 feet AGL for a touch and go, a loss of power occurred. Forced landing was accomplished onto a rough field where the left wing struck a small tree. The aircraft spun around and the nose gear and main gear collapsed. Examination of…NTSB SEA84LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Shady Cove, ORThe pilot stated after the accident that he stalled the aircraft at an altitude of 50 ft AGL during takeoff and the acftdescended in a nose low attitude into trees and the ground.NTSB SEA84LA181Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Creswell, ORThe acft was on a night VFR flt from san carlos, CA, to eugene, OR, when the plt asked apch control how for away the arpt was. ATC informed the plt that the arpt was 16 miles further. About 3 minutes later, the left fuel tank was emptied. The plt switched to…NTSB SEA80FA032Accident · 1 fatalClosedPiper PA-28 · Woodburn, ORNTSB SEA76DYC21Accident · No injuriesClosedPiper PA-28 · Albany, OR