NTSB investigations: Lycoming TI0-540 series, 1986, AL
4 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
| 1968 | 1 |
|---|---|
| 1970 | 2 |
| 1973 | 2 |
| 1974 | 3 |
| 1975 | 1 |
| 1976 | 3 |
| 1977 | 3 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1986 | 4 |
| 1989 | 1 |
| 1991 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 2 |
| 2020 | 2 |
| 2023 | 3 |
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\" = 'AL' 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" = 'AL' 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 ATL86LA161Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Guntersville, ALThe plt allowed the aircraft to settle back onto the runway shortly after liftoff from the runway after having already retracted the landing gear. The aircraft landed with the landing gear retracted.NTSB ATL86LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birmingham, ALAfter takeoff pilot noted loss of engine oil pressure. Engine siezed and pilot landed short of runway. A/c hit ILS antenna during landing roll, severed right wing. Engine oil cooler line burst due to aging. Line was fabricated in the 1st qtr 0F 1972. Oil…NTSB ATL86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300T · Fort Deposit, ALShortly after takeoff smoke and flames entered the cockpit. The pilot returned to the airport and landed hard damaging the firewall. Examination of the aircraft revealed that the turbo charger exhaust clamp broke and allowed hot exhaust gases to ignite a fire…NTSB ATL86MA087Accident · 1 fatalMajor investigationFinal reportPiper PA-32-300 · Andalusia, ALThe accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…