NTSB investigations: Continental W670 series, 1995
7 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 | 31 |
|---|---|
| 1965 | 28 |
| 1966 | 27 |
| 1967 | 32 |
| 1968 | 24 |
| 1969 | 21 |
| 1970 | 17 |
| 1971 | 18 |
| 1972 | 14 |
| 1973 | 23 |
| 1974 | 23 |
| 1975 | 14 |
| 1976 | 17 |
| 1977 | 14 |
| 1978 | 11 |
| 1979 | 12 |
| 1980 | 18 |
| 1981 | 9 |
| 1982 | 9 |
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 6 |
| 1988 | 8 |
| 1989 | 14 |
| 1990 | 6 |
| 1991 | 10 |
| 1992 | 10 |
| 1993 | 5 |
| 1994 | 8 |
| 1995 | 7 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 4 |
| 2000 | 8 |
| 2001 | 2 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 6 |
| 2005 | 5 |
| 2006 | 6 |
| 2007 | 7 |
| 2008 | 5 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 5 |
| 2017 | 7 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 1995
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 year(c."eventDate") = 1995
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 LAX96LA066Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Chino, CAthe pilot's failure to see and avoid light poles. A poorly planned approach was a factor.NTSB MIA96LA018Accident · Minor injuriesLimited investigationFinal reportBoeing E75N1 · Wauchula, FLA total loss of engine power due to worn serrated teeth on the valve timing gear and intermediate camshaft drive gear which prevented the valve train and generator from operating. A factor was the lack of suitable terrain for the forced landing.NTSB NYC95LA231Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Staten Island, NYFailure of the propeller blade due to fatigue, which resulted in severe vibration, subsequent separation of the engine, and a forced landing.NTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.NTSB ANC95LA143Accident · Serious injuriesLimited investigationFinal reportWaco UPF-7 · Anchorage, AKThe pilot's inadequate preflight planning/preparation, which resulted in an unlocked engine primer and subsequent loss of engine power.NTSB ATL95LA107Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Fayetteville, GAA malfunction of the carburetor needle valve which resulted in fuel starvation to the engine.NTSB SEA95LA109Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Rawlins, WYThe pilot's failure to maintain a proper climb rate. Factors contributing to the accident were the high density altitude and the rising terrain.