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 NYC90DNE03Accident · 2 fatalFinal reportAerodyne Vector 727 Senior · Berlin, MAIn-flight failure of the wings for undetermined reason(s).NTSB NYC90LA124Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Barre, MAThe premature commanded tow release by the towplane pilot over unsuitable terrain.NTSB NYC90LA123Accident · No injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAImproper maintenance and inspection by maintenance personnel of the left gear torque link attachment.NTSB NYC90LA122Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Becket, MAA power loss due to oil starvation, after maintenance personnel failed to comply with Lycoming directives during the engine overhaul. Factors related to the accident were: improper adjustment of the engine oil pressure by maintenance personnel and unsuitable…NTSB NYC90DNA03Accident · No injuriesFinal reportBataller Kitfox · Marlboro, MAThe undetermined loss of engine power.NTSB NYC90LA119Accident · Minor injuriesLimited investigationFinal reportGrumman American AA5-A · Plainfield, MAThe pilot's failure to switch the fuel selector to the proper tank. A factor to the accident was the high obstructions near the field.NTSB NYC90LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Lawrence, MAThe pilot's improper use of flight controls, resulting in loss of control.NTSB NYC90DNA02Accident · No injuriesFinal reportBell 47G5 · Marion, MAImproper use of carburetor heat by the pilot resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.NTSB NYC90LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Marshfield, MAThe pilots failure to maintain directional control during an aborted landing. Factors related to the accident were: the pilots limited experienced in type of airplane, and variable winds.NTSB NYC90LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Bedford, MAFailure of the exhaust system and subsequent melting/shorting of the magneto p-leads.NTSB NYC90DNE02Accident · No injuriesFinal reportWalter Hudson Mustang 2 · Westfield, MAAn encounter with wake turbulence from a preceding airplane. A factor related to the accident was the pilot's decision to takeoff close behind the preceeding airplane.NTSB NYC90LA074Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, MAAn off airport landing in unsuitable terrain following a power loss due to a delaminated ceet duct between the air intake screen and carburetor air box.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 NYC90LA072Accident · Minor injuriesLimited investigationFinal reportBell 206B · Norwood, MAImproper planning/decision by the pilot. The turbulence was a related factor.NTSB NYC90LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Worcester, MAA power loss due to an oil pump failure while operating over unsuitable terrain. A factor related to the accident was night conditions.NTSB NYC90FA051Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Great Barrngton, MAFailure of the pilot to maintain proper altitude and clearance from trees while departing from the airport. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, his allowing the aircraft weight and balance to be…NTSB NYC90LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Northampton, MAPilot's improper handling of the airplane, resulting in the loss of directional control. Contributing to the accident were gusty wind conditions and the pilot's lack of total experience.NTSB NYC90LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Millis, MAThe pilot's improper use of carburetor heat which caused a power loss and a forced landing in unsuitable terrain. Factors related to the accident were carburetor icing conditions and the pilots lack of total experience.NTSB NYC90LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · No. Andover, MAThe pilot inadvertently turned off the magneto switch during a go-around, resulting in a loss of power. Also causal to the accident was the failure of the pilot of a second airplane to respond to the tower controller's instructions. A factor related to the…NTSB NYC90LA037Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Uxbridge, MAIce in the fuel strainer, which restricted fuel flow & resulted in fuel starvation, and the pilot inadvertently stalled the airplane, when he abruptly maneuvered it to avoid a transmission wire during a forced landing.NTSB NYC90LA033Accident · No injuriesLimited investigationFinal reportCessna 150 · Westfield, MALoss of control during landing due to an improper flare and recovery from a bounced landing. A factor relating to the accident was the lack of total experience of the student pilot.NTSB NYC90FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · North Adams, MAFailure of the pilot-in-command (PIC) to assure proper rotor RPM and proper operation of the flight controls during an approach in gusty wind conditions. A factor related to the accident was: the pic's lack of experience in the type of operation.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 NYC90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Lowell, MAThe failure of the pilot to assure that the float wheels were retracted prior to a water landing. A contributing factor was the extension of the left float wheels for an undetermined reason.NTSB NYC90DNE01Accident · No injuriesFinal reportNorth American T-28B · New Braintree, MAThe failure of the nose gear, which failed to retract with the main landing gear after takeoff; the gear was observed to be misaligned, and collapsed during the aircraft's touchdown.NTSB NYC90LA017Accident · Minor injuriesLimited investigationFinal reportCessna T172N · Townsend, MAThe pilot's failure to use carburetor heat during weather conditions favorable to carburetor icing. A contributing factor was the lack of suitable terrain.NTSB NYC90LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Sterling, MAInflight loss of control due to inadvertent retraction of the wing flaps during a go around.NTSB NYC90DNA01Accident · 1 fatalFinal reportSmeesters RV-4 · North Andover, MAThe pilot's inadequate preflight inspection, and his failure to maintain aircraft control during the resultant forced landing.NTSB NYC89LA213Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Boston, MAFailue of pilot to maintain control of the helicopter when a passenger inadvertently pushed the cyclic control. The fence (near the helipad) was considered to be a factor.NTSB NYC89LA215Accident · No injuriesLimited investigationFinal reportBeech 1900C · Boston, MAThe failure of the ground personnel to safely guide the aircraft so that it would have cleared the jetway.NTSB NYC89LA198Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Gardner, MAThe worn throttle arm.NTSB NYC89LA194Accident · Minor injuriesLimited investigationFinal reportMBB ME 209 · Chatham, MAThe pilot stalled the aircraft while landing. Contributing factors to the accident were haze and the pilot applied power too late to arrest the airplane's sink rate.NTSB NYC89IA185Incident · Minor injuriesIncident investigationFinal reportBoeing 727-254 · Boston, MAThe failure of the landing gear drag brace to unlock during landing. Contributing was the failure of pacific southwest airlines to catch the incorrect assembly. An additional factor was the use of faulty information by eastern airlines and their decision to…NTSB NYC89LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beverly, MACollision with trees during an aborted landing and attempted go-around with insufficient remaining runway.NTSB NYC89LA139Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Southampton, MAImproper maintenance which resulted in a section of the vertical stabilizer failing inflight.NTSB NYC89FA146Accident · 1 fatalField investigationFinal reportCessna T210N · Hubbardston, MAFailure of both pilots to see-and-avoid (attain visual lookout for) conflicting traffic.NTSB NYC89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Uxbridge, MAImproper maneuvering shortly after takeoff from a private grass strip of marginal length for the caliber of acft being operated. A wind change added to the already exacting conditions.NTSB NYC89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bedford, MAImproper use of throttle and flight controls by the student and inadequate supervision by the CFI which resulted in a stall. The student's lack of total flying experience and the instructor's lack of experience in the type of operation (instructing) were…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 NYC89FA099Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Southbridge, MAPoor judgement of the pilot by flying while physically impaired by alcohol, and his continued VFR flight into instrument meteorological conditions (IMC). Related factors were: the pilot's inadequate preflight planning/preparation, dark night, adverse weather…NTSB NYC89LA083Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA loss of engine power and subsequent forced landing which resulted from binding of the carbuerator throttle shaft. The binding resulted from an improper overhaul of the carbuertor approximately 10 flight hours prior to the accident.NTSB NYC89LA081Accident · No injuriesLimited investigationFinal reportCessna 402B · Hyannis, MAInadequate preflight planning and preparation by the pilot which resulted in improper weight and balance (aft CG). The aft CG also contributed to the uncommanded altitude deviation after takeoff.NTSB NYC89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Turners Falls, MALoss of control during landing roll due to ice on the runway, and collision with a snow bank off the runway which sheared the left main landing gear.NTSB NYC89LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Hyannis, MAThe acft ran off the runway and hit a landing light and terrain as the pilot attempted to make a crosswind landing, at barnstable airport, Hyannis, MA.NTSB NYC89LA046Accident · No injuriesLimited investigationFinal reportBeech 24R · Oxford, MAFailure of the pilot to stop the aircraft on the available runway due to a long landing.NTSB NYC89LA043Accident · No injuriesLimited investigationFinal reportCessna 185 · Hanson, MAThe pilot reported that he had just landed when the left brake failed. In order to avoid hitting trucks parked near the runway the pilot elected to ground loop the aircraft. The side loading on the left landing gear during the ground loop caused it to…NTSB NYC89DNE01Accident · 1 fatalFinal reportBell 47D1 · Russell, MAA pilot induced low rotor RPM condition, followed by blade flapping as the main rotor blade contacted the tail of the helicopter.NTSB NYC89LA041Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Sharon, MAEngine power loss while landing due to fuel exhaustion.NTSB NYC89FA032Accident · 1 fatalField investigationFinal reportMooney M20K · Holden, MAInflight loss of control due to spatial disorientation and contact with trees prior to regaining control after the pilot experienced an unknown problem with the autopilot. Contributing was the lack of recent night experience.NTSB NYC89IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Boston, MAFailure of the local controller to detect the red t on the departure strip on PRE659 when he cleared him into position and hold. Factors related to the accident were: darkness and the lack of positive coordination between the ground controller and local…