NTSB investigations: Continental 0-200 series, 2011

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

20082026
NTSB investigations: Continental 0-200 series, 2011 per year, 2008–2026: 69 cases
20088
20095
20104
20116
20125
20133
20144
20154
20166
20173
20183
20193
20201
20215
20222
20242
20253
20262

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 year(c.\"eventDate\") = 2011
    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 ERA12CA125Accident · Serious injuriesData collectionFinal reportCessna 150H · Knoxville, TNThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Dec 26, 2011 · N22565 · Substantial damageNTSB CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.Oct 7, 2011 · N642EZ · Substantial damageNTSB ERA11LA411Accident · No injuriesLimited investigationFinal reportCessna 150M · Elizabethtown, KYA total loss of engine power for undetermined reasons.Jul 20, 2011 · N8576U · 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 CEN11LA182Accident · No injuriesLimited investigationFinal reportCessna 150L · Trenton, MIThe loss of preload torque on a connecting rod nut and bolt, which precipitated a separation of the connecting rod from the engine's crankshaft and resulted in the total loss of engine power.Feb 12, 2011 · N6622G · Substantial damageNTSB CEN11CA221Accident · No injuriesData collectionFinal reportCessna 150L · Gonzales, LAThe flight instructor's failure to monitor the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.Feb 5, 2011 · N11790 · Substantial damage