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 NYC06CA020Accident · Minor injuriesData collectionFinal reportRobinson R44 · Bourne, MAThe inadvertent contact of a lift strap with the tail rotor during external load operations, which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the gusty wind conditions.NTSB NYC06CA023Accident · No injuriesData collectionFinal reportBeech M35 · Pittsfield, MAThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB NYC05LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marstons Mills, MAThe pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.NTSB NYC05CA127Accident · No injuriesData collectionFinal reportYakovlev 55M · New Marlboro, MAThe pilot's improper weather evaluation which resulted in a precautionary off airport landing; and his improper flare which resulted in a hard landing. A factor in this accident was weather associated with thunderstorm activity.NTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.NTSB IAD05LA107Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Plymouth, MAFatigue failure of the intermediate tailrotor driveshaft, which resulted in a loss of directional control at a hover.NTSB IAD05LA111Accident · No injuriesLimited investigationFinal reportCessna 182T · Chatham, MAthe pilot's improper recovery from a bounced landing.NTSB NYC05LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Edgartown, MAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]NTSB NYC05LA103Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Beverly, MAThe pilot's failure to attain the proper touchdown point while conducting a precautionary landing. A factor was the partial loss of power to one engine for undetermined reasons.NTSB NYC05IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A330-301 · Boston, MAThe local east controller's failure to follow FAA Order 7110.65, para 3-9-8 and Boston Tower Order 7110.11, Standard Operating Procedures, which resulted in a runway incursion during takeoff involving two transport category airplanes.NTSB NYC05LA071Accident · No injuriesLimited investigationFinal reportBrennan Flightstar · Middleboro, MAA loss of engine power for undetermined reasons.NTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…NTSB IAD05LA044Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Boston, MAThe first officer's misjudgment of a perceived threat, which resulted in the captain's excessive braking and subsequent injury to a flight attendant. A factor was the night lighting conditions.NTSB NYC05IA052Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe mechanic's inadequate inspection, which failed to discover cracks in the left wing spar around wing station 114.NTSB IAD05LA030Accident · No injuriesLimited investigationFinal reportBeech G35 · Falmouth, MAThe pilot's failure to maintain control of the airplane during taxi. A factor was the snow-covered taxiway.NTSB IAD05LA017Accident · No injuriesLimited investigationFinal reportChumsae Kitfox Speedster · Sterling, MAThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and a total loss of engine power.NTSB NYC05CA019Accident · No injuriesData collectionFinal reportVigneau RAF 2000 GTX · Chatham, MAThe pilot's failure to maintain aircraft control during a takeoff. A factor related to the accident was the pilot's lack of experience in gyroplanes.NTSB IAD05CA014Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe pilot's improper decision to taxi on a closed taxiway, and his misjudgment of obstacle clearance.NTSB IAD05LA007Accident · 1 fatalLimited investigationFinal reportSanClemente Zenith CH 601HDS · Leominster, MAA loss of aircraft control for an undetermined reason.NTSB IAD05LA005Accident · No injuriesLimited investigationFinal reportBeech C24R · Hyannis, MAThe mechanic's failure to secure the fuel pressure line to the fuel pressure gauge fitting, which resulted in an engine compartment fire and a subsequent loss of engine power.NTSB IAD05LA002Accident · No injuriesLimited investigationFinal reportBradley Renegade · Stow, MAA partial loss of engine power for undetermined reasons, which resulted in the airplane's inability to climb over a stand of trees.NTSB NYC04CA202Accident · Minor injuriesData collectionFinal reportCessna 305A · Lawrence, MAThe pilot's inadvertent pickup of a banner towline with the airplanes main landing gear after encountering gusting wind conditions. A factor related to the accident was the gusting wind conditions.NTSB NYC04LA191Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Edgartown, MAThe pilot's failure to maintain airspeed while performing maneuvers to land, which resulted in an inadvertent stall/mush. A factor was the gusting wind conditions.NTSB NYC04LA186Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Marlboro, MAThe loss of engine power due to a stuck cylinder exhaust valve. Factors were the tailwind and a jammed engine cylinder exhaust valve.NTSB NYC04CA184Accident · No injuriesData collectionFinal reportPascucci RAF 2000 · Beverly, MAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.NTSB NYC04CA166Accident · No injuriesData collectionFinal reportRobinson R-44 II · Beverly, MAThe pilot's inadequate visual lookout, which resulted in a collision with transmission wires.NTSB IAD04LA028Accident · No injuriesLimited investigationFinal reportCessna 150 · Paxton, MAThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing. Factors included the pilot's use of a fuel gauge that was calibrated for a different model airplane, and a lack…NTSB NYC04FA136Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Leominster, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with trees. A factor related to the accident was the low cloud ceiling, and dark night.NTSB NYC04CA134Accident · Serious injuriesData collectionFinal reportCessna 172M · Worcester, MAThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind conditions. A factor in the accident was the gusting wind.NTSB NYC04LA133Accident · Serious injuriesLimited investigationFinal reportMosher Avid Heavy Hauler · Fitchburg, MAThe malfunction of the elevator control system, resulting in a forced landing.NTSB NYC04CA128Accident · Serious injuriesData collectionFinal reportCameron Balloons N90 · Whately, MAThe pilot's failure to maintain clearance from the trees. A factor was windshear.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 NYC04LA118Accident · 1 fatalLimited investigationFinal reportCessna T-50 · Sharon, MAThe loss of power in one engine for undetermined reasons. Factors were the excessive weight, and degraded climb performance.NTSB NYC04CA114Accident · Minor injuriesData collectionFinal reportCessna 305 A · Taunton, MAThe pilots inadequate pre-flight planning which resulted in a landing on soft terrain and subsequent nose over. A factor was the soft terrain.NTSB IAD04LA018Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Bedford, MAThe mechanic's failure to properly torque the engine-driven fuel pump's return line B-nut fitting.NTSB NYC04LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAThe pilot's misjudgment of altitude/distance and his failure to maintain adequate clearance from trees while landing. Factors related to the accident were the lack runway displaced threshold markings, the trees located at the end of the runway, and the…NTSB NYC04CA102Accident · No injuriesData collectionFinal reportCessna 172P · Westfield, MAThe student pilot's improper flare and his failure to maintain aircraft control while landing.NTSB NYC04FA093Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · Pittsfield, MAThe pilot's loss of aircraft control for undetermined reasons, which resulted in an inadvertent stall/spin and subsequent impact with the ground.NTSB NYC04CA091Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Norwood, MAThe student pilot failure to recover from a bounced landing. A factor in this accident was the student pilot's lack of solo flight experience.NTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.NTSB NYC04CA066Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Grt. Barrington, MAThe pilot's misjudgment of the airplane's distance/speed and failure to obtain the proper touchdown point, which resulted in an overrun. A factor was the cross wind.NTSB IAD04LA008Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Bedford, MAFailure of the #2 piston connecting rod cap, which resulted in a hole in the engine crankcase and a loss of engine power. A factor was dark night lighting condition.NTSB DCA04IA018Incident · No injuriesIncident investigationFinal reportEmbraer 135 · Bangor, MASevere wear of the internal threads of the rudder interconnection contol rod which led to disengagement.NTSB NYC04CA031Accident · No injuriesData collectionFinal reportPiper PA-18 · Westfield, MAThe pilot's failure to maintain aircraft control while landing.NTSB NYC04CA018Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Mansfield, MAThe pilot's failure to maintain directional control while landing.NTSB NYC04LA014Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Athol, MAThe loss of power due to disengagement of the magneto idler gear. Also causal was the improper reinstallation of the magneto during the annual inspection.NTSB NYC04CA003Accident · No injuriesData collectionFinal reportBoeing 737 · Boston, MAThe collision of a ground support vehicle with a parked aircraft, due to the faulty gearshift lever on the ground support vehicle.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 NYC03FA205Accident · 2 fatalField investigationFinal reportCessna 182T · Concord, MAThe pilot's failure to maintain aircraft control due to spatial disorientation. A factor was the low ceilings.NTSB NYC03LA204Accident · Serious injuriesLimited investigationFinal reportLaBarge Titan Tornado I · Charlton, MAA seizure of the forward piston during the initial climb.