NTSB investigations: Continental E185 series, CA
6 cases on aircraft whose registry engine model is Continental E185 series, where the first occurrence was “Loss of control - in flight”. 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 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 2 |
| 2007 | 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\" = 'CA' 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 ('17014')
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\" = 250))
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" = 'CA' 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 ('17014')
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" = 250))
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 LAX07CA237Accident · Minor injuriesData collectionFinal reportBeech C35 · Redlands, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall.NTSB FTW89GA170Accident · 2 fatalFinal reportBeech A35 · Escondido, CASpatial disorientation of the pilot after he initiated flight into IMC conditions, and his exceeding the design stress limits of the airplane during the attempted recovery. Related factors were: the pilot's lack of total and recent instrument flight…NTSB LAX89LA176Accident · No injuriesLimited investigationFinal reportBeech 35 · Sierraville, CAThe pilot's attempt to land downwind on the runway and the inability to attain a climb after aborting the landing which resulted in a stall and uncontrolled descent into the ground.NTSB LAX86FUM04Accident · 2 fatalFinal reportSteen Skybolt UNK · Chula Vista, CADuring a local pleasure flight, the aircraft was observed to make a climbing right turn to the inverted position. When observed a few seconds later, the aircraft was right side up in a shallow spin. The aircraft remained in this position until colliding with…NTSB LAX85FA283Accident · Serious injuriesField investigationFinal reportBeech 35 · Cameron Park, CAIt could not be determined which of the two private plts on board the acft was serving as PIC & at the controls of the acft. The density alt was computed to be 4100 ft. there was very little wind & the max allowable gross weight was exceeded by aprx 123…NTSB LAX83FUM01Accident · 4 fatalFinal reportBeech A35 · Oceanside, CADuring arrival, the aircraft entered downwind for a right traffic pattern to runay 24. At that time, a witness (a well qualified pilot) noted that the wind was from the northeast at about 8 KTS. Another pilot-witness stated that the wind was from the…