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 NYC89LA019Accident · Minor injuriesLimited investigationFinal reportBeech 60 · Norwood, MAThe pilot had just climbed to 2500 feet when the right engine started to sputter. When he placed the fuel selector in crossfeed, both engines quit. The pilot elected to land in a field leading to substantial damage to the nose, wings, and tail section of the…NTSB NYC89LA018Accident · Minor injuriesLimited investigationFinal reportSchweizer 1-35C · Methuen, MAPilot uncontrolled contact with a tree during a landing after the pilot failed to connect his aileron controls and accepted a tow to get airborne.NTSB NYC88FA236Accident · 2 fatalField investigationFinal reportCessna 172N · Adams, MAPilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper.NTSB NYC88DNA02Accident · Serious injuriesFinal reportDillinger Long E-Z · Lawrence, MAThe plt depd provincetown on a rtrn flt to his home arpt at aprx 0230 EDT & arrived at his destn about 1 hr later. He rprtd he was unable to activate the plt-ctld rwy lights. He checked the lighted wind sock & decided the night was bright & clear enough to…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 NYC88LA220Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Lakeville, MAAccording to the acft owner, N9022L'S fuel tanks were only one quarter full of fuel when the plt took off. The pax said that after about an hour of flying the engine began to run roughly and then it finally quit. The plt made an unsuccessful forced landing.…NTSB NYC88LA213Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Plymouth, MAThe acft was taking off on a hard packed, grassy area beside a paved rwy with a 12 kt headwind. After the tail was raised, and at a point 900 ft from the beginning of the roll, the acft suddenly nosed over. Examination of the broken right main landing gear…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 NYC88LA195Accident · No injuriesLimited investigationFinal reportCessna 177RG · Canton, MADuring initial climb from takeoff, the engine lost total power and an emergency landing was made on a highway. The left wing and horizontal stabilizer struck a guardrail when the pilot was maneuvering to avoid a truck. A post-crash inspection of the engine…NTSB NYC88FA181Accident · 1 fatalField investigationFinal reportCessna 421 · Taunton, MABfr rchg his destn, the plt adzd apch ctl that his rgt eng was 'blowing some smoke' & losing oil pressure. Vectors were provided for a visual apch, but there were low clouds in the area & vis was restricted due to haze. After reaching the vcnty of the arpt,…NTSB NYC88LA201Accident · No injuriesLimited investigationFinal reportBell 206B · Plymouth, MAA loss of power to the engine because the fuel control was not properly adjusted and collision with terrain due to an unsuitable landing area.NTSB NYC88LA170Accident · Serious injuriesLimited investigationFinal reportBell 47J2 · Newburyport, MAThe helicopter departed runway 10 at plum island airport, turned left over the plum island river and shortly thereafter the engine quit. The pilot stated that no warning was noted and a check of the instruments indicated no problems. He further stated that…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 NYC88LA123Accident · No injuriesLimited investigationFinal reportCessna 185 · Hopedale, MAThe pilot said he flared too high and landed hard. The pilot stated that the prop contacted the ground, the right landing gear broke, and the rt wing contacted the ground and was bent rearward during the hard landing. The plt did not file an acc report.NTSB DCA88IA044Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Boston, MAThe improper installation of the battery ground connection that resulted in premature loosening of the connection and electrical arc ignition of pooled fuel in the cac bilge. The fuel was not drained overboard due to inoperative cac bilge area drain valves.…NTSB NYC88LA105Accident · Minor injuriesLimited investigationFinal reportBell 206B · Agawam, MAThe pilot was on approach to landing from the south at about 2,000 yards from his pad. Speed was about 65 knots and was about 500 feet from the ground when the pilot said he had a flashback and doesn't remember what happened, the helicopter rolled over while…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 NYC88LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Plymouth, MAThe pilot of the PA-24 said everything was normal until he switched fuel tanks and turned on the boost pump. He said a power loss followed. He was unable to get the engine restarted prior to making an off airport landing. A witness in the aircraft said the…NTSB NYC88LA081Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Chatham, MAAfter aborting two landings on runway 24 at Chatham, Massachusetts, the pilot was advised by radio to use runway 6. While attempting a landing on runway 6, the airplane touched down short of the runway and the landing gear was sheared off when it struck a…NTSB NYC88LA091Accident · No injuriesLimited investigationFinal reportCessna 303 · Hyannis, MAThe Cessna 303 broke out of the clouds and made a long landing on a 5567 ft runway. Tire marks showed that the aircraft touched down with less than 2000 ft of runway remaining. The landing runway was 24 and the winds were from 360 degrees at 8 KTS. The runway…NTSB NYC88LA075Accident · No injuriesLimited investigationFinal reportCessna 402C · Provincetown, MAThe Cessna 402C was being positioned for a scheduled commuter flight with only a pilot on board. The pilot made an ILS approach to runway 7 with winds from 220 degrees at 14 knots, the runway wet and light rain falling. The aircraft slid off the end of the…NTSB NYC88LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Mendon, MAOff airport landing due to engine power loss for undetermined reasons.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 NYC88LA059Accident · 1 fatalLimited investigationFinal reportCessna 170A · Sandwich, MAThe Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…NTSB NYC88LA047Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · E.Harwich Port, MAThe pilot departed chatham airport for a local pleasure flight. Shortly after takeoff and while turning left in the pattern, the engine suffered a power loss. The pilot prepared for an emergency landing and transmitted a 'may day'. The aircraft crashed in a…NTSB NYC88LA044Accident · Minor injuriesLimited investigationFinal reportBell 206B · Beverly, MAThe helicopter was on a normal approach to Beverly airport and was cleared to cross runway 27 from the southeast. The pilot entered an autorotation but realized that the ground was under construction and was very muddy. In an attempt to shift directions at…NTSB NYC88LA038Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Tewksbury, MAThe student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…NTSB NYC88LA034Accident · No injuriesLimited investigationFinal reportCessna 170B · Shirley, MADuring final approach to runway 19 at Shirley, Massachusetts the aircraft rolled inverted. Pilot was able to correct and bring the aircraft upright but did not have enough altitude to clear trees. He set the aircraft into the trees and the wing folded back.NTSB NYC88LA035Accident · No injuriesLimited investigationFinal reportCessna U206F · New Bedford, MAThe Cessna U206F was taking off from a harbor. After becoming airborne it experienced a 40 knot airspeed loss. The plt stated that he was unable to maintain altitude and was forced to land on a beach. The acft flipped ovr after a pontoon caught a rock. A…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 NYC88LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Marlboro, MAThe pilot was attempting a landing at Marlboro airport. Upon touchdown brakes were applied. According to the pilot, the aircraft was not stopping but instead was sliding down the runway. The pilot turned the nosewheel to the left to slow the aircraft but…NTSB NYC88LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chatham, MAThe duration of the pleasure flight was about 25 minutes and was uneventful. The pilot made the approach and entered the traffic pattern in the standard manner and radioed UNICOM of her intentions to land. The pilot stated that she landed longer than usual…NTSB NYC88LA016Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Barre, MAThe aircraft was in the traffic pattern when it experienced a power loss. The plt made an off-airport landing in a wooded area. The pilot reported that he was in a slip prior to and at the time of the reported power loss. The FAA reported that the engine…NTSB NYC88LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Pepperell, MAA student pilot on a cross country training flight experienced fuel exhaustion at about 3500 feet. The pilot stated that when the engine lost power he contacted approach control on 121.5 but did not have sufficient altitude to make it to an airport. The…NTSB NYC88LA014Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Mansfield, MAThe Schweizer SGS-2-33A was in the traffic pattern with a student pilot and flight instructor. In the right turn from base to final, the nose dropped and control was lost. The flight instructor took control of the aircraft, and regained control, however,…NTSB NYC88LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Beverly, MAThe plt rprtd that drg an NDB apch, the acft 'broke out slightly above minimums' & that he maneuvered to land from a close-in, base leg. He stated that drg a left turn to final apch, the left eng began losing power. Rprtdly, there was a lack of response to…NTSB NYC88LA011Accident · No injuriesLimited investigationFinal reportCessna 402B · Nantucket, MAThe plt rprtd that drg an apch to rwy 6 at dusk, a sudden sink rate developed. He applied power & brought the acft to a climb attitude; however, he felt a 'thud beneath the aircraft' & noted that the right main gear light no longer indicated down & locked.…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 NYC88FA005Accident · 2 fatalField investigationFinal reportCessna 150H · Gardner, MAWhile executing tough-and-go landings, the pilot neglected to partially raise the wing flaps, as recommended in the owners manual, before lifting off. Thereafter, the pilot failed to maintain a safe airspeed for the landing configuration and inadvertently…NTSB NYC88LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Weston, MADrg a night arrival, when the acft was apchg the boston tca, the plt dscndd to 1000 ft. as he was leveling off, he noted a power loss & was unable to reach the destn arpt. He identified a field & initiated an emerg landing. Drg the apch, the acft struck power…NTSB NYC88LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Mansfield, MAAccording to the plt, the winds were from the south-southwest at 15 to 20 KTS. He rprtd that drg the landing roll on rwy 22, he applied full right rudder against the prevailing wind, but the acft veered left with the application of brakes. Subsequently, it…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 NYC87LA261Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Fitchburg, MADrg arrival, the plt was clrd for an ndb-a apch to Fitchburg muni arpt. The NDB was located on the arpt & the arpt elev was 350'. The min dscnt alt (mda) was 1140' MSL. The apch procedure was to go outbnd fm the NDB on a 137 deg bearing, make a procedure…NTSB NYC87FA251Accident · 2 fatalField investigationFinal reportCessna 152 · Boxborough, MAThe IFR flight from auburn-lewiston, Maine to the manchester, new hampshire VORTAC facility was without incident. Boston center cleared the flight for the vor/dme instrument approach procedure to runway 21 at the uncontrolled stow/minute man airport, stow,…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 NYC87FA272Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Martha Vineyard, MAThe plt was involved in commerical fishing operations as a spotter and to direct the closing of nets around schools of tuna. While directing the closing of a net, the fish being netted reversed course and started to escape from the open net. The plt dove at a…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 NYC87LA217Accident · No injuriesLimited investigationFinal reportRobinson R22 · Sterling, MABefore flying solo, the student plt & his instructor (CFI) practiced autorotations for about 1/2 hr. The CFI deplaned & the student took off on a solo flt. He flew to a reservoir area for more practice. After descending from about 1000' to 500', the eng lost…NTSB NYC87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18S · Brewster, MAThe instructor (CFI) said that shortly after takeoff, the student was given a simulated power failure. At aprx 75' AGL, the student initiated a steep turn to head into the wind, which terminated in nearly a 90 deg heading change. The CFI stated the wind was…NTSB NYC87LA220Accident · No injuriesLimited investigationFinal reportAerospatiale AS350D · Nantucket, MAThe flight was enroute from Nantucket to hyannis when the pilot heard a loud bang followed by a severe vibration, loss of power to the main rotor system, and a loss of hydraulic pressure. The helicopter made an autorotative landing in water about 25 feet in…