NTSB investigations: Lycoming TI0-540 series, AR
31 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
| 1965 | 1 |
|---|---|
| 1967 | 3 |
| 1968 | 2 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1986 | 1 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 2 |
| 1999 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2009 | 1 |
| 2012 | 1 |
| 2013 | 2 |
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\" = 'AR' 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 c."eventStateOrRegion" = 'AR' 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 CEN14LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA 32R-300 · Hector, ARAn engine failure due to crankshaft fatigue cracking for reasons that could not be determined based on the available evidence.NTSB CEN13LA198Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Rogers, ARThe pilot’s failure to maintain control due to a sudden turbulence encounter while on final approach. Contributing to the accident was ice buildup on the wings’ leading edges.NTSB CEN12CA486Accident · No injuriesData collectionFinal reportMooney M20M · Heber Springs, ARThe pilot's improper flare, which led to a bounced landing and a subsequent loss of control.NTSB CEN09FA393Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Lakeview, ARThe pilot's poor judgment/decision making in attempting the no-flap takeoff, his failure to comply with weight and balance limitations, and his failure to calculate the airplane's performance under exiting conditions.NTSB DFW07FA020Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Danville, ARFailure of the number 5 cylinder which resulted in oil starvation and the subsequent loss of engine power, and the pilot's inability to see the transmission line during the forced landing. Factors Contributing to the accident were the dark night and the…NTSB DFW06CA153Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Mena, ARThe pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB CHI05FA053Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Eureka Springs, ARThe pilot misjudged his distance/speed which resulted in the overrun and subsequent impact with trees. The wet turf runway and the trees were factors in the accident.NTSB FTW04FA172Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hot Springs, ARThe pilot's failure to fly a stabilized, published instrument approach procedure, which resulted in a collision with mountainous terrain. Factors were the clouds and the air traffic controllers' failure to provide known information that may have assisted the…NTSB FTW99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cabot, ARThe flight instructor's failure to attain the proper touchdown point during the landing.NTSB FTW96LA302Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Rogers, ARfuel exhaustion due to the pilot's failure to refuel. Factors were the below landing minimums weather conditions and the lack of suitable terrain for the forced landing.NTSB FTW96LA139Accident · No injuriesLimited investigationFinal reportRockwell 500U · Hampton, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Danville, ARPilot's improper crosswind correction, his loss of directional control, and improper supervision by the instructor pilot. A factor was the crosswindNTSB FTW92LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Hot Springs, ARThe partial loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB MKC89FA110Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Winslow, ARThe pilot flying into adverse weather conditions which resulted in the in-flight separation of a portion of the right wing. Contributing to the accident was the pilot's lack of total experience.NTSB MKC89LA080Accident · No injuriesLimited investigationFinal reportCallair A9-B · Fisher, ARFailure of the engine magneto resulting in engine failure.NTSB MKC87LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Harrison, ARThe routine business flt had progressed normally until approaching bentonville, Arkansas. The PIC rptd his eng ran rough for a very brief period and quit. Emerg procedures were conducted but a restart was impossible. Only 1.5 hrs of flt had transpired since…NTSB FTW81FA017Accident · 2 fatalClosedPiper PA-32R · Hagarville, ARNTSB FTW79FPG51Accident · 1 fatalClosedPiper PA-36 · Tupelo, ARNTSB FTW78FPG02Accident · No injuriesClosedPiper PA-23E · Little Rock, ARNTSB FTW74DPG80Accident · No injuriesClosedAero Comdr A-9B · Grady, ARNTSB FTW74DPG41Accident · No injuriesClosedPiper PA-32 · Mena, ARNTSB FTW73FPG11Accident · No injuriesClosedAero Comdr A-9A · Boydell, ARNTSB FTW72FPG27Accident · 1 fatalClosedAero Comdr A-9B · Mccrory, ARNTSB FTW70FPG35Accident · Serious injuriesClosedCallair A9B · Newport, ARNTSB FTW70F0219Accident · No injuriesClosedPiper PA-24 · Tuckerman, ARNTSB FTW69F0143Accident · No injuriesClosedPiper PA-24 · Eudora, ARNTSB FTW69F0017Accident · No injuriesClosedPiper PA-24 · Mountain Home, ARNTSB FTW68A0067Accident · Minor injuriesClosedAero Cmdr 500-B · Mena, ARNTSB FTW68F0386Accident · No injuriesClosedPiper PA-23 · Little Rock, ARNTSB FTW68D0175Accident · No injuriesClosedPiper PA-23 · Gurdon, ARNTSB FTW66D0375Accident · No injuriesClosedPiper PA-23 · Siloam Sps, AR