Skip to content

NTSB investigations: Continental A&C75 series, AK

27 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" = 'AK' 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\" = 'AK' 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" = 'AK' 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 ANC14LA091Accident · No injuriesLimited investigationFinal reportPiper J3 · Ft. Yukon, AKThe pilot's improper preflight inspection and in-flight fuel management, which resulted in fuel exhaustion and a subsequent forced landing.Sep 28, 2014 · N7092H · Substantial damage NTSB ANC97LA079Accident · No injuriesLimited investigationFinal reportPiper J-5 · Wasilla, AKThe loss of engine power for an undetermined reason, and the noncertificated pilot's decision to perform a go-around after a suitable landing site had been attained. A factor associated with the accident was the rough and uneven terrain.May 29, 1997 · N31164 · Substantial damage NTSB ANC93LA179Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, AKThe pilot's improper in-flight planning/decision, and his failure to attain the proper touchdown point. A factor was the rough/uneven terrain.Sep 18, 1993 · N5029M · Substantial damage NTSB ANC93LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-3 · Knik, AKThe improper use of the flight controls by the student pilot and inadequate supervision by the CFI pilot-in-command.Jun 12, 1993 · N91952 · Substantial damage NTSB ANC85FA163Accident · 6 fatalField investigationFinal reportCessna 180H · Mt. Palmer, AKAircraft collided with Cessna 180 and crashed on mountain side about one-quarter mile apart. Piper was sightseeing and Cessna was spotting sheep. Scattered clouds were reported about 300 feet above the points of ground impact.Aug 25, 1985 · N417GP · 2 aircraft · Destroyed NTSB ANC84LA098Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Healy, AKShortly after lifting off from an airstrip, the eng lost power. The plt tried to make an emergency landing on a highway, but was unable to reach it. The acft was damaged when he landed in the tops of trees. The reason for the power loss was not found.Jun 23, 1984 · N1210H · Substantial damage NTSB ANC84LA019Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Anchorage, AKThe eng quit after takeoff. The plt was able to return to the arpt but landed on a Piper super cub. Water was found in the carburetor & main fuel tank.Nov 27, 1983 · N95666 · Destroyed NTSB ANC82DAG36Accident · No injuriesFinal reportTaylorcraft BC-12D · Settlers Bay, AKWhile on a cross-country flight from wasilla to king lake the pilot decided to do some touch and go landings at Settlers Bay. The pilot stated that on his third landing the left brake locked and the aircraft swerved off the runway into a ditch nosing over.Jun 19, 1982 · N96401 · Substantial damage NTSB ANC82DAG21Accident · No injuriesFinal reportPiper J3C-75 · Soldotna, AKWhile executing departure stalls the elevator locked in the full up position. After several attempts to regain control, it was found that partial control was possible in a power off descending turn. This attitude was maintained until just prior to ground…May 11, 1982 · N27006 · Substantial damage NTSB ANC80FA003Accident · 2 fatalClosedPiper J-3 · Georgetown, AKOct 10, 1979 · N6254H · Destroyed NTSB ANC77FA054Accident · 1 fatalClosedAeronca 7AC · Sterling, AKJul 6, 1977 · N83535 · Substantial damage NTSB ANC77DAG35Accident · Minor injuriesClosedErco 415-D · Anchorage, AKMar 6, 1977 · N2431H · Substantial damage NTSB ANC76DAH09Accident · No injuriesClosedAeronca 11AC · Glennallen, AKMay 8, 1976 · N3183E · Substantial damage NTSB ANC74DAG20Accident · No injuriesClosedAeronca 7AC · Palmer, AKAug 20, 1974 · N1506E · Substantial damage NTSB ANC73DAG71Accident · No injuriesClosedAeronca 7AC · Palmer, AKDec 31, 1972 · N2597E · Substantial damage NTSB ANC72DAG63Accident · No injuriesClosedAeronca 7AC · Hope, AKOct 7, 1971 · N3308E · Substantial damage NTSB ANC71AA010Accident · 2 fatalClosedPiper J3C-65 · Gulkana, AKAug 9, 1970 · N3598N · Destroyed NTSB ANC70DAG22Accident · Minor injuriesClosedAeronca 7AC · Palmer, AKJun 1, 1970 · N2597E · Substantial damage NTSB ANC69D0108Accident · No injuriesClosedTaylorcraft BC12-D · Anchorage, AKFeb 1, 1969 · N36443 · Substantial damage NTSB ANC69D0084Accident · No injuriesClosedPiper J4E · Fairbanks, AKSep 20, 1968 · N38068 · Substantial damage NTSB ANC68F0050Accident · No injuriesClosedPiper J3C-65 · Dillingham, AKJun 1, 1967 · N7184H · Substantial damage NTSB ANC68F0026Accident · Minor injuriesClosedAeronca 7AC · Kodiak, AKMay 29, 1967 · N84348 · Destroyed NTSB ANC68F0018Accident · No injuriesClosedPiper J4E · Soldotna, AKApr 15, 1967 · N38152 · Substantial damage NTSB ANC66F0105Accident · No injuriesClosedAeronca 7AC · Clear, AKMay 8, 1966 · N81660 · Substantial damage NTSB UNK65X1472Accident · No injuriesClosedChampion 7AC · Anchorage, AKMar 14, 1965 · N3308E · Substantial damage NTSB UNK64X2264Accident · No injuriesClosedTaylorcraft BC-12D · Ft Richardsn, AKJun 13, 1964 · N29694 · Substantial damage NTSB UNK64X2191Accident · No injuriesClosedTaylorcraft BC-12D · Anchorage, AKJun 8, 1964 · N29694 · Substantial damage