NTSB investigations: Lycoming I0360 series
78 cases on aircraft whose registry engine model is Lycoming I0360 series, where the defining event was Loss of control on ground. 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\" = '230'))
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" = '230'))
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 CEN12LA485Accident · No injuriesLimited investigationFinal reportMooney M20E · Englewood, COThe pilot's loss of directional control during landing.NTSB ERA12LA445Accident · No injuriesLimited investigationFinal reportCessna 172S · Allentown, PAThe student pilot's failure to maintain directional control during a touch-and-go takeoff, which resulted in a runway excursion and a subsequent impact with a gopher hole, and the flight instructor's inadequate supervision of the student pilot and his delayed…NTSB WPR12CA251Accident · No injuriesData collectionFinal reportCessna 172S · Bend, ORThe pilot’s inadequate crosswind correction, which resulted in a loss of airplane control and runway excursion into a berm.NTSB WPR12CA151Accident · No injuriesData collectionFinal reportLake LA-4-200 · Lake Havasu City, AZThe pilot did not maintain directional control during a water touchdown.NTSB CEN12LA214Accident · No injuriesLimited investigationFinal reportCessna 172S · Midlothian, TXThe pilot's failure to maintain directional control during the landing roll.NTSB CEN12LA198Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Bloomfield, INThe pilot's failure to land with sufficient runway remaining to stop, which resulted in an unsuccessful aborted landing, inadvertent stall, and collision with terrain.NTSB CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.NTSB ERA12CA232Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Dover, TNThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a collision with an object and a landing gear collapse during the subsequent landing.NTSB ERA12CA189Accident · No injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe student pilot’s loss of directional control during a crosswind landing.NTSB WPR11CA466Accident · Minor injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe pilot’s failure to maintain directional control during the landing rollout.NTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA11CA212Accident · No injuriesData collectionFinal reportMooney M20J · St. Petersburg, FLThe pilot’s failure to maintain directional control during a crosswind landing.NTSB WPR11LA075Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Chino, CAThe student pilot's failure to properly position the flaps for the takeoff, failure to maintain airplane control during the procedure, and the flight instructor's delayed remedial action.NTSB ERA10CA358Accident · No injuriesData collectionFinal reportCessna 172 · Fairhope, ALThe student pilot's failure to maintain directional control during a crosswind takeoff.NTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.NTSB ERA10CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Farmingdale, NYThe student pilot's failure to maintain directional control during a crosswind landing.NTSB WPR10CA266Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · St. George, UTThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.NTSB WPR10CA230Accident · No injuriesData collectionFinal reportCessna 172S · Palo Alto, CAThe student pilot's failure to maintain directional control and the certified flight instructor’s delayed response to the student pilot's loss of control during the takeoff roll.NTSB ERA10CA067Accident · No injuriesData collectionFinal reportRobert Wood Thorp T18 · Newburgh, NYThe pilot's failure to maintain directional control during the landing rollout.NTSB WPR10CA038Accident · No injuriesData collectionFinal reportMooney M20F · Palm Springs, CAThe pilot's inadequate compensation for gusty crosswind conditions and his failure to maintain directional control.NTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.NTSB ANC09CA070Accident · No injuriesData collectionFinal reportDressen Donald L Back Count · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground-loop and substantial damage to the airplane.NTSB WPR09LA298Accident · No injuriesLimited investigationFinal reportSimmons Vans RV-8A · Cameron Park, CAThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.NTSB WPR09CA233Accident · No injuriesData collectionFinal reportCessna 172R · Coeur d'Alene, IDThe student pilot's inadequate compensation for the crosswinds while landing.NTSB WPR09FA019Accident · 3 fatalField investigationFinal reportMooney M20J · Avalon, CAThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons. Contributing to the accident was the pilot's failure to abort the takeoff while sufficient runway remained to stop.NTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.NTSB SEA08CA131Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Lakeview, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Contributing to the accident was the crosswind was a factor.NTSB DEN08CA086Accident · No injuriesData collectionFinal reportMooney M20E · Erie, COThe pilot failed to maintain directional control of the airplane during the touch and go landing.