Fatal NTSB investigations: Lycoming TI0-540 series, 2007

7 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, 2007 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\") = 2007
    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 CHI08FA054Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Warrens, WIThe decision by the pilot to fly into known adverse weather, and the pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors include the clouds and the night conditions.Dec 21, 2007 · N1919H · DestroyedNTSB SEA08FA046Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Orting, WAThe pilot's failure to maintain clearance from trees while maneuvering. A contributing factor was the dark night.Dec 7, 2007 · N4388P · Substantial damageNTSB CHI07FA305Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Defiance, OHThe pilot's spatial disorientation when he encountered convective turbulence which resulted in a loss of control. This encounter resulted in an in-flight break up. Contributing to the accident was the convective turbulence in the clouds.Sep 26, 2007 · N8341G · DestroyedNTSB ATL07LA110Accident · 1 fatalLimited investigationFinal reportCessna T206H · Lovell, METhe pilot's failure to retract the amphibious floatplane's landing gear during a water landing.Aug 4, 2007 · N206MW · Substantial damageNTSB NYC07FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Windham, CTThe pilot's failure to maintain control of the airplane during a go-around.Apr 22, 2007 · N5651Y · DestroyedNTSB MIA07LA084Accident · 5 fatalLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot's continued visual flight rules flight into known adverse weather conditions, resulting in an in-flight loss of aircraft control. Contributing to the accident were thunderstorms.Apr 21, 2007 · N4TR · DestroyedNTSB ATL07FA069Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Andrews, NCThe pilot's misjudgment of distance and altitude during a night approach for landing, resulting in an in flight collision with wires and the ground.Apr 9, 2007 · N21423 · Destroyed