Ongoing NTSB investigations: Lycoming 0-320 series, CA

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

20232026

Ongoing NTSB investigations: Lycoming 0-320 series, CA per year, 2023–2026: 8 cases
2023	1
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND 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')) 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\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND 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'))
  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" = 'CA' AND c."eventCountry" = 'USA'
  AND 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'))
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 WPR27LA009Accident · Serious injuriesLimited investigationInvestigation openCessna 172N · Knights Landing, CAOct 1, 2026 · N75513 NTSB WPR26FA330Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · San Diego, CAOn September 7, 2026, about 1720 Pacific daylight time, a Cessna 172N, N734ZK, was destroyed when it was involved in an accident near San Diego, California. The flight instructor and student pilot were fatally injured. The airplane was being operated as a…Sep 8, 2026 · N734ZK · Destroyed NTSB WPR26FA329Accident · 4 fatalClass 3 · FieldPreliminary reportGrumman American Avn. AA-5 · Fresno, CAOn September 5, 2026, about 1345 Pacific daylight time, a Grumman AA-5, N6510L, was destroyed when it was involved in an accident near Fresno, California. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…Sep 5, 2026 · N6510L · Destroyed NTSB WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CAAug 16, 2026 · N7526G · Substantial damage NTSB WPR26LA269Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-161 · San Bernardino, CAOn July 18, 2026, about 1530 Pacific daylight time, a Piper PA-28-161, N8249B, was substantially damaged when it was involved in an accident near San Bernardino, California. The pilot and pilot rated passenger were not injured. The airplane was operated as a…Jul 18, 2026 · N8249B · Substantial damage NTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…Jul 16, 2026 · N98GB · Substantial damage NTSB WPR26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · Oroville, CAOn February 28, 2026, about 0948 Pacific standard time, a Piper PA-22-150, N3170Z, was destroyed when it was involved in an accident near Oroville, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Feb 28, 2026 · N3170Z · Destroyed NTSB WPR24LA032IncidentClass 3 · LimitedInvestigation openBeech 23 · Santa Ynez, CANov 12, 2023 · N2358Z