NTSB investigations: Continental 0-200 series, IL

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

19852026
NTSB investigations: Continental 0-200 series, IL per year, 1985–2026: 6 cases
19851
19921
19951
19991
20011
20031

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\" = 'IL' 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\" = 250))
  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 CHI03FA202Accident · 1 fatalField investigationFinal reportCessna 150L · Schaumburg, ILThe pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.Jul 8, 2003 · N10257 · DestroyedNTSB CHI02FA006Accident · 1 fatalField investigationFinal reportCessna 150L · Union, ILThe pilot not maintaining appropriate airspeed which resulted in an inadvertent stall.Oct 20, 2001 · N6609G · DestroyedNTSB CHI00LA007Accident · No injuriesLimited investigationFinal reportCessna 150M · Wheeling, ILaircraft control not maintained by the pilot. A factor to the accident was the windshear.Oct 10, 1999 · N2977V · Substantial damageNTSB CHI96LA019Accident · No injuriesLimited investigationFinal reportCessna 150M · Centralia, ILthe pilot's improper use of flaps leading to the inadvertant stall.Oct 25, 1995 · N63566 · Substantial damageNTSB CHI92FA142Accident · 2 fatalField investigationFinal reportTaylorcraft F19 · Harvard, ILThe pilot's failure to maintain control of the aircraft during the initial climb out. A related factor is the pilot's lack of recent experience.May 10, 1992 · N3688T · DestroyedNTSB CHI85FEE03Accident · Serious injuriesFinal reportCessna 150L · Plainfield, ILThe student departed chicago midway & flew to the clow arpt to practice takeoffs & landings. On downwind at clow, the wind blew the acft toward the arpt, causing it to be too close in to the rwy. Subsequently, the student overshot the turn to final apch &…Jul 5, 1985 · N5356Q · Substantial damage