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 NYC85LA093Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Orange, MAThe plt reported he was flying at about 25 ft above water. As the acft crossed over a grass covered sand bar, the gear encountered 'swail grass' & the acft was 'dragged in.' The plt also reported that the acft had encountered turbulence; however, a witness…NTSB NYC85LA085Accident · No injuriesLimited investigationFinal reportBoeing JB-75 · Marston Mills, MAThe acft nosed over after contacting an utility pole during an overrun landing. The acft touched down aprx 1/2 way down the rwy and the plt applied brakes, however, braking action was poor because of the wet grass rwy. The acft skidded off the end of the rwy…NTSB NYC85LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Taunton, MAWhile approaching about 6 mi from the arpt, the eng lost power & the acft began descending toward a pond. There was a surge of power, but power was lost again. The plt stated that he brought the nose up above the trees to 'mush' the plane in rather than go…NTSB NYC85LA051Accident · No injuriesLimited investigationFinal reportBeech B58 · New Bedford, MAThe acft experienced a gear collapse during landing. During the first landing and takeoff the plt noticed the left main gear began to collapse. The takeoff was continued and two passes were performed in front of the ATC twr. Twr personnel advised that the…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 NYC85LA042Accident · Minor injuriesLimited investigationFinal reportCessna T337G · Lawrence, MAN8CF made an emergency landing in a wooded are after experiencing a dual engine failure aprx 50 minutes after takeoff./ the fuel pressure gage for the front engine displayed erratic elevated readings. The pilot then decided to return to the departure airport…NTSB NYC85LA040Accident · No injuriesLimited investigationFinal reportBeech 58TC · Norwood, MATouchdown made 1/3 the way down the wet rwy. Brakes were ineffective on wet pavement. Plt raised flaps and reapplied brakes with no positive result. Acft continued onto 60 ft overrun area where some braking action was effective however, acft continued down an…NTSB NYC85FA025Accident · 1 fatalField investigationFinal reportCessna C337 · Taunton, MAAfter departure & at an altitude of 2000 ft the plt noticed that the rear eng fuel flow was low, however, the eng was operating satisfactory. The plt, as a precaution, decided to return to the departure arpt. While returning the plt noted that there was no…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 NYC85LA011Accident · No injuriesLimited investigationFinal reportCessna 206 · Menemsha, MADuring climb out when the plt normally retracted the landing gear he was copying an IFR clearance. The gear were not retracted and upon touchdown in the pond the float acft nosed over in the 8 ft deep water.NTSB NYC84FNE07Accident · 1 fatalFinal reportFuller/Findlay Varieze · Worcester, MAWitnesses stated, after what appeared to be a longer then normal takeoff roll, acft rotated to a very steep climb angle. Estimates regarding climb angle vary from 'slightly nose up' to vertical. Acft climbed to 100-150 ft AGL and rotated to an extremely nose…NTSB NYC84FA310Accident · 2 fatalField investigationFinal reportAeronca 11AC · Newbury, MAThe student plt had logged approximately 240 hrs of flying time. He was not certificated to carry pax. Witnesses stated that they observed the acft descend at a slow airspeed to an alt of 100 ft. the acft then made a steep bank turn to the right and impacted…NTSB NYC84LA308Accident · No injuriesLimited investigationFinal reportBeech J35 · Hyannis, MAAprx 30 min after departure, according to the plt, the eng began running rough and stopped about 1 min later. The gear down forced landing was made in salt water aprx 6 mins from the dest arpt. Exam of the wreckage by FAA personnel revealed that the electric…NTSB NYC84LA299Accident · No injuriesLimited investigationFinal reportBeech A23A · Mansfield, MAAfter a night landing, the plt went to the end of the rwy, then started a 180 deg turn to the right onto a parallel taxiway. He intended to head the opposite direction on the taxiway, which was not lighted. As he turned, the landing light (installed on the…NTSB NYC84FNA03Accident · Serious injuriesFinal reportPiper PA-28-181 · New Bedford, MAThe rt front seat pass'g exited the acft via the rt door and went forward over the leading edge of the wing while the acft engine was idling at aprx 1200 RPM. The rotation prop struck and injuried the pass'g with serious chest, back and arm lacerations. The…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 NYC84FNA02Accident · No injuriesFinal reportAir & Space Gyroplane 18A · Harwich, MACruising at 500 ft over water the plt encountered fog. In an effort to maintain visual contact with the shoreline the plt began a descent and began a turn to avoid the fog. During the descending turn the acft got low and slow and the plt was unable to control…NTSB NYC84LA265Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Plymouth, MAThe plt stated that when he released his glider at 2500 feet, soaring conditions were good. Conditions deteriorated which resulted in no lift and altitude was insufficient to safely return to the departure airport. The pilot attempted to land off the airport…NTSB NYC84LA252Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAN49985 landed on rwy 32 and turned off rwy at midfield intersection. Acft came to full stop to retract flaps and turn off carb heat. Plt stated a check for other traffic who made at this time. Student plt began taxiing to ramp with landing light off, nav…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 NYC84FA240Accident · 2 fatalField investigationFinal reportMBB BO-105C · Rehobeth, MAThe messerschmitt-blohm-boelkow BO-105C was on an air ambulance flt with a plt, 2 additional crewmembers (doctor & nurse) & a passenger (patient) on board. During flt, the plt radioed that he had lost power in 1 eng, then about 14 sec later, he radioed that…NTSB NYC84FNE03Accident · 1 fatalFinal reportPiper J4A · Gardner, MADuring climbout, plt noted slight pwr loss, applied carb heat & eng regained pwr. On removal of carb heat, pwr loss (aprx 200 RPM) again occurred. Application of carb heat again resorted pwr but plt elected to turn back to field and land. During turn, plt…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 NYC84FA227Accident · 1 fatalField investigationFinal reportCessna 402C · Boston, MADuring arrival, the flt was cleared for an ils/dme apch to rwy 27. While on the apch, the acft crashed in the ocean about 2.7 mi east of the rwy threshold. The plt reported that he was making the apch, using instruments, & landed short for unknown reasons. He…NTSB NYC84LA220Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Orange, MAThe plt stated that he was giving local sightseeing flights. He indicated that a 'wide' gentleman and a 'moderate' size gentleman boarded the acft. The plt moved the throttle to ensure clearance but found one of the pax restricted the movement slightly. The…NTSB NYC84FA201Accident · 1 fatalField investigationFinal reportCessna 172P · Haverhill, MAWitnesses observed the acft on a high final apch to rwy 05 when a go-around was initiated over the rwy at aprx 50 ft AGL with the flaps fully extended. The acft climbed to aprx 100 ft AGL & then suddenly entered a stall, descended to the ground & crashed. The…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 NYC84LA186Accident · No injuriesLimited investigationFinal reportCessna C150 · Stow, MADuring the initial takeoff climb at about 400 ft AGL the acft experienced a loss of power. During the emergency descent the eng restarted and ran for aprx 30 seconds before quiting again. The plt perofrmed a forced landing into the pine trees below.NTSB NYC84LA188Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Pepperell, MAThe glider was attempting a tow-launch when the right wing tip struck a clump of high grass. The glider yawed right and collided with the asphalt rwy, breaking the fuselage and collapsing the landing gear. The pilot stated that the grass was too high for a…NTSB NYC84FA180Accident · 1 fatalField investigationFinal reportBeech D-45 · Taunton, MAN812Z crashed in a wooded area about one mile southeast of the Taunton municipal airport. Witnesses in the area observed the acft prior to the crash. One witness saw what appeared to be yellow smoke coming from the bottom of the acft. Some of the witnesses…NTSB NYC84LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chatham, MADirectional control was lost during the takeoff ground roll with a slight quartering tailwind. Power was reduced but the acft traveled off the left side of the rwy where it collided with a tree.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 NYC84LA171Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Spencer, MAAccording to the plt, the purpose of the flt was to practice autorotations. During practice, the acft touched down hard & was substantially damaged.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 NYC84LA160Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Newburyport, MAWhile landing on rwy 28, the acft encountered a gust of wind. The plt reported that the wind caught the tail of the acft & caused it to drift. He stated that he continued the landing, but applied the brakes too fast & the acft nosed over. He reported the wind…NTSB NYC84FA159Accident · No injuriesField investigationFinal reportPiper PA-28-140 · North Andover, MAThe plt stated to police that he was positioning the prop for a photo when the engine started and the airplane traveled 2500 ft unattended across the arpt before it became airborne and struck the rear of a commercial bldg that housed three businesses,…NTSB NYC84LA155Accident · No injuriesLimited investigationFinal reportBell 206 · Boston, MAAfter takeoff, the helicopter was climbing thru 200 to 300 ft AGL, at 50 to 60 KTS, when a partial loss of power occurred. This was followed immediately by a complete loss of power. The plt initiated an autorotation & landed in a railroad switching area where…NTSB NYC84FA143Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Concord, MAThe acft crashed into a house while on an ILS approach to rwy 11 at hanscom field. Shortly before the acft had reached the outer marker (and after the hand off from boston approach control to hanscom tower) an altitude alert on N4467X was received by the…NTSB NYC84LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Hopedale, MADuring the sixth landing on the dual instructional flt, the acft veered to the left. The instructor took over the controls and applied right rudder but the acft contacted a snow bank and nosed over.NTSB NYC84LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Stow, MADuring the landing roll, the acft began drifting to the left & the student plt overcontrolled with the rudder. Subsequently, the acft departed the rwy, collided with a snowbank & nosed over. The instructor (CFI) took control of theacft as the veer was taking…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 NYC84LA121Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chatham, MAAfter landing, as the plt was taxiing to the parking area, the acft hit a rwy identifier sign. The left horizontal stabilizer, elevator & rudder were damaged. The plt said the sign was painted black & was not clearly visible. Also, the sign was not of a…NTSB NYC84LA120Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Lawrence, MAThe plt reported that the acft ballooned on landing, & on the 2nd touchdown, it veered left towards a snowbank. He maneuvered to avoid the snowbank, but the nose wheel collapsed in soft mud.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 NYC84LA111Accident · No injuriesLimited investigationFinal reportCessna 340 · Norwood, MAThe plt reported that during an instrument apch, he descended to the mda with the radar altimeter set to 415 ft. the passenger in the right front seat, who was a plt, advised that he saw the apch lights & 1 or 2 seconds later, the radar altimeter sounded. The…NTSB NYC84LA147Accident · No injuriesLimited investigationFinal reportCessna 152 · Fitchburg, MAThe plt of N45945 stated that upon entering downwind for rwy 32 she reported her position on UNICOM, but did not receivea reply. She continued her approach failing to report base and final positions. At aprx 500 ft on final apch she felt the acft buffet and…NTSB NYC84LA101Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe student plt was practicing touch and go landings. The plt reported that the acft encountered a strong gust of wind about 5 ft AGL during the 2nd landing. The touchdown was made on the right main gear as the acft skidded and bounced. The next landing was…NTSB NYC84LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Bedford, MAThe acft was decelerating at about 35 mph during roll when a gust of wind picked up the right wing and the acft veered to the right. Full power was applied to regain control and during acceleration the right main gear collapsed and the acft pivoted right and…NTSB NYC84LA303Accident · No injuriesLimited investigationFinal reportCessna R182 · Boston, MAAccording to the plt, due to landing traffic he was requested by ATC to keep his airspeed as fast as possible. A hard landing resulted at 110 KTS.