Fatal NTSB investigations: Lycoming TI0-540 series, 2004

16 cases on aircraft whose registry engine model is Lycoming TI0-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 TI0-540 series, 2004 per year, 1964–2026: 467 cases
19641
19663
19685
19693
19701
19714
19726
19731
19741
19754
19765
19776
197814
197912
198016
198113
198215
198313
19849
19857
19869
198710
19886
19898
19902
19918
19926
19938
19948
19953
19967
19972
19986
19996
20006
200114
200217
200312
200416
200512
200613
20077
200811
200910
20109
20118
201214
20137
201412
201510
20165
20174
20187
20196
20207
20216
20227
20239
20241
20253
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\") = 2004
    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 ('41533'))
  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 NYC05FA028Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Vandalia, OHThe pilot's failure to maintain adequate altitude\clearance while on approach, which resulted in an in-flight collision with trees. Factors in the accident were the fog and low ceiling conditions.Dec 7, 2004 · N54316 · DestroyedNTSB DFW05FA020Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · San Antonio, TXThe pilot's failure to maintain control during an ILS approach. Contributing factors were the prevailing instrument meteorological conditions( clouds, low ceiling and drizzle/mist), and the pilot's spatial disorientation.Nov 14, 2004 · N40731 · DestroyedNTSB ATL04LA177Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Lake Wales, FLThe pilot's inadequate preflight planning and preparation, and his inadequate visual lookout, which resulted in a collision with a television tower.Sep 11, 2004 · N962AB · Substantial damageNTSB FTW04FA235Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Rachel, TXThe total failure of the vacuum pump that resulted in an inoperative attitude gyro and spatial disorientation and a subsequent loss of aircraft control by the pilot. Factors were; the prevailing instrument meteorological conditions, and the dark night light…Sep 9, 2004 · N6209J · DestroyedNTSB FTW04FA208Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Burnet, TXThe pilot's continued flight into known adverse weather, VFR flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. A contributing factor was the cloudy weather.Aug 7, 2004 · N927RP · DestroyedNTSB FTW04FA204Accident · 6 fatalField investigationFinal reportPiper PA-60-601P · Lakeway, TXThe pilot's failure to successfully perform a short-field takeoff and his subsequent failure to maintain adequate airspeed during climbout, which resulted in an aerodynamic stall.Aug 3, 2004 · N601BV · DestroyedNTSB CHI04FA205Accident · 5 fatalField investigationFinal reportPiper PA-32-300 · Point Lookout, MOThe pilot's failure attain adequate flying speed and his delay in aborting the takeoff which resulted in premature liftoff and an overrun of the runway. Contributing factors were the descending embankment, trees and ravine.Aug 2, 2004 · N4230R · DestroyedNTSB NYC04FA170Accident · 5 fatalField investigationFinal reportPiper PA-32R-301T · Wheeling, WVThe pilot's failure to maintain terrain clearance while executing an instrument approach. A factor was the night instrument meteorological conditions.Jul 19, 2004 · N7710M · DestroyedNTSB IAD04FA030Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ticonderoga, NYReason for occurrence undetermined.Jul 10, 2004 · N45032 · DestroyedNTSB FTW04FA172Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hot Springs, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with mountainous terrain. Factors were the clouds and the air traffic controllers' failure to provide known information that may have assisted the…Jul 2, 2004 · N4123R · Substantial damageNTSB MIA04FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Baker, FLThe flight crew's inadvertent flight into thunderstorms resulting in the design limits of the airplane being exceeded, loss of aircraft control and subsequent in-flight breakup. A factor in the accident was the lack of required advisory by ATC about a radar…Jun 21, 2004 · N54134 · DestroyedNTSB CHI04GA130Accident · 1 fatalFinal reportCessna T206H · Homer Glen, ILThe seized turbocharger, the altitude/clearance not maintained/obtained during approach to a forced landing on an agricultural field, and the unsuitable landing area encountered by the pilot. Contributing factors were the inadequate emergency procedures by…May 28, 2004 · N9548D · DestroyedNTSB ATL04FA107Accident · 2 fatalField investigationFinal reportMooney M20M · Cary, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with trees. Factors were low ceilings and fog.May 3, 2004 · N91514 · Substantial damageNTSB ATL04FA090Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Johns Island, SCThe pilot's failure to maintain airspeed during emergency descent, which resulted in an inadvertent stall/spin and uncontrolled descent into trees and terrain. A factor was the loss of engine power in one engine due to pre-ignition/detonation.Apr 5, 2004 · N869CC · Substantial damageNTSB LAX04FA177Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Ukiah, CAThe non-instrument rated pilot's flight intentional flight into instrument meteorological conditions during takeoff-initial climb, which resulted in spatial disorientation, a subsequent loss of aircraft control, and an uncontrolled descent into terrain. A…Apr 4, 2004 · N4130D · DestroyedNTSB LAX04FA102Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Big Pine, CAfailure of the pilot to maintain clearance with mountainous terrain for undetermined reasons.Jan 21, 2004 · N8701E · Destroyed