Fatal NTSB investigations: Lycoming 0-540 series, 2006

11 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
Fatal NTSB investigations: Lycoming 0-540 series, 2006 per year, 1964–2026: 407 cases
19645
19654
19662
19677
19687
19696
197010
19713
19725
19732
19744
19753
19764
19777
19788
19798
198011
19818
198212
19838
19847
198512
19865
19877
19886
19899
19905
19917
19927
19936
19948
19957
19965
19974
19988
19991
20006
20019
20027
200310
200410
20058
200611
20077
20087
200910
20108
201111
20125
20132
20143
20154
20162
20176
20185
20195
20206
202110
20228
20238
20241
20254
20266

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 ('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 NYC07FA052Accident · 4 fatalField investigationFinal reportCessna TR182 · Charlotte, NCThe pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.Dec 31, 2006 · N7090S · DestroyedNTSB CHI07FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Wellington, ILSpatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…Nov 20, 2006 · N8990W · DestroyedNTSB CHI06LA223Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Underwood, NDThe pilot's failure to maintain clearance with the power line during the aerial application flight.Aug 3, 2006 · N4693Y · Substantial damageNTSB ATL06FA102Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Suches, GAThe pilot's failure to retract the wing flaps and his decision to make a turn while performing a go-around.Jul 8, 2006 · N3380W · DestroyedNTSB ANC06FA089Accident · 1 fatalField investigationFinal reportPiper PA-28 · Manley Hot Spng, AKThe pilot's continued cruise flight into known adverse weather conditions, his failure to maintain aircraft control while maneuvering, and his exceeding the design stress limits of the airplane, which resulted in an in-flight break-up. Factors associated with…Jul 6, 2006 · N9026W · DestroyedNTSB ATL06LA094Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Wilkesboro, NCThe pilot's improper fuel consumption calculations and improper in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion, a forced landing, and collision with terrain.Jun 20, 2006 · N5626P · Substantial damageNTSB NYC06FA133Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Manahawkin, NJThe noninstrument-rated pilot's inadvertent VFR cruise flight into instrument meteorological conditions, and his subsequent loss of aircraft control, which resulted in his exeeding the design stress limits of the airplane, and an in-flight separation of the…May 31, 2006 · N48ED · Substantial damageNTSB MIA06LA106Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Caribbean SeaThe failure of the pilot to maintain control of the airplane. A contributing factor in the accident was the spatial disorientation of the pilot, resulting in the in-flight loss of control.May 10, 2006 · N5033Y · DestroyedNTSB SEA06LA052Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Helena, MTThe pilot's intentional suicide. The unauthorized use of a helicopter and impairment by alcohol were factors.Feb 6, 2006 · N7085U · DestroyedNTSB LAX06FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Mammoth Lakes, CAthe pilot's failure to maintain an adequate airspeed resulting in a stall/spin.Jan 8, 2006 · N9124W · DestroyedNTSB MIA06FA039Accident · 3 fatalField investigationFinal reportRobinson R44 · Grand Ridge, FLThe pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.Jan 2, 2006 · N442DH · Destroyed