NTSB investigations: Lycoming 0-320 series, OR
11 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “In flight collision with terrain/water”. 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
| 1986 | 1 |
|---|---|
| 1991 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 3 |
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\" = 230))
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" = 230))
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 SEA07FA246Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Alsea, ORTerrain clearance was not maintained while maneuvering. A low altitude during the maneuver and hilly terrain were factors.NTSB SEA07CA122Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Chiloquin, ORThe pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.NTSB LAX07LA113Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Lincoln City, ORIn-flight collision with water for undetermined reasons.NTSB SEA05LA070Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Corvallis, ORThe student pilot's failure to maintain directional control while attempting to turn in the direction necessary to air-taxi to the landing pad, and the flight instructor's failure to take remedial action soon enough to correct the problems created when the…NTSB SEA04CA186Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Brooks, ORThe flight instructor's failure to maintain altitude/clearance on final approach to land resulting in an in-flight collision with terrain. Contributing factors were the student pilot's failure to maintain adequate airspeed during the approach and the flight…NTSB SEA01LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Scapoose, ORthe pilot's failure to maintain a speed above minimum in-flight stall speed (Vs). Factors include gusty winds at the time of the attempted landing.NTSB SEA98LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Newberg, ORThe pilots failure to account for the increased drag on the runway during the preflight planning. Factors were the long, wet grass.NTSB SEA96LA097Accident · No injuriesLimited investigationFinal reportPowers Bede BD-4 · Pacific City, ORthe pilot's inadequate compensation for wind conditions during the landing flare, and his failure to maintain runway alignment, which resulted in an encounter with tall grass beside the intended landing area. Factors relating to the accident were: the…NTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.NTSB SEA91FA262Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Dayville, ORThe pilot's poor in flight decision. Factors include mountainous/hilly terrain.NTSB SEA86LA102Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Harlen, ORThe acft contacted trees and descended to ground impact during an attempted go-around. The go-around was attempted after the plt over shot the farm field in which he had intended to land.