NTSB investigations, 2015, 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\") = 2015
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") = 2015 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 ERA16FA023Accident · 1 fatalField investigationFinal reportMooney M20M · Worcester, MAA total loss of engine power during the initial climb due to a fatigue failure of the engine's crankshaft. Contributing to the accident was the pilot's failure to maintain control of the airplane, which resulted in an aerodynamic stall.NTSB GAA15CA273Accident · No injuriesData collectionFinal reportPiper PA 20 · Marshfield, MAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and impact with terrain.NTSB ERA15LA360Accident · No injuriesLimited investigationFinal reportJ. Schilling S-19 · East Falmouth, MAThe experimental airplane builder's failure to properly secure the stabilator trim tab push-pull tube’s connection, which resulted in the tube’s separation and a subsequent hard landing. Contributing to the accident was the pilot/owner's failure to detect the…NTSB GAA15CA253Accident · Minor injuriesData collectionFinal reportAir Creation USA Skypper · Stow, MAThe student pilot's improper directional control inputs during the takeoff roll, resulting in a roll over and collision with terrain.NTSB ERA15LA291Accident · No injuriesLimited investigationFinal reportSontonastaso Mosquito · Winchendon, MAA partial loss of engine power due to a faulty electrical wiring crimp in the engine’s ignition system.NTSB ERA15LA266Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Southbridge, MAThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB DCA15CA152Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 212 · Boston, MAan inadvertent fall by the passenger while exiting the lavatory when the seat belt light was illuminated.NTSB ERA15FA254Accident · 3 fatalField investigationFinal reportBeech A36 · Plainville, MAThe total loss of engine power due to the failure of the alternator drive coupling. Contributing to the accident was the pilot's inability to locate and navigate to a suitable forced landing site due to low cloud ceilings.NTSB GAA15CA073Accident · No injuriesData collectionFinal reportCessna 182T · Newburyport, MAThe pilot's failure to recover from a bounced landing, which resulted in substantial damage to the airplane during the runway overrun.NTSB ERA15CA101Accident · No injuriesData collectionFinal reportCessna 150L · Stow, MAThe flight instructor's delayed remedial action in response to the student pilot's improper go-around, which resulted in the airplane exceeding its critical angle of attack, experiencing an aerodynamic stall, and impacting a parked airplane.