Final NTSB investigations: Lycoming 0-360 series
11 cases on aircraft whose registry engine model is Lycoming 0-360 series. 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
| 1965 | 2 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1996 | 1 |
| 2017 | 2 |
| 2024 | 1 |
| 2025 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41499'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41499'))
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 ANC25LA118Accident · No injuriesClass 4 · LimitedFinal reportToci Gabe C G Supa · Palmer, AKThe pilot’s failure to maintain airplane control during the go-around.NTSB ANC24LA044Accident · No injuriesClass 4 · LimitedFinal reportJordan Harry James Sportsman 2+2 · Fairbanks, AKThe pilot’s failure to maintain directional control during the takeoff roll.NTSB WPR18FA026Accident · 1 fatalClass 2 · FieldFinal reportPiper PA 18-150 · Murphy, IDFailure of the left aileron control cable that resulted in a loss of aircraft control during takeoff. Contributing to the accident was inadequate maintenance inspections to the aileron cable connections.NTSB GAA17CA232Accident · No injuriesData collectionFinal reportCessna 172 · Houston, TXThe pilot’s delayed attempt to abort the takeoff with a tailwind, which resulted in a runway overrun.NTSB ANC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKthe pilot's premature liftoff and subsequent inadvertent stall.NTSB ATL88LA181Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1A · Blue Ridge, GAThe plt reported that he encountered deteriorating wx conditions during the flt. He made a 180 degree turn and other course changes in an attempt to return to better wx, but was unable to maintain VFR flt. He subsequently elected to make a precautionary ldg…NTSB ANC87LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe pilot stated that during a right turn on approach the aircraft stalled and crashed into the river.NTSB ANC73DAA10Accident · Serious injuriesClosedPiper PA-18 · Fairbanks, AKNTSB ANC71DAA10Accident · No injuriesClosedPiper PA-18A · Nenana, AKNTSB NYC66F0277Accident · No injuriesClosedPiper PA-28 · Amityville, NYNTSB ANC66D0003Accident · No injuriesClosedPiper PA-18A · Yentna River, AK