NTSB investigations: Continental W670 series

8 cases on aircraft whose registry engine model is Continental W670 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19822026

NTSB investigations: Continental W670 series per year, 1982–2026: 8 cases
1982	2
1989	1
1992	1
1993	1
1995	2
2000	1

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17018') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17018')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17018')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 IAD00LA062Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75-N1 · Atwater, OHLoss of total engine power due to a fractured crankshaft.Jul 18, 2000 · N75647 · Substantial damage NTSB MIA96LA018Accident · Minor injuriesLimited investigationFinal reportBoeing E75N1 · Wauchula, FLA total loss of engine power due to worn serrated teeth on the valve timing gear and intermediate camshaft drive gear which prevented the valve train and generator from operating. A factor was the lack of suitable terrain for the forced landing.Nov 4, 1995 · N1535M · Substantial damage NTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.Jun 8, 1995 · N53232 · Substantial damage NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.Sep 12, 1993 · N54941 · Substantial damage NTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.Jul 31, 1992 · N62552 · Destroyed NTSB MIA89IA080Incident · Minor injuriesIncident investigationFinal reportWaco UPF-7 · Marathon, FLFuel starvation due to a corroded carburetor.Feb 6, 1989 · N39721 · Minor damage NTSB ATL83LA066Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Anderson, SCAfter takeoff, while several hundred feet in the air, the engine backfired & quit. The plt was able to turn around & head back toward the arpt, but could not quite reach the rwy. The acft landed 1,000 ft short of the rwy, hit a ditch & flipped over. The plt…Dec 16, 1982 · N61857 · Substantial damage NTSB CHI82DA237Accident · No injuriesFinal reportWaco UPF-7 · Popular Grove, ILThe pilot experienced severe engine vibration during cruise flight. The pilot performed an emergency landing in a field. Because of the length of the field the pilot landed hard and the left main gear collapsed. The separated gear struck and fractured the…Jul 4, 1982 · N39714 · Substantial damage