NTSB investigations: Lycoming O&VO-360 series, 1964, 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, 1964, 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\") = 1964
    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 UNK65X1151Accident · No injuriesClosedMooney M20C · El Paso, TXDec 27, 1964 · N6876U · Substantial damageNTSB UNK65X0233Accident · No injuriesClosedMooney M20A · Ft Worth, TXOct 11, 1964 · N6587B · Substantial damageNTSB UNK65X0185Accident · No injuriesClosedMooney M20C · Sugarland, TXOct 7, 1964 · N6416U · Substantial damageNTSB UNK64X3852Accident · No injuriesClosedLake LA4 · Lake Texhoma, TXSep 7, 1964 · N1118L · Substantial damageNTSB UNK64X3261Accident · Serious injuriesClosedMooney M20D · Fort Worth, TXAug 7, 1964 · N6741U · Substantial damageNTSB UNK64X3223Accident · No injuriesClosedMooney MK20D · Amarillo, TXAug 5, 1964 · N6917U · Substantial damageNTSB UNK64X2527Accident · 1 fatalClosedPiper PA18A · Sinton, TXJun 27, 1964 · N7797B · DestroyedNTSB UNK64X2390Accident · No injuriesClosedMooney M20D · Houston, TXJun 20, 1964 · N1227X · Substantial damageNTSB UNK64X2354Accident · No injuriesClosedBeechcraft 95 · Dallas, TXJun 18, 1964 · N2732Y · Substantial damageNTSB UNK64X2202Accident · No injuriesClosedPiper PA24 · Dimmitt, TXJun 9, 1964 · N5656P · Substantial damageNTSB UNK64X1760Accident · No injuriesClosedMooney M21 · Port Lavaca, TXMay 14, 1964 · N6225U · Substantial damageNTSB UNK64X1596Accident · No injuriesClosedMooney M21 · Houston, TXMay 3, 1964 · N6213U · Substantial damageNTSB UNK64X0897Accident · No injuriesClosedHughes 269A · Bandera, TXMar 13, 1964 · N8791F · Substantial damageNTSB UNK64X0587Accident · No injuriesClosedPiper PA28 · Corpus Christ, TXFeb 16, 1964 · N7451W · Substantial damage