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

67 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 c.\"eventStateOrRegion\" = 'TN' 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 ('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 MIA71DKW13Accident · No injuriesClosedPiper PA-28 · Crossville, TNSep 13, 1970 · N4905L · Substantial damageNTSB MIA69F0373Accident · No injuriesClosedPiper PA-24 · Dyersburg, TNMar 8, 1969 · N5568P · Substantial damageNTSB MIA69D0108Accident · No injuriesClosedPiper PA-24 · Chapel Hill, TNAug 11, 1968 · N7677P · Substantial damageNTSB MIA68F0521Accident · No injuriesClosedMooney M20G · Byrdstown, TNApr 26, 1968 · N3960N · Substantial damageNTSB MIA68F0404Accident · No injuriesClosedMooney M20C · Chattanooga, TNJan 22, 1968 · N79334 · Substantial damageNTSB MIA68F0271Accident · No injuriesClosedMooney M20D · Nashville, TNNov 26, 1967 · N6658U · Substantial damageNTSB MIA68F0154Accident · No injuriesClosedPiper PA-28 · Dayton, TNSep 2, 1967 · N7904W · Substantial damageNTSB MIA68F0023Accident · No injuriesClosedPiper PA-28 · Doyle, TNJul 2, 1967 · N9146J · Substantial damageNTSB MIA67D0555Accident · No injuriesClosedPiper PA-24 · Oak Ridge, TNMay 19, 1967 · N7598P · Substantial damageNTSB MIA67F0317Accident · No injuriesClosedMooney M20C · Nashville, TNDec 18, 1966 · N6075Q · Substantial damageNTSB MIA67F0166Accident · No injuriesClosedPiper PA-28 · Bristol, TNSep 2, 1966 · N7866W · Substantial damageNTSB MIA66F0522Accident · No injuriesClosedPiper PA-24 · Nashville, TNApr 29, 1966 · N8188P · Substantial damageNTSB MIA66D0290Accident · No injuriesClosedMooney M20B · Waverly, TNOct 29, 1965 · N74517 · Substantial damageNTSB MIA66D0302Accident · No injuriesClosedPiper PA-24 · Chattanooga, TNOct 24, 1965 · N6871P · Substantial damageNTSB UNK64X1895Accident · No injuriesClosedPiper PA28 · Madison, TNMay 23, 1964 · N7104W · Substantial damageNTSB UNK64X0861Accident · Minor injuriesClosedLake LA4 · Knoxville, TNMar 9, 1964 · N1118L · Substantial damageNTSB UNK64X0597Accident · No injuriesClosedPiper PA28 · Chattanooga, TNFeb 17, 1964 · N7422W · Substantial damage