NTSB investigations: Lycoming IO-540 series, 1987
15 cases on aircraft whose registry engine model is Lycoming IO-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
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 4 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 4 |
| 1977 | 3 |
| 1978 | 6 |
| 1979 | 7 |
| 1980 | 18 |
| 1981 | 10 |
| 1982 | 16 |
| 1983 | 17 |
| 1984 | 30 |
| 1985 | 20 |
| 1986 | 17 |
| 1987 | 15 |
| 1988 | 12 |
| 1989 | 11 |
| 1990 | 14 |
| 1991 | 14 |
| 1992 | 19 |
| 1993 | 24 |
| 1994 | 13 |
| 1995 | 14 |
| 1996 | 16 |
| 1997 | 16 |
| 1998 | 16 |
| 1999 | 28 |
| 2000 | 27 |
| 2001 | 32 |
| 2002 | 37 |
| 2003 | 30 |
| 2004 | 35 |
| 2005 | 30 |
| 2006 | 31 |
| 2007 | 34 |
| 2008 | 29 |
| 2009 | 19 |
| 2010 | 29 |
| 2011 | 22 |
| 2012 | 26 |
| 2013 | 21 |
| 2014 | 28 |
| 2015 | 19 |
| 2016 | 18 |
| 2017 | 28 |
| 2018 | 27 |
| 2019 | 16 |
| 2020 | 15 |
| 2021 | 27 |
| 2022 | 23 |
| 2023 | 24 |
| 2024 | 14 |
| 2025 | 18 |
| 2026 | 16 |
Where
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
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.
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL87LA254Accident · No injuriesLimited investigationFinal reportAerostar 600 · Columbus, OHThe scheduled domestic all cargo flt was taxiing from the ramp to the rwy behind another company acft when the plt suddenly realized that the lead acft was not moving. The plts attempts to stop the acft were not successful. The stopped acft was substantially…NTSB FTW87LA200Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mc Allen, TXThe right main landing gear collapsed for unknown reasons as the aircraft was taxiing for takeoff. The pilot has not responded to requests to complete an accident report form. According to airman records, the pilot did not have a multiengine rating.NTSB SEA87LA159Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Hamer, IDThe plt rprtd that he bgn taking off on a downhill strip (aprx 1/2 mi long) with a left quartering tail wind. As the takeoff roll progressed, he realized an overrun was developing, so he bgn dumping his load & attempted to lift- off. He said the acft settled…NTSB NYC87LA212Accident · Serious injuriesLimited investigationFinal reportLake LA-4-250 · Westport, NYDrg the takeoff run on a Lake, the amphibian enctrd rough water & became airborne prematurely. The acft then settled onto the water in a slightly nose high attitude & touched down in front of a large wave. The acft's nose crashed head-on into the wave which…NTSB NYC87LA198Accident · No injuriesLimited investigationFinal reportLake LA-250 · Alton Bay, NHThe Lake renegade 250 was making a water takeoff when it started a sharp left turn. The aircraft stopped in the water and the pilot exited without injuries prior to the aircraft turning over. Examination of the aircraft showed that the engine pylon had…NTSB ANC87LA076Accident · No injuriesLimited investigationFinal reportMaule M-6 · Kenai, AKThe pilot effected a go-around during an approach to runway 01 in gusty surface wind conditions. During the second approach he landed and lost control at or near the demonstrated crosswind component limit for this airplane. The airplane ground looped and…NTSB FTW87FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Porter, OKAcft was observed in a rt bank when it experienced an inflt breakup. Both wings, vert stab and rudder, and the horz stab and trim tab separated prior to impact. Wx was dark night with scattered to broken cloud cover, but VFR. Although a wx rpt 33 NM northwest…NTSB MKC87LA088Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Lincoln, KSThe plt was spraying 2/4/D when one spray nozzle stuck open. Rather than kill alfalfa and trees during the turnarounds, the plt elected to land on a dirt road and repair the nozzle. He misjudged the width of the road and on touchdown, the right wing touched…NTSB FTW87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Lake Providence, LAThe pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the…NTSB FTW87LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Laverne, OKDuring a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces.NTSB FTW87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Many, LAAcft received substantial damage when it ran off the end of a 3,300' pvt airstrip into a lake during an attempted go around. The winds were calm. The plt reported that he landed long and fast over trees at the threshold and delayed initiating a go around…NTSB ATL87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Toccoa, GAThe pilot overshot runway 20 and skidded off the departure end which caused substantial damage to the aircraft. The pilot stated that he should have descended to the normal visual traffic pattern altitude before attempting a landing. There were no reported…NTSB LAX87DVA03Accident · No injuriesFinal reportEagle DW-1 · Modesto, CADuring an aerial application flight, the pilot stated that just after the aircraft became airborne, it began to lose altitude and struck a canal bank at the end of the dirt strip. There were no reported mechanical failures or malfunctions. The acft was loaded…NTSB ATL87LA063Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Wilkesboro, NCDuring a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.…NTSB MIA87LA070Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Pahokee, FLThe plt stated that he was conducting an over water apch to rwy 17 when he observed traffic preparing to land ahead of him. He slowed the acft for traffic separation, lowered the gear, & extended partial flaps. He then stated that he felt an abnormal loss of…