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

16 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, 1971, 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\") = 1971
    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 FTW72DQG24Accident · No injuriesClosedPiper PA-28 · Follett, TXDec 4, 1971 · N4658R · Substantial damageNTSB FTW72FPD07Accident · No injuriesClosedHafe CH-1 · Mineral Wells, TXAug 31, 1971 · N86495 · Substantial damageNTSB FTW72FPA05Accident · No injuriesClosedPiper PA-25 · Rockwall, TXAug 31, 1971 · N6206Z · Substantial damageNTSB FTW72DQD05Accident · Minor injuriesClosedPiper PA-18A · Fabens, TXAug 12, 1971 · N3971P · Substantial damageNTSB FTW72FPD04Accident · Minor injuriesClosedVolaircraft 10A · Cleburne, TXJul 25, 1971 · N6666D · Substantial damageNTSB FTW72DQG10Accident · No injuriesClosedPiper PA-18A · Stratford, TXJul 24, 1971 · N4434Z · Substantial damageNTSB FTW72DPD03Accident · No injuriesClosedCessna 172 · Bridgeport, TXJun 21, 1971 · N46461 · Substantial damageNTSB FTW71DPD61Accident · No injuriesClosedPiper PA-28 · Denton, TXJun 12, 1971 · N5110G · Substantial damageNTSB FTW71DPA31Accident · No injuriesClosedPiper PA-28 · Sherman, TXMay 15, 1971 · N1750T · Substantial damageNTSB FTW71AF068Accident · No injuriesClosedCessna 150 · Dallas, TXApr 3, 1971 · N7213S · 2 aircraft · Substantial damageNTSB FTW71FPD46Accident · No injuriesClosedPiper PA-28 · Arlington, TXMar 26, 1971 · N1559J · Substantial damageNTSB FTW71DQG64Accident · No injuriesClosedPiper PA-28 · Union, TXMar 11, 1971 · N5722F · Substantial damageNTSB FTW71DPD40Accident · No injuriesClosedCessna 172L · Fort Worth, TXMar 6, 1971 · N7598G · Substantial damageNTSB FTW71FRG83Accident · No injuriesClosedCessna 172K · Corpus Chrsti, TXFeb 18, 1971 · N78487 · Substantial damageNTSB FTW71FRA34Accident · No injuriesClosedCessna 172K · Katy, TXJan 10, 1971 · N7210G · Substantial damageNTSB FTW71AF036Accident · 1 fatalClosedPiper PA-28 · Leakey, TXJan 2, 1971 · N5540W · Destroyed