NTSB investigations: Continental C85 series, AK
6 cases on aircraft whose registry engine model is Continental C85 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 2004 | 1 |
| 2006 | 1 |
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 c.\"eventStateOrRegion\" = 'AK' 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')
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\" = 353))
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" = 'AK' 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')
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" = 353))
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 ANC06LA129Accident · No injuriesLimited investigationFinal reportPiper J5A · North Pole, AKThe pilot's inadequate in-flight planning, which resulted in a loss of engine power due to fuel starvation during cruise flight, and an emergency landing.NTSB ANC04LA109Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot's failure to use carburetor heat during takeoff/initial climb, which resulted in a total loss of engine power, and an in-flight collision with trees.NTSB ANC88LA113Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Dillingham, AKThe pilot-in-command was beginning his descent for landing at Dillingham, Alaska and did not apply carburetor heat until his engine began to sputter. The engine stopped producing power and the pilot was unable to restart the engine. He landed on the tundra…NTSB ANC87LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Nenana, AKThe pilot lost control on takeoff, stalled and crashed on a frozen lake. During the interview with the pilot, he stated that the engine quit on initial climbout; he believed he did not pre-heat the engine long enough before takeoff. At the time of the…NTSB ANC85FA027Accident · No injuriesField investigationFinal reportCessna 140 · Wasilla, AKOn go-around during a simulated forced landing over a dirt landing strip engine began to sputter and run rough. Plt stated power was reduced and engine began to run smooth. Fuel tank was switched and 15 to 20 seconds later, engine quit. Forced landing was…NTSB SEA83LA152Accident · No injuriesLimited investigationFinal reportCessna 120 · Tenakee Springs, AKThe acft nosed over during a forced landing on a rocky beach at night. The pilot did not use carburetor heat during the engine restart attempts.