Fatal NTSB investigations: Continental 0-200 series, IL

10 cases on aircraft whose registry engine model is Continental 0-200 series. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Fatal NTSB investigations: Continental 0-200 series, IL per year, 1964–2026: 10 cases
1964	1
1969	1
1976	1
1977	1
1978	1
1980	1
1987	1
1992	1
2001	1
2003	1

Where

Open the map

Latest cases

Query with SQL

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."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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"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'))
  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.

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."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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

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 · Destroyed NTSB CHI02FA006Accident · 1 fatalField investigationFinal reportCessna 150L · Union, ILThe pilot not maintaining appropriate airspeed which resulted in an inadvertent stall.Oct 20, 2001 · N6609G · Destroyed NTSB 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 · Destroyed NTSB CHI88DEV01Accident · 1 fatalFinal reportCessna 150L · Marion, ILPilot in command suffered a fatal heart attack. His wife, a private pilot, attempted to land the aircraft, lost control on landing roll and struck a runway light.Dec 5, 1987 · N7533G · Substantial damage NTSB CHI80FA069Accident · 1 fatalClosedCessna 150J · Akin, ILSep 22, 1980 · N60771 · Destroyed NTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · Destroyed NTSB CHI77FA050Accident · 1 fatalClosedCessna 150H · Benton, ILJun 13, 1977 · N7087S · Destroyed NTSB CHI76FC079|CHI76AC079Accident · 5 fatalClosedCessna 150M · Rockford, ILJul 17, 1976 · N66375 · 2 aircraft · Destroyed NTSB MKC70A0027Accident · 2 fatalClosedCessna 150E · Esmond, ILNov 9, 1969 · N426RA · Destroyed NTSB UNK64X0566Accident · 1 fatalClosedCessna 150 · Chicago, ILFeb 14, 1964 · N2030Z · Destroyed