NTSB investigations: Continental 0-200 series, KS

5 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

19872026
NTSB investigations: Continental 0-200 series, KS per year, 1987–2026: 5 cases
19871
19901
19911
19961
19981

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\" = 'KS' 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\" = 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 CHI98LA138Accident · No injuriesLimited investigationFinal reportCessna 150H · Benton, KSthe pilot's failure to assure an adequate fuel supply to complete the flight by refueling the airplane en route resulting in fuel exhaustion. A factor was the hedgerow which was contacted during the landing and the dark night conditions.May 3, 1998 · N6977S · Substantial damageNTSB CHI96LA296Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.Aug 14, 1996 · N61094 · 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 MKC90LA087Accident · No injuriesLimited investigationFinal reportCessna 150 · Salina, KSFuel exhaustion, fuel calculations misjudged and refueling not performed by the pilot in command.Apr 18, 1990 · N714EB · Substantial damageNTSB MKC87LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Newton, KSThe stu was practicing simulated engine failures at his cfi's direction. As the stu simulated corrective action in the cockpit to restore pwr, he inadvertently turned the fuel selector off, and did not tell the CFI. Normally the CFI terminated the simulated…Mar 6, 1987 · N704QT · Substantial damage