NTSB investigations: Continental A&C65 series, 1985
3 cases on aircraft whose registry engine model is Continental A&C65 series, where the first occurrence was “Loss of engine power”. 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
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 4 |
Where
Latest 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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 SEA85LA232Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Lopez Island, WAShortly after takeoff the acft's eng ceased operating for unknown reasons. During the landing rollout, the acft struck a fence and nosed over.NTSB NYC85LA197Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Coventryville, NYDuring a local flt over Coventryville, NY, the plt decided to overfly and observe a building. The plt made one pass and was about to make another when the eng began to lose pwr. While planning to land in a nearby fld, the eng regained pwr and the plt…NTSB SEA85LA179Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Yamhill, ORThe eng ceased operating at aprx 40 ft AGL during initial takeoff climb. Investigation disclosed the acft had been fueled with a mixture of automotive fuel and 80/87 avgas. The acft had sat on the ground for over 4 hrs with a surface tem of 95 degs f. a…