Skip to content

NTSB investigations: Continental E185 series, IL

37 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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CEN25LA032Accident · No injuriesClass 4 · LimitedFinal reportRyan Navion A · Belleville, ILThe pilot’s failure to maintain airplane control during the takeoff.Oct 19, 2024 · N2341 · Substantial damage NTSB DCA22FA157Accident · 1 fatalClass 3 · FieldFinal reportBeech A35 · Centralia, ILThe pilot’s unsuccessful attempt to switch fuel tanks, which resulted in fuel starvation. Contributing to the accident was the uninstalled fuel selector handle warning device.Jul 23, 2022 · N8466A · Substantial damage NTSB CEN22LA128Accident · No injuriesClass 3 · LimitedFinal reportRyan L17 · Livingston, ILA total loss of engine power due to fuel injection system contamination from an unknown source.Feb 20, 2022 · N5042K · Substantial damage NTSB CHI07CA242Accident · No injuriesData collectionFinal reportMarcellus Starduster SA-300 · Columbia, ILThe pilot's improper flare, which resulted in a hard landing and subsequent left main landing gear collapse.Jul 24, 2007 · N2498 · Substantial damage 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.Jul 22, 2003 · N2968C · Substantial damage NTSB CHI95LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Jacksonville, ILimproper maintenance and inspection of the airplane's ruddervators.Jun 4, 1995 · N8640A · Substantial damage NTSB CHI88LA175Accident · No injuriesLimited investigationFinal reportBeech 35R · Manito, ILDrg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just…Jul 26, 1988 · N3016V · Substantial damage NTSB CHI78FCA01Accident · Minor injuriesClosedNavion NAV-4 · Bethalto, ILJun 25, 1978 · N4992K · Substantial damage NTSB CHI78FEV19Accident · Minor injuriesClosedBeech A35 · Quincy, ILMar 5, 1978 · N8479A · Substantial damage NTSB CHI77FEE34Accident · No injuriesClosedBeech 35 · Morris, ILJul 31, 1977 · N3842N · Substantial damage NTSB CHI77FEE20Accident · No injuriesClosedNavion A · Schaumburg, ILApr 26, 1977 · N4503K · Substantial damage NTSB CHI76FEV18Accident · Minor injuriesClosedLuscombe 8A · Urbana, ILOct 20, 1975 · N77964 · 2 aircraft · Substantial damage NTSB CHI76FEE05Accident · No injuriesClosedBeech B35 · Hinsdale, ILJul 15, 1975 · N8824A · Substantial damage NTSB CHI74FEE13Accident · No injuriesClosedLuscombe 11A · Wheeling, ILAug 10, 1973 · N1629B · Substantial damage NTSB CHI73FEE57Accident · No injuriesClosedBeech 35 · Frankln Grove, ILMay 5, 1973 · N3891N · Substantial damage NTSB CHI73FEV15Accident · No injuriesClosedBeech 35 · Quincy, ILNov 5, 1972 · N3956N · Substantial damage NTSB CHI69F0536Accident · No injuriesClosedBeech C35 · Rockford, ILMar 16, 1969 · N5856C · Substantial damage NTSB CHI69D0441Accident · No injuriesClosedNavion A · Richton Park, ILJan 11, 1969 · N8801H · Substantial damage NTSB CHI69D0458Accident · No injuriesClosedBeech B-35 · Granite City, ILDec 18, 1968 · N3331V · Substantial damage NTSB CHI69D0320Accident · No injuriesClosedBeech 35 · Huntley, ILOct 20, 1968 · N3745N · Substantial damage NTSB CHI69F0242Accident · No injuriesClosedNavion A · Harvard, ILAug 17, 1968 · N4005K · Substantial damage NTSB CHI69D0184Accident · No injuriesClosedCessna 150 · Wheeling, ILJul 27, 1968 · N8022S · Substantial damage NTSB CHI68F0419Accident · No injuriesClosedBeech 35 · New Lenox, ILOct 4, 1967 · N8479A · Substantial damage NTSB CHI67D0607Accident · No injuriesClosedBeech 35 · Compton, ILApr 23, 1967 · N2804V · Substantial damage NTSB CHI67F0483Accident · Minor injuriesClosedCessna 150F · Northbrook, ILFeb 4, 1967 · N8022S · Substantial damage NTSB CHI67F0422Accident · No injuriesClosedBeech 35 · Roselle, ILDec 25, 1966 · N3745N · Substantial damage NTSB CHI67F0226Accident · No injuriesClosedBeech A35 · Midlothian, ILAug 28, 1966 · N564B · Substantial damage NTSB CHI67D0211Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 22, 1966 · N8022S · Substantial damage NTSB CHI66D0676Accident · No injuriesClosedBeech A35 · Crystal Lake, ILMar 20, 1966 · N515B · Substantial damage NTSB CHI66F0544Accident · No injuriesClosedBeechcraft C35 · Kankakee, ILJan 23, 1966 · N8944A · Substantial damage NTSB CHI66F0140Accident · No injuriesClosedBeechcraft C-35 · Taylorville, ILMay 29, 1965 · N783D · Substantial damage NTSB CHI65F0135Accident · No injuriesClosedNavion NAV-4 · Wheeling, ILMar 31, 1965 · N4813K · Substantial damage NTSB CHI65F0029Accident · No injuriesClosedBeechraft 35 · Lockport, ILJan 27, 1965 · N409B · Substantial damage NTSB UNK64X4072Accident · No injuriesClosedNavion A · Wheeling, ILSep 20, 1964 · N8585H · Substantial damage NTSB UNK64X3456Accident · No injuriesClosedNavion 205 · E St Louis, ILAug 18, 1964 · N4791K · Substantial damage NTSB UNK64X0190Accident · No injuriesClosedBeechcraft 35 · Chicago, ILJan 8, 1964 · N3365V · Substantial damage NTSB UNK64X0184Accident · No injuriesClosedNavion A · Peoria, ILJan 7, 1964 · N8801H · Substantial damage