NTSB investigations: Lycoming O-360 series, OR
8 cases on aircraft whose registry engine model is Lycoming O-360 series. 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
| 2003 | 1 |
|---|---|
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2018 | 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.engine_model_code IN ('41575'))
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 ('41575'))
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 WPR21LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Redmond, ORFailure of the landing gear strut piston tube due to fatigue cracking from corrosion pitting.NTSB WPR18LA130Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Portland, ORA hard landing for reasons that could not be determined based on the available information.NTSB GAA16CA213Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Troutdale, ORThe flight instructor's failure to monitor outside the helicopter during hover flight, which resulted in a collision with terrain and rollover.NTSB WPR12LA402Accident · Serious injuriesLimited investigationFinal reportHansen HANSEN-VANS RV-6 · Lemolo Lake, ORAn overvoltage event due to the failure of the automotive voltage regulator, which resulted in electrical anomalies and smoke in the cockpit and a subsequent forced off-airport landing.NTSB LAX07CA073Accident · No injuriesData collectionFinal reportRobinson R-22 Beta 2 · Salem, ORThe student pilot's improper remedial action when a dynamic rollover was encountered.NTSB SEA06FA168Accident · Minor injuriesField investigationFinal reportAviat A-1B · Owyhee, ORThe pilot inadvertently landing with the parking brake engaged, which resulted in a nose over.NTSB SEA04FA031Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Cave Junction, ORBoth the pilot-in-command and the co-pilot allowing the aircraft to enter into an area of adverse weather (icing conditions at low [-20 degrees C] temperatures) resulting in sequential induction icing, induction filter blockage, carburetor icing and the…NTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.