NTSB investigations: Lycoming O&VO-360 series, 1966, TX

14 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 per year

19642026
NTSB investigations: Lycoming O&VO-360 series, 1966, TX per year, 1964–2026: 349 cases
196414
196514
196614
196718
196814
19697
197012
19718
19729
19735
19747
19757
19767
197710
19789
19793
19807
19813
19829
19839
19844
19857
19864
19875
19884
19891
19901
19915
19924
19934
19945
19955
19963
19974
19983
19993
20004
20014
20023
20035
20044
20052
20063
20076
20085
20093
20103
20114
20122
20143
20153
20167
20173
20186
20193
20202
20217
20221
20238
20243
20252
20265

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\") = 1966
    AND c.\"eventStateOrRegion\" = 'TX' 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 FTW67D0355Accident · No injuriesClosedMooney M20A · Cumby, TXDec 4, 1966 · N6596B · Substantial damageNTSB FTW67D0342Accident · No injuriesClosedPiper PA-24 · Spearman, TXDec 2, 1966 · N6344P · Substantial damageNTSB FTW67D0329Accident · No injuriesClosedPiper PA-28 · Van Horn, TXNov 9, 1966 · N7391W · Substantial damageNTSB FTW67F0254Accident · Serious injuriesClosedPiper PA-28 · Granger, TXSep 19, 1966 · N7830W · Substantial damageNTSB FTW67D0149Accident · No injuriesClosedMooney M20C · La Porte, TXAug 7, 1966 · N6225U · Substantial damageNTSB FTW67F0169Accident · No injuriesClosedPiper PA-24 · Baytown, TXAug 5, 1966 · N5008P · Substantial damageNTSB FTW6MF0117Accident · No injuriesClosedMooney M20E · Odessa, TXJul 31, 1966 · N5758Q · Substantial damageNTSB FTW67D0116Accident · No injuriesClosedMooney M20C · Abilene, TXJul 31, 1966 · N6693U · Substantial damageNTSB FTW67F0166Accident · No injuriesClosedPiper PA-28 · Raymondville, TXJul 23, 1966 · N7827W · Substantial damageNTSB FTW6MF0103Accident · No injuriesClosedPiper PA-24 · Harlingen, TXJul 16, 1966 · N325C · Substantial damageNTSB FTW66F0672Accident · No injuriesClosedPiper PA-28 · Idalou, TXMay 16, 1966 · N6826W · Substantial damageNTSB FTW66F0524Accident · No injuriesClosedMooney M21 · Arlington, TXFeb 25, 1966 · N74736 · Substantial damageNTSB FTW66A0074Accident · No injuriesClosedPiper PA-24 · Lubbock, TXFeb 25, 1966 · N8328P · Substantial damageNTSB FTW66F0490Accident · No injuriesClosedPiper PA-24 · Alief, TXJan 9, 1966 · N6812P · Substantial damage