NTSB investigations: Lycoming IO-360-L2A, KS
9 cases on aircraft whose registry engine model is Lycoming IO-360-L2A. 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
| 2005 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2022 | 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\" = 'KS' 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 ('41597'))
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" = 'KS' 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 ('41597'))
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 CEN26LA104Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Augusta, KSThe student pilot’s failure to maintain control during the takeoff.NTSB CEN23LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Olathe, KSThe inflight collision with multiple geese during initial climb.NTSB CEN21LA066Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Lawrence, KSThe student pilot’s improper landing flare/touchdown which resulted in a hard landing.NTSB GAA17CA351Accident · No injuriesData collectionFinal reportCessna 172 · Lawrence, KSThe student pilot's incorrect control application during landing after a simulated engine failure, which resulted in a hard, bounced landing, and the flight instructor's delayed action to perform a go-around in gusting wind conditions.NTSB CEN12CA342Accident · No injuriesData collectionFinal reportCessna 172S · Fort Scott, KSThe student pilot’s loss of directional control during the landing roll. Contributing to the accident was the student pilot’s diverted attention to retract the flaps.NTSB CEN11CA100Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot’s non-stabilized approach and improper landing flare, which resulted in a hard landing.NTSB CEN10CA163Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSThe student pilot's failure to maintain an appropriate glide path during approach. Contributing to the accident was the student pilot's decision to continue the approach instead of going around.NTSB CEN09LA182Accident · No injuriesLimited investigationFinal reportCessna 172N · Johnson County Exec Airport, KSFailure of the pilot of the Cessna 172S to ensure the taxiway was clear prior to initiating the turn. Contributing to the accident was the failure of the pilot of the Cessna 172N to obtain taxi clearance prior to entering the movement area.NTSB DEN06CA022Accident · No injuriesData collectionFinal reportCessna 172S · Lawrence, KSthe student pilot's improper decision to continue taxiing through the field. Contributing factor's include student pilot's failure to maintain control during the takeoff roll and the drainage ditch masked by snow.