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 NYC03FA203Accident · 1 fatalField investigationFinal reportCessna 402C · Nantucket, MAThe pilot's failure to maintain aircraft control during a missed approach. Factors in this accident were fog and the night light conditions.NTSB NYC03MA183Accident · 2 fatalMajor investigationFinal reportBeech 1900D · Yarmouth, MAThe improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…NTSB NYC03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Newburyport, MAThe pilot's inadequate compensation for the wind conditions and his inadequate flare.NTSB NYC03CA157Accident · Minor injuriesData collectionFinal reportRolladen-Schneider LS-4 · Ashburnham, MAThe pilot's improper in-flight decision to over fly a suitable landing area. Factors in this accident were weak thermal lift activity, and lack of suitable terrain at the time of the landing.NTSB NYC03LA159Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Taunton, MAThe pilot's failure to maintain directional control while landing and the CFI's delayed remedial action.NTSB NYC03LA135Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135-KL · Boston, MAThe tug driver's failure to maintain directional control of the tug, which caused the tug to impact the airplane.NTSB NYC03FA132Accident · 1 fatalField investigationFinal reportAviat A-1 · Tyringham, MAThe pilot's incapacitation due to a heart attack, which resulted in a loss of aircraft control.NTSB NYC03LA125Accident · No injuriesLimited investigationFinal reportCessna 172L · Newburyport, MAThe pilot's failure to attain the proper touchdown point.NTSB NYC03LA101Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Boston, MAThe operator's loss of control of the belt-loader while operating in the proximity of the airplane.NTSB IAD03LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe student pilot's misjudgment of his traffic pattern altitudes, which resulted in a premature descent into a tree.NTSB IAD03FA043Accident · 6 fatalField investigationFinal reportBeechcraft B200 · Leominster, MAThe pilot's low altitude maneuver using an excessive bank angle, and his failure to maintain airspeed which resulted in an inadvertent stall and subsequent collision with a building. A factor was the pilot's impairment from prescription medications.NTSB NYC03LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Taunton, MAThe pilot's inadequate compensation for the winds, and his failure to maintain airspeed which resulted in the inadvertent stall. A factor in the accident was the tailwind.NTSB NYC03FA061Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Monterey, MAThe pilot's improper decision to attempt a visual flight rules (VFR) flight in marginal VFR weather conditions over mountainous terrain, which resulted in an in-flight collision with trees. Factors in this accident were clouds and night light conditions.NTSB IAD03LA033Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 162F · Westford, MAThe inflight loss of control due to the loss of tail rotor effectiveness.NTSB NYC03LA045Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Pittsfield, MAThe pilot's failure to maintain control, which resulted in a rollover. Factors in this accident were the night light conditions, ice covered ramp and a snowbank.NTSB NYC03LA028Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Dalton, MAThe pilot's inadequate preflight inspection of the aircraft, which resulted in a total loss of engine power due to fuel contamination. A factor was the cold air temperature.NTSB IAD03LA022Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Leeds, MAThe flight instructor's failure to ensure adequate fuel onboard, which resulted in fuel exhaustion and a total loss of engine power.NTSB NYC03LA025Accident · No injuriesLimited investigationFinal reportCessna 172G · Stow, MAThe pilot's failure to maintain adequate altitude/clearance. A factor in this accident was gusty wind conditions.NTSB NYC03LA019Accident · 2 fatalLimited investigationFinal reportMooney M20R · Vineyard Haven, MAThe pilot's spatial disorientation during a missed approach, which resulted in a loss of control, and the airplane's subsequent impact with water. Factors included clouds, rain, and night lighting conditions.NTSB NYC03LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, MAThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel contamination. Factors in this accident were the corroded fuel tanks caps, and an inadequate annual inspection.NTSB IAD03IA007Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Boston, MAAn inadvertant collision with birds during the initial climb out.NTSB NYC03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Edgartown, MAThe pilot's inadequate in-flight evaluation of the landing facilities wind conditions, and inadequate airspeed resulting in a stall/mush. A factor related to the accident was the tailwind condition.NTSB IAD02LA094Accident · 1 fatalLimited investigationFinal reportGarlick OH-58AT · Rochester, MAThe pilot's failure to center the sling load prior to commencing forward flight. Also causal, was the pilot's improper decision to attempt a takeoff with a quartering tailwind, which resulted in an engine compressor stall.NTSB IAD02LA092Accident · No injuriesLimited investigationFinal reportGoff Glassair · Stow, MAThe pilot's improper positioning of the throttle during engine start, which resulted in his inability to maintain control of the airplane.NTSB NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.NTSB NYC02LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · New Bedford, MAThe pilots failure to obtain the proper touchdown point, and the CFI's delay in remedial action.NTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…NTSB NYC02LA163Accident · No injuriesLimited investigationFinal reportNiemann Champion II · Foxboro, MAThe pilot's failure to maintain aircraft control during the landing flare.NTSB IAD02TA081Accident · 1 fatalFinal reportCrawford Widebody Long EZ · Martha's Vineyard, MAPilot incapacitation from a massive subarachnoid hemorrhage (stroke.)NTSB NYC02LA143Accident · No injuriesLimited investigationFinal reportBeech 58 · Provincetown, MAThe pilot's failure to initiate a timely go-around, which resulted in his landing the airplane long and fast. Factors included low ceilings and the airplane's initial misalignment with the runway.NTSB NYC02LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Newburyport, MAA power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.NTSB NYC02LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Worcester, MAThe failure of the nose wheel actuator o-ring.NTSB NYC02LA099Accident · No injuriesLimited investigationFinal reportBoucher Revolution Mini 500 · Sterling, MAA misalignment of the rotor system drive belt, which resulted in belt chaffing, its subsequent separation, and a resultant loss of power to the rotor system. Also causal was the relatively low altitude and airspeed at which the separation occurred, which…NTSB IAD02LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Norwood, MAThe student pilot's failure to maintain directional control during an aborted landing.NTSB NYC02LA052Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Marlborough, MAThe pilot's failure to achieve a proper touchdown point on the runway which resulted in an overrun. A factor was the pilot's lack of experience in short field operations.NTSB IAD02LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, MAThe pilot's delayed aborted landing and his failure to attain obstacle clearance. The pilot's misjudgment of distance is a contributing factor.NTSB NYC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Nantucket, MAa loss of engine power for undetermined reasons.NTSB NYC02LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · Sterling, MAThe student pilots inadequate compensation for wind conditions which resulted in an off-field landing, and the CFI's improper decision to allow the student to fly solo. Factors related to the accident were the gusting wind conditions, and the students lack of…NTSB NYC02LA042Accident · Serious injuriesLimited investigationFinal reportRaytheon BE-1900D · Boston, MAThe passengers misjudged step, which resulted in a loss of balance and subsequent fall.NTSB NYC02LA036Accident · No injuriesLimited investigationFinal reportRockwell NA-265-80 · Boston, MAThe failure of the left thrust reverser assembly due to fatigue.NTSB NYC02FA032Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Falmouth, MAThe incapacitation of the pilot for undetermined reasons which resulted in an in-flight collision with water.NTSB NYC02LA010Accident · No injuriesLimited investigationFinal reportCessna 172L · Northampton, MAThe pilots' failure to maintain airspeed, which resulted in a loss of control and a hard landing.NTSB IAD01LA099Accident · No injuriesLimited investigationFinal reportCessna 150J · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB NYC01LA195Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Hanson, MAThe pilot's failure to maintain aircraft control during the takeoff.NTSB NYC01FA189Accident · 1 fatalField investigationFinal reportPiper PA-46-350 · Westfield, MAThe pilot's failure to maintain aircraft control while maneuvering during a go-around.NTSB NYC01LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Stow, MAThe pilot's failure to maintain airplane control during a go-around.NTSB NYC01LA166Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Boston, MAThe pilot's improper decision to waive the wake turbulence hold time, and his subsequent loss of control when wake vortex turbulence was encountered.NTSB NYC01LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Plymouth, MAThe pilot's failure to ensure the magnetos were off prior to rotating the propeller, which resulted in an unintentional engine start and subsequent unmanned taxi.NTSB IAD01LA069Accident · Serious injuriesLimited investigationFinal reportBucker Jungmann C.A.S.A. 1.131 · Plymouth, MAThe pilot's failure to maintain altitude during an approach and inadequate visual lookout, which resulted in a collision with a runway sign.NTSB NYC01FA128Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Danvers, MAThe pilot's failure to maintain aircraft control. Factors in the accident were the dark night, low ceiling, reduced visibility, and the pilot's decision to attempt a visual flight rules flight in marginal weather conditions.