NTSB investigations: Continental A&C75 series, 2003
7 cases on aircraft whose registry engine model is Continental A&C75 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 | 48 |
|---|---|
| 1965 | 34 |
| 1966 | 33 |
| 1967 | 39 |
| 1968 | 28 |
| 1969 | 19 |
| 1970 | 19 |
| 1971 | 19 |
| 1972 | 16 |
| 1973 | 15 |
| 1974 | 12 |
| 1975 | 14 |
| 1976 | 16 |
| 1977 | 17 |
| 1978 | 15 |
| 1979 | 17 |
| 1980 | 15 |
| 1981 | 9 |
| 1982 | 11 |
| 1983 | 14 |
| 1984 | 5 |
| 1985 | 8 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 8 |
| 1989 | 2 |
| 1990 | 6 |
| 1991 | 9 |
| 1992 | 2 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 5 |
| 1996 | 5 |
| 1997 | 7 |
| 1998 | 5 |
| 1999 | 5 |
| 2000 | 10 |
| 2001 | 6 |
| 2002 | 6 |
| 2003 | 7 |
| 2004 | 2 |
| 2005 | 6 |
| 2006 | 7 |
| 2007 | 5 |
| 2008 | 5 |
| 2009 | 9 |
| 2010 | 10 |
| 2011 | 6 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 5 |
| 2019 | 6 |
| 2020 | 4 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 3 |
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\") = 2003
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005'))
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") = 2003
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17005'))
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 CHI04LA016Accident · Serious injuriesLimited investigationFinal reportOostdik M-18-X · Pana, ILThe pilot's attention was diverted to a person on the ground which resulted in his failure to maintain altitude/clearance with trees . A contributing factor to the accident were trees.NTSB CHI04LA008Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Harvard, ILThe pilot misjudged his altitude and distance from the approach end of the airstrip, along with his decision to land at an unlit airstrip at night. Factors involved in the accident were the the night lighting conditions, the unlit airstrip, and the corn crop…NTSB LAX03LA260Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Saint Johns, AZThe failure of the exhaust valve on the number two engine cylinder, which resulted in a partial loss of engine power during the final approach to land, and an on ground collision with a ditch during the subsequent off-airport landing roll.NTSB CHI03LA167Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Atwood, ILThe pilot's selection of an unsuitable landing area and his improper decision to continue the approach without the airport and runway clearly in-sight. Factors contributing to the accident were the pilot's disorientation, the transmission wires, and the road…NTSB CHI03LA165Accident · No injuriesLimited investigationFinal reportEngineering & Research 415-C · Independence, KSA loss of engine power due to fuel starvation. A factor to the accident was the pilot's improper installation of the fuel cap.NTSB SEA03LA107Accident · No injuriesLimited investigationFinal reportPippert Zenith Air CH 701 · Rochester, WALoose jet in the carburetor while on climb out resulting in a loss of engine power.NTSB FTW03LA123Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ranger, TXThe loss of engine power for an undetermined reason.