NTSB investigations: Lycoming I0360 series, 1968

73 cases on aircraft whose registry engine model is Lycoming I0360 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 ('41515'))
  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 OAK69D0021Accident · Minor injuriesClosedMooney M20F · Lodi, CAMay 2, 1968 · N9613M · Substantial damageNTSB SEA68D0311Accident · No injuriesClosedHughes 269B · Tigard, ORApr 20, 1968 · N9477F · Substantial damageNTSB FTW68F0520Accident · Minor injuriesClosedMooney M20F · Many, LAApr 16, 1968 · N6361Q · Substantial damageNTSB NYC68F0456Accident · No injuriesClosedMooney M20E · Salem, NHApr 13, 1968 · N2555W · Substantial damageNTSB MKC68D0517Accident · No injuriesClosedBeech A23-24 · Leon, IAApr 12, 1968 · N7907L · Substantial damageNTSB OAK68F0333Accident · No injuriesClosedPiper PA-28 · Fair Oaks, CAApr 10, 1968 · N3905T · Substantial damageNTSB MKC68F0506Accident · No injuriesClosedHughes 269B · St Paul, MNMar 28, 1968 · N9487F · Substantial damageNTSB SEA68A0059Accident · No injuriesClosedHughes 269B · Walla Walla, WAMar 15, 1968 · N9332F · Substantial damageNTSB CHI68F0692Accident · No injuriesClosedMooney M20F · Oshkosh, WIMar 5, 1968 · N2907L · Substantial damageNTSB MKC68F0499Accident · No injuriesClosedMooney M20E · Thief R.Flls, MNMar 3, 1968 · N2639W · Substantial damageNTSB CHI68A0077Accident · Serious injuriesClosedHughes 269B · Sinking Spgs, OHFeb 27, 1968 · N9406F · DestroyedNTSB OAK68F0326Accident · No injuriesClosedTaylorcraft BC12-D · San Jose, CAFeb 25, 1968 · N43420 · 2 aircraft · Substantial damageNTSB CHI68D0624Accident · No injuriesClosedBeech A23-24 · Owensboro, KYFeb 25, 1968 · N3666Q · Substantial damageNTSB MIA68F0428Accident · No injuriesClosedMooney M20E · Gadsden, ALFeb 24, 1968 · N7197U · Substantial damageNTSB LAX68A0076Accident · No injuriesClosedHughes 269B · Hawain Grdn, CAFeb 23, 1968 · N9459F · Substantial damageNTSB DIA68F0177Accident · No injuriesClosedMooney M20F · Concord, NCFeb 18, 1968 · N2921L · Substantial damageNTSB FTW68A0077Accident · No injuriesClosedHughes 269A · San Antonio, TXFeb 17, 1968 · N8783F · Substantial damageNTSB MIA68F0472Accident · No injuriesClosedMooney M20C · Florence, SCFeb 16, 1968 · N6087Q · Substantial damageNTSB FTW68D0439Accident · No injuriesClosedMooney M20F · Webber Falls, OKFeb 4, 1968 · N3881N · Substantial damageNTSB MKC68F0414Accident · No injuriesClosedMooney M20E · Wichita, KSJan 28, 1968 · N2716W · Substantial damageNTSB MIA68A0065Accident · 2 fatalClosedBeech B95 · Marion, ALJan 28, 1968 · N9712Y · DestroyedNTSB DEN68A0034Accident · No injuriesClosedHughes 269B · Sundance, WYJan 26, 1968 · N9397F · Substantial damageNTSB SEA68A0049Accident · Minor injuriesClosedHughes 269B · Wyola, MTJan 18, 1968 · N9389F · Substantial damage