NTSB investigations: Continental W670 series, KS
19 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1969 | 3 |
| 1971 | 1 |
| 1973 | 5 |
| 1974 | 1 |
| 1975 | 1 |
| 1999 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'KS' 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" = 'KS' 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" DESCRun 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 CEN25LA370Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Benton, KSThe pilot's failure to maintain clearance from a moving vehicle during an evasive maneuver from a perceived conflict with another airplane. Contributing to the accident was the pilot of the other airplane’s non-standard phraseology and inaccurate position…NTSB CEN16LA177Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Osage City, KSA partial loss of engine power for reasons that could not be determined based on the available information.NTSB CEN15LA294Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Louisburg, KSA partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB CHI99LA158Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman PT-27 · Grainfield, KSThe pilot's improper in-flight decision and failure to maintain adequate clearance with the ground.NTSB MKC75DCQ56Accident · No injuriesClosedBoeing A75N1 · Stafford, KSNTSB MKC74DCQ47Accident · No injuriesClosedBoeing A75 · Hepler, KSNTSB MKC74DCQ19Accident · No injuriesClosedCessna 190 · Bennington, KSNTSB MKC74FCQ11Accident · No injuriesClosedBoeing A75L · Ingalls, KSNTSB MKC74FCQ04Accident · Serious injuriesClosedFairchild M62C · Garden City, KSNTSB MKC73DCG48Accident · Minor injuriesClosedBoeing B75N1 · Garnett, KSNTSB MKC73DCQ29Accident · Minor injuriesClosedBoeing A75N1 · Pittsburg, KSNTSB MKC71DCQ35Accident · No injuriesClosedBoeing A75N1 · Liberal, KSNTSB MKC70D0155Accident · No injuriesClosedGrumman G-164 · Johnson, KSNTSB MKC70D0124Accident · No injuriesClosedCallair A-9 · Plains, KSNTSB MKC69D0441Accident · No injuriesClosedBoeing A75 · Axtell, KSNTSB MKC67F0060Accident · No injuriesClosedBoeing A75N1 · Mcdonald, KSNTSB MKC67F0135Accident · No injuriesClosedBoeing A75N1 · Newton, KSNTSB MKC66F0024Accident · No injuriesClosedGrumman G-164 · Manhattan, KSNTSB UNK64X2841Accident · No injuriesClosedBoeing A75 · Norton, KS