NTSB investigations, MA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 NYC87LA210Accident · Minor injuriesLimited investigationFinal reportBell 47G3 · Marston Mills, MAThe helicopter reached an altitude of about 50 feet when a loss of power was experienced. Immediately the pilot set up for an emergency landing and set the helicopter down. The aircraft, however, collided with the ground hard and incurred substantial damage.…NTSB NYC87LA208Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Bedford, MADuring a practice autorotation with power recovery, the rotor RPM bled off. Directional control was lost and the helicopter turned several times before hitting the ground. The helicopter rolled to the left and came to rest on its side.NTSB NYC87IA202Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Boston, MADelta flt 752, a Boeing 767, was nr the outer marker (om) on an ILS rwy 22L apch when the flt control sys sensed an uncommanded go-arnd. The acft drifted rgt of the localizer for ovr 1 min. At abt 1000' AGL, rwy 22R was sighted to the left & a normal landing…NTSB NYC87FA187Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Boston, MAThe en route portion of the flt was uneventful, except that the plt used the call sign 'N251DE' instead of 'N33670' which was the registration number of his acft. Drg arrival at Boston, he was provided radar vectors, cleared for an ILS rwy 4R apch &…NTSB NYC87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Southbridge, MADuring landing roll, a failure of a tire tube caused a flat tire and control of the aircraft was lost. When the tire was dismantled, the inner tube was found to be defective at the joint seam. Total time on the acft and tire WAS407 hrs. The acft had a 100 hr…NTSB NYC87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Tewksbury, MAThe pilot switched the fuel selector from what he thought was the left tank to both while on final approach. He then decided to make a go-around during the flare because he felt his a/s was to fast. The engine quit at 40 ft AGL during the go-around. He was…NTSB NYC87LA178Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sterling, MAWhile practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then…NTSB NYC87FA172Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Nantucket, MAThe weather at the Nantucket airport was below the prescribed minima for the ILS approach to runway 24. A blanket broadcast had been made on the air traffic frequencies that the Nantucket weather was below the minima for most users and, thereafter, the…NTSB NYC87IA167Incident · No injuriesIncident investigationFinal reportNihon YS-11 · Hyannis, MAThe YS-11 was landing with a right crosswind. The pilot said he touched down on the right main landing gear first and upon touchdown, the right main landing gear collapsed. The aircraft stayed on the runway and received minor damage. The cockpit crew of 2, 2…NTSB NYC87LA166Accident · No injuriesLimited investigationFinal reportNorth American B-25N · Stow, MAThe acft touched down hard on the grassy area 5 to 10 ft short of the rwy. The plt stated at the time that he felt and heard the hydraulic line burst in the cabin which left the aircraft without brakes. The acft failed to stop and continued to roll off the…NTSB NYC87LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Falmouth, MAAbout 10 min aft TK0F, an oil line from the governor to the prop broke, causing oil to spray over the windshield, obscuring visibility. Shortly thereafter, the eng lost pwr with the prop in shallow pitch. A forced landing was made in trees with the gear and…NTSB NYC87LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgartown, MAThe plt rprtd that after he entered the pattern to land on rwy 24, the winds rapidly shifted from a slight x-wind to more of a tail wind. Subsequently, the acft touched down long, went off the left side of the rwy, hit some bushes & nosed over. Rwy 24 was…NTSB NYC87LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Nantucket, MAThe Piper PA-23-250 attempted a go-around after crossing the threshold and observing the runway lights were not on during a night instrument approach. The pilot reported that he added full power and retracted the wing flaps. The procedure in the Piper manual…NTSB NYC87FA121Accident · Minor injuriesField investigationFinal reportCessna 402C · Hyannis, MAShortly after the initial pwr reduction drg tkof, the plt noted a partial loss of pwr in the rgt eng. He said he 'went to full power on both engines' & noted an 'extremely high' fuel flow indcn to the rgt eng. He said, 'thinking that the engine was flooding,…NTSB NYC87DNE02Accident · 1 fatalFinal reportSprague Christian Eagle II · North Adams, MAThe christian eagle was coming in for a touch and go when it sank into trees, turned around and became involved in a postcrash fire. The acft was destroyed and the plt fatally injured. A pilot who preceded the accident aircraft said the winds were gusty and…NTSB NYC87LA117Accident · Serious injuriesLimited investigationFinal reportBeech 1900 · Boston, MADuring taxi operations in preparation for a takeoff from Boston logan airport, the Beech aircraft was struck by a ground vehicle and substantially damaged.NTSB NYC87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Bedford, MADuring taxi operation in preparation for takeoff, the left main gear of the aircraft impacted an unmarked open manhole and the aircraft was substantially damaged.NTSB NYC87LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-31T · Lawrence, MAThe crew of the PA-31T cheyenne had made one missed approach and the co-pilot was calling out the altitudes to the pilot. The pilot's reply to the co-pilot was that he was just going to descend to 400 ft. the approach minimums were published for an mda of 660…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 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 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 NYC87LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Taunton, MAA student pilot allowed the aircraft to drift to the left side of the runway during landing roll. The left main gear caught a snowbank, causing the airplane to pivot counterclockwise into the snow and was substantially damaged.NTSB NYC87LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAPilot was landing after a cross country solo flight. The aircraft hit a patch of ice and the pilot lost directional control causing the aircraft to collide nose first with a snow bank. The aircraft then swung the right wing around into the snow, causing…NTSB NYC87LA058Accident · Minor injuriesLimited investigationFinal reportAgusta A109AII · So. Dartmouth, MAAgusta N300CC departed a helipad in front of claremont corp president's residence in south Dartmouth, Massachusetts. As the helicopter was hovering prior to moving forward, the tail rotor blade, s/n 124, failed. The tail rotor assembly and gearbox separated…NTSB NYC87LA057Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Marston Mills, MAThe flight was on an aerial photography mission but due to the heavy cloud cover, the aircraft returned to departure airport. The engine quit before reaching the runway and the aircraft was substantially damaged when it collided with terrain. Examination of…NTSB NYC87LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Leominster, MAThe Piper PA-28-181 departed on a cross country flight with full tanks (48 gal) according to the pilot. Enroute the pilot experienced a power loss at night after flying for 3.9 hours. The pilot landed in a residential area and struck a house on landing roll.…NTSB ATL87MA041Accident · 6 fatalMajor investigationFinal reportBeech 100 · Windsor, MADrg arr for a LOC rwy 26 apch, the plt was adzd the abyss fan marker was notamed out-of-svc. With abyss inop, min dscnt alt (mda) was 2200'. After N65TD was clrd for the apch, radar svc was terminated & the flt was clrd to adzy freq. The crew contacted UNICOM…NTSB NYC87LA036Accident · Serious injuriesLimited investigationFinal reportBoeing Stearman 75 · No.Andover, MAThree banners were laid out for pickup by two stearman aircraft. One banner was an extra. The two stearmans approached the banner pick up point as a flight of two. As the first aircraft made its pickup an extra banner became tangled with the designated pickup…NTSB NYC87LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Haverhill, MAThe student plt was on an approved solo x-counrty flt when he became lost. He attempted a landing at an arpt 10 sm away from his arpt of intended landing. Realizing he was high on his first apch, he made a go-around. While making a 360 deg turn with full…NTSB NYC87FA027Accident · Serious injuriesField investigationFinal reportPiper PA-31-325 · Mansfield, MAPiper PA-31, N200GG, was on a VFR flt to boston, MA. The PA-31 plt contacted boston TRACON & adzd he had ATIS info & would be lndg at boston. TRACON suggested a hdg & alt of 070 deg & 2500' for rwy 33R & told the plt to maint VFR. At aprx the same time, a…NTSB NYC87LA026Accident · No injuriesLimited investigationFinal reportCessna U206F · Marshfiled, MAElectrical failure occurred in flight due to an alternator belt failure. The acft landed in the grass beside the rwy and was damaged. The landing was difficult due to darkness, fog and no lights. The plt tried to use flaps but failed due to no elec power. The…NTSB NYC87LA018Accident · Minor injuriesLimited investigationFinal reportBeech E-90 · Beverly, MAThe Beech king air E-90 was observed to break out of the clouds in a steep descent, land long and run off the departure end of the 4637 ft runway. The aircraft received substantial damage and the crew of 2 and 6 passengers received minor injuries. The…NTSB NYC87LA010Accident · Serious injuriesLimited investigationFinal reportLockheed L188A · Boston, MADuring engine start number 4 engine was started. The signal was given to the ground crewman to disconnect the air start unit. The engineer thought he heard 'start number 3'. Engine number 4 was shifted up, it stabilized, and engine number 3 was started. After…NTSB NYC87LA005Accident · No injuriesLimited investigationFinal reportCessna C-150 · Plymouth, MAThe student pilot flared long during landing and the instructor initiated a go around. During a right turn away from buildings, the aircraft stalled and collided with the ground on its nose and flipped over.NTSB NYC87FA006Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Holyoke, MAThe aircraft was attempting to make a special visual flight rules arrival when it crashed into a rock face slope 2 miles east of the airport while on a easterly heading. The accident occurred over 1 hour after sunset. The pilot did not have an instrument…NTSB NYC86LA238Accident · No injuriesLimited investigationFinal reportCessna 150 · Ashburnham, MAWhile crusing at an altitude of about 3500 feet, the flight suffered fuel exhaustion and lost engine power causing the pilot to execute a forced landing in a field.NTSB NYC86FA234Accident · Serious injuriesField investigationFinal reportCessna U206F · Holoyoke, MAWhile en route at 6000 ft, the acft lost power. The plt descended through a scattered layer of clouds and made a forced landing in a grass covered field 1 1/2 miles north of barnes municipal airport, shearing off the nose gear and coming to rest inverted.…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 NYC86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Dennis Port, MAAccording to the plt, he was flying at an alt of 800 ft along the coastline during an aerial advertising flt and was switching from the right fuel tank to the left when the eng lost power. The acft was then ditched in 14 foot deep water. Post accident…NTSB NYC86LA227Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Newburyport, MAThe plt experienced a total power loss of the acft eng while practicing autorotations. The helicopter landed hard, the main rotor flexed and severed the tail boom. Post accident inspection of the helicopter revealed the fuel selector was positioned on the…NTSB NYC86LA210Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Nantucket, MAThe pilot made a precautionary landing on a beach shortly after takeoff when the engine stopped running. However during engine examination, nothing was found to determine malfunction or failure.NTSB NYC86LA204Accident · No injuriesLimited investigationFinal reportHughes 369HS · Norwood, MAThe plt was practicing an autorotation from a closed traffic pattern to the numbers on rwy 35. He rprtd that he made a normal flare & power recovery. However, as the helicopter was nosing forward out of the flare, the plt heard a noise & felt a percussion…NTSB NYC86LA187Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Boston, MAShortly after takeoff, the aircraft was unable to continue climb out. The pilot lowered the nose to level flight, however the airspeed continued to drop and the aircraft crashed. The continued drop in the airspeed was undetermined.NTSB NYC86LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Plymouth, MAShortly after takeoff, the tow was released from the glider when its nose started rising uncontrollably. The glider thencollided with the ground & was substantially damaged. The plt rprted the accident could have been avoided by more info &emphasis on the…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 NYC86LA177Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1B · Marston Mills, MAThe pilot failed to clear trees on the left side of the runway on departure, and crashed to the ground. The plt failed to file and acc report and his flt time records were not available.NTSB NYC86LA174Accident · No injuriesLimited investigationFinal reportHughes 500A · Fall River, MAThe flight encountered fog and haze during return flight to new bedford, Massachusetts. The pilot failed to maintain direction control of the helicopter and crashed into the north watuppa pond.NTSB NYC86LA164Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Marstons Mills, MAThe eng lost power as the acft was climbing thru about 60' AGL during takeoff. The plt rprtd that he was forced to turn back toward the arpt since there was a wooded area & a residential area ahead. Subsequently, the acft was extensively damaged when it crash…NTSB NYC86LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Oxford, MAThe plt rprtd he encountered a gust of wind & a wind shift during the flare to land. Subsequently, he lost directional control & the acft went off the side of the rwy, collided with a man-made pyramid of stone & rotated upside down. The plt rprtd the winds…