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 NYC93LA156Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Lawrence, MAThe improper installation of the battery box cover by maintenance personnel.NTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…NTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.NTSB BFO93LA127Accident · No injuriesLimited investigationFinal reportCessna 172P · Edgartown, MAThe pilot failed to maintain directional control during takeoff. Other related factors were: the tailwind, and the gross weight of the airplane being exceeded.NTSB BFO93LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Falmouth, MAThe pilot's inadequate compensation for wind conditions and improper recovery from a bounced landing. The gusty wind condition was a related factor.NTSB NYC93LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Spencer, MAThe pilot's inadequate preflight planning for the high density altitude departure and the delay in aborting the takeoff roll, with insufficient runway remaining, resulting in a collision with treesNTSB NYC93LA120Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Palmer, MAThe loss of engine power for undetermined reasons. A factor was lack of suitable terrain for the forced landing.NTSB NYC93FA118Accident · 3 fatalField investigationFinal reportCessna P210 · Marthas Vineyrd, MAThe pilot's failure to maintain control of the airplane.NTSB NYC93FA110Accident · 1 fatalField investigationFinal reportSkillman Thorp T-18 · Chatham, MAthe pilot's performance of an aerobatic maneuver, with insufficient altitude for recovery, resulting in a collision with the waterNTSB NYC93LA106Accident · Serious injuriesLimited investigationFinal reportHenry J. Camacho Seahawk · Orange, MAThe pilot's excessive rotation and failure to obtain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the pilot's inexperience in the type aircraft.NTSB NYC93LA105Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Provincetown, MAThe pilot's failure to recover from a bounced landing and to maintain aircraft control which resulted in the airplane nosing over. Improper landing flare is a contributing factor.NTSB BFO93LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Marlboro, MAThe pilot failed to maintain control of the airplane during landing. Related to the accident was the excessive airspeed.NTSB BFO93LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner Falls, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB NYC93LA086Accident · No injuriesLimited investigationFinal reportPitts S1T · Halifax, MADetachment of the throttle cable at the fuel injector arm. Soft terrain in the emergency landing area was a related factor.NTSB NYC93FA076Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Oxford, MAThe pilot's selection of the wrong runway for takeoff which resulted in not being able to obtain adequate airspeed for climbout. A factor which contributed to the accident was the tailwind.NTSB NYC93LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Orange, MAThe pilot failed to maintain control of the airplane resulting in the airplane departing the runway and impacting with a snow bank.NTSB BFO93FA018Accident · 1 fatalField investigationFinal reportCessna 182P · Stow, MAAn inadequate preflight by the pilot, which allowed water contamination in the fuel and subsequent loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall.NTSB NYC93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Great Barrington, MAThe inadequate pre-flight by the pilot ensuring fuel cap security. A factor in this accident was the pilots complacency in fuel management.NTSB NYC93FA026Accident · 2 fatalField investigationFinal reportBeech 55 · Leicester, MAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were the pilot's lack of recent flight experience and his lack of recent instrument experienced.NTSB NYC93LA023Accident · No injuriesLimited investigationFinal reportCessna C-152 · Petersham, MAThe imprpoer maintenance procedures which resulted in engine failure and subsequent forced landing on unsuitable terrain.NTSB NYC93LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newburyport, MAThe pilot's inaccurate fuel consumption calculations and improper preflight planning, resulting in fuel exhaustion.NTSB BFO92LA148Accident · No injuriesLimited investigationFinal reportMooney M20E · Stow, MAFailure of the pilot to attain proper runway alignment during landing. Factors related to the accident were darkness, a lack of runway lighting on the left side of the runway, and the pilot's lack of visual ques.NTSB BFO92LA143Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1A · Bedford, MAInadequate maintenance inspection which failed to reveal a deteriorated rudder cable which subsequently failed and caused loss of directional control.NTSB BFO92IA145Incident · No injuriesIncident investigationFinal reportLockheed L1011-385 · Boston, MAInadequate lubrication which caused stress corrosion cracking and the separation of the right wing number two flap vane.NTSB BFO92FA151Accident · 3 fatalField investigationFinal reportCessna R182 · Edgartown, MAThe pilots's lack of regard for the published decision height of the approach and his decision not to execute a missed approach. Factors contributing to the accident include the pilot's failure to attain the proper glidepath and descent rate during the…NTSB BFO92LA147Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, MAThe pilot's abrupt application of the brakes which resulted in the airplane nosing over.NTSB BFO92FA131Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Conway, MAThe pilot's failure to maintain clearance above the trees. A possible factor related to the accident was the pilot's use of a prescription drug.NTSB BFO92LA121Accident · No injuriesLimited investigationFinal reportCessna 172H · New Braintree, MAWater contaminated fuel which resulted in the loss of engine power and the pilot's inadequate preflight inspection.NTSB BFO92LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Great Barringto, MAThe pilot's failure to recover from a bounced landing. Factors related to the accident were the pilot's inadequate flare and failure to maintain directional control.NTSB NYC92LA177Accident · No injuriesLimited investigationFinal reportAerostar AX-9 · Hopkinton, MAThe pilot's inflight planning which resulted in a forced landing in unsuitable terrain due to fuel exhaustion.NTSB NYC92LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Newburyport, MAThe loss of engine power for undetermined reasons.NTSB NYC92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bedford, MAThe pilot's loss of airplane control during the flare, resulting in porpoising and subsequent hard landing.NTSB NYC92LA178Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Nantucket, MAThe pilot's failure to use carburetor heat, resulting in carburetor ice and loss of engine power and subsequent forced landing in the ocean.NTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.NTSB BFO92LA113Accident · No injuriesLimited investigationFinal reportStinson JR.SR. · Hanson, MAThe pilot inadequate compensation for wind which resulted in the loss of directional control.NTSB BFO92LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Marston Mills, MAThe pilot's inadequate preflight preparation. Contributing was the pilot's failure to use all available runway and overconfidence in his own abilities.NTSB BFO92LA102Accident · No injuriesLimited investigationFinal reportBell 47G · Southwick, MAImproper adjustment of the stabilizer control system by maintenance personnel.NTSB NYC92LA128Accident · No injuriesLimited investigationFinal reportFairchild SA-227AC · Boston, MAThe loss of airplane control during a crosswind landing resulting in a hard bounced landing and a collision with the runway.NTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.NTSB NYC92LA113Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Hadley, MAA power loss of undetermined origin while operating over unsuitable terrain.NTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.NTSB BFO92LA062Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Middleboro, MAThe pilot's failure to release a tie down strap from the helicopter's skid during the preflight.NTSB BFO92LA052Accident · Serious injuriesLimited investigationFinal reportBeech 24 · Millis, MAThe pilot's failure to attain adequate flying speed during takeoff climb which resulted in a stall and inflight collision with the terrain. Contributing was a downwind takeoff.NTSB NYC92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tewksbury, MAThe failure of the pilot to compensate for adverse winds, which resulted in a bounced landing, subsequent loss of airspeed and airplane control.NTSB NYC92LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Palmer, MAThe improper use of carburetor heat which resulted in a power loss due to carburetor ice over unsuitable terrain. Factors related to the accident were the carburetor icing conditions and the failure of the pilot to be aware of the temperature/dewpoint spread.NTSB NYC92LA065Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Plymouth, MAThe failure of the pilot to use carburetor heat which resulted in the formation of carburetor ice and a subsequent loss of engine power and forced landing in trees.NTSB BFO92LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · East Taunton, MAInadequate preflight by the dual student and inadequate supervision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB BFO92LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Edgartown, MAFailure of the pilot to attain adequate airspeed, which resulted in a stall. Factors related to the accident were the crosswind, the pilot's inadequate compensation for the wind and failure to maintain proper alignment with the runway, and high obstructions.NTSB NYC92FA047Accident · 1 fatalField investigationFinal reportPiper PA-23-235 · Fall River, MAThe pilot did not follow IFR proceedures and was manuvering at too low an altitude to remain clear of the terrain. Factors in the accident were; fatigue, fog and no visual ground clues.NTSB NYC92LA034Accident · Minor injuriesLimited investigationFinal reportRyan 260-B · Barre, MAA total loss of engine power in cruise flight due to fuel starvation resulting in a forced landing and collapse of the landing gear during the landing roll. A factor related to the accident was a leaking fuel selector valve.