NTSB investigations: Continental E185 series
15 cases on aircraft whose registry engine model is Continental E185 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1984 | 1 |
|---|---|
| 1985 | 2 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 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.\"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\" = 351))
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."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" = 351))
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 LAX05LA208Accident · Serious injuriesLimited investigationFinal reportBeech C35 · Pasadena, CAa fuel starvation induced loss of engine power due a failure of the electric fuel pump. A factor in the accident was the dark night lighting conditions.NTSB CHI03LA221Accident · Minor injuriesLimited investigationFinal reportNavion L-17A · Canton, ILA complete loss of engine power during landing approach for undetermined reasons, as well as the unsuitable terrain for a forced landing encountered by the pilot. Contributing factors were the berm and the crops.NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.NTSB MIA00LA157Accident · Serious injuriesLimited investigationFinal reportNavion L-17B · Sharpsburg, GATotal loss of engine power due to debris (aluminum) from an undetermined source found in the engine-driven fuel pump cavity resulting in the shearing of the hollow pump fuel shaft, and subsequent forced landing to none suitable terrain.NTSB FTW00LA038Accident · Serious injuriesLimited investigationFinal reportBeech BE35 · Stillwater, OKThe total loss of engine power due to the dry-rotted diaphragms in the pressure carburetor. A factor was the hilly terrain encountered during the forced landing.NTSB CHI99LA340Accident · No injuriesLimited investigationFinal reportNavion A · Utica, NEthe failure of the fuel pump and the misjudged touchdown point by the pilot. A factor was the high vegetation.NTSB LAX98FA119Accident · Minor injuriesField investigationFinal reportBeech A35 · Auburn, CAfailure of the engine driven fuel pump drive coupling and the pilot's failure to perform the emergency procedure specified in the Pilot Operating Handbook.NTSB NYC95LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Shadyside, OHThe loss of oil pressure, which resulted in the number six connecting rod failure and penetration through the crankcase.NTSB MIA95LA066Accident · No injuriesLimited investigationFinal reportBeech 35 · Sardis, MSA loss of engine power due to fuel starvation caused by a fuel selector stem failure, due to wear, that precluded the pilot from selecting a fuel tank that had fuel.NTSB SEA94LA001Accident · No injuriesLimited investigationFinal reportBeech A35 · Heber City, UTFuel starvation brought on by the absence of the roll pin which engages the fuel selector handle to the fuel selector valve shaft, and the pilot in command's misjudging his flare resulting in a hard landing.NTSB BFO93LA009Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Dublin, VAImproper adjustment of the fuel pressure regulator which produced an inadequate fuel flow and subsequent fuel starvation. Factors related to the accident were: the rough terrain and trees in the emergency landing area.NTSB LAX88LA243Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Lancaster, CANTSB FTW85LA349Accident · No injuriesLimited investigationFinal reportRyan Navion · Midland, TXThe plt experienced eng failure during climbout from sky ranch arpt at Midland, TX. He then turned into the wind and made a forced landing in a pasture. Subsequent investigation revealed a connecting rod had broken, however, the cause of the rod failure was…NTSB MKC85FCQ04Accident · Serious injuriesFinal reportRyan Navion · Blue Rapids, KSThe acft eng lost power after a 30 minute flt and a forced landing resulted in an off.-arpt acc. Witnesses at the acc site did not find any fuel in the tanks or evidence of spillage of fuel. An inspection of the eng did not reveal any discrepancies. A…NTSB SEA84LA040Accident · No injuriesLimited investigationFinal reportBeech A35 · Renton, WAThe acft was damaged during a forced landing after the engine quit after takeoff. The plt said he noticed the oil pressure drop to zero a few minutes after takeoff and was turning back to the arpt when the engine quit. He did not lower the landing gear since…