NTSB investigations, 1976, MD
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 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\") = 1976
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") = 1976 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 IAD77FIG09Accident · Serious injuriesClosedCurtis MSTNG2 · Mitchelville, MDNTSB IAD77FA016Accident · 2 fatalClosedBoeing A75 · Crofton, MDNTSB DCA77AA008Accident · Serious injuriesClosedPiper PA-28 · Baltimore, MDNTSB IAD77FIA06Accident · Minor injuriesClosedCessna 182 · Friendly, MDNTSB IAD77FIG05Accident · Minor injuriesClosedCessna 177 · Middle River, MDNTSB IAD77FIG04Accident · Serious injuriesClosedEvans VP-2 · Westminster, MDNTSB IAD77FIA03Accident · No injuriesClosedGrum Amer AA1-B · Leonardtown, MDNTSB IAD77FIG02Accident · No injuriesClosedBeech B35 · Mitchellville, MDNTSB IAD77DIG03Accident · No injuriesClosedCessna 150 · Easton, MDNTSB IAD77FIG01Accident · Minor injuriesClosedCessna 182P · Hagerstown, MDNTSB IAD76FIG27Accident · No injuriesClosedCessna 150 · Silver Springs, MDNTSB IAD76FIG26Accident · No injuriesClosedBellanca 7KCAB · Bowie, MDNTSB IAD76AI099Accident · 1 fatalClosedAmer Avco AA1 · Frederick, MDNTSB IAD76FIG28Accident · Minor injuriesClosedLuscombe 8E · Mitchellville, MDNTSB IAD76FIG24Accident · Serious injuriesClosedSoneria 1 · Frederick, MDNTSB IAD76AI089Accident · 1 fatalClosedBellanca 7GCBC · Ocean City, MDNTSB IAD76FIG23Accident · No injuriesClosedCessna 172M · Stevensville, MDNTSB IAD76FIA13Accident · No injuriesClosedCessna 180 · Clinton, MDNTSB IAD76FIG22Accident · No injuriesClosedLuscombe 8E · Mchenry, MDNTSB IAD76FIG21Accident · No injuriesClosedBeech C35 · Annapolis, MDNTSB IAD76FIG20Accident · No injuriesClosedPiper PA-28 · Baltimore, MDNTSB IAD76FIG19Accident · Minor injuriesClosedCessna 172 · Laurel, MDNTSB IAD76DIG17Accident · No injuriesClosedAeronca 7CCM · Cumberland, MDNTSB IAD76FIG16Accident · Minor injuriesClosedHughes 269B · Gaithersburgh, MDNTSB IAD76FIG18Accident · No injuriesClosedFourney 415-D · Pasadena, MDNTSB IAD76FIG14Accident · No injuriesClosedGrumman G-164A · Downsville, MDNTSB IAD76FIG15Accident · No injuriesClosedGrum Amer AA1-B · College Park, MDNTSB IAD76FIA09Accident · No injuriesClosedCessna 177 · Clinton, MDNTSB IAD76FIG13Accident · Serious injuriesClosedPiper J3C-65 · Mt Airy, MDNTSB IAD76FIG12Accident · No injuriesClosedPiper PA-28 · White Marsh, MDNTSB IAD76AI062Accident · 1 fatalClosedCessna 172L · Accident, MDNTSB IAD76FIA06Accident · 1 fatalClosedSmith Mini · Lexington Park, MDNTSB IAD76FIG11Accident · No injuriesClosedBellanca 7ECA · Fort Meade, MDNTSB IAD76FIA10Accident · Minor injuriesClosedCessna 150M · College Park, MDNTSB IAD76FIG09Accident · No injuriesClosedPiper PA-22 · College Park, MDNTSB IAD76AI054Accident · 3 fatalClosedMitsubishi MU-2B · Easton, MDNTSB IAD76FIA05Accident · No injuriesClosedCessna 177 · Clinton, MDNTSB IAD76FIG08Accident · Minor injuriesClosedCessna 150 · Baltimore, MDNTSB IAD76AI050Accident · 2 fatalClosedBeech D95A · Gaithersburg, MDNTSB IAD76AI047Accident · 1 fatalClosedSikorsky S-55 · California, MD