NTSB investigations: Continental C90 series, 2004
12 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\") = 2004
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") = 2004
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 SEA05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Spanaway, WAThe pilot's misjudgment of distance/altitude during final approach to land which resulted in an undershoot and in flight collision with a fence. A factor was the pilot's alcohol impairment.NTSB IAD05LA011Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Clarksburg, WVThe pilot's inability to operate the airplane's brake pedals which resulted in the loss of aircraft control.NTSB ANC05CA011Accident · No injuriesData collectionFinal reportChampion 7FC · Talkeetna, AKThe instructor pilot's inadequate supervision of the student, which resulted in a loss of control during the landing roll, and subsequent nose over.NTSB ANC04CA105Accident · No injuriesData collectionFinal reportPiper PA-18 · Healy, AKThe pilot's inadequate compensation for wind conditions, and failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with vegetation and a nose over. A factor contributing to the accident was a tailwind.NTSB ANC04CA082Accident · Minor injuriesData collectionFinal reportPiper J3C · Palmer, AKThe pilot's inadequate evaluation of the wind conditions which resulted in an encounter with a downdraft during the takeoff/initial climb, and subsequent collision with trees and terrain. Factors contributing to the accident were the presence of a downdraft,…NTSB ATL04LA158Accident · 1 fatalLimited investigationFinal reportPitts S-1 · Durham, NCThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin and subsequent in-flight collision with terrain.NTSB NYC04CA159Accident · No injuriesData collectionFinal reportLuscombe 8F · Andover, NJThe pilot's failure to maintain aircraft control during approach. A factor was windshear.NTSB CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…NTSB ATL04LA100Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Fort Pierce, FLThe loss of engine power due to fuel starvation resulting from a crack in the gascolator bowl.NTSB LAX04FA168Accident · 2 fatalField investigationFinal reportAlon A2 · Cameron Park, CAThe pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in a stall/spin. Also causal was the partial loss of engine power due to improperly secured magnetos.NTSB FTW04LA096Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Portland, TXThe pilots failure to maintain airspeed resulting in an inadvertant stall while executing a forced landing. A factor was the loss of engine power for undetermined reasons.NTSB CHI04LA082Accident · No injuriesLimited investigationFinal reportAlon A2 Ercoupe · Hawley, MNThe loss of engine power for undetermined reasons. A contributing factor was the fence post.