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 ERA11LA489Accident · No injuriesLimited investigationFinal reportCessna 172N · Plymouth, MAThe pilot's inadequate flare and improper recovery from a bounced landing.NTSB DCA11CA084Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Boston, MAthe B767 Captain's failure to maintain a safe clearance between his wing and the tail of the CRJ900 that was stopped on a taxiway.NTSB ERA11LA379Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Egremont, MAA partial loss of engine power due to the No. 4 intake and exhaust valves becoming lodged in the valve guides, which resulted from a lack of use, improper engine storage preparation, and improper return to service from indefinite storage.NTSB ERA11LA383Accident · No injuriesLimited investigationFinal reportCessna 150L · Plymouth, MAA partial loss of engine power during initial climb due to a stuck cylinder valve, which resulted from excessive corrosion and carbon deposits on the valve springs due to inadequate maintenance.NTSB ERA11CA371Accident · No injuriesData collectionFinal reportCessna 172M · North Adams, MAThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from a light pole while taxiing.NTSB ERA11CA350Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Sterling, MAThe pilot's misjudgment of the amount of flaps required to attain the proper touchdown point. Contributing to the accident was the pilot's limited experience in the high performance glider.NTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.NTSB ERA11CA235Accident · No injuriesData collectionFinal reportRobinson R22 · Marlboro, MAThe student pilot's failure to maintain directional control during takeoff.NTSB ERA11LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Vineyard Haven, MAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11CA199Accident · No injuriesData collectionFinal reportLuscombe 8E · Taunton, MAThe pilot's inadvertent application of the brakes during recovery from a ground loop which resulted in a nose over.NTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.NTSB ERA11FA094Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Spencer, MAThe in-flight collision with a tree while returning to land for undetermined reasons.NTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.NTSB ERA11IA091Incident · No injuriesIncident investigationFinal reportEurocopter Deutschland MBB-BK 117 C-1 · Boston, MAImproper installation of wiring associated with a medical cabinet interior, which resulted in chafing and a subsequent in-flight fire. Contributing to the incident was inadequate maintenance procedures for continued airworthiness.NTSB ERA11LA050Accident · 1 fatalLimited investigationFinal reportNorth American/Schwamm AT-6F · Fitchburg, MAA total loss of engine power due to a cracked carburetor float and resulting carburetor malfunction.NTSB ERA11LA049Accident · Serious injuriesLimited investigationFinal reportAirborne Classic · Stow, MAThe operator's inadequate engine maintenance, which resulted in a total loss of engine power. Contributing to the accident was the pilot's decision to conduct a downwind takeoff.NTSB ERA10CA513Accident · No injuriesData collectionFinal reportPiper PA34 · Northampton, MAThe pilot's improper recovery from a bounced landing.NTSB ERA10CA496Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Marlboro, MAThe pilot’s improper touchdown point and failure to perform a go-around in a timely manner, which resulted in a runway excursion.NTSB ERA10LA488Accident · 1 fatalLimited investigationFinal reportSchulman Mosquito XEL · Halifax, MAThe pilot's loss of control while hovering. Contributing to the accident was the pilot’s limited experience operating the helicopter make and model.NTSB ERA10LA446Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Beverly, MAThe flight instructor's decision to exit the airplane on the taxiway with the engine still operating, and his failure to avoid the rotating propeller.NTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.NTSB ERA10CA411Accident · No injuriesData collectionFinal reportPiper PA28 · Marshfield, MAThe pilot's failure to maintain clearance from a vehicle while taxiing. Contributing to the accident was his inadequate visual lookout.NTSB ERA10LA396Accident · No injuriesLimited investigationFinal reportCessna 177B · Mashpee, MAThe pilot’s delayed use of carburetor heat while flying at reduced power settings in conditions that were favorable for carburetor icing resulting in the partial loss of engine power.NTSB ERA10CA393Accident · No injuriesData collectionFinal reportMaule M-7-260 · Onset, MAThe pilot's loss of airplane control during the initial climb.NTSB ERA10IA378Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe pilot's failure to extend the landing gear prior to landing flare and touchdown.NTSB ERA10LA362Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Rowley, MAThe failure of the power turbine governor internal driveshaft bearings, resulting in the failure of the governor.NTSB ERA10CA337Accident · Serious injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's attempted visual flight into night instrument meteorological conditions, which resulted in spatial disorientation and subsequent controlled flight into terrain.NTSB ERA10LA317Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAA total loss of engine power during final approach due to fuel starvation as a result of the pilot’s delayed configuration of the airplane for landing.NTSB ENG10WA034Incident · No injuriesForeign investigationAirbus A330 · Boston, MAOn June 15, 2010, an Alitalia Airbus A330-202, registration number EI-DIP, flight number AZ615 experienced a reported No. 1 engine (left engine)fire during takeoff from the Boston Logan International Airport (BOS). The No. 1 engine power setting was brought…NTSB ERA10CA289Accident · No injuriesData collectionFinal reportCessna 172N · Sterling, MAThe pilot’s decision to not continue with the go-around, which resulted in a collision with trees. Contributing to the accident was the pilot’s distraction due to the passenger’s panicked condition.NTSB ERA10FA283Accident · 1 fatalField investigationFinal reportSchweizer 269C-1 · Boxborough, MAThe FAA inspector's rapid reduction of power which resulted in a loss of engine power and his decision to initiate a turn during the autorotation without sufficient altitude to clear obstacles. Contributing to the accident was the FAA’s lack of comprehensive…NTSB ERA10LA216Accident · No injuriesLimited investigationFinal reportSmith Richard D JR Revolution Mini 500 · Middleboro, MAA loss of engine coolant, which resulted in a loss of engine power during the pilot’s attempt to cushion a precautionary landing. Contributing to the accident was a disconnected engine coolant hose and the pilot's inadequate preflight inspection.NTSB ERA10CA169Accident · No injuriesData collectionFinal reportCessna 150H · New Bedford, MAThe pilot’s failure to maintain directional control during a crosswind landing/rollout.NTSB ERA10CA124Accident · No injuriesData collectionFinal reportCessna 150 · Taunton, MAThe pilot's failure to obtain the proper touchdown point during landing.NTSB ERA10CA122Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Great Barrington, MAThe pilot's improper approach, failure to perform a go-around, and failure to maintain directional control while braking after a long landing.NTSB ERA09LA538Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Vineyard Haven, MAThe pilot's improper flare while landing in gusting wind, which resulted in a hard landing.NTSB ERA09LA523Accident · No injuriesLimited investigationFinal reportCessna 208 · Sheffield, MAA total loss of engine power due to a failure of the 1st stage sun gear output splines for unknown reasons, which resulted in a power turbine overspeed condition, with subsequent blade distress/release.NTSB ERA09LA496Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Mansfield, MAA loss of engine power due to carburetor icing as a result of the pilot's delayed use of carburetor heat.NTSB ERA09CA489Accident · No injuriesData collectionFinal reportPiper J5A · Holland, MAA loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's inadequate preflight inspection.NTSB ERA09CA401Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Bedford, MAThe flight instructor's inadequate remedial action while conducting hover practice with a student pilot, which resulted in the helicopter rolling over when it contacted the ground.NTSB ERA09LA399Accident · No injuriesLimited investigationFinal reportCessna 172N · Rochester, MAAn engine vibration as reported by the pilot, for undetermined reasons.NTSB ERA09CA553Accident · No injuriesData collectionFinal reportChampion 7GCAA · Ware, MAThe pilot's failure to maintain control of the airplane during landing.NTSB ERA09LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.NTSB OPS09IA008Incident · No injuriesIncident investigationFinal reportAirbus A320 · Boston, MAThe vehicle operator's failure to follow the designated haul route to the construction site and his failure to adhere to airport driving procedures, which led to missed visual cues and lack of required communication prior to crossing the active runway.…NTSB ERA09LA295Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout, which resulted in excessive side loads to the right main landing gear and the separation of the outer main landing gear rib from the right wing.NTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.NTSB ERA09IA267Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MAInstallation of an improper bearing in the landing gear actuator.NTSB ERA09CA251Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Southbridge, MAThe pilot's inadequate compensation for the gusting wind conditions.NTSB ERA09LA194Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Lee, MAThe pilot's failure to maintain clearance from the overhead wire.