NTSB investigations: Continental C90 series, 1995
9 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\") = 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 ('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") = 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 ('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 FTW96LA052Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Fredericksburg, TXthe pilot's failure to maintain directional control. Factors were the binding tailwheel and the pilot's lack of experience in tailwheel airplanes.NTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.NTSB MIA96LA007Accident · No injuriesLimited investigationFinal reportForney ERCOUPE-2 · Cartersville, GAThe pilot-in-command's decision to continue flight with the inoperative fuel transfer pump which resulted in loss of engine power due to fuel starvation. The inoperative fuel transfer pump and the unsuitable terrain encountered during the forced landing were…NTSB CHI95LA329Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Hudson, WIthe pilot's improper decision to attempt a touch-and-go on a short airstrip.NTSB NYC95LA216Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Boothbay Harbor, MEthe pilot's misjudgment of distance and altitude, while on final approach to land. Factors relating to the accident were: sunglare, and the pilot's lack of visual cues (visual perception).NTSB FTW95LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-95 · Rio Hondo, TXThe failure of the pilot to properly supervise a non-passenger resulting in the individual being struck by the propeller.NTSB NYC95LA115Accident · 1 fatalLimited investigationFinal reportPitcher W-8 · Mineral, VAan electrical system problem that resulted in a blown (failed) fuze and an inoperative electric fuel pump, which in turn resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed which resulted in an…NTSB MIA95LA113Accident · No injuriesLimited investigationFinal reportCessna 140 · Foxworth, MSThe pilot-in-command's selection of an unuitable landing strip for landing.NTSB LAX95LA102Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Wickenburg, AZThe pilot-rated passenger's failure to maintain directional control of the airplane during the takeoff ground roll, and the pilot-in-command's inadequate supervision of the pilot-rated passenger, who had sole access to the airplane's brakes.