Skip to content

NTSB investigations: Continental A&C75 series, NC

19 cases on aircraft whose registry engine model is Continental A&C75 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" = 'NC' 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 ('17005')) 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\" = 'NC' 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 ('17005'))
  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" = 'NC' 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 ('17005'))
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 ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.Oct 16, 2011 · N3760H · Substantial damage NTSB ERA10CA311Accident · Serious injuriesData collectionFinal reportDwight Lohr Baby Ace · Carolina Beach, NCThe pilot's failure to maintain clearance from a tree during initial climb after takeoff.Jun 13, 2010 · N39D · Substantial damage NTSB MIA97LA234Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Siler City, NCFailure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.Aug 16, 1997 · N2237H · Substantial damage NTSB ATL95LA123Accident · Minor injuriesLimited investigationFinal reportKnosp Corbin JR. ACE-E · Whiteville, NCContamination of the fuel system which resulted in fuel starvation and a total loss of engine power. .Jul 1, 1995 · N74RK · Substantial damage NTSB ATL91LA056Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Gastonia, NCThe pilot's improper flare and subsequent failure to recover from a bounced landing.Feb 9, 1991 · N3353H · Substantial damage NTSB MIA90FA168Accident · 2 fatalField investigationFinal reportErco 415-C · Huntersville, NCFailure of the pilot in command to maintain airspeed.Aug 11, 1990 · N2436H · Destroyed NTSB ATL89LA146Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Troy, NCAn undetermined powerplant problem, which resulted in a loss of engine power, and the pilot/mechanic's failure to assure the aircraft was properly inspected before flight. Factors related to the accident were: the pilot's delay in making a precautionary…May 13, 1989 · N99766 · Destroyed NTSB ATL88LA183Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Whiteville, NCThe student plt reported that the engine began to skip and lose pwr about 20 minutes after departure. The engine subsequently lost all pwr and the student made a forced ldg in a plowed field. The airplane nosed over during the ldg. Post-crash exam of the…May 24, 1988 · N41886 · Substantial damage NTSB ATL81FLJ11Accident · Minor injuriesClosedErco 415-E · Southport, NCJun 29, 1981 · N2527H · Substantial damage NTSB NYC72DKM36Accident · No injuriesClosedErco 415-C · Mayodan, NCMay 6, 1972 · N94030 · Substantial damage NTSB IAD71DKM39Accident · No injuriesClosedErcoupe 415C · Marion, NCJun 19, 1971 · N3690H · Substantial damage NTSB DIA69D0206Accident · No injuriesClosedLuscombe 8E · Rutherfordton, NCMay 26, 1969 · N71344 · Substantial damage NTSB MIA67F0084Accident · No injuriesClosedErcoupe 415-C · Greensboro, NCJul 27, 1966 · N99476 · Substantial damage NTSB MIA67F0005Accident · No injuriesClosedPiper J3 · Erwin, NCJul 4, 1966 · N42463 · Substantial damage NTSB MIA66F0462Accident · Minor injuriesClosedErco 415-C · Jacksonville, NCMar 18, 1966 · N99983 · Substantial damage NTSB MIA66F0308Accident · No injuriesClosedErcoupe 415C · Spruce Pine, NCOct 30, 1965 · N87294 · Substantial damage NTSB UNK65X1285Accident · No injuriesClosedErcoupe 415C · Bladenboro, NCJan 14, 1965 · N99815 · Destroyed NTSB UNK64X3302Accident · No injuriesClosedLuscombe 8A · Statesville, NCAug 9, 1964 · N71166 · Substantial damage NTSB UNK64X2430Accident · Serious injuriesClosedPiper J3C · Whitsett, NCJun 21, 1964 · N40974 · Substantial damage