Ongoing NTSB investigations: Lycoming 0-320 series
15 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Loss of engine power (partial). 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.
Cases per year
| 2025 | 5 |
|---|---|
| 2026 | 10 |
Where
Open the mapLatest cases
Query with SQL
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\" = '342'))
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" = '342'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN27LA029Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28 · Claremore, OKOn October 22, 2026, about 1510 central daylight time, a Piper PA-28-160 airplane, N5393W, was substantially damaged when it was involved in an accident near Claremore, Oklahoma. The flight instructor and student pilot were not injured. The airplane was…NTSB CEN26LA322Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172M · Hanover, INOn September 16, 2026, about 1905 eastern daylight time, a Cessna 172M airplane, N9909Q, was substantially damaged when it was involved in an accident near Hanover, Indiana. The pilot and passenger sustained minor injuries. The airplane was operated as a…NTSB ERA26LA342Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Panama City, FLOn September 7, 2026, about 1059 central daylight time, a Cessna 172N airplane, N734NM, was substantially damaged when it was involved in an accident near Panama City, Florida. The student pilot and flight instructor were not injured. The airplane was…NTSB ERA26LA319Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA22 · Pace, FLOn August 29, 2026, about 1030 central daylight time, a Piper PA-22-150, N5731D, was substantially damaged when it was involved in an accident near Pace, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA26LA221Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Pembroke Pines, FLOn May 29, 2026, at 1138 eastern daylight time, a Cessna 172P, N96100, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor sustained serious injuries. The student pilot sustained minor injuries.…NTSB WPR26LA190Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Chandler, AZOn May 14, 2026, at 2043 mountain standard time, a Piper PA-28, N8714N, was substantially damaged when it was involved in an accident near Chandler, Arizona. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA132Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · West Valley City, UTOn March 21, 2026, about 1610 mountain daylight time, a Piper PA-28-140, N7328J, was substantially damaged when it was involved in an accident near West Valley City, Utah. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…NTSB CEN26LA143Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172P · Denton, TXOn March 20, 2026, about 1415 central daylight time, a Cessna 172P airplane, N65614, was substantially damaged when it was involved in an accident near Denton, Texas. The pilot sustained minor injuries, and the pilot-rated sensor operator sustained serious…NTSB ERA26LA144Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Indian Trail, NCOn March 8, 2026, about 1100 eastern daylight time, a Piper PA-28-140, N98360, was substantially damaged when it was involved in an accident near Indian Trail, North Carolina. The pilot and passenger were seriously injured. The airplane was operated as a…NTSB WPR26FA119Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-28-140 · Phoenix, AZOn March 4, 2026, about 0721 mountain standard time, a Piper PA-28-140, N7744T, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor was seriously injured, and the student pilot and one person on the…NTSB ERA26LA046Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Palm Bay, FLOn November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB ERA26LA007Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Miami, FLOn October 07, 2025, at 1440 eastern daylight time, a Cessna 172M, N433PT, was substantially damaged when it was involved in an accident near Miami, Florida. The private pilot and the flight instructor were uninjured. The airplane was operated as a Title 14…NTSB CEN26LA006Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · McGregor, MNOn October 5, 2025, about 1310 central daylight time, a Piper PA-28-140, N4218T was substantially damaged when it was involved in an accident near McGregor, Minnesota. The pilot and two passengers were seriously injured. The airplane was operated under the…NTSB ERA25LA302Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172 · Titusville, FLOn August 15, 2025, about 1415 eastern daylight time, a Cessna 172, N7205Q, was substantially damaged when it was involved in an accident near Titusville, Florida. The pilot was seriously injured and the flight instructor received minor injuries. The airplane…NTSB CEN25LA096Accident · Minor injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. AA-5A · Gladewater, TXOn February 17, 2025, about 2215 central standard time, a Grumman AA-5A airplane, N26071, was substantially damaged when it was involved in an accident near Gladewater, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…