Skip to content

NTSB investigations: Lycoming TI0-540 series, MD

17 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

19672026

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" = 'MD' 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\" = 'MD' 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" = 'MD' 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 ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.Nov 18, 2019 · N1031M · Substantial damage NTSB ERA17LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Friendly, MDA total loss of engine power during initial climb for reasons that could not be determined because examination of the wreckage revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 6, 2017 · N21HD · Substantial damage NTSB ERA13CA079Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Easton, MDThe pilot's failure to maintain directional control while landing.Dec 4, 2012 · N2835W · Substantial damage NTSB NYC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Denton, MDThe failure of the pilot to detect the automobile gasoline in the tanks prior to departure, and intentional refueling with improper fuel by the pilot's brother which resulted in a lose of engine power due to detonation and loss of oil pressure.Jun 10, 1992 · N4552X · Substantial damage NTSB BFO89FA043Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Myersville, MDContinued flight by the pilot into instrument meteorological conditions (IMC) and his inability to maintain control of the aircraft after becoming spatially disoriented. Contributing factors were hilly/mountainous terrain, weather conditions, the pilot's lack…Jun 9, 1989 · N1499X · Destroyed NTSB BFO88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Cambridge, MDThe pilot had departed ocean city, MD aprx 20 minutes after takeoff when nearing the chesapeake bay at an alt of 3000 ft MSL, a total loss of engine power was experienced. The plt attempted to restart the engine to no avail and a forced landing was made in a…Jun 27, 1988 · N21312 · Substantial damage NTSB ATL82DA193Accident · Minor injuriesFinal reportPiper PA-32-300 · Westminster, MDWhile on a cross-country flight, the pilot elected to make an unscheduled stop at a unfamiliar airport to check the en route weather. He circled the airport and thought the wind indicated favored runway 31, but later, he found that the wind was calm. No…Jul 10, 1982 · N4371X · Substantial damage NTSB ATL82DA094Accident · No injuriesFinal reportPiper PA-32-301T · Lexington Park, MDThe pilot stated that while decelerating through approximately 50 knots on landing rollout he lowered the nose. The nose gear collapsed after encountering a soft spot on the runway.Mar 28, 1982 · N81573 · Substantial damage NTSB ATL81IA039Incident · No injuriesClosedPiper PA-31 · Baltimore, MDJan 28, 1981 · N400RA · 2 aircraft · Minor damage NTSB IAD78IA080Incident · No injuriesClosedPiper PA-31 · Baltimore, MDJul 13, 1978 · N66892 · Minor damage NTSB IAD78FA035Accident · Serious injuriesClosedPiper PA-32R · Laurel, MDJan 22, 1978 · N5420F · Destroyed NTSB IAD77IA037Incident · No injuriesClosedPiper PA-32R · Forest Hills, MDApr 20, 1977 · N4505X · Minor damage NTSB IAD76II010Incident · No injuriesClosedPiper PA-31 · Baltimore, MDAug 27, 1975 · N66873 · No damage NTSB IAD75FIA18Accident · Serious injuriesClosedBellanca 1731TC · Waldorf, MDMar 23, 1975 · N7330V · Substantial damage NTSB IAD74FIG07Accident · No injuriesClosedPiper PA-24 · Edgewater, MDAug 13, 1973 · N9209P · Substantial damage NTSB IAD73FIG27Accident · No injuriesClosedPiper PA-24 · Baltimore, MDJun 4, 1973 · N8975P · Substantial damage NTSB DIA67D0099Accident · No injuriesClosedPiper PA-24 · Aberdeen, MDMay 19, 1967 · N9006P · Substantial damage