NTSB investigations, 1969, 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\") = 1969
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") = 1969 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 IAD70A0036Accident · No injuriesClosedBeech D18S · Friendship Apt, MDNTSB IAD70F0126Accident · No injuriesClosedAero Comdr 680-FL · Gaithersburg, MDNTSB IAD70A0035Accident · No injuriesClosedNihon YS11-A · Baltimore, MDNTSB IAD70D0116Accident · No injuriesClosedPiper PA-28 · Clinton, MDNTSB IAD70F0115Accident · No injuriesClosedCessna 421A · Friendshp Arpt, MDNTSB IAD70F0120Accident · 1 fatalClosedPiper PA-28 · Rohrersville, MDNTSB IAD70F0118Accident · No injuriesClosedBeech A23-24 · White Marsh, MDNTSB IAD70F0111Accident · No injuriesClosedPiper PA-20 · Gaithersburg, MDNTSB IAD70D0110Accident · No injuriesClosedChampion 7KCAB · Churchton, MDNTSB IAD70D0105Accident · No injuriesClosedCessna 150 · Clinton, MDNTSB IAD70A0030Accident · 2 fatalClosedCessna 172G · Accident, MDNTSB IAD70D0090Accident · Minor injuriesClosedPiper PA-22 · Andrews Afb, MDNTSB IAD70D0087Accident · No injuriesClosedAeronca S-7CCM · Annapolis, MDNTSB IAD70A0026Accident · 2 fatalClosedMooney M20A · Hyattstown, MDNTSB IAD70D0186Accident · No injuriesClosedPiper PA-28 · White Marsh, MDNTSB IAD70A0023Accident · 4 fatalClosedFairchild 24 · Pomfret, MDNTSB IAD70D0070Accident · No injuriesClosedCessna 172 · Nanjemoy, MDNTSB IAD70A0021Accident · 2 fatalClosedPiper PA-28 · Edgewater, MDNTSB IAD70D0076Accident · No injuriesClosedBeech D50C · Gaithersberg, MDNTSB IAD70D0004Accident · No injuriesClosedBeech 35 · Park Hall, MDNTSB IAD70F006MAccident · Serious injuriesClosedBeech B23 · Maryland Line, MDNTSB IAD70F0064Accident · No injuriesClosedCessna 150F · Crisfield, MDNTSB DIA70D0043Accident · No injuriesClosedPiper PA-22 · Mitchellville, MDNTSB IAD70F0046Accident · Serious injuriesClosedPiper PA-32 · Salisbury, MDNTSB DIA70F0045Accident · No injuriesClosedPiper PA-24 · Friendshp Arpt, MDNTSB IAD70D0044Accident · No injuriesClosedPiper PA-22 · Park Hall, MDNTSB IAD70A0005Accident · 1 fatalClosedBeech 35-E33 · Jarrettsville, MDNTSB IAD70A0003Accident · No injuriesClosedBeech 95-B55 · Friendshp Arpt, MDNTSB DIA70D0024Accident · No injuriesClosedPiper PA-22 · Stevensville, MDNTSB DIA70D0018Accident · Minor injuriesClosedCessna 177 · Darnestown, MDNTSB DIA70F0017Accident · No injuriesClosedCessna 172 · Grantsville, MDNTSB DIA70F0027Accident · Serious injuriesClosedPiper J3C-65 · Cambridge, MDNTSB DIA70D0016Accident · No injuriesClosedCessna 182 · Stevensville, MDNTSB DIA70F0023Accident · No injuriesClosedPiper PA-24 · Laytonsville, MDNTSB DIA70F0002Accident · Minor injuriesClosedCessna 172E · Laurel, MDNTSB DIA69F0207Accident · No injuriesClosedPiper PA-28 · Gaithersburg, MDNTSB DIA69D0204Accident · No injuriesClosedPiper PA-28 · College Park, MDNTSB DIA69F0196Accident · No injuriesClosedCessna 177 · Gaithersburg, MDNTSB DIA69A0061Accident · No injuriesClosedLockheed 18 · Gaithersburg, MDNTSB DIA69F0194Accident · No injuriesClosedPitts SPL SC-1 · Stevensville, MDNTSB DIA69F0193Accident · No injuriesClosedPiper PA-24 · Edgewater, MDNTSB DIA69F0185Accident · No injuriesClosedBell 47G-2A · Mt Savage, MDNTSB DIA69D0188Accident · No injuriesClosedPiper PA-28 · Chestertown, MDNTSB DIA69I0058Incident · No injuriesClosedDornier DO-28D · Baltimore, MDNTSB DIA69I0057Incident · No injuriesClosedBoeing 707 · Baltimore, MDNTSB IAD69D0179Accident · No injuriesClosedPiper PA-28R · Accokeek, MDNTSB DIA69D0178Accident · No injuriesClosedPiper PA-28 · Clinton, MDNTSB DIA69F0180Accident · Serious injuriesClosedCessna 140 · Ocean City, MDNTSB DIA69F0174Accident · No injuriesClosedPiper PA-28 · Rock Hall, MDNTSB DIA69F0181Accident · No injuriesClosedPiper PA-22 · Westminster, MD