NTSB investigations: Continental 0-200 series, WA

6 cases on aircraft whose registry engine model is Continental 0-200 series, where the defining event was Loss of engine power (total). 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

20092026
NTSB investigations: Continental 0-200 series, WA per year, 2009–2026: 6 cases
20091
20111
20151
20171
20181
20241

Latest 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 ('17020')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341'))
  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.

NTSB WPR24LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Ritzville, WAMaintenance personnel’s improper installation of the No. 2 cylinder exhaust valve, which allowed the valve to drop into the cylinder and resulted in a total loss of engine power.Jul 15, 2024 · N714PW · Substantial damageNTSB GAA18CA519Accident · No injuriesData collectionFinal reportCessna 150 · Everett, WAA total loss of engine power due to carburetor icing during final approach, which resulted in a hard landing short of the runway and the nose landing gear collapsing.Jul 22, 2018 · N45586 · Substantial damageNTSB WPR17LA194Accident · No injuriesClass 3 · LimitedFinal reportPaul Gaywood E CH 601 HD · Goldendale, WAA total loss of engine power for reasons that could not be determined based on the available information.Aug 26, 2017 · N9066F · Substantial damageNTSB WPR15FA268Accident · Serious injuriesField investigationFinal reportCessna 150F · Port Townsend, WAThe loss of engine power due to the mechanic's inadequate tightening of the crankshaft gear retaining bolts during an engine overhaul, which resulted in fatigue failure of the bolts and the crankshaft gear dowel pin that allowed the crankshaft gear to…Sep 28, 2015 · N8529G · Substantial damageNTSB WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.Apr 24, 2011 · N23295 · Substantial damageNTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.Jul 24, 2009 · N22278 · Substantial damage