NTSB investigations: Lycoming IGSO-540-B1A, FL
16 cases on aircraft whose registry engine model is Lycoming IGSO-540-B1A. 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
| 1966 | 1 |
|---|---|
| 1969 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 4 |
| 1981 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1994 | 1 |
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 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 ('41535'))
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."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 ('41535'))
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 MIA94LA149Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Pensacola, FLImproper installation of nuts on the nosewheel (split rim) through-bolts by unknown personnel, which resulted in a subsequent failure (separation of the wheel halves).NTSB MIA91LA151Accident · Minor injuriesLimited investigationFinal reportBeech 80 · Fort Lauderdale, FLThe improper maintenance work by an unknown person who crossthreaded a fuel nozzle injector fitting which allowed fuel to leak on the exhaust system initiating a fire. No reason for the right engine not to develop full power was found.NTSB MIA86LA011Accident · No injuriesLimited investigationFinal reportBeech 65A-80 · Ochopee, FLWhile on a night pleasure flt, both engs surged and lost pwr and an emergency landing was made. The plt stated that he had a total of 3 hrs flt time in this type of acft. He later recanted his statement & stated that he had never flown this type acft before.…NTSB MIA84FA163Accident · Serious injuriesField investigationFinal reportBeech 65-80 · Opa Locka, FLThe plt stated that he did not check the acft fuel visually prior to departure. About 10 minutes after takeoff, while using auxiliary fuel tanks, the right eng lost power. The plt selected crossfeed & the eng restarted. He then turned off the right fuel…NTSB MIA81FA102Accident · 2 fatalClosedBeech 65-B80 · Groveland, FLNTSB MIA80FLD96Accident · No injuriesClosedBeech 65-B80 · Lake Marion, FLNTSB MIA80FLD52Accident · Serious injuriesClosedBeech 65-80 · Sebring, FLNTSB MIA80FLA17Accident · No injuriesClosedAero Comdr 680F · N Smyrna Beach, FLNTSB MIA80FA032Accident · 2 fatalClosedAero Comdr 680FL · Sebring, FLNTSB MIA78FA060Accident · 1 fatalClosedAero Comdr 680F · Fellsmere, FLNTSB MIA77DKT56Accident · No injuriesClosedBeech 65 · W.Palm Beach, FLNTSB MIA7LDLD77Accident · No injuriesClosedBeech 65-80 · Lake Placid, FLNTSB MIA76FLD68Accident · No injuriesClosedBeech 65-80 · Clearwater, FLNTSB MIA74FLA28Accident · No injuriesClosedBeech 65-80 · Crestview, FLNTSB MIA70D0013Accident · No injuriesClosedBeech 65-80 · Ft.Meyers, FLNTSB MIA67F0162Accident · No injuriesClosedBeech 65-80 · Merritt Isl., FL