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 NYC01LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA 31-350 · Nahant, MAA loss of engine power due to fuel exhaustion for undetermined reasons. A factor in this accident was the pilot's failure to visual check the airplane's fuel quantity prior to takeoff.NTSB NYC01LA111Accident · Minor injuriesLimited investigationFinal reportKnab-Douglas Jurca MJ5 Sirocco · G. Barrington, MAThe pilot's failure to obtain the proper touchdown point, which resulted in an overrun. A factor in this accident was the gusty wind condition.NTSB NYC01LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200ER · Boston, MAThe Boeing 767 captain's misjudgment of the distance between his airplane and the stationary Boeing 737, which resulted in a ground collision. A factor was sunglare.NTSB IAD01LA042Accident · No injuriesLimited investigationFinal reportCessna 172R · Lawrence, MAThe pilot's improper flare.NTSB NYC01LA093Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falmouth, MAThe pilot's failure to maintain directional control while landing. Factors were the pilot's inadequate weather evaluation and a tailwind.NTSB IAD01IA034Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10 · Boston, MAThe inadequate de-ice and preflight inspection procedure of the #2 engine inlet and bellmouth area by company maintenance personnel that resulted in ice ingestion and foreign object damage of the #2 engine.NTSB NYC01LA077Accident · No injuriesLimited investigationFinal reportFokker F28 MK 0100 · Boston, MAthe failure of the flight crew to follow the checklist prior to engine start, and their subsequent diverted attention during engine start.NTSB NYC01LA075Accident · No injuriesLimited investigationFinal reportBoeing B-737-832 · Boston, MAThe inadequate visual lookout by theMD-81's tug driver during the pushback operation.NTSB NYC01FA073Accident · Serious injuriesField investigationFinal reportCessna 402C · Edgartown, MAThe pilot's failure to maintain a stabilized approach with an adequate vertical and lateral track. Also causal was his failure to maintain obstacle clearance.NTSB NYC01LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Falmouth, MAThe pilot's improper decision to takeoff and attempt VFR flight in IMC conditions.NTSB NYC01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Somerset, MAThe pilot's inadequate visual lookout. A factor was the dusk lighting conditions.NTSB NYC01LA076Accident · Serious injuriesLimited investigationFinal reportBoeing 767-300ER · Boston, MAThe vehicle driver's improper decision to pass behind an aircraft with operating engines, which resulted in an encounter with jet blast.NTSB NYC01LA067Accident · No injuriesLimited investigationFinal reportRockwell 112A · Norwood, MAThe pilot's improper starting procedure, which resulted in an on-ground collision with a parked aircraft.NTSB IAD01LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Boston, MAThe airplane's inadvertent encounter with severe turbulence.NTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.NTSB NYC01FA005Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-26A · Edgartown, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with a tree. A factor related to the accident was the low cloud ceiling.NTSB NYC01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Marshfield, MAThe pilot's improper management of the fuel supply, which resulted in fuel starvation of the engine. A factor in the accident was the pilot's diverted attention to the inclement weather.NTSB NYC01LA002Accident · Serious injuriesLimited investigationFinal reportMaule M-5 · Leicester, MAThe pilot's failure to properly manage the fuel onboard the airplane, which resulted in fuel starvation, and a total loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while maneuvering for a field.NTSB NYC00LA269Accident · No injuriesLimited investigationFinal reportSaab 340B · Boston, MAThe operator's loss of control of the belt-loader, due to his improper decision to depress the vehicle's accelerator in the proximity of the airplane.NTSB NYC00LA252Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Northampton, MAThe pilot's improper preflight planning which resulted in an attempted takeoff from a taxiway. A factor in the accident was the fog.NTSB NYC00LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nantucket, MAThe pilot's failure to maintain the proper glide path to the runway. Factors related to the accident were the fog conditions and the pilot’s fatigue.NTSB NYC00LA238Accident · No injuriesLimited investigationFinal reportAviat A-1B · Newberryport, MAthe failure of the pilot to maintain directional control during landing and a subsequent rejected landing. Factors were the crosswind, and the delayed corrective action by the pilot.NTSB NYC00LA223Accident · No injuriesLimited investigationFinal reportCessna 150 · Bridgewater, MAThe mechanic's inadequate annual inspection, which resulted in a departure with fuel contamination. A factor was the pilot-in-command's inadequate preflight inspection.NTSB NYC00LA212Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Chatham, MAThe pilot's delayed use of the brakes, which resulted in a runway overrun. Factors in the accident were the pilot's improper decision to land with a right quartering tailwind.NTSB NYC00FA210Accident · 1 fatalField investigationFinal reportMooney M20E · Lunenburg, MAThe pilot's inadequate preflight planning which resulted in exhaustion of the fuel supply.NTSB NYC00LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norwood, MAthe pilot's improper bounced landing recovery. A factor was the pilot's lack of total flight experience.NTSB NYC00LA199Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Lawrence, MAThe pilot's failure to attain the proper touchdown point and his delayed remedial action. Also causal was the pilot's lack of recent experience. A factor in the accident was the tailwind condition.NTSB IAD00LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fitchburg, MApilot's inadequate compensation for the crosswind. A factor was the crosswind.NTSB NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.NTSB IAD00LA048Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Northampton, MAThe student pilot's failure to maintain directional control during takeoff.NTSB IAD00LA047Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Grt Barrington, MAThe pilot's failure to perform a go around and his inadequate recovery from a bounced landing. Factors in the accident were the pilot's s failure to maintain the proper glide path and to reach the proper touchdown point.NTSB IAD00LA046Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Sterling, MAThe pilot's failure to attain a proper touchdown point.NTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.NTSB IAD00FA038Accident · 1 fatalField investigationFinal reportPiper PA-12 · Norfolk, MAThe loss of power for undetermined reasons, which resulted in an inadvertent stall during at banner pick-up.NTSB NYC00LA109Accident · No injuriesLimited investigationFinal reportCessna 172 · North Adams, MAThe pilot's failure to obtain the proper touchdown point. A factor was a tailwind.NTSB NYC00IA100Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Boston, MAthe failure of the ground pushback crew to maintain an adequate clearance from a nearby airplane during pushback.NTSB NYC00FA092Accident · Minor injuriesField investigationFinal reportDassault DA-900 · Hyannis, MAThe flightcrew's inadequate coordination and improper weather evaluation. Also causal was the captain's improper decision to continue the approach to a runway with insufficient length and his failure to obtain the proper touch down point on the runway.…NTSB IAD00FA023Accident · 1 fatalField investigationFinal reportAerotechnik L-13 SEH Vivat · Plymouth, MAthe flight instructor's inadequate compensation for the wind conditions. A factor was the flight instructor's improper use of speed brakes and the strong gusty winds with downdrafts.NTSB NYC00IA078Incident · Minor injuriesIncident investigationFinal reportSaab-Scania 340B · Boston, MAThe vehicle driver's inadequate visual lookout.NTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.NTSB NYC00FA058Accident · 1 fatalField investigationFinal reportCessna 172P · Leominster, MAThe student pilot's failure to see and avoid the private pilot's airplane. Factors included the student pilot's non-standard traffic pattern entry, the private pilot's failure to check for other traffic before turning onto final, and the position of the sun…NTSB IAD00LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Hopedale, MAwas the student pilot's improper flare that resulted in a bounced landing and the flight instructor's delay in taking remedial action.NTSB NYC00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hopedale, MAThe nose landing gear was not locked in the extended position.NTSB NYC00LA017Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orange, MAThe pilot's failure to maintain directional control during a sudden wind shift.NTSB NYC00FA006Accident · 2 fatalField investigationFinal reportRaytheon Corporate Jets BE-200 · Williamstown, MAThe pilot-in-command's failure comply with an air traffic control clearance which resulted in a collision with terrain. A factor in this accident was clouds.NTSB NYC99IA239Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Nantucket, MAA fractured turbine wheel.NTSB NYC99LA230Accident · No injuriesLimited investigationFinal reportCessna 182 · Pepperell, MAA landing gear bolt failure for undetermined reasons.NTSB NYC99FA222Accident · 2 fatalField investigationFinal reportCessna 337C · North Adams, MAthe failure of the pilot of the Cessna 305 to follow the instructions issued, and maintain a low altitude. A factor was the delay in evasive action by the pilot of the Cessna 337 after he was first advised that the Cessna 305 was climbing.NTSB IAD99LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Nantucket, MAthe pilot's inadequate recovery from a bounced landing which resulted in a hard landing and the fracture and collapse of the right main landing gear.NTSB NYC99FA216Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Plymouth, MAThe flight instructor's inadequate remedial action, and the pilot-under-instruction's panic and subsequent interference with the flight controls.