NTSB investigations: Lycoming 0-320 series, OR
13 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 2 |
|---|---|
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 2000 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 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.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 SEA08FA005Accident · 1 fatalField investigationFinal reportPiper PA-18 · Crowley Ranch, ORThe pilot's failure to maintain adequate clearance from a power transmission line while maneuvering. Contributing to this accident was the pilot's diverted attention, and decision to maneuver at a low altitude.NTSB SEA05FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Grand Ronde, ORThe pilot's failure to maintain clearance from high terrain while maneuvering. A factor contributing to the accident was the high terrain.NTSB SEA04LA013Accident · No injuriesLimited investigationFinal reportCessna 172M · Bandon, ORThe pilot's failure to maintain clearance from objects while on final approach. Dark night conditions, trees and a low glidepath were factors.NTSB SEA02FA125Accident · 2 fatalField investigationFinal reportCessna 172N · Otis, ORThe pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.NTSB SEA02FA085Accident · 2 fatalField investigationFinal reportRobinson R-22 Mariner · Merlin, ORClearance from a cable running perpendicular to a river was not maintained during low level cruise flight. A cable was a factor.NTSB SEA00LA187Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberg, ORThe pilot's failure to maintain a proper glide path on final approach. Factors include a vehicle on the roadway and a downdraft.NTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…NTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.NTSB SEA96LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Klamath Falls, ORthe pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…NTSB SEA96LA116Accident · No injuriesLimited investigationFinal reportCessna 172L · Sisters, ORthe pilot's inadequate compensation for wind conditions during a go-around, which resulted in his failure to maintain proper runway alignment. Factors relating to the accident were: the variable/gusty crosswind condition, and the proximity of the hanger and…NTSB SEA96LA035Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacific City, ORThe pilot's delay in aborting the landing, which resulted in his failure to clear the perimeter fence. Factors relating to the accident were: the tailwind, and the pilot's failure to land at the proper touchdown point.NTSB SEA83FYM01Accident · 1 fatalFinal reportBellanca 7GCBC · 1/4nm S. Of Peo, ORThe pilot and passenger were on a pleasure flight over the willamette river. The passenger stated that after following the river the aircraft began to climb and turn east. There was a sudden jolt and the plane began to spin and impacted the water.NTSB SEA82FYM24Accident · 2 fatalFinal reportCessna 172P · 3nm Se Scappoos, ORThe acft struck & severed power lines strung between two 90-foot towers located about 1500 feet apart. The power lines were about 50 to 60 feet above the water at the lowest point of the line sag.