Skip to content

NTSB investigations: Continental 0-200 series, IL

233 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, newest first

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."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.\"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."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 CHI85LA113Accident · No injuriesLimited investigationFinal reportRutan Varieze · Mt. Vernon, ILThe acft lndg gear collapsed after several lndgs. The plt was practicing touch & go lndgs and completed 5 circuits. During the 6th lndg the main gear collapsed at touchdown. The nose gear then collapsed this model varieze was equipped with a lndg gear that…Feb 17, 1985 · N101MW · Substantial damage NTSB CHI85LA074Accident · No injuriesLimited investigationFinal reportCessna 150F · Staunton, ILWhile taxiing for takeoff at a private airstrip, the acft contacted a parked truck. The plt attributed the collision to his lack of alertness.Dec 22, 1984 · N8232F · Substantial damage NTSB CHI84LA079Accident · No injuriesLimited investigationFinal reportCessna 150G · Plato Center, ILThe acft nosed over during a forced landing after the engine lost power. After the accident oil samples from the acft were analyzed and found to contain anti-freeze. The acft owner suspected sabotage.Jan 8, 1984 · N2396U · Substantial damage NTSB CHI83LA385Accident · No injuriesLimited investigationFinal reportCessna 150 · Savanna, ILThe plt reported the winds were from 160 deg at 7 KTS & that he back taxied on rwy 14 to takeoff. He reported that during the takeoff roll, he encountered a right x-wind, & when he was aprx 2/3 of the way down the rwy, the acft veered to the left. After…Aug 17, 1983 · N11279 · Destroyed NTSB CHI83LA374Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ILThe acft made a forced landing in a corn field and nosed down after the engine stopped during flt. During pre-flt the pilot had looked in the tanks and measured the amount of fuel with the tie cap chain. He thought he had enough fuel for the flt even though…Aug 9, 1983 · N3400V · Substantial damage NTSB CHI83LA087Accident · No injuriesLimited investigationFinal reportCessna 150M · Cahokia, ILThe acft collided with a ditch during a forced landing after the engine quit during a takeoff climb. The student pilot was climbing out after a touch and go landing and at about 200 ft AGL the engine quit. The CFI took control of the acft and checked for an…Jan 20, 1983 · N704LQ · Substantial damage NTSB CHI83LA009Accident · No injuriesLimited investigationFinal reportCessna 150M · Lawsing, ILOn landing roll the student pilot inadvertently added power, ran off the end of the runway and into a ditch.Oct 5, 1982 · N63627 · Substantial damage NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…Jul 29, 1982 · N60028 · Substantial damage NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…Jul 9, 1982 · N61130 · Substantial damage NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…May 8, 1982 · N8197F · Substantial damage NTSB CHI82DA097Accident · No injuriesFinal reportCessna 150 · Wheeling, ILThe student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right…Mar 24, 1982 · N714KR · Substantial damage NTSB CHI81DEE45Accident · No injuriesClosedCessna 150 · Morris, ILJun 18, 1981 · N11729 · Substantial damage NTSB CHI81FEV13Accident · No injuriesClosedCessna 150M · Williamsville, ILApr 25, 1981 · N63288 · Substantial damage NTSB CHI80FA069Accident · 1 fatalClosedCessna 150J · Akin, ILSep 22, 1980 · N60771 · Destroyed NTSB CHI80DEE36Accident · No injuriesClosedCessna 150M · Wonder Lake, ILJul 10, 1980 · N704LB · Substantial damage NTSB CHI80DEE40Accident · No injuriesClosedCessna 150 · Lockport, ILJul 4, 1980 · N3946V · Substantial damage NTSB CHI80DEE15Accident · No injuriesClosedCessna 150 · Mt.Morris, ILFeb 8, 1980 · N8964U · Substantial damage NTSB CHI80FEV11Accident · No injuriesClosedCessna 150H · Springfield, ILDec 3, 1979 · N22931 · Substantial damage NTSB CHI79FEE67Accident · No injuriesClosedFriling Variez · Plainfield, ILJul 17, 1979 · N28JF · Substantial damage NTSB CHI79FEV14Accident · No injuriesClosedCessna 150 · Lincoln, ILMar 12, 1979 · N19358 · Substantial damage NTSB CHI79FEV11Accident · No injuriesClosedCessna 150 · Champaign, ILFeb 17, 1979 · N66092 · Substantial damage NTSB CHI79DEE35Accident · No injuriesClosedCessna 150 · Spring Valley, ILJan 22, 1979 · N3089S · Substantial damage NTSB CHI79DEE22Accident · No injuriesClosedCessna 150 · Naperville, ILDec 26, 1978 · N1294Q · Substantial damage NTSB CHI79FEE21Accident · No injuriesClosedCessna 150 · Mendota, ILDec 17, 1978 · N23JR · Substantial damage NTSB CHI79DEV06Accident · No injuriesClosedCessna 150 · Monmouth, ILDec 9, 1978 · N704PT · Substantial damage NTSB CHI79DEE13Accident · No injuriesClosedCessna 150 · Lanark, ILOct 10, 1978 · N5896G · Substantial damage NTSB CHI78FCA03Accident · No injuriesClosedCessna 150M · Cahokia, ILSep 22, 1978 · N714LV · Substantial damage NTSB CHI78DEE67Accident · No injuriesClosedCessna 150 · Wheeling, ILSep 16, 1978 · N9437U · Substantial damage NTSB CHI78FA052Accident · 2 fatalClosedPiper PA-22 · East Moline, ILAug 6, 1978 · N3217B · 2 aircraft · Destroyed NTSB CHI78DEE66Accident · No injuriesClosedCessna 150 · Aperville, ILJul 18, 1978 · N3026S · Substantial damage NTSB CHI78FEV44Accident · No injuriesClosedCessna 150 · Peoria, ILJul 8, 1978 · N45530 · Substantial damage NTSB CHI78DEE48Accident · No injuriesClosedCessna 150 · Plato Center, ILJun 21, 1978 · N11554 · Substantial damage NTSB CHI78FEV23Accident · No injuriesClosedCessna 152 · Monmouth, ILMar 27, 1978 · N24242 · 2 aircraft · Substantial damage NTSB CHI78DEV20Accident · No injuriesClosedCessna 150 · Carbondale, ILMar 6, 1978 · N66009 · Substantial damage NTSB CHI78DEE28Accident · No injuriesClosedCessna 150M · West Chicago, ILMar 5, 1978 · N704LF · Substantial damage NTSB CHI78DEE24Accident · No injuriesClosedCessna 150M · Lockport, ILFeb 22, 1978 · N9408U · Substantial damage NTSB CHI78DEE23Accident · No injuriesClosedCessna 150 · Wheeling, ILFeb 19, 1978 · N9474U · Substantial damage NTSB CHI78FEE21Accident · No injuriesClosedCessna 150J · Wedron, ILFeb 12, 1978 · N60731 · Substantial damage NTSB CHI78DEE22Accident · No injuriesClosedCessna 150 · Lockport, ILFeb 9, 1978 · N714LC · Substantial damage NTSB CHI78DEE16Accident · No injuriesClosedCessna 150 · Lockport, ILJan 23, 1978 · N63646 · Substantial damage NTSB CHI78FEE18Accident · No injuriesClosedCessna 150L · Wheeling, ILJan 3, 1978 · N1575Q · Substantial damage NTSB CHI78FEE13Accident · No injuriesClosedCessna 150 · Plainfield, ILNov 26, 1977 · N19410 · Substantial damage NTSB CHI78DEV02Accident · No injuriesClosedCessna 150 · Pittsfield, ILOct 6, 1977 · N10524 · Substantial damage NTSB CHI78FEE02Accident · No injuriesClosedCessna 150 · Kankakee, ILOct 2, 1977 · N6572T · Substantial damage NTSB CHI77FEE44Accident · Minor injuriesClosedCessna 150M · Plainfield, ILAug 14, 1977 · N66776 · Substantial damage NTSB CHI78FEE43Accident · No injuriesClosedCessna 150 · Joliet, ILJul 19, 1977 · N6998G · Substantial damage NTSB CHI77FA050Accident · 1 fatalClosedCessna 150H · Benton, ILJun 13, 1977 · N7087S · Destroyed NTSB CHI77DEE22Accident · No injuriesClosedCessna 150 · Lansing, ILApr 30, 1977 · N9235U · Substantial damage NTSB CHI77FEE19Accident · Minor injuriesClosedCessna 150M · Kankakee, ILApr 16, 1977 · N45127 · Substantial damage NTSB CHI77DEV20Accident · No injuriesClosedCessna 150 · Thompsonville, ILApr 16, 1977 · N23127 · Substantial damage