NTSB investigations: Lycoming I0360 series, FL
7 cases on aircraft whose registry engine model is Lycoming I0360 series, 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
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2023 | 2 |
Where
Latest 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_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."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_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 ERA23LA217Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Defuniak Springs, FLThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a runway excursion and impact with a berm. Contributing was the automated weather briefing which failed to include accurate wind information.NTSB ERA23FA138Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · West Palm Beach, FLThe pilots’ exceedance of the airplane’s critical angle of attack following a go-around/low pass over the runway, which resulted in a loss of control and impact with terrain.NTSB GAA18CA559Accident · No injuriesData collectionFinal reportPiper PA34 · Miami, FLThe pilot under instruction’s failure to maintain the twin-engine airplane’s minimum control airspeed with one engine inoperative and the flight instructor’s distraction when reconfiguring the airplane following the simulated engine failure, which resulted in…NTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.NTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.NTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…