Skip to content

NTSB investigations: Continental E185 series, AR

22 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

19642026

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" = 'AR' 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\" = 'AR' 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" = 'AR' 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 CEN22LA364Accident · No injuriesClass 4 · LimitedFinal reportBeechcraft 35 · Star City, ARThe pilot’s delayed decision to abort the takeoff, which resulted in a runway excursion and impact with a ditch.Jul 30, 2022 · N3260V · Substantial damage NTSB CEN21LA405Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A35 · Morrilton, ARThe total loss of engine power for reasons that could not be determined based on available information.Sep 2, 2021 · N8419A · Substantial damage NTSB CEN17FA364Accident · 2 fatalField investigationFinal reportBeech C35 · Camden, ARThe pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…Sep 24, 2017 · N5958C · Destroyed NTSB CEN12LA331Accident · Minor injuriesLimited investigationFinal reportBaldwin Skybolt · Stuttgart, ARThe pilot's inadequate preflight planning, which resulted in the airplane’s overweight takeoff from an airstrip with a high density altitude and subsequent collision with terrain.May 30, 2012 · N24EB · Substantial damage NTSB FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.Jun 9, 2001 · N2963V · Substantial damage NTSB FTW00LA211Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Decatur, ARThe inadvertent stall while maneuvering to avoid obstructions during a forced landing. A factor was the pilot's failure to extend the landing gear, which resulted in a partial loss of engine power due to the propeller blades striking the runway.Jul 15, 2000 · N3424B · Substantial damage NTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.Jul 13, 1999 · N5BH · Substantial damage NTSB CHI98LA125Accident · No injuriesLimited investigationFinal reportBeech B35 · Bentonville, ARthe damage to the empennage was due to flutter.Apr 13, 1998 · N5246C · Substantial damage NTSB FTW98LA078Accident · No injuriesLimited investigationFinal reportBeech 35 · Springdale, ARThe fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a…Dec 28, 1997 · N2815V · Substantial damage NTSB FTW91FA109Accident · Serious injuriesField investigationFinal reportNorth American NA1 · Mountain Home, ARThe contamination of the airplane's fuel system and the foreign object blockage of the vapor return orifice which induced the power loss. A factor was the lack of suitable terrain.Jun 28, 1991 · N91108 · Destroyed NTSB MKC85LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Nashville, ARDuring the flare the acft ballooned, decelerated and stalled. The resultant hard ldg collapsed the ldg gear.Oct 4, 1984 · N4498V · Substantial damage NTSB MKC84LA151Accident · No injuriesLimited investigationFinal reportBeech BE35 · Nashville, ARThe acft collided with the ground after takeoff. The plt said he over-rotated during takeoff. The acft rolled right and left, striking the right landing gear and then the left wing on the rwy.May 26, 1984 · N4498V · Substantial damage NTSB FTW69F0468Accident · No injuriesClosedNavion A · Hot Springs, ARApr 11, 1969 · N4527K · Substantial damage NTSB FTW69F0301Accident · No injuriesClosedNavion A · Walnut Ridge, AROct 31, 1968 · N5139K · Substantial damage NTSB FTW68D0390Accident · No injuriesClosedNavion A · Little Rock, ARDec 2, 1967 · N4961C · Substantial damage NTSB FTW68D0365Accident · No injuriesClosedBeech 35 · Booneville, ARNov 22, 1967 · N3878N · Substantial damage NTSB FTW68F0249Accident · No injuriesClosedBeech C35 · Malvern, ARMar 19, 1967 · N743D · Substantial damage NTSB FTW66D0633Accident · No injuriesClosedBeech C35 · Sparkman, ARApr 24, 1966 · N1813D · Substantial damage NTSB FTW66D0617Accident · No injuriesClosedMavion A · Jonesboro, ARApr 12, 1966 · N9126R · Substantial damage NTSB UNK65X1367Accident · No injuriesClosedNavion NAV4 · Garland City, ARJan 28, 1965 · N91569 · Substantial damage NTSB UNK64X2668Accident · No injuriesClosedBeechcraft 35 · Springdale, ARJul 5, 1964 · N3348V · Substantial damage NTSB UNK64X0267Accident · No injuriesClosedNavion B · Keiser, ARJan 17, 1964 · N5139K · Substantial damage