NTSB investigations, 1981, 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\") = 1981
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") = 1981 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 NYC82DNA09Accident · 2 fatalClosedCessna 172N · Nantucket, MANTSB NYC82FNA06Accident · No injuriesClosedCessna 170B · Stow, MANTSB NYC82FNA05Accident · Serious injuriesClosedRaven S-55A · Shirley, MANTSB NYC82FA007Accident · 1 fatalClosedChampion 7GCAA · Scituate, MANTSB NYC82FA004Accident · 2 fatalClosedPiper PA-28 · Danvers, MANTSB NYC81FNA03Accident · Minor injuriesClosedPiper PA-30 · Norwood, MANTSB NYC82FNA02Accident · Serious injuriesClosedCessna 182 · East Pepperell, MANTSB NYC82FNE01Accident · Serious injuriesClosedBeech A35 · Montague, MANTSB NYC82FNA01Accident · Minor injuriesClosedCessna 172 · North Reading, MANTSB NYC81FNA26Accident · No injuriesClosedPiper PA-24 · Marstons Mills, MANTSB NYC81FNE30Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC81FNE29Accident · Minor injuriesClosedPiper PA-28 · Berlin, MANTSB NYC81FNA25Accident · Serious injuriesClosedSchweizer 2-32 · Plymouth, MANTSB NYC81FNA27Accident · Serious injuriesClosedGrum Amer AA-1B · Tewksbury, MANTSB NYC81FNE28Accident · No injuriesClosedPiper PA-22 · Gr Barrington, MANTSB NYC81FNE25Accident · No injuriesClosedMaule M-5 · Pittsfield, MANTSB NYC81DNA23Accident · No injuriesClosedCessna 172N · Marthas Vinyrd, MANTSB NYC81FNE23Accident · No injuriesClosedCessna 152 · Sterling, MANTSB NYC81DNA22Accident · No injuriesClosedPiper PA-22 · Mansfield, MANTSB NYC81FNE22Accident · No injuriesClosedPiper PA-28R · N.Egremont, MANTSB NYC81FNA20Accident · No injuriesClosedPiper PA-32 · Falmouth, MANTSB NYC81FNA21Accident · Minor injuriesClosedGulf Amer AA-5B · Stow, MANTSB NYC81FNA17Accident · Minor injuriesClosedCessna 172 · Haverhill, MANTSB NYC81FNA24Accident · Minor injuriesClosedGrum Amer AA-1B · Tewksbury, MANTSB NYC81FA050Accident · 2 fatalClosedBeech G18S · Hyannis, MANTSB NYC81FNE18Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC81FNE17Accident · No injuriesClosedSchweizer 2-33A · New Braintree, MANTSB NYC81FNE16Accident · No injuriesClosedPiper PA-28 · Gardner, MANTSB NYC81FNA15Accident · No injuriesClosedBeech C23 · Bedford, MANTSB NYC81FA043Accident · 1 fatalClosedBellanca 7KCAB · North Adams, MANTSB NYC81FNE15Accident · Minor injuriesClosedCessna 150 · Belchertown, MANTSB NYC81FNA14Accident · No injuriesClosedPiper PA-38 · New Bedford, MANTSB NYC81FNA13Accident · No injuriesClosedPiper PA-28 · Hyannis, MANTSB NYC81FNE12Accident · Minor injuriesClosedMooney M20F · Oakham, MANTSB NYC81FA030Accident · 2 fatalClosedCessna 310R · North Adams, MANTSB NYC81FNE11Accident · Minor injuriesClosedCessna 150 · Princeton, MANTSB NYC81FNA11Accident · No injuriesClosedGrum Amer AA-5B · Taunton, MANTSB NYC81FNE09Accident · No injuriesClosedPiper PA-28 · Northampton, MANTSB NYC81FA025Accident · 1 fatalClosedLake LA-4 · Middleboro, MANTSB NYC81FNA09Accident · No injuriesClosedPiper PA-28R · Falmouth, MANTSB NYC81FNA10Accident · Minor injuriesClosedPiper PA-28 · Middleboro, MANTSB NYC81FNA08Accident · Minor injuriesClosedPiper PA-28 · Beverly, MANTSB NYC81FNA07Accident · No injuriesClosedPiper PA-28 · Norfolk, MA