NTSB investigations: Lycoming IO-320 series
9 cases on aircraft whose registry engine model is Lycoming IO-320 series, where the defining event was Landing gear collapse. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2024 | 1 |
| 2026 | 1 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509')
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\" = '094'))
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 ('41509')
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" = '094'))
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 WPR26LA107Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-30 · Big Bear, CAOn February 23, 2026, at 1800 Pacific standard time, a Piper PA-30, N811LE, was substantially damaged when it was involved in an accident near Big Bear, California. The pilot and passenger were not injured. The airplane was operated as a 14 Code of Federal…NTSB CEN25LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · New Orleans, LAThe failure of a landing gear torque arm which resulted in a landing gear collapse and runway excursion.NTSB WPR20LA252Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Salem, ORA fatigue failure of the right main landing gear trunnion.NTSB ERA18LA171Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Vero Beach, FLThe collapse of all three landing gear for reasons that could not be determined because postaccident examination of the landing gear system revealed no evidence of any mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN12LA204Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Roanoke, TXThe pilot’s failure to follow the published emergency procedures to lower the landing gear following a loss of electrical power.NTSB WPR11LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rialto, CAFatigue cracking of the left main landing gear leg, which resulted in a gear collapse during landing.NTSB ERA10CA183Accident · No injuriesData collectionFinal reportPiper PA-30 · Baltimore, MDThe pilot's inadvertent retraction of the landing gear during a touch-and-go landing. Contributing to the accident was the pilot's lack of recent experience in the make and model airplane.NTSB WPR09LA372Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Walla Walla, WAA tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing. Contributing to the accident was the disabled landing gear warning horn.NTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.