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 SEA79FYM67Accident · No injuriesClosedAeronca 7AC · Tigard, ORSep 23, 1979 · N1787E · Substantial damage NTSB IAD79FID35Accident · Minor injuriesClosedPiper PA-12 · Chesapeake, VASep 8, 1979 · N72HW · Substantial damage NTSB MKC79FER71Accident · Serious injuriesClosedAeronca 11AC · Lake Park, MNSep 5, 1979 · N85964 · Substantial damage NTSB CHI79FEC49Accident · No injuriesClosedAeronca 7AC · Deford, MISep 4, 1979 · N85188 · Substantial damage NTSB NYC79FA088Accident · 1 fatalClosedAeronca 7AC · Edinboro, PASep 3, 1979 · N83122 · Destroyed NTSB FTW79FPD41Accident · No injuriesClosedAeronca 7AC · N Richland Hls, TXSep 2, 1979 · N84296 · Substantial damage NTSB LAX79DVG76Accident · Minor injuriesClosedPiper J3 · Pleasant Grove, CAAug 31, 1979 · N40615 · Substantial damage NTSB MIA79FLD87Accident · Serious injuriesClosedPiper J3C · Aurburndale, FLAug 27, 1979 · N6716H · Destroyed NTSB LAX79DDD36Accident · No injuriesClosedAeronca L-3 · Walnut Creek, CAAug 19, 1979 · N49110 · Substantial damage NTSB CHI79FEM33Accident · 2 fatalClosedBreezy FGC100 · Grand Haven, MIAug 5, 1979 · N219TC · 2 aircraft · Minor damage NTSB SEA79DYP39Accident · Minor injuriesClosedTaylorcraft DC-65 · Mead, WAJul 23, 1979 · N57833 · Substantial damage NTSB MIA79FA108Accident · 2 fatalClosedPiper J-3C65 · Ft.Pierce, FLJul 22, 1979 · N26147 · Destroyed NTSB NYC79FFJ24Accident · Minor injuriesClosedPalermo ACE · Geneseo, NYJul 21, 1979 · N666Q · Substantial damage NTSB MIA79FLD81Accident · Serious injuriesClosedTaylorcraft BL-65 · Fort Pierce, FLJul 21, 1979 · N27673 · Destroyed NTSB CHI79FEE72Accident · Minor injuriesClosedLach/Bensen B8M · Rockford, ILJul 20, 1979 · N8447 · Substantial damage NTSB NYC79FFJ23Accident · Serious injuriesClosedPiper J-3 · Skaneateles, NYJul 14, 1979 · N42844 · Substantial damage NTSB NYC79FGM32Accident · Minor injuriesClosedLuscombe 8A · Albion, PAJul 8, 1979 · N45922 · Substantial damage NTSB NYC79DFA31Accident · No injuriesClosedAeronca 7AC · Deryter, NYJul 7, 1979 · N83152 · Substantial damage NTSB MIA79DKJ51Accident · No injuriesClosedAeronca 7AC · Pell City, ALJul 4, 1979 · N85663 · Substantial damage NTSB CHI79FA053Accident · 1 fatalClosedAeronca 11AC · Chippewa Falls, WIJun 25, 1979 · N9408E · Destroyed NTSB IAD79DIA13Accident · Minor injuriesClosedPiper J-3 · Naylor, MDJun 16, 1979 · N1500N · Substantial damage NTSB FTW79FPG44Accident · Serious injuriesClosedPiper J3C-65 · Crawfordsville, ARJun 4, 1979 · N7900A · Substantial damage NTSB MKC79DER45Accident · No injuriesClosedLuscombe 8A · Rush City, MNJun 3, 1979 · N45813 · Destroyed NTSB MKC79FER44Accident · 1 fatalClosedPiper PA-25 · Gaylord, MNMay 19, 1979 · N70152 · Destroyed NTSB OAK79DVD26Accident · Minor injuriesClosedPiper L-4B · Smith River, CAMay 13, 1979 · N8358H · Substantial damage NTSB FTW79FPD19Accident · Serious injuriesClosedAeronca 7AC · Justin, TXMay 13, 1979 · N84726 · Destroyed NTSB MIA79DLD61Accident · No injuriesClosedTaylorcraft BC12D · Brooksville, FLMay 2, 1979 · N95757 · Substantial damage NTSB MIA79FLD60Accident · Minor injuriesClosedPiper J-3C · Arcadia, FLApr 29, 1979 · N2156M · Substantial damage NTSB LAX79DUJ67Accident · No injuriesClosedAeronca 7AC · Tucson, AZApr 29, 1979 · N1338E · Substantial damage NTSB FTW79FPG29Accident · No injuriesClosedBowers Fly · N Little Rock, ARApr 29, 1979 · N1878 · Substantial damage NTSB OAK79FVM19Accident · No injuriesClosedTaylorcraft DC-65 · San Jose, CAApr 24, 1979 · N67755 · Substantial damage NTSB NYC79DHA11Accident · No injuriesClosedAeronca 11AC · Poyntelle, PAApr 22, 1979 · N3295E · Substantial damage NTSB CHI79FEX23Accident · Minor injuriesClosedLuscombe 8E · Lanesville, INApr 21, 1979 · N2698K · Substantial damage NTSB NYC79FNC24Accident · Minor injuriesClosedTaylorcraft BC-12D · Waterville, MEApr 18, 1979 · N43937 · Substantial damage NTSB LAX79DU024|LAX79DUQ24Accident · No injuriesClosedAeronca 7AC · Van Nuys, CAApr 1, 1979 · N2403E · 2 aircraft · Substantial damage NTSB FTW79FPD11Accident · Minor injuriesClosedTaylorcraft BC12-D · Forestburg, TXMar 27, 1979 · N44174 · Substantial damage NTSB FTW79DRJ11Accident · Minor injuriesClosedPiper J-3 · Monterey, LAMar 25, 1979 · N6493H · Substantial damage NTSB SEA79FYM22Accident · Minor injuriesClosedPiper J3C-65 · Camas, WAMar 24, 1979 · N1326N · Substantial damage NTSB NYC79FHM14Accident · No injuriesClosedAeronca 11AC · Newburgh, NYMar 23, 1979 · N9512E · Substantial damage NTSB SEA79FA025Accident · 2 fatalClosedTaylorcraft BC-65 · Orting, WAMar 17, 1979 · N23633 · Destroyed NTSB MIA79FLA16Accident · No injuriesClosedAeronca 7AC · Blakely, GAMar 6, 1979 · N83796 · Substantial damage NTSB SEA79DYM12Accident · No injuriesClosedPiper J3C-65 · The Dalles, ORJan 28, 1979 · N5721N · Substantial damage NTSB MKC79DCD09Accident · No injuriesClosedTaylorcraft BC-12D · Nevada, IAJan 7, 1979 · N95622 · Substantial damage NTSB LAX79DUJ39Accident · Serious injuriesClosedAeronca 0-58B · Flagstaff, AZDec 31, 1978 · N33323 · Substantial damage NTSB FTW79FPD05Accident · No injuriesClosedLuscombe 8A · Clifton, TXDec 29, 1978 · N45497 · Substantial damage NTSB CHI79DEX11Accident · No injuriesClosedLuscombe 8A · Greenwood, INNov 30, 1978 · N71897 · Substantial damage NTSB MIA79DKJ12Accident · No injuriesClosedAeronca 7AC · Opp, ALNov 16, 1978 · N83644 · Substantial damage NTSB MKC79DCG05Accident · No injuriesClosedAeronca 7AC · Corning, MOOct 14, 1978 · N82140 · Substantial damage NTSB FTW78DA003Accident · Minor injuriesClosedWaco VKS-7 · Tahlequah, OKOct 14, 1978 · N2309 · 2 aircraft · Substantial damage NTSB NYC79FFJ03Accident · Minor injuriesClosedAeronca 11AC · Collins, NYOct 8, 1978 · N3635E · Substantial damage