NTSB investigations, 1970, 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\") = 1970
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") = 1970 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 IAD71FIG27Accident · Minor injuriesClosedLuscombe 8A · Laytonsville, MDNTSB IAD71FIG23Accident · No injuriesClosedCessna 150 · White Marsh, MDNTSB IAD71FIG22Accident · Minor injuriesClosedCessna 172K · Baltimore, MDNTSB IAD71FIG21Accident · Minor injuriesClosedCessna 172 · Reistertown, MDNTSB IAD71FIG19Accident · No injuriesClosedPiper J-3 · College Park, MDNTSB IAD71AI017Accident · 4 fatalClosedBeech A23-24 · Ocean City, MDNTSB IAD71FIG16Accident · No injuriesClosedCessna 310 · Frienship Arpt, MDNTSB IAD71FIG15Accident · No injuriesClosedCessna 175 · Edgewater, MDNTSB IAD71FIA08Accident · No injuriesClosedPiper PA-32 · Rose Haven, MDNTSB IAD71FIG10Accident · No injuriesClosedPiper PA-28 · Chestertown, MDNTSB IAD71FIG12Accident · No injuriesClosedCessna 195B · Stevensville, MDNTSB IAD71DIG11Accident · No injuriesClosedPiper PA-28 · Fallston, MDNTSB IAD71FIG14Accident · No injuriesClosedCessna 210 · Churchville, MDNTSB IAD71FIG08Accident · Serious injuriesClosedLuscombe 8A · Frederick, MDNTSB IAD71FIG09Accident · No injuriesClosedCessna 170B · Taneytown, MDNTSB IAD71FIG07Accident · No injuriesClosedPiper PA-23 · Friendshp Arpt, MDNTSB IAD71FIG13Accident · No injuriesClosedPiper PA-24 · Edgewater, MDNTSB IAD71FIA02Accident · No injuriesClosedCessna 177 · Clinton, MDNTSB IAD71FIG06Accident · Serious injuriesClosedErco 415-C · Cumberland, MDNTSB IAD71FIG05Accident · No injuriesClosedBeech A23-19 · Whiteford, MDNTSB IAD71FIA01Accident · No injuriesClosedCessna 172D · Lothian, MDNTSB IAD71AI006Accident · 2 fatalClosedPiper PA-18 · Clear Spring, MDNTSB IAD71FIG03Accident · Minor injuriesClosedPiper PA-22 · Sykesville, MDNTSB IAD71FIG02Accident · Serious injuriesClosedPiper PA-28 · Sykesville, MDNTSB IAD70AI063Accident · No injuriesClosedBeech 99 · Hagerstown, MDNTSB IAD70FIG18Accident · Minor injuriesClosedTaylorcraft DCO-65 · Cumberland, MDNTSB IAD71FIG17Accident · No injuriesClosedFairchild M-62C · Baltimore, MDNTSB IAD70DIG19Accident · No injuriesClosedChampion L-16 · Davidsonville, MDNTSB IAD70FIG16Accident · No injuriesClosedMooney M20E · Mitchellville, MDNTSB IAD70DIG15Accident · No injuriesClosedErco 415-C · College Park, MDNTSB IAD70FIA13Accident · Serious injuriesClosedPiper PA-23 · Clinton, MDNTSB IAD70AI059Accident · 2 fatalClosedPiper PA-28 · Frederick, MDNTSB IAD70DIG14Accident · No injuriesClosedCessna 172 · Friendsville, MDNTSB NYC70FHG05Accident · No injuriesClosedPiper PA-28 · Woodland Beach, MDNTSB IAD70FIA09Accident · Serious injuriesClosedPiper PA-24 · Lusby, MDNTSB IAD70DIG13Accident · No injuriesClosedEnstrom F-28A · Silver Springs, MDNTSB IAD70FIG12Accident · No injuriesClosedAero Comdr 100 · Friendshp Arpt, MDNTSB IAD70AI054Accident · 3 fatalClosedPiper PA-32 · Cambridge, MDNTSB IAD70DIA10Accident · No injuriesClosedPiper PA-24 · Accokeek, MDNTSB IAD70FIG09Accident · Minor injuriesClosedCessna 150G · Hagerstown, MDNTSB IAD70DIG11Accident · No injuriesClosedAero Comdr 100 · Centreville, MDNTSB IAD70DIG10Accident · No injuriesClosedCallair A-9 · Massey, MDNTSB IAD70FIG07Accident · No injuriesClosedPiper PA-28 · Laurel, MDNTSB IAD70FI608Accident · No injuriesClosedCessna 182 · Ridgely, MDNTSB IAD70DIA06Accident · Minor injuriesClosedPiper PA-28 · Clinton, MDNTSB IAD70FIG06Accident · No injuriesClosedCessna 120 · Gaithersburg, MDNTSB IAD70FIG05Accident · No injuriesClosedCessna 170B · Friendship Apt, MDNTSB IAD70FIA03Accident · 1 fatalClosedCessna 172K · Chesapeake Bch, MDNTSB IAD70AI04IAccident · Serious injuriesClosedHiller Acft FH1100 · Bowie, MDNTSB IAD70FIA04Accident · 2 fatalClosedH.O.Beckett T-18 · Helen, MD