NTSB investigations: Lycoming I0360 series
82 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Hard landing”. 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 ATL98LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Summerland Key, FLthe pilot's inadequate compensation for the wind conditions and failure to flare the airplane for landing. The gusty crosswind was a related factor.NTSB MIA97LA238Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Kissimmee, FLa hard landing resulting in a wing contacting the runway. A factor in this accident was the nose landing gear would not extend due to the steering ball being off its track.NTSB CHI97LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Auburn, INan improper flare by either this pilot or the pilot of a previous flight, which resulted in a hard landing and overload damage to the right main landing gear. The pilot's continued operation with a known deficiency may have been a related factor.NTSB CHI97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Mackinac Island, MIthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing. Turbulence on short final was a related factor.NTSB SEA97LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Pocatello, IDinadequate remedial action of the pilot-in-command (CFI). Related factors include: the dual student's failure to maintain the proper airspeed and descent rate.NTSB CHI96LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Chesterfield, MOimproper flare by the dual student during the landing, and delayed remedial action by the flight instructor (CFI).NTSB FTW96LA375Accident · No injuriesLimited investigationFinal reportHughes 269B · Frisco, TXThe pilot's improper touchdown procedure.NTSB NYC95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westminister, MDthe failure of the flight instructor to take timely remedial action during an approach, resulting in an inadvertent stall, hard landing and subsequent collapse of the landing gear. A factor related to the accident was the flight instructor's lack of…NTSB BFO94LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Willimantic, CTThe instructor's inadequate supervision and the student's improper landing flare.NTSB CHI93LA277Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIThe pilot's inadequate preflight planning for determining the proper takeoff profile. A factor in the accident was the high density altitude.NTSB LAX93LA049Accident · No injuriesLimited investigationFinal reportMooney M20J · Santa Ana, CAThe pilot's improper landing flare, his improper bounced landing recovery technique, and his inadvertent entry into a stall mush condition.NTSB BFO92LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Middle Bass, OHInadequate flare which resulted in a hard landing.NTSB BFO92LA139Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Shelbyville, KYAn improper flare made by the pilot resulting in a hard landing and main rotor blade tail boom strike.NTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.NTSB LAX92FA196Accident · 2 fatalField investigationFinal reportBeech A23-24 · Corona, CA1) The flying pilot's improper landing flare which resulted in a hard landing and significant damage to the aircraft empennage flight controls, 2) the flying pilot's decision to initiate a go around with the obvious serious damage to the aircraft, and 3) the…NTSB FTW91LA041Accident · No injuriesLimited investigationFinal reportHughes 269C · Knowles, OKThe pilot's failure to maintain a proper descent rate during the maneuver and his delay in initiating the go-around.NTSB CHI90LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roseville, ILMisjudged flare for landing, an improper recovery from a bounced landing, and his failure to maintain directional control.NTSB DEN90LA165Accident · No injuriesLimited investigationFinal reportBeech B-24-R · Cheyenne Wells, COThe pilot's improper recovery from a bounced landing. A factor was the pilot's failure to compensate for the existing cross wind.NTSB ANC90FA047Accident · No injuriesField investigationFinal reportde Havilland DHC-6 · Chevak, AKImproper flare by the pilot (PIC) during the landing/flare. The weather condition with fog was a related factor.NTSB MIA88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Daytona Beach, FLWhile practicing short field landings, the student plt flared the acft prematurely resulting in a hard landing & substantial damage. The acft was then taxied to the ramp.NTSB ATL88LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, KYDuring a dual instructional flight the student leveled the acft abv the rwy during the landing flare. The CFI told the FAA inspector that he was verbally coaching the student and did not assume the flt controls. The acft landed hard and the student applied…NTSB NYC87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Marlboro, MAThe pilot allowed the aircraft to stall and touch down hard causing substantial damage. The pilot was unfamiliar with the short field at this airport.NTSB CHI85LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ephriam, WIThe aircraft began drifting to the right during the landing flare. As the aircraft touched down the right wheel entered an area of slush. The aircraft then slid off the runway to the right into a snowbank, damaging the landing gear and left wing tip. The…NTSB NYC84LA213Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Monongahela, PAThe certified flt instructor (CFI) stated that he was giving multiengine instruction. All basic single and multi- engine maneuvers had been completed. The CFI reduced the pwr on one engine to simulate a single engine landing. The CFI stated that a normal…NTSB ATL84LA196Accident · No injuriesLimited investigationFinal reportMooney M20E · Seale, ALThe plt approached downwind at 80 mph with full flaps. At touchdown the acft bounced and floated about 600 ft before a 2nd touchdown. When the acft could not be stopped on the short grass rwy, it was groundlooped to stay on the arpt. During the groundloop the…NTSB ATL84FIA02Accident · No injuriesFinal reportPiper PA-28R-180 · Manassas, VAThe plt reported that during a night landing, the right main gear failed & the acft went off the right side of the rwy. An FAA investigator reported that the acft had touched down hard during the landing.NTSB FTW84LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Brenham, TXThe pilot, accompanied by three passengers, landed hard, bounced and last control of the acft, which continued into a stock tank/pond. Examination revealed all three main gear assemblies were collapsed and both left and right wing assemblies were damaged.NTSB LAX83LA283Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Prescott, AZThe cross country flt was made later than the pilot intended. The pilot had never landed this model acft on a dark night at a high density alt arpt. The pilot reported that things were happening a lot faster than he was accustomed to. By the time he saw the…NTSB CHI83LA193Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Schaumburg, ILThe rated student was on an instructional flt to become a helicopter instructor plt. During an autorotative landing in a farmer's field, the helicopter landed hard & the main rotor hit the tail cone.NTSB ATL82DKM07Accident · No injuriesFinal reportHughes 269C · Marshville, NCThe instructor pilot (ip) and the student (a private, single engine land, pilot) were on a dual instructional flight. After completing several hover autorotations and hovering patterns, the ip took control. He positioned the helicopter for an autorotation…NTSB CHI82FA350Accident · 2 fatalField investigationFinal reportMooney M20E · Houghton, MIThe acft crashed into trees while making an ILS approach to Houghton county memorial arpt, hancock, MI. The weather was IMC and an IFR flt plan had been filed. The two occupants were held in the acft by seat belts and were fatally injured in the crash and…NTSB CHI82DA165Accident · No injuriesFinal reportPiper PA-28R · Stow, OHThe instructor pilot and his student, a rated private pilot, were on a flight to provide dual instruction for a commercial pilot certificate. A landing approach was made to a runway with a slight downslope in the touchdown area. The instructor estimated that…