NTSB investigations: Continental W670 series, CA
7 cases on aircraft whose registry engine model is Continental W670 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1988 | 1 |
|---|---|
| 1989 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1998 | 1 |
Where
Latest 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\" = 'CA' 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')
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\" = 260))
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" = 'CA' 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')
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" = 260))
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 LAX98LA074Accident · No injuriesLimited investigationFinal reportCessna 195 · Long Beach, CAThe pilot's failure to maintain directional control during the landing, which led to a ground loop and a resultant overload failure of the right main landing gear attach points.NTSB LAX96LA201Accident · No injuriesLimited investigationFinal reportBoeing-Brown E75NL · Columbia, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.NTSB LAX91LA370Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Wallace, CAThe pilot's failure to properly align his airplane with the runway and his failure to maintain directional control during takeoff. Contributing factors related to the presence of rough and downhill terrain adjacent to the runway.NTSB LAX89LA205Accident · No injuriesLimited investigationFinal reportCessna 190 · Livermore, CAThe failure of the flight instructor to maintain directional control. Contributing to the accident was the flight instructors lack of experience in this type aircraft.NTSB LAX89LA089Accident · No injuriesLimited investigationFinal reportCessna 190 · Sonoma, CAA jammed brake mechanism resulting in the pilot's inability to maintain directional control.NTSB LAX88LA178Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Sacramento, CA