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

4 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, 1983, 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\") = 1983
    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 LAX84FA118Accident · No injuriesField investigationFinal reportPiper PA28-235 · Irwindale, CAAccording to the flt instr the eng lost pwr after the stu had completd varous turning maneuvers. He stated that the fuel sel was in the left main position and estimated that there were 18 gals in that tank, 25 gals in the right tank,5 gals in the left tip…Dec 28, 1983 · N55665 · Substantial damageNTSB LAX84FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Holtville, CAThe plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time…Dec 2, 1983 · N3206W · DestroyedNTSB LAX83LA421Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Clearlake, CADuring arrival, the plt made an apch to rwy 30 at night in calm wind conditions. He reported that on final apch, he allowed the airspeed to get low & the acft stalled and struck the ground approximately 300 feet short of the rwy. The rwy was equipped with…Sep 4, 1983 · N252EZ · DestroyedNTSB LAX83LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · El Cajon, CAShortly after takeoff, at an altitude of aprx 300 ft AGL, the eng lost power. The plt turned & landed wheels-up on an unimproved grass area on the southwest corner of the arpt. An exam of the eng & fuel systems revealed no evidence of a preimpact/mechanical…Jan 15, 1983 · N5730P · Substantial damage