NTSB investigations: Lycoming TI0-540 series, 1986, FL
10 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
| 1964 | 1 |
|---|---|
| 1965 | 3 |
| 1966 | 1 |
| 1967 | 4 |
| 1968 | 5 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 5 |
| 1973 | 6 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 3 |
| 1978 | 5 |
| 1979 | 6 |
| 1980 | 9 |
| 1981 | 4 |
| 1982 | 4 |
| 1983 | 5 |
| 1984 | 10 |
| 1985 | 9 |
| 1986 | 10 |
| 1987 | 8 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 9 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 2 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 3 |
| 2026 | 1 |
Where
Open the mapLatest 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\") = 1986
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 ('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.
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") = 1986
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 ('41533'))
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 MIA87LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Cedar Key, FLThe plt stated that he was not able to see the lighted wind sock from 1000 ft as he was unfamiliar with its location. The acft landed downwind on the rwy & was unable to stop before running off the end. A 15 to 20 kt tailwind was present at the time. The plt…NTSB MIA87LA024Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homestead, FLThe plt stated that he thought he had put the gear handle down but on touchdown the gear was up and the aircraft slid to a stop on the runway. Post crash examination of the landing gear system revealed that the landing gear was up when it contacted the runway…NTSB MIA87FA002Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Tallahassee, FLWitnesses stated seeing the acft enter a left downwind apch to rwy 16, turn base to final normally then veer to the left of the runway in a nose high attitude & disappear behind a line of trees & crash aprx 500 feet east of rwy 16. Post crash examination of…NTSB MIA86LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft.Lauderdale, FLFlt experienced loss of power in the left engine shortly after takeoff due to corrosion blocking the main jet in the fuel control unit. The pilot feathered the engine and returned for a landing. While on short final he remembered he would have to manually…NTSB MIA86LA159Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Tallahassee, FLWhile in the traffic pattern the acft's electrical system failed due to internal failure of the alternator. The plt failed to extend the landing gear by the emergency gear extension handle and a gear up landing resulted.NTSB MIA86FA103Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Osteen, FLBefore the flt, the plt & pax were observed drinking alcoholic beverages on the way to the arpt. After much difficulty taxiing to the rwy, the flt was cleared for takeoff after entering the active rwy without clearance. After taking off, the acft was seen…NTSB MIA86LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Pierce, FLThe plt stated that while switching tanks, his fuel selector froze up & both eng's failed. Upon landing, the acft struck a tree severing a wing. The NTSB form 6120.1 that was sent to the plt was returned, it stated that the addressee moved & left no address.…NTSB MIA86FA095Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Florida City, FLThe acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the…NTSB MIA86FA085Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · St. Cloud, FLThe acft was on a VFR flt, the wx was clear with an almost full moon when the acft crashed in a fld. There was no evidence of an airframe, flt control system, eng or propeller malfunction or failure. The autopsy & toxicological studies revealed no pre impact…NTSB MIA86FA080Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Moore Haven, FLOn February 17, 1986 the wreckage of N7EA along with the skeletal remains of two persons were found. The acft crashed into trees causing the separation of the outboard six feet of left wing and then continued crashing through more trees before colliding with…