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 NYC99LA204Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Mansfield, MAWas the student pilot's failure to maintain lateral control of the helicopter while bringing it to a hover. A factor in the accident was the student pilot's lack of total experience in helicopters.NTSB NYC99LA195Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chatham, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.NTSB NYC99LA158Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Marston Mills, MAThe inadvertent control interference of the airplane's brakes by the passenger. A factor related to the accident was the pilot in commands insufficient passenger briefing.NTSB NYC99LA151Accident · No injuriesLimited investigationFinal reportLearjet 60 · Hyannis, MAThe flightcrew's inadequate coordination and their failure to utilize checklists. Also causal was the captain's improper decision to continue the approach to a runway with insufficient length. A factor in the accident was the improper maintenance.NTSB NYC99FAMS3Accident · 1 fatalMissing aircraftFinal reportPiper PA28RT-201T · Plymouth, MAundetermined (missing airplane)NTSB NYC99LA092Accident · No injuriesLimited investigationFinal reportSaab-Scania 340B · Boston, MAThe belt-loader driver's loss of control of the vehicle, and his failure to follow published procedures for approaching the airplane with the belt-loader.NTSB NYC99LA086Accident · No injuriesLimited investigationFinal reportCessna 172P · Lawrence, MAThe student pilot's improper flare, and his improper recover from a bounced landing.NTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.NTSB NYC99LA052Accident · No injuriesLimited investigationFinal reportBeech 1900D · Hyannis, MAThe captain's improper placement of the power levers in the BETA position, while the airplane was inflight. Factors were the fog and dusk conditions.NTSB NYC99LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Methuen, MAThe pilot's failure to ensure the engine primer was in and locked prior to takeoff which resulted in a loss of engine power. A factor in this accident was the pilot's lack of experience in airplanes equipped with reciprocating engines.NTSB NYC99FA026Accident · 1 fatalField investigationFinal reportCessna 414A · Mattapoisett, MAThe pilot's failure to maintain control of the airplane after an undetermined failure of the airplane's attitude indicator. A factor in this accident was fog.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 NYC99LA013Accident · Serious injuriesLimited investigationFinal reportGoodyear Aerospace GZ-20-A · Bedford, MAThe separation of the pull-in-line. A factor in the accident was the gusting winds.NTSB NYC98LA190Accident · No injuriesLimited investigationFinal reportCessna 172 · Stow, MAThe pilot's improper recovery from a bounced landing. Contributing factors were the pilot's lack of a single engine experience/certification. Also a factor was the flying club's inadequate oversight of pilot qualifications.NTSB NYC98LA183Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chatham, MAthe failure of the pilot to maintain airspeed during a go-around and which resulted in an inadvertent stall. Factors in the accident were the pilot's lack of total experience and the gusting crosswinds.NTSB IAD98LA102Accident · No injuriesLimited investigationFinal reportCessna 185 · Westport, MAThe flight instructor's failure to maintain control of the airplane and his delayed decision to go-around. Factors related to the accident were the flight instructor's improper inflight decision to land downwind and his inadequate compensation for wind.NTSB NYC98LA171Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Marston Mills, MAThe pilot's improper landing flare and his delayed go-around.NTSB NYC98FA161Accident · 2 fatalField investigationFinal reportCessna 150M · Worthington, MAThe pilot's failure to maintain airspeed due to diverted attention.NTSB NYC98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Nantucket, MAThe student pilot's failure to perform a go-around. A factor in the accident was the tailwind.NTSB IAD98LA093Accident · No injuriesLimited investigationFinal reportCessna 182 · Edgartown, MAwas the pilot's improper flare prior to touchdown.NTSB NYC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Taunton, MAa delayed decision by the pilot to abort the takeoff, which resulted in an overrun. A factor was false reading from the airspeed indicator.NTSB NYC98FA124Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Dalton, MAThe pilot's decision to continue the flight into instrument meteorological conditions, resulting in a loss of control, and airplane stress limits to be exceeded. Factors in the accident, the pilot's decision to disregard the preflight weather briefing, and…NTSB IAD98LA064Accident · No injuriesLimited investigationFinal reportCessna 172D · Beverly, MAfailure of the pilot to maintain control of the airplane during the landing and attempted go-around. A related factor was the crosswind.NTSB NYC98FA117Accident · 1 fatalField investigationFinal reportMorelli Rans S9 · Taunton, MAThe pilot's operation of the aircraft in an unapproved configuration contrary to procedures resulting in diminished aircraft control, and his failure to maintain control of the aircraft resulting in a stall/spin event. Contributing factors were the…NTSB NYC98GA113Accident · 2 fatalFinal reportCessna 182R · Middleborough, MAThe pilot-in-command's failure to maintain control of the airplane during a VFR go-around. A factor was the impairment due to drugs.NTSB NYC98FA111Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Lincoln, MAThe pilot's failure to maintain airspeed.NTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.NTSB NYC98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · New Bedford, MAThe pilot's impairment due to alcohol, which resulted in an inadequate preflight examination and subsequent takeoff with a control lock installed.NTSB NYC98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAloss of engine power for undetermined reason(s), which resulted in a forced landing and subsequent nose-over on uneven terrain. Uneven terrain (furrow) in the forced landing area was a related factor.NTSB IAD98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haverhill, MAA loss of engine power due to a fractured number two cylinder exhaust valve and cracked cylinder. Contributing factors were the operator's allowance of the time between engine overhaul to be exceeded and the trees.NTSB NYC98FA063Accident · 1 fatalField investigationFinal reportCessna 172K · Boxborough, MAThe failure of the pilot to remove the frost on the wings before departure, which resulted in a stallNTSB IAD98LA025Accident · No injuriesLimited investigationFinal reportCessna 172K · Oxford, MAThe pilot's failure to maintain directional control.NTSB NYC98LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Mansfield, MAThe pilot's failure to remove snow and ice from the aircraft prior to takeoff resulting in degraded climb performance and a subsequent stall/mush condition.NTSB NYC98LA042Accident · No injuriesLimited investigationFinal reportCessna 182P · Chatham, MAloss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.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 NYC98FA034Accident · 2 fatalField investigationFinal reportBeech BE-S35 · Chatham, MAThe pilot's failure to maintain adequate airspeed during initial climb which resulted in an inadvertent stall and subsequent impact into trees. Related factors were high wind and turbulence.NTSB NYC98FA024Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Fitchburg, MAThe flight instructor's inadequate in-flight decision and his failure to maintain adequate airspeed which resulted in a loss of control. Contributing was the flight instructor's failure to follow standard practices while simulating and practicing emergency…NTSB IAD98LA006Accident · No injuriesLimited investigationFinal reportAviat A-1 · Duxbury, MAFailure of the pilot to maintain control of the airplane. A related factor was the wind gusts.NTSB NYC98LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittsfield, MAThe pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.NTSB NYC98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Edgartown, MAThe pilot's inadequate evaluation of the wind direction and his failure to initiate a go-around. Contributing factors were the tailwind, wet runway, and utility pole.NTSB NYC98LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Gt. Barrington, MAslippage of the number 2 main bearing for undetermined reason(s) which resulted in a broken crankshaft.NTSB IAD97FA123Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Pittsfield, MAThe first pilot's improper procedures for an autorotation, and improper flare which resulted in a hard landing. Also causal was the second pilot's inadequate remedial action.NTSB NYC97LA183Accident · No injuriesLimited investigationFinal reportCessna 402C · Nantucket, MAthe pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.NTSB NYC97FA173Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Hancock, MAThe pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.NTSB IAD97LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Westfield, MAThe pilot's inadequate preflight preparation which fail to include a weight and balance check and his subsequent failure to maintain aircraft control.NTSB IAD97LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAInadequate compensation for wind conditions by the pilot. A related factor was the crosswind.NTSB NYC97LA150Accident · No injuriesLimited investigationFinal reportCessna 172E · Fitchburg, MAA loss of engine power for undetermined reasons.NTSB IAD97LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Edgartown, MAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Related factors were the crosswind, wind gusts and high vegetation.NTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..