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 MIA67D0300Accident · No injuriesClosedAeronca 11AC · Weaver, ALOct 8, 1966 · N9618E · Substantial damage NTSB CHI67F0258Accident · No injuriesClosedTaylorcraft BC12-D · Lombard, ILOct 8, 1966 · N43826 · Substantial damage NTSB CHI67F0331Accident · No injuriesClosedGlobe GC-1B · Wheeling, ILOct 5, 1966 · N80605 · 2 aircraft · Substantial damage NTSB MIA67F0188Accident · No injuriesClosedPiper J-3 · Clarksdale, MSOct 1, 1966 · N92627 · Substantial damage NTSB CHI67F0224Accident · Minor injuriesClosedAeronca 7AC · Middletown, OHOct 1, 1966 · N82889 · Substantial damage NTSB MIA67D0242Accident · Minor injuriesClosedPiper J-3 · Florence, ALSep 24, 1966 · N98069 · Substantial damage NTSB LAX67D0125Accident · No injuriesClosedTaylorcraft BC12-D · San Diego, CASep 19, 1966 · N43486 · Substantial damage NTSB MKC67A0024Accident · 1 fatalClosedLuscombe 8E · Eolia, MOSep 18, 1966 · N1208B · Destroyed NTSB DEN67D0111Accident · No injuriesClosedPiper J-3 · Riverton, WYSep 18, 1966 · N88661 · Substantial damage NTSB CHI67F0231Accident · No injuriesClosedAeronca 7AC · Grandville, MISep 18, 1966 · N83965 · Substantial damage NTSB CHI67F0283Accident · Minor injuriesClosedTaylorcraft BC12-D · Elyria, OHSep 17, 1966 · N96533 · Substantial damage NTSB MKC67F0202Accident · No injuriesClosedErcoupe 415-C · Blaisdell, NDSep 10, 1966 · N28953 · Substantial damage NTSB LAX67D0121Accident · No injuriesClosedAeronca 7AC · Norco, CASep 10, 1966 · N82083 · Substantial damage NTSB FTW67F0213Accident · No injuriesClosedAeronca 7AC · Gurdon, ARSep 8, 1966 · N85695 · Substantial damage NTSB MKC67F0199Accident · Minor injuriesClosedAeronca 058B · Essex, IASep 5, 1966 · N48243 · Substantial damage NTSB MIA67F0157Accident · No injuriesClosedPiper J3C-65 · Sanford, NCSep 5, 1966 · N91998 · Substantial damage NTSB MIA67D0165Accident · No injuriesClosedPiper J3C · Shelby, MSAug 31, 1966 · N78405 · Substantial damage NTSB MKC67F0234Accident · No injuriesClosedAeronca 7AC · Tuthill, SDAug 28, 1966 · N82894 · Substantial damage NTSB DEN67F0102Accident · No injuriesClosedLuscombe 8A · Littleton, COAug 28, 1966 · N1095K · Substantial damage NTSB LAX67D0107Accident · No injuriesClosedLuscombe 8A · Redlands, CAAug 26, 1966 · N28615 · Substantial damage NTSB FTW67D0182Accident · Serious injuriesClosedPiper PA-11S · Lewisville, TXAug 23, 1966 · N4604M · No damage NTSB SEA67D0103Accident · No injuriesClosedMooney M-18 · Easton, WAAug 21, 1966 · N4180 · Substantial damage NTSB NYC67D0195Accident · No injuriesClosedAeronca 7AC · Monroe, CTAug 19, 1966 · N83091 · Substantial damage NTSB NYC67F0228Accident · No injuriesClosedLuscombe 8A · Neptune, NJAug 17, 1966 · N77840 · Substantial damage NTSB SEA67F0147Accident · No injuriesClosedTaylorcraft BC12-D · Tigard, ORAug 13, 1966 · N5033M · Substantial damage NTSB FTW67F0132Accident · No injuriesClosedLuscombe 8A · Gonzalez, TXAug 9, 1966 · N77908 · Substantial damage NTSB MIA67D0143Accident · No injuriesClosedPiper J-3 · Newberry, SCAug 8, 1966 · N42595 · Substantial damage NTSB ANC67F0062Accident · Serious injuriesClosedTaylorcraft BC12-D · Tok, AKAug 7, 1966 · N94922 · Destroyed NTSB CHI67F0171Accident · Minor injuriesClosedPiper J3C-65 · Yates City, ILAug 1, 1966 · N6379H · Destroyed NTSB NYC67D0164Accident · No injuriesClosedLuscombe 8A · Franklinville, NYJul 31, 1966 · N1936B · Substantial damage NTSB ANC67D0025Accident · No injuriesClosedAeronca 7AC · Cardova, AKJul 30, 1966 · N3112E · Destroyed NTSB NYC67D0138Accident · No injuriesClosedLuscombe 8A · Seaville, NJJul 27, 1966 · N1018K · Destroyed NTSB NYC67F0118Accident · Minor injuriesClosedTaylorcraft DCO-65 · Cobleskill, NYJul 24, 1966 · N46093 · Substantial damage NTSB MKC67D0168Accident · No injuriesClosedAeronca 11AC · Imogene, IAJul 24, 1966 · N3223E · Substantial damage NTSB CHI67F0248Accident · Minor injuriesClosedLuscombe 8A · Northfield, OHJul 24, 1966 · N45615 · Destroyed NTSB MIA67F0115Accident · No injuriesClosedLuscombe 8A · Titusville, FLJul 22, 1966 · N1197K · Substantial damage NTSB MIA67A0008Accident · 1 fatalClosedPiper J3C-65 · Burlington, NCJul 17, 1966 · N2147M · Destroyed NTSB FTW67F0095Accident · Minor injuriesClosedPiper J-3 · Tomball, TXJul 16, 1966 · N75088 · Substantial damage NTSB MIA67F0073Accident · No injuriesClosedAeronca 7AC · Warrington, FLJul 13, 1966 · N81532 · Substantial damage NTSB MKC67D0068Accident · No injuriesClosedAeronca 7AC · Junction City, KSJul 12, 1966 · N3521E · Substantial damage NTSB NYC67F0032Accident · No injuriesClosedPiper J365 · Ft Kent, MEJul 10, 1966 · N30779 · Substantial damage NTSB OAK67D0034Accident · No injuriesClosedLuscombe 8A · Palo Alto, CAJul 9, 1966 · N28601 · Substantial damage NTSB CHI67D0074Accident · No injuriesClosedPiper J-3 · Columbia, KYJul 9, 1966 · N6104H · Substantial damage NTSB FTW67F0083Accident · Serious injuriesClosedLuscombe 8A · Caddo Mills, TXJul 4, 1966 · N1702K · Destroyed NTSB SEA67D0016Accident · No injuriesClosedTaylorcraft BC12-D · Hailey, IDJul 3, 1966 · N39230 · Substantial damage NTSB OAK67D0037Accident · No injuriesClosedPiper J-3C · Hanford, CAJul 3, 1966 · N6741H · Substantial damage NTSB MIA67D0089Accident · Minor injuriesClosedAeronca 7AC · Denmark, SCJun 30, 1966 · N85026 · Substantial damage NTSB CHI67D0065Accident · No injuriesClosedAeronca 7AC · Weathersfield, ILJun 29, 1966 · N84065 · Substantial damage NTSB SEA67F0082Accident · No injuriesClosedPiper J3C-65 · Beavercreek, ORJun 28, 1966 · N48612 · Substantial damage NTSB ANC66A0051Accident · 1 fatalClosedChampion 7AC · Kasilof, AKJun 27, 1966 · N83995 · Substantial damage