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

30 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, 1970, 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\") = 1970
    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 FTW71FPD33Accident · No injuriesClosedPiper PA-28 · Springtown, TXDec 6, 1970 · N8353R · Substantial damageNTSB FTW71DRA31Accident · No injuriesClosedPiper PA-28 · Tomball, TXNov 22, 1970 · N95347 · Substantial damageNTSB FTW71FRG50Accident · No injuriesClosedCessna 172L · San Antonio, TXNov 17, 1970 · N7654G · Substantial damageNTSB FTW71FPA12Accident · No injuriesClosedPiper PA-23 · Plano, TXNov 16, 1970 · N20A · 2 aircraft · Substantial damageNTSB FTW71FPD24Accident · No injuriesClosedCessna 177 · Abilene, TXOct 30, 1970 · N2985X · Substantial damageNTSB FTW71FRA24Accident · No injuriesClosedPiper PA-18 · Conroe, TXOct 25, 1970 · N3996Z · Substantial damageNTSB FTW71FRG36Accident · No injuriesClosedPiper PA-28 · Corpus Chrsti, TXOct 18, 1970 · N4251J · Substantial damageNTSB FTW71FPD20Accident · No injuriesClosedPiper PA-28 · Saginaw, TXSep 18, 1970 · N8197N · Substantial damageNTSB FTW71FQD12Accident · No injuriesClosedPiper PA-28 · Fabens, TXAug 31, 1970 · N98222 · Substantial damageNTSB FTW71FPD18Accident · No injuriesClosedCessna 172 · Arlington, TXAug 31, 1970 · N78623 · Substantial damageNTSB FTW71DQG27Accident · No injuriesClosedCessna 172 · Memphis, TXAug 16, 1970 · N7209G · Substantial damageNTSB FTW71DPD13Accident · No injuriesClosedCessna 177 · Iowa Park, TXAug 12, 1970 · N2963X · Substantial damageNTSB FTW71DRG15Accident · No injuriesClosedPiper PA-22 · Jourdanton, TXAug 10, 1970 · N9596D · Substantial damageNTSB FTW71FRA11Accident · Minor injuriesClosedPiper PA-28 · Humble, TXAug 2, 1970 · N7234J · Substantial damageNTSB FTW71FPD08Accident · No injuriesClosedPiper PA-28 · Denton, TXAug 1, 1970 · N4122J · Substantial damageNTSB FTW71DQG23Accident · No injuriesClosedCessna 172I · Childress, TXJul 14, 1970 · N35436 · Substantial damageNTSB FTW71DQG01Accident · No injuriesClosedCessna 172K · Sterling City, TXJul 4, 1970 · N79139 · Substantial damageNTSB FTW71FRG02Accident · Serious injuriesClosedPiper PA-22 · Sabinal, TXJul 3, 1970 · N9768D · Substantial damageNTSB FTW71FRA04Accident · No injuriesClosedBeech 23 · Eagle Lake, TXJul 3, 1970 · N2385J · Substantial damageNTSB FTW71DQG03Accident · Minor injuriesClosedChampion 7GCA · Slaton, TXJun 18, 1970 · N9529S · Substantial damageNTSB FTW70DRG50Incident · No injuriesClosedPiper PA-18A · Sinton, TXJun 2, 1970 · N3479Z · Minor damageNTSB FTW70AF077Accident · No injuriesClosedGen Dynamic F-102A · La Porte, TXMay 25, 1970 · ANG61044 · 2 aircraft · Minor damageNTSB FTW70DQG15Accident · No injuriesClosedPiper PA-28 · Sterling City, TXMay 16, 1970 · N6756J · Substantial damageNTSB FTW70FPD09Accident · No injuriesClosedPiper PA-22 · Mansfield, TXMay 10, 1970 · N8436D · Substantial damageNTSB FTW70DRJ09Accident · No injuriesClosedPiper PA-28 · Lufkin, TXMay 4, 1970 · N6933W · Substantial damageNTSB FTW70FRG33Accident · No injuriesClosedMorrisey 2150 · San Antonio, TXApr 11, 1970 · N5101V · Substantial damageNTSB FTW70FQD06Accident · No injuriesClosedPiper PA-18A · El Paso, TXFeb 25, 1970 · N7669D · Substantial damageNTSB FTW70DRG12Accident · No injuriesClosedCessna 177 · Randolph Afb, TXFeb 21, 1970 · N3255T · DestroyedNTSB FTW70FRA04Accident · No injuriesClosedPiper PA-28 · Houston, TXJan 31, 1970 · N1092T · Substantial damageNTSB FTW70FRA01Accident · Minor injuriesClosedCessna 177 · Beaumont, TXJan 1, 1970 · N3122T · Substantial damage