NTSB investigations, 2000, 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 per year
| 1963 | 3 |
|---|---|
| 1964 | 64 |
| 1965 | 78 |
| 1966 | 81 |
| 1967 | 71 |
| 1968 | 69 |
| 1969 | 56 |
| 1970 | 87 |
| 1971 | 63 |
| 1972 | 58 |
| 1973 | 72 |
| 1974 | 68 |
| 1975 | 72 |
| 1976 | 45 |
| 1977 | 51 |
| 1978 | 68 |
| 1979 | 34 |
| 1980 | 35 |
| 1981 | 43 |
| 1982 | 38 |
| 1983 | 41 |
| 1984 | 53 |
| 1985 | 38 |
| 1986 | 40 |
| 1987 | 54 |
| 1988 | 29 |
| 1989 | 25 |
| 1990 | 44 |
| 1991 | 26 |
| 1992 | 31 |
| 1993 | 31 |
| 1994 | 33 |
| 1995 | 21 |
| 1996 | 28 |
| 1997 | 21 |
| 1998 | 22 |
| 1999 | 21 |
| 2000 | 29 |
| 2001 | 23 |
| 2002 | 23 |
| 2003 | 22 |
| 2004 | 28 |
| 2005 | 18 |
| 2006 | 16 |
| 2007 | 19 |
| 2008 | 12 |
| 2009 | 14 |
| 2010 | 24 |
| 2011 | 18 |
| 2012 | 10 |
| 2013 | 10 |
| 2014 | 12 |
| 2015 | 10 |
| 2016 | 12 |
| 2017 | 10 |
| 2018 | 9 |
| 2019 | 9 |
| 2020 | 8 |
| 2021 | 10 |
| 2022 | 11 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 10 |
| 2026 | 10 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2000
AND 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 year(c."eventDate") = 2000 AND 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 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.