Fatal NTSB investigations: Continental 0-200 series

12 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

19832026
Fatal NTSB investigations: Continental 0-200 series per year, 1983–2026: 12 cases
19831
19841
19861
19871
19912
19931
19951
19972
20031
20041

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.\"highestInjuryLevel\" = 'Fatal'
    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 ANC04FA042Accident · 2 fatalField investigationFinal reportCessna 150C · DeLand, FLThe pilot's failure to detect water in the fuel system during the preflight inspection, which precipitated a loss of engine power during initial climb, and his failure to maintain adequate airspeed resulting in a stall.Mar 17, 2004 · N2080Z · DestroyedNTSB NYC04LA013Accident · 1 fatalLimited investigationFinal reportLoranger Emeraude CP301A · Brookville, OHThe pilot's improper decision to operate an airplane with insufficient fuel for the flight, his improper decision to return to the airport with inadequate altitude remaining, and his failure to maintain airspeed, which resulted in an inadvertent stall. A…Oct 21, 2003 · N29GL · Substantial damageNTSB 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 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 LAX95LA325Accident · 1 fatalLimited investigationFinal reportChambers C1C · Turlock, CAa loss of engine power due to fuel system contamination and the pilot's failure to maintain an adequate airspeed while maneuvering for an emergency landing. Factors in the accident were: the inadequate procedures used to purge the fuel system of known…Sep 4, 1995 · N177GE · DestroyedNTSB MIA93FA141Accident · 1 fatalField investigationFinal reportCessna 150J · Niceville, FLThe inadequate annual inspection of the airplane by other maintenance personnel and the failure of the pilot to maintain airspeed above a stall.Jun 12, 1993 · N60366 · Substantial damageNTSB CHI92FA023Accident · 1 fatalField investigationFinal reportCessna 150K · Kiowa, KSThe pilot-in-command's failure to properly utilize the carburetor heat to avoid loss of engine power due to carburetor icing. Factors contributing to the accident were the pilot-in-command's inattention and the encounter of unsuitable terrain during an…Nov 8, 1991 · N5732G · Substantial damageNTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.Apr 19, 1991 · N87VE · DestroyedNTSB SEA87FA158Accident · 1 fatalField investigationFinal reportCessna 150J · Las Vegas, NVThe student plt planned a x-country flt for 3.6 hrs. After 3.9 hrs of flt, fuel exhaustion occurred as the acft was apchg the destn arpt. The plt declared an emergency, but was unable to glide to the arpt. Witnesses observed the acft on an apch to a vacant…Aug 6, 1987 · N51358 · DestroyedNTSB MIA86FA146Accident · 1 fatalField investigationFinal reportCessna 150F · Pembroke Pines, FLA witness stated that he was standing in his front yard when he heard an acft eng sputter & then completely quit. He looked up & saw the lights of the acft disappear behind trees, & moments later, he heard the acft crash. A post crash exam of the acft…May 4, 1986 · N8268S · DestroyedNTSB NYC84FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Keymar, MDWitness stated acft was performing touch & go landings. On third or forth initial climb at about 300 ft AGL the acft began 'zigzagging.' The acft then entered a nose low atitude and descended to ground impact aprx 1/2 mile from the arpt. Inspection of…Jun 23, 1984 · N704GV · DestroyedNTSB MIA83FA058Accident · 2 fatalField investigationFinal reportCessna 150 · Green Cove Spgs, FLThe acft crashed in a spin after the engine quit during takeoff. This was one of a series of touch and go landings. The acft reached an alt of about 150 ft when the engine sputtered and quit. The acft then started a 180 degree turn which steepened into a spin…Jan 8, 1983 · N6503G · Destroyed