NTSB investigations: Continental O-470 series, 1978, CA

21 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 per year

19642026
NTSB investigations: Continental O-470 series, 1978, CA per year, 1964–2026: 657 cases
196427
196533
196627
196737
196817
196923
197024
197123
197216
197318
197416
197522
197612
197715
197821
197921
198015
198110
19828
198314
198414
19854
198610
19879
19887
19896
199014
199114
19928
19935
19943
19956
19967
199710
19986
19993
20002
20011
200210
20039
20046
20059
20067
20077
20082
20094
20107
20114
20125
20135
20146
20154
20169
20175
20186
20195
20203
20211
20223
20233
20258
20261

Latest cases

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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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 LAX79DUQ09Accident · No injuriesClosedCessna 182 · Santa Barbara, CADec 13, 1978 · N1386S · Substantial damageNTSB OAK79DA001Accident · 1 fatalClosedCessna 182 · Monterey, CAOct 11, 1978 · N759TU · DestroyedNTSB LAX78DUG56Accident · No injuriesClosedCessna 182M · El Monte, CASep 23, 1978 · N70833 · Substantial damageNTSB LAX78DUQ43Accident · No injuriesClosedCessna 182 · Burbank, CASep 6, 1978 · N735DK · Substantial damageNTSB OAK78FA044Accident · 1 fatalClosedCessna 182Q · Eureka, CAAug 21, 1978 · N759LZ · DestroyedNTSB OAK78DVM36Accident · No injuriesClosedCessna 182 · Salinas, CAAug 2, 1978 · N1510M · 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 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 OAK78FA035Accident · 4 fatalClosedCessna 182P · S Lake Tahoe, CAJun 24, 1978 · N8257M · DestroyedNTSB LAX78AA050Accident · 4 fatalClosedCessna 310 · Irvine, CAMay 29, 1978 · N3699D · DestroyedNTSB OAK78DA032Accident · 3 fatalClosedCessna 182Q · Weber Peak, CAMay 16, 1978 · N735FR · DestroyedNTSB LAX78DVM23Accident · Minor injuriesClosedCessna 182C · Simmler, CAMay 9, 1978 · N8993T · Substantial damageNTSB OAK78FA025Accident · 1 fatalClosedCessna 182F · Half Moon Bay, CAMar 26, 1978 · N3108U · DestroyedNTSB OAK78FVA27Accident · Serious injuriesClosedCessna 182P · Gustine, CAFeb 23, 1978 · N6536M · Substantial damageNTSB OAK78FA015Accident · 1 fatalClosedCessna 182 · Turlock, CAJan 29, 1978 · N5472B · DestroyedNTSB OAK78DVG15Accident · No injuriesClosedCessna 180 · Redding, CAJan 20, 1978 · N4646A · Substantial damageNTSB LAX78FUM08Accident · No injuriesClosedCessna 182L · Santa Paula, CAJan 2, 1978 · N42291 · Substantial damage