Skip to content

NTSB investigations: Continental A&C65 series

3,023 cases on aircraft whose registry engine model is Continental A&C65 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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17003'))
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 ANC76DAH47Accident · Minor injuriesClosedAeronca 7AC · Palmer, AKAug 20, 1976 · N85408 · Substantial damage NTSB CHI76FEG20Accident · Minor injuriesClosedTaylorcraft BC-12D · Dayton, OHAug 7, 1976 · N95941 · Destroyed NTSB LAX76DUJ94Accident · No injuriesClosedTaylorcraft BC12-D · Laveen, AZJul 26, 1976 · N5208M · Substantial damage NTSB FTW76DPG91Accident · No injuriesClosedAeronca 7AC · Searcy, ARJul 24, 1976 · N82739 · Substantial damage NTSB NYC76FGM40Accident · Serious injuriesClosedTaylorcraft BC12-D · Somerset, PAJul 18, 1976 · N95098 · Substantial damage NTSB LAX76FUA29Accident · No injuriesClosedTaylorcraft BC12-D · Torrance, CAJul 18, 1976 · N39238 · 2 aircraft · Substantial damage NTSB ANC76DAH36Accident · No injuriesClosedPiper PA-11 · Peter'S Creek, AKJul 18, 1976 · N78665 · Substantial damage NTSB MKC76FCG88Accident · No injuriesClosedPiper J-3 · Springfield, MOJul 17, 1976 · N42755 · Substantial damage NTSB FTW76FPG84Accident · No injuriesClosedLuscombe 8A · Mountain Home, ARJul 17, 1976 · N1313K · Substantial damage NTSB MIA76AM076Accident · 1 fatalClosedPiper J3C-65 · Cartersville, GAJul 7, 1976 · N70419 · Destroyed NTSB CHI76FEM49Accident · Serious injuriesClosedTaylorcraft BC12-D · Mancelona, MIJul 6, 1976 · N43873 · Substantial damage NTSB CHI76DEP34Accident · No injuriesClosedPiper J3C · Cottage Grove, WIJul 3, 1976 · N30714 · Substantial damage NTSB CHI76FEI32Accident · Serious injuriesClosedTaylorcraft BC12-D · Kirby, OHJun 29, 1976 · N95741 · Destroyed NTSB NYC76FGM37Accident · No injuriesClosedPiper J-3 · Jeanette, PAJun 28, 1976 · N42574 · Substantial damage NTSB CHI76FEV46Accident · No injuriesClosedLuscombe 8A · Lincoln, ILJun 28, 1976 · N77923 · Substantial damage NTSB MKC76FCD50Accident · No injuriesClosedCessna T210 · Iowa Falls, IAJun 27, 1976 · N1675X · 2 aircraft · Substantial damage NTSB SEA76FYI21Accident · No injuriesClosedAeronca 65C · Elmira, ORJun 26, 1976 · N22116 · Substantial damage NTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYJun 26, 1976 · N8621J · 2 aircraft · Minor damage NTSB SEA76FYA28Accident · Serious injuriesClosedTaylorcraft BC12-D · Mountain Home, IDJun 23, 1976 · N36430 · Substantial damage NTSB CHI76FEM47Accident · No injuriesClosedLuscombe 8A · Fruitport, MIJun 22, 1976 · N45589 · Substantial damage NTSB FTW76DRA48Accident · No injuriesClosedPiper J3C · Angleton, TXJun 21, 1976 · N6605H · Substantial damage NTSB MIA76DLD62Accident · No injuriesClosedTaylorcraft DCO-65 · Cypress Garden, FLJun 12, 1976 · N45310 · Substantial damage NTSB FTW76AF100Accident · 1 fatalClosedPiper J3C · Fordyce, ARJun 10, 1976 · N3408N · Destroyed NTSB IAD76FKM35Accident · Minor injuriesClosedAeronca 7AC · Statesville, NCJun 8, 1976 · N2831E · Substantial damage NTSB NYC76FNE23Accident · Minor injuriesClosedTaylorcraft BC12-D · Norfolk, CTJun 6, 1976 · N95148 · Substantial damage NTSB FTW76DPG64Accident · No injuriesClosedLuscombe 8A · Van Buren, ARJun 4, 1976 · N1196K · Substantial damage NTSB MKC76FTK26Accident · No injuriesClosedAeronca 7AC · Philip, SDMay 30, 1976 · N85149 · Substantial damage NTSB LAX76DUQ39Accident · No injuriesClosedTaylorcraft BC12-D · Pacoima, CAMay 23, 1976 · N95781 · Substantial damage NTSB CHI76FEM42Accident · Serious injuriesClosedPiper J-3 · Sparta, MIMay 20, 1976 · N98045 · Substantial damage NTSB NYC76FHA33Accident · No injuriesClosedLuscombe 8A · Skippack, PAMay 17, 1976 · N77832 · Substantial damage NTSB IAD76DIA11Accident · No injuriesClosedAeronca 7AC · New Market, VAMay 12, 1976 · N83487 · Substantial damage NTSB MIA76AM082Accident · 1 fatalClosedPiper J3C · New Ellenton, SCMay 6, 1976 · N51524 · Destroyed NTSB OAK76DVG72Accident · No injuriesClosedAeronca 7AC · Colusa, CAMay 1, 1976 · N81862 · Substantial damage NTSB LAX76FUJ70Accident · No injuriesClosedLuscombe 8A · Chandler, AZApr 24, 1976 · N1153B · Substantial damage NTSB MKC76DER58Accident · No injuriesClosedAeronca 11AC · Sacred Heart, MNApr 18, 1976 · N86113 · Substantial damage NTSB NYC76FHD26Accident · No injuriesClosedAeronca 7AC · Smithville, NJApr 17, 1976 · N3032E · Substantial damage NTSB MIA76DKT85Accident · No injuriesClosedAeronca 11AC · Key Largo, FLApr 16, 1976 · N9594E · Substantial damage NTSB NYC76FFA31Accident · No injuriesClosedPiper PA-17 · Vernon, NYApr 14, 1976 · N4616H · Substantial damage NTSB FTW76FRJ19Accident · Serious injuriesClosedAeronca 7AC · Transylvania, LAApr 11, 1976 · N2606E · Substantial damage NTSB SEA76FYE33Accident · No injuriesClosedLuscombe 8A · Maple Valley, WAApr 4, 1976 · N1202B · Substantial damage NTSB NYC76DHD21Accident · No injuriesClosedPiper J-3 · Bridgeton, NJMar 29, 1976 · N7497H · Substantial damage NTSB ANC76DAH01Accident · Serious injuriesClosedAeronca 7AC · Dillingham, AKMar 23, 1976 · N2041E · Substantial damage NTSB MKC76FCJ29Accident · Serious injuriesClosedPiper J3C-65 · Alliance, NEMar 17, 1976 · N3426K · Substantial damage NTSB FTW76FPD33Accident · No injuriesClosedLuscombe 8C · Keene, TXMar 14, 1976 · N28617 · Substantial damage NTSB CHI76FEC33Accident · No injuriesClosedChampion 7FC · Jackson, MIMar 14, 1976 · N9805Y · Substantial damage NTSB SEA76DYE27Accident · No injuriesClosedAeronca 11AC · Waldron Island, WAMar 1, 1976 · N9448E · Substantial damage NTSB FTW76FPG43Accident · No injuriesClosedLuscombe 8A · Conway, ARFeb 29, 1976 · N71153 · Substantial damage NTSB MKC76DCQ36Accident · Minor injuriesClosedInterstate S-1A · Spivey, KSFeb 28, 1976 · N37377 · Substantial damage NTSB LAX76DUJ63Accident · No injuriesClosedLuscombe 8A · Mesa, AZFeb 24, 1976 · N45694 · Substantial damage NTSB DEN76DTC24Accident · No injuriesClosedAeronca 7AC · Lander, WYFeb 22, 1976 · N3768E · Substantial damage