Skip to content

NTSB investigations: Cessna 170B, IL

30 cases on aircraft the registry lists as Cessna 170B. 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.aircraft_model_code IN ('2072306', '2072307')) 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.aircraft_model_code IN ('2072306', '2072307'))
  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.aircraft_model_code IN ('2072306', '2072307'))
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 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 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 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 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 CHI81FEE15Accident · No injuriesClosedCessna 170B · Roscoe, ILDec 24, 1980 · N4362B · Substantial damage NTSB CHI78DEE45Accident · No injuriesClosedCessna 170B · Kewanee, ILJun 12, 1978 · N4692C · Substantial damage NTSB CHI74FEV38Accident · No injuriesClosedCessna 170B · Carlinville, ILJan 29, 1974 · N3004A · Substantial damage NTSB CHI74FEV20Accident · No injuriesClosedCessna 170B · St Joseph, ILSep 8, 1973 · N2758C · Substantial damage NTSB CHI72DEE40Accident · No injuriesClosedCessna 170B · Moline, ILOct 21, 1971 · N3532C · Substantial damage NTSB CHI71DEV39Accident · No injuriesClosedCessna 170B · Peoria, ILApr 29, 1971 · N8293A · Substantial damage NTSB CHI71DBD64Accident · No injuriesClosedCessna 170 · Rockford, ILApr 10, 1971 · N3487D · Substantial damage NTSB CHI71FBQ12Accident · Serious injuriesClosedCessna 170B · Jerseyville, ILAug 28, 1970 · N8233A · Destroyed NTSB CHI70DBQ21Accident · No injuriesClosedCessna 170B · Waggoner, ILJun 12, 1970 · N4517C · Substantial damage NTSB CHI69A0099Accident · 1 fatalClosedCessna 170B · Sparta, ILJun 7, 1969 · N2791C · Destroyed NTSB CHI69D0504Accident · No injuriesClosedCessna 170B · Sterling, ILFeb 12, 1969 · N1637D · 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 CHI68D0286Accident · No injuriesClosedCessna 170B · Ipava, ILSep 8, 1967 · N2899C · Substantial damage NTSB CHI67D0655Accident · No injuriesClosedCessna 170B · Rockford, ILMar 29, 1967 · N2779D · Substantial damage NTSB CHI67D0488Accident · No injuriesClosedCessna 170B · Sandwich, ILNov 5, 1966 · N2272D · Substantial damage NTSB CHI67D0061Accident · No injuriesClosedCessna 172D · Northbrook, ILJul 7, 1966 · N2971D · Substantial damage NTSB CHI66F0386Accident · No injuriesClosedCessna 170B · Half Day, ILAug 29, 1965 · N4550C · Substantial damage NTSB CHI66F0010Accident · No injuriesClosedCessna 170B · E St Louis, ILMay 13, 1965 · N3289A · Substantial damage NTSB UNK65X0797Accident · No injuriesClosedCessna 170B · Peoria, ILNov 22, 1964 · N4316B · Substantial damage NTSB UNK64X2442Accident · Minor injuriesClosedCessna 170B · Polo, ILJun 23, 1964 · N3009A · Substantial damage NTSB UNK64X0222Accident · No injuriesClosedCessna 170B · Gibson City, ILJan 11, 1964 · N3409C · Substantial damage