NTSB investigations: Piper J3C-65, OR
16 cases on aircraft the registry lists as Piper J3C-65. 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 |
|---|---|
| 1966 | 1 |
| 1967 | 4 |
| 1969 | 1 |
| 1971 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1988 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 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 ('7100510'))
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 ('7100510'))
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 WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.NTSB SEA01LA178Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Glide, ORInadequate compensation for wind conditions during takeoff resulting in the pilot's failure to maintain directional control. Wind gusts, down sloping terrain and a fence post were factors.NTSB SEA95LA115Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Medford, ORAn unreliable fuel quantity gage and an inadequate preflight. The tall vegetation in the landing area was a factor.NTSB SEA88LA075Accident · No injuriesLimited investigationFinal reportPiper J-3 · Newberg, ORThe pilot had not flown for over five years and was doing multiple touch and goes in order to prepare for his biennial flight review. While on a landing rollout the engine ceased operating. The pilot exited the aircraft and began hand propping the engine. The…NTSB SEA79FYM47Accident · Minor injuriesClosedPiper J-3 · Clatskanie, ORNTSB SEA79DYM12Accident · No injuriesClosedPiper J3C-65 · The Dalles, ORNTSB SEA76DYI13Accident · No injuriesClosedPiper J-3 · Medford, ORNTSB SEA74FYC44Accident · 1 fatalClosedPiper J3C-65 · Cornelius, ORNTSB SEA72DYC05Accident · No injuriesClosedPiper J3C-65 · Beaverton, ORNTSB SEA70D0051Accident · No injuriesClosedPiper J3C-65 · Eugene, ORNTSB SEA68D0215Accident · No injuriesClosedPiper J3C-65 · Bonanza, ORNTSB SEA68D0095Accident · No injuriesClosedPiper J-3 · Newberg, ORNTSB SEA68D0115Accident · No injuriesClosedPiper J3C-65 · Diamond, ORNTSB SEA67D0311Accident · No injuriesClosedPiper PA-18 · Rome, ORNTSB SEA67F0082Accident · No injuriesClosedPiper J3C-65 · Beavercreek, ORNTSB UNK64X1995Accident · No injuriesClosedPiper J3 · Sandy, OR