NTSB investigations, MA
41 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 3 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 NYC06FA040Accident · 1 fatalField investigationFinal reportBeech B-55 · Nantucket, MAThe pilot's failure to maintain the proper glidepath during the instrument approach, which resulted in controlled flight into water. Factors were the failure of the air traffic controllers to issue minimum safe altitude warnings, night lighting conditions,…NTSB NYC04CA132Accident · Minor injuriesData collectionFinal reportAviat A-1B · Halifax, MAThe pilot's inadequate flare during landing, which resulted in an in-flight collision with water. A factor was the glassy water conditions.NTSB NYC03CA207Accident · No injuriesData collectionFinal reportRobinson R-22A · Bedford, MAThe certified flight instructor's failure to maintain ground clearance and his delayed remedial action, which resulted in a rollover.NTSB NYC02FA032Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Falmouth, MAThe incapacitation of the pilot for undetermined reasons which resulted in an in-flight collision with water.NTSB NYC01LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Stow, MAThe pilot's failure to maintain airplane control during a go-around.NTSB NYC00LA199Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Lawrence, MAThe pilot's failure to attain the proper touchdown point and his delayed remedial action. Also causal was the pilot's lack of recent experience. A factor in the accident was the tailwind condition.NTSB NYC00FA006Accident · 2 fatalField investigationFinal reportRaytheon Corporate Jets BE-200 · Williamstown, MAThe pilot-in-command's failure comply with an air traffic control clearance which resulted in a collision with terrain. A factor in this accident was clouds.NTSB NYC99FAMS3Accident · 1 fatalMissing aircraftFinal reportPiper PA28RT-201T · Plymouth, MAundetermined (missing airplane)NTSB NYC99FA012Accident · 1 fatalField investigationFinal reportGrumman American AA-5 · Provincetown, MAThe failure of the pilot to follow the published instrument approach procedure, which resulted in inadvertent collision with water. Factors in the accident were the dark night and low ceiling.NTSB NYC98LA039Accident · 1 fatalLimited investigationFinal reportCessna 172M · New Salem, MAThe pilot's failure to maintain adequate altitude/clearance above the water due to his impairment by drugs. A factor in this accident was the glassy water condition.NTSB NYC95LA091Accident · No injuriesLimited investigationFinal reportMooney M20K · Marshfield, MAthe pilot misjudged the flare, resulting in a bounced landing and impact with the terrain. A factor in this accident was an improper recovery from a bounced landing.NTSB BFO94LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-31T · Norwood, MAThe pilot's failure to attain alignment with the centerline of the runway, and his failure to execute a missed approach. Factors which contributed to the accident were: the dark night, the pilot's improper decision to initiate the approach in below-minimum…NTSB BFO94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Newburyport, MAThe pilot not maintaining clearance from the snowbank during final approach. A factor in this accident was the proximity of the snowbank to the active runway.NTSB NYC93FA118Accident · 3 fatalField investigationFinal reportCessna P210 · Marthas Vineyrd, MAThe pilot's failure to maintain control of the airplane.NTSB NYC93FA110Accident · 1 fatalField investigationFinal reportSkillman Thorp T-18 · Chatham, MAthe pilot's performance of an aerobatic maneuver, with insufficient altitude for recovery, resulting in a collision with the waterNTSB BFO92FA151Accident · 3 fatalField investigationFinal reportCessna R182 · Edgartown, MAThe pilots's lack of regard for the published decision height of the approach and his decision not to execute a missed approach. Factors contributing to the accident include the pilot's failure to attain the proper glidepath and descent rate during the…NTSB NYC92FA026Accident · 2 fatalField investigationFinal reportPiper L-3 · Plymouth, MAThe improper decision by the non-instrument-rated pilot to attempt VFR flight in instrument meteorological conditions, at a low altitude, which resulted in a collision with the water. Factors related to the accident were: the overconfidence of the pilot in…NTSB NYC91LA226Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Nantucket, MAThe pilot's descent below the ILS glide path and his delay in initiating a missed approach which resulted in collision with the terrain.NTSB NYC91LA014Accident · Minor injuriesLimited investigationFinal reportStinson SR8C · Lakeville, MAThe pilot misjudged his altitude above the lake water and allowed the airplane to descend while making a left turn. Factor's related to the accident were: calm winds causing the lake water to be glassy.NTSB NYC90FA231Accident · 2 fatalField investigationFinal reportCessna 182Q · Nantucket, MAThe pilot's improper IFR operation in attempting an ILS approach in an airplane not equipped with an ILS glide slope receiver. The weather conditions were factors in the accident.NTSB NYC90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orange, MAFailure of the pilot to maintain runway alignment while aborting the takeoff. The crosswind, turbulence, and snowbank were related factors.NTSB NYC90LA025Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Westfield, MALoss of aircraft control for an undetermined reason, which resulted in the tail rotor striking the ground and separating from the helicopter.NTSB NYC89FA105Accident · 4 fatalField investigationFinal reportAerospatiale TB-10 · Pittsfield, MAFailure of the pilot to maintain proper altitude. Factors related to the accident were: inadequate briefing provided by the flight service station (fss) specialist, dark night, low clouds, and terrain conditions.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 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 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 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 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 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 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 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 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 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 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 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 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 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 NYC83LA003Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Ipswich, MAThe pilot descended over water at night and elected to fly over a beach area at 100 to 200 ft AGL. He reported that he lowered the nose briefly to see better. At about that time, the aircraft collided with a sand bank.NTSB NYC82FNA11Accident · Minor injuriesFinal reportVarga 2150A · Marlboro, MASnow had fallen on the evening before the accident. The runway was covered with one inch of snow which had not been plowed or treated. Also, the pilot reported that he had removed snow and frost from the airframe during his preflight. He said that the leading…NTSB NYC82DA042Accident · No injuriesFinal reportCessna 172RG · Palmer, MAThe pilot initiated a takeoff on runway 04. He reported the wind was from 300 to 330 degrees at 10 gusting 25 KTS. During the takeoff roll, a bump in the runway was encountered and the aircraft became airborne. The pilot reported that a gust of wind from the…