NTSB investigations: Lycoming IO-320 series
9 cases on aircraft whose registry engine model is Lycoming IO-320 series, where the defining event was Sys/Comp malf/fail (non-power). 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 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 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\" = '330'))
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" = '330'))
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 WPR24LA275Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Concord, CAThe failure of the main landing gear to extend and lock for reasons that could not be determined based on the available information. Contributing to the accident was a mechanical failure of the manual landing gear release mechanism due to inadequate clearance…NTSB WPR24LA061Accident · No injuriesClass 3 · LimitedFinal reportGlasair SH2 · Prescott, AZLoss of directional control during landing due to an improperly constructed and maintained tailwheel locking assembly.NTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.NTSB CEN18LA271Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Lexington, TXThe fatigue failure of the main landing gear (MLG) truss, which resulted in the MLG spreading apart.NTSB ERA14LA178Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Bay St Louis, MSA sudden fuel leak, which resulted in a postlanding fire; the origin of the leak could not be determined due to fire damage.NTSB CEN13LA231Accident · No injuriesLimited investigationFinal reportNeedham Stoddard-Hamilton TD · Bloomington, INThe improper installation of a rudder control cable connector and its subsequent separation from the bellcrank, which resulted in the loss of directional control during takeoff.NTSB WPR12LA366Accident · No injuriesLimited investigationFinal reportPiper PA-30 B · Scappoose, ORThe failure of the landing gear to fully extend as a result of a failure of the landing gear transmission assembly for reasons that could not be determined based on the available evidence.NTSB ERA11CA396Accident · No injuriesData collectionFinal reportPiper PA-30 · Plant City, FLThe failure of a screw in the nose landing gear aligner assembly for undetermined reasons, which prevented the landing gear from fully extending.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.