NTSB investigations: Continental IO-550 series, WA
11 cases on aircraft whose registry engine model is Continental IO-550 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
| 1992 | 1 |
|---|---|
| 2005 | 2 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2017 | 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\" = '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 ('17042'))
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 ('17042'))
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 WPR21LA339Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Arlington, WAThe fatigue fracture of the tailwheel fitting spring, which resulted in the loss of directional control during the landing roll.NTSB GAA18CA104Accident · Minor injuriesData collectionFinal reportGeldermann Bert E Lancair Legacy · Friday Harbor, WAThe pilot’s inability to maintain the landing flare, which resulted in the airplane landing hard short of the runway. Contributing to the accident was the cockpit canopy opening in flight.NTSB WPR17LA084Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Brinnon, WAThe flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.NTSB WPR14CA360Accident · No injuriesData collectionFinal reportNavion Navion F · Colville, WAThe pilot's loss of directional control during the landing roll.NTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR10FA163Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Morton, WAThe failure of maintenance personnel to properly secure a fitting cap on the throttle and metering assembly inlet after conducting a fuel system pressure check, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was…NTSB WPR09LA197Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Lopez Island, WAA loss of engine power during cruise flight due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the aft mounting nuts for the newly installed propeller governor and the pilot’s failure to secure the oil…NTSB LAX08LA253Accident · 2 fatalLimited investigationFinal reportLong Lancair ES · Cliffdell, WAThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident was turbulence and clouds.NTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.NTSB SEA05CA143Accident · No injuriesData collectionFinal reportBeech A36 · Sequim, WAThe temporary loss of engine power for an undetermined reason during the takeoff initial climb.NTSB SEA92LA211Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Blakely Island, WAThe removal of the control gust lock was not performed. Factors to the accident were: inadequate preflight, the checklist was not used, and the control gust lock marking flag was gone due to previous damage.