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

10 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, 2009, 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\") = 2009
    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 WPR10FA068Accident · 2 fatalField investigationFinal reportSchleicher ASW-27 · Middletown, CAThe failure of both pilots to see and avoid the other airplane. Contributing to the accident was the pilot's failure to yield right of way to the glider.Nov 28, 2009 · N127AL · 2 aircraft · Substantial damageNTSB WPR10CA067Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Llano, CAThe pilot's inadequate compensation for the gusting crosswind conditions and failure to maintain lateral and directional control.Nov 27, 2009 · N9600P · Substantial damageNTSB WPR10CA193Accident · No injuriesData collectionFinal reportRobinson R44 · San Juan Batista, CAThe pilot's failure to maintain adequate clearance from wires while maneuvering and his subsequent improper use of the collective control, which resulted in the main rotor contacting the tail boom.Oct 29, 2009 · N144RF · Substantial damageNTSB WPR09LA436Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Torrance, CAA main rotor overspeed due to the pilot’s failure to maintain rotor RPM within allowable limits during a practice autorotation.Sep 3, 2009 · N8361X · Substantial damageNTSB WPR09LA204Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Los Angeles, CAThe pilot's inadequate compensation for the crosswinds and failure to maintain directional control during the landing roll.Apr 16, 2009 · N9219E · Substantial damageNTSB WPR09FA192Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Diego, CAThe pilot's failure to maintain control during an en route cruise descent through multiple cloud layers, resulting in an in-flight breakup.Apr 11, 2009 · N7690P · DestroyedNTSB WPR09LA169Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · San Carlos, CAA total loss of engine power during the initial climb for undetermined reasons.Mar 28, 2009 · N9249W · Substantial damageNTSB WPR09CA157Accident · No injuriesData collectionFinal reportPiper PA-24-250 · San Luis Obispo, CAThe pilot's inadequate compensation for the crosswinds during touchdown.Mar 17, 2009 · N8215P · Substantial damageNTSB WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.Mar 14, 2009 · N129AB · DestroyedNTSB WPR09LA139Accident · No injuriesLimited investigationFinal reportMaule M-5 · Calexico, CAA loss of engine power for undetermined reasons.Mar 3, 2009 · N9166E · Substantial damage