NTSB investigations, MA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 NYC84LA094Accident · No injuriesLimited investigationFinal reportCessna 500 · Fitchburg, MAThe plt landed on a slushy rwy. He was unable to stop on the rwy and angled off the end into marshy ground. The stoppingdistance on a dry rwy was figured at 2355 ft. on a slushy rwy the stopping distance was about 4004 ft. the landing rwy was 4500 ft long.…NTSB NYC84FA090Accident · 1 fatalField investigationFinal reportBeech 76 · Beverly, MAA commercially rated plt (student) was receiving multi-eng training from an instructor plt (CFI). The student stated that on final apch to landing, he noticed the airspeed was slow when the CFI shut down the right eng by using the mixture control. The acft…NTSB NYC84FU003Accident · 1 fatalFinal reportPanaplane Pappillon · Pepperell, MAThe airman took off on his first solo flt after one and one half hours of ground instruction and no flt instruction. Theflt proceeded after a normal takeoff to turn left at about 50 ft AGL to avoid a hanger. After a precise 90 degree turn, the acft continued…NTSB NYC84FA085Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Templeton, MAThe acft collided with trees on unlgtd terrain at ngt after making a low pass at aprx 60 ft AGL with the gear extended. Witnesses reported that the acft's clearance lights were not operating until the rwy lights were turned on, then they observed the acft's…NTSB NYC84FA072Accident · 1 fatalField investigationFinal reportCessna 152 · Barre, MAThe acft was landed off the arpt tailing fire and smoke shortly after takeoff. It was a cold day and the CFI and student had trouble starting the acft even after pre-heat was used. Witnesses saw the acft after takeoff descending withsmoke and flames trailing…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 NYC84FA064Accident · No injuriesField investigationFinal reportCanadair CL44D4 · East Boston, MAThe acft landed with the right main landing gear in the retracted position. The crew was unable to lower the right main gear by the normal or emergency methods. Inspection after the accident revealed that the main hydraulic line. Pn 44-75087-98 was broken…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 NYC84LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Marlborough, MAThe acft collided with trees during final approach to land. The acft was on a short final to rwy 32 at marborough when the left wheel and left wing struck tree tops a short way from the rwy threshold. The acft turned about 70 degrees to the left and collided…NTSB NYC84LA028Accident · No injuriesLimited investigationFinal reportBeech C35 · Martha'S Vineyard, MAThe plt had departed Martha'S Vineyard arpt & was climbing over lagoon pond (a large body of salt water) at aprx 900 ft AGL when the eng lost power. The plt decided the arpt was too FAR away for an emergency landing & there were trees in the area, so he…NTSB NYC84LA027Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Fitchburg, MAThe aircraft's engine lost power on takeoff and the pilot elected to make an emergency landing in a residental area. The pilot maneuvered the aircraft between two homes and crashed into a tree. The aircraft rolled to the left and fell tothe ground.…NTSB NYC84LA019Accident · No injuriesLimited investigationFinal reportWichawk 1 · Northampton, MAAccording to the pilot the approach was too low and too slow and the aircraft landed short of the runway.NTSB NYC84FA016Accident · 2 fatalField investigationFinal reportBellanca 17-31 ATC · Littleton, MAGround witnesses observed the right wing separate in flight, the acft bank sharply to the right entered a spiral dive and crashed into a wooded lot in a residential area. Investigation revealed that the right wing separation occurred when the front spar lower…NTSB NYC84FNA01Accident · Serious injuriesFinal reportMooney M20E · Falmouth, MAAccording to witnesses, the acft circled the field and then came in for landing. On final aprch the acft was in a left wing low crab. Upon touchdown the acft bounced touched again and then the left wing touched the ground. The pilot applied full power and the…NTSB NYC83IA252Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6 · Boston, MAThe acft encountered jet blast while taxiing behind a L-1011 acft which had not yet received taxi clearance & was still attached to the tug when the pass began.NTSB NYC83LA247Accident · No injuriesLimited investigationFinal reportCessna 185B · Orange, MADuring arrival, the plt used a grass landing area on the north side of rwy 32/14. The wind had previously been from 290 deg, but had swung to 350 deg. The plt reported that he landed in a level attitude on the main gear, then reduced the throttle to idle.…NTSB NYC83FU010Accident · Serious injuriesFinal reportRotec Rally 3B · Franklin, MAAccording to the plt, the registered ultralight acft was brought to a field during the morning to check out the control rigging & to familiarize him with the vehicle. There was no intention to fly the ultralight at that time. Later in the day, the plt was…NTSB NYC83FA254Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Provincetown, MAThe acft crashed in cape cod bay during a night x-country flt. Two sections of wooden wing identified as from the same make and model as the missing acft were recovered from the bay during the 3 days following the flt of the acft. Other identified parts of…NTSB NYC83LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tewksbury, MAThe acft had just completed a go-around and was trying a 2nd time. The acft floated and bounced until a go-around was started about 100 ft before the departure end of the rwy. The pilot stalled over a fence and miniature golf course. The acft was about 100…NTSB NYC83LA225Accident · No injuriesLimited investigationFinal reportCessna 182C · New Salem, MAThe acft collided with high tension wires while flying at about 100 ft AGL. The plt landed in the water and all 4 occupants evacuated safely. The ditching was controlled but the acft nosed over after impact. The passengers said they had no trouble until they…NTSB NYC83FNA05Accident · Serious injuriesFinal reportLake LA-4-200 · Stow, MADuring takeoff, the plt encountered a noticeable loss of power & lowered the nose to maintain airspeed. The acft continued to lose altitude, so he selected an open field for an emergency landing. While landing on uneven terrain, the left wing struck the…NTSB NYC83FNA04Accident · No injuriesFinal reportSikorsky H-19D · Halifax, MAAfter arriving at the field to be sprayed, the plt initiated a descent to begin aerial application. At aprx 40 ft AGL & 50 KTS, the eng failed. The plt entered an autorotation, but could not avoid telephone wires. He was able to avoid hitting a dike, but in…NTSB NYC83LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oak Bluffs, MAThe plt report that during the landing roll, he encountered a bump on the rwy & the acft became airborne aprx 5 to 10 ft. he elected to go around rather than continue the landing since there was not enough room to recover & stop safely. While attempting to…NTSB NYC83LA180Accident · No injuriesLimited investigationFinal reportCessna 172 · Haverhill, MAThe acft overran the departure end of the 2100 ft rwy 32 during landing. The wind was from 320 degrees at 10 KTS. The pilot stated he made one go-around because he was high. He reported that the 2nd approach was flown at 65 mph with the touchdown accomplished…NTSB NYC83FNE04Accident · 1 fatalFinal reportBede BD-5B · Westfield, MAThe acft crashed short of the rwy during an attempted landing. There were some confusing and garbled transmissions and some mistaken instructions from the tower during the problem experienced by the accident plt. This plt did not make it clear that he had an…NTSB NYC83LNA03Accident · Serious injuriesFinal reportCessna 150 · Stow, MAThe acft propeller struck a passenger who was walking around the acft in preparation for boarding. The acft had been taxied in from landing and stopped near the coffee shop. The wife of the passenger on board the acft approached theacft prior to engine shut…NTSB NYC83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Pittsfield, MAOn the 1st takeoff, the CFI demonstrated an aborted takeoff by placing the rt selector gasoline valve in the off position and had the student pull the eng back, making a landing on the rwy. The flt then taxied back for another takeoff, again the CFI shut off…NTSB NYC83LA153Accident · No injuriesLimited investigationFinal reportMooney M20F · Marshville, MAThe plt reported that during landing, just before touchdown, the passenger accidently pulled back on the yoke causing a left wing nose-up attitude. The plt was unable to correct and a hard landing occurred.NTSB NYC83LA150Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Nantucket, MAThe helicopter made a hard landing during an aborted takeoff following a medical evacuation demonstration at Nantucket. After the presentation the acft was changed from a 2 litter configuration. The pilot noted that the cyclic retention cap was on the cyclic…NTSB NYC83FU006Accident · Serious injuriesFinal reportEastern Ultralight Snoop · Norton, MAThe non-rated plt had purchased the ultralight vehicle about 1 month prior to the accident. He had completed aprx 8 hrs of taxi & low flts along a grass rwy. Earlier on the day of the accident, he had made 2 flts & reportedly had accumulated 1 hr of flt time…NTSB NYC83LA143Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Marlboro, MAThe acft ran off the end of the runway while making a precautionary landing due to weather. During the overrun the acft collided with a fence. The pilot was not injured.NTSB NYC83LA132Accident · No injuriesLimited investigationFinal reportMooney M20B · Lakeville, MAThe acft collided with the smooth water of a reservoir while flying low during an afternoon flight. The acft crashed about 1000 ft offshore when the right wing tip collided with the surface of the water. The acft then sank in 15-20 ft ofwater. The pilot…NTSB NYC83FA130Accident · 1 fatalField investigationFinal reportNorth American AT-6C · Westfield, MAThe airline transport rated plt was on a low level, aerobatic waiver, competency check flt. He was scheduled to demonstrate a loop, an aileron roll, a split-s, an immelmann, a barrel roll & a 4-point hesitation roll. The minimum alt for these maneuvers was to…NTSB NYC83LA136Accident · No injuriesLimited investigationFinal reportCessna 170A · Chatham, MAThe acft veered onto the grass and nosed over during landing. The pilot said a gust of wind caught the tail of the acft and turned it 45 degrees to the left and when brakes were applied as a corrective action the acft nosed over. The landing was on runway 6…NTSB NYC83LA131Accident · No injuriesLimited investigationFinal reportCessna 182B · Taunton, MAThe acft collided with a small rock during taxi from landing. As the pilot taxied back to the ramp area along a dirt taxiway he observed three people standing in the way. The pilot taxied onto the grass to avoid the people and while still taxiing the acft…NTSB NYC83LA120Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Bedford, MAThe engine quit at 250 feet during the takeoff climb. No cause for the engine failure was found.NTSB NYC83LA112Accident · No injuriesLimited investigationFinal reportForney F-1 · Fitchburg, MAThe acft settled into trees during a forced landing on takeoff after a power loss at 800 feet AGL. The flight had started at stow, MA. And proceeded at Fitchburg after practicing stalls and turns for a pilot review. After landing at Fitchburg airport the…NTSB NYC83IA113Incident · No injuriesIncident investigationFinal reportCessna 402C · Boston, MAWhile in level flight a Cessna 402 passed behind an Airbus A-300 in descent for landing. The Cessna 402 rolled inverted. The pilot regained control and landed without further incident at his destination. Both acft were on instrument flight plans, in…NTSB NYC83FU004Accident · 1 fatalFinal reportVector 610 · Turners Falls, MAOn 4/18/83, the ultralight vehicle was damaged by high winds. This necessitated the replacement of the front & rear spars as well as the battens which provided curvature to the upper wing surface. Prior to a test flt, a weighted tail wheel was also installed.…NTSB NYC83FNA02Accident · No injuriesFinal reportRogers Long EZ · Fall River, MAThe plt reported that during flt, the eng lost power. He moved the carburetor heat control to apply carb heat & tried to start the eng, but was unable. He then tried to land on a road, but crashed in a wooded area before reaching the roadway. An investigation…NTSB NYC83LA100Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Ashley Falls, MAThe pilot stated that he was about a half mile from the airport when the engine quit. He restarted it but it quit a 2nd time and would not restart. By this time the acft was down to about 200 ft. a right turn was made to land on an island. The acft landed…NTSB NYC83LA108Accident · No injuriesLimited investigationFinal reportBellanca 7GBC · Middleboro, MAThe acft landed short of the runway after experiencing a power loss on the approach. The pilot had carburetor heat on and when he experienced a downdraft on final he said he opened the throttle and the engine quit. The acft was landed in the bushes short of…NTSB NYC83LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Norfolk, MAThe acft crash landed shortly after takeoff and was destroyed. The student pilot stated that after clearing the runway on his last takeoff of the day the engine hesitated and stopped. He lowered the nose to a glide speed of 70 mph picked aspot to land and…NTSB NYC83LA089Accident · No injuriesLimited investigationFinal reportPiper J3C-85 · Spencer, MAThe pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the…NTSB NYC83FA078Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · North Adams, MAAt 1145 the plt reported VFR conditions & requested radar vectors to the arpt. He was issued a cruise clearance of 5,000 ft & given a heading. 18 mi from the arpt he reported visual contact with the ground. At 1151 he was asked if he was familiar with the…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 NYC83LA075Accident · No injuriesLimited investigationFinal reportBeech P35 · Beverly, MAThe approach was made at 90 mph with full flaps in winds gusting to 25K. As the plt flared for landing the right gear contacted a pot hole at the approach lip of the rwy blowing the tire causing the rear strut to push a hole into the wing skin.NTSB NYC83FA062Accident · No injuriesField investigationFinal reportPiper PA-28-151 · Newbury, MAAfter takeoff, the plt leveled at 2500 ft & after cruising for about 20 min, descended to 1500 ft MSL. Shortly after leveling at 1500 ft, there was a slight reduction in engine RPM. The plt stated that he applied carburetor heat, but the RPM continued to…NTSB NYC83LA043Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fall River, MAOn short final & aligned with the rwy lights the plt cancelled his IFR flt plan with approach control. The acft landed on the rwy which had the middle third of its width covered with 6-8 inches of snow. The outer thirds were plowed but icy.NTSB NYC83FNA01Accident · 1 fatalFinal reportCessna 150L · Marstons Mills, MAThe acft was observed to climb at a steep angle to 150-200 ft & then enter a spin. The owner/plt had just finished installing stall fences as part of a stol kit that he was in the process of completing. Examination of the acft showed a partial installation of…