Skip to content

Fatal NTSB investigations: Continental E185 series

95 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."highestInjuryLevel" = 'Fatal' 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')) 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.\"highestInjuryLevel\" = 'Fatal'
    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'))
  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."highestInjuryLevel" = 'Fatal'
  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'))
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 MIA85FA159Accident · 4 fatalField investigationFinal reportBeech C35 · Tampa, FLWitnesses observed the acft takeoff on rwy 36 in foggy conditions. They reported that during the initial climb after lift-off, the acft pitched up & rolled into a steep left bank, then entered a descent & crashed on an aprx heading of 060 deg. Impact occurred…Apr 27, 1985 · N1967D · Destroyed 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 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 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 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 CHI81FEP44Accident · 1 fatalClosedSteen Skyblt · Hartford, WISep 5, 1981 · N81GS · Destroyed NTSB DEN81FA045Accident · 2 fatalClosedBeech C35 · Spanish Forks, UTJun 27, 1981 · N5915C · Destroyed NTSB DEN81FA037Accident · 2 fatalClosedBeech A-35R · Beaver, UTMay 16, 1981 · N3158V · Substantial damage NTSB MIA81DA035Accident · 4 fatalClosedBeech C35 · Missing AircraftJan 6, 1981 · N5805C · Destroyed NTSB SEA81FA004Accident · 3 fatalClosedNavion A · Yakima, WANov 15, 1980 · N8553H · 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 LAX79FA005Accident · 3 fatalClosedBeech 35 · Williams, AZOct 20, 1978 · N2734V · Destroyed NTSB FTW78FA081Accident · 5 fatalClosedBeech 35 · Kerrville, TXSep 17, 1978 · N48RH · Destroyed NTSB SEA78FA058Accident · 2 fatalClosedBeech C35 · Redmond, ORAug 19, 1978 · N668D · Destroyed NTSB CHI78FA038Accident · 4 fatalClosedBeech 35 · Middletown, OHMay 3, 1978 · N3290V · Destroyed NTSB OAK78FA016Accident · 1 fatalClosedBeech 35 · Napa, CAFeb 10, 1978 · N3783N · Destroyed NTSB SEA78FA019Accident · 4 fatalClosedBeech 35 · Cascade Locks, ORFeb 7, 1978 · N3087V · Destroyed NTSB DEN77FA049Accident · 4 fatalClosedBeech D35 · Bakersville, COJul 23, 1977 · N444Y · Destroyed NTSB LAX77FA041Accident · 4 fatalClosedBeech 35 · Huntington Bch, CAMay 5, 1977 · N2826V · Destroyed NTSB OAK76AP038Accident · 3 fatalClosedBeech 35 · Incline Vlg, NVDec 23, 1975 · N379Z · Destroyed NTSB FTW75AF043Accident · 3 fatalClosedBeech 35 · Vidor, TXDec 23, 1974 · N80463 · Destroyed NTSB OAK74AP043Accident · 3 fatalClosedRyan Navion · Columbia, CAMar 9, 1974 · N8785H · Destroyed NTSB MIA73AM103Accident · 2 fatalClosedNavion A · Missing AircraftMay 25, 1973 · N5126K · Destroyed NTSB MKC73AK040Accident · 2 fatalClosedBeech C-45H · St.Paul, MNNov 29, 1972 · N717B · Destroyed NTSB ANC73AA027Accident · 2 fatalClosedNavion A · Missing AircraftJul 22, 1972 · N91458 · Destroyed NTSB OAK72AP031Accident · 1 fatalClosedBeech E35 · Dublin, CAMar 2, 1972 · N766B · Destroyed NTSB DEN71AD015Accident · 2 fatalClosedBeech B35 · Evanston, WYOct 6, 1970 · N8817A · Destroyed NTSB CHI71AC007Accident · 3 fatalClosedBeech A-35 · Carrolton, KYJul 26, 1970 · N678B · Destroyed NTSB LAX70AL043Accident · 1 fatalClosedBeech D35 · Newhall, CAJan 13, 1970 · N2124D · Destroyed NTSB MIA70A0035Accident · 1 fatalClosedBeech 35 · Thomasville, GAOct 25, 1969 · N2817V · Destroyed NTSB MIA70A0022Accident · 1 fatalClosedNavion A · Williamson, GASep 19, 1969 · N8593H · Destroyed NTSB UNK69X0128Accident · 3 fatalClosedBeech 35 · Westwold, CanadaJun 28, 1969 · N2800V · Destroyed NTSB CHI69A0097Accident · 4 fatalClosedBeech 35 · Missing AircraftMay 21, 1969 · N3358V · Destroyed NTSB SEA69A0051Accident · 3 fatalClosedBeech 35 · Albion, WAApr 7, 1969 · N2875V · Destroyed NTSB MKC69A0030Accident · 3 fatalClosedNavion A · St.John, KSNov 8, 1968 · N91684 · Destroyed NTSB OAK69A0011Accident · 2 fatalClosedBeech N35 · Truckee, CAAug 16, 1968 · N1235Z · Destroyed NTSB NYC67A0182Accident · 3 fatalClosedBeech A35 · Summitville, NYJun 17, 1967 · N8644A · Destroyed NTSB MKC67A0059Accident · 1 fatalClosedBeech 35 · Wall, SDApr 21, 1967 · N3099V · Destroyed NTSB FTW67A0007Accident · 5 fatalClosedBeech 35 · Andrews, TXJul 10, 1966 · N4508V · Destroyed NTSB LAX66A0086Accident · 1 fatalClosedBeech 35 · ZMay 8, 1966 · N3918N · Destroyed NTSB FTW66A0097Accident · 2 fatalClosedBeech C35 · Brownsville (Gulf of Mexico)Mar 9, 1966 · N783D · Destroyed NTSB MIA66A0019Accident · 1 fatalClosedBeechcraft A-35 · Statesville, NCAug 13, 1965 · N8595A · Destroyed NTSB SEA65A0025Accident · 2 fatalClosedBeechcraft 35 · Granite Fals, WASep 16, 1964 · N3070V · Destroyed NTSB UNK64X1196Accident · 2 fatalClosedBeechcraft 35 · West Milford, NJApr 5, 1964 · N2745V · Destroyed