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

14 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, 1973, 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\") = 1973
    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 FTW74DRG39Accident · No injuriesClosedCessna 172 · Austin, TXDec 4, 1973 · N84148 · Substantial damageNTSB FTW74DRA19Accident · No injuriesClosedPiper PA-28 · Angleton, TXNov 3, 1973 · N6380R · Substantial damageNTSB FTW74FRA10Accident · No injuriesClosedPiper PA-22 · Friendswood, TXAug 8, 1973 · N3963P · Substantial damageNTSB FTW74DPD14Accident · No injuriesClosedHiller Acft UH-12A · Springtown, TXJul 22, 1973 · N8145H · Substantial damageNTSB FTW74FQG01Accident · Serious injuriesClosedPiper PA-18A · Plainview, TXJul 20, 1973 · N7478D · DestroyedNTSB FTW74DQG45Accident · No injuriesClosedCessna 172 · Childress, TXJun 27, 1973 · N35664 · Substantial damageNTSB FTW73DRA40Accident · No injuriesClosedPiper PA-18A · Ganado, TXJun 27, 1973 · N1874A · Substantial damageNTSB FTW73DPD44Accident · No injuriesClosedPiper PA-22 · Stamford, TXJun 1, 1973 · N8543D · Substantial damageNTSB FTW73DPD35Accident · No injuriesClosedPiper PA-28 · Gainesville, TXMay 18, 1973 · N15955 · Substantial damageNTSB FTW73FQG36Accident · Minor injuriesClosedPiper PA-22 · Lubbock, TXApr 22, 1973 · N3917P · Substantial damageNTSB FTW73DQG38Accident · Minor injuriesClosedCessna 172K · Follett, TXApr 18, 1973 · N78587 · Substantial damageNTSB FTW73DRG60Accident · Minor injuriesClosedPiper PA-28 · Kileen, TXMar 25, 1973 · N1726T · Substantial damageNTSB FTW73FPD24Accident · No injuriesClosedPiper PA-28 · Meridian, TXMar 11, 1973 · N5834U · Substantial damageNTSB FTW73DRA15Accident · No injuriesClosedPiper PA-23 · Lagrange, TXJan 20, 1973 · N64K · Substantial damage