NTSB investigations: Lycoming LTS-101 series
9 cases on aircraft whose registry engine model is Lycoming LTS-101 series, where the first occurrence was “In flight collision with object”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41560')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41560')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 IAD02FA026Accident · 2 fatalField investigationFinal reportMBB BK-117 A-3 · Cleveland, OHpilot's failure to maintain directional control of the helicopter while hovering, which resulted in its collision with a building. Factors were the confined area, tail wind, and wind gusts.NTSB DEN01LA084Accident · No injuriesLimited investigationFinal reportBell 222UT · Alcova, WYthe pilot's failure to maintain tail rotor clearance during a right pedal turn while hovering.NTSB NYC00FA127Accident · Serious injuriesField investigationFinal reportEurocopter BK-117-A4 · Cincinnati, OHthe pilot's misjudgment of his closure rate, while turning to land on the rooftop helipad, which resulted in a collision with the building. Factors in the accident were the tailwind and the stuck windsock.NTSB ATL00FA048Accident · 3 fatalField investigationFinal reportEurocopter BK117-A3 · St. Petersburg, FLThe pilot's failure to maintain clearance that resulted in the in-flight collision with a tower.NTSB MIA99LA129Accident · No injuriesLimited investigationFinal reportMbb BK 117 A-3 · Sarasota, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering in a hover resulting in the tail rotor colliding with a building.NTSB ATL89FA116Accident · 2 fatalField investigationFinal reportMBB BK-117-A-3 · Coinjock, NCFailure of the cellular company to properly install an operational lighting system on a newly constructed transmission tower. Darkness and the company's failure to notify flight service of the unlighted tower were related factors.NTSB LAX86LA098Accident · Minor injuriesLimited investigationFinal reportBell 222UT · La Habra, CAOn January 26, 1986 a Bell 222UT collided with a 3/8 inch support cable. The pilot saw the lower of two of the three support cables about 75 feet AGL as he was transitioning to forward flight from a vertical max performance t/o. the pilot applied aft cyclic…NTSB ATL85LA017Accident · Minor injuriesLimited investigationFinal reportBell 222 · Pascagoula, MSThe acft sustained substantial damage while taking off from a barge during a FAR 135 medevac flt. Investigation revealedthat the barge was pitching due to rough seas. As the acft lifted, the rear of the acft was struck by the landing platform as it pitched…NTSB FTW84LA090Accident · No injuriesLimited investigationFinal reportBell 222U · Albuquerque, NMThe helicopter was parked on the ramp, facing east. When the plt called the tower for clearance, he requested a west departure. The plt received a clearance & was advised of traffic on the west ramp (behind the helicopter) & was instructed not to overfly the…