NTSB investigations: Lycoming AEIO-360 series, VA

5 cases on aircraft whose registry engine model is Lycoming AEIO-360 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

19782026

NTSB investigations: Lycoming AEIO-360 series, VA per year, 1978–2026: 5 cases
1978	1
1980	1
1983	1
1997	1
2011	1

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" = 'VA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601')) 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\" = 'VA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601'))
  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" = 'VA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601'))
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 ERA11CA488Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Leesburg, VAThe pilot did not follow the engine start checklist.Sep 10, 2011 · N878AC · Substantial damage NTSB IAD97LA058Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Warrenton, VAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The crosswind was a related factor.Mar 28, 1997 · N1118E · Substantial damage NTSB ATL83LA371Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Saluda, VAThe acft landed off the rwy and cartwheeled into the tiedown area after the plt lost control during landing. The plt said the wind shifted while he was on final approach. He compensated with power and rudder but does not recall his airspeed. The acft snapped…Sep 15, 1983 · N5070N · Substantial damage NTSB ATL80DIA13Accident · No injuriesClosedBellanca 8KCAB · Washington, VAAug 9, 1980 · N5044U · Substantial damage NTSB IAD78FID18Accident · Serious injuriesClosedBellanca 8KCAB · Norfolk, VAAug 6, 1978 · N5537K · 2 aircraft · Destroyed