NTSB investigations: Lycoming 0-540 series, 1967, TX

26 cases on aircraft whose registry engine model is Lycoming 0-540 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-540 series, 1967, TX per year, 1964–2026: 302 cases
196410
196516
196614
196726
196813
196914
197012
197112
197210
19735
197410
19759
19767
197716
19785
19796
19809
19818
19827
19833
19841
19857
19863
19873
19882
19891
19903
19911
19921
19931
19943
19953
19962
19973
19983
19993
20002
20011
20026
20031
20043
20054
20063
20072
20082
20093
20102
20112
20123
20142
20152
20162
20181
20191
20202
20212
20222
20231
20251

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\") = 1967
    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 ('41532'))
  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 FTW68A0065Accident · 3 fatalClosedPiper PA-24 · Vashti, TXDec 27, 1967 · N7097P · DestroyedNTSB FTW68D0377Accident · No injuriesClosedPiper PA-23 · Andrews, TXNov 30, 1967 · N5032Y · Substantial damageNTSB FTW68D0426Accident · No injuriesClosedPiper PA-24 · Maude, TXNov 10, 1967 · N7811P · Substantial damageNTSB FTW68D0345Accident · Serious injuriesClosedPiper PA-32 · Del Rio, TXOct 29, 1967 · N3229W · Substantial damageNTSB FTW68F0295Accident · No injuriesClosedPiper PA-25 · Dumas, TXOct 13, 1967 · N6577Z · Substantial damageNTSB FTW68F0272Accident · No injuriesClosedPiper PA-24 · Mcniel, TXSep 9, 1967 · N5441P · Substantial damageNTSB FTW68F0233Accident · Minor injuriesClosedPiper PA-25 · Hereford, TXSep 6, 1967 · N7249Z · DestroyedNTSB FTW68D0198Accident · No injuriesClosedPiper PA-28 · Matador, TXSep 4, 1967 · N8759W · Substantial damageNTSB FTW68D0258Accident · No injuriesClosedPiper PA-25 · Dimmitt, TXSep 1, 1967 · N6564Z · Substantial damageNTSB FTW68D0168Accident · No injuriesClosedPiper PA-25 · Plainview, TXAug 18, 1967 · N6779Z · Substantial damageNTSB FTW68D0153Accident · No injuriesClosedPiper PA-24 · Stanton, TXAug 13, 1967 · N7961P · Substantial damageNTSB FTW68D0183Accident · No injuriesClosedPiper PA-25 · La Sara, TXAug 2, 1967 · N7184Z · Substantial damageNTSB FTW68F0120Accident · Serious injuriesClosedPiper PA-25 · Wharton, TXJul 24, 1967 · N7755Z · Substantial damageNTSB FTW68F0031Accident · No injuriesClosedPiper PA-24 · Rockwell, TXJul 9, 1967 · N5345P · Substantial damageNTSB FTW68D0110Accident · No injuriesClosedPiper PA-28 · Petersburg, TXJul 5, 1967 · N9269W · Substantial damageNTSB FTW68D0068Accident · No injuriesClosedCallair A-9 · Floydada, TXJul 5, 1967 · N7231V · Substantial damageNTSB FTW68F0084Accident · No injuriesClosedPiper PA-25 · Santa Rosa, TXJul 3, 1967 · N7368Z · Substantial damageNTSB FTW68D0025Accident · No injuriesClosedPiper PA-25 · Sunray, TXJun 17, 1967 · N6986Z · Substantial damageNTSB FTW68D0009Accident · No injuriesClosedPiper PA-28 · Ralls, TXJun 1, 1967 · N9244W · Substantial damageNTSB FTW68D0007Accident · No injuriesClosedPiper PA-32 · Shallowater, TXMay 31, 1967 · N3754W · Substantial damageNTSB FTW67D0602Accident · No injuriesClosedPiper PA-25 · Wharton, TXApr 26, 1967 · N6996Z · Substantial damageNTSB FTW67F0582Accident · No injuriesClosedPiper PA-24 · Luling, TXApr 23, 1967 · N6172P · Substantial damageNTSB FTW67D0560Accident · No injuriesClosedPiper PA-24 · Stamford, TXApr 16, 1967 · N5697P · Substantial damageNTSB FTW67F0536Accident · No injuriesClosedPiper PA-24 · Big Springs, TXApr 10, 1967 · N7562P · Substantial damageNTSB FTW67D0552Accident · Minor injuriesClosedPiper PA-25 · Spearman, TXApr 5, 1967 · N6440Z · Substantial damageNTSB FTW67F0434Accident · No injuriesClosedPiper PA-24 · Angleton, TXJan 26, 1967 · N7797P · Substantial damage