NTSB investigations: Lycoming IO-540 series, 1988
12 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\") = 1988
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") = 1988
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 BFO89FA009Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Towson, MDAbout 6 min after takeoff, after leveling at 3500 ft, the plt rprtd he was having a probelm that he was unable to figure out. A few minutes later, he repeated the same problem & elected to divert to a nearby arpt. Witnesses rprtd the acft reversed course svrl…NTSB LAX89LA036Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Camarillo, CAPilot of N8219J used poor judgement when she elected to execute the high speed taxi operation.NTSB ANC89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Ivanof Bay, AKThe pilot was attempting to land on a 30 foot wide, 1200 foot gravel strip in gusty wind conditions. He said just prior to touchdown, the airplane encountered a strong gust of wind resulting in a hard landing short of the runway. The left main landing gear…NTSB MIA89FA015Accident · Serious injuriesField investigationFinal reportLake LA-4-250 · Key West, FLThe plt reduced engine power during initial climb from a touch and go landing on the gulf of Mexico. The acft stalled and descended uncontrolled back to the water, striking the water hard. The acft then bounced and again hit the water in a nose low right wing…NTSB MKC88LA177Accident · No injuriesLimited investigationFinal reportAerospatiale TB-20 · Omaha, NEThe plt rprtd that when the acft was at aprx 150' to 200' AGL on final apch, the eng lost pwr & would not restart. Unable to rch the rwy, he lndd about 50' short on soft trrn, where the gear collapsed & the acft was dmgd. Only about 12 ounces of fuel was…NTSB ANC88LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dillingham, AKThe pilot reported that he lost control of the aircraft. The plane crashed approximately 500 feet off the departure end of the airstrip. The flight was a part 135 on-demand air taxi flight. At the time of the accident, the aircraft was above maximum certified…NTSB ANC88LA085Accident · 1 fatalLimited investigationFinal reportMaule M6-235 · Egegik, AKAfter touchdown on the beach, the aircraft struck a three-wheeled scooter (atv). The atv was substantially damaged and the driver of the atv, an eleven year old boy, died a few days later. The atv passenger, a eight year old girl, received minor injuries.…NTSB DEN88DTK01Accident · Serious injuriesFinal reportEagle DW-1 · Ferney, SDThe ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and…NTSB NYC88FA147Accident · 1 fatalField investigationFinal reportLake LA4-250 · Shaftsbury, VTThe Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition…NTSB ANC88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Port Heiden, AKThe pilot elected to abort the takeoff of a heavily loaded Piper from a soft strip. His decision was tardy and the airplane struck a cinder bank.NTSB MIA88LA204Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLWhile en route, on a personal cross country flt, the alternator belt broke resulting in the loss of electrical power which the plt did not recognize before the battery had been drained. During the precautionary landing the acft landed hard resulting in…NTSB ANC88LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kipnuk, AKThe pilot stated that during the initial climbout from the airport he encountered a complete whiteout condition. The pilot then elected to land on the frozen lake and during the rollout the aircraft struck a snowbank.