NTSB investigations, 2006, MA
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 2006
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") = 2006 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 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.