NTSB investigations: Continental 0-200 series, 1997

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

19822026
NTSB investigations: Continental 0-200 series, 1997 per year, 1982–2026: 370 cases
198217
198316
198423
198515
198620
198719
198813
198923
199027
199114
199210
199324
199417
199512
199615
199717
19983
199910
200014
200112
20025
20038
200410
20056
200613
20077

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\") = 1997
    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\" = 353))
  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 FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.Oct 20, 1997 · N6206K · DestroyedNTSB LAX98LA016Accident · No injuriesLimited investigationFinal reportCessna 150 · Temple Bar, AZthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the terrain condition (ditch) in the emergency landing area.Oct 13, 1997 · N71VL · Substantial damageNTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.Sep 12, 1997 · N18503 · Substantial damageNTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.Aug 31, 1997 · N60200 · Substantial damageNTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 10, 1997 · N22286 · Substantial damageNTSB LAX97LA278Accident · No injuriesLimited investigationFinal reportCessna 150G · Palos Verdes, CALoss of engine power due to fuel starvation and the pilot's mismanagement of the aircraft's fuel supply.Aug 9, 1997 · N3084S · Substantial damageNTSB NYC97LA161Accident · No injuriesLimited investigationFinal reportCessna A150L · Waynesburg, PAthe pilot's inadequate preflight by failing to ensure there was adequate fuel on board, which resulted in fuel exhaustion during takeoff.Aug 6, 1997 · N23JR · Substantial damageNTSB FTW97LA290Accident · No injuriesLimited investigationFinal reportCessna A150K · Elgin, OKfuel contamination, and the pilot's inadequate preflight of the airplane. Trees in the emergency landing area were considered a related factor.Jul 30, 1997 · N8332M · Substantial damageNTSB NYC97LA111Accident · No injuriesLimited investigationFinal reportCessna 150K · Jay, MEthe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.Jun 8, 1997 · N6218G · Substantial damageNTSB MIA97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Miami, FLThe student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Apr 6, 1997 · N50918 · Substantial damageNTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.Apr 5, 1997 · N6106T · Substantial damageNTSB IAD97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsburgh, PAthe student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.Apr 2, 1997 · N3616J · Substantial damageNTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.Mar 20, 1997 · N5526G · Substantial damageNTSB FTW97FA109Accident · 1 fatalField investigationFinal reportKeating Quickie II · Houston, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. Factors were the pilot's lack of familiarity with the airplane, the dark night, the lack of cockpit lights, and the lack of suitable terrain for the pilot to…Feb 28, 1997 · N89WL · DestroyedNTSB ATL97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Raleigh, NCa loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.Feb 23, 1997 · N714JY · Substantial damageNTSB ATL97LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Winter Haven, FLthe student pilot's inadvertent movement of the mixture control to idle cut-off during the approach to land, which resulted in engine shut-down, and the student's failure to follow emergency procedures for restarting the engine.Feb 9, 1997 · N6679F · Substantial damageNTSB MIA97LA054Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Daytona Beach, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel for continued flight, which resulted in fuel exhaustion and subsequent collision with objects (concrete blocks) during a forced landing. Factors relating to the accident…Jan 1, 1997 · N5813G · Substantial damage