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

152 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\") = 1968
    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 MKC69F0145Accident · No injuriesClosedMooney M20C · Park River, NDAug 9, 1968 · N6334Q · Substantial damageNTSB MKC69D0220Accident · Minor injuriesClosedMooney M20C · Gainesville, MOAug 9, 1968 · N5739Q · Substantial damageNTSB NYC69F0067Accident · Minor injuriesClosedPiper PA-28 · Honesdale, PAAug 4, 1968 · N5235L · DestroyedNTSB FTW69D0107Accident · No injuriesClosedColonial C-2 · Kemp, TXAug 4, 1968 · N278B · Substantial damageNTSB CHI69D0173Accident · No injuriesClosedPiper PA-28 · Northbrook, ILAug 4, 1968 · N4709L · Substantial damageNTSB NYC69F0103Accident · Minor injuriesClosedPiper PA-24 · Thomasville, PAAug 3, 1968 · N7373P · Substantial damageNTSB MIA69D0147Accident · No injuriesClosedPiper PA-28 · Summerton, SCAug 2, 1968 · N4920L · Substantial damageNTSB OAK69D0089Accident · Minor injuriesClosedPiper PA-28 · Del Rey, CAAug 1, 1968 · N8441W · Substantial damageNTSB NYC69A0014Accident · No injuriesClosedPiper PA-28 · East Hampton, CTAug 1, 1968 · N9311J · Substantial damageNTSB CHI69F0149Accident · No injuriesClosedMooney M20C · Connersville, INJul 30, 1968 · N9266M · Substantial damageNTSB CHI69F0231Accident · Minor injuriesClosedDyke Delta JD-2 · Rockford, ILJul 29, 1968 · N555A · Substantial damageNTSB MKC69D0064Accident · No injuriesClosedMooney M20D · Chamberlain, SDJul 28, 1968 · N1972Y · Substantial damageNTSB CHI69F0110Accident · No injuriesClosedPiper PA-28 · Hebron, KYJul 27, 1968 · N7326W · Substantial damageNTSB NYC69F0119Accident · No injuriesClosedCessna 170B · Lexington, NYJul 26, 1968 · N3228A · Substantial damageNTSB LAX69F0086Accident · Minor injuriesClosedHughes 269A · Marina Del Ray, CAJul 26, 1968 · N8812F · DestroyedNTSB SEA69F0047Accident · No injuriesClosedPiper PA-24 · Spokane, WAJul 23, 1968 · N6817P · Substantial damageNTSB MKC69F0050Accident · No injuriesClosedPiper PA-28 · Schuyler, NEJul 22, 1968 · N9458J · Substantial damageNTSB MIA69D0132Accident · No injuriesClosedPiper PA-28 · Chipley, FLJul 22, 1968 · N4710L · Substantial damageNTSB CHI69D0114Accident · No injuriesClosedPiper PA-24 · Trout Lake, MIJul 18, 1968 · N5486P · Substantial damageNTSB FTW69F0104Accident · Minor injuriesClosedMooney M20C · Lakeview, ARJul 16, 1968 · N6596U · Substantial damageNTSB NYC69D0081Accident · No injuriesClosedPiper PA-28 · Union, MEJul 15, 1968 · N7567W · Substantial damageNTSB FTW69F0095Accident · Minor injuriesClosedCessna 172 · Ainesville, TXJul 15, 1968 · N1323F · Substantial damageNTSB OAK69D0106Accident · No injuriesClosedCessna 177 · Black Springs, CAJul 14, 1968 · N29467 · Substantial damageNTSB LAX69F0129Accident · Serious injuriesClosedMooney M20C · Santa Susana, CAJul 14, 1968 · N3420X · Substantial damageNTSB DEN69F0045Accident · Serious injuriesClosedPiper PA-28 · Ordway, COJul 9, 1968 · N9529J · Substantial damageNTSB SEA69D0026Accident · No injuriesClosedPiper PA-28 · Chinook, MTJul 7, 1968 · N7557W · Substantial damageNTSB MKC69D0107Accident · No injuriesClosedPiper PA-28 · Hazen, NDJul 7, 1968 · N8994J · Substantial damageNTSB DEN69D0035Accident · No injuriesClosedMooney M20D · Ogden, UTJul 7, 1968 · N1962Y · Substantial damageNTSB NYC69F0076Accident · No injuriesClosedBrantly B-2B · Monroeville, PAJul 6, 1968 · N5948X · Substantial damageNTSB NYC69F0039Accident · No injuriesClosedPiper PA-28 · Butler, PAJul 6, 1968 · N5167L · Substantial damageNTSB CHI69F0051Accident · No injuriesClosedMooney M20D · Boscobel, WIJul 6, 1968 · N6913U · Substantial damageNTSB DIA69A0001Accident · 1 fatalClosedPiper PA-28 · Chase, MDJul 5, 1968 · N9399J · DestroyedNTSB DEN69D0042Accident · Minor injuriesClosedPiper PA-28 · Jackson, WYJul 5, 1968 · N5668W · Substantial damageNTSB LAX69F0017Accident · No injuriesClosedMooney M21 · Yorba Linda, CAJun 28, 1968 · N6743U · Substantial damageNTSB SEA69F0024Accident · No injuriesClosedHughes 269A · Medford, ORJun 23, 1968 · N8711F · Substantial damageNTSB FTW69D0256Accident · No injuriesClosedPiper PA-28 · Granbury, TXJun 23, 1968 · N9033J · Substantial damageNTSB OAK68A0074Accident · 5 fatalClosedMdoney M20A · Indian Sprngs, NVJun 20, 1968 · N1092B · 2 aircraft · DestroyedNTSB CHI69F0032Accident · No injuriesClosedPiper PA-28 · Rantoul, ILJun 20, 1968 · N5101G · Substantial damageNTSB SEA69D0028Accident · No injuriesClosedMooney M20C · Jefferson, ORJun 16, 1968 · N3487X · Substantial damageNTSB CHI68D0786Accident · No injuriesClosedPiper PA-28 · Milan, MIJun 15, 1968 · N4939L · Substantial damageNTSB SEA69F0025Accident · No injuriesClosedBrantly B-2 · Albany, ORJun 13, 1968 · N5963X · Substantial damageNTSB CHI68A0105Accident · No injuriesClosedPiper PA-28 · Michigan City, INJun 11, 1968 · N9561J · Substantial damageNTSB DEN69F0008Accident · No injuriesClosedPiper PA-25 · Montrose, COJun 7, 1968 · N6173Z · Substantial damageNTSB NYC69D0014Accident · No injuriesClosedGlobe GC-1B · Farmingdale, NYJun 5, 1968 · N2300B · Substantial damageNTSB MIA68A0102Accident · 2 fatalClosedMooney M20A · Orlando, FLJun 5, 1968 · N8372E · DestroyedNTSB FTW69F0023Accident · No injuriesClosedMooney M20C · Austin, TXJun 4, 1968 · N606W · Substantial damageNTSB CHI69F0009Accident · No injuriesClosedPiper PA-28 · Plymouth, MIJun 2, 1968 · N9371J · Substantial damageNTSB MKC69D0029Accident · No injuriesClosedMooney M20C · Grand Rapids, MNJun 1, 1968 · N5736Q · Substantial damageNTSB OAK69O0013Accident · No injuriesClosedPiper PA-28 · Mexicali, MexicoMay 25, 1968 · N9269J · Substantial damageNTSB OAK68D0382Accident · No injuriesClosedPiper PA-28 · Chico, CAMay 18, 1968 · N5166L · Substantial damage