NTSB investigations: Lycoming I0360 series
72 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, newest first
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.\"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."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 CEN12CA402Accident · No injuriesData collectionFinal reportSchweizer TH55A/269A · Grinnell, IAThe pilot’s inadequate compensation for the wind during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.NTSB CEN12LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Arcola, TXThe pilot did not maintain adequate crosswind correction during the landing flare and the flight instructor's delayed remedial action.NTSB CEN12FA170Accident · 2 fatalField investigationFinal reportMooney M20E · San Antonio, TXThe pilot's inadvertent overboost of the turbocharged engine during initial climb, which resulted in detonation and a partial loss of engine power followed by the pilot's failure to maintain airspeed and the instructor's delayed remedial action, which…NTSB CEN12FA083Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Crystal Lake, ILThe noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.NTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.NTSB WPR11FA242Accident · 4 fatalField investigationFinal reportCessna 172R · Wendover, UTThe pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…NTSB CEN11CA331Accident · Minor injuriesData collectionFinal reportCessna 172R · Fort Worth, TXThe student pilot's improper recovery from the bounced landing and the flight instructor's delayed remedial action.NTSB ERA11LA229Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ridgely, MDThe pilot receiving instruction's inadequate compensation for the wind during landing and delay in executing a go-around, which resulted in a loss of airspeed, low final approach, and subsequent collision with the ground short of the runway. Contributing to…NTSB CEN11FA125Accident · 1 fatalField investigationFinal reportBeech C24R · Wheeling, ILThe installation of the wrong engine-driven fuel pump, which resulted in a loss of engine power during takeoff, and the pilot's subsequent decision to turn back toward the airport at an insufficient altitude to complete the maneuver. Contributing to the…NTSB CEN11FA124Accident · 2 fatalField investigationFinal reportMooney M20E · Colorado Springs, COThe pilot’s decision to initiate an approach into weather conditions where the ceiling and visibility were below the minimums for the approach and where reported icing existed, in an airplane not certified for flight in icing conditions, and his failure to…NTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.NTSB ERA10FA359Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · North Myrtle Beach, SCThe pilot's failure to maintain aircraft control while maneuvering in instrument meteorological conditions around a thunderstorm. Contributing to the accident was the pilot's lack of recent actual instrument experience.NTSB WPR10LA208Accident · Minor injuriesLimited investigationFinal reportBibbee Cozy Mark IV · North Las Vegas, NVThe airplane's inability to recover from a stall due to the builder's failure to comply with design specifications and update the pilot’s operating handbook, which would have highlighted the discrepancies in the airplane's build-up.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…NTSB WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.NTSB MIA08CA179Accident · No injuriesData collectionFinal reportCessna 172SP · South Harpswell, METhe pilot's failure to maintain control of the airplane while landing in gusty winds.NTSB NYC08CA277Accident · Minor injuriesData collectionFinal reportMooney M20F · Ridgeland, SCThe pilot's inadequate compensation for a crosswind during landing. A factor contributing to the accident was the crosswind.NTSB DEN08LA124Accident · 1 fatalLimited investigationFinal reportAerotek Pitts S-2A · Cleveland, TXthe pilot's failure to maintain aircraft control during his attempted performance of aerobatic maneuvers shortly after takeoff.NTSB DFW08CA171Accident · Minor injuriesData collectionFinal reportMooney M20 · Lake Ft Gibson, OKThe pilot's loss of control while maneuvering the aircraft.NTSB CHI08CA164Accident · Minor injuriesData collectionFinal reportHughes 269B · Cook, MNThe pilot not maintaining tail rotor effectiveness while turning in cruise.NTSB CHI08LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Wrightsville, GAThe pilot's failure to maintain control during takeoff. Contributing to the accident were the gusty winds.NTSB CHI08CA116Accident · Minor injuriesData collectionFinal reportMooney M20J · Howell, MIThe inadvertent stall and low airspeed while maneuvering back to the departure airport after the baggage door opened in flight. An additional cause was the plot's diverted attention to the opening of the baggage door.