Skip to content

NTSB investigations: Lycoming TI0-540 series, NE

20 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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 WPR26FA216Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-36-300 · Henderson, NEOn June 11, 2026, at 2103 central daylight time, a Piper PA-36-300, N57846, was substantially damaged when it impacted a rotating beacon tower and terrain near Henderson, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jun 12, 2026 · N57846 · Substantial damage NTSB CEN24FA028Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46 · McCook, NEThe pilot exceeded the airplane’s critical angle of attack during the initial climb, resulting in an aerodynamic stall from which he could not recover. Contributing to the accident was the pilot’s decision to take off with the airplane well above its maximum…Oct 30, 2023 · N510KC · Substantial damage NTSB DEN06LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Harrisburg, NEThe loss of engine power resulting from mechanical failure of a connecting rod for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 10, 2006 · N8741P · Substantial damage NTSB CHI05CA092Accident · No injuriesData collectionFinal reportMooney M20M · Lincoln, NEThe pilot inadvertently exceeded the design limits of the airplane during the recovery from the loss of control due to the unanticipated severe turbulence. Factors to the accident were the turbulence in clouds and the main landing gear collapse.Apr 10, 2005 · N21816 · Substantial damage NTSB CHI01LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Plattsmouth, NEthe loss of engine power for undetermined reasons during the approach and the inadvertent stall that occurred during the forced landing. Factors relating to this accident were the low airspeed, the uphill terrain, and the fence.Jun 21, 2001 · N5659V · Substantial damage NTSB CHI00LA255Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Omaha, NEthe landing gear not deployed, the checklist not followed, the lack of familiarity with the airplane, the landing gear warning system not understood, and the landing gear warning disregarded by the pilot.Aug 10, 2000 · N10QB · Substantial damage NTSB CHI94LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ellsworth, NEthe jammed impulse coupling on the left magneto which caused the crankshaft drive gear to shear from the crankshaft.Mar 21, 1994 · N5251S · Substantial damage NTSB CHI92IA141Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Valentine, NEThe failure of the pilot in command to extend the landing gear and the inattentive FAA inspector (check airman). Associated factors are the inoperative landing gear warning system, the inadequate preflight inspection by the pilot and FAA inspector, and the…May 7, 1992 · N143AC · Minor damage NTSB MKC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Norfolk, NEA fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to…Jul 22, 1986 · N62719 · Substantial damage NTSB MKC85LA171Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Cozad, NEThe plt reported that during a descent to land at kearney, NE, the eng lost power & oil oozed out of the cowling & covered most of the windshield. During a forced landing apch, he released his seat belt so he could see thru a small section of the windshield.…Jul 28, 1985 · N6598V · Substantial damage NTSB MKC80FCJ16Accident · No injuriesClosedAero Comndr 500B · Omaha, NEJun 22, 1980 · N888CA · Substantial damage NTSB MKC79DCJ10Accident · No injuriesClosedPiper PA-32R · Ainsworth, NEFeb 16, 1979 · N2174A · Substantial damage NTSB MKC78DCJ37Accident · Minor injuriesClosedAero Comdr A-9B · Agnew, NEAug 7, 1978 · N7292V · Substantial damage NTSB MKC78FCJ28Accident · No injuriesClosedCallair A-9 · Loup City, NEJul 13, 1978 · N7227V · Substantial damage NTSB MKC77FCJ37Accident · No injuriesClosedPiper PA-32 · Lincoln, NEAug 16, 1977 · N8674N · Substantial damage NTSB MKC75DCJ04Accident · No injuriesClosedPiper PA-24 · Sidney, NEJul 8, 1974 · N9222P · Substantial damage NTSB MKC73FCJ26Accident · No injuriesClosedBeech D95A · North Platte, NENov 28, 1972 · N816G · Substantial damage NTSB MKC71DCJ61Incident · No injuriesClosedPiper PA-28 · Lincoln, NEMay 13, 1971 · N7482W · Minor damage NTSB MKC70FCJ04Accident · No injuriesClosedPiper PA-32 · Oneill, NEJan 27, 1970 · N8955N · Substantial damage NTSB MKC66F0227Accident · No injuriesClosedPiper PA-24 · Ogallala, NEOct 3, 1965 · N8844P · Substantial damage