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 ERA09CA063Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe student pilot's inadequate compensation for winds during landing.NTSB NYC08CA327Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Beverly, MAAn inadvertent collision with a deer while landing.NTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.NTSB MIA08LA186Accident · No injuriesLimited investigationFinal reportTetrault Ronad Team Mini Max 1500R · Berkley, MAThe total loss of engine power due to the contamination of the combustion cylinders.NTSB MIA08FA163Accident · 3 fatalField investigationFinal reportBeech G35 · South Easton, MAThe pilot's failure to maintain control of the airplane while attempting to execute an instrument approach in instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument currency.NTSB NYC08CA274Accident · No injuriesData collectionFinal reportBoeing E75 · Sterling, MAThe owner/pilot's improper flare. Contributing to the accident was the pilot-in-command's inadequate remedial action.NTSB NYC08FA218Accident · 1 fatalField investigationFinal reportDehavilland DHC6 · Hyannis, MAThe pilot's failure to remove the flight control lock prior to takeoff. Contributing to the accident was the Federal Aviation Administration's failure to issue an airworthiness directive making the manufacturer's previously-issued flight control lock service…NTSB LAX08CA172Accident · No injuriesData collectionFinal reportCessna T337G · GreatBarrington, MAThe pilot's misjudgment of distance and altitude, and failure to attain the proper touchdown point. The pilot's delayed remedial action was also causal.NTSB MIA08CA107Accident · No injuriesData collectionFinal reportWaco GXE · Provincetown, MAThe pilot's failure to maintain directional control while landing.NTSB MIA08CA084Accident · No injuriesData collectionFinal reportGrumman American AA5B · Marlboro, MAThe pilot's inadequate compensation for wind gusts while on final approach.NTSB MIA08CA071Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Norwood, MAThe failure of the flightcrew to maintain directional control of the airplane.NTSB MIA08LA041Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Norwood, MAThe loss of engine power for undetermined reasons. *This report was modified on May 20, 2008.*NTSB MIA08CA045Accident · No injuriesData collectionFinal reportCessna 172P · Northampton, MAThe student pilot's failure to maintain directional control of the airplane during the takeoff roll and inadequate supervision by the CFI.NTSB MIA08CA017Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hyannis, MAThe student pilot's mismanagement of the fuel supply and the flight instructor's inadequate supervision.NTSB NYC07CA225Accident · No injuriesData collectionFinal reportPiper J3L-65 · Stow, MAA partial loss of engine power for undetermined reasons.NTSB ATL07FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Mansfield, MAThe pilot's improper use of wing flaps during takeoff, which resulted in reduced climb performance and a subsequent stall. Contributing to the accident was the exceedance of the airplane's maximum gross weight.NTSB NYC07LA214Accident · No injuriesLimited investigationFinal reportCessna 172R · Boston, MAThe air traffic controller's improper taxi clearance.NTSB ATL07LA115Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Siassconset, MAThe non-instrument rated pilot's loss of control at night in instrument flight conditions due to spatial disorientation. A factor was the pilot's in-flight decision not to inform the controller that he was not instrument rated.NTSB ATL07CA114Accident · No injuriesData collectionFinal reportWaco Classic YMF-5 · Nantucket, MAThe pilot's failure to maintain control of the airplane during takeoff roll, which resulted in an on ground collision with an airport sign.NTSB NYC07CA165Accident · No injuriesData collectionFinal reportPiper J3C-65 · Uxbridge, MAA partial loss of engine power for undetermined reasons.NTSB ATL07CA105Accident · No injuriesData collectionFinal reportCessna 172S · Beverly, MAThe pilot's improper flare, which resulted in a hard landing and nose gear collapse. A contributing factor was the wind gust.NTSB ATL07LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Gardner, MAThe pilot's failure to maintain control of the airplane during an aborted landing.NTSB ATL07FA102Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Tyringham, MAThe pilot's inadvertent encounter with thunderstorms during cruise flight. Contributing to the accident was the failure of air traffic control to appropriately issue weather information and initiate an in-flight deviation around known and clearly observed…NTSB NYC07FA130Accident · 1 fatalField investigationFinal reportMooney M20J · Canton, MAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.NTSB MIA07LA092Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Marstons Mill, MAThe pilot's improper preflight planning and preparation resulting in an in-flight loss of engine power due to fuel exhaustion.NTSB NYC07CA090Accident · Serious injuriesData collectionFinal reportNavion A · Marlboro, MAThe pilot's failure to maintain a proper glidepath to the runway.NTSB NYC07LA081Accident · No injuriesLimited investigationFinal reportCessna 500 · Beverly, MAThe inadequate guidance and procedures provided by the airplane manufacturer regarding operation of the pneumatic de-icing boots. Also causal was the Federal Aviation Administration's inadequate directives which failed to require manufacturers to direct…NTSB NYC07LA077Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during a hover, and the flight instructor's delayed remedial action.NTSB NYC07CA074Accident · No injuriesData collectionFinal reportMooney M20R · Marshfield, MAA loss of directional control for undetermined reasons.NTSB NYC07FA065Accident · 3 fatalField investigationFinal reportSocata TBM 700 · Dartmouth, MABoth pilots' failure to maintain aircraft control during a missed approach.NTSB NYC07CA093Accident · No injuriesData collectionFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during landing, and the flight instructor's delayed remedial action.NTSB NYC07CA046Accident · No injuriesData collectionFinal reportCessna 172R · Northhampton, MAThe pilot's inadequate recovery from a bounced landing.NTSB NYC06IA229Incident · No injuriesIncident investigationFinal reportAmerican Blimp A-60+ · Manchester, MAA malfunction of the rudder control system, and the pilot's inadequate preflight inspection. Contributing to the incident was the inadequate design of the chain keeper guards.NTSB NYC06LA224Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · East Bridgewate, MAThe completion center's installation of the incorrect (shorter) release cable, and the ground crewmember's improper movement under the flight path during a bin transfer.NTSB NYC06CA195Accident · Minor injuriesData collectionFinal reportChampion 7KCAB · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB NYC06CA168Accident · No injuriesData collectionFinal reportLiberty Aerospace XL2 · Mansfield, MAThe pilot's improper recovery from a bounced landing.NTSB NYC06CA152Accident · No injuriesData collectionFinal reportCessna 182F · Beverly, MACollapse of the nose landing gear for an undetermined reason.NTSB NYC06IA143Incident · No injuriesIncident investigationFinal reportCessna 172S · Lawrence, MAForeign object damage to the leading edge of the propeller blade, which resulted in fatigue cracking and subsequent blade failure.NTSB NYC06LA124Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Vineyard Haven, MAThe pilot's improper preflight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB NYC06LA114Accident · Minor injuriesLimited investigationFinal reportEmbraer EMB-145-LR · Boston, MAThe tug driver's inadequate visual lookout, which resulted in a collision with a parked airplane. A factor was the fog.NTSB NYC06LA101Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Norwood, MAImproper maintenance, which resulted in a fatigue fracture of the dual magneto mounting flange, and a subsequent loss of engine power.NTSB NYC06LA092Accident · Minor injuriesLimited investigationFinal reportMichaud KR2S · North Andover, MAA partial loss of engine power for undetermined reasons, during the initial climb, which resulted in a forced landing into trees.NTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.NTSB NYC06LA074Accident · No injuriesLimited investigationFinal reportBoeing 757-232 · Boston, MAThe deice vehicle driver's failure to maintain clearance from a standing airplane, which resulted in a collision between the deice vehicle and left elevator of the airplane.NTSB NYC06CA065Accident · No injuriesData collectionFinal reportCessna A185F · Pembroke, MAThe pilot's failure to maintain control during the takeoff roll, which resulted in a ground loop and subsequent impact with trees. A factor was the soft runway as reported by the pilot.NTSB NYC06CA059Accident · No injuriesData collectionFinal reportCessna R182 · Bedford, MAThe pilot's improper flare resulting in a hard landing. A factor in the accident was the wind gusts.NTSB NYC06CA049Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Lawrence, MAThe pilot's improper flare and recovery from a bounced landing.NTSB NYC06IA044Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Boston, MAWater dilution of the grease, which resulted in the failure of the number 4 wheel bearing.NTSB NYC06FA040Accident · 1 fatalField investigationFinal reportBeech B-55 · Nantucket, MAThe pilot's failure to maintain the proper glidepath during the instrument approach, which resulted in controlled flight into water. Factors were the failure of the air traffic controllers to issue minimum safe altitude warnings, night lighting conditions,…NTSB NYC06LA039Accident · 1 fatalLimited investigationFinal reportRogers Lancair 360 · Vineyard Haven, MAA loss of engine power for undetermined reasons.