NTSB investigations, 2001, MA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2001
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") = 2001 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 NYC02LA042Accident · Serious injuriesLimited investigationFinal reportRaytheon BE-1900D · Boston, MAThe passengers misjudged step, which resulted in a loss of balance and subsequent fall.NTSB NYC02LA036Accident · No injuriesLimited investigationFinal reportRockwell NA-265-80 · Boston, MAThe failure of the left thrust reverser assembly due to fatigue.NTSB NYC02FA032Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Falmouth, MAThe incapacitation of the pilot for undetermined reasons which resulted in an in-flight collision with water.NTSB NYC02LA010Accident · No injuriesLimited investigationFinal reportCessna 172L · Northampton, MAThe pilots' failure to maintain airspeed, which resulted in a loss of control and a hard landing.NTSB IAD01LA099Accident · No injuriesLimited investigationFinal reportCessna 150J · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB NYC01LA195Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Hanson, MAThe pilot's failure to maintain aircraft control during the takeoff.NTSB NYC01FA189Accident · 1 fatalField investigationFinal reportPiper PA-46-350 · Westfield, MAThe pilot's failure to maintain aircraft control while maneuvering during a go-around.NTSB NYC01LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Stow, MAThe pilot's failure to maintain airplane control during a go-around.NTSB NYC01LA166Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Boston, MAThe pilot's improper decision to waive the wake turbulence hold time, and his subsequent loss of control when wake vortex turbulence was encountered.NTSB NYC01LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Plymouth, MAThe pilot's failure to ensure the magnetos were off prior to rotating the propeller, which resulted in an unintentional engine start and subsequent unmanned taxi.NTSB IAD01LA069Accident · Serious injuriesLimited investigationFinal reportBucker Jungmann C.A.S.A. 1.131 · Plymouth, MAThe pilot's failure to maintain altitude during an approach and inadequate visual lookout, which resulted in a collision with a runway sign.NTSB NYC01FA128Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Danvers, MAThe pilot's failure to maintain aircraft control. Factors in the accident were the dark night, low ceiling, reduced visibility, and the pilot's decision to attempt a visual flight rules flight in marginal weather conditions.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.