NTSB investigations: Lycoming 0-540 series, 1971, 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, 1971, 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\") = 1971
    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 OAK72DVD27Accident · No injuriesClosedPiper PA-28 · Smith River, CANov 7, 1971 · N8660W · Substantial damageNTSB OAK72DVM08Accident · Minor injuriesClosedPiper PA-24 · San Carlos, CAOct 24, 1971 · N7994P · Substantial damageNTSB OAK72DVA33Accident · No injuriesClosedPiper PA-28 · Chouchilla, CAOct 3, 1971 · N8537N · Substantial damageNTSB OAK72DVD10Accident · No injuriesClosedPiper PA-24 · Novato, CASep 6, 1971 · N146U · Substantial damageNTSB OAK72DVA17Accident · No injuriesClosedPiper PA-25 · Modesto, CAAug 19, 1971 · N4440Y · Substantial damageNTSB LAX72AL008Accident · 1 fatalClosedPiper PA-28 · Santa Ynez, CAJul 30, 1971 · N9378W · Minor damageNTSB OAK72FXQ10Accident · No injuriesClosedPiper PA-24 · Chester, CAJul 24, 1971 · N5642P · Substantial damageNTSB LAX72DVA03Accident · Minor injuriesClosedCallair A-9 · Shafter, CAJul 17, 1971 · N7215V · Substantial damageNTSB OAK71DVA86Accident · No injuriesClosedPiper PA-24 · Visalia, CAJun 19, 1971 · N7852P · Substantial damageNTSB OAK71FVA71Accident · No injuriesClosedPiper PA-32 · Merced, CAMay 10, 1971 · N3343W · Substantial damageNTSB LAX71FUG83Accident · No injuriesClosedPiper PA-24 · Chino, CAMay 9, 1971 · N6229P · Substantial damageNTSB OAK71DVA69Accident · No injuriesClosedPiper PA-25 · Tulare, CAApr 20, 1971 · N7092Z · Substantial damageNTSB OAK71DVM39Accident · Minor injuriesClosedPiper PA-24 · San Jose, CAFeb 13, 1971 · N7994P · Substantial damageNTSB LAX71FUG39Accident · No injuriesClosedPiper PA-24 · Rialt0, CAJan 27, 1971 · N7786P · Substantial damage