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

36 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, 1972, 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\") = 1972
    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 LAX73DUM16Accident · No injuriesClosedCessna 177 · Imperial, CADec 18, 1972 · N3478T · Substantial damageNTSB LAX73DVA27Accident · No injuriesClosedCessna 172 · Bakersfield, CAOct 10, 1972 · N19879 · Substantial damageNTSB LAX73DUG2IAccident · No injuriesClosedPiper PA-28 · Havasu Ldg, CAOct 10, 1972 · N5983U · Substantial damageNTSB OAK73DVG22Accident · No injuriesClosedCessna 172 · Vacaville, CASep 29, 1972 · N3854Q · Substantial damageNTSB LAX73DUG19Accident · No injuriesClosedPiper PA-22 · Bg Bear Cty, CASep 28, 1972 · N1163C · Substantial damageNTSB LAX73FUM06Accident · No injuriesClosedPiper PA-23 · San Diego, CASep 23, 1972 · N156M · Substantial damageNTSB OAK73DVD13Accident · Minor injuriesClosedPitts Spec S-1C · Tracey, CASep 13, 1972 · N8L · Substantial damageNTSB LAX73DUG16Accident · No injuriesClosedPiper PA-12 · Idyllwild, CASep 6, 1972 · N4166M · Substantial damageNTSB OAK73DVG14Accident · No injuriesClosedPiper PA-22 · Redding, CAAug 26, 1972 · N8825D · Substantial damageNTSB LAX73DVM03Accident · No injuriesClosedAero-Comdr 100 · Niland, CAAug 25, 1972 · N5550M · Substantial damageNTSB LAX73AL007Accident · 3 fatalClosedPiper PA-28 · Ontario, CAAug 22, 1972 · N8195N · DestroyedNTSB OAK73DVA13Accident · No injuriesClosedPiper PA-22 · Mariposa, CAAug 10, 1972 · N3611P · Substantial damageNTSB LAX73FUM01Accident · No injuriesClosedPiper PA-28 · Ramona, CAAug 7, 1972 · N8168N · Substantial damageNTSB LAX73FUG08Accident · No injuriesClosedPiper PA-28 · Rialto, CAJul 30, 1972 · N8738N · Substantial damageNTSB LAX73FUG07Accident · Serious injuriesClosedCessna 177 · Corona, CAJul 30, 1972 · N3316T · DestroyedNTSB LAX73AL004Accident · 3 fatalClosedCessna 172 · La Jolla, CAJul 29, 1972 · N2820Q · 2 aircraft · Substantial damageNTSB LAX73FUA04Accident · No injuriesClosedPiper PA-28 · Torrance, CAJul 23, 1972 · N4404T · Substantial damageNTSB OAK73FVD05Accident · No injuriesClosedBeech A23-19 · Vineburg, CAJul 15, 1972 · N7611R · Substantial damageNTSB OAK73FVG03Accident · No injuriesClosedCessna 177 · Shngle Spgs, CAJul 13, 1972 · N29441 · Substantial damageNTSB LAX73DUQ06Accident · No injuriesClosedCessna 172 · Inyokern, CAJun 19, 1972 · N84827 · Substantial damageNTSB OAK72FVA79Accident · No injuriesClosedPiper PA-28 · Columbia, CAJun 18, 1972 · N5769U · Substantial damageNTSB OAK72DVM35Accident · No injuriesClosedCessna 172 · San Jose, CAMay 21, 1972 · N7775G · Substantial damageNTSB LAX72DUQ88Accident · No injuriesClosedChampion 7KCAB · Pacoima, CAMay 21, 1972 · N5065X · Substantial damageNTSB OAK72DVG56Accident · No injuriesClosedCessna 177 · Paradise, CAMay 14, 1972 · N3448T · Substantial damageNTSB LAX72FUQ79Accident · No injuriesClosedPiper PA-28 · Quartz Hill, CAApr 17, 1972 · N5541F · Substantial damageNTSB OAK72DVA65Accident · No injuriesClosedCessna 172 · Dunlap, CAApr 1, 1972 · N9863G · Substantial damageNTSB LAX72DVA63Accident · No injuriesClosedCessna 172 · Shafter, CAMar 29, 1972 · N79896 · Substantial damageNTSB LAX72DVA64Accident · No injuriesClosedPiper PA-28 · Bakersfield, CAMar 24, 1972 · N5208W · Substantial damageNTSB LAX72DUM22Accident · No injuriesClosedPiper PA-28 · Santee, CAMar 11, 1972 · N4395T · Substantial damageNTSB OAK72DVG40Accident · No injuriesClosedPiper PA-28 · Nut Tree, CAMar 10, 1972 · N5951U · Substantial damageNTSB OAK72DVA50Accident · No injuriesClosedPiper PA-28 · Tulare, CAFeb 27, 1972 · N6514W · Substantial damageNTSB OAK72DVD36Accident · No injuriesClosedCessna 177 · Hayward, CAFeb 18, 1972 · N29523 · Substantial damageNTSB OAK72DVM24Accident · No injuriesClosedPiper PA-22 · Gonzales, CAFeb 15, 1972 · N7417D · Substantial damageNTSB LAX72AL045Accident · No injuriesClosedCessna 150J · Fntn Valley, CAJan 15, 1972 · N51362 · 2 aircraft · Substantial damageNTSB LAX72DUG49Accident · Minor injuriesClosedPiper PA-28 · Thermal, CAJan 10, 1972 · N5906W · Substantial damageNTSB LAX72FUQ59Accident · Minor injuriesClosedCessna 172K · Palmdale, CAJan 5, 1972 · N7098G · Substantial damage