Skip to content

NTSB investigations: Continental E185 series, AZ

31 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 per year

19652026

Where

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" = 'AZ' 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')) 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\" = 'AZ' 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'))
  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" = 'AZ' 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'))
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 WPR24LA086Accident · No injuriesClass 3 · LimitedFinal reportBeech A35 · Maricopa, AZThe pilot’s failure to properly configure the landing gear and verify its position before landing, which resulted in a gear-up landing.Feb 11, 2024 · N691B · Substantial damage NTSB WPR23LA129Accident · Serious injuriesClass 4 · LimitedFinal reportNavion Navion A · Mesa, AZThe pilot of the Ryan Navion’s failure to maintain visual sight of and clearance from another airplane during a formation flight, which resulted in a mid-air collision.Mar 17, 2023 · N610 · 2 aircraft · Substantial damage NTSB WPR15CA033Accident · No injuriesData collectionFinal reportBeech A35 · Havasu City, AZLoss of engine power due to fuel starvation as a result of the pilot's failure to properly operate the fuel selector valve.Nov 5, 2014 · N149DS · Substantial damage NTSB WPR09CA387Accident · No injuriesData collectionFinal reportBeech 35 · St. Johns, AZThe pilot’s inadequate compensation for the crosswind gust and failure to maintain directional control of the airplane during the takeoff. Contributing to the accident was the gusty crosswind weather conditions.Aug 5, 2009 · N4577V · Substantial damage NTSB LAX02FA210Accident · 1 fatalField investigationFinal reportBeech C35 · Chambers, AZThe pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.Jun 30, 2002 · N5856C · Destroyed NTSB LAX01LA104Accident · No injuriesLimited investigationFinal reportSchneider, Edmund, Pty. Starduster SA300 · Chino Valley, AZThe pilot's inadequate preflight planning and his failure to dissiminate/coordinate the total distance required to successfully operate the airplane.Feb 23, 2001 · N1173 · Substantial damage NTSB LAX95LA189Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Flagstaff, AZThe owner/pilot improper installation of the propeller by failing to properly connect the pitch change mechanism.May 16, 1995 · N41151 · Substantial damage NTSB LAX93LA134Accident · Minor injuriesLimited investigationFinal reportBeech D35 · San Manuel, AZThe pilot's improper use of carburetor heat. Contributing to this accident were weather conditions which were conducive to the formation of carburetor ice.Feb 11, 1993 · N2908B · Substantial damage NTSB LAX88LA005Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Wickenburg, AZDuring the takeoff run, the plt realized he had a flt control problem when he was unable to rotate the acft for lift- off. He stated that he contd the takeoff, attempting to overcome the problem with elevator trim. He was unable to establish a climb.…Oct 4, 1987 · N8583A · Substantial damage NTSB LAX86LA323Accident · Serious injuriesLimited investigationFinal reportBeech 35R · Sun City West, AZA Beechcraft BE-35R lost alt during initial climb and collided with the ground after takeoff from a private airstrip. The plt described the takeoff as normal until he reached an alt of 100 to 125 ft AGL and started to turn left. The plt stated, 'the aircraft…Aug 15, 1986 · N3371V · Substantial damage NTSB LAX81DUJ55Accident · No injuriesClosedBeech 35 · White Mtn Lke, AZMay 2, 1981 · N3378V · Substantial damage NTSB LAX79FA005Accident · 3 fatalClosedBeech 35 · Williams, AZOct 20, 1978 · N2734V · Destroyed NTSB LAX78DUK01Accident · No injuriesClosedBeech C35 · Cottonwood, AZSep 9, 1978 · N7SW · Substantial damage NTSB LAX78DUJ14Accident · Minor injuriesClosedNavion A · Greasewood, AZNov 27, 1977 · N4140K · Substantial damage NTSB LAX76FUJ79Accident · No injuriesClosedBeech A35 · Scottsdale, AZMay 29, 1976 · N734B · Substantial damage NTSB LAX75FUJ56Accident · No injuriesClosedNavion A · Carefree, AZJan 18, 1975 · N5102K · Substantial damage NTSB LAX74FUJ44Accident · Serious injuriesClosedBeech D35 · Lake Havasu, AZMar 8, 1974 · N711LB · Substantial damage NTSB LAX72DUJ04Accident · No injuriesClosedNavion A205 · Yuma, AZJun 17, 1972 · N5119K · Substantial damage NTSB LAX72DUJ13Accident · No injuriesClosedBeech 35 · Coolidge, AZMar 29, 1971 · N80443 · Substantial damage NTSB LAX71FUJ53Accident · No injuriesClosedBeech D35 · Tucson, AZJan 4, 1971 · N2155D · Substantial damage NTSB LAX70D0212Accident · Minor injuriesClosedBeech C35 · Glendale, AZNov 24, 1969 · N756D · Substantial damage NTSB LAX70F0170Accident · Minor injuriesClosedNavion A · Williams, AZOct 7, 1969 · N4277K · Destroyed NTSB LAX69D0194Accident · No injuriesClosedBeech D35 · Wickenburg, AZOct 21, 1968 · N3430B · Substantial damage NTSB LAX69D0179Accident · No injuriesClosedBeech 35 · Grand Canyon, AZSep 26, 1968 · N3150V · Substantial damage NTSB LAX68F0208Accident · No injuriesClosedBeech C35 · Phoenix, AZNov 7, 1967 · N8973A · Substantial damage NTSB LAX67F0290Accident · No injuriesClosedBeech 35 · Welton, AZFeb 7, 1967 · N133M · Substantial damage NTSB LAX67F0207Accident · No injuriesClosedBeech 35 · Wellton, AZNov 24, 1966 · N2710V · Substantial damage NTSB LAX67D0044Accident · No injuriesClosedLuscombe 11A · Scottsdale, AZJul 2, 1966 · N1625B · Substantial damage NTSB LAX67F0019Accident · No injuriesClosedBeech A35 · Phoenix, AZJun 22, 1966 · N8461A · Substantial damage NTSB LAX67D0024Accident · No injuriesClosedNavion B · Buckeye, AZMay 27, 1966 · N8569H · Substantial damage NTSB DEN66D0055Accident · No injuriesClosedBeechcraft 35 · Flagstaff, AZJun 29, 1965 · N2875V · Substantial damage