Skip to content

Ongoing NTSB investigations: Lycoming 0-235 series

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

20252026

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."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 ('41505')) 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 ('41505'))
  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 ('41505'))
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 CEN26LA330Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 152 · Bolingbrook, ILOn September 29, 2026, about 1828 central daylight time, a Cessna 152 II airplane, N69009, sustained substantial damage when it was involved in an accident near Bolingbrook, Illinois. The flight instructor and the student pilot sustained minor injuries. The…Sep 29, 2026 · N69009 · Substantial damage NTSB WPR26LA332Accident · No injuriesClass 4 · LimitedInvestigation openCessna 152 · Carlsbad, CASep 4, 2026 · N5447L · Substantial damage NTSB WPR26LA316Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Bemidji, MNAug 21, 2026 · N7524H · Substantial damage NTSB ERA26LA283Accident · Serious injuriesClass 3 · LimitedPreliminary reportAmerican AA-1 · Kearneysville, WVOn July 23, 2026, at 1440 eastern daylight time, an American AA-1, N6132L, was substantially damaged when it was involved in an accident near Kearneysville, West Virginia. The pilot and pilot-rated passenger were seriously injured. The airplane was being…Jul 23, 2026 · N6132L · Substantial damage NTSB ANC26LA075Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 152 · Pell City, ALOn July 20, 2026, at 1030 eastern daylight time, a Cessna 152 airplane was substantially damaged when it was involved in an accident near Pell City, Alabama. The flight instructor and student pilot were not injured. The airplane was operated as a Title 14…Jul 20, 2026 · N103UC · Substantial damage NTSB ANC26LA059Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-12 · North Pole, AKJun 21, 2026 · N2586M · Substantial damage NTSB CEN26LA208Accident · Minor injuriesClass 3 · LimitedPreliminary reportAmerican AA-1A · Amery, WIOn May 30, 2026, about 1113 central daylight time, a Grumman AA-1A airplane, N6416L, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…May 30, 2026 · N6416L · Substantial damage NTSB ANC26LA042Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-14 · Nenana, AKMay 18, 2026 · N5184H · Substantial damage NTSB WPR26LA133Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · West Linn, OROn March 18, 2026, about 1700 Pacific daylight time, a Piper PA-12, N7632H, was substantially damaged when it was involved in an accident near West Linn, Oregon. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…Mar 19, 2026 · N7632H · Substantial damage NTSB CEN26LA137Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Lockhart, TXOn March 7, 2026, about 1323 central standard time, a Piper PA-12, N2511M, was substantially damaged when it was involved in an accident near Lockhart, Texas. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…Mar 7, 2026 · N2511M · Substantial damage NTSB WPR26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportAmerican AA-1A · High Rolls, NMOn November 26, 2025, about 1145 mountain standard time, an American Aviation AA-1A airplane, N9439L was destroyed when it was involved in an accident near Alamogordo, New Mexico. The pilot and passenger were fatally injured. The airplane was operated as a…Nov 26, 2025 · N9439L · Destroyed NTSB WPR26LA030Accident · Serious injuriesClass 3 · LimitedPreliminary reportRutan Long-EZ · Long Beach, CAOn October 20, 2025, about 1603 Pacific daylight time, an experimental amateur-built Rutan Long-EZ, N8183K, was substantially damaged when it was involved in an accident in Long Beach, California. The pilot was seriously injured, and a pedestrian on the…Oct 20, 2025 · N8183K · Substantial damage NTSB ERA25LA300Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Inverness, FLOn August 14, 2025, about 1915 easter daylight time, a Piper-PA12, N4014M, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The private pilot sustained serious injuries, and the passenger received a minor injury. The…Aug 14, 2025 · N4014M · Substantial damage NTSB ERA25LA297Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Ponce Inlet, FLOn August 11, 2024, about 1359 easter daylight time, a Piper PA-12, N2504M, was substantially damaged when it was involved in an accident near Ponce Inlet, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…Aug 11, 2025 · N2504M · Substantial damage NTSB WPR25FA233Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 152 · Hornell, NYOn August 1, 2025, about 1859 eastern daylight time, a Cessna 152, N6125B was destroyed when it was involved in an accident near Hornell, New York. The student pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…Aug 1, 2025 · N6125B · Destroyed NTSB ERA25FA283Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J5C · Rochester, NYOn August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was…Aug 1, 2025 · N28151 · Substantial damage