NTSB investigations: Lycoming 0-540 series, 1966, CA

25 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, 1966, CA per year, 1964–2026: 353 cases
196418
196513
196625
196712
196814
19697
19705
197114
19727
19739
19748
197510
197610
19779
197810
197910
19807
19815
19824
19834
19845
19857
19862
19874
19887
19897
19905
19913
19925
19934
19945
19951
199610
19973
19985
19992
20002
20016
20024
20031
20042
20058
20063
20073
20083
200910
20105
20113
20122
20131
20145
20151
20161
20171
20182
20192
20212
20222
20231
20242
20254
20261

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\") = 1966
    AND c.\"eventStateOrRegion\" = 'CA' 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 OAK67A0053Accident · Minor injuriesClosedPiper PA-32 · Cloverdale, CADec 19, 1966 · N3675W · Substantial damageNTSB LAX67D0249Accident · No injuriesClosedHelio H-250 · New Cuyama, CADec 13, 1966 · N5444E · Substantial damageNTSB OAK67D0155Accident · No injuriesClosedPiper PA-24 · Resno, CANov 9, 1966 · N7736P · Substantial damageNTSB LAX66F0159Accident · No injuriesClosedPiper PA-24 · Blythe, CAOct 15, 1966 · N7999P · Substantial damageNTSB LAX67D0136Accident · No injuriesClosedPiper PA-24 · Lancaster, CASep 21, 1966 · N7161P · Substantial damageNTSB OAK67D0113Accident · No injuriesClosedPiper PA-23 · Fresno, CASep 20, 1966 · N4631P · Substantial damageNTSB LAX67F0151Accident · No injuriesClosedPiper PA-24 · Palm Springs, CASep 19, 1966 · N6496P · Substantial damageNTSB LAX67D0134Accident · No injuriesClosedPiper PA-24 · El Monte, CASep 17, 1966 · N5943P · Substantial damageNTSB OAK67D0182Accident · No injuriesClosedPiper PA-23 · Arcata, CASep 6, 1966 · N4541P · Substantial damageNTSB OAK67F0094Accident · Minor injuriesClosedPiper PA-28 · Petaluma, CAAug 27, 1966 · N8606W · Substantial damageNTSB LAX67D0128Accident · No injuriesClosedPiper PA-32 · Oildale, CAAug 27, 1966 · N3630W · Substantial damageNTSB LAX67D0111Accident · No injuriesClosedPiper PA-23 · Oceanside, CAAug 25, 1966 · N4508P · Substantial damageNTSB OAK67D0051Accident · No injuriesClosedPiper PA-25 · Huron, CAAug 4, 1966 · N7176Z · Substantial damageNTSB LAX67F0094Accident · No injuriesClosedAero Cmdr 500 · Van Nuys, CAJul 31, 1966 · N8459C · Substantial damageNTSB LAX67F0065Accident · Minor injuriesClosedPiper PA-32 · Walteria Sta., CAJul 22, 1966 · N3403W · Substantial damageNTSB OAK67D0063Accident · No injuriesClosedPiper PA-24 · San Francisco, CAJul 21, 1966 · N7005P · Substantial damageNTSB LAX66A0101Accident · 6 fatalClosedPiper PA-32 · Guadalupe, CAJun 16, 1966 · N3531W · DestroyedNTSB LAX67F0012Accident · No injuriesClosedPiper PA-24 · Los Angeles, CAMay 23, 1966 · N6186P · Substantial damageNTSB OAK67D0005Accident · No injuriesClosedPiper PA-24 · Palo Alto, CAMay 22, 1966 · N7833P · Substantial damageNTSB LAX66F0339Accident · No injuriesClosedPiper PA-24 · Palm Springs, CAApr 23, 1966 · N7838P · Substantial damageNTSB LAX66D0298Accident · No injuriesClosedFpiper PA-24 · Palm Springs, CAMar 15, 1966 · N7025P · Substantial damageNTSB OAK66D0250Accident · No injuriesClosedPiper PA-24 · Mammoth Lakes, CAMar 11, 1966 · N7730P · Substantial damageNTSB LAX66D0268Accident · No injuriesClosedPiper PA-28 · Hawthorne, CAMar 11, 1966 · N8900W · Substantial damageNTSB LAX66D0260Accident · No injuriesClosedPiper PA-24 · Van Nuys, CAMar 3, 1966 · N5423P · Substantial damageNTSB LAX66F0276Accident · No injuriesClosedAero Comdr 500 · Palm Sprngs, CAFeb 20, 1966 · N8459C · Substantial damage