Skip to content

NTSB investigations: Continental E225 series, WA

19 cases on aircraft whose registry engine model is Continental E225 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('17015')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('17015'))
  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 ('17015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR15FA181Accident · 1 fatalField investigationFinal reportBeech F35 · Everett, WAThe partial loss of engine power during takeoff due to debris within the fuel servo, which restricted fuel flow throughout the engine fuel system and resulted in a partial loss of engine power.Jun 10, 2015 · N4224B · Substantial damage NTSB WPR11LA172Accident · No injuriesLimited investigationFinal reportBeech G35 · Whidbey Island, WAThe pilot's failure to prioritize flying over navigation due to his diverted attention, which allowed the airplane to near a restricted area, which, in turn, led the pilot to enter a rapid avoidance maneuver and subsequently lose airplane control.…Mar 19, 2011 · N4211D · Substantial damage NTSB SEA06LA004Accident · No injuriesLimited investigationFinal reportBeech G35 · Longview, WARuddervator flutter which resulted in the buckling of the empennage. The reason for the ruddervator flutter was undetermined.Oct 7, 2005 · N4647D · Substantial damage NTSB SEA03LA078Accident · No injuriesLimited investigationFinal reportBeech F-35 · Anacortes, WAThe pilot's inadvertent selection of the incorrect fuel tank selector position (OFF) while in cruise flight over open water, and his failure to activate the fuel wobble-pump. A contributing factor was the unsuitable terrain.May 8, 2003 · N5030B · Destroyed NTSB SEA02LA116Accident · No injuriesLimited investigationFinal reportBeech G35 · Yakima, WAEmpennage flutter which resulted in structural damage during descent for landing. Turbulence was a factor.Jun 21, 2002 · N4647D · Substantial damage NTSB SEA02LA043Accident · No injuriesLimited investigationFinal reportBeech G35 · Anacortes, WAThe pilot's inadvertent failure to lower the landing gear prior to touchdown.Feb 26, 2002 · N168B · Substantial damage NTSB SEA01LA115Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Eastsound, WAFailure of the engine driven fuel pump due to a worn snap ring which resulted in a loss of engine power during initial climb. Failure to comply with Service Bulletin inspection instructions, and collision with trees were factors.Jun 9, 2001 · N7362B · Substantial damage NTSB ANC99LA005Accident · 1 fatalLimited investigationFinal reportBeech G-35 · Neah Bay, WAUndetermined. Missing Aircraft.Oct 4, 1998 · N4479D · Destroyed NTSB SEA93LA217Accident · No injuriesLimited investigationFinal reportBeech G35 · Arlington, WAFracture of the left stabilizer spar.Sep 15, 1993 · N4641D · Substantial damage NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.Sep 22, 1992 · N7337B · Substantial damage NTSB SEA79DYP19Accident · No injuriesClosedBeech G-35 · Mattawa, WAMay 11, 1979 · N191B · Substantial damage NTSB SEA76DYE55Accident · No injuriesClosedBeech B35 · Olympia, WAAug 26, 1976 · N5206C · Substantial damage NTSB SEA73FYE24Accident · No injuriesClosedBeech F35 · Lester, WAJan 2, 1973 · N4218B · Substantial damage NTSB SEA72DYE13Accident · No injuriesClosedBeech A35 · Prevost, WASep 9, 1971 · N654B · Substantial damage NTSB SEA70FWD06Accident · No injuriesClosedBeech 35 · Georgetown, WAMar 23, 1970 · N3164V · Substantial damage NTSB SEA68A0013Accident · No injuriesClosedBeech C35 · Seattle, WAAug 8, 1967 · N5928C · Substantial damage NTSB SEA66D0179Accident · No injuriesClosedBeechcraft 35 · Pullman, WADec 17, 1965 · N3854N · Substantial damage NTSB UNK65X0367Accident · No injuriesClosedBeech F35 · Ocean Shores, WAOct 22, 1964 · N4218B · Substantial damage NTSB UNK64X4083Accident · No injuriesClosedBeechcraft C35 · Kelso, WASep 21, 1964 · N1877D · Substantial damage