NTSB investigations, 1964, MD
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
| 1962 | 2 |
|---|---|
| 1963 | 1 |
| 1964 | 76 |
| 1965 | 81 |
| 1966 | 68 |
| 1967 | 72 |
| 1968 | 52 |
| 1969 | 69 |
| 1970 | 56 |
| 1971 | 39 |
| 1972 | 36 |
| 1973 | 35 |
| 1974 | 35 |
| 1975 | 32 |
| 1976 | 40 |
| 1977 | 41 |
| 1978 | 31 |
| 1979 | 29 |
| 1980 | 25 |
| 1981 | 22 |
| 1982 | 29 |
| 1983 | 34 |
| 1984 | 28 |
| 1985 | 30 |
| 1986 | 26 |
| 1987 | 32 |
| 1988 | 25 |
| 1989 | 33 |
| 1990 | 29 |
| 1991 | 21 |
| 1992 | 25 |
| 1993 | 16 |
| 1994 | 18 |
| 1995 | 24 |
| 1996 | 27 |
| 1997 | 25 |
| 1998 | 20 |
| 1999 | 24 |
| 2000 | 18 |
| 2001 | 19 |
| 2002 | 12 |
| 2003 | 12 |
| 2004 | 11 |
| 2005 | 11 |
| 2006 | 19 |
| 2007 | 13 |
| 2008 | 20 |
| 2009 | 13 |
| 2010 | 21 |
| 2011 | 23 |
| 2012 | 10 |
| 2013 | 15 |
| 2014 | 13 |
| 2015 | 20 |
| 2016 | 10 |
| 2017 | 14 |
| 2018 | 12 |
| 2019 | 17 |
| 2020 | 12 |
| 2021 | 10 |
| 2022 | 17 |
| 2023 | 8 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 9 |
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\") = 1964
AND c.\"eventStateOrRegion\" = 'MD' 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") = 1964 AND c."eventStateOrRegion" = 'MD' 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 UNK65X1128Accident · Minor injuriesClosedPiper PA22 · Piney Point, MDNTSB UNK65X0984Accident · No injuriesClosedPiper PA22 · Piney Point, MDNTSB UNK65X0593Accident · No injuriesClosedPiper PA28 · Friendly, MDNTSB UNK65X0487Accident · No injuriesClosedPiper PA22 · Randallstown, MDNTSB UNK65X0486Accident · Minor injuriesClosedPiper PA17 · College Park, MDNTSB UNK65X0424Accident · No injuriesClosedNo American SNJ5 · Gaithersburg, MDNTSB UNK65X0245Accident · No injuriesClosedMooney M21 · Mitchelville, MDNTSB UNK65X0206Accident · No injuriesClosedPiper PA24 · Snow Hill, MDNTSB UNK64X4212Accident · No injuriesClosedPiper PA22 · Ft Meade, MDNTSB UNK64X4165Accident · No injuriesClosedBeechcraft M23 · Laytonsville, MDNTSB UNK64X4129Accident · No injuriesClosedBoeing A75 · Parsonsburg, MDNTSB UNK64X4101Accident · No injuriesClosedPiper PA28 · Edgewater, MDNTSB UNK64X4047Accident · Minor injuriesClosedCessna 172 · Hagerstown, MDNTSB UNK64X3805Accident · 1 fatalClosedHomebuilt P-64 · Edgewater, MDNTSB UNK64X3769Accident · No injuriesClosedErcoupe 415C · Indian Head, MDNTSB UNK64X3660Accident · No injuriesClosedCessna 180 · Aberdeen, MDNTSB UNK64X3625Accident · No injuriesClosedRyan Navion · Crystal Beach, MDNTSB UNK64X3602Accident · No injuriesClosedCessna 170 · Knoxville, MDNTSB UNK64X3579Incident · No injuriesClosedLockheed L-749A · Baltimore, MDNTSB UNK64X3543Accident · No injuriesClosedBeechcraft A55 · Baltimore, MDNTSB UNK64X3471Accident · No injuriesClosedErcoupe 415C · Westminister, MDNTSB UNK64X3392Accident · No injuriesClosedPiper PA16 · Baltimore, MDNTSB UNK64X3275Accident · No injuriesClosedPiper PA23 · Park Hall, MDNTSB UNK64X3220Accident · No injuriesClosedPiper J3 · Issue, MDNTSB UNK64X3203Accident · 1 fatalClosedPiper PA-30 · Lothian, MDNTSB UNK64X2975Accident · No injuriesClosedPiper PA28 · Baltimore, MDNTSB UNK64X2913Accident · No injuriesClosedCessna 172 · Beltsville, MDNTSB UNK64X2840Accident · Minor injuriesClosedPiper PA11 · Edgewater, MDNTSB UNK64X2801Accident · No injuriesClosedBeechcraft D18S · Baltimore, MDNTSB UNK64X2727Accident · No injuriesClosedPiper PA22 · Annapolis, MDNTSB UNK64X2725Accident · Minor injuriesClosedCessna 120 · Laytonsville, MDNTSB UNK64X2697Accident · No injuriesClosedPiper PA23 · Ocean City, MDNTSB UNK64X2662Accident · No injuriesClosedCessna 180 · Cockeysville, MDNTSB UNK64X2593Accident · Minor injuriesClosedCessna 172B · Ocean City, MDNTSB UNK64X2477Accident · No injuriesClosedCessna 182 · Severn, MDNTSB UNK64X2413Accident · No injuriesClosedPiper PA22 · Ft Meade, MDNTSB UNK64X2384Accident · Minor injuriesClosedPiper PA28 · Baltimore, MDNTSB UNK64X2343Accident · No injuriesClosedCont Copter M2 · Gaithersburg, MDNTSB UNK64X2331Accident · No injuriesClosedCessna 182 · Church Hill, MDNTSB UNK64X2283Accident · No injuriesClosedCessna 182 · Westminister, MDNTSB UNK64X2218Accident · No injuriesClosedPiper PA22 · Rockville, MDNTSB UNK64X2174Accident · No injuriesClosedBeechcraft 35 · Beltsville, MDNTSB UNK64X2048Accident · No injuriesClosedAeronca 11AC · Balto Harbor, MDNTSB UNK64X1968Accident · No injuriesClosedChampion 402 · Friendly, MDNTSB UNK64X1844Accident · No injuriesClosedCessna 170B · Gaithersburg, MDNTSB UNK64X1801Accident · No injuriesClosedPiper PA25 · Preston, MDNTSB UNK64X1796Accident · No injuriesClosedPiper PA22 · Woodland Beach, MDNTSB UNK64X1756Accident · Minor injuriesClosedStinson 108 · Barnesville, MDNTSB UNK64X1680Accident · No injuriesClosedPiper PA24 · Laurel, MDNTSB UNK64X1679Accident · No injuriesClosedPiper PA22 · Baltimore, MD