Fatal, Ongoing NTSB investigations: Lycoming 0-540 series
9 cases on aircraft whose registry engine model is Lycoming 0-540 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.
Cases per year
| 2025 | 4 |
|---|---|
| 2026 | 5 |
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.\"highestInjuryLevel\" = 'Fatal'
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 ('41532'))
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."highestInjuryLevel" = 'Fatal'
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 ('41532'))
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 ERA26FA252Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA24 · Hazen, NDOn June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB WPR26FA224Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Middlefield, OHOn June 20, 2026, about 1535 eastern daylight time, a Piper PA-24-250, N6403P, was substantially damaged when it was involved in an accident near Middlefield, Ohio. The pilot and two passengers sustained fatal injuries. The airplane was operated as a Title 14…NTSB ERA26FA214Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-25-235 · Saratoga Springs, NYOn May 26, 2026, about 1347 eastern daylight time, a Piper PA-25-235 airplane, N8656L, was substantially damaged when it was involved in an accident near Saratoga Springs, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR26FA151Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-32R-301T · Marana, AZOn April 08, 2026 at 1710 mountain standard time, a Piper PA-32R-301T, N4190E, sustained substantial damage when it was involved in an accident near Marana, AZ. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB ANC26FA021Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Boynton Beach, FLOn March 23, 2026, about 1221 eastern daylight time, a Robinson R44 Raven I helicopter, N478AT, was destroyed when it was involved in an accident near Boynton Beach, Florida. The flight instructor and the pilot receiving instruction were fatally injured. The…NTSB WPR26FA069Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-32-260 · Rio Linda, CAOn December 24, 2025, at approximately 1230 Pacific standard time, a Piper PA-32-260, N2785Q, was substantially damaged when it was involved in an accident near Rio Linda, California. The pilot sustained serious injuries, and the pilot-rated passenger was…NTSB CEN25FA308Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T182T · Augusta, AROn August 7, 2025, at 1037 central daylight time, a Cessna T182T airplane, N35370, was substantially damaged when it was involved in an accident near Augusta, Arkansas. The pilot was fatally injured and the passenger received minor injuries. The airplane was…NTSB CEN25FA124Accident · 1 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Danville, VAOn March 15, 2025, about 1500 eastern daylight time, a Robinson R44 helicopter, N331ES, was destroyed when it was involved in an accident near Danville, Virginia. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB WPR25FA079Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Rock Springs, WYOn January 14, 2025, about 0622 mountain standard time, a Piper PA-24-250, N6502P, was destroyed when it was involved in an accident near Rock Springs, Wyoming. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…