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

24 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, 1972, 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\") = 1972
    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 FTW73DRA14Accident · No injuriesClosedCessna 177 · Tomball, TXDec 31, 1972 · N29434 · Substantial damageNTSB FTW73FRA13Accident · No injuriesClosedPiper PA-28 · Bellville, TXDec 27, 1972 · N4119J · Substantial damageNTSB FTW73DQG26Accident · Serious injuriesClosedPiper PA-22 · Amarillo, TXDec 25, 1972 · N7835D · No damageNTSB FTW73DRJ23Accident · No injuriesClosedPiper PA-28 · Hallsville, TXDec 6, 1972 · N1750T · Substantial damageNTSB FTW73AF016Accident · No injuriesClosedPiper PA-18 · Friendswood, TXNov 5, 1972 · N4612Y · 2 aircraft · Minor damageNTSB FTW73FRA10Accident · No injuriesClosedPiper PA-28 · Friendswood, TXSep 7, 1972 · N6380R · Substantial damageNTSB FTW73FRJ13Accident · No injuriesClosedCessna 172L · Garrison, TXSep 6, 1972 · N19719 · Substantial damageNTSB FTW73FQD08Accident · Serious injuriesClosedPiper PA-18 · Canutillo, TXSep 1, 1972 · N4335Z · Substantial damageNTSB FTW73DQG14Accident · No injuriesClosedPiper PA-25 · Shallowater, TXAug 19, 1972 · N6098Z · Substantial damageNTSB FTW73FPA09Accident · No injuriesClosedPiper PA-28 · Dallas, TXAug 9, 1972 · N6700J · Substantial damageNTSB FTW73FPA06Accident · No injuriesClosedBeech B23 · Waxahachie, TXJul 29, 1972 · N2377Q · Substantial damageNTSB FTW73FRG03Accident · Serious injuriesClosedPiper PA-18 · Portland, TXJul 19, 1972 · N4342Z · Substantial damageNTSB FTW73DRA04Accident · No injuriesClosedCessna 177 · Bay City, TXJul 16, 1972 · N30139 · Substantial damageNTSB FTW72FRA58Accident · Minor injuriesClosedPiper PA-28 · Arcola, TXMay 14, 1972 · N98314 · Substantial damageNTSB FTW72DRG79Accident · Serious injuriesClosedPiper PA-18 · Pleasanton, TXApr 30, 1972 · N9266D · Substantial damageNTSB FTW72AF069Accident · Minor injuriesClosedPiper PA-28 · Dallas, TXApr 17, 1972 · N1512J · 2 aircraft · Substantial damageNTSB FTW72FRA51Accident · No injuriesClosedPiper PA-28 · League City, TXApr 14, 1972 · N7132R · Substantial damageNTSB FTW72FPA20Accident · No injuriesClosedPiper PA-28 · Sherman, TXApr 13, 1972 · N5749F · Substantial damageNTSB FTW72FRA49Accident · Minor injuriesClosedPiper PA-28 · Kennard, TXApr 2, 1972 · N6007U · Substantial damageNTSB FTW72FPA16Accident · Minor injuriesClosedPiper PA-22 · Hillsboro, TXFeb 27, 1972 · N3465Z · DestroyedNTSB FTW72FQG72Accident · No injuriesClosedCessna 177 · Tulia, TXFeb 24, 1972 · N29302 · Substantial damageNTSB FTW72FPA15Accident · No injuriesClosedPiper PA-22 · Corsicana, TXFeb 20, 1972 · N3941P · Substantial damageNTSB FTW72FQG30Accident · No injuriesClosedPiper PA-18A · Friona, TXFeb 15, 1972 · N7496D · Substantial damageNTSB FTW72FRA38Accident · 1 fatalClosedCessna 172K · Sugar Land, TXFeb 4, 1972 · N46377 · Minor damage