NTSB investigations, 1976, MA
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
Latest 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\") = 1976
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") = 1976 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 NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MANTSB NYC77FNA07Accident · Serious injuriesClosedTed Smith 601 · Framingham Ctr, MANTSB NYC76DNA04Accident · No injuriesClosedPiper PA-24 · Chatham, MANTSB NYC77DNA03Accident · No injuriesClosedAero Comdr 560A · Provincetown, MANTSB NYC77FNE02Accident · Serious injuriesClosedSchweizer SGS233 · Pittsfield, MANTSB NYC77FNA01Accident · No injuriesClosedEvans VP1 · Stow, MANTSB NYC76FNA54Accident · No injuriesClosedPiper PA-12 · Pembroke, MANTSB NYC76FNA52Accident · No injuriesClosedCessna 172 · Middleboro, MANTSB NYC76FNA51Accident · No injuriesClosedStearman A75 · Norwood, MANTSB NYC76DNA53Accident · No injuriesClosedCessna 172K · Methuen, MANTSB NYC76FNE33Accident · Serious injuriesClosedSchweizer SGS126 · Sterling, MANTSB NYC76FNE31Accident · Serious injuriesClosedLake LA-4 · Grt Barrington, MANTSB NYC76AN119Accident · Serious injuriesClosedCessna U206F · Tuckernuck Is, MANTSB NYC76AN117Accident · No injuriesClosedBeech 65 · Bedford, MANTSB NYC76FNA46Accident · No injuriesClosedPiper PA-32 · Tewksbury, MANTSB NYC76FNA45Accident · No injuriesClosedCessna 150L · Freetown, MANTSB NYC76DNA44Accident · Minor injuriesClosedCessna 140 · Norfolk, MANTSB NYC76FNE29Accident · No injuriesClosedCessna 150J · Southbridge, MANTSB NYC76AN111Accident · 1 fatalClosedPiper PA-28R · Bedford, MANTSB NYC76FNA47Accident · No injuriesClosedGrum Amer AA-5 · Stow, MANTSB NYC76FNE27Accident · Serious injuriesClosedGlobe GC-1B · Gardner, MANTSB NYC76FNA41Accident · No injuriesClosedPiper PA-18 · Chatham, MANTSB NYC76DNA40Accident · Minor injuriesClosedCessna 150 · Shirley, MANTSB NYC76AN105Accident · 4 fatalClosedCessna 172 · Turo, MANTSB NYC76FNE24Accident · Minor injuriesClosedCessna 150G · Westboro, MANTSB NYC76AM1O2Accident · 2 fatalClosedBeech B35 · Hyannis, MANTSB NYC76FNE22Accident · Minor injuriesClosedMooney M20C · Westboro, MANTSB NYC76FNE20Accident · No injuriesClosedPiper PA-12 · Pittsfield, MANTSB NYC76DNA39Accident · No injuriesClosedStinson 108-3 · Oak Bluffs, MANTSB NYC76FNA38Accident · No injuriesClosedCessna 150H · Shirley, MANTSB NYC76DNA35Accident · No injuriesClosedCessna 150 · Norfolk, MANTSB NYC76DNA34Accident · No injuriesClosedPiper PA-16 · Bedford, MANTSB NYC76DNA33Accident · No injuriesClosedMooney M20C · Bedford, MANTSB NYC76DNA32Accident · No injuriesClosedCessna 411A · Stow, MANTSB NYC76FNE19Accident · No injuriesClosedCessna 150 · Worcester, MANTSB NYC76FNA31Accident · Minor injuriesClosedCessna 172 · Tewksbury, MANTSB NYC76AN087Accident · 2 fatalClosedCessna 150L · Plymouth, MANTSB NYC76FNE15Accident · No injuriesClosedCessna 172K · Orange, MANTSB NYC76AN078Accident · Serious injuriesClosedPiper PA-23 · Ludlow, MANTSB NYC76FNE14Accident · No injuriesClosedCessna 172 · Worcester, MANTSB NYC76FNA29Accident · No injuriesClosedGrum Amer AA1-B · Billerica, MANTSB NYC76FNA28Accident · Serious injuriesClosedPiper PA-28 · Norfolk, MANTSB NYC76FNA27Accident · No injuriesClosedPiper PA-23 · Bedford, MANTSB NYC76FNE13Accident · No injuriesClosedCessna 172L · Worcester, MANTSB NYC76DNA25Accident · No injuriesClosedErco 415-C · Tauton, MA