NTSB investigations: Lycoming O&VO-360 series, 1968, 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, 1968, 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\") = 1968
    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 FTW69D0332Accident · Minor injuriesClosedMooney M20D · Roaring Sprgs, TXDec 11, 1968 · N6917U · Substantial damageNTSB FTW69A0040Accident · 1 fatalClosedMooney M20 · Fort Mckavett, TXDec 8, 1968 · N7897V · DestroyedNTSB FTW69F0315Accident · No injuriesClosedPiper PA-24 · Lubbock, TXDec 4, 1968 · N8092P · Substantial damageNTSB FTW69D0304Accident · No injuriesClosedMooney M20A · Grand Prairie, TXNov 17, 1968 · N8325E · Substantial damageNTSB FTW69F0254Accident · No injuriesClosedPiper PA-28 · Shallowater, TXOct 13, 1968 · N6826W · Substantial damageNTSB FTW69A0020Accident · 2 fatalClosedPiper PA-28 · Gilmer, TXSep 29, 1968 · N9730J · DestroyedNTSB FTW69D0228Accident · No injuriesClosedPiper PA-28 · Mcallen, TXAug 31, 1968 · N6541J · Substantial damageNTSB FTW69D0107Accident · No injuriesClosedColonial C-2 · Kemp, TXAug 4, 1968 · N278B · Substantial damageNTSB FTW69F0095Accident · Minor injuriesClosedCessna 172 · Ainesville, TXJul 15, 1968 · N1323F · Substantial damageNTSB FTW69D0256Accident · No injuriesClosedPiper PA-28 · Granbury, TXJun 23, 1968 · N9033J · Substantial damageNTSB FTW69F0023Accident · No injuriesClosedMooney M20C · Austin, TXJun 4, 1968 · N606W · Substantial damageNTSB FTW68F0457Accident · No injuriesClosedPiper PA-22 · League City, TXMar 3, 1968 · N2939Z · Substantial damageNTSB FTW68D0471Accident · No injuriesClosedPiper PA-28 · Lubbock, TXFeb 27, 1968 · N8236W · Substantial damageNTSB FTW68F0437Accident · No injuriesClosedMooney M20C · Amarillo, TXJan 28, 1968 · N7700M · Substantial damage