NTSB investigations: Continental IO-520 series, WA
111 cases on aircraft whose registry engine model is Continental IO-520 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, newest first
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 ('17032'))
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 ('17032'))
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 SEA94LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Spangle, WAThe pilot not maintaining clearance from the fence. A factor in the accident was the dusk light conditions.NTSB SEA93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Dayton, WAThe loss of engine power, undetermined. A factor relating to the accident was a fence in the flt path.NTSB SEA93LA218Accident · No injuriesLimited investigationFinal reportCessna A188B · Rockford, WAThe pilot failed to maintain alignment with the landing area. A factor to the accident was: high vegetation.NTSB SEA93LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Friday Harbor, WAFuel starvation and poor in-flight planning/decision.NTSB SEA93LA124Accident · No injuriesLimited investigationFinal reportCessna A185F · Bellevue, WAFailure of the right main landing gear shock strut.NTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.NTSB SEA93FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Aberdeen, WAThe pilot's failure to maintain proper altitude, and an inadequate visual lookout. Factors include weather below approach minimums, fog, drizzle, and a dark night.NTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.NTSB SEA91FA157Accident · 3 fatalField investigationFinal reportBeech V35B · Roche Harbor, WAThe pilot's failure to plan his takeoff path to provide adequate terrain clearance. The rising terrain and dark night light conditions were contributing factors.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB SEA90LA024Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Seattle, WAThe pilot did not maintain directional control of the airplane during the landing roll.NTSB SEA89LA136Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Albion, WAThe pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.NTSB SEA89LA062Accident · No injuriesLimited investigationFinal reportCessna 185 · Everett, WAThe failure of the pilot to maintain directional control of the tailwheel aircraft during landing roll.NTSB SEA89LA054Accident · No injuriesLimited investigationFinal reportCessna 185 · Bellingham, WAThe pilot's failure to compensate for the loss of lift due to ice accumulation on the wings, his failure to control the rate of descent, and poor inflight decision making. Contributing to the accident was the pilot's fatigue.NTSB SEA89LA035Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Sekiu, WAPilot attempted a landing in adverse weather conditions, rather than postpone the business trip and return to origin or other safe area. Contributing to the accident were turbulence and gusty winds along with the self induced pressure to make the business flt.NTSB SEA89LA017Accident · No injuriesLimited investigationFinal reportCessna 210K · Anacortes, WADuring a gusty crosswind landing, touchdown was accomplished about 500 feet past the runway threshold. The aircraft bounced at touchdown. The pilot stated that he thought he had a flat main tire. The pilot momentarily added power after touchdown to go-around…NTSB SEA88LA192Accident · No injuriesLimited investigationFinal reportCessna 207 · Center Island, WAThe plt was landing upslope on a one-way 1700 ft rwy in wind that was variable & changing from calm to gusts from the north. The plt rprtd a northerly gust cond occurred as he was landing. Subsequently, the acft floated beyond the desired touchdown point &…NTSB SEA88FA154Accident · 2 fatalField investigationFinal reportCessna 210E · N Bonneville, WAWhile on a flt from oroville to orchards, WA, the acft was about 25 to 30 mi east of the destn when it collided with trees & crashed. Impact occurred aprx 100 ft below the top of a ridgeline at an elev of about 1755 ft. a witness, who heard the crash, rprtd…NTSB SEA88LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Mercer Island, WAThe pilot stated that the aircraft struck a log while landing on the water. The aircraft then nosed over inverted and sank.NTSB SEA86LA241Accident · Minor injuriesLimited investigationFinal reportCessna 185 · St. John, WAAfter running a fuel tank dry in flight, the plt switched fuel tanks but failed to assure that the fuel selector was in the detent. The engine quit running and a forced landing was made in rough terrain.NTSB SEA86LA198Accident · No injuriesLimited investigationFinal reportCessna 188 · Easton, WAThe tow plane with glider attached began losing pwr at aprx 50 ft AGL during takeoff. The tow plt signaled the glider plt for tow release. The two plts landed on the remaining rwy. The tow plane skidded into the trees off the end of the rwy. Investigation…NTSB SEA86FA194Accident · 1 fatalField investigationFinal reportCessna 310C · Vancouver, WAPlt not IFR rated. Attempted departure from own airstrip in fog during early dawn. Positive rate of climb not established. Acft contacted terrain 3/4 mile from runway end. Psgrs reported no sensation of power probs, but complete loss of ground ref at liftoff.…NTSB SEA85LA229Accident · No injuriesLimited investigationFinal reportCessna 185 · San Juan Island, WAThe pilot was attempting to depart his private airstrip to the north with trees bordering the north end of the airstrip. The wind was from 360 at 20 knots gusting to 30 knots. The pilot was unable to arrest his rate of sink and made a right turn to avoid…NTSB SEA85LA230Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Burlington, WADuring initial climb, the plt smelled smoke & heard a backfire, then the eng lost power. A forced landing was made in a field on rough/uneven terrain. During the landing roll, the acft struck a ditch & was damaged. A visual inspection revealed that the left…NTSB SEA85LA223Accident · No injuriesLimited investigationFinal reportCessna A185F · Eastsound, WADuring takeoff roll the acft veered right and the plt overcorrected to the left. The acft then departed the rwy to the left striking VASI lights.NTSB SEA84LA187Accident · No injuriesLimited investigationFinal reportCessna A188B · Palouse, WAPIC stated he landed in S0FT dirt short of the 1600 ft ag strip. The acft nosed over.NTSB SEA82DA099Accident · No injuriesFinal reportCessna A188B · Othello, WAAt the completion of a spray operation, the pilot returned to the airport to land. During the landing roll realizing that no braking was available on the left wheel, the aircraft was intentionally ground looped in an effort to reduce the damage. According to…NTSB SEA82DA024Accident · No injuriesFinal reportCessna U206G · Moses Lake, WAThe pilot stated that he encountered a freak gust of wind during the landing. The plane touched down on the right side of the runway in an area of soft terrain. The aircraft veered farther to the right and continued into an earthen drainage ditch. The ditch…NTSB SEA81FYE17Accident · Minor injuriesClosedCessna TU206G · Everett, WANTSB SEA81DYE07Accident · No injuriesClosedCessna 185 · Port Townsend, WANTSB SEA81FYE03Accident · No injuriesClosedCessna 185 · Seattle, WANTSB SEA79FYE41Accident · No injuriesClosedCessna A185F · Renton, WANTSB SEA78DYE32Accident · No injuriesClosedCessna 185 · Oak Harbor, WANTSB SEA78FA043Accident · Minor injuriesClosedCessna 207 · Olga, WANTSB SEA78DYE24Accident · No injuriesClosedCessna 185F · Arlington, WANTSB SEA78DYE22Accident · No injuriesClosedCessna 185F · Arlington, WANTSB SEA78DYP25Accident · No injuriesClosedCessna 188 · Fairfield, WANTSB SEA78FYP15Accident · No injuriesClosedCessna A188 · Moxee, WANTSB SEA78FYE04Accident · No injuriesClosedCessna 185F · Seattle, WANTSB SEA78DYP01Accident · No injuriesClosedCessna 206 · Priest Rpd Dam, WANTSB SEA77DYP35Accident · No injuriesClosedCessna 188 · Connell, WANTSB SEA77FA030Accident · 1 fatalClosedBeech 58 · Vancouver, WANTSB SEA77FYP23Accident · No injuriesClosedCessna 185 · Waterville, WANTSB SEA76DYG52Accident · No injuriesClosedCessna 206 · Spangle, WANTSB SEA76DYG21Accident · No injuriesClosedCessna 206 · Pasco, WANTSB SEA76DYG12Accident · No injuriesClosedCessna 188 · Monitor, WANTSB SEA75FYC45Accident · No injuriesClosedCessna 150 · Vancouver, WANTSB SEA75AS045Accident · No injuriesClosedCessna 402A · Seattle, WANTSB SEA75DYG28Accident · No injuriesClosedCessna A185F · Connell, WANTSB SEA74DVG12Accident · No injuriesClosedCessna 210C · Spokane, WA