Skip to content

NTSB investigations: Continental IO-360 series, MI

18 cases on aircraft whose registry engine model is Continental IO-360 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

19652026

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 ('17025', '17045')) 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 ('17025', '17045'))
  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 ('17025', '17045'))
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 CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.Dec 29, 2018 · N1095V · Destroyed NTSB CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.Jul 31, 2009 · N337BA · Substantial damage NTSB CHI08CA263Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Greenville, MIThe deer that ran onto the runway contacting the airplane. A factor associated with the accident was the dark night conditions.Aug 26, 2008 · N1281 · Substantial damage NTSB CHI08LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Muskegon, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing available to the pilot due to the presence of a residential sub-division and trees.Oct 13, 2007 · N1261X · Substantial damage NTSB CHI06CA279Accident · No injuriesData collectionFinal reportMeyers MAC-145 · Manistique, MIThe pilot not verifying the landing gear selector position prior to starting the taxi.Aug 6, 2006 · N34360 · Substantial damage NTSB CHI03LA110Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Ironwood, MIThe pilot's inadvertent ground loop on landing. A contributing factor was the ditch.Apr 23, 2003 · N9014A · Substantial damage NTSB CHI02LA220Accident · No injuriesLimited investigationFinal reportCessna R172K · Flushing, MIA loss of engine power for undetermined reasons. Contributing to the accident was the wet runway.Jul 28, 2002 · N1086V · Substantial damage NTSB CHI96LA042Accident · No injuriesLimited investigationFinal reportCessna T337G · Pontiac, MIthe pilot's improper level-off and improper recovery from a bounced landing.Nov 26, 1995 · N6CX · Substantial damage NTSB CHI95LA231Accident · Serious injuriesLimited investigationFinal reportCessna 337H · Holland, MIthe passenger's improper decision to exit the airplane with the engine(s) running.Jul 22, 1995 · N53449 · No damage NTSB CHI89LA172Accident · No injuriesLimited investigationFinal reportCessna T-337D · Howell, MIThe pilot's poor preflight planning and inaccurate fuel consumption calculations. Contributing factor was maintenance personnel's not performing correct calibration of fuel gages.Aug 19, 1989 · N33N · Substantial damage NTSB CHI81FA001Accident · 3 fatalClosedCessna 337H · Waterford, MIOct 14, 1980 · N1333L · 2 aircraft · Destroyed NTSB CHI75FEC38Accident · No injuriesClosedCessna T337B · Pontiac, MIFeb 22, 1975 · N2414S · Substantial damage NTSB CHI75FEC34Accident · No injuriesClosedCessna 337A · Howell, MIJan 6, 1975 · N5403S · Substantial damage NTSB CHI72FEC18Accident · No injuriesClosedCessna 337 · Ann Arbor, MINov 10, 1971 · N2113X · Substantial damage NTSB CHI71FDW25Accident · Minor injuriesClosedCessna 337 · Durand, MIDec 4, 1970 · N5431S · Substantial damage NTSB CHI68F0463Accident · No injuriesClosedCessna 337A · Detroit, MIDec 4, 1967 · N5327S · Substantial damage NTSB CHI67F0060Accident · No injuriesClosedCessna 170B · Grand Rapids, MIJul 4, 1966 · N4570C · Substantial damage NTSB CHI65F0118Accident · Minor injuriesClosedMaule M-4 · Jackson, MIApr 16, 1965 · N4614T · Substantial damage