NTSB investigations: Continental C85 series, WY
16 cases on aircraft whose registry engine model is Continental C85 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 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1969 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1980 | 2 |
| 1981 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1992 | 1 |
| 1999 | 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 c.\"eventStateOrRegion\" = 'WY' 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 ('17008'))
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 c."eventStateOrRegion" = 'WY' 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 ('17008'))
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 DEN99FA075Accident · 2 fatalField investigationFinal reportPiper PA-11 · Lander, WYThe pilot inadvertently stalling the airplane. Factors were his abrupt maneuvering of the airplane to avoid a powerline, and his attention being diverted.NTSB SEA93LA045Accident · No injuriesLimited investigationFinal reportCroy KR-2M · Gillette, WYJamming of the nose landing gear door opening mechanism and the pilot in command's excessive descent rate upon touchdown.NTSB DEN88LA066Accident · No injuriesLimited investigationFinal reportPiper J3C · Cody, WYDuring an attempted landing at a private airstrip which was covered by 5-6 inches of dry powdered snow, the acft touched down. It pitched forward and nosed over. After the acft came to rest, the pilot got out of the acft, examined the landing gear, and…NTSB DEN86LA194Accident · No injuriesLimited investigationFinal reportCessna 120 · Riverton, WYPlt stated after accident '... We could not climb after initial takeoff and a pwr line was coming up so I tried to turn right and the plane stalled.' The density altitude was calculated to be 7,136 feet MSL. The plt stated that he did not lean the mixture for…NTSB DEN86LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Riverton, WYThe plt reports that the eng cowling came loose and he decided to land on a highway to secure the cowling. The approach was made to the west on the east/west road. The plt said the wind was from the south at 25 mph with gusts to 35 and the landing attempt…NTSB DEN81FTC11Accident · Minor injuriesClosedCessna 140 · Wapiti, WYNTSB DEN80FTC29Accident · Serious injuriesClosedCessna 120 · Afton, WYNTSB DEN80DTC08Accident · No injuriesClosedLuscombe 8E · Cheyenne, WYNTSB DEN76FTC23Accident · No injuriesClosedErco 415-D · Douglas, WYNTSB DEN75FTC14Accident · No injuriesClosedCessna 120 · Cheyenne, WYNTSB DEN70D0087Accident · No injuriesClosedCulver V · Casper, WYNTSB DEN70D0014Accident · Minor injuriesClosedTaylorcraft BC12-D · Lyman, WYNTSB DEN66D0281Accident · No injuriesClosedTaylorcraft BC12-D · Seely, WYNTSB DEN66F0141Accident · No injuriesClosedErcoupe 415C · Cheyenne, WYNTSB DEN65D0086Accident · No injuriesClosedLuscombe 8E · Lovell, WYNTSB UNK64X2878Accident · No injuriesClosedPiper J5 · Cody, WY