NTSB investigations: Lycoming LTS-101 600A series
12 cases on aircraft whose registry engine model is Lycoming LTS-101 600A 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
| 1979 | 1 |
|---|---|
| 1981 | 3 |
| 1982 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2010 | 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 ('41562'))
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 ('41562'))
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 OPS10IA538Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Los Angeles, CAFailure of the air traffic controller to exercise positive control of the situation by issuing clear and timely control instructions to the helicopter pilot. Contributing to the incident was delay by the helicopter pilot in responding to instructions issued…NTSB ATL05FA038Accident · 1 fatalField investigationFinal reportAerospatiale AS350-D · Falkner, MSThe pilot's improper decision to attempt VFR flight into known instrument flight conditions and failure to maintain altitude clearance resulted in an in-flight collision with trees and the ground.NTSB SEA04LA145Accident · No injuriesLimited investigationFinal reportBell 222U · Louie Lake, IDThe failure of the pilot to maintain rotor rpm and his inadequate recovery from a bounced landing. Factors contributing to the accident included the tailwind condition and the tree.NTSB ATL00FA069Accident · 3 fatalField investigationFinal reportEurocopter AS350B · Sumner, GAThe pilot experienced spatial disorientation, which resulted in a loss of control of the helicopter. Contributing factors was the dark night.NTSB MIA90FA081Accident · 2 fatalField investigationFinal reportAerospatiale 350D · Miami, FLFatigue failure of an engine turbine blade, which resulted in a loss of power. Rough ocean water in the emergency landing area was a related factor.NTSB FTW89FA049Accident · 3 fatalField investigationFinal reportMBB BK-117 A-1 · Tyler, TXThe pilot's failure to execute the published inadvertent IMC procedures when he encountered adverse weather conditions.NTSB FTW83FRA03Accident · Serious injuriesFinal reportS.N.I.A.S. AS350D · Houston, TXThe pilot stated that as he came to a hover to land, an engine surge occurred which sent the helicopter back into the air. Reportedly, the engine continued to surge off and on, and as helicopter came down, it would impact the ground and bounce back in the…NTSB LAX82DA147Accident · 1 fatalFinal reportS.N.I.A.S. AS350 · Gold Strike, NVThe helicopter had just returned from a sightseeing tour of the grand canyon. The pilot reported that the passengers wanted to get out while the helicopter was undergoing its two-minute, cool-down period. The pilot escorted four of the passengers from the…NTSB CHI81FEX29Accident · No injuriesClosedAerospatial AS350D · Lynnville, INNTSB FTW81IA112Incident · No injuriesClosedAerospatial AS350 · Port Arthur, TXNTSB FTW81FA069Accident · Minor injuriesClosedAerospatial AS350D · Edmond, OKNTSB FTW80FRD12Accident · Serious injuriesClosedAerospatle AS-350 · Intracstl Cy, LA