Skip to content

NTSB investigations: Continental GO-300 series, MI

17 cases on aircraft whose registry engine model is Continental GO-300 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" = '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.engine_model_code IN ('17024')) 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.engine_model_code IN ('17024'))
  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.engine_model_code IN ('17024'))
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 CEN27LA008Accident · No injuriesClass 4 · LimitedInvestigation openCessna 175A · Hastings, MIOct 8, 2026 · N6741E · Substantial damage 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 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 CHI92LA074Accident · No injuriesLimited investigationFinal reportCessna 175 · Warren, MIA loss of engine power as a result of a connecting rod failure. Factors related to the accident were the power lines and trees in the path of the selected emergency landing site.Jan 19, 1992 · N8293T · Substantial damage 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 CHI83LA313Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanwood, MIThe acft was damaged during landing from a tire failure. During landing the plt heard a report and took off again. He performed a minimum speed landing and during landing the tire rim dug into the surface causing sudden stoppage. The tirefailure had resulted…Jul 15, 1983 · N6982E · Substantial damage NTSB CHI76FEC08Accident · No injuriesClosedCessna 175 · Lambertville, MIAug 18, 1975 · N6956E · Substantial damage 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