NTSB investigations: Continental C85 series, FL

8 cases on aircraft whose registry engine model is Continental C85 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Continental C85 series, FL per year, 1982–2026: 8 cases
1982	2
1988	1
1993	1
1996	1
1998	2
2006	1

Where

Open the map

Latest cases

Query with SQL

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" = 'FL' 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" = 350)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'FL' 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\" = 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 c."eventStateOrRegion" = 'FL' 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" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MIA06LA118Accident · 2 fatalLimited investigationFinal reportErcoupe 415C · Panacea, FLA loss of engine power for undetermined reasons, which resulted in the airplane descending and impacting trees during the approach. A possible contributing factor was the pilot's pre-existing cardiovascular condition.Jun 22, 2006 · N99355 · Destroyed NTSB ATL98LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reasons. A factor was the unsuitable terrain.May 22, 1998 · N2102N · Substantial damage NTSB ATL98LA035Accident · No injuriesLimited investigationFinal reportPiper J5-A · Vero Beach, FLloss of engine power for undetermined reasons.Jan 20, 1998 · N38645 · Substantial damage NTSB MIA96LA178Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reason(s) during a go-around, which result in the aircraft being unable to climb above trees at the departure end of the runway.Jul 10, 1996 · N2102N · Substantial damage NTSB MIA93FA051Accident · Serious injuriesField investigationFinal reportCessna 140 · Niceville, FLA loss of engine power for undetermined reasons over terrain that was not suitable for the subsequent forced landing.Jan 18, 1993 · N89968 · Substantial damage NTSB MIA89LA036Accident · No injuriesLimited investigationFinal reportPiper J3C · Homestead, FLThe plt rprtd that while climbing at night after takeoff, the eng sputtered. He suspected possible water in the fuel & landed across rows in a field. Drg the landing, the gear failed & the acft came to rest on its belly with a bent prop, torn fabric & dmgd…Oct 25, 1988 · N26820 · Substantial damage NTSB MIA83LA026Accident · No injuriesLimited investigationFinal reportPiper J-3 · Near Melbourne, FLPilot made forced landing off airport due to power loss. Landing gear collapsed. No malfunctions found.Nov 8, 1982 · N6875H · Substantial damage NTSB MIA82DA095Accident · No injuriesFinal reportErcoupe 415-C · Merritt Island, FLThe pilot suspected a partial loss of engine power shortly after lift-off. He cut the power to land on the remaining runway. The plane touched down on the right main and nose gear, and the nose gear collapsed. The plane skidded about 100 ft before coming to…Mar 29, 1982 · N94067 · Substantial damage