Skip to content

NTSB investigations: Continental W670 series, AR

27 cases on aircraft whose registry engine model is Continental W670 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" = 'AR' 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 ('17018')) 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\" = 'AR' 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 ('17018'))
  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" = 'AR' 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 ('17018'))
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 DFW08CA199Accident · No injuriesData collectionFinal reportGrumman G-164A · Newport, ARThe pilot's failure to maintain aircraft control. Contributing factors were the high temperature and tailwind.Jul 25, 2008 · N519Y · Substantial damage NTSB FTW04CA185Accident · Serious injuriesData collectionFinal reportGrumman G-164 · Havana, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight.Jul 16, 2004 · N519Y · Substantial damage NTSB FTW01FA095Accident · 2 fatalField investigationFinal reportCessna 190 · Lurton, ARthe pilot's continued VFR flight into IMC, which resulted in spatial disorientation and the ensuing loss of aircraft control while in cruise flight. Contributory factors were the haze and fog weather conditions.Apr 7, 2001 · N1055D · Destroyed NTSB FTW91LA087Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Horseshoe Bend, ARThe pilot's failure to maintain directional control of the airlane. A factor was the crosswind.May 30, 1991 · N4561N · Substantial damage NTSB MKC90LA085Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Pleasant Grove, ARImproper use of carburetor heat by the pilot, which resulted in carburetor icing. The weather (carburetor icing condition) was a related factor.Apr 14, 1990 · N1902M · Substantial damage NTSB FTW81DPG51Accident · No injuriesClosedGrumman G-164 · Cash, ARJul 2, 1981 · N10264 · Substantial damage NTSB FTW79DPG27Accident · No injuriesClosedGrumman G-164 · Burdette, ARApr 18, 1979 · N10264 · Substantial damage NTSB FTW78DPG74Accident · No injuriesClosedGrumman G-164A · Okean, ARAug 10, 1978 · N470Y · Destroyed NTSB FTW74FPG75Accident · Minor injuriesClosedCessna 190 · Brinkley, ARJun 24, 1974 · N1515D · Substantial damage NTSB FTW74FPG46Accident · No injuriesClosedStearman PT-17 · Little Rock, ARJan 31, 1974 · N6904 · Substantial damage NTSB FTW73DPG55Accident · No injuriesClosedGrumman G-164 · Devalls Bluff, ARJun 3, 1973 · N10264 · Destroyed NTSB FTW72FPG88Accident · No injuriesClosedBoeing A75 · De Witt, ARJun 24, 1972 · N62465 · Substantial damage NTSB FTW71FPG17Accident · No injuriesClosedGrumman G-164 · Gould, ARSep 3, 1970 · N464Y · Substantial damage NTSB FTW70FPG20Accident · Minor injuriesClosedBoeing E75 · Hunter, ARApr 23, 1970 · N75848 · Destroyed NTSB FTW70D0066Accident · No injuriesClosedBoeing A75 · Carlisle, ARJul 1, 1969 · N9383H · Substantial damage NTSB FTW69F0202Accident · No injuriesClosedBoeing A75 · Monette, ARSep 7, 1968 · N63624 · Substantial damage NTSB FTW69D0146Accident · Minor injuriesClosedGrumman G-164 · Brinkley, ARJul 18, 1968 · N10294 · Destroyed NTSB FTW69D0101Accident · No injuriesClosedBoeing A75 · Walnut Ridge, ARJul 6, 1968 · N53414 · Substantial damage NTSB FTW68D0514Accident · No injuriesClosedBoeing A75N1 · Dermott, ARMar 26, 1968 · N75010 · Substantial damage NTSB FTW68D0155Accident · No injuriesClosedBoeing A75N1 · Dumas, ARAug 21, 1967 · N91098 · Substantial damage NTSB FTW68F0003Accident · No injuriesClosedBoeing A75N · Lonoke, ARMay 30, 1967 · N4602N · Substantial damage NTSB FTW67D0609Accident · No injuriesClosedGrumman G-164 · Dewitt, ARMay 4, 1967 · N10226 · Substantial damage NTSB FTW67F0121Accident · No injuriesClosedBoeing A75 · Brinkley, ARJul 29, 1966 · N75641 · Destroyed NTSB FTW66D0364Accident · No injuriesClosedBoeing PT-13 · Tucker, ARSep 27, 1965 · N50072 · Substantial damage NTSB FTW66F0468Accident · No injuriesClosedGrumman G-164 · Gould, ARAug 21, 1965 · N464Y · Substantial damage NTSB UNK64X3857Accident · Minor injuriesClosedBoeing B75N1 · Olyphant, ARSep 7, 1964 · N60955 · Substantial damage NTSB UNK64X1909Accident · No injuriesClosedGrumman G164 · Wynne, ARMay 23, 1964 · N10226 · Substantial damage