NTSB investigations: Lycoming O&VO-360 series, 1979

114 cases on aircraft whose registry engine model is Lycoming O&VO-360 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\") = 1979
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41514'))
  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 LAX79DUQ43Accident · No injuriesClosedBellanca 8GCBC · Rosamond, CAAug 4, 1979 · N8667V · Substantial damageNTSB CHI79DEI36Accident · No injuriesClosedPiper PA-28 · Painesville, OHAug 4, 1979 · N2925Q · Substantial damageNTSB FTW79FPG70Accident · No injuriesClosedMooney M20C · Conway, ARAug 1, 1979 · N79392 · Substantial damageNTSB NYC79FHJ27Accident · Minor injuriesClosedBeech C23 · Mattituck, NYJul 29, 1979 · N60045 · Substantial damageNTSB CHI79FEG22Accident · Serious injuriesClosedBeech B23 · Waynesville, OHJul 29, 1979 · N9132T · Substantial damageNTSB CHI79FA061Accident · 1 fatalClosedMooney M20C · Brocton, ILJul 26, 1979 · N6217U · DestroyedNTSB CHI79DEV28Accident · No injuriesClosedBrantly B-2B · Flanagan, ILJul 23, 1979 · N2283U · Substantial damageNTSB OAK79DVG64Accident · No injuriesClosedMooney M20C · Montague, CAJul 22, 1979 · N2567W · Substantial damageNTSB UNK79X0112Accident · Minor injuriesClosedGrumman AA-5B · Polo, ILJul 13, 1979 · N28411 · Substantial damageNTSB IAD79FA060Accident · No injuriesClosedMooney M20G · Bluefield, WVJul 5, 1979 · N6791N · 2 aircraft · Substantial damageNTSB LAX79DUJ93Accident · Serious injuriesClosedCessna 177 · Bullhead City, AZJul 4, 1979 · N19939 · No damageNTSB NYC79DNC34Accident · No injuriesClosedPiper PA-28 · Vinalhaven, VTJul 3, 1979 · N4342T · Substantial damageNTSB MKC79DCG53Accident · No injuriesClosedMooney M20C · Ava, MOJul 3, 1979 · N6668R · Substantial damageNTSB OAK79DVG59Accident · No injuriesClosedBeech C23 · Grass Valley, CAJun 30, 1979 · N6628E · Substantial damageNTSB MKC79DCD23Accident · No injuriesClosedCessna 177 · Oelwein, IAJun 22, 1979 · N34631 · Substantial damageNTSB IAD79FIG08Accident · No injuriesClosedCessna 177 · Westminster, MDJun 20, 1979 · N29400 · Substantial damageNTSB DEN79FQA32Accident · No injuriesClosedBeech C23 · Albuquerque, NMJun 18, 1979 · N23986 · 2 aircraft · Substantial damageNTSB LAX79DUJ85Accident · No injuriesClosedCessna 177B · Phoenix, AZJun 17, 1979 · N34577 · Substantial damageNTSB SEA79DYM40Accident · No injuriesClosedBellanca 8GCBC · The Dalles, ORJun 14, 1979 · N4143Y · Substantial damageNTSB MKC79FER48Accident · Minor injuriesClosedCessna 177 · Longville, MNJun 10, 1979 · N34471 · Substantial damageNTSB FTW79DPD22Accident · No injuriesClosedPitts S-1 · Roanoke, TXJun 10, 1979 · N10SC · DestroyedNTSB ANC79DA057Incident · Minor injuriesClosedPiper PA-28 · Ophir, AKJun 8, 1979 · N6475J · Minor damageNTSB MKC79FCA16Accident · Serious injuriesClosedGrumman AA-5B · Owensville, MOJun 6, 1979 · N28467 · DestroyedNTSB MIA79FA093Accident · 1 fatalClosedBeech 95 · Leesburg, FLJun 6, 1979 · N2032C · DestroyedNTSB NYC79FHJ19Incident · No injuriesClosedCessna 177B · Amityville, NYJun 1, 1979 · N30639 · Minor damageNTSB OAK79FVA36Accident · Minor injuriesClosedBeech C-23 · Fresno, CAMay 28, 1979 · N2041L · Substantial damageNTSB OAK79DVA35Accident · No injuriesClosedBeech C23 · Fresno, CAMay 28, 1979 · N5289M · Substantial damageNTSB SEA79DYE24Accident · No injuriesClosedCessna 177B · Mercer Island, WAMay 26, 1979 · N991MP · Substantial damageNTSB DEN79FTM18Accident · No injuriesClosedMooney M20C · Bullfrog, UTMay 25, 1979 · N2957L · Substantial damageNTSB DEN79DTM16Accident · No injuriesClosedPiper PA-28 · Green River, UTMay 21, 1979 · N6553F · Substantial damageNTSB LAX79DUG39Accident · No injuriesClosedPiper PA-28 · El Monte, CAMay 20, 1979 · N33565 · Substantial damageNTSB FTW79FRD29Accident · No injuriesClosedPiper PA-28 · Patterson, LAMay 16, 1979 · N9301J · Substantial damageNTSB MIA79FKG41Accident · 1 fatalClosedPitts Spec S-1 · Warner Robins, GAMay 15, 1979 · N42R · DestroyedNTSB SEA79FYK10Accident · Minor injuriesClosedPiper PA-24 · Klamath Falls, ORMay 6, 1979 · N5846P · Substantial damageNTSB NYC79FA045Accident · 2 fatalClosedBeech C-23 · Saltsburg, PAMay 5, 1979 · N6550R · Substantial damageNTSB CHI79DEX29Accident · No injuriesClosedPiper PA-28 · Hagertown, INMay 5, 1979 · N15425 · Substantial damageNTSB LAX79FVA31Accident · No injuriesClosedPiper PA-44 · Kernville, CAMay 4, 1979 · N2160E · Substantial damageNTSB MIA79FKJ36Accident · No injuriesClosedBeech C-23 · Birmingham, ALMay 1, 1979 · N9186S · Substantial damageNTSB MKC79FCG41Accident · Serious injuriesClosedPiper PA-25 · Camdenton, MOApr 29, 1979 · N6944Z · Substantial damageNTSB SEA79FYM30Accident · Serious injuriesClosedPiper PA-28 · Sandy, ORApr 28, 1979 · N7142W · DestroyedNTSB OAK79FA027Accident · Minor injuriesClosedPiper PA-22 · King City, CAApr 25, 1979 · N7318D · Substantial damageNTSB LAX79DUJ70Accident · No injuriesClosedBeech C-23 · Phoenix, AZApr 24, 1979 · N24629 · Substantial damageNTSB NYC79FA040Accident · 1 fatalClosedLake LA-4 · Jonesboro, MEApr 20, 1979 · N7639L · DestroyedNTSB CHI79FEX21Accident · Serious injuriesClosedBeech C-23 · Fishers, INApr 17, 1979 · N2064L · Substantial damageNTSB CHI79FA045Accident · 2 fatalClosedPiper PA-28 · Veedersburg, INApr 17, 1979 · N1895T · 2 aircraft · DestroyedNTSB MIA79DLD58Accident · No injuriesClosedPiper PA-44 · Useppa Island, FLApr 14, 1979 · N2089K · Substantial damageNTSB DEN79FQA23Accident · Serious injuriesClosedPiper PA-28 · Gallup, NMApr 6, 1979 · N5428F · Substantial damageNTSB FTW79DRA13Accident · No injuriesClosedMooney M20A · Tomball, TXMar 25, 1979 · N6556B · Substantial damageNTSB MIA79FKG25Accident · No injuriesClosedPiper PA-24 · Hawkinsville, GAMar 18, 1979 · N7622P · Substantial damageNTSB MIA79FKG24Accident · No injuriesClosedMooney M20C · Peachtree City, GAMar 13, 1979 · N1956Y · Substantial damage