NTSB investigations: Continental 0-200 series, 2003

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

19822026
NTSB investigations: Continental 0-200 series, 2003 per year, 1982–2026: 164 cases
19824
19833
19845
19854
19864
19877
19889
19893
19907
19916
19926
19937
19945
19953
19965
19974
19988
199910
20007
200112
20029
20039
20046
20054
20065
200712

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\") = 2003
    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\" = 350))
  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 ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.Oct 6, 2003 · N4662X · Substantial damageNTSB FTW04CA002Accident · No injuriesData collectionFinal reportPrice Cuby Acro Trainer · Canutillo, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the pilot's inadequate in-flight planning and decision making.Oct 4, 2003 · N300HS · Substantial damageNTSB CHI03LA281Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fennimore, WIThe loss of engine power in cruise flight due to carburetor icing. A factor was the unsuitable terrain the pilot encountered during his forced landing.Aug 23, 2003 · N61134 · Substantial damageNTSB LAX03CA261Accident · No injuriesData collectionFinal reportCessna 150C · Tucson, AZthe pilot's inadequate inflight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.Aug 22, 2003 · N7909Z · Substantial damageNTSB NYC03LA134Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mount Holly, NJA loss of engine power for undetermined reasons.Jun 23, 2003 · N18146 · Substantial damageNTSB FTW03LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Temple, TXThe total loss of engine power for an undetermined reason. Contributing factors were the night conditions and the lack of suitable terrain for the forced landing.May 20, 2003 · N6520G · Substantial damageNTSB ANC03LA033Accident · Serious injuriesLimited investigationFinal reportHughes Stol King · Seldovia, AKThe loss of engine power during initial climb for an undetermined reason, which resulted in a hard landing.Mar 23, 2003 · N1243W · Substantial damageNTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Mar 15, 2003 · N493RA · Substantial damageNTSB ATL03LA048Accident · No injuriesLimited investigationFinal reportCessna 150F · Rome, GAThe maintenance personnel failure to secure the throttle linkage during the installation of the carburetor that resulted in the loss of engine power.Feb 22, 2003 · N8115F · Substantial damage