Skip to content

NTSB investigations: Continental A&C75 series, MI

21 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" = 'MI' 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\" = 'MI' 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" = 'MI' 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 CEN13CA510Accident · No injuriesData collectionFinal reportErcoupe 415-C · Mackinac Island, MIThe pilot's failure to maintain aircraft control while on final approach.Aug 10, 2013 · N99094 · Substantial damage NTSB CEN10LA203Accident · No injuriesLimited investigationFinal reportUnivair 415-C · Columbiaville, MIThe pilot misjudged his speed and distance while landing, which resulted in an overrun and subsequent collision with terrain.Apr 12, 2010 · N93876 · Substantial damage NTSB CEN09LA291Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe · Brighton, MIThe pilot's failure to attain the proper touchdown point, and his failure to initiate a go-around.May 12, 2009 · N99811 · Substantial damage NTSB CHI07CA110Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Brighton, MIThe student pilot's failure to maintain proper glidepath to the runway. Contributing factors to the accident included the passenger vehicle, the rising embankment, and the airport perimeter fence.Apr 21, 2007 · N99811 · Substantial damage NTSB CHI06LA281Accident · No injuriesLimited investigationFinal reportUnivar Ercoupe · Howell, MIThe student pilot's improper landing flare and lack of total experience.Jan 10, 2006 · N99811 · Substantial damage NTSB CHI91FA305Accident · 1 fatalField investigationFinal reportErcoupe Ercoupe 415-D · Emmett, MIThe pilot's exceeding the design limits of the aircraft, which resulted in an inflight breakup.Sep 27, 1991 · N99283 · Destroyed NTSB CHI84LA021Accident · No injuriesLimited investigationFinal reportPiper J4E · Troy, MIThe acft departed the side of the rwy during landing and nosed over. A private pilot was being accompanied by a commercial pilot whose CFI cirtificate had expired. During landing roll the private pilot began 's' turns for better forward visibility. The…Oct 12, 1983 · N35695 · Substantial damage NTSB CHIB1FEM14Accident · Minor injuriesClosedPiper J5A · Covert, MIApr 18, 1981 · N35697 · Substantial damage NTSB CHI79FEC25Accident · No injuriesClosedRower Aero Bipe · Sandusky, MIMay 9, 1979 · N3987A · Substantial damage NTSB CHI78FEM02Accident · No injuriesClosedErco 415-C · Beaverton, MINov 3, 1977 · N87046 · Substantial damage NTSB CHI75DEM16Accident · No injuriesClosedErco 415-C · Plainwell, MIOct 11, 1974 · N2372H · Substantial damage NTSB CHI74DEM56Accident · No injuriesClosedErco 415-D · South Haven, MIApr 20, 1974 · N2650H · Substantial damage NTSB CHI71FDW27Accident · No injuriesClosedErco 415-C · Fowlerville, MIDec 29, 1970 · N87030 · Substantial damage NTSB CHI69F0368Accident · No injuriesClosedErco 415-C · Lawton, MINov 24, 1968 · N86978 · Substantial damage NTSB CHI69F0107Accident · Serious injuriesClosedLuscombe 8E · Watervliet, MIJul 12, 1968 · N1654K · Destroyed NTSB CHI68F0409Accident · No injuriesClosedErco 415-C · Plymouth, MINov 18, 1967 · N94327 · Substantial damage NTSB CHI68F0327Accident · No injuriesClosedErco 415-C · New Hudson, MIOct 5, 1967 · N99008 · Substantial damage NTSB CHI67F0672Accident · No injuriesClosedLuscombe 8C · Flint, MIMay 17, 1967 · N28829 · Substantial damage NTSB CHI66F0419Accident · No injuriesClosedErcoupe 415C · Three Oaks, MIOct 26, 1965 · N2980H · Substantial damage NTSB UNK65X0714Accident · No injuriesClosedAeronca 11AC · Ontanagon, MINov 15, 1964 · N3264E · Substantial damage NTSB UNK64X3391Accident · No injuriesClosedCulver LCA · Menominee, MIAug 15, 1964 · N29392 · Substantial damage