Skip to content

NTSB investigations: Continental IO-360 series, OH

15 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

19672026

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" = 'OH' 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\" = 'OH' 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" = 'OH' 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 NYC00LA227Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Columbus, OHThe pilot's failure to maintain airspeed, resulting from his improper go-around procedures following a rear engine failure. A factor was the pilot's improper fuel management, which resulted in the rear engine failure.Aug 14, 2000 · N86485 · Substantial damage NTSB BFO95LA089Accident · No injuriesLimited investigationFinal reportCessna R172K · Lisbon, OHLoss of oil, where an oil filter adapter had separated from the crankcase cover, due to stripped threads that were caused or allowed by inadequate maintenance or inspection, which resulted in oil exhaustion and subsequent loss of engine power. A factor…Aug 26, 1995 · N1439V · Substantial damage NTSB NYC94LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt. Gilead, OHthe pilot's improper inflight decision to conduct a night landing at an airport without runway lights, and the subsequent misalignment with the runway and collision with an object.Oct 2, 1993 · N736RZ · Substantial damage NTSB NYC91LA224Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Urbana, OHThe pilot's failure to follow procedures and directives which resulted in the failure of the pilot to recognize the stoppage of the rear engine prior to take off. Additionally the lack of total engine power resulted in the inability of the pilot to maintain…Aug 27, 1991 · N6304F · Substantial damage NTSB NYC91LA187Accident · No injuriesLimited investigationFinal reportMeyers MAC-145 · Elyria, OHThe failure of the pilot to maintain directional control during landing. Factors related to the accident were a strong wind shear during landing; unavailability of wheel brakes for the co-pilot; and inadequate supervision of the co-pilot during landing.Jul 23, 1991 · N34360 · Substantial damage NTSB ATL88LA024Accident · Minor injuriesLimited investigationFinal reportCessna 337C · Columbus, OHPIC rpted rear eng quit after take-off. Fuel selector found on right main tank which was empty. Prop was not feathered and landing gear was found in transient position after crash. Owners manual cautions against higher drag with gear in transit due to large…Oct 27, 1987 · N11GL · Substantial damage NTSB CHI84LA122Accident · No injuriesLimited investigationFinal reportCessna R172K · Marion, OHThe plt lost directional control of the acft during landing on an icy rwy in a gusty crosswind. The acft skidded to the left and contacted a snowbank, after which it nosed over.Mar 1, 1984 · N736JT · Substantial damage NTSB CHI81FEG04Accident · No injuriesClosedCessna 337P · Miamisburg, OHDec 31, 1980 · N8BC · Substantial damage NTSB CHI78FEI24Accident · No injuriesClosedCessna R172K · Smithfield, OHJun 28, 1978 · N736XC · Substantial damage NTSB CHI76FEI09Accident · No injuriesClosedCessna T337G · Youngstown, OHAug 9, 1975 · N8CE · Substantial damage NTSB CHI75FEG11Accident · No injuriesClosedCessna R172E · Xenia, OHFeb 1, 1975 · N14455 · Substantial damage NTSB CHI71FGD04Accident · Minor injuriesClosedMaule M4-210 · Wadsworth, OHJul 23, 1970 · N4745T · Substantial damage NTSB CHI69D0528Accident · No injuriesClosedCessna 337 · Mansfield, OHJan 25, 1969 · N2500S · Substantial damage NTSB CHI69D0527Accident · No injuriesClosedCessna 337 · Cleveland, OHDec 28, 1968 · N5487S · Substantial damage NTSB CHI67F0549Accident · No injuriesClosedCessna 337 · Delaware, OHMar 24, 1967 · N2217X · Substantial damage