NTSB investigations: Continental C90 series, 1989
14 cases on aircraft whose registry engine model is Continental C90 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 | 78 |
|---|---|
| 1965 | 82 |
| 1966 | 79 |
| 1967 | 63 |
| 1968 | 49 |
| 1969 | 43 |
| 1970 | 38 |
| 1971 | 32 |
| 1972 | 37 |
| 1973 | 33 |
| 1974 | 30 |
| 1975 | 22 |
| 1976 | 17 |
| 1977 | 27 |
| 1978 | 19 |
| 1979 | 14 |
| 1980 | 16 |
| 1981 | 9 |
| 1982 | 15 |
| 1983 | 7 |
| 1984 | 16 |
| 1985 | 8 |
| 1986 | 15 |
| 1987 | 16 |
| 1988 | 13 |
| 1989 | 14 |
| 1990 | 11 |
| 1991 | 16 |
| 1992 | 7 |
| 1993 | 14 |
| 1994 | 9 |
| 1995 | 9 |
| 1996 | 8 |
| 1997 | 7 |
| 1998 | 8 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 9 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 12 |
| 2005 | 8 |
| 2006 | 8 |
| 2007 | 5 |
| 2008 | 8 |
| 2009 | 10 |
| 2010 | 13 |
| 2011 | 11 |
| 2012 | 11 |
| 2013 | 9 |
| 2014 | 6 |
| 2015 | 5 |
| 2016 | 9 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 11 |
| 2020 | 8 |
| 2021 | 8 |
| 2022 | 7 |
| 2023 | 8 |
| 2024 | 4 |
| 2025 | 8 |
| 2026 | 9 |
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\") = 1989
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
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") = 1989
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
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 CHI90LA007Accident · No injuriesLimited investigationFinal reportCessna 140A · Peoria, ILInadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.NTSB ANC89LA180Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork, AKImproper planning/decision by the pilot.NTSB FTW89LA164Accident · No injuriesLimited investigationFinal reportCessna 140A · Austin, TXThe pilot's failure to maintain directional control of the aidrcraft. The gusty crosswind condition was a related factor.NTSB ANC89FA143Accident · No injuriesField investigationFinal reportPiper PA-19 · Anchorage, AKOperation with a known deficiency in the aircraft and water contamination of the fuel due to inadequate preflight preparation by the pilot. Factors related to the accident were: lack of suitable terrain for a forced landing and tree(s).NTSB ANC89LA136Accident · No injuriesLimited investigationFinal reportCessna 140 · Sparrevohn, AKPilot-in-command's failure to maintained directional control of the airplane during takeoff. The misjudged terrain was a contributing factor in the eventual outcome.NTSB ANC89LA135Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kodiak, AKThe pilot failed to maintain directional control and inadvertently allowed the aircraft to ground loop.NTSB NYC89LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Walpole, MEA loss of engine power for undetermined reasons. Contributing to the accident was the powerline which the airplane contacted.NTSB ANC89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-100 · Knik River, AKThe failure of the pilot-in-command to maintain control of the airplane on the ground by proper use of the flight controls during gusting winds.NTSB NYC89LA144Accident · Minor injuriesLimited investigationFinal reportAlon Aircoupe A-2 · Cattaraugus, NYEngine power loss due to fuel starvation resulting from the installation of an improper fuel pump. A factor related to the accident was: trees in the emergency landing area.NTSB MKC89LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ramsey, MNThe passengers interference with the flight controls and the pilot's failure to maintain control of the aircraft. Contributing to the severity of the accident was the ditch located short of the runway which the aircraft contacted.NTSB CHI89LA093Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, MIThe pilot's poor judgement, poor aircraft handling, and the resultant hard touchdown.NTSB DEN89LA125Accident · No injuriesLimited investigationFinal reportChampion 7EC · St George, UTInadequate compensation for the wind conditions by the pilot. The gusty crosswind, soft terrain, and ditch were contributing factors.NTSB ANC89LA047Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igiugig, AKThe pilot's failure to maintain control of the airplane and his failure to understand the performance parameters of his airplane.NTSB LAX89FA099Accident · 1 fatalField investigationFinal reportSilvaire 8F · Lake Elsinore, CALoss of aircraft control due to improper and/or unapproved modifications to the aircraft's aileron control system by the pilot/owner. A contributing factor was the pilot/owner's overconfidence in his ability to modify the aileron control system without…