Ongoing NTSB investigations: Lycoming 0-540 series

5 cases on aircraft whose registry engine model is Lycoming 0-540 series, where the defining event was Loss of engine power (total). 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

20252026

Ongoing NTSB investigations: Lycoming 0-540 series per year, 2025–2026: 5 cases
2025	1
2026	4

Where

Open the map

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."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '341')) 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.\"completionStatus\" = 'Ongoing'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341'))
  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."completionStatus" = 'Ongoing'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41532')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '341'))
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 CEN27LA019Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Cedar Rapids, IAOn October 18, 2026, about 2015 central daylight time, a Piper PA-28-235 airplane, N8759W, was substantially damaged when it was involved in an accident near Cedar Rapids, Iowa. The flight instructor and student pilot were not injured. The airplane was…Oct 19, 2026 · N8759W · Substantial damage NTSB ANC26LA096Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna R182 · Lebanon, TNOn September 1, 2026, about 1815 eastern daylight time, a Cessna R182 airplane was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…Sep 1, 2026 · N6346T · Substantial damage NTSB ERA26LA358Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Union City, OHOn August 10, 2026, about 1800eastern daylight time, a Piper PA-24-250, N6985P, was substantially damaged when it was involved in an accident near Union City, Ohio. The flight instructor and the private pilot were not injured. The airplane was operated as a…Aug 10, 2026 · N6985P · Substantial damage NTSB ANC26LA080Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-32-260 · Pinetown, NCOn August 6, 2026, about 1355 eastern daylight time, a Piper Aircraft PA-32-260 airplane, N8791E, was substantially damaged when it was involved in an accident near Pinetown, North Carolina. The private pilot and two passengers sustained minor injuries. The…Aug 6, 2026 · N8791E · Substantial damage NTSB CEN26LA042Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Castle Rock, COOn November 10, 2025, about 1815 mountain standard time, a Piper PA-28-235 airplane, N9143W, was substantially damaged when it was involved in an accident near Castle Rock, Colorado. The pilot and one passenger reported no injuries. A second passenger…Nov 11, 2025 · N9143W · Substantial damage