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 NYC97LA108Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 135 · Pepperell, MAThe pilot's failure to maintain airspeed during a turn, which resulted in an inadvertent stall and subsequent uncontrolled descent into water.NTSB NYC97LA106Accident · Serious injuriesLimited investigationFinal reportPiper PA-17 · Mansfield, MAThe inadequate procedure for hand-prop starting of the engine.NTSB NYC97LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · North Andover, MAFuel vents blocked by frozen moisture which resulted in restricted fuel flow to the engine and subsequent loss of engine power.NTSB IAD97IA045Incident · No injuriesIncident investigationFinal reportCessna 402C · Provincetown, MAthe pilot's inadequate inflight planning/decision, and his misjudgment of speed and distance. Related factors were: fog, tailwind, and soft terrain on the overrun area at the end of the runway.NTSB IAD97LA034Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Beverly, MAloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and subsequent in-flight collision with terrain.NTSB NYC97LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering into a snowbank. The proximity of the snowbank was a related factor.NTSB NYC97FA019Accident · No injuriesField investigationFinal reportCessna 172N · Andover, MAfailure of the dual magneto, which resulted in a total loss of engine power, and subsequent collision with trees during a forced landing at night. Darkness and trees in the emergency landing area were related factors.NTSB NYC97LA018Accident · No injuriesLimited investigationFinal reportDubis Team Minimax · North Adams, MAfuel contamination, which resulted in a loss of engine power. Factors relating to the accident were: the lack of a drain in the fuel system to properly check the fuel before flight, and the pilot's failure (or inability) to detect the contaminated fuel.NTSB NYC97LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Norwood, MAfailure of the pilot to perform a go-around, when an animal obstructed the runway; and his failure to maintain clearance from an obstruction (VASI). Factors relating to the accident were: darkness, an animal (deer) on the runway, and the proximity of the…NTSB IAD97LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Sheffield, MAThe pilot's abrupt control of the airplane, which resulted in an inadvertent stall, uncontrolled descent, and subsequent in-flight collision with water.NTSB NYC97LA003Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Mansfield, MAfailure of the T-6 pilot to maintain clearance from the Cessna 152, as he turned off the runway after landing. A factor relating to the accident was: the T-6 pilot's restricted view of the Cessna 152 (lack of visual detection), due to a blind spot beyond the…NTSB NYC97LA002Accident · No injuriesLimited investigationFinal reportCessna 172H · Chatham, MAthe pilot's improper flare, which resulted in a hard landing. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.NTSB NYC96LA190Accident · No injuriesLimited investigationFinal reportBins Kitfox IV · Pittsfield, MAthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control, the airplane veering off the runway, and a subsequent nose over. The adverse wind condition and uneven terrain were related factors.NTSB IAD96LA150Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Templeton, MAthe student pilot's improper in-flight decision to continued the cross-country flight into night conditions, and his inability to find the destination (or an alternate airport) in a timely manner, which resulted in fuel exhaustion, forced landing, and…NTSB NYC96LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · Stow, MAthe pilot's misjudgment of speed and distance during the landing, and his failure to go around while there was sufficient runway remaining, which resulted in a runway overrun and an encounter with a soft terrain at the edge of a pond. Wet grass on the runway…NTSB NYC96LA166Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Bedford, MAThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a ground loop/swerve. The variable wind condition was a related factor.NTSB NYC96LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Worcester, MAthe pilot's improper recovery from a bounced landing, and his failure to maintain control of the airplane, which resulted in a nose over. His improper flare was a related factor.NTSB NYC96LA145Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Carver, MAthe pilot's inadequate visual look out for obstacles, which resulted in a collision with wires and the ground.NTSB NYC96LA141Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Boston, MAa fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.NTSB NYC96LA140Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26E · Marston Mills, MAfailure of the pilot to maintain control of the glider while being towed during takeoff, which resulted in a pitch oscillation, failure of the tow cable, loss of airspeed, an inadvertent stall/spin, and an uncontrolled collision with the ground.NTSB NYC96LA135Accident · No injuriesLimited investigationFinal reportBell 206B III · South Carver, MAThe pilot's failure to maintain control of the helicopter during an aerial application maneuver. This put the helicopter in a low slow down wind, high power demand turn, where it encountered a loss of tail rotor effectiveness, and the subsequent collision…NTSB NYC96LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAan animal (deer) that wandered onto the runway. The light condition (at dusk) was a related factor.NTSB CHI96IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320 · Boston, MAan undetermined intermittent fault in the trimmable horizontal stabilizer actuator system.NTSB NYC96LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Gardner, MAthe pilot 's misjudgment of speed and distance during landing.NTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…NTSB NYC96IA116Incident · No injuriesIncident investigationFinal reportBoeing 767-31AER · Boston, MANumerous electrical anomalies as a result of a loose main battery shunt connection and undetermined electrical system causes.NTSB NYC96LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshfield, MAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control, on-ground collision with terrain, and the aircraft nosing over. The sudden windshift was a related factor.NTSB NYC96LA092Accident · No injuriesLimited investigationFinal reportCessna 175 · Pittsfield, MAthe pilot's inadequate crosswind compensations during the landing roll.NTSB IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.NTSB NYC96LA068Accident · No injuriesLimited investigationFinal reportCessna 172M · Bedford, MAthe flight instructor's inadequate supervision of the flight, the pilot's improper compensation for the wind conditions, and the high wind. The instructor's inadequate evaluation of the weather was a contributing factor.NTSB NYC96LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwood, MAFailure of the student pilot to maintain directional control of the airplane after touchdown, which resulted in an inadvertent ground swerve and collision with a snowbank.NTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…NTSB NYC96LA029Accident · Serious injuriesLimited investigationFinal reportBellanca 8-KCAB · Sheffield, MAthe pilot's inadequate preflight and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel.NTSB NYC96LA028Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Southbridge, MAfatigue failure of the engine crankshaft.NTSB NYC96LA025Accident · No injuriesLimited investigationFinal reportCessna 150J · Norwood, MAthe student's inadvertent use of the mixture control and the flight instructor's inadequate supervision during the final approach resulting in the loss of engine power due to fuel starvation and the subsequent nose over during the forced landing.NTSB NYC96LA020Accident · No injuriesLimited investigationFinal reportCessna 414A · Grt Barrington, MAthe pilot's inadequate compensation for wind conditions, which resulted in an undershoot of the proper touchdown point for landing. Factors relating to the accident were: the unfavorable wind conditions and the exposed runway lip.NTSB NYC96LA016Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Barre, MAThe pilot's improper inflight planning/decision, which resulted in his failure to return to the airport after encountering an area of no thermal lift, and his failure to maintain adequate airspeed, while maneuvering to avoid an obstruction during an off…NTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.NTSB NYC95LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, MAThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a related factor.NTSB NYC95LA200Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Hopedale, MAthe student pilot's improper flare and improper recovery from a bounced landing, which resulted in a loss of control and collision with a fence and a building.NTSB NYC95LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norfolk, MAThe pilot's misjudgement of speed and distance during the landing, which resulted in a runway overrun. Factors relating to the accident were: heavy rain, wet runway, and hydroplaning conditions.NTSB NYC95FA181Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Rehoboth, MAThe pilot's inadvertent flight into hazardous weather, which subsequently resulted in exceeding the design stress limits of the airplane and an in-flight breakup. Factors relating to the accident were: embedded thunderstorms, turbulence, and failure of the…NTSB NYC95LA180Accident · No injuriesLimited investigationFinal reportWright JUNGSTER-I · Mansfield, MAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and subsequent uncontrolled descent and collision with the terrain.NTSB NYC95LA160Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Deerfield, MAThe pilot's inadequate evaluation of the weather, which resulted in an encounter with unfavorable winds and an inflight loss of control. The unfavorable/high winds and sudden wind gusts were related factors.NTSB NYC95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, MAthe pilot's improper preflight planning/preparation, inaccurate fuel consumption calculations and failure to refuel, resulting in fuel exhaustion and a subsequent collision with trees during the forced landing.NTSB NYC95LA177Accident · No injuriesLimited investigationFinal reportPincince Corbin Baby ACE · Palmer, MAcontamination in the carburetor which resulted in fuel starvation, a total loss of engine power and forced landing.NTSB BFO95LA066Accident · 1 fatalLimited investigationFinal reportDrake Moni · Pittsfield, MAthe pilot's failure to maintain/regain control of the aircraft during the simulated engine-out procedure while on approach to landing.NTSB NYC95LA116Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Taunton, MAthe failure of the pilot to monitor his fuel supply, which resulted in a power loss due to fuel exhaustion, and a forced landing in rough terrain.NTSB NYC95LA101Accident · No injuriesLimited investigationFinal reportBell 206B · Hamilton, MAthe pilot's improper decision to fly at night with a night vision deficiency, and his failure to maintain clearance with trees during takeoff, which resulted in an in-flight collision with the trees and the subsequent hard landing.NTSB NYC95LA100Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Middleboro, MAthe pilot's failure to maintain airspeed during a low altitude aerial application turn, which resulted in inadvertent settling with power and the subsequent collision with the terrain.