NTSB investigations: Continental W670 series, 1992
10 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\") = 1992
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") = 1992
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 CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.NTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.NTSB SEA92LA168Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Brigham City, UTA partial power loss for undetermined reasons and the pilot in command's inability to execute corrective action during the noseover. A factor contributing to the accident was the berm.NTSB LAX92FA257Accident · 2 fatalField investigationFinal reportWaco UPF-7 · Sedona, AZFuel exhaustion due to the pilots inadequate preflight planning and his failure to refuel the airplane prior to departure. Factors in the accident were: 1) the unreliable fuel sight gauges which were contaminated with a tar like residue which may have…NTSB ATL92LA128Accident · Minor injuriesLimited investigationFinal reportBoeing D75N1 · Stockbridge, GAThe improper compensation for the downwind condition by the pilot in command. A factor in the accident was the improper in flight planning to attempt a downwind landing on the short runway with rising terrain by the pilot in command.NTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.NTSB SEA92LA094Accident · No injuriesLimited investigationFinal reportFairchild 24W-40 · Toledo, WAThe pilot's inadequate compensation for wind conditions resulting in failure to maintain directional control. A factor contributing to the accident was crosswinds.NTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.NTSB CHI92LA133Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Washington, MOThe pilot in command's improper use of the carburetor heat control.NTSB MIA92LA105Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deland, FLThe pilot's inadequate compensation for wind conditions.