Skip to content

NTSB investigations: Continental IO-360 series, NY

20 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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA13CA375Accident · Minor injuriesData collectionFinal reportMark C Pauls RV-7A · Cortland, NYA partial loss of engine power during go-around due to incorrect maintenance of the fuel system by the pilot/builder.Aug 25, 2013 · N411AK · Substantial damage NTSB ERA12LA428Accident · No injuriesLimited investigationFinal reportCessna R172K · Greene, NYAn undetected fatigue crack on the outer surface of the No. 3 cylinder barrel that could only have been detected visually and not by a differential compression test , resulting in separation of the head from the barrel and a subsequent partial loss of engine…Jul 1, 2012 · N758JQ · Substantial damage NTSB NYC08FA041Accident · 1 fatalField investigationFinal reportCirrus Design SR20 · New Windsor, NYThe pilot's failure to maintain the proper glidepath during an instrument-landing-system approach in fog. Contributing to the accident were pilot fatigue and air traffic control's failure to issue a minimum safe altitude warning.Nov 21, 2007 · N108GD · Substantial damage NTSB NYC99LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Ramapo, NYFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor in the accident was the flight instructor's inadequate supervision of the solo cross-country flight.Apr 3, 1999 · N2743V · Substantial damage NTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).May 17, 1998 · N5471S · Substantial damage NTSB NYC94FA176Accident · No injuriesField investigationFinal reportWDL 1B · Farmingdale, NYInadequate design of the airship, which allowed the center ballonet to overfill and to collapse the trunking to the fore and aft ballonets, rendering the airship uncontrollable. Factors related to the accident were: inadequate maintenance by the…Sep 11, 1994 · N317TW · Substantial damage NTSB NYC90LA091Accident · No injuriesLimited investigationFinal reportCessna O337F · Brant, NYThe pilot's premature rotation and failure to obtain airspeed.Apr 25, 1990 · N1814M · Substantial damage NTSB NYC89LA098Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bethel, NYImproper planning/decision by the pilot concerning his fuel management, which resulted in fuel exhaustion due to an inadequate supply of fuel. The false indication from the fuel quantity gage(s), dark night, and trees were considered to be factors.Mar 10, 1989 · N2265X · Destroyed NTSB NYC84LA152Accident · No injuriesLimited investigationFinal reportCessna 337D · New Paltz, NYAbout 5 mins after departing the arpt, the front eng began to gradually lose power. The plt turned back toward the arpt & adjusted the fuel selector to various settings. The front eng continued to lose power and the rear eng began losing power. Subsequently,…May 5, 1984 · N86094 · Substantial damage NTSB NYC83IA182Incident · No injuriesIncident investigationFinal reportCessna 172XP · Mechanicville, NYAfter starting the engine and taxiing forward the pilot stated he pushed the trottle by mistake and the acft moved rapidy forward and struck a parked acft.Jul 19, 1983 · N8123V · Minor damage NTSB NYC82DA159Accident · No injuriesFinal reportCessna R172E · Latham, NYPilot reduced power to idle on final approach and when he tried to add power there was no response. No reason for failure was found.Jul 15, 1982 · N26209 · Substantial damage NTSB NYC81FHJ11Accident · No injuriesClosedMaule M-4 · Farmingdale, NYJul 27, 1981 · N9861M · Substantial damage NTSB NYC79FA024Accident · 2 fatalClosedCessna 172K · Dover Plains, NYFeb 23, 1979 · N736FW · Destroyed NTSB NYC76FHM28Accident · No injuriesClosedMaule M-4 · Stormville, NYMay 15, 1976 · N51419 · Substantial damage NTSB NYC76DHM22Accident · No injuriesClosedMaule M-4 · Mahopac, NYMar 14, 1976 · N27HM · Substantial damage NTSB NYC75DFA19Accident · No injuriesClosedMaule M-4 · Glens Falls, NYOct 27, 1974 · N27HM · Substantial damage NTSB NYC72DFJ02Accident · No injuriesClosedCessna 337C · Buffalo, NYJul 16, 1972 · N2662S · Substantial damage NTSB NYC71DHM16Accident · Minor injuriesClosedMaule M4 · Ellenville, NYJan 31, 1971 · N9843M · Substantial damage NTSB NYC69D0215Accident · No injuriesClosedCessna 337 · White Plains, NYSep 15, 1968 · N2511S · Substantial damage NTSB NYC68F0155Accident · Serious injuriesClosedMaule M-4 · Ballston, NYJul 14, 1967 · N9856M · Destroyed