NTSB investigations: Lycoming 0-540 series, 1987, FL

4 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
NTSB investigations: Lycoming 0-540 series, 1987, FL per year, 1964–2026: 222 cases
19646
196511
19667
19679
19683
19691
19709
19712
19729
19739
19741
19755
19763
19775
19786
19797
198012
19813
19826
19832
19844
19858
19863
19874
19882
19891
19902
19912
19921
19932
19941
19954
19963
19971
19984
19997
20001
20011
20021
20036
20046
20051
20063
20074
20081
20091
20102
20112
20133
20142
20152
20162
20171
20181
20193
20203
20235
20242
20251
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\") = 1987
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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 MIA88LA037Accident · No injuriesLimited investigationFinal reportMandley Steen Skybolt · Placida, FLWhen attempting to start the eng the plt heard it backfire & then observed smoke coming from under the eng cowling. He then immediately exited the acft & left the scene to summon the fire department. He later returned to find the aircraft consumed by fire.…Nov 16, 1987 · N44JM · DestroyedNTSB MIA87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kissimmee, FLThe plt failed to lower the landing gear prior to touchdown. Insp of the acft revealed that the landing gear warning horn & gear down & locked light were inoperative.Jun 10, 1987 · N6529P · Substantial damageNTSB MIA87LA104Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Navarre, FLShortly after take off with the fuel selector positioned to the rt tank, at an alt of aprx 250 feet, the eng quit. The plt force landed the acft in an inter coastal waterway with the landing gear extended. Insp of the acft revealed that the eng quit due to…Mar 11, 1987 · N7645P · Substantial damageNTSB MIA87LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Ft.Lauderdale, FLThe plt repositioned the fuel selector from the left tip tank to the right main tank when the flt entered the traffic pattern. The eng then quit & a forced landing was made in an open field. Upon touchdown the left & right main landing gear were pushed…Jan 17, 1987 · N3743W · Substantial damage