NTSB investigations: Continental A&C75 series, OK
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.
Cases per year
| 1964 | 5 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1969 | 2 |
| 1973 | 2 |
| 1976 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2016 | 1 |
| 2020 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'OK' 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" = 'OK' 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" DESCRun 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 CEN21LA047Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Ardmore, OKThe pilot’s improper decision to takeoff with 3 persons in a 2-place airplane and over maximum gross weight, and his failure to apply carburetor heat when the airplane’s engine experienced carburetor ice and a partial loss of power.NTSB GAA16CA180Accident · Minor injuriesData collectionFinal reportLamb-Robin Bowers FLY Baby · Guthrie, OKThe pilot's exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall and a collision with terrain.NTSB FTW02LA160Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Hinton, OKFuel exhaustion due to a fuel cap leak. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01FA151Accident · 1 fatalField investigationFinal reportErcoupe 415-CD · McAlester, OKthe inadvertent stall by the pilot-in-command.NTSB FTW83LA309Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elk City, OKThe acft landed short of the rwy during a night landing following a x-country. The plt stated that he was on the approach to land and attempted to add power. The engine sputtered without an increase in power. The acft touched down 5 ft short of the rwy…NTSB FTW79FPM17Accident · No injuriesClosedErco 415-C · Atoka, OKNTSB FTW77FPJ02Accident · Serious injuriesClosedErco 415-C · Chattanooga, OKNTSB FTW74AF010Accident · No injuriesClosedErco 415-C · Page, OKNTSB FTW73FPM18Accident · No injuriesClosedErco 415-C · Tulsa, OKNTSB FTW70D0120Accident · No injuriesClosedErco 415C · Sweetwater, OKNTSB FTW69F0383Accident · Serious injuriesClosedErcoupe 415-C · Jenks, OKNTSB FTW68D0217Accident · No injuriesClosedErco 415-C · Canute, OKNTSB FTW67D0032Accident · No injuriesClosedErcoupe 415-C · Altus, OKNTSB FTW66F0481Accident · Minor injuriesClosedErcoupe 415-C · Lahoma, OKNTSB UNK65X0954Accident · No injuriesClosedErcoupe 415C · El Reno, OKNTSB UNK64X3750Accident · Minor injuriesClosedErcoupe 415C · Eufaula, OKNTSB UNK64X2782Accident · Serious injuriesClosedForney 415C · Purcell, OKNTSB UNK64X2045Accident · Serious injuriesClosedPiper J3 · Bixby, OKNTSB UNK64X0943Accident · Minor injuriesClosedPiper J3 · Tulsa, OK