Skip to content

NTSB investigations: Lycoming TI0-540 series, IA

29 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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" = 'IA' 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

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\" = 'IA' 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" = 'IA' 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

Run 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 CEN14LA138Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Marion, IAThe pilot’s failure to attain a touchdown on the runway’s hard surface, which resulted in a loss of directional control.Feb 11, 2014 · N350AR · Substantial damage NTSB CEN12LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Elkader, IAThe pilot's failure to attain the proper touchdown point while landing on the wet grass runway.Jul 14, 2012 · N1127X · Substantial damage NTSB CEN10CA106Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Cherokee, IAThe pilot misjudged his altitude while on short final approach.Jan 21, 2010 · N8916P · Substantial damage NTSB CHI02FA292Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Ankeny, IAThe pilot applied an excessive angle of bank and failed to maintain terrain clearance. An additonal factor was the pilot's attention being diverted.Sep 24, 2002 · N8782P · Destroyed NTSB CHI00LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Mason City, IAthe unsuitable terrain for landing encountered by the pilot and the failure of the oil filter converter plate gasket. Factors to the accident were the total loss of oil and the soft terrain condition.Sep 1, 2000 · N8304C · Substantial damage NTSB CHI99LA114Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Waterloo, IAthe pilot's failure to maintain directional control.Mar 24, 1999 · N812TB · Substantial damage NTSB CHI97LA277Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAinadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.Aug 31, 1997 · N7058T · Destroyed NTSB CHI92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Charles City, IAProper glide path not maintained. Factors in the accident are the premature landing gear extension and inadequate airspeed by the pilot in command.Nov 12, 1991 · N9161P · Substantial damage NTSB MKC89LA029Accident · No injuriesLimited investigationFinal reportAerospatiale TB-21 · Clinton, IAThe plt rprtd that while cruising at 10,000' & monitoring the eng instruments in a normal manner, power was suddenly lost as if by fuel starvation. He stated that emerg procedures were performed, but he was unable to restart the eng in spite of fuel in both…Nov 22, 1988 · N20GF · Substantial damage NTSB MKC87FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Ogden, IAThe airplane was equipped for IFR flight. The pilot was not instrument rated. The pilot had been briefed earlier that VFR flight was not recommended. The pilot did not update the weather for this flight. The front of the airplane was buried seven feet in the…Apr 22, 1987 · N44626 · Destroyed NTSB MKC87LA062Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mason City, IAThe pilot stated that he had obtained a full weather briefing and an IFR clearance from grand marais, Minnesota to des moines, Iowa prior to departure; and that the flight was uneventful, except for stronger than forecasted headwinds aloft. Enroute, the pilot…Mar 16, 1987 · N56285 · Substantial damage NTSB MKC84FA235Accident · Serious injuriesField investigationFinal reportPiper PA32R300 · Des Moines, IAThe acft eng began to 'shudder badly' upon reaching a cruise alt of 3500 ft MSL shortly after takeoff. The plt made a 180 deg course reversal to return to the arpt but reported to ATC he was unable to see outside the acft because oil was smeared on the acft.…Jul 30, 1984 · N1654H · Substantial damage NTSB MKC81DCD18Accident · No injuriesClosedPiper PA-32 · Holstein, IAApr 26, 1981 · N2835W · Substantial damage NTSB MKC79FA020Accident · No injuriesClosedPiper PA-31 · Clinton, IAFeb 28, 1979 · N9170Y · Substantial damage NTSB MKC78DCD54Accident · No injuriesClosedCallair A-9B · Lake Park, IASep 6, 1978 · N7757V · Substantial damage NTSB MKC78DCD46Accident · No injuriesClosedPiper PA-32R · Des Moines, IAAug 25, 1978 · N12ML · Substantial damage NTSB MKC78FCD19Accident · No injuriesClosedPiper PA-32 · Washington, IAMay 4, 1978 · N2DP · Substantial damage NTSB MKC78IA023Incident · No injuriesClosedPiper PA-23 · Marshalltown, IAFeb 22, 1978 · N88SS · Minor damage NTSB MKC77FCD14Accident · Serious injuriesClosedPiper PA-24 · Spirit Lake, IAMar 20, 1977 · N8623P · Substantial damage NTSB MKC77FCD06Accident · Minor injuriesClosedAero-Star 600 · Pella, IADec 29, 1976 · N7468S · Substantial damage NTSB MKC76FCD06Accident · No injuriesClosedAero Comdr A-9 · Sac City, IAAug 28, 1975 · N7749V · Substantial damage NTSB MKC75FCD08Accident · No injuriesClosedCallair A-9B · Harcourt, IAAug 15, 1974 · N7765V · Destroyed NTSB MKC74FCD31Accident · No injuriesClosedBellanca 17-30A · Red Oak, IAMay 5, 1974 · N8262R · 2 aircraft · Substantial damage NTSB MKC73DCD22Accident · No injuriesClosedPiper PA-24 · Nevada, IAAug 28, 1972 · N9207P · Substantial damage NTSB MKC72DCD45Accident · No injuriesClosedPiper PA-32 · Ida Grove, IANov 14, 1971 · N4063R · Substantial damage NTSB MKC72DCD38Accident · No injuriesClosedPiper PA-32 · Marshalltown, IAOct 13, 1971 · N4031R · Substantial damage NTSB MKC71DCD43Accident · No injuriesClosedPiper PA-24 · Shenandoah, IADec 19, 1970 · N9164P · Substantial damage NTSB MKC67F0254Accident · No injuriesClosedPiper PA-23 · Des Moines, IAOct 15, 1966 · N6193Y · Substantial damage NTSB MKC66F0359Accident · No injuriesClosedPiper PA-24 · Estherville, IANov 29, 1965 · N8606P · Substantial damage