NTSB investigations: Lycoming AEIO-360 series

8 cases on aircraft whose registry engine model is Lycoming AEIO-360 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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

19832026

NTSB investigations: Lycoming AEIO-360 series per year, 1983–2026: 8 cases
1983	1
1991	1
1992	1
1996	1
1997	1
2000	1
2003	1
2006	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 ATL06CA125Accident · No injuriesData collectionFinal reportBrown Floyd L Christen Eagle II · Topsail Beach, NCThe in-flight separation of the engine and propeller from the airframe for undetermined reasons, which resulted in the airplane's uncontrolled impact with water.Sep 3, 2006 · N225FL · Substantial damage NTSB SEA03LA145Accident · No injuriesLimited investigationFinal reportAndelin S1E · Troutdale, ORThe pilot's inability to maintain directional control due to an obstruction of the left brake line by foreign material resulting in asymmetrical braking.Jul 16, 2003 · N732E · Substantial damage NTSB FTW00LA254Accident · No injuriesLimited investigationFinal reportAbernathy Streaker · Sherman, TXThe failure of the wing skin and the rear spar while performing aerobatics, which resulted in the restricted movement of the aileron.Sep 5, 2000 · N1LM · Substantial damage NTSB FTW97LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Laporte, TXThe pilot's diminished ability to maintain control of the airplane due to a jammed elevator control as result of inadequate maintenance procedures by the operator's mechanic.Jan 15, 1997 · N5062P · Substantial damage NTSB ATL96LA120Accident · No injuriesLimited investigationFinal reportGreat Lakes GL2T-1A-2 · Montgomery, ALThe locked rudder in a fully deflected position which resulted in the pilot's inability to maintain directional control.Aug 17, 1996 · N47L · Substantial damage NTSB LAX92LA118Accident · Minor injuriesLimited investigationFinal reportAvions Mudry CAP-10B · Santa Paula, CAThe failure of the airplanes's left wing spar due to stress overloading caused by pre-existing compression failures in the laminate.Feb 15, 1992 · N64ND · Destroyed NTSB CHI91DEP08Accident · 1 fatalFinal reportJack Thomas Pitts S-IT · Kenosha, WIImproper maintenance, by person or persons unknown, to the elevator control system which allowed a bolt attaching the elevator control rod to the pitch bellcrank to become disconnected during flight.Jun 16, 1991 · N83AM · Destroyed NTSB FTW83FA424Accident · 1 fatalField investigationFinal reportPartenavia P68C · Plainview, TXThe plt was executing a high speed pass over the rwy at about 250 ft AGL. The plt then began a rapid pull-up & both wings separated just outboard of the eng nacelles. Reconstruction of the sequence from a videotape revealed that the acft's speed at the time…Sep 11, 1983 · N29561 · Destroyed