Ongoing NTSB investigations: Lycoming 0-290 series

7 cases on aircraft whose registry engine model is Lycoming 0-290 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

20262026

Ongoing NTSB investigations: Lycoming 0-290 series per year, 2026–2026: 7 cases
2026	7

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 ('41506')) 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 ('41506'))
  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 ('41506'))
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 WPR26LA350Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Salem, ORSep 20, 2026 · N4139M · Substantial damage NTSB ANC26LA093Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 · Beluga, AKAug 29, 2026 · N15XX · Substantial damage NTSB WPR26LA288Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-20 · Reno, NVAug 2, 2026 · N7626K · Substantial damage NTSB CEN26FA267Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Zodiak 601 HDS · Sioux City, IAOn July 24, 2026, about 1422 central daylight time, a Zenith Zodiac 601HDS experimental airplane, N27601, was destroyed when it was involved in an accident near Sioux City, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jul 24, 2026 · N27601 · Destroyed NTSB ANC26LA064Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 105 · Chena, AKJun 23, 2026 · N7506K · Substantial damage NTSB ANC26LA017Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 · Waialua, HIMar 3, 2026 · N1532V · Substantial damage NTSB CEN26FA126Accident · 1 fatalClass 3 · FieldPreliminary reportPeck JODEL-F12 · Rogers, AROn February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code…Feb 26, 2026 · N30P · Destroyed