Skip to content

NTSB investigations: Cessna 175, MI

16 cases on aircraft the registry lists as Cessna 175. 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" = 'MI' 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 ('2072502')) 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\" = 'MI' 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 ('2072502'))
  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" = 'MI' 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 ('2072502'))
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 CHI07FA016Accident · 1 fatalField investigationFinal reportCessna 175 · Battle Creek, MIA loss of engine power while in cruise flight due to an oil leak from the nose seal of the reduction gear case. Contributing to the accident were the oil leak, the pilot's reduced visibility out the windscreen, and rising terrain.Nov 2, 2006 · N9408B · Substantial damage NTSB CHI04LA137Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Blissfield, MIThe pilot selected the wrong runway on which to land which resulted in exceeding the proper touchdown point during landing. Factors associated with the accident were the tailwind condition and the drainage ditch which the airplane contacted.Jun 4, 2004 · N9401B · Substantial damage NTSB CHI04LA028Accident · No injuriesLimited investigationFinal reportCessna 175 · Mears, MILoss of engine power due to carburetor icing and the pilot's delayed application of carburetor heat during descent. A factor was the carburetor icing conditions.Nov 8, 2003 · N9275B · Substantial damage NTSB CHI03FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 175 · MIUndetermined. Missing aircraft.Nov 11, 2002 · N7091M · Substantial damage NTSB CHI00FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 175 · MIundetermined.Nov 12, 1999 · N6533E · Destroyed NTSB CHI93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Houghton Lake, MIThe pilot operating the airplane with a known deficiency.May 9, 1993 · N7303M · Destroyed NTSB CHI89DEM04Accident · No injuriesFinal reportCessna 175 · Lawton, MIThe pilot's delay in aborting takeoff and his excessive rate of descent at touchdown. A factor in the accident was the pilot's inadequate preflight planning.Jul 15, 1989 · N7404M · Substantial damage NTSB CHI86LA211Accident · No injuriesLimited investigationFinal reportCessna 175 · Muskegon, MIJust prior to applying takeoff power the pilot switched to the left fuel tank. Fuel from this tank had never been used by this pilot since he purchased the aircraft two weeks earlier. Shortly after breaking ground the engine quit. Although the pilot switched…Aug 23, 1986 · N9275B · Substantial damage NTSB CHI86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Gregory, MIThe newly purchased acft was being flown off of the seller's turf strip. After taking off, the acft struck 50 ft trees off of the end of the runway. The seller, who watched the takeoff, stated that the pilot overrotated the acft after lift-off.Mar 16, 1986 · N7191M · Substantial damage NTSB CHI76FEC38Accident · Serious injuriesClosedCessna 175 · Lansing, MIApr 7, 1976 · N1515S · Destroyed NTSB CHI74FEM20Accident · Serious injuriesClosedCessna 175 · Kalamazoo, MISep 9, 1973 · N7482M · No damage NTSB CHI69F0378Accident · No injuriesClosedCessna 175 · Laingsburg, MINov 22, 1968 · N6546E · Destroyed NTSB CHI69F0230Accident · No injuriesClosedPiper PA-28 · Saginaw, MIAug 13, 1968 · N6433R · 2 aircraft · Substantial damage NTSB CHI68D0406Accident · No injuriesClosedCessna 175 · West Branch, MIOct 5, 1967 · N7134M · Substantial damage NTSB CHI68F0257Accident · No injuriesClosedCessna 175 · Byron Center, MIJul 14, 1967 · N9429B · Substantial damage NTSB UNK65X0402Accident · No injuriesClosedCessna 175 · East Tawas, MIOct 24, 1964 · N6646E · Substantial damage