NTSB investigations: Continental A&C75 series, 1987
6 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\") = 1987
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") = 1987
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 ATL88LA050Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Union City, TNThe plt rprtd the acft started to veer off the rwy after a 'rough' lndg. He atmtd to steer the plane with the steering control, but it would not respond. Subsequently, the acft veered off the rwy. About 50' to the side of the rwy, the nose gear hit a hole &…NTSB LAX88DUQ01Accident · 1 fatalFinal reportStits Elkins 85 · Camarillo, CADuring the starting procedures for a local flight, the pilot had chocked the wheels and was hand-propping the engine. After several tries, the engine started. The airplane jumped the chocks and the pilot moved to the right wing, attempting to stop the…NTSB LAX87LA283Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Galt, CADuring the takeoff ground roll on a 2000 ft private runway, at the point to rotate, the plt applied back pressure, however, the aircraft did not respond. Aprx three quarters of the way down the rwy the plt realized that the acft was not lifting off and he…NTSB DEN87LA078Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Englewood, COThe student plt said the acft ballooned during the flare and he applied forward stick. The acft touched down nose wheel first and the nose gear collapsed. The acft then settled hard on main gear resulting in additional damage.NTSB ATL87LA090Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Cottondale, ALThe plt performed a touch-and-go after takeoff. During the takeoff phase of the touch-and-go, the acft eng quit. The acft was force landed in tree. Post accident inspection failed to reveal any failure/malfunction.NTSB MIA87LA092Accident · No injuriesLimited investigationFinal reportPiper J5A · Brooksville, FLShortly after take off the eng began to lose power. Unable to maintain alt a forced landing was made in a field, during which, the acft sustained substantial damage. Inspection of the acft revealed that the loss of power was the result of an insufficient fuel…