NTSB investigations: Lycoming 0-320 series, 1969, TX

33 cases on aircraft whose registry engine model is Lycoming 0-320 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 0-320 series, 1969, TX per year, 1964–2026: 916 cases
196428
196525
196630
196727
196834
196933
197030
197116
197224
197314
197420
197518
197626
197723
197823
197924
198019
198122
198225
198314
198411
198511
198613
19876
19887
19897
19908
199110
199211
199316
19944
19958
199613
199713
199810
199913
200011
20019
200217
200320
200414
200510
200614
20077
200813
200910
201011
201112
20127
20137
201410
201511
20168
20177
20186
20196
202013
20219
202211
202310
20249
20257
202611

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\") = 1969
    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 ('41508'))
  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 FTW70F0325Accident · No injuriesClosedPiper PA-28 · Wilderado, TXDec 2, 1969 · N5777F · Substantial damageNTSB FTW70F0316Accident · No injuriesClosedPiper PA-22 · Rockwall, TXNov 30, 1969 · N4544A · Substantial damageNTSB FTW70F0299Accident · No injuriesClosedPiper PA-23 · Plainview, TXNov 15, 1969 · N1065P · Substantial damageNTSB FTW70F0287Accident · No injuriesClosedPiper PA-28 · Pecos, TXNov 1, 1969 · N7309F · Substantial damageNTSB FTW70D0241Accident · No injuriesClosedPiper PA-22 · Pilot Point, TXSep 27, 1969 · N4443A · Substantial damageNTSB FTW70D0191Accident · No injuriesClosedBeech A23 · Dimmitt, TXAug 27, 1969 · N2309Q · Substantial damageNTSB FTW70D0131Accident · No injuriesClosedBeech A23-19 · Amarillo, TXAug 13, 1969 · N2385W · Substantial damageNTSB FTW70D0139Accident · Minor injuriesClosedPiper PA-22 · Freer, TXJul 27, 1969 · N9589D · Substantial damageNTSB FTW70D0128Accident · No injuriesClosedPiper PA-22 · Dickinson, TXJul 18, 1969 · N4803A · Substantial damageNTSB FTW70F0089Accident · Minor injuriesClosedCessna 177 · Matagorda Is., TXJul 4, 1969 · N3355T · Substantial damageNTSB FTW70D0036Accident · No injuriesClosedPiper PA-22 · Evant, TXJun 21, 1969 · N2721P · Substantial damageNTSB FTW70D0057Accident · No injuriesClosedPiper PA-18 · Sterling City, TXJun 19, 1969 · N3833Z · Substantial damageNTSB FTW69D0530Accident · No injuriesClosedPiper PA-28 · Slaton, TXJun 6, 1969 · N5552W · Substantial damageNTSB FTW70F0103Accident · Serious injuriesClosedCessna 177 · Mountain Home, TXJun 3, 1969 · N3339F · Substantial damageNTSB FTW70F0149Accident · No injuriesClosedCessna 177 · Mission Valey, TXJun 1, 1969 · N3256T · Substantial damageNTSB FTW70D0004Accident · No injuriesClosedPiper PA-28 · Vernon, TXMay 24, 1969 · N9629W · Substantial damageNTSB FTW69F0515Accident · No injuriesClosedPiper PA-18 · Presidio, TXMay 24, 1969 · N1850P · Substantial damageNTSB FTW70D0095Accident · No injuriesClosedPiper PA-28 · George West, TXMay 22, 1969 · N5161W · Substantial damageNTSB FTW69D0539Accident · No injuriesClosedPiper PA-18A · Sonora, TXMay 19, 1969 · N6983B · Substantial damageNTSB FTW69D0522Accident · No injuriesClosedBeech A23-19 · Plainview, TXMay 16, 1969 · N5952S · Substantial damageNTSB FTW70D0002Accident · No injuriesClosedCessna 172 · Smithfield, TXMay 13, 1969 · N78429 · Substantial damageNTSB FTW69D0520Accident · No injuriesClosedCallair A-5 · Littlefield, TXMay 3, 1969 · N2902G · Substantial damageNTSB FTW69D0511Accident · No injuriesClosedPiper PA-28 · Eldorado, TXApr 30, 1969 · N95160 · Substantial damageNTSB FTW69D0484Accident · No injuriesClosedPiper PA-28 · Abilene, TXApr 19, 1969 · N3530K · Substantial damageNTSB FTW69D0473Accident · No injuriesClosedCessna 172 · Burleson, TXApr 19, 1969 · N46263 · Substantial damageNTSB FTW70F0014Accident · No injuriesClosedPiper PA-18A · Bloomington, TXApr 13, 1969 · N2886P · Substantial damageNTSB FTW69D0438Accident · No injuriesClosedCessna 177 · Tomball, TXApr 6, 1969 · N29395 · Substantial damageNTSB FTW69F0471Accident · No injuriesClosedPiper PA-28 · San Antonio, TXMar 27, 1969 · N6555W · Substantial damageNTSB FTW69D0443Accident · No injuriesClosedPiper PA-22 · Sweetwater, TXMar 22, 1969 · N3454Z · Substantial damageNTSB FTW69D0475Accident · No injuriesClosedPiper PA-23 · Burnet, TXFeb 28, 1969 · N3273P · DestroyedNTSB FTW69D0379Accident · No injuriesClosedPiper PA-18 · Lubbock, TXFeb 3, 1969 · N2688P · Substantial damageNTSB FTW69F0335Accident · No injuriesClosedPiper PA-28 · Dallas, TXJan 8, 1969 · N6062W · Substantial damageNTSB FTW69F0367Accident · No injuriesClosedPiper PA-28 · Seminole, TXJan 5, 1969 · N6427R · Substantial damage