NTSB investigations, 1971, MD
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1971
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") = 1971 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 NYC72DIG17Accident · No injuriesClosedPiper PA-28 · Montgomery, MDNTSB NYC72FIG16Accident · No injuriesClosedCessna 150J · Crownsville, MDNTSB NYC72FIA10Accident · No injuriesClosedBeech A23-24 · Lexington Park, MDNTSB NYC72FIA09Accident · 2 fatalClosedLake LA-4A · Laplata, MDNTSB NYC72DIG15Accident · No injuriesClosedCessna 140 · Ocean City, MDNTSB NYC72AN058Accident · 2 fatalClosedFairchild M-62A · Stevensville, MDNTSB NYC72FIG14Accident · Minor injuriesClosedGlobe GC-1B · Perry Hall, MDNTSB NYC72AN041Accident · 3 fatalClosedCessna 337A · Boonsboro, MDNTSB NYC72DIA04Accident · No injuriesClosedChampion 7ECA · California, MDNTSB NYC72FIG13Accident · Minor injuriesClosedMooney M20A · Mitchellville, MDNTSB NYC72DIG12Accident · No injuriesClosedPiper PA-22 · Pasadena, MDNTSB NYC72AN032Accident · 3 fatalClosedPiper PA-32 · Corriganville, MDNTSB NYC72AN030Accident · 3 fatalClosedPiper PA-28 · Accident, MDNTSB NYC72FIG10Accident · 1 fatalClosedDehavnd Can DHC-1B · Stevensville, MDNTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDNTSB NYC72FIG06Accident · No injuriesClosedBell 47D-1 · Union Bridge, MDNTSB NYC72FIG09Accident · No injuriesClosedPiper PA-23 · Westminster, MDNTSB NYC72FIG08Accident · No injuriesClosedPiper PA-28 · White Marsh, MDNTSB NYC72DIG07Accident · No injuriesClosedCessna 182 · Cambridge, MDNTSB IAD72AI003Accident · 1 fatalClosedPiper PA-28 · St.Michaels, MDNTSB IAD72FIG05Accident · Serious injuriesClosedMooney M20G · College Park, MDNTSB IAD72DIG03Accident · No injuriesClosedCessna 150 · Finksburg, MDNTSB IAD72FIG02Accident · Minor injuriesClosedHughes 269B · Bowie, MDNTSB IAD72FIG01Accident · No injuriesClosedBell 206A · Rosedale, MDNTSB IAD72FIG33Accident · No injuriesClosedPiper PA-22 · White Marsh, MDNTSB IAD71FIG32Accident · No injuriesClosedBeech 35 · Golts, MDNTSB IAD71DIA22Accident · No injuriesClosedCessna 170B · Cobb Island, MDNTSB IAD71FIG31Accident · Serious injuriesClosedBeech B35 · Stevensville, MDNTSB MIA71IM101Incident · No injuriesClosedDouglas DC-9 · Baltimore, MDNTSB IAD71FIA21Accident · Minor injuriesClosedCessna 150 · Lusby, MDNTSB IAD71II052Incident · No injuriesClosedBeech B55 · Easton, MDNTSB IAD71AI050Accident · 1 fatalClosedCessna 172H · Hollywood, MDNTSB IAD71DIG30Accident · No injuriesClosedPiper PA-28 · Westminster, MDNTSB IAD71FIG28Accident · Minor injuriesClosedCessna 172K · Fallston, MDNTSB IAD71FIG27Accident · Minor injuriesClosedPiper J3L-65 · Edgewater, MDNTSB IAD71FIG29Accident · No injuriesClosedPiper PA-28 · White Marsh, MDNTSB IAD71FIG26Accident · Serious injuriesClosedCessna 172 · College Park, MDNTSB IAD71DIG25Accident · No injuriesClosedPiper J-3 · College Park, MDNTSB IAD71II033Incident · No injuriesClosedBoeing 720 · Baltimore, MD