NTSB investigations: Lycoming I0360 series, FL
10 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1985 | 1 |
|---|---|
| 1986 | 1 |
| 1989 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2007 | 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\" = 'FL' 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 ('41515')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
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" = 'FL' 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 ('41515')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351))
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 MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.NTSB MIA04LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Ocala, FLloss of engine power due to oil starvation for undetermined reasons, resulting in an in-flight collision with a fence during a forced landing.NTSB MIA03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Sarasota, FLA loss of engine power due to the crankshaft bolt losing torque, the gear disengaging, and the engine ceasing to operate as a result of inadequate maintenance installation.NTSB ATL01LA110Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLThe improper installation of the engine vacuum pump by maintenance personnel which resulted in oil exhaustion and the subsequent loss of engine power. A factor was the none-suitable terrain.NTSB MIA96LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Boca Raton, FLthe partial loss of engine power due to the fatigue failure of the number 3 cylinder hold down studs and nut. A factor was the pilot'e evasive maneuver to avoid golphers on a golf course.NTSB MIA94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · River Ranch, FLThe improper inspection of the worn throttle linkage connection at the fuel control, which resulted in the linkage becoming disconnected from the fuel control in flight and the engine losing power. This resulted in the aircraft colliding with a ditch during a…NTSB MIA90LA016Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Apalachicola, FLBinding and subsequent failure of the #1 exhaust valve. A factor related to the accident was: the soft/wet (swampy) terrain condition in the emergency landing area.NTSB MIA89FA093Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Inverness, FLThe failure of the propeller governor oil line due to fatigue which was caused by bending damage to the line and the failure of mechanics to install support clamps on the line which caused the fatigue to propagate at a faster rate.NTSB MIA87LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Lakeland, FLThe plt stated the acft lost power and he was unable to make it to the arpt. The acft crashed in a field about 3/4 of a mile from the Lakeland arpt. Post crash examination of the eng revealed a complete failure of both magnetos, resulting in the loss of power…NTSB MIA85LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wabasso, FLInstructional flight practicing steep turns. Engine lost oil through crack in propeller governor oil line and seized. Instructor took over control and landed on a road in a sand pit. Pilot was unable to steer through an 's' turn on the road and collided with…