NTSB investigations: Lycoming I0360 SER A&C, LA
9 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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
| 2003 | 1 |
|---|---|
| 2011 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2020 | 1 |
| 2021 | 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.\"eventStateOrRegion\" = 'LA' 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 ('41511'))
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" = 'LA' 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 ('41511'))
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 CEN26LA236Accident · No injuriesClass 4 · LimitedFinal reportBeech C24R · Baton Rouge, LAThe pilot’s failure to extend the landing gear before landing.NTSB CEN24LA211Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Chandeleur Island, LAA fatigue failure of the engine oil pressure line, which resulted in the loss of engine oil during the flight and subsequent damage to the nose landing gear support structure during the precautionary landing.NTSB CEN21LA268Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Saint James, LAThe in-flight fatigue failure of an air-conditioning system hose which resulted in a precautionary landing and impact with a road sign.NTSB CEN20CA195Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Houma, LAThe pilot's failure to maintain adequate clearance from a ground obstacle during landing.NTSB CEN18FA030Accident · 1 fatalField investigationFinal reportTemco GC 1B · Pineville, LAThe loss of engine power due to fuel starvation, which resulted from the unporting of the fuel during a right turn due to the auxiliary fuel tanks' improper configuration.NTSB OPS17IA021IncidentClass 3 · IncidentFinal reportCessna 172S · New Orleans, LAThe air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.NTSB GAA16CA131Accident · No injuriesData collectionFinal reportFoxworthy Roy Christen Eagle · Bell City, LAThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a runway excursion and a nose over.NTSB CEN12LA076Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · New Orleans, LAA loss of engine power due to detonation of the No.2 cylinder from a clogged fuel injector nozzle.NTSB FTW03LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · New Orleans, LAThe loss of engine power as a result of the separation of the magneto assembly due to inadequate maintenance by unknown personnel. A contributing factor was the lack of suitable terrain for the forced landing.