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 ANC74DAG23Accident · No injuriesClosedTaylorcraft BCS12 · Palmer, AKAug 19, 1973 · N34068 · Substantial damage NTSB NYC74AN016Accident · 1 fatalClosedAeronca 11AC · Prospect, PAAug 18, 1973 · N23518 · Substantial damage NTSB CHI74DEP12Accident · Minor injuriesClosedPiper J-3 · Neena, WIAug 12, 1973 · N98200 · Substantial damage NTSB DEN74DTC07Incident · No injuriesClosedTaylorcraft DC12D · Evanston, WYAug 11, 1973 · N39243 · Minor damage NTSB ANC74DAG22Accident · No injuriesClosedTaylorcraft BC12-S · Kena, AKAug 11, 1973 · N29705 · Substantial damage NTSB CHI74DEM15Accident · No injuriesClosedPiper PA-17 · Charlotte, MIAug 7, 1973 · N4847H · Substantial damage NTSB OAK74DVM03Accident · No injuriesClosedPiper J4A · San Jose, CAAug 1, 1973 · N27898 · Substantial damage NTSB LAX74DUQ08Accident · No injuriesClosedTaylorcraft BC12-D · Goleta, CAJul 23, 1973 · N43132 · Substantial damage NTSB MIA74DLA02Accident · No injuriesClosedPiper J-3 · Pensacola, FLJul 21, 1973 · N1971M · Substantial damage NTSB CHI74FEE03Accident · No injuriesClosedAeronca 11AC · Naperville, ILJul 18, 1973 · N85917 · Substantial damage NTSB NYC74AN001Accident · 1 fatalClosedPiper J3C-65 · Panther Lake, NYJul 4, 1973 · N98355 · Destroyed NTSB CHI74FEA02Accident · No injuriesClosedAeronca 7AC · Speedway, INJul 4, 1973 · N84304 · Substantial damage NTSB FTW74FPG01Accident · No injuriesClosedPiper PA-11 · Lewisville, ARJul 1, 1973 · N4768M · Substantial damage NTSB OAK73DVG73Accident · Minor injuriesClosedPorterfield CP-65 · Esparto, CAJun 23, 1973 · N27280 · Substantial damage NTSB CHI73FEI48Accident · No injuriesClosedTaylorcraft BC12-D · Wadsworth, OHJun 18, 1973 · N96995 · Substantial damage NTSB SEA73DYE38Accident · Minor injuriesClosedAeronca 7AC · Maple Valley, WAJun 17, 1973 · N2492E · Substantial damage NTSB MKC73FCG49Accident · Serious injuriesClosedAeronca L-3 · Branson, MOJun 17, 1973 · N48218 · Substantial damage NTSB CHI73FER08Accident · Serious injuriesClosedTaylorcraft BC12-D · Menomonie, WIJun 13, 1973 · N96584 · Substantial damage NTSB FTW73DRJ39Accident · No injuriesClosedLuscombe 8A · Lufkin, TXJun 5, 1973 · N1706K · Substantial damage NTSB NYC73FNC73Accident · No injuriesClosedPiper J3-65 · Augusta, MEMay 26, 1973 · N42571 · Substantial damage NTSB FTW73AF070Accident · 1 fatalClosedLuscombe 8A · Ama, LAMay 20, 1973 · N45882 · Destroyed NTSB CHI73FEP59Accident · No injuriesClosedLuscombe 8A · Middleton, WIMay 20, 1973 · N71318 · Substantial damage NTSB CHI73FEE59Accident · No injuriesClosedLuscombe 8A · Aurora, ILMay 20, 1973 · N2239K · Substantial damage NTSB MKC73DCJ42Accident · No injuriesClosedLuscombe 8A · Sidney, NEMay 19, 1973 · N71847 · Substantial damage NTSB SEA73DYE34Accident · No injuriesClosedTaylorcraft BC12-D · Bellevue, WAMay 17, 1973 · N95514 · Substantial damage NTSB OAK73DVG63Accident · No injuriesClosedLuscombe 8A · Vacaville, CAMay 15, 1973 · N45499 · Substantial damage NTSB IAD73FLQ30Accident · Minor injuriesClosedAeronca 7AC · Murray, KYMay 13, 1973 · N81941 · Substantial damage NTSB CHI73DEM59Accident · No injuriesClosedTaylorcraft BC12-D · Allegan, MIMay 10, 1973 · N96723 · Substantial damage NTSB ANC73DAG87Accident · No injuriesClosedAeronca O-58B · Anchorage, AKMay 6, 1973 · N48623 · Substantial damage NTSB NYC73FNC71Accident · Minor injuriesClosedPiper PA-17 · Hillsborough, NHApr 30, 1973 · N4615H · Substantial damage NTSB IAD733ID20Accident · No injuriesClosedPiper J3C-65 · Blairs, VAApr 29, 1973 · N70449 · Substantial damage NTSB CHI73AC085Accident · 1 fatalClosedAeronca 7AC · Rice Lake, WIApr 25, 1973 · N85010 · Destroyed NTSB DEN73FQA35Accident · Minor injuriesClosedTaylorcraft BC12-D · Albuquerque, NMApr 22, 1973 · N39969 · Substantial damage NTSB NYC73DNC70Accident · Minor injuriesClosedLuscombe 8A · Princeton, MEApr 15, 1973 · N2209K · Substantial damage NTSB ANC73DAG83Accident · No injuriesClosedTaylorcraft BC12-D · Anchorage, AKApr 11, 1973 · N95288 · Substantial damage NTSB LAX73DUG45Accident · No injuriesClosedPiper J3C-65 · Apple Vally, CAApr 3, 1973 · N42130 · Substantial damage NTSB MKC73FER46Accident · No injuriesClosedLuscombe 8A · Hibbing, MNMar 30, 1973 · N2128K · Substantial damage NTSB IAD73A1006Accident · 2 fatalClosedPiper J3 · Brundidge, ALMar 24, 1973 · N98633 · Destroyed NTSB MIA73AM091Accident · 2 fatalClosedLuscombe 8A · Greensboro, ALMar 14, 1973 · N71509 · Destroyed NTSB IAD73DKM26Accident · No injuriesClosedAeronca 7AC · Indian Trail, NCMar 4, 1973 · N2840E · Substantial damage NTSB LAX73AL040Accident · 1 fatalClosedAeronca 7AC · Apache Jctn, AZFeb 25, 1973 · N2915E · Destroyed NTSB NYC73FNC55Accident · No injuriesClosedPiper J3C-65 · Springfield, VTFeb 23, 1973 · N1401V · Substantial damage NTSB MIA73DLG33Accident · No injuriesClosedPiper PA-11 · Isle Of Palms, SCFeb 4, 1973 · N4827M · Substantial damage NTSB OAK73FVG44Accident · Serious injuriesClosedAeronca 7AC · Sloughhouse, CAJan 30, 1973 · N85401 · Substantial damage NTSB CHI73FEA22Accident · Minor injuriesClosedPiper J3C-65 · Terre Haute, INJan 25, 1973 · N92343 · Destroyed NTSB FTW73FPA23Accident · No injuriesClosedAeronca O-58B · Sherman, TXJan 19, 1973 · N46464 · Substantial damage NTSB LAX73FUM14Accident · No injuriesClosedPiper J3C-65 · Carlsbad, CAJan 18, 1973 · N98140 · Substantial damage NTSB MKC73FER35Accident · Minor injuriesClosedTaylorcraft BC12-D · Blue Earth, MNJan 13, 1973 · N43478 · Substantial damage NTSB CHI73FEC20Accident · Minor injuriesClosedLuscombe 8A · Belleville, MIDec 31, 1972 · N1468K · Substantial damage NTSB OAK73DVW13Accident · Minor injuriesClosedPiper PA-15 · Henderson, NVDec 28, 1972 · N4355H · Substantial damage