NTSB investigations: Continental 0-200 series, TX

5 cases on aircraft whose registry engine model is Continental 0-200 series, where the first occurrence was “Loss of engine power(partial) - nonmechanical”. 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

19872026
NTSB investigations: Continental 0-200 series, TX per year, 1987–2026: 5 cases
19871
19891
19911
19991
20061

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\" = 'TX' 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 354))
  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 DFW06CA119Accident · No injuriesData collectionFinal reportCessna 150G · Coleman, TXThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain available for the forced landing.May 6, 2006 · N3815J · Substantial damageNTSB FTW99LA069Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Nemo, TXA partial loss of engine power due to the obstructed fuel vent line and fuel cap vent.Jan 25, 1999 · N152PA · Substantial damageNTSB FTW91LA130Accident · No injuriesLimited investigationFinal reportCessna 150G · Hitchcock, TXA power loss for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the forced landing. Factors were the pilot's continued operation with a known engine deficiency and the owner/operator's failure to perform needed maintenance.Jul 29, 1991 · N8585J · Substantial damageNTSB FTW89LA169Accident · No injuriesLimited investigationFinal reportCessna 150 · Powell, TXThe pilot's improper use of carburetor heat resulting in a partial, non-mechanical power loss from carburetor icing conditions.Sep 19, 1989 · N8256F · Substantial damageNTSB FTW87FA047Accident · Serious injuriesField investigationFinal reportCessna 150F · Rio Vista, TXPrivate pilot of Cessna 150K experienced partial power loss after departing private strip near Rio Vista, TX. Pilot attempted to return for landing. After take off he was unablle to sustain climb. Aircraft hit utility pole, aircraft control was lost and…Jan 24, 1987 · N8033F · Destroyed