Fatal NTSB investigations: Lycoming IO-540 series, 2006

11 cases on aircraft whose registry engine model is Lycoming IO-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

19712026
Fatal NTSB investigations: Lycoming IO-540 series, 2006 per year, 1971–2026: 276 cases
19711
19782
19792
19812
19822
19833
19843
19855
19865
19871
19883
19893
19902
19912
19925
19934
19945
19955
19961
19976
19984
19997
20004
200110
200221
200312
200410
200511
200611
200711
200813
20097
201013
20118
20125
20134
20149
20155
20163
20177
20186
20199
20203
20213
20223
20237
20243
20252
20263

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\") = 2006
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
  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 CHI07FA046Accident · 2 fatalField investigationFinal reportRockwell International 114 · Jasper, TNThe pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…Dec 26, 2006 · N55MB · Substantial damageNTSB LAX07LA054Accident · 2 fatalLimited investigationFinal reportJohn Lauer Harmon Rocket II · Bakersfield, CAThe pilot's failure to maintain terrain clearance during an aerobatic maneuver.Dec 9, 2006 · N604JL · DestroyedNTSB ATL07FA010Accident · 2 fatalField investigationFinal reportCessna 182T · Rocky Mount, NCThe pilot's failure to maintain aircraft control.Oct 22, 2006 · N2135L · Substantial damageNTSB ATL06FA122Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Hartsville, SCThe pilot's loss of control of the airplane due to spatial disorientation.Aug 18, 2006 · N31911 · Substantial damageNTSB SEA06FA159Accident · 3 fatalField investigationFinal reportRobinson R44 II · Warrenton, ORThe pilot's intentional flight into instrument meteorological conditions while maneuvering which resulted in an in flight collision with terrain/water.Aug 13, 2006 · N168PT · DestroyedNTSB CHI06WA248Accident · 1 fatalForeign investigationBussey Express FT · Regina, SK, CanadaAug 4, 2006 · N554SB · DestroyedNTSB DFW06FA102Accident · 2 fatalField investigationFinal reportRobinson R44 II · Fredericksburg, TXThe pilot's failure to maintain clearance with the power lines. Contributing factors were the dusk light condition and the pilot's non-compliance with standard taxi and takeoff procedures.Apr 13, 2006 · N123CK · DestroyedNTSB LAX06LA141Accident · 1 fatalLimited investigationFinal reportVelocity XL-RG · Pearce, AZa departure from controlled flight for undetermined reasons, resulting in a collision with terrain.Apr 12, 2006 · N732RA · DestroyedNTSB ANC06LA029Accident · 1 fatalLimited investigationFinal reportCooper Harmon Rocket ll · McKittrick, CAThe pilot's failure to maintain altitude/clearance while performing intentional low altitude aerobatic flight maneuvers. Factors associated with the accident are the low altitude aerobatic flight maneuvers.Mar 25, 2006 · N96CR · DestroyedNTSB ATL06FA038Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Camden, ALThe pilots failure to maintain altitude and clearance during a visual descent which resulting in an in-flight collision with trees and the ground for undetermined reasons.Jan 28, 2006 · N38510 · DestroyedNTSB SEA06WA045Accident · 4 fatalForeign investigationEADS Socata TB-20 Trinidad · Bourdeau, FranceJan 16, 2006 · N250AG · Destroyed