NTSB investigations: Lycoming 0-320 series, 1973

316 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, 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\") = 1973
    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 SEA74FTI10Accident · No injuriesClosedCallair A-2 · Anaconda, MTOct 13, 1973 · N2918V · Substantial damageNTSB CHI74FEE27Accident · No injuriesClosedCessna 172K · Plainfield, ILOct 13, 1973 · N7341G · Substantial damageNTSB NYC74FFA16Accident · No injuriesClosedCessna 172I · Alexandria Bay, NYOct 12, 1973 · N46100 · Substantial damageNTSB MKC74FTG07Accident · No injuriesClosedPiper PA-28 · Fargo, NDOct 10, 1973 · N8825N · Substantial damageNTSB IAD74FLQ12Accident · No injuriesClosedCessna 172K · Williamsburg, KYOct 10, 1973 · N7042G · Substantial damageNTSB IAD74FLQ11Accident · No injuriesClosedPiper PA-28 · Louisville, KYOct 10, 1973 · N5253W · Substantial damageNTSB MKC74DCD17Accident · Serious injuriesClosedPiper PA-22 · West Branch, IAOct 8, 1973 · N3336Z · Substantial damageNTSB MIA74DKG36Accident · No injuriesClosedPiper PA-24 · Gainesville, GAOct 7, 1973 · N7329F · Substantial damageNTSB NYC74FFA13Accident · No injuriesClosedCessna 172L · Bloomingburg, NYOct 6, 1973 · N7938G · Substantial damageNTSB CHI74AC031Accident · 2 fatalClosedBellanca 7GCBC · Morris, ILOct 6, 1973 · N36034 · DestroyedNTSB ANC74DAG64Accident · No injuriesClosedPiper PA-14 · Anchorage, AKOct 6, 1973 · N5135H · Substantial damageNTSB NYC74DHD17Accident · No injuriesClosedPiper PA-28 · Berlin, NJOct 5, 1973 · N5580U · Substantial damageNTSB LAX74AL026Accident · 2 fatalClosedPiper PA-18 · Tacna, AZOct 4, 1973 · N4265Z · Substantial damageNTSB DEN74DQD06Accident · No injuriesClosedPiper PA-28 · Silver City, NMOct 1, 1973 · N98222 · Substantial damageNTSB SEA74DYC19Accident · Minor injuriesClosedPiper PA-28 · Colton, ORSep 30, 1973 · N2479T · Substantial damageNTSB NYC74FEM08Accident · Serious injuriesClosedMooney M20 · Dubois, PASep 30, 1973 · N6531B · Substantial damageNTSB CHI74FEE24Accident · No injuriesClosedPiper PA-28 · Plainfield, ILSep 30, 1973 · N8225N · Substantial damageNTSB ANC74FAG73Accident · Serious injuriesClosedPiper PA-18 · Gulkana, AKSep 30, 1973 · N3577P · DestroyedNTSB ANC74DAG60Accident · No injuriesClosedBellanca 7GCBC · Anchorage, AKSep 29, 1973 · N57484 · Substantial damageNTSB SEA74FVC18Accident · No injuriesClosedPiper PA-28 · Salem, ORSep 26, 1973 · N5239T · Substantial damageNTSB SEA74DTA10Accident · No injuriesClosedBellanca 7GCA · Lodge Pole, MTSep 25, 1973 · N57476 · Substantial damageNTSB NYC74DNC75Accident · No injuriesClosedPiper PA-18 · Lebanon, NHSep 25, 1973 · N13814 · Substantial damageNTSB MKC74DCJ11Accident · No injuriesClosedPiper PA-18 · Ainsworth, NESep 25, 1973 · N8519Y · Substantial damageNTSB LAX74DUQ14Accident · No injuriesClosedPiper PA-18A · Mojave, CASep 23, 1973 · N9907D · Substantial damageNTSB IAD74DIJ19Accident · No injuriesClosedPiper PA-28 · Burlington, NCSep 23, 1973 · N95069 · Substantial damageNTSB MKC74DCD16Accident · No injuriesClosedPitts S-1C · Washburn, IASep 22, 1973 · N17MP · Substantial damageNTSB CHI74FEP17Accident · No injuriesClosedPiper PA-22 · Arena, WISep 22, 1973 · N6838B · Substantial damageNTSB ANC74FAA15Accident · No injuriesClosedPiper PA-18 · Clear, AKSep 21, 1973 · N9855D · Substantial damageNTSB MKC74DER15Accident · No injuriesClosedBellanca 17-30A · Lake Elmo, MNSep 18, 1973 · N8286R · 2 aircraft · Substantial damageNTSB OAK74DVW07Accident · No injuriesClosedBeech 19 · Las Vegas, NVSep 17, 1973 · N24627 · Substantial damageNTSB DEN74DTC13Accident · No injuriesClosedPiper PA-18 · Wheatland, WYSep 16, 1973 · N4332Z · DestroyedNTSB MKC74DCJ10Accident · No injuriesClosedPiper PA-25 · Gresham, NESep 15, 1973 · N6481Z · Substantial damageNTSB ANC74DAG49Accident · No injuriesClosedPiper PA-14 · Susitna, AKSep 15, 1973 · N5100H · Substantial damageNTSB ANC74DAG56Accident · No injuriesClosedPiper PA-18 · Gulkana, AKSep 14, 1973 · N4326Z · Substantial damageNTSB ANC74DAG52Accident · No injuriesClosedPiper PA-18 · Pilot Point, AKSep 14, 1973 · N5743Y · Substantial damageNTSB ANC74DAG46Accident · No injuriesClosedPiper PA-18 · Kenai, AKSep 12, 1973 · N9405P · Substantial damageNTSB ANC74DAG54Accident · No injuriesClosedPiper PA-18 · Gulkana, AKSep 11, 1973 · N3856Z · Substantial damageNTSB CHI74FEE18Accident · Minor injuriesClosedPiper PA-22 · Glenwood, ILSep 10, 1973 · N5725D · Substantial damageNTSB NYC74DHJ15Accident · No injuriesClosedCessna 150 · Deerpark, NYSep 9, 1973 · N60616 · 2 aircraft · Substantial damageNTSB MIA74DKJ24Accident · No injuriesClosedPiper PA-22 · Daphne, ALSep 9, 1973 · N3425Z · Substantial damageNTSB LAX74DUJ18Accident · No injuriesClosedPiper PA-28 · White Mt Lk, AZSep 9, 1973 · N1449T · DestroyedNTSB CHI74FEI12Accident · Minor injuriesClosedPiper PA-28 · Gustavus, OHSep 9, 1973 · N5318W · Substantial damageNTSB ANC74DAG47Accident · No injuriesClosedPiper PA-18 · Talchultna R, AKSep 9, 1973 · N9355D · Substantial damageNTSB MKC74DER12Accident · No injuriesClosedPiper PA-28 · Elk River, MNSep 8, 1973 · N7254F · Substantial damageNTSB CHI74DEV19Accident · Minor injuriesClosedPiper PA-28 · Bloomington, ILSep 7, 1973 · N2341T · 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 NYC74DFA08Accident · No injuriesClosedAmer Avco AA-5 · Mt Upton, NYSep 4, 1973 · N5458L · Substantial damageNTSB ANC74DAG39Accident · No injuriesClosedPiper PA-18 · Palmer, CASep 4, 1973 · N5994Z · Substantial damageNTSB ANC74DAG35Accident · Minor injuriesClosedPiper PA-28 · Rainy Pass, AKSep 4, 1973 · N1720J · Substantial damage