Ongoing NTSB investigations: Lycoming 0-320 series

5 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Loss of control in flight. 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-320 series per year, 2025–2026: 5 cases
2025	2
2026	3

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 ('41508') 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" = '240')) 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 ('41508')
      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\" = '240'))
  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 ('41508')
    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" = '240'))
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 ERA26FA338Accident · 1 fatalClass 3 · FieldPreliminary reportReed Julian Estill RV-4 · Albertville, ALOn September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…Sep 15, 2026 · N469TW · Substantial damage NTSB ERA26LA159Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172M · Lakeland, FLOn April 05, 2026, at 0007 eastern daylight time, a Cessna 172M airplane, N61972, was substantially damaged when it was involved in an accident near Lakeland, Florida. The pilot and certified flight instructor (CFI) rated passenger were uninjured. The…Apr 5, 2026 · N61972 · Substantial damage NTSB CEN26FA093Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-140 · Holly Springs, MSOn January 18, 2026, about 1640 central standard time, a Piper PA28-140 airplane, N6711J, was destroyed when it was involved in an accident near Holly Springs, Mississippi. The flight instructor and student pilot were fatally injured. The airplane was…Jan 18, 2026 · N6711J · Destroyed NTSB CEN26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · New Orleans, LAOn November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was…Nov 25, 2025 · N80FP · Destroyed NTSB ANC25LA060Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-22-150 · Chinitna Bay, AKOn June 30, 2025, about 1630 Alaska daylight time, a Piper PA 22-150 airplane, N3609Z, was substantially damaged when it was involved in an accident near Chinitna Bay, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Jul 1, 2025 · N3609Z · Substantial damage