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 NYC86FNA01Accident · No injuriesFinal reportSteen Skybolt UNK · Beverly, MAThe Steen Skybolt modified with a turbo-prop conversion experienced a power loss on takeoff after achieving an altitude of 200-300 ft AGL and made a hard landing on the runway remaining. The landing gear collapsed and aircraft received substantial damage. The…NTSB NYC86LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Palmer, MAThe acft climbed in an excessively nose high attitude upon rotation at 60 mph. It then veered left and settled to the left side of the rwy. The plt reduced the power to idle and applied braked. The acft continued to slide and collided with trees. The acft was…NTSB NYC86MA148Accident · 4 fatalMajor investigationFinal reportSikorsky S-76B · Sutton, MAAbout 16 min after takeoff, while cruising at 6000' MSL in IMC, the plt transmitted 'Sikorsky 507' (call sign of acft hefrequently flew). The ATC ctlr was talking to another flt & did not respond. About 1 min later, rdo & radar contact werelost & the…NTSB NYC86LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Pittsfield, MAThe student pilot on a solo cross-country flight in a Piper cherokee PA-28-140 became lost and attempted a landing at another airport. The weather was 500 ft broken, 1000 ft overcast. Visibility 8 miles and rain showers. On his first approach, the aircraft…NTSB NYC86FA216Accident · 3 fatalField investigationFinal reportBell 206B · Noman'S Land, MAThe Bell 206 helicopter was en route to nantocket island when the pilot received an inflight weather briefing with VFR flight not recommended. The pilot acknowledged this report and it appears he elected to continue the flight. The acft did not reach it's…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 NYC86LA118Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Mt. Graylock, MAThe pilot was practicing simulated cross country passes on a ridge at an altitude of 150 ft AGL on the windward side of a ridge in a Schweizer sgs 1-26 sailplane. The pilot encountered a roll condition from which he lost control, was unable to recover and…NTSB NYC86LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Marshfield, MAThe student pilot was making touch and go's on runway 24 in a Piper tomahawk. The wind was from the north west at 12 knots. The pilots reported the wing rose and the aircraft drifted left with a gust. He stated he applied power for a go-around, however the…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 NYC86LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Pittsfield, MAThe Cessna 152 was making a touch and go. The student pilot reported the landing was good and when he applied power, the aircraft veered left off the runway, struck a ditch and flipped over. The pilot was uninjured and the aircraft received substantial…NTSB NYC86IA093Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · Boston, MATwo of 3 reqd flt attendants (f/a's) were distributing passenger (pax) coats as the acft was being taxied after lndg. Smoke fm an overheated air cond (a/c) pack bgn entering the cabin & the f/a's returned to their duty stations. The flt crew stopped the acft…NTSB NYC86LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Newburyport, MAWhile taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over.NTSB NYC86LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Pepperell, MAAfter descending to traffic pattern altitude. The throttle was advanced with no response from the engine. On flare to landing, pilot experienced sun glare, drifted to the right, and touched down in a snow bank. Nose gear dug in and aircraft flipped over onto…NTSB NYC86LA069Accident · Serious injuriesLimited investigationFinal reportCessna 402 · New Bedford, MAThe plt experienced inadequate l eng manifold pres during a tkf attempt at newport. The tkf was aborted and afterwards the plt decided to ferry the acft to New Bedford for inspection. The eng were restarted and operation was good. The flt to New Bedford was…NTSB NYC86FA068Accident · 1 fatalField investigationFinal reportBeech E55 · Sunderland, MAWitnesses reported seeing the acft descend vertically in a flat spin until impact in open, flat terrain. The accident occurred aprx 45 min after the plt had taken off on a local proficiency flt. After impact, most of the airframe was demolished by fire. The…NTSB NYC86LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Boston, MAThe pilot was attempting to start the aircraft for a cross country flight. The weather was cold. Initially. The pilot stated the engine started but stopped. The pilot pulled key from ignition, pulled back throttle and closed the mixture before exiting the…NTSB DCA86AA011Accident · No injuriesFinal reportBoeing 747-136 · Boston, MAAprx 16 ft of the left inboard trailing edge flap separated while the acft was on final apch to land. The apch and landing were completed without further incident. Investigation revealed 5 of the 8 bolts which hold the no. 3 flap trackforward attach fitting…NTSB NYC86FA049Accident · 1 fatalField investigationFinal reportCessna 340A · Peru, MADuring IFR flight at 12000 feet both aircraft vacuum pumps failed. Aircraft descended in right turn off radar. Witnesses observed aircraft at low altitude above trees, circle, make steep left turn, climb and descend to ground.NTSB NYC86LA042Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries WW-24 · Worcester, MAAccording to the pilot, the flight was normal, upon touchdown the reversers were deployed, pilot had information that braking action was poor and rwy was icy but had been sanded, pilot landed on the left side of the rwy centerline aircraft began to drift…NTSB NYC86LA044Accident · Minor injuriesLimited investigationFinal reportPiper Aztec · North Adams, MAThe flight departed albany new york under VFR conditions and picked up IFR clearance to pittsfield, MA. The pilot flew the approach until reaching VFR under a cloud layer at about 2500 ft. continuing VFR toward no. Adams at an altitude of 2000 ft, the pilot…NTSB NYC86FNE01Accident · No injuriesFinal reportDorfman,William A. Bede 4/275 · Westfield, MAThe aircraft collided with the ground off to the side of the runway during a takeoff attempt. The nose gear and the main gear collapsed during the ground contact. The wind blew the aircraft to the side with a wing raised and before recovery as effected the…NTSB NYC86LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe plt stated a gust of wind was encountered when the acft was 5 ft from touchdown. The gust turned the acft 90 degs from the rwy heading. The plt applied pwr to avoid trees but was unsuccessful and a collision with the trees occurred. Winds were reportedly…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 NYC86LA008Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Norwood, MAAccording to the pilot, during the takeoff climb the aircraft did not develop sufficient power to maintain altitude. The pilot turned the aircraft to the right in an attempt to return to the airport. During the approach to the airport, the aircraft collided…NTSB NYC86LA007Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Sterling, MAThe acft contacted trees while making an apch to rwy 34 at Sterling, Massachusetts. The acft crashed about 100 ft short of the rwy. The plt stated that a severe downdraft was encountered and then a rapid rate of descent followed. The left main gear struck…NTSB NYC85LA249Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5B · Manchester, MAPlt stated that during cruise flight at an altitude of 1200 ft the engine RPM decreaseed from cruise setting to between 900-1100 RPM. The acft was overwater and 2 miles from the coastline. He was unable to maintain altitude and he started a descent toward…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 NYC85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Provincetown, MAPlt experience eng pwr loss during tke climb at a height of about 350 ft. the plt headed toward a beach and ditched about 50 yards offshore in order to avoid crowd. The acft submerged underwater afterwards. Examination of the acft disclosed leadlike…NTSB NYC85FNA03Accident · Serious injuriesFinal reportPiper PA-28-151 · Newburyport, MAThe pilot attempted a landing at night with an inoperative landing light and no runway lights. After circling the airport 3 or 4 times he attempted a landing. The aircraft received substantial damage and the pilot received serious injuries. The passenger…NTSB NYC85LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Lawrence, MAAfter refueling the acft, the plt attempted to start the eng with the throttle full open and the mixture at idle cut off. The instructor thought the eng was vapor locked and was going to drain the gascolator when he noticed a fire in the carburetor airbox.…NTSB NYC85LA193Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Worcester, MAThe instructor (CFI) & student were practicing touch-&-go landings. On the 4th landing, the apch & touchdown were made with full flaps extended. The CFI began to retract the flaps while the student applied full power for takeoff. The acft became airborne &…NTSB NYC85LA191Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Plymouth, MAThe aircraft was towed to an alt of 3000 ft. the plt set up for landing and entered the pattern at the initial point at about 1200 ft. the apch went normally until the base leg. After turning onto the base leg, the plt experienced a high sink rate. The plt…NTSB NYC85FA185Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Fall River, MAWitnesses observed the acft execute an aerial pick up of the aerial advertising banner & climb very steeply away from the ground. Normal eng sounds were reported by the witnesses. The acft was observed to climb to an alt of approx 150 ft, nearly come to a…NTSB NYC85LA184Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Nantucket, MAThe acft was observed in a medium left bank turning through a south southwest heading as it appeared from the clouds. The acft continued to descend in that attitude until it collided with the trees about 3.5 miles southeast of the arpt. The plt and passenger…NTSB NYC85LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Provincetown, MADuring arrival, the acft was vectored for an ILS rwy 7 apch which was made with a tail wind. On his 1st attempt, the plt made a missed apch & was vectored for another ILS. After making a 2nd apch, he landed. The plt stated that while he was landing, he…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 NYC85LA194Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Savoy, MAThe pilot was attempting to land on a dirt runway approximately 800 feet long with a small dirt embankment at the threshold. During the approach, the aircraft landed short and the landing gear collided with the embankment. The aircraft nosed over and came to…NTSB NYC85FA163Accident · No injuriesField investigationFinal reportMitsubishi MU-2B-26 · Southbridge, MADuring lndg the acft impacted hard and skidded down the rwy before it went off the left side of the rwy. The left main wheel separted and the nose gear collapsed. Both plts stated the lndg apch was normal until the acft was aprx 15 ftabove the rwy at which…NTSB NYC85FA260Incident · Serious injuriesField investigationFinal reportDouglas DC-9 · Boston, MAThe acft was climbing out of 10000 ft, shortly after tkf, when the PIC lost consciousness. The copilot took control of the flight and returned to Boston where a lndg occured without incident. Medical examination of the PIC revealed that he suffered a heart…NTSB NYC85LA066Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Norfolk, MAThe acft was unintentionally landed with the gear retracted. A CFI and a pvt plt were on board at the time of the accident. The pvt plt in the left seat was flying the acft and on the third landing failed to extend the gear. The CFI in the right seat was…NTSB NYC85FNA02Accident · Serious injuriesFinal reportMcpherson Evans VP-1 · Boxborough, MAThe pilot experienced an engine failure and allowed the airspeed to decrease until the aircraft stalled and spun to the ground. The cause of the engine failure was not determined. The pilot received serious injuries and the homebuilt aircraft received…NTSB NYC85LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Newbury, MAAccording to a passenger, after a long ground roll, the acft lifted off and the plt attempted to increase airspeed by lowering the pitch attitude. As the acft approached the end of the rwy and trees, the stall warning horn sounded. The plt again attempted to…NTSB NYC85FNA01Accident · Serious injuriesFinal reportGulfstream AA-5B · Boxborough, MAThe pilot made six attempts at landing with a left crosswind of 24 knots. On the last attempt he was observed to lose control and crash into the trees off he departure end of the runway. The aircraft burnded and the pilot received serious injuries.NTSB NYC85LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Hancock, MAThe acft was under contract to the Massachusetts state environmental department. It was being used for aerial observation of forest fires & for the disposition of ground fire fighting personel & equipment. The plt reported that while he was attempting to find…NTSB NYC85LA124Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Stow, MAPiper PA28-181N82054 landed hard on runway 3 at minute man airport, Stow, mass. The student was performing touch and go landings, on one landing, the pilot stated that the aircraft bounced and then veered to the left. Rudder was applied but there was no…NTSB NYC85LA116Accident · No injuriesLimited investigationFinal reportCentrair 101A · Barre, MAThe acft encountered windshear during the approach to land and landed in trees. By the time the plt realized his situation it was too late and his wing tip hit a tree top. The acft camp to rest in trees.NTSB NYC85LA107Accident · No injuriesLimited investigationFinal reportBeech D95A · Boston, MAAccording to the plt, the gear warning horn circuit breaker was pulled en route to stop the horn from sounding while the pwr was at a low setting because of turbulence. The circuit breaker was not reset prior to landing. During the apch,the plt lowered the…NTSB NYC85LA095Accident · No injuriesLimited investigationFinal reportLet L-13 · Mansfield, MAThe plt reported that he turned onto final apch at about 500 ft AGL & the pattern was normal until he was about 1/3 mi from the rwy threshold. The glider then began to sink rapidly. The plt realized that he would be unable to glide to the rwy, so he decided…NTSB NYC85FA099Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Nantucket, MAAcft collided with trees during final approach to runway 24. No evidence of pre-impact failure or malfunction of the acft was found. Reported wx at crash site indefinite 100 feet sky obscured. RVR 2400 feet. Acft should have encountered a decreasing headwind…NTSB NYC85LA096Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsfield, MADuring a preflt wx briefing, the plt was advised of possible moderate icing in clouds from the surface to 4000 ft. while in flt, structural icing conditions were encountered & rime ice accumulated on the windshield. Also, carb ice conditions were encountered…