NTSB investigations, 2005, MA
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2005
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") = 2005 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 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.NTSB NYC06CA020Accident · Minor injuriesData collectionFinal reportRobinson R44 · Bourne, MAThe inadvertent contact of a lift strap with the tail rotor during external load operations, which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the gusty wind conditions.NTSB NYC06CA023Accident · No injuriesData collectionFinal reportBeech M35 · Pittsfield, MAThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB NYC05LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marstons Mills, MAThe pilot's failure to attain a climb during takeoff which resulted in a diminished climb rate and subsequent collision with trees. Factors were the turf runway and a tailwind.NTSB NYC05CA127Accident · No injuriesData collectionFinal reportYakovlev 55M · New Marlboro, MAThe pilot's improper weather evaluation which resulted in a precautionary off airport landing; and his improper flare which resulted in a hard landing. A factor in this accident was weather associated with thunderstorm activity.NTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.NTSB IAD05LA107Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Plymouth, MAFatigue failure of the intermediate tailrotor driveshaft, which resulted in a loss of directional control at a hover.NTSB IAD05LA111Accident · No injuriesLimited investigationFinal reportCessna 182T · Chatham, MAthe pilot's improper recovery from a bounced landing.NTSB NYC05LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Edgartown, MAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]NTSB NYC05LA103Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Beverly, MAThe pilot's failure to attain the proper touchdown point while conducting a precautionary landing. A factor was the partial loss of power to one engine for undetermined reasons.NTSB NYC05IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A330-301 · Boston, MAThe local east controller's failure to follow FAA Order 7110.65, para 3-9-8 and Boston Tower Order 7110.11, Standard Operating Procedures, which resulted in a runway incursion during takeoff involving two transport category airplanes.NTSB NYC05LA071Accident · No injuriesLimited investigationFinal reportBrennan Flightstar · Middleboro, MAA loss of engine power for undetermined reasons.NTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…NTSB IAD05LA044Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Boston, MAThe first officer's misjudgment of a perceived threat, which resulted in the captain's excessive braking and subsequent injury to a flight attendant. A factor was the night lighting conditions.NTSB NYC05IA052Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe mechanic's inadequate inspection, which failed to discover cracks in the left wing spar around wing station 114.NTSB IAD05LA030Accident · No injuriesLimited investigationFinal reportBeech G35 · Falmouth, MAThe pilot's failure to maintain control of the airplane during taxi. A factor was the snow-covered taxiway.