NTSB investigations: Continental W670 series, MO
11 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 |
|---|---|
| 1973 | 2 |
| 1976 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2007 | 1 |
| 2009 | 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\" = 'MO' 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" = 'MO' 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 CEN10CA060Accident · No injuriesData collectionFinal reportBoeing B75N1 · St. Louis, MOA loss of engine power for undetermined reasons.NTSB CHI07CA194Accident · Minor injuriesData collectionFinal reportBoeing N2S-3 · Trenton, MOThe pilot's failure to maintain sufficient altitude/clearance above the water while maneuvering. A factor in the accident was the low altitude maneuver attempted by the pilot.NTSB CHI00LA195Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman A75N1(PT17) · Windsor, MOfuel exhaustion and the pilot abruptly applying normal brakes during the landing roll. Factors relating to this accident were the precautionary landing, and the pilot's inadequate in-flight planning/ decision.NTSB CHI93LA357Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Springfield, MOthe disconnection of the primer supply line at the fuel strainer.NTSB CHI92LA133Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Washington, MOThe pilot in command's improper use of the carburetor heat control.NTSB MKC89LA128Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Creve Coeur, MOImproper use of the carburetor heat by the pilot and carburetor ice. Contributing factors were: carburetor icing conditions, high obstructions and terrain conditions (corn crop).NTSB MKC81FCA10Accident · Serious injuriesClosedGrumman G-164 · Neelyville, MONTSB MKC76FCA21Accident · Minor injuriesClosedBoeing B75N1 · St Charles, MONTSB MKC74FCA09Accident · No injuriesClosedBoeing A75N1 · Creve Coeur, MONTSB MKC74DCA04Accident · No injuriesClosedBoeing A75 · Hannibal, MONTSB UNK64X2147Accident · Minor injuriesClosedBoeing B75N1 · Mexico, MO