NTSB investigations: Continental O-470 series, 1978

161 cases on aircraft whose registry engine model is Continental O-470 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.

Cases, newest first

Query with SQL
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 year(c.\"eventDate\") = 1978
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026'))
  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.

NTSB ANC78FA069Accident · 2 fatalClosedCessna 182Q · Ketchikan, AKAug 29, 1978 · N735NZ · DestroyedNTSB FTW78DRD52Accident · Minor injuriesClosedCessna 180F · Buras, LAAug 22, 1978 · N52108 · Substantial damageNTSB OAK78FA044Accident · 1 fatalClosedCessna 182Q · Eureka, CAAug 21, 1978 · N759LZ · DestroyedNTSB IAD78FA096Accident · No injuriesClosedCessna 180 · Roanoke, VAAug 21, 1978 · N7827K · 2 aircraft · Substantial damageNTSB MKC78DCJ41Accident · No injuriesClosedCessna 182 · Aurora, NEAug 15, 1978 · N8964G · Substantial damageNTSB IAD78FKW10Accident · No injuriesClosedCessna 182 · Westmoreland, TNAug 9, 1978 · N735RT · Substantial damageNTSB CHI78FET33Accident · No injuriesClosedCessna 182M · Chesterton, INAug 7, 1978 · N92125 · Substantial damageNTSB ANC78DA068Accident · No injuriesClosedCessna 180C · Pt. Possession, AKAug 7, 1978 · N96019 · Substantial damageNTSB MKC78DER83Accident · No injuriesClosedCessna 180B · Eveleth, MNAug 4, 1978 · N5273E · Substantial damageNTSB NYC78FNA41Accident · No injuriesClosedCessna 182 · Hyannis, MAAug 3, 1978 · N91529 · Substantial damageNTSB OAK78DVM36Accident · No injuriesClosedCessna 182 · Salinas, CAAug 2, 1978 · N1510M · Substantial damageNTSB NYC78FNC42Accident · Minor injuriesClosedCessna 182D · Hollis, NHJul 29, 1978 · N8810X · Substantial damageNTSB FTW78DRA34Accident · No injuriesClosedCessna 180K · Houston, TXJul 28, 1978 · N66109 · Substantial damageNTSB LAX78FUG41Accident · No injuriesClosedCessna 182E · Temecula, CAJul 22, 1978 · N3188Y · Substantial damageNTSB LAX78FUA20Accident · No injuriesClosedCessna 180 · Long Beach, CAJul 22, 1978 · N55KA · Substantial damageNTSB FTW78FPJ31Accident · No injuriesClosedCessna 182 · Cushing, OKJul 21, 1978 · N6407A · Substantial damageNTSB FTW78FA065Accident · 3 fatalClosedCessna 310B · Cameron, LAJul 20, 1978 · N5403A · DestroyedNTSB CHI78FEM29Accident · No injuriesClosedCessna 180 · Otsego Lake, MIJul 15, 1978 · N1608C · Substantial damageNTSB IAD78DLQ25Accident · No injuriesClosedCessna 182F · Flemingsburg, KYJul 11, 1978 · N3566U · Substantial damageNTSB NYC78FHM20Accident · Serious injuriesClosedCessna 182 · Fairfield, NJJul 9, 1978 · N1287S · 2 aircraft · Substantial damageNTSB MKC78FER67Accident · Minor injuriesClosedCessna 180J · Goodland, MNJul 8, 1978 · N9993N · Substantial damageNTSB MIA78DLA42Accident · No injuriesClosedCessna 182 · Gainesville, FLJul 4, 1978 · N3592F · Substantial damageNTSB LAX78FVA21Accident · No injuriesClosedCessna 182 · Avalon, CAJul 4, 1978 · N182DJ · Substantial damageNTSB OAK78FAO36Accident · 4 fatalClosedCessna 182A · Red Bluff, CAJul 2, 1978 · N3873D · DestroyedNTSB OAK78DVG55Accident · No injuriesClosedCessna 182 · Fair Oaks, CAJul 2, 1978 · N92187 · Substantial damageNTSB LAX78FA058Accident · 1 fatalClosedCessna 182 · San Diego, CAJul 1, 1978 · N2341G · 2 aircraft · DestroyedNTSB ANC78DAG82Accident · No injuriesClosedCessna 180 · Bethel, AKJul 1, 1978 · N2978A · Substantial damageNTSB DEN78FTC29Accident · Serious injuriesClosedCessna 182 · Tipton, WYJun 28, 1978 · N3559F · Substantial damageNTSB MIA78FLD57Accident · Minor injuriesClosedCessna 180H · New Smyrna Bch, FLJun 27, 1978 · N2704X · DestroyedNTSB MIA78FLA41Accident · No injuriesClosedCessna 180 · Jacksonville, FLJun 26, 1978 · N2378C · Substantial damageNTSB OAK78FA035Accident · 4 fatalClosedCessna 182P · S Lake Tahoe, CAJun 24, 1978 · N8257M · DestroyedNTSB IAD78FIJ15Accident · Minor injuriesClosedCessna 182E · Charleston, WVJun 23, 1978 · N2992Y · Substantial damageNTSB MKC78FCG35Accident · No injuriesClosedCessna 182 · Columbia, MOJun 14, 1978 · N1447S · Substantial damageNTSB FTW78DQG47Accident · No injuriesClosedCessna 182 · Tulia, TXJun 14, 1978 · N735SN · Substantial damageNTSB FTW78DRJ21Accident · No injuriesClosedCessna 180J · Shreveport, LAJun 13, 1978 · N7801K · Substantial damageNTSB ANC78DA041Accident · No injuriesClosedCessna 180H · Aniakchak Bay, AKJun 11, 1978 · N3488Y · Substantial damageNTSB LAX78DUJ72Accident · Minor injuriesClosedCessna 182 · Page, AZJun 10, 1978 · N70801 · Substantial damageNTSB SEA78FA036Accident · 1 fatalClosedCessna 182A · Featherville, IDJun 9, 1978 · N2719G · DestroyedNTSB MIA78DLA37Accident · No injuriesClosedCessna 182 · Fargo, GAJun 8, 1978 · N7298N · Substantial damageNTSB IAD78DID08Accident · No injuriesClosedBeech T-34B · Dillwyn, VAJun 8, 1978 · N31810 · Substantial damageNTSB ANC78DAG67Accident · No injuriesClosedCessna 180A · Dillingham, AKJun 8, 1978 · N2204C · Substantial damageNTSB FTW78DQG33Accident · No injuriesClosedCessna 182 · Rotan, TXJun 6, 1978 · N2453X · Substantial damageNTSB CHI78FEK22Accident · No injuriesClosedCessna 182 · Columbus, OHJun 6, 1978 · N52726 · Substantial damageNTSB IAD78FIJ12Accident · Minor injuriesClosedCessna 182L · Man, WVJun 4, 1978 · N42366 · Substantial damageNTSB MIA78DKG46Accident · Serious injuriesClosedCessna 182 · Atlanta, GAJun 3, 1978 · N70698 · Substantial damageNTSB SEA78DYP30Accident · No injuriesClosedCessna 180 · Kahlotus, WAMay 30, 1978 · N7616K · Substantial damageNTSB LAX78AA050Accident · 4 fatalClosedCessna 310 · Irvine, CAMay 29, 1978 · N3699D · DestroyedNTSB UNK78X0122Accident · 2 fatalClosedCessna 180C · Numazi, JAMay 27, 1978 · N3833 · DestroyedNTSB FTW78DPJ25Accident · No injuriesClosedCessna 182 · Lawton, OKMay 27, 1978 · N2692G · Substantial damageNTSB MKC78FCG31Accident · No injuriesClosedCessna 180H · Warrensburg, MOMay 20, 1978 · N741M · Substantial damage