NTSB investigations: Continental W670 series, MS
16 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
| 1965 | 3 |
|---|---|
| 1967 | 3 |
| 1968 | 2 |
| 1969 | 1 |
| 1974 | 3 |
| 1978 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 2006 | 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\" = 'MS' 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" = 'MS' 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 DFW06CA194Accident · Serious injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Jackson, MSThe pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall and a subsequent loss of control.NTSB MIA87LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Ruleville, MSWhile maneuvering the acft for a swath run after takeoff the plt stated that it was slow to climb. He then lowered the nose to increase airspeed, & realizing that the acft would not clear trees located ahead of the flt, elected to land in a field. Upon…NTSB ATL80FLT09Accident · No injuriesClosedGrumman G-164 · Olive Branch, MSNTSB MIA78FKQ11Accident · No injuriesClosedWaco UPF-7 · Meridian, MSNTSB MIA75FKQ19Accident · Minor injuriesClosedBoeing A75 · Merigold, MSNTSB MIA75FKQ10Accident · 1 fatalClosedBoeing B75 · Eagle Lake, MSNTSB MIA75FKQ03Accident · 2 fatalClosedBoeing A75N1 · Greenville, MSNTSB MIA69F0481Accident · No injuriesClosedBoeing A75N1 · Yazoo City, MSNTSB MIA68F0512Accident · Serious injuriesClosedBoeing A75N1 · Merigold, MSNTSB MIA68F0440Accident · No injuriesClosedBoeing A75N1 · Leland, MSNTSB MIA68D0264Accident · No injuriesClosedBoeing B75N1 · Belzoni, MSNTSB MIA68D0059Accident · No injuriesClosedBoeing A75N1 · Tomnolen, MSNTSB MIA67A0090Accident · No injuriesClosedBoeing A75N1 · Tralake, MSNTSB MIA66F0285Accident · No injuriesClosedBoeing B-75N1 · Webb, MSNTSB MIA66F0194Accident · No injuriesClosedGrumman T-G164 · Charleston, MSNTSB MIA66F0091Accident · No injuriesClosedBoeing A-75N1 · Avalon, MS