Skip to content

NTSB investigations: Continental E185 series

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

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17014')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17014'))
  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'))
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 LAX83IA342Incident · No injuriesIncident investigationFinal reportBeech B-35 · Fullerton, CAThe gear collapsed on the landing roll. Gear were found to be dry. Tge pilot had a gear flag but does not remember a green light.Jul 16, 1983 · N5274C · Minor damage NTSB DEN83LA220Accident · No injuriesLimited investigationFinal reportBeech D35 · St. Thomas, NDThe plt stated that after a flt to inspect farm fields he 'made an approach to the arpt and landed with the gear up.' He said he heard the gear warning as he crossed the threshold but interpeted it as a stall warning.Jun 23, 1983 · N3422B · Substantial damage NTSB MIA83LA163Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Miami Beach, FLThe pilot stated that while cruising with another aircraft at an unknown altitude the oil pressure began to decrease. Shortly after this, the engine failed. The oil temp, cylinder temp, and exhaust gas temp remained in the normal range the engine stopped…Jun 18, 1983 · N3364V · Destroyed NTSB FTW83LA169Accident · Minor injuriesLimited investigationFinal reportBeech 35 · El Paso, TXOn a flt after an annual inspn, the plt could not retract the gear, using the normal electrical sys. It remained extended with the green safe light on & the gear pointer indicating down. He tried to assist the normal sys with the manual handcrank, although…Mar 29, 1983 · N3732N · Substantial damage NTSB LAX83FA141Accident · 2 fatalField investigationFinal reportRyan Navion A · Fiddletown, CAThe acft crashed into hilly terrain while descending to enter the traffic pattern at the rancho murieta airport. The pilot had called sacramento fss to get assistance in locating this arpt which is about 11 NM from sacramento VOR on a bearing of about 65…Mar 12, 1983 · N444N · Destroyed NTSB FTW83LA080Accident · No injuriesLimited investigationFinal reportBeech B35 · Canadian, TXThe acft collided with a tree during rollout after a forced landing following engine power loss on final approach. The pilot said he was one and a half miles out on final at 200 ft AGL when the engine quit. He was operating on the right main fuel tank. He…Jan 7, 1983 · N8849A · Substantial damage NTSB LAX83FVD03Accident · Serious injuriesFinal reportBeech B35 · Linden, CAThe aircraft engine lost power during a night cross-country. The pilot was forced to land in a grove of young walnut trees. The aircraft hit with one wing low and spun around. All motion stopped in a very short distance. An examination revealed that both fuel…Oct 27, 1982 · N5236C · Destroyed 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…Oct 10, 1982 · N696B · Substantial damage NTSB FTW82DA252Accident · No injuriesFinal reportBeech 35 · Graham, TXWhile descending through about 2800 ft AGL to land, the engine lost power. The pilot was unable to restart the engine and elected to land in an OAT field with oats about 2 to 3 ft high. The pilot reported that during the landing roll, the nose gear collapsed…Jun 28, 1982 · N2880V · Substantial damage NTSB FTW82DA222Accident · Minor injuriesFinal reportBeech C-35 · Ryan, OKOn arrival at the destination airport the pilot determined the grass strip was too wet for a landing. The pilot selecteda farm road and stated that a gust of wind struck the aircraft at about 10 to 12 feet above the road. The aircraft landed hard and swerved…Jun 13, 1982 · N679D · Destroyed NTSB FTW82DA218Accident · No injuriesFinal reportBeech 35 · Terrell, TXWhile en route, the cabin door of the aircraft popped open, approximately 10 miles from the destination. The pilot reported that he was distracted by the open door and lost airspeed while on final approach. The aircraft touched down hard just short of the…Jun 8, 1982 · N3803N · Substantial damage NTSB NYC82FFA05Accident · Serious injuriesFinal reportNavion A · Hancock, NYThe pilot reported that during takeoff, he climbed to about 20 to 30 ft and raised the gear. At about that time, the aircraft began to sink. He stated that he pulled the power off just before the aircraft hit the ground a few miles from the airport. An…May 16, 1982 · N91662 · Substantial damage NTSB FTW82FA109Accident · 2 fatalField investigationFinal reportBeech B35 · Dulce, NMApproximately 30 min after departure the acft returned to the arpt trailing smoke & occassional flame from an area near the cowl flaps & nose gear doors. The plt did not make a straight in approach but appeared to be in a normal traffic pattern. The acft…Mar 30, 1982 · N5237C · Destroyed NTSB LAX82DA091Accident · No injuriesFinal reportBeech B35 · La Jolla, CADuring flight over the water, the engine lost power and the pilot was unable to glide to a safe landing area on shore. The plane was ditched in the pacific ocean about 1/4 mile from the shore.Mar 4, 1982 · N180L · Destroyed NTSB FTW82FPJ10Accident · 1 fatalFinal reportNavion A · Chickasha, OKThe aircraft departed from a private airport 2 miles south of Chickasha at 0330. At 0336 power was interrupted on electric power lines southwest of Chickasha. The wreckage was found 6 miles south and 4 and 1/2 miles west of Chickasha a few feet west of a 35…Jan 2, 1982 · N4876K · Destroyed NTSB FTW81DPD38Accident · Minor injuriesClosedCessna 150F · Fort Worth, TXSep 7, 1981 · N8225S · Substantial damage NTSB CHI81FEP44Accident · 1 fatalClosedSteen Skyblt · Hartford, WISep 5, 1981 · N81GS · Destroyed NTSB SEA81FYP35Accident · No injuriesClosedNavion · Spangle, WAAug 16, 1981 · N91104 · Substantial damage NTSB CHI81FEK24Accident · No injuriesClosedBeech B35 · Columbus, OHJul 17, 1981 · N5138C · Substantial damage NTSB DEN81FA045Accident · 2 fatalClosedBeech C35 · Spanish Forks, UTJun 27, 1981 · N5915C · Destroyed NTSB LAX81FUA11Accident · No injuriesClosedBeech 35 · Long Beach, CAJun 23, 1981 · N2793V · Substantial damage NTSB DEN81FA037Accident · 2 fatalClosedBeech A-35R · Beaver, UTMay 16, 1981 · N3158V · Substantial damage NTSB LAX81FVM20Accident · No injuriesClosedBeech A35 · Palo Alto, CAMay 3, 1981 · N8683A · Substantial damage NTSB LAX81DUJ55Accident · No injuriesClosedBeech 35 · White Mtn Lke, AZMay 2, 1981 · N3378V · Substantial damage NTSB MKC81DCJ09Accident · No injuriesClosedNavion G · Bayard, NEApr 14, 1981 · N91551 · Destroyed NTSB ANC81DAA09Accident · No injuriesClosedLuscombe 11A · Moses Point, AKFeb 21, 1981 · N1667B · Substantial damage NTSB FTW81FRA17Accident · Minor injuriesClosedBeech A35 · La Porte, TXFeb 17, 1981 · N8407A · Substantial damage NTSB MIA81DA035Accident · 4 fatalClosedBeech C35 · Missing AircraftJan 6, 1981 · N5805C · Destroyed NTSB FTW81DQD10Accident · No injuriesClosedBeech C35 · Carlsbad, NMDec 4, 1980 · N2033D · Substantial damage NTSB SEA81FA004Accident · 3 fatalClosedNavion A · Yakima, WANov 15, 1980 · N8553H · Destroyed NTSB CHI80FEM46Accident · No injuriesClosedBeech A35 · Lincoln, MISep 13, 1980 · N2744V · Destroyed NTSB CHI80FET25Accident · No injuriesClosedBeech A-35 · Hobart, INAug 15, 1980 · N8654A · Substantial damage NTSB MIA80DKT51Accident · No injuriesClosedNavion A · W Palm Beach, FLAug 2, 1980 · N5165K · Destroyed NTSB NYC80FA053Accident · 1 fatalClosedBeech C35 · Spring Valley, NYJul 9, 1980 · N16W · Destroyed NTSB LAX80FA112Accident · 1 fatalClosedBeech 35 · Weaverville, CAJun 12, 1980 · N2948V · Destroyed NTSB ATL80DKM18Accident · No injuriesClosedNavion A · Mooresville, NCMay 19, 1980 · N91679 · Substantial damage NTSB DEN80FQA25Accident · No injuriesClosedBeech 35 · Albuquerque, NMApr 20, 1980 · N2798V · Substantial damage NTSB LAX80DVA24Accident · No injuriesClosedBeech B35 · Bakersfield, CAMar 21, 1980 · N5236C · Substantial damage NTSB MKC80FA022Accident · Serious injuriesClosedBeech A35 · Creston, IAFeb 14, 1980 · N71RT · Destroyed NTSB CHI80FEG09Accident · No injuriesClosedRyan Navion · Troy, OHFeb 6, 1980 · N4341K · Substantial damage NTSB MIA80DLD30Accident · Minor injuriesClosedBeech B-35 · Kissimmee, FLJan 19, 1980 · N5004C · Destroyed NTSB MKC80FCD07Accident · No injuriesClosedBeech C35 · Somers, IANov 30, 1979 · N8976A · Substantial damage NTSB IAD80FLQ01Accident · Minor injuriesClosedBeech A-35 · Grayson, KYOct 13, 1979 · N786B · Substantial damage NTSB CHI79FEC48Accident · No injuriesClosedBeech 35 · Detroit, MISep 3, 1979 · N3712N · Substantial damage NTSB SEA79DYE47Accident · No injuriesClosedNavion A · Snohomish, WAAug 25, 1979 · N8750H · Substantial damage NTSB MIA79FLD84Accident · Minor injuriesClosedNavion A · Lakeland, FLAug 19, 1979 · N4319K · Substantial damage NTSB OAK79FXQ28Accident · No injuriesClosedNavion NAV-4 · Reno, NVJul 29, 1979 · N8880H · Substantial damage NTSB IAD79DKM15Accident · No injuriesClosedRyan Navion · Newton, NCJun 8, 1979 · N8634H · Substantial damage NTSB FTW79FQG30Accident · No injuriesClosedNavion A · Sweetwater, TXApr 13, 1979 · N8534H · Substantial damage NTSB FTW79FQG28Accident · Serious injuriesClosedBeech B35 · Kalgary, TXApr 11, 1979 · N5266C · Destroyed