NTSB investigations: Lycoming IO-390-C3B6
6 cases on aircraft whose registry engine model is Lycoming IO-390-C3B6, where the defining event was Loss of control in flight. 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
| 2020 | 1 |
|---|---|
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 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 ('42710')
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\" = '240'))
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 ('42710')
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" = '240'))
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 CEN26LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Sherman, TXThe pilot's failure to maintain airplane control during recovery from a bounced landing.NTSB ERA24LA224Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lagrangeville, NYThe pilot’s failure to maintain control of the airplane during the landing and subsequent go-around attempt. Also causal was the flight instructor’s delayed remedial action.NTSB CEN24LA159Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Chesterfield, MOThe student pilot’s failure to maintain control during takeoff. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA24LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Pahokee, FLThe flight instructor’s failure to maintain control of the airplane after encountering a wind gust during landing.NTSB WPR23FA027Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR20 · San Diego, CAThe student pilot’s exceedance of the critical angle of attack during a go-around, resulting in an aerodynamic stall and impact with terrain following a non-stabilized approach to land.NTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.