Fatal NTSB investigations: Lycoming 0-540 series, 1987

7 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, 1987 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\") = 1987
    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 ATL88FA060Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Moultrie, GAThe plt was on a personal VFR flt with his wife and son. During the course of the flt, he entered deteriorating weather conditions. He was advised that there were scattered rain showers ahead. He continued on his track and advised apch control that he had…Dec 12, 1987 · N3632W · DestroyedNTSB BFO88FA008Accident · 3 fatalField investigationFinal reportPiper PA-32-260B · Willis, VAThe acft was on a night IFR flight at 7000 ft MSL in IMC when the plt reported the directional gyro was inoperative. The acft was outbound from the pulaski VOR on V45 headed southeast. The plt further reported the turn&bank and the mag compass were operative.…Nov 27, 1987 · N4832S · DestroyedNTSB FTW88FA023Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Fulton, TXAcft departed in conditions of low ceiling and visibility with a student plt and pax on board. Witnesses at the arpt estimated the ceiling as 150 to 300 ft ovc with 1/8 to 1/4 mile vis in fog. After lift off the acft entered the fog in a rt climbing turn and…Nov 4, 1987 · N3666W · DestroyedNTSB LAX88FA028Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Buttonwillow, CAA Piper PA-24-250 collided with terrain while on an IFR flight. The pilot received a wx briefing from fss. While en route, radio and radar contact was lost, then regained. The pilot stated to ATC that the acft had been struck by lightning. He elected to…Oct 29, 1987 · N5431P · DestroyedNTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…Sep 6, 1987 · N8692W · DestroyedNTSB DEN87FA178Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Hayden, COThe plt and two pax were participating in the denver, CO to jackpot, NV air classic. The acft departed, destined for rock springs, WY. The plt was believed by a friend to have been navigating with the use of a recently installed RNAV system. The plt radioed a…Jul 11, 1987 · N7858P · DestroyedNTSB DEN87FA050Accident · 1 fatalField investigationFinal reportCessna TR-182 · Moran, WYThe pilot received several weather briefings prior to departure. Briefings included reports of icing conditions, low clouds and turbulence. VFR flight was not recommended. Plt departed VFR and filed IFR enroute to jackson. The pilot was issued instructions…Feb 2, 1987 · N6089T · Destroyed