NTSB investigations: Continental A&C75 series, NM

8 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

19652026

NTSB investigations: Continental A&C75 series, NM per year, 1965–2026: 8 cases
1965	1
1966	2
1972	1
1973	1
1988	1
1990	1
1991	1

Where

Open the map

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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 DEN91LA062Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Santa Rosa, NMThe pilot of the other aircraft failed to maintain clearance between the aircraft.Apr 19, 1991 · N87259 · 2 aircraft · Substantial damage NTSB DEN90LA137Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Truth/Consequen, NMThe pilot's failure to maintain proper airspeed and obtain a proper climb rate after takeoff.Jun 16, 1990 · N94351 · Substantial damage NTSB DEN88FA112Accident · Serious injuriesField investigationFinal reportTaylorcraft BC12-D · Albuquerque, NMThe pilot and his passenger decided to make a local personal flight. The pilot said he saw a squall line approaching the airport, but thought he could get off the ground before it arrived. He took off and started a left crosswind turn. A gust of wind lifted…May 27, 1988 · N43411 · Destroyed NTSB DEN74DQA20Accident · Minor injuriesClosedPiper J-3 · Stead, NMOct 14, 1973 · N88240 · Substantial damage NTSB DEN73FQD13Accident · No injuriesClosedErco 415-CD · Alamogordo, NMDec 31, 1972 · N2431H · Substantial damage NTSB DEN67F0147Accident · No injuriesClosedErcoupe 415-C · Carlsbad, NMOct 5, 1966 · N99702 · Substantial damage NTSB DEN66D0350Accident · No injuriesClosedErcoupe 415C · Gallup, NMJun 3, 1966 · N87095 · Substantial damage NTSB DEN65D0074Accident · No injuriesClosedPiper J-3C · Taos, NMApr 10, 1965 · N88240 · Substantial damage