Skip to content

NTSB investigations: Continental C145 series, IL

35 cases on aircraft whose registry engine model is Continental C145 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

Where

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17012')) 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 ('17012'))
  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 ('17012'))
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 CEN21LA058Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Waukegan, ILThe pilot’s failure to maintain directional control during takeoff with a crosswind that resulted in a ground loop and impact with terrain.Nov 8, 2020 · N77759 · Substantial damage NTSB CEN18LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Harvard, ILThe failure of the universal joint in the pilot-side flight control yoke due to the fatigue fracture of a rivet within the universal joint. Contributing to the universal joint failure was the universal joint design, which was prone to galling wear and seizure.Nov 8, 2017 · N2766D · Substantial damage NTSB GAA17CA499Accident · No injuriesData collectionFinal reportCessna 170 · Rochelle, ILThe pilot’s failure to maintain directional control during landing with a tailwind.Aug 21, 2017 · N2486D · Substantial damage NTSB CEN09CA508Accident · No injuriesData collectionFinal reportCessna 170A · Aurora, ILThe pilot's failure to maintain directional control during the landing.Aug 6, 2009 · N9793A · Substantial damage NTSB CHI06CA167Accident · Minor injuriesData collectionFinal reportCessna 170A · Atwood, ILThe loss of engine power during approach due to carburetor ice and the uneven terrain encountered during the forced landing which caused the airplane to nose over. Weather conducive to carburetor icing was a contributing factor.Jun 24, 2006 · N9204A · Substantial damage NTSB CHI97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Savoy, ILthe student pilot's failure to maintain directional control. Factors relating to this accident were the student pilot's failure to request another runway and the crosswind.Dec 14, 1996 · N2506C · Substantial damage NTSB CHI94LA332Accident · No injuriesLimited investigationFinal reportCessna 170 · St. Anne, ILEngine failure due to an inadequately reconditioned cylinder.Sep 18, 1994 · N4216V · Substantial damage NTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.Nov 14, 1992 · N2836C · Substantial damage NTSB CHI91LA286Accident · No injuriesLimited investigationFinal reportCessna 170B · Frankfort, ILThe pilot in command's failure to maintain directional control. A contributing factor was a crosswind.Aug 31, 1991 · N8244A · Substantial damage NTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…Nov 2, 1988 · N5596C · Substantial damage NTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILJul 8, 1988 · N8048A · Substantial damage NTSB CHI85LA353Accident · No injuriesLimited investigationFinal reportCessna 170B · West Chicago, ILDuring application of pwr during a touch-and go landing the acft 'started to get sideways' on the rwy. The plt allowed the acft to drift off the left side of the rwy into the grass. A ground loop subsequently occurred which substantially damaged the acft.…Aug 21, 1985 · N2209D · Substantial damage NTSB CHI85FAMS2Accident · 2 fatalMissing aircraftFinal reportCessna 170B · Chicago(L.Mich), ILAt an unknown time during the night of July 25/26 the acft crashed into lake Michigan. Exact wx conditions are unknown. The passenger was recovered from the lake the next morning, along with the two crushed front seats and two buckled interior side panels.…Jul 25, 1985 · N3160B · Destroyed NTSB CHI83LA071Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Plato Center, ILThe wind at the nearest facility was reported to be from 350 degrees at 12 KTS. The pilot reported the wind sock at the airport was showing wind from 310-320 degrees at 10 KTS or less and gusting. He made two go-arounds because of gusty winds and difficulty…Jan 2, 1983 · N4292V · Substantial damage NTSB CHI78DEE45Accident · No injuriesClosedCessna 170B · Kewanee, ILJun 12, 1978 · N4692C · Substantial damage NTSB CHI76FEV15Accident · Serious injuriesClosedCessna 170 · Enfield, ILOct 12, 1975 · N1218D · Substantial damage NTSB CHI75FCA04Accident · Minor injuriesClosedTemco GC-1B · Cahokia, ILJan 23, 1975 · N78326 · Substantial damage NTSB CHI74FEV38Accident · No injuriesClosedCessna 170B · Carlinville, ILJan 29, 1974 · N3004A · Substantial damage NTSB CHI74FEE15Accident · No injuriesClosedCessna 170A · Streator, ILAug 20, 1973 · N1390D · Substantial damage NTSB CHI72AC007Accident · 2 fatalClosedCessna 170A · Pittsfield, ILJul 16, 1971 · N1499D · Destroyed NTSB CHI71DEV39Accident · No injuriesClosedCessna 170B · Peoria, ILApr 29, 1971 · N8293A · Substantial damage NTSB CHI70DBQ21Accident · No injuriesClosedCessna 170B · Waggoner, ILJun 12, 1970 · N4517C · Substantial damage NTSB CHI70DBD51Accident · No injuriesClosedCessna 170 · Roscoe, ILMay 22, 1970 · N4113V · Substantial damage NTSB CHI70F0022Accident · Minor injuriesClosedCessna 170A · Carbondale, ILMay 29, 1969 · N5486C · Substantial damage NTSB CHI69D0274Accident · No injuriesClosedCessna 170 · Plainfield, ILSep 11, 1968 · N2246D · Substantial damage NTSB CHI69D0137Accident · No injuriesClosedCessna 170B · Rochelle, ILJul 18, 1968 · N6095V · Substantial damage NTSB CHI68F0633Accident · No injuriesClosedCessna 170 · Chicago, ILFeb 25, 1968 · N9024A · Substantial damage NTSB CHI68D0470Accident · No injuriesClosedMaule M-4 · Chicago, ILNov 18, 1967 · N4710T · Substantial damage NTSB CHI68D0286Accident · No injuriesClosedCessna 170B · Ipava, ILSep 8, 1967 · N2899C · Substantial damage NTSB CHI68D0206Accident · No injuriesClosedCessna 170 · Sycamore, ILJun 24, 1967 · N1337D · Substantial damage NTSB CHI67D0655Accident · No injuriesClosedCessna 170B · Rockford, ILMar 29, 1967 · N2779D · Substantial damage NTSB CHI66F0386Accident · No injuriesClosedCessna 170B · Half Day, ILAug 29, 1965 · N4550C · Substantial damage NTSB CHI66D0062Accident · No injuriesClosedMeyers MAC145 · Chicago, ILMar 14, 1965 · N34364 · Substantial damage NTSB UNK64X2442Accident · Minor injuriesClosedCessna 170B · Polo, ILJun 23, 1964 · N3009A · Substantial damage NTSB UNK64X1567Accident · No injuriesClosedMeyers MAC145 · Chicago, ILMay 2, 1964 · N34364 · Substantial damage