NTSB investigations: Piper PA-30, OR
15 cases on aircraft the registry lists as Piper PA-30. 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 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 2012 | 1 |
| 2020 | 2 |
| 2021 | 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 ('7103002'))
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 ('7103002'))
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 WPR21LA179Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30B · Corvallis, ORThe pilot’s failure to maintain airplane control during a simulated engine out landing which resulted in impact with terrain.NTSB WPR20LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Salem, ORA fatigue failure of the right main landing gear trunnion.NTSB WPR20LA111Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 30 · Eagle Creek, ORThe pilot's loss of airplane control during takeoff due to his left shoe’s interference with the rudder pedal.NTSB WPR12LA366Accident · No injuriesLimited investigationFinal reportPiper PA-30 B · Scappoose, ORThe failure of the landing gear to fully extend as a result of a failure of the landing gear transmission assembly for reasons that could not be determined based on the available evidence.NTSB SEA83LA092Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Lakeview, ORThe acft had landed earlier at redmond in what was described as a hard landing. The plt stated the only problem noted was a 'loud squeeking brake' during the rollout. The next leg of the flight was to terminate at reno, but the plt landedat Lakeview to wait…NTSB SEA78DYM34Accident · No injuriesClosedPiper PA-30B · Madras, ORNTSB SEA74AS042Accident · 1 fatalClosedPiper PA-30 · Deer Island, ORNTSB SEA73FYC36Accident · No injuriesClosedPiper PA-30 · Salem, ORNTSB SEA74DYC28Accident · No injuriesClosedPiper PA-30 · Mulino, ORNTSB SEA70D0073Accident · No injuriesClosedPiper PA-30 · Portland, ORNTSB SEA69F0089Accident · Minor injuriesClosedPiper PA-30 · Silver Lake, ORNTSB SEA67A0058Accident · 3 fatalClosedPiper PA-30 · Halfway, ORNTSB SEA66D0214Accident · No injuriesClosedPiper PA-30 · Ontario, ORNTSB SEA66A0040Accident · 4 fatalClosedPiper PA-30 · Ironside, ORNTSB SEA66F0016Accident · Serious injuriesClosedPiper PA30 · Mckenzie Brij, OR