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

14 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, 1968, 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\") = 1968
    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 OAK69D0199Accident · No injuriesClosedPiper PA-25 · Lemoore, CADec 11, 1968 · N6571Z · Substantial damageNTSB OAK69A0023Accident · 2 fatalClosedPiper PA-25 · Dixon, CAOct 24, 1968 · N4688Y · 2 aircraft · DestroyedNTSB OAK69D0141Accident · No injuriesClosedPiper PA-24 · San Jose, CAOct 6, 1968 · N7833P · Substantial damageNTSB OAK69D0148Accident · No injuriesClosedPiper PA-24 · Garberville, CASep 13, 1968 · N7365P · Substantial damageNTSB OAK69D0139Accident · Minor injuriesClosedPiper PA-24 · Bridgeport, CAAug 18, 1968 · N6512P · Substantial damageNTSB OAK69A0010Accident · No injuriesClosedCessna 150 · Hayward, CAAug 14, 1968 · N7819E · 2 aircraft · Substantial damageNTSB LAX69F0074Accident · 1 fatalClosedPiper PA-25 · San Luis Rey, CAJul 31, 1968 · N7412Z · DestroyedNTSB OAK69D0060Accident · No injuriesClosedPiper PA-25 · Lindsay, CAJul 13, 1968 · N4781Y · Substantial damageNTSB OAK69F0035Accident · No injuriesClosedPiper PA-32 · Sacramento, CAJun 21, 1968 · N3594W · Substantial damageNTSB OAK69F0017Accident · Minor injuriesClosedPiper PA-32 · Red Bluff, CAJun 6, 1968 · N3675W · Substantial damageNTSB OAK68F0375Accident · No injuriesClosedPiper PA-24 · Fresno, CAMay 11, 1968 · N7369P · Substantial damageNTSB OAK68D0357Accident · Minor injuriesClosedPiper PA-32 · Arcata, CAApr 13, 1968 · N3310W · DestroyedNTSB LAX68F0385Accident · No injuriesClosedPiper PA-28 · Santa Paula, CAMar 28, 1968 · N8555W · Substantial damageNTSB LAX68D0300Accident · No injuriesClosedPiper PA-28 · Imperial, CAJan 18, 1968 · N8576W · Substantial damage