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

19 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, 1980, 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\") = 1980
    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 FTW81FRG13Accident · No injuriesClosedCessna 172N · Laredo, TXDec 21, 1980 · N4903F · Substantial damageNTSB FTW81FPD03Accident · Serious injuriesClosedHughes 269A · Newport, TXNov 9, 1980 · N8825F · Substantial damageNTSB FTW80DQD04Accident · No injuriesClosedPiper PA-18 · Tornillo, TXOct 18, 1980 · N9796P · Substantial damageNTSB FTW80FRG75Accident · No injuriesClosedCessna 172 · New Braunfels, TXSep 20, 1980 · N70386 · Substantial damageNTSB FTW81FPA18Accident · No injuriesClosedBeech B19 · Dallas, TXAug 31, 1980 · N24006 · Substantial damageNTSB FTW80FRG67Accident · No injuriesClosedCessna 150 · Mcallen, TXAug 27, 1980 · N2969J · Substantial damageNTSB FTW80FA099Accident · 2 fatalClosedCessna 172M · Bridgeport, TXAug 6, 1980 · N9855Q · 2 aircraft · DestroyedNTSB FTW80FRG52Accident · No injuriesClosedPiper PA-22 · Pipecreek, TXJun 28, 1980 · N4443A · Substantial damageNTSB FTW80DQD11Accident · No injuriesClosedPiper PA-18 · Tornillo, TXJun 18, 1980 · N9929P · Substantial damageNTSB FTW80FQG21Accident · No injuriesClosedBeech B19 · Lubbock, TXMay 26, 1980 · N6572R · Substantial damageNTSB FTW80DRJ18Accident · No injuriesClosedAero-Comdr 100 · Mt.Pleasant, TXMay 5, 1980 · N3795X · Substantial damageNTSB FTW80DPD26Accident · No injuriesClosedPiper PA-28 · Frisco, TXApr 28, 1980 · N9371K · Substantial damageNTSB FTW80DQD06Accident · No injuriesClosedCessna 172 · Dell City, TXApr 18, 1980 · N7124G · Substantial damageNTSB FTW80FA059Accident · 4 fatalClosedCessna 172B · Tomball, TXApr 6, 1980 · N13374 · DestroyedNTSB FTW80DPD16Accident · No injuriesClosedPiper PA-28 · Stamford, TXMar 2, 1980 · N8723N · Substantial damageNTSB FTW80DPD09Accident · No injuriesClosedHughes 269A · Ringo, TXFeb 3, 1980 · N8825F · Substantial damageNTSB FTW80DRJ10Accident · No injuriesClosedCessna 172 · Milam, TXJan 27, 1980 · N4338Q · Substantial damageNTSB FTW80DRG21Accident · No injuriesClosedBeech B19 · George West, TXJan 19, 1980 · N18956 · Substantial damageNTSB FTW80DQG09Accident · No injuriesClosedPiper PA-28 · Wink, TXJan 12, 1980 · N4329T · Substantial damage