NTSB investigations: Lycoming 0-320 series, MA
232 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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\" = 'MA' 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 ('41508'))
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" = 'MA' 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 ('41508'))
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 NYC96LA068Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, MAthe flight instructor's inadequate supervision of the flight, the pilot's improper compensation for the wind conditions, and the high wind. The instructor's inadequate evaluation of the weather was a contributing factor.NTSB NYC95LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAThe pilot's failure to maintain adequate terrain clearance, which resulted in an inflight collision with trees. Other related factors were: heavy rain, moderate turbulence, dark night, and high winds.NTSB NYC95LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grt Barrington, MAthe pilot's improper flare during landing, which resulted in a hard landing and the subsequent collapsed landing gear. A factor in this accident was the pilot's lack of total recent flying experience and recent experience in make and model.NTSB BFO94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Newburyport, MAThe pilot not maintaining clearance from the snowbank during final approach. A factor in this accident was the proximity of the snowbank to the active runway.NTSB NYC94LA010Accident · Minor injuriesLimited investigationFinal reportSchlappi RV3 · Hatfield, MAThe pilot misjudged his distance and altitude which resulted in an undershoot of the runway. A factor was his delay in intiating a go around.NTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.NTSB BFO92LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · East Taunton, MAInadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB NYC91LA236Accident · No injuriesLimited investigationFinal reportCessna 172M · Norwood, MAPremature retraction of the wing flaps during a go-around which resulted in an inadvertent stall with insufficient altitude for recovery. Factors related to the accident were: the pilot's lack of total experience in make and model, and lack of recent…NTSB NYC91LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, MAThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain in which the emergency landing was made.NTSB NYC91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taunton, MAThe pilot attempted to land in a strong cross wind, lost control of the airplane, ran off the runway and hit the VASI system.NTSB NYC90LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Lawrence, MAThe pilot's improper use of flight controls, resulting in loss of control.NTSB NYC88LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mansfield, MAThe acft, with a CFI and student on board, had just made a touch and go landing and was about one mile fm the arpt, climbing to cruise, when the eng lost power. It was dark and the pilot attempted a landing on a state highway. The acft collided with a traffic…NTSB NYC88LA210Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ashburnham, MAA student pilot and flight instructor were making a practice pinnacle approach. The student pilot tried to terminate the descent, but was unable and a landing on rough terrain took place. The helicopter rolled over and received substantial damage but the two…NTSB NYC88LA129Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Dracut, MAThe pilot said that while making a normal approach for a 'glassy water' landing on a lake, he flared high and stalled the airplane. The right wing dropped off and the airplane crashed into the water.NTSB NYC88LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Southbridge, MADuring takeoff from Southbridge airport, the aircraft encountered a crosswind. The aircraft started drifting to the right even though full left aileron and full power were being applied. The pilot cut the power to abort the takeoff, and the aircraft impacted…NTSB NYC88LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe aircraft was taxiing from a shop on the airport to runway 24 for a south end departure. The pilot stated that the left wing of the aircraft made contact with the parked truck causing substantial damage.NTSB NYC88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norfolk, MAThe pilot of the Cessna 172 was making her third takeoff, having made two prior takeoffs and landings to a full stop, when she experienced a loss of power. The aircraft ran off the departure end of the runway and was observed to porpoise several times prior…NTSB NYC88LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Bedford, MAA Cessna 172, N97313, and a Beech C23, N6718Z, collided in flt as the plts of both acft were arriving to land on rwy 11 at hanscom field. The Cessna plt had planned to land at beverly, MA, but diverted to hansom field due to wx. The Cessna was in a left turn…NTSB NYC87LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Stow, MAThe pilot was on takeoff roll when he decided to abort. He stated that he felt the engine was not developing adequate power and the airspeed was not up to required takeoff speed. The aircraft continued off the end of the runway and inverted in swampy soil.NTSB NYC87FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-28-161 · Nantucket, MAThe Piper PA-28-161 with a pilot and passenger onboard disappeared from the radar scope while being vectored to an ILS approach to rwy 24 at Nantucket, MA. The controller observed the aircraft in a southeasterly heading and asked the tower controller to…NTSB NYC87LA221Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · N. Andover, MAThe aircraft lost power shortly after takeoff. The instructor pilot took control and due to the lack of altitude decided to land the acft straight ahead. The aircraft was landed on the grass beside the runway. Teardown of the engine revealed a stuck valve.…NTSB NYC87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Oxford, MAThe plt rprtd that drg a lndg, the acft enctrd a gust of wind & veered into a ground loop before he could correct the situation. The acft then hit a snowbank at the side of the rwy & was damaged. The plt rprtd the wind was from 300 deg at 12 gusting 15 KTS.NTSB NYC87LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Beverly, MAStudent pilot became lost and disoriented during enroute flight to the manchester area and landed at Beverly airport instead. During landing roll, the aircraft drifted to the left of the runway and collided with a snowbank, breaking off the nose gear and…NTSB NYC87LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawrence, MADuring a simulated engine out, the aircraft collided with power lines, while climbing out after descending over a possible landing area. The aircraft was able to continue flight and land at bedford, Massachusetts without further incident.NTSB NYC86LA233Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sterling, MAOn a student pilot's third solo supervised flight, the pilot placed the throttle in detent, became confused, and autorotated into trees.NTSB NYC86LA179Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newburyport, MAPilot made a precautionary landing after experiencing a rudder control failure after a banner pick up. The left aft rudder cable had parted 49.5 inches aft of the rudder pedal attachment point.NTSB NYC86LA120Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Plymouth, MAThe acft touched down on a grass landing area and the nose gear collapsed. The acft appeared to have touched down between a crossing runway and taxiway, both of which are asphalt. There is a depression, aprx 18-24 inches deep, that the acft crossed. Wrinkles…NTSB ATL86MA114Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Holliston, MAThe Cessna 172 and a Bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the Bell was traveling in a…NTSB NYC86LA013Accident · No injuriesLimited investigationFinal reportRobinson R22A · Sterling, MAThe accident occurred when the CFI allowed the student who was in a hover maneuver to lose rotor RPM. The helicopter drift rearward, the left rear skid dug into the ground and the helicopter rolled over. RPM decayed so badly that the helicopter could not…NTSB NYC85LA242Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Ware, MAThe student plt and CFI were practicing full stop night landings when the accident occurred. While on final apch for thefourth landing, the acft collided with trees 1.7 NM short of the rwy.NTSB NYC85LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Chatham, MADuring the final approach to runway 24, the aircraft was too high and fast. The pilot decided to land on the runway instead of going around. According to the pilot, the aircraft landed too FAR down the runway and went over the end.NTSB NYC85LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Stow, MAPlt stated that after a normal crosswind touchdown, the tail section did not drop as expected, but rose and veered left. Acft swerved and flipped inverted.NTSB NYC85FA019Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Beverly, MADuring an approach to land at night, the acft crashed & burned about 3000 ft from the approach end of the rwy. The non-instrument rated plt had been in contact with approach control. He indicated that IFR conditions existed over the arpt & that he was going…NTSB NYC84LA279Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Nantucket, MAPlt entered the pattern for landing and was advised of a cross-wind situation. Plt was unfamiliar with the airport and requested a full pattern circuit to observe conditions. On lndg flare with full flaps and left cross-wind correction input, a gust carried…NTSB NYC84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Beverly, MAThe acft made a forced landing after the engine vibrated and lost power. The plt said that the fuel gages were checked and indicated 1/4 full. The plt said he switched fuel tanks but the engine did not improve its performance. The plt thenaccomplished the…NTSB NYC84FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Nantucket, MAThe acft disappeared after departing on the return leg of a x-country. The plt had called the operator at the home base and reported that IMC weather existed for the return. The plt was informed that the acft was not needed and he did not need to hurry back.…NTSB NYC84LA235Accident · No injuriesLimited investigationFinal reportPiper PA-23 · No. Andover, MAThe acft lost power at about 200 ft AGL during takeoff. The plt feathered the right engine and then elected to land on the remaining rwy when the left engine lost power. The acft went off the rwys end with brakes locked. When the acft was examined by FAA…NTSB NYC84LA196Accident · No injuriesLimited investigationFinal reportCessna 172 · Orleans, MAShortly after level off the pilot stated that the engine began to run roughly. All emergency procedures were followed and a precautionary landing was made on the beach. As the acft touched down and rolled out, the nose wheel dug into the sand and the aircraft…NTSB NYC84LA197Accident · No injuriesLimited investigationFinal reportCessna C172 · Mansfield, MAStudent plt on first solo landed hard due to late flare. The acft touched down on the nose gear resulting in substantialdamage. A go-around was accomplished followed by an uneventful landing.NTSB NYC84LA162Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Muskeget Island, MAThe acft was unable to clear trees during the initial takeoff climb. The plt raised the nose of the acft and the acft stalled contacted the trees.NTSB NYC84LA122Accident · No injuriesLimited investigationFinal reportCessna 172M · Fitchburg, MADuring a touch-&-go landing, the student plt lost directional control. The acft landed slightly sideways on the right main gear & the right wing tip hit the ground. The right wing, prop, eng mount & nose gear were damaged.NTSB NYC84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Lawrence, MAAs the plt completed his landing, he let the acft roll-out to the intersection of rwys 32 & 23 where he intended to turn off the active rwy. He reported that when he came to the intersection, the right gear 'collapsed' (retracted) & the acft skidded to the…NTSB NYC84FNE01Accident · Minor injuriesFinal reportPiper PA-28-151 · Southwick, MAThe acft lost power & made an emergency forced landing in a school yard. Investigation revealed that only a few drops offuel remained in the powerplant & 1QT plus 1PT remained in the wing tanks with none in the gasolator. There was no evidence of fuel leakage…NTSB NYC84LA050Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC Citabria · Nantucket, MAThe acft experienced a power loss and crashed during a low pass to observe an object on the ground. The flt had departednantucket and flown over to tuckernuck isl where a descent was made to observe an unusual object on a shoal. Carburetor heat was applied…NTSB NYC83FNE02Accident · Serious injuriesFinal reportPiper PA-28-140 · Oxford, MADuring a go-around, the eng began losing power, & subsequently, the plt elected to make a forced landing in an open field. However, before landing, the acft collided with an electric wire, then crashed. An investigation revealed some maintenance…NTSB NYC82DA212Accident · No injuriesFinal reportPiper PA-28-140 · Norwood, MAThe student pilot was on a local flight and returned to the airport to practice landings. Just prior to touchdown on his second touch-and-go, the nose went to the right. Left rudder was applied to re-align the aircraft to the centerline of the runway. At…NTSB NYC82DA194Accident · No injuriesFinal reportCessna 172M · Marlboro, MAThe solo student was practicing landings, flared the aircraft too high, then stalled and made a hard landing. The nose gear collapsed and the aircraft nosed over.NTSB NYC82FA175Accident · 1 fatalField investigationFinal reportBeech B19 · South Yarmouth, MAThe acft stalled & impacted trees as the plt was buzzing a residence at 150-200 ft above the tree tops.NTSB NYC82DA149Accident · No injuriesFinal reportBellanca 7GCBC · North Adams, MAThe pilot reported that during the landing roll-out, the aircraft had slowed to about 20 mph when it started to veer slightly to the left. He stated that a slight right rudder and brake correction was made and the plane veered to the right. Reportedly, he was…NTSB NYC82FNA14Accident · 1 fatalFinal reportThurston Teal TSC-1A · Methuen, MAThe pilot was practicing takeoffs and landings on a river in an amphibian aircraft. After a landing, the pilot commenceda high speed taxi takeoff. When violent shaking started the pilot reduced power, pulled back the stick, and landed. The aircraft nosed…