NTSB investigations: Lycoming I0360 SER A&C, FL
73 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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.\"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 ('41511'))
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 ('41511'))
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 ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.NTSB MIA99LA127Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Pensacola, FLThe pilot's inability to maintain directional control due to failure of the main landing gear, and partial electrical system failure for undetermined reasons.NTSB MIA98LA078Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Sarasota, FLinadequate clearance and fretting wear of the fitting/beam attachment to the angle/top beam, due to inadequate design, which resulted in fatigue and subsequent failure of the fitting/beam attachment ear.NTSB MIA97LA202Accident · 1 fatalLimited investigationFinal reportDFL Holdings Tango · Keystone, FLan in-flight loss of control for undetermined reasons.NTSB MIA96LA120Accident · No injuriesLimited investigationFinal reportMooney M20C · St Augustine, FLinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplane. A factor relating to the accident was: the lack of traffic pattern position reports from the Christian Eagle, due to the…NTSB MIA95FA175Accident · 2 fatalField investigationFinal reportMooney M20F · Cedar Key, FLContinued flight by the pilot into known adverse weather (vip level three thunderstorm). The thunderstorm was a related factor.NTSB MIA95LA056Accident · Minor injuriesLimited investigationFinal reportMooney 20J · St. Petersburg, FLThe failure of the No. 3 connecting rod bolt due to oil starvation for undetermined reasons. This resulted in a total loss of engine power, forced landing, and subsequent ditching.NTSB MIA92LA151Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics LA-4-200 · FLSubstantial damage to the airplane during Unknown phase of flight for undetermined reasons.NTSB MIA92FA118Accident · Serious injuriesField investigationFinal reportCessna 172RG · Cedar Key, FLImproper recovery from the bounced landing by the pilot-in-command, and failure to maintain directional control. Contributing to the accident was the crosswind.NTSB MIA90LA103Accident · No injuriesLimited investigationFinal reportSwing Velocity RG · Wimauma, FLDelamination of a portion of one of the wooden propeller blades at a knot, resulting in severe vibration and necessitating a forced landing.NTSB MIA90IA005Incident · No injuriesIncident investigationFinal reportMooney M20F · Pensacola, FLImproper rigging of the landing gear which resulted in an overload failure.NTSB MIA89LA087Accident · Minor injuriesLimited investigationFinal reportHarmon Velocity · Fort Lauderdale, FLThe inability of the pilot to recover from the intentional stall with an unknown c.g.NTSB MIA88LA022Accident · No injuriesLimited investigationFinal reportMooney M20F · Vero Beach, FLPlt stated that while turning final approach he believes he placed the landing gear handle in the down position and observed red gear intransit lights. He was occupied by a strong wind for the landing and never checked for a gear down and safe indication. The…NTSB MIA87LA221Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · St.Augustine, FLDuring the water takeoff run the plt's forward visibility was momentarily lost as he rotated the acft onto the step. When visibility was regained he realized that the acft was headed towards the shoreline & turned to avoid it during which the rt wing tip was…NTSB MIA87FA098Accident · No injuriesField investigationFinal reportPiper PA-34-200 · Miami, FLThe plt stated that he was on final approach & cleared to land long, when a 737 was cleared for an immediate takeoff and he was told to make s turns or whatever necessary. He slowed to land and when he was approximately 10 to 20 ft. in the air he encountered…NTSB MIA86LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Melbourne, FLThe plt stated that they were doing touch & go landings & on liftoff, the eng sputtered & lost power. She then took over the controls from the student & attempted to land on another rwy & landed hard. Post crash examination of the eng revealed that the eng…NTSB MIA86FA081Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Auburndale, FLThe plt stated that just after passing lakeland, FL, his eng RPM began to fluctuate. He selected his aux fuel tanks but the RPM continued to deteriorate. He elected to make his forced landing on a small lake but not having enough alt to turn & land into the…NTSB MIA86LA043Accident · No injuriesLimited investigationFinal reportLake LA4-200 · Homestead, FLThe plt stated that while on a flight from marco island FL, to ocean reef FL, he heard a loud bang and elected to land at Homestead general arpt. Upon landing he found the left muffler had seperated from the acft, struck the propeller and was driven through…NTSB MIA83FA093Accident · Serious injuriesField investigationFinal reportMooney M20J · Tampa, FLThe accident occurred during an instrument takeoff in IMC. The sky was obscured & visibility zero. After lift-off the acft began to settle. The plt stated he aggravated the situation by advancing down trim which was his routine to establish a 5 deg climb…NTSB MIA81FA090Accident · 1 fatalClosedMooney M20J · St.Petersburg, FLNTSB MIA80DLD77Accident · No injuriesClosedLake LA4200 · Blue Cypress, FLNTSB MIA76FLA65Accident · Minor injuriesClosedHughes 269B · Pensacola, FLNTSB MIA72FKT65Accident · No injuriesClosedMooney M20E · Boca Raton, FL