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

18 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, 1964, 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\") = 1964
    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 UNK65X1201Accident · No injuriesClosedPiper PA-24 · Apple Valley, CADec 31, 1964 · N6506P · Substantial damageNTSB UNK65X1064Accident · 2 fatalClosedPiper PA-24 · Huntington Lk, CADec 19, 1964 · N5552P · DestroyedNTSB UNK65X1063Accident · No injuriesClosedPiper PA24 · Santa Monica, CADec 19, 1964 · N6633P · Substantial damageNTSB UNK65X0450Accident · No injuriesClosedPiper PA24 · Elsinore, CAOct 27, 1964 · N8191P · Substantial damageNTSB UNK65X0370Accident · No injuriesClosedPiper PA24 · Santa Maria, CAOct 22, 1964 · N7621P · Substantial damageNTSB UNK65X0296Accident · No injuriesClosedPiper PA24 · San Jose, CAOct 16, 1964 · N7002P · Substantial damageNTSB UNK64X3709Accident · No injuriesClosedPiper PA24 · Napa, CAAug 31, 1964 · N7420P · Substantial damageNTSB UNK64X3636Accident · No injuriesClosedPiper PA24 · Los Angeles, CAAug 28, 1964 · N9191E · Substantial damageNTSB UNK64X2709Accident · No injuriesClosedPiper PA23 · Burbank, CAJul 8, 1964 · N5151Y · Substantial damageNTSB UNK64X2603Accident · No injuriesClosedPiper PA24 · Fullerton, CAJul 2, 1964 · N7213P · Substantial damageNTSB UNK64X2431Accident · No injuriesClosedPiper PA24 · Hoopa, CAJun 22, 1964 · N7989P · Substantial damageNTSB UNK64X2027Accident · No injuriesClosedPiper PA24 · National City, CAMay 30, 1964 · N8194P · Substantial damageNTSB UNK64X1994Accident · No injuriesClosedPiper PA24 · Torrance, CAMay 28, 1964 · N5757P · Substantial damageNTSB UNK64X1952Accident · No injuriesClosedPiper PA24 · San Carlos, CAMay 25, 1964 · N6518P · Substantial damageNTSB UNK64X1593Accident · No injuriesClosedPiper PA24 · Woodland, CAMay 3, 1964 · N5429P · Substantial damageNTSB UNK64X1273Accident · No injuriesClosedPiper PA24 · Santa Cruz, CAApr 12, 1964 · N5699P · Substantial damageNTSB UNK64X0946Accident · No injuriesClosedPiper PA-28 · Fresno, CAMar 15, 1964 · N8713W · Substantial damageNTSB UNK64X0519Accident · No injuriesClosedPiper PA-24 · Saugus, CAFeb 9, 1964 · N7250P · Substantial damage