Skip to content

NTSB investigations: Continental A&C75 series, NY

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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA10CA049Accident · Minor injuriesData collectionFinal reportErcoupe 415 · Germantown, NYThe pilot's decision to continue operation of the airplane with a known mechanical deficiency.Nov 4, 2009 · N93659 · Substantial damage NTSB IAD02LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Millbrook, NYpilot's inadvertent activation of the right brake during landing roll-out , which caused the airplane to nose over. A factor was the crosswind.Nov 4, 2001 · N1147B · Substantial damage NTSB NYC00LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Rome, NYThe pilot inadvertently selecting the mixture control to off, resulting in a total loss of engine power.Mar 4, 2000 · N3719H · Substantial damage NTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…May 16, 1998 · N3230H · Destroyed NTSB NYC94LA153Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Scriba, NYThe pilot's failure to maintain adequate airspeed which resulted in a stall and inflight collision with trees.Aug 6, 1994 · N94151 · Substantial damage NTSB NYC88LA197Accident · Serious injuriesLimited investigationFinal reportErco 415C · W. Bloomfield, NYShorlty after takeoff at about 150 feet a.g.l., the pilot lost control of the airplane and crashed in a corn field about 0.5 mile from airport. A passenger reported that they encountered a wind gust and the pilot was unable to control the airplane.Jul 29, 1988 · N94011 · Destroyed NTSB NYC87LA040Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stormville, NYThe plt reported that during the landing apch, aprx 1/2 mile from touchdown, the acft descended below the visual glidepath. Recovery was attempted with the application of power, however, the acft mushed into a field short of the rwy. The acft rolled, struck a…Nov 16, 1986 · N93523 · Substantial damage NTSB NYC85LA211Accident · No injuriesLimited investigationFinal reportErcoupe Ercoupe 415-C · Del Mar, NYThe plt was reposition the acft at the request of the new owner who was not a rated plt. While climbing thru 2000 ft AGL the plt reported hearing the engine growl and felt a loss of power. During a precautionary descent the engine seized and the plt made a…Aug 14, 1985 · N3431H · Substantial damage NTSB NYC76FHJ18Accident · No injuriesClosedErco 415-C · East Moriches, NYApr 30, 1976 · N94132 · Substantial damage NTSB NYC75FHJ23Accident · No injuriesClosedErco 415-D · Shirley, NYDec 15, 1974 · N2339H · Substantial damage NTSB NYC69D0192Accident · No injuriesClosedPiper J5A · Jacksons Crnr, NYAug 4, 1968 · N27159 · Substantial damage NTSB NYC67F0570Accident · No injuriesClosedErco 415-C · Kent Cliffs, NYMar 19, 1967 · N93991 · Substantial damage NTSB NYC67F0229Accident · Serious injuriesClosedPiper J-3 · Kingston, NYAug 17, 1966 · N1219V · Substantial damage NTSB NYC67F0162Accident · No injuriesClosedErco 415C · Byron, NYAug 4, 1966 · N93753 · Substantial damage NTSB NYC67F0174Accident · No injuriesClosedErco 415-CD · Lake Katrine, NYJul 30, 1966 · N94614 · Substantial damage NTSB NYC66F0313Accident · No injuriesClosedErcoupe 415-C · Montour Falls, NYOct 3, 1965 · N99843 · Substantial damage NTSB NYC66D0283Accident · No injuriesClosedLuscombe 8E · Spring Valley, NYSep 11, 1965 · N2050K · Substantial damage NTSB NYC66D0074Accident · No injuriesClosedErcoupe 415C · Mattituck, NYJul 9, 1965 · N3431H · Substantial damage NTSB NYC66F0042Accident · No injuriesClosedErcoupe 415 · E Moriches, NYJun 20, 1965 · N99616 · Substantial damage NTSB UNK65X0374Accident · No injuriesClosedErcoupe 415C · Waterloo, NYOct 22, 1964 · N94068 · Substantial damage NTSB UNK64X2411Accident · Minor injuriesClosedAeronca 7AC · Red Hook, NYJun 21, 1964 · N82546 · Substantial damage