NTSB investigations: Continental A&C65 series, 1985, WA
5 cases on aircraft whose registry engine model is Continental A&C65 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 | 2 |
|---|---|
| 1965 | 5 |
| 1966 | 3 |
| 1967 | 4 |
| 1968 | 4 |
| 1969 | 3 |
| 1970 | 7 |
| 1971 | 1 |
| 1972 | 2 |
| 1973 | 3 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 3 |
| 1977 | 5 |
| 1978 | 1 |
| 1979 | 3 |
| 1980 | 2 |
| 1981 | 2 |
| 1983 | 2 |
| 1985 | 5 |
| 1986 | 4 |
| 1988 | 2 |
| 1989 | 2 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 2 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
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\") = 1985
AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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'))
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."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
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'))
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 SEA85LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Ridgefield, WAThe acft stalled at an alt of aprx 15 AGL and contacted the terrain hard during a landing at a pvt airstrip. The acft does not have a stall warning system. The plt stated that he should have maintained a proper airspeed.NTSB SEA85FA212Accident · Serious injuriesField investigationFinal reportLuscombe 8A · Renton, WAThe inexperienced, low time student pilot reported a gradual loss of power while operating his luscobe 8A aircraft on a personal, local flight. The aircraft was equipped with a stromberg carburetor whose mixture was permanently wired full open and power was…NTSB SEA85FA171Accident · 2 fatalField investigationFinal reportPiper J3-C-65 · Goose Prairie, WAThe acft contacted trees while the plt was performing low level passes over a boy scout camp. Witnesses reported the plt made three passes over the camp and during one of those passes, the plt dropped a bag of candy bars to the scouts. The fourth, during…NTSB SEA85LYE01Accident · No injuriesFinal reportLuscombe 8A · Cheney, WAAcft was found abandoned after sustaining substantial damage in apparent lndg attempt in snow-covered marsh. Presumed pilot had expired student certificate and had registered acft to self under an alias. Circumstances of mishap unknown.