Skip to content

NTSB investigations: Continental A&C65 series

3,024 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 MKC66F0435Accident · Minor injuriesClosedAeronca 50C · St Francisvill, MOFeb 26, 1966 · N21340 · Substantial damage NTSB FTW66F0545Accident · Serious injuriesClosedAeronca 0-58B · Lubbock, TXFeb 23, 1966 · N50562 · Substantial damage NTSB DEN66D0250Accident · No injuriesClosedLuscombe 8A · Mesa, AZFeb 23, 1966 · N77881 · Substantial damage NTSB OAK66D0203Accident · Minor injuriesClosedTaylorcraft BC-12D · Nut Tree, CAFeb 20, 1966 · N95792 · Substantial damage NTSB NYC66F0567Accident · No injuriesClosedLuscombe 8A · Tarentum, PAFeb 20, 1966 · N45825 · Substantial damage NTSB LAX66D0261Accident · No injuriesClosedAeronca 11AC · Santa Susana, CAFeb 20, 1966 · N9669E · Substantial damage NTSB NYC66D0515Accident · Minor injuriesClosedPiper J-3 · Edgewater, MDFeb 19, 1966 · N70255 · Substantial damage NTSB MIA66D0444Accident · No injuriesClosedAeronca 7AC · Winder, GAFeb 19, 1966 · N2363E · Substantial damage NTSB FTW66D0508Accident · No injuriesClosedAeronca 7AC · San Antonio, TXFeb 19, 1966 · N2241E · Substantial damage NTSB MKC66F0421Accident · Minor injuriesClosedPiper J-3 · Angola, KSFeb 13, 1966 · N35311 · Substantial damage NTSB NYC66F0495Accident · No injuriesClosedTaylorcraft BC-65 · Tarentum, PAFeb 12, 1966 · N22657 · Substantial damage NTSB MKC66D0428Accident · No injuriesClosedAeronca 11AC · Creve Coeur, MOFeb 12, 1966 · N3870E · Substantial damage NTSB LAX66F0254Accident · Minor injuriesClosedPiper J3C-65 · Palm Desert, CAFeb 9, 1966 · N92339 · Substantial damage NTSB NYC66F0518Accident · No injuriesClosedPiper JC3 · Lawrence, MAFeb 6, 1966 · N6340H · Substantial damage NTSB NYC66D0488Accident · No injuriesClosedAeronca S-65CA · Ravena, NYFeb 6, 1966 · N34596 · Substantial damage NTSB NYC66F0538Accident · No injuriesClosedCessna 150 · Amityville, NYFeb 4, 1966 · N8766S · 2 aircraft · Substantial damage NTSB MKC66D0418Accident · No injuriesClosedAeronca 7AC · Kenmare, NDFeb 4, 1966 · N2774E · Substantial damage NTSB LAX66F0232Accident · No injuriesClosedLuscombe 8A · Van Nuys, CAFeb 3, 1966 · N45581 · Substantial damage NTSB DEN66F0286Accident · Minor injuriesClosedAeronca 7AC · Ajo, AZJan 31, 1966 · N85567 · Substantial damage NTSB OAK66D0189Accident · No injuriesClosedAeronca 7AC · Oroville, CAJan 30, 1966 · N3134E · Substantial damage NTSB CHI66F0672Accident · Minor injuriesClosedAeronca 65-C · Kalkaska, MIJan 29, 1966 · N21303 · Substantial damage NTSB OAK66D0182Accident · No injuriesClosedMooney M18C · Sacramento, CAJan 28, 1966 · N4146 · Substantial damage NTSB CHI66F0518Accident · No injuriesClosedTaylorcraft BC-65 · Lewis Center, OHJan 24, 1966 · N24453 · Substantial damage NTSB NYC66D0477Accident · No injuriesClosedPiper J-3 · Newfield, NYJan 22, 1966 · N6342H · Substantial damage NTSB LAX66F0230Accident · No injuriesClosedAeronca 7AC · Santa Paula, CAJan 22, 1966 · N82413 · Substantial damage NTSB LAX66F0226Accident · Minor injuriesClosedPiper J3 · Pacoima, CAJan 18, 1966 · N37920 · Substantial damage NTSB DEN66D0208Accident · No injuriesClosedLuscombe 8A · Quemado, NMJan 15, 1966 · N45460 · Substantial damage NTSB CHI66F0569Accident · No injuriesClosedLuscombe 8A · Troy, OHJan 12, 1966 · N25128 · Substantial damage NTSB MKC66D0468Accident · No injuriesClosedPiper J3C-65 · Pipestone, MNJan 9, 1966 · N5797N · Substantial damage NTSB LAX66F0218Accident · Minor injuriesClosedAeronca L-3 · Long Beach, CAJan 1, 1966 · N48716 · Substantial damage NTSB MIA66F0390Accident · No injuriesClosedLuscombe 8A · Bay Minette, ALDec 26, 1965 · N71928 · Substantial damage NTSB MIA66A0069Accident · 2 fatalClosedPiper J3C-65 · Metter, GADec 17, 1965 · N7060H · Substantial damage NTSB CHI66D0472Accident · No injuriesClosedLuscombe 8A · Waldo, OHDec 17, 1965 · N71180 · Substantial damage NTSB MIA66D0361Accident · No injuriesClosedPiper J3C-65 · St George, SCDec 12, 1965 · N98519 · Substantial damage NTSB FTW66F0431Accident · Minor injuriesClosedTaylorcraft DCO-65 · Gurdon, ARDec 12, 1965 · N58603 · Substantial damage NTSB SEA66F0182Accident · Minor injuriesClosedTaylorcraft DC0-65 · Kent, WADec 11, 1965 · N49174 · Substantial damage NTSB MKC66D0348Accident · No injuriesClosedAeronca 7AC · Lincoln, KSDec 8, 1965 · N83703 · No damage NTSB NYC66F0408Accident · No injuriesClosedLuscombe 8C · Henrietta, NYDec 5, 1965 · N28734 · Substantial damage NTSB FTW66F0428Accident · No injuriesClosedLuscombe 8A · Bowie, TXDec 5, 1965 · N45404 · Substantial damage NTSB MIA66F0337Accident · Minor injuriesClosedLuscombe 8A · Orlando, FLNov 27, 1965 · N1539B · Substantial damage NTSB CHI66F0505Accident · Minor injuriesClosedTaylorcraft DCO-65 · Waupaca, WINov 26, 1965 · N53514 · Substantial damage NTSB MKC66D0404Accident · No injuriesClosedLuscombe 8A · Fessenden, NDNov 21, 1965 · N77859 · Substantial damage NTSB MKC66D0362Accident · No injuriesClosedTaylorcraft L-2 · Adair, IANov 21, 1965 · N48247 · Substantial damage NTSB SEA66F0176Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WANov 17, 1965 · N81933 · Substantial damage NTSB ANC66F0067Accident · Minor injuriesClosedTaylorcraft BCS12D · Sitka, AKNov 16, 1965 · N96370 · Destroyed NTSB NYC66F0365Accident · No injuriesClosedPiper J3C-65 · Agawam, MANov 12, 1965 · N70596 · Substantial damage NTSB OAK66F0150Accident · No injuriesClosedAeronca 7AC · Loomis, CANov 11, 1965 · N82072 · Substantial damage NTSB CHI66F0401Accident · Serious injuriesClosedLuscombe 8A · Salem, MINov 11, 1965 · N28484 · Substantial damage NTSB MKC66F0304Accident · No injuriesClosedLuscombe 8C · Wellington, KSNov 8, 1965 · N28617 · Substantial damage NTSB CHI66F0413Accident · Minor injuriesClosedPiper J3C-65 · Greenfield, INNov 7, 1965 · N87851 · Substantial damage