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 NYC83FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Plymouth, MAThe aircraft had been repossessed. The purpose of the flight was for the pilot to demonstrate it to one or both of the other occupants. Prior to this flight, the aircraft had not been flown since 5/20/82. During takeoff, the engine lost power at about 200 ft…NTSB NYC83LA021Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Nantucket, MAPilot approached runway and right wing dropped. Pilot corrected with full power aileron and elevator. Aircraft yawed and rolled to left. Left wing hit and main gear collapsed. Aircraft groundlooped and stopped.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 NYC82DA234Accident · No injuriesFinal reportCessna 150D · Hyannis, MAThe pilot stated that she was cleared for landing on runway 24. She stated that as she turned onto final, and the aircraft was high, an additional notch of flaps was added. The descent to the runway was at approximately 90 mph. The aircraft touched down in…NTSB NYC82DA228Accident · No injuriesFinal reportCessna 152 · Hyannis, MAAfter returning from a cross-country, the pilot landed on runway 23. The wind was reported to be from 240 deg at 10, gusting to 20 KTS. The pilot reported that during the landing, the plane touched down on the main gear, and nosed over onto the propeller. He…NTSB NYC82DA223Accident · No injuriesFinal reportBeech B23 · West Yarmouth, MAAbout 30 min after takeoff, the engine lost power at about 1000 ft AGL when the pilot added power to climb. He was unable to restart the engine and elected to land along the shoreline. During the approach, the aircraft collided with power lines. Reportedly,…NTSB NYC82DA212Accident · No injuriesFinal reportPiper PA-28-140 · Norwood, MAThe student pilot was on a local flight and returned to the airport to practice landings. Just prior to touchdown on his second touch-and-go, the nose went to the right. Left rudder was applied to re-align the aircraft to the centerline of the runway. At…NTSB NYC82DA201Accident · No injuriesFinal reportErcoupe 415C · Gardner, MAThe engine lost power during flight and the pilot engaged the starter with the prop windmilling. The starter gear was found shattered and the starter gear teeth were scattered through various parts of the engine. No reason was found for the original engine…NTSB NYC82DA195Accident · No injuriesFinal reportChampion 7ECA · Lawrence, MAThe instructor pilot reported that there was a loss of power after the student had adjusted his pattern for another aircraft and turned on final approach. The instructor took control of the aircraft and landed on a street. During the landing the aircraft…NTSB NYC82DA194Accident · No injuriesFinal reportCessna 172M · Marlboro, MAThe solo student was practicing landings, flared the aircraft too high, then stalled and made a hard landing. The nose gear collapsed and the aircraft nosed over.NTSB NYC82DA189Accident · No injuriesFinal reportPiper PA-12 · Wellesley, MAThe pilot experienced a power loss and decaying RPM and decided to land short of destination which was 10 miles away. After surveying a pond for landing, the RPM was 600 and the landing was hard enough to damage the floats. As inspection revealed a blockage…NTSB NYC82FNE04Accident · Serious injuriesFinal reportBellanca 7KCAB · Agawam, MAWhile setting up to land on rwy 23, the plt throttled back the eng & it quit. The acft crashed into a wooded area approximately 1/4 mi from the end of the rwy. During the post-accident eng run, the eng would not maintain 700 RPM at idle (manufacturers…NTSB NYC82FA175Accident · 1 fatalField investigationFinal reportBeech B19 · South Yarmouth, MAThe acft stalled & impacted trees as the plt was buzzing a residence at 150-200 ft above the tree tops.NTSB NYC82DA172Accident · No injuriesFinal reportHughes 269A · Westfield, MAThe helicopter started to spin around after takeoff during a hover in strong wind. The pilot decided to land. Sideloading broke a skid and the helicopter rolled over during touchdown.NTSB NYC82DA156Accident · Minor injuriesFinal reportDowner Aircraft Industries Republic RC-3 · Southwick, MADuring flight, the engine began to run rough. The pilot attempted to correct the situation but the engine continued to operate at reduced power. He elected to land the amphibious plane in a field and extended the gear. However the pilot saw that the aircraft…NTSB NYC82DA149Accident · No injuriesFinal reportBellanca 7GCBC · North Adams, MAThe pilot reported that during the landing roll-out, the aircraft had slowed to about 20 mph when it started to veer slightly to the left. He stated that a slight right rudder and brake correction was made and the plane veered to the right. Reportedly, he was…NTSB NYC82FNA19Accident · No injuriesFinal reportBreezy RL4-1 · Andover, MADuring flt the plt felt something snap or break on the acft. The control wheel movement for the aileron became exceedingly harder to move & the acft started to flutter in an up & down motion. He reduced power to slow the flutteringaction, but was not able to…NTSB NYC82DA141Accident · No injuriesFinal reportGrumman American AA-5A · Marstons Mills, MAThe pilot stated that the aircraft was slow to gain normal lift-off speed due to the surface of the airstrip. He also stated that after prematurely vaulting the aircraft into the air the aircraft never gained sufficient airspeed for a climb. The aircraft…NTSB NYC82DA144Accident · Minor injuriesFinal reportErcoupe 415-C · Mansfield, MAWitnesses reported that the aircraft bounced during touchdown and began porpoising. After bouncing 4 or 5 times, the nose tire blew out. Subsequently, the aircraft vee ed off the runway and nosed over.NTSB NYC82FNA18Accident · Serious injuriesFinal reportCallair A-9 · Salisbury, MAAfter taking off, the pilot began an approach to pick up an advertising banner. A witness observed the plane circling to the right. He reported that as the plane turned right, it suddenly plunged straight to the ground. The aircraft crashed in a marshland.NTSB NYC82FNA17Accident · No injuriesFinal reportS.N.I.A.S. SA-330J · Hyannis, MAThe pilot reported that he took off, and during a climb through about 800 ft, he heard a loud snap and immediately felt severe lateral vibrations. He declared an emergency and landed without further incident. An investigation revealed that the inboard…NTSB NYC82FNA20Accident · No injuriesFinal reportSmith Aerostar 601 · Martha'S Vineyard, MADuring an ILS with the autopilot coupler on, a high sink rate developed toward the end of the approach. The pilot uncoupled the autopilot and began a missed approach, but the aircraft hit the top of a tree. He diverted and landed at providence, RI without…NTSB NYC82FNA15Accident · Minor injuriesFinal reportAeronca 7AC · Danvers, MADuring the previous flight, the aircraft had run out of fuel and was successfully landed in an open field. This occurred while the fuel gauge was indicating 1/4 full. The pilot serviced the plane with 5 gallons of no-lead auto fuel and stripped it of excess…NTSB NYC82FNA14Accident · 1 fatalFinal reportThurston Teal TSC-1A · Methuen, MAThe pilot was practicing takeoffs and landings on a river in an amphibian aircraft. After a landing, the pilot commenceda high speed taxi takeoff. When violent shaking started the pilot reduced power, pulled back the stick, and landed. The aircraft nosed…NTSB NYC82DA092Accident · No injuriesFinal reportPiper PA-28-140 · North Andover, MADuring landing the aircraft bounced and touched down on the center of runway 05. When the nosewheel was lowered the aircraft swerved to the right. According to the pilot, manipulation of the rudder pedals failed to change the direction or rate of turn of the…NTSB NYC82FNA13Accident · No injuriesFinal reportBeech E33 · Bedford, MAThe pilot was unable to start the aircraft with the electric starter when the battery had insufficient power to crank the engine. The pilot stated that he shut off the battery and alternator switches, turned off the magneto switch, and removed the keys. He…NTSB NYC82FNA12Accident · Serious injuriesFinal reportPiper PA-32R · Rochester, MAThe pilot reported that while he was en route, a power loss occurred and he was unable to restart the engine. He selected a clearing for a forced landing, but was unable to reach it. A crash landing, but was made in an area of trees and brush. An…NTSB NYC82DA062Accident · No injuriesFinal reportCessna 150L · Haverhill, MAAfter calling for landing information on UNICOM and receiving no reply the pilot elected to land. During roll-out at approximately 5 mph the aircraft's right main and nose gear encountered a sink-hole causing the right wingtip to hit the ground.NTSB NYC82DA025Accident · No injuriesFinal reportCessna 172M · Haverhill, MAThe pilot landed on a wet and muddy strip beside a hard topped runway. After traveling about 100 ft down the strip, the wheels began to sink. As the plane almost came toa stop, the nose wheel sank into the mud and the plane slowly nosed over.NTSB NYC82DA038Accident · No injuriesFinal reportCessna 182B · Pepperell, MAWhen the pilot arrived at his destination, he landed on an icy runway. Near the end of his landing roll, the aircraft encountered a rut and veered into a snowbank beside the runway. The wind was light and variable.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…NTSB NYC82DA032Accident · No injuriesFinal reportCessna 172K · Plymouth, MAAfter entering the traffic pattern, the pilot completed his prelanding checklist while opposite of the numbers on downwind. After turning to final approach, there was a loss of engine power. He stated that he reached down and switched the fuel selector…NTSB NYC82DA033Accident · No injuriesFinal reportBellanca 7KCAB · Marthas Vineyard, MAAfter arriving at the destination, the pilot landed on runway 24. The wind was from 330 degrees gusting to 20 KTS. During the landing roll-out, the aircraft ground looped when a crosswind gust was encountered. The plane ran off the runway into a rough grassy…NTSB NYC82FNA10Accident · Minor injuriesFinal reportCessna 172 · Taunton, MAThe student pilot took off at night on an unsupervised pleasure flight. His passenger did not hold any type of pilot certificate. After takeoff, the pilot encountered fog. He used the nbd for orientation and was able to return to the airport. He reported…NTSB DCA82AA013Accident · 2 fatalFinal reportMcdonnell Douglas DC-10-30 · Boston, MADrg arr, plt ackd rcpt of ATIS info & fld cond rprt, both in dcg braking action "fair to poor." He was not adzd of 3 pltrprts of braking action "poor to nil" or "poor." Acft was clrd for vor/dme apch to rwy 15R. Due to psbl wnd shear, 35 deg of flaps (instead…NTSB NYC82DNA09Accident · 2 fatalClosedCessna 172N · Nantucket, MANTSB NYC82FNA06Accident · No injuriesClosedCessna 170B · Stow, MANTSB NYC82FNA05Accident · Serious injuriesClosedRaven S-55A · Shirley, MANTSB NYC82FA007Accident · 1 fatalClosedChampion 7GCAA · Scituate, MANTSB NYC82FA004Accident · 2 fatalClosedPiper PA-28 · Danvers, MANTSB NYC81FNA03Accident · Minor injuriesClosedPiper PA-30 · Norwood, MANTSB NYC82FNA02Accident · Serious injuriesClosedCessna 182 · East Pepperell, MANTSB NYC82FNE01Accident · Serious injuriesClosedBeech A35 · Montague, MANTSB NYC82FNA01Accident · Minor injuriesClosedCessna 172 · North Reading, MANTSB NYC81FNA26Accident · No injuriesClosedPiper PA-24 · Marstons Mills, MANTSB NYC81FNE30Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC81FNE29Accident · Minor injuriesClosedPiper PA-28 · Berlin, MANTSB NYC81FNA25Accident · Serious injuriesClosedSchweizer 2-32 · Plymouth, MANTSB NYC81FNA27Accident · Serious injuriesClosedGrum Amer AA-1B · Tewksbury, MA