NTSB investigations: Lycoming TI0-541 series, FL
15 cases on aircraft whose registry engine model is Lycoming TI0-541 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
| 1971 | 1 |
|---|---|
| 1972 | 2 |
| 1975 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1993 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 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.\"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 ('41536'))
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 ('41536'))
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 ERA22LA048Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-350 · Fort Lauderdale, FLThe collapse of the left main landing gear for reasons that could not be determined.NTSB CEN18FA358Accident · 4 fatalField investigationFinal reportBeech B60 · Fort Walton Beach, FLThe pilot's controlled flight into terrain after misidentifying the destination airport during a period of restricted visibility due to weather.NTSB ERA17FA119Accident · 2 fatalField investigationFinal reportBeech B 60 · Duette, FLThe pilots' decision to perform flight training maneuvers at low airspeed at an altitude that was insufficient for stall recovery. Contributing to the accident was the flight instructor's inappropriate use of non-standard stall recovery techniques.NTSB NYC07LA178Accident · No injuriesLimited investigationFinal reportBeech B60 · Orlando, FLThe pilot's improper weather evaluation during cruise flight. Contributing to the accident was the air traffic controller's failure to issue in-flight weather avoidance assistance and the convective turbulence.NTSB MIA06FA090Accident · 3 fatalField investigationFinal reportBeech B-60 · Gainesville, FLThe loss of control for an undetermined reason.NTSB MIA94FA008Accident · Serious injuriesField investigationFinal reportBeech 60 · Miami, FLInadequate preflight by the pilot, and his failure to assure that proper maintenance/annual inspection was attained. Factors related to the accident were: water and other contamination in the fuel supply, lack of continuity in two ignition leads, loose left…NTSB MIA89IA094Incident · No injuriesIncident investigationFinal reportBeech B60 · Jacksonville, FLFailure of the left main landing gear retract rod due to poor maintenance and inspection of the main gear assembly.NTSB MIA88FA195Accident · 1 fatalField investigationFinal reportPiper PA-31-P · Miami Lakes, FLThe instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…NTSB MIA88LA045Accident · No injuriesLimited investigationFinal reportMooney M-22 · Fort Pierce, FLPlt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the…NTSB MIA81FLD56Accident · No injuriesClosedBeech 56TC · Arcadia, FLNTSB MIA79DKT73Accident · Minor injuriesClosedBeech A60 · Belle Glade, FLNTSB MIA76F1A05Accident · No injuriesClosedBeech 56TC · Destin, FLNTSB MIA73FLD30Accident · No injuriesClosedBeech 56TC · Daytona Beach, FLNTSB MIA72FLA28Accident · No injuriesClosedMooney M-22 · Bell, FLNTSB MIA72DLD10Accident · No injuriesClosedBeech 56TC · Crystal River, FL