NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 NYC66D0416Accident · No injuriesClosedBeechcraft G35 · Mendon, MANTSB NYC66F0435Accident · No injuriesClosedErcoupe 415-D · Marlboro, MANTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MANTSB NYC66F0430Accident · Minor injuriesClosedPiper JC3-65 · Pepperell, MANTSB NYC66F0389Accident · Minor injuriesClosedPiper PA-28 · Worcester, MANTSB NYC66D0377Accident · No injuriesClosedCessna 180 · Rochester, MANTSB NYC66D0406Accident · No injuriesClosedCessna 337 · Beverly, MANTSB NYC66D0358Accident · No injuriesClosedCessna 150 · Falmouth, MANTSB NYC66I0057Incident · No injuriesClosedBoeing 707 321B · Boston, MANTSB NYC66F0365Accident · No injuriesClosedPiper J3C-65 · Agawam, MANTSB NYC66F0327Accident · No injuriesClosedPiper PA-28 · Brookfield, MANTSB NYC66F0343Accident · Minor injuriesClosedPiper PA-28 · Lynn, MANTSB NYC66F0309Accident · No injuriesClosedPiper PA-22 · Northampton, MANTSB NYC66I0049Incident · No injuriesClosedDouglas DC-6 · Boston, MANTSB NYC66F0293Accident · No injuriesClosedStinson 108-1 · Westfield, MANTSB NYC66F0274Accident · No injuriesClosedBeechcraft E50 · Hopedale, MANTSB NYC66F0267Accident · No injuriesClosedCessna 150 · Beverly, MANTSB NYC66F0219Accident · No injuriesClosedPiper PA-22 · Norwood, MANTSB NYC66F0210Accident · No injuriesClosedErcoupe 415C · Agawam, MANTSB NYC66F0222Accident · No injuriesClosedCessna 170B · Norwood, MANTSB NYC66F0220Accident · No injuriesClosedPiper PA-28 · Gr Barringtn, MANTSB NYC66F0226Accident · No injuriesClosedPiper PA-28 · Lawrence, MANTSB NYC66F0168Accident · Minor injuriesClosedPiper J5A · Gardner, MANTSB NYC66D0167Accident · No injuriesClosedPiper PA-22 · Marlboro, MANTSB NYC66F0189Accident · No injuriesClosedPiper PA-24 · Newburyport, MANTSB NYC66A0022Accident · No injuriesClosedDouglas DC-6A · Boston, MANTSB NYC66A0021Accident · 3 fatalClosedAeronca 15AC · Mashpee, MANTSB NYC66F0183Accident · No injuriesClosedAeronca 11AC · Tewksbury, MANTSB NYC66F0175Accident · No injuriesClosedBeechcraft T-34A · Turner Falls, MANTSB NYC66F0158Accident · Serious injuriesClosedPiper PA-15 · Lowell, MANTSB NYC66F0190Accident · No injuriesClosedBeechcraft C-45H · Nantucket, MANTSB NYC66F0154Accident · Minor injuriesClosedPiper PA-28 · Lenox, MANTSB NYC66F0122Accident · Minor injuriesClosedChampion 7ECA · Norfolk, MANTSB NYC66D0145Accident · No injuriesClosedPiper J-3 · Cheshire, MANTSB NYC66D0130Accident · No injuriesClosedScheibe L-SPAT · Heath, MANTSB NYC66F0124Accident · No injuriesClosedPiper PA-18A · Southwick, MANTSB NYC66F0119Accident · 1 fatalClosedScheibe L-55 · New Braintre, MANTSB NYC66D0135Accident · No injuriesClosedPiper PA-28 · Newburyport, MANTSB NYC66F0100Accident · No injuriesClosedPiper PA-28 · Taunton, MANTSB NYC66F0099Accident · No injuriesClosedLockheed 10A · East Boston, MANTSB NYC66D0055Accident · Minor injuriesClosedPiper PA-22 · Palmer, MANTSB NYC66F0091Accident · No injuriesClosedPiper J3C · Hopedale, MANTSB NYC65A0157Accident · No injuriesClosedAir & Space 18A · Pocasset, MANTSB NYC66D0036Accident · No injuriesClosedBeechcraft 23 · Tewksbury, MANTSB NYC66D0047Accident · No injuriesClosedStinson SM-8A · Provincetown, MANTSB NYC66F0025Accident · No injuriesClosedCessna 195B · East Boston, MANTSB NYC66F0007Accident · Minor injuriesClosedAeronca 7AC · Hanson, MANTSB NYC66F0013Accident · No injuriesClosedPiper J-3 · Tewksbury, MANTSB NYC65F0169Accident · No injuriesClosedPiper PA-22 · Danvers, MANTSB NYC65F0178Accident · No injuriesClosedLuscombe T8F · Shirley, MA