NTSB investigations: Lycoming 0-320 series, 1973, CA

31 cases on aircraft whose registry engine model is Lycoming 0-320 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: Lycoming 0-320 series, 1973, CA per year, 1964–2026: 1,367 cases
196425
196530
196646
196750
196841
196933
197041
197130
197236
197331
197424
197524
197618
197739
197836
197932
198032
198130
198228
198327
198424
198519
198627
198722
198822
198919
199029
199122
199220
199328
199425
199520
199620
199713
199817
199920
200024
200124
200225
200321
200417
200520
200619
200718
200817
200917
201012
20119
20126
201311
20148
201512
201612
201712
201813
201914
20207
20217
20226
202313
20249
20253
202611

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\") = 1973
    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 ('41508'))
  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 OAK74DVD18Accident · No injuriesClosedCessna 172 · Novato, CADec 18, 1973 · N19886 · Substantial damageNTSB LAX74AUQ22Accident · No injuriesClosedPiper PA-28 · Valencia, CADec 8, 1973 · N6852W · Substantial damageNTSB OAK74DVG19Accident · No injuriesClosedPiper PA-28 · Rio Linda, CANov 14, 1973 · N1671J · Substantial damageNTSB LAX74DUG21Accident · No injuriesClosedPiper PA-28 · Yucca Vally, CAOct 27, 1973 · N98194 · Substantial damageNTSB OAK74FVG18Accident · No injuriesClosedBeech B19 · Sacremento, CAOct 18, 1973 · N1949W · Substantial damageNTSB LAX74DUQ14Accident · No injuriesClosedPiper PA-18A · Mojave, CASep 23, 1973 · N9907D · Substantial damageNTSB OAK74DVA19Accident · No injuriesClosedPiper PA-28 · Madera, CASep 6, 1973 · N98287 · Substantial damageNTSB OAK74DVA18Accident · No injuriesClosedPiper PA-22 · Kettleman, CASep 5, 1973 · N9411D · Substantial damageNTSB ANC74DAG39Accident · No injuriesClosedPiper PA-18 · Palmer, CASep 4, 1973 · N5994Z · Substantial damageNTSB LAX74DUG12Accident · No injuriesClosedCessna 172K · Yucca Valy, CAAug 29, 1973 · N79034 · Substantial damageNTSB LAX74FUQ11Accident · Minor injuriesClosedPiper PA-28 · Boron, CAAug 13, 1973 · N7080R · Substantial damageNTSB OAK74DXQ06Accident · No injuriesClosedCessna 172 · Mammoth Lks, CAAug 12, 1973 · N7736G · Substantial damageNTSB LAX74FVA16Accident · Serious injuriesClosedPiper PA-28 · Bakersfield, CAAug 9, 1973 · N5734W · Substantial damageNTSB LAX74DVA10Accident · No injuriesClosedCessna 172K · Delano, CAAug 6, 1973 · N84195 · Substantial damageNTSB LAX74FUD01Accident · No injuriesClosedPiper PA-28 · Snta Monica, CAAug 1, 1973 · N4915T · 2 aircraft · Substantial damageNTSB LAX74FUQ05Accident · No injuriesClosedPiper PA-28 · Simi Valley, CAJul 16, 1973 · N4146J · Substantial damageNTSB LAX74FUG02Accident · No injuriesClosedPiper PA-28 · Mecca, CAJul 9, 1973 · N5746U · Substantial damageNTSB OAK73DVM41Accident · No injuriesClosedChampion 7GCBC · Palo Alto, CAJun 28, 1973 · N5149X · Substantial damageNTSB LAX73FUQ31Accident · Minor injuriesClosedPiper PA-28 · Van Nuys, CAMay 10, 1973 · N1599J · Substantial damageNTSB OAK73DVD33Accident · No injuriesClosedPiper PA-20 · Concord, CAApr 22, 1973 · N7454K · Substantial damageNTSB LAX73FUM28Accident · No injuriesClosedCessna 172K · Oceanside, CAApr 6, 1973 · N79087 · Substantial damageNTSB LAX73FUQ28Accident · No injuriesClosedPiper PA-18 · Tehachapi, CAApr 1, 1973 · N3803Z · Substantial damageNTSB LAX73FUA37Accident · Minor injuriesClosedPiper PA-28 · Capistrano, CAMar 25, 1973 · N4395T · Substantial damageNTSB OAK73DVA45Accident · No injuriesClosedChampion 7GCAA · Chowchilla, CAMar 18, 1973 · N9606S · Substantial damageNTSB LAX73FUM20Accident · No injuriesClosedBeech B19 · San Diego, CAMar 3, 1973 · N9703L · Substantial damageNTSB LAX73FUG43Accident · Minor injuriesClosedCommuter 150 · Rubidoux, CAFeb 25, 1973 · N2367 · Substantial damageNTSB LAX73DUG40Accident · No injuriesClosedHoward DGA15P · Elsinore, CAFeb 23, 1973 · N65046 · 2 aircraft · Substantial damageNTSB OAK73DVM24Accident · No injuriesClosedPiper PA-28 · San Jose, CAFeb 22, 1973 · N494FL · Substantial damageNTSB LAX73DUG32Accident · No injuriesClosedStarduster SA100 · Riverside, CAJan 28, 1973 · N2268 · Substantial damageNTSB LAX73DUM17Accident · No injuriesClosedPiper PA-28 · Valley Ctr, CAJan 19, 1973 · N995PK · Substantial damageNTSB OAK73AP019Accident · 1 fatalClosedPiper PA-28 · Hayward, CAJan 7, 1973 · N4160J · 2 aircraft · Substantial damage