NTSB investigations: Lycoming O-360 series, WA
10 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
| 1982 | 1 |
|---|---|
| 2003 | 1 |
| 2004 | 2 |
| 2006 | 1 |
| 2010 | 2 |
| 2012 | 1 |
| 2015 | 1 |
| 2018 | 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\" = 'WA' 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" = 'WA' 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 GAA18CA336Accident · No injuriesData collectionFinal reportAviat A 1 · Renton, WAThe pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface.NTSB WPR15LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Centralia, WAMaintenance personnel’s incorrect installation of the fuel selector valvehandle, which resulted in fuel starvation, a loss of engine power, and a forced hard landing. Contributing to the accident was the pilot's failure to follow the manufacturer's checklist.NTSB WPR12CA405Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Lake Newman, WAThe flight instructor's failure to maintain clearance from terrain while correcting for the student pilot's failure to maintain directional control of the helicopter.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR10FA277Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Spokane, WAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation and the student pilot's failure to maintain main rotor rpm.…NTSB SEA06CA086Accident · No injuriesData collectionFinal reportSchmidt RV7A · Northport, WAThe pilot's failure to maintain directional control during the landing flare/touchdown. Factors contributing to the accident included the gusty wind and soft terrain conditions which resulted in the aircraft nosing over during the landing roll.NTSB SEA05LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Oak Harbor, WAThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with terrain.NTSB SEA04LA179Accident · Minor injuriesLimited investigationFinal reportHardin Lancair 320 · Chewelah, WAFuel exhaustion as a result of a fuel leak from an undetermined location resulting in a loss of engine power during approach for landing and subsequent forced landing. Soft terrain was a factor.NTSB SEA03LA134Accident · No injuriesLimited investigationFinal reportArcher S-18T · Arlington, WAThe pilot's failure to maintain an airspeed above Vs (stalling speed) while making a close-in base-to-final turn.NTSB SEA82DA023Accident · No injuriesFinal reportCessna 172P · Sinclair Island, WAThe airport was a privately owned strip approximately 1200 ft in length. About the last 25 percent of runway 33 was angled approximately 30 degrees to the right. Tth runway was considered unidirectional with landings normally made to the north/northwest and…