NTSB investigations, 1977, MD
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1977
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") = 1977 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 IAD78DIG04Accident · No injuriesClosedCessna 182 · Hempstead, MDNTSB IAD78FA019Accident · 2 fatalClosedVarga 2150A · Jessup, MDNTSB IAD78FIG03Accident · Minor injuriesClosedCessna 195B · Elkton, MDNTSB IAD78FA011Accident · 2 fatalClosedPiper PA-32 · Emmitsburg, MDNTSB IAD78FIG02Accident · No injuriesClosedCessna 210 · Edgewater, MDNTSB IAD78FIG01Accident · Minor injuriesClosedPiper PA28 · Baltimore, MDNTSB IAD77FIG36Accident · No injuriesClosedBeech 200 · Gaithersburg, MDNTSB IAD77FIG35Accident · No injuriesClosedHughes 269B · Gaithersburg, MDNTSB IAD77FA066Accident · Serious injuriesClosedPiper PA-28 · Clinton, MDNTSB IAD77FIA23Accident · Serious injuriesClosedChampion 7ACA · Brandywine, MDNTSB IAD77FIG34Accident · No injuriesClosedCessna 150L · Tryaskin, MDNTSB IAD77FIG32Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDNTSB IAD77FIG33Accident · No injuriesClosedPiper PA-22 · Mitchellville, MDNTSB IAD77FA058Accident · 1 fatalClosedGrum Amer AA1-B · Unity, MDNTSB IAD77IA057Incident · No injuriesClosedBell 206L · Poolesville, MDNTSB IAD77FIG31Accident · No injuriesClosedBeech 23 · Essex, MDNTSB IAD77FIG28Accident · No injuriesClosedBeech 23 · Gaithersburg, MDNTSB IAD77FIG26Accident · No injuriesClosedCessna 150 · Baltimore, MDNTSB IAD77FIG27Accident · Minor injuriesClosedCessna 172C · Stevensville, MDNTSB IAD77FIG25Accident · No injuriesClosedBeech B24R · Carmichael, MDNTSB IAD77FIG24Accident · Minor injuriesClosedCessna 150G · Aberdeen, MDNTSB IAD77FIA20Accident · Minor injuriesClosedAeronca 7AC · Balalton, MDNTSB IAD77FIG30Accident · No injuriesClosedRyan ST-A · Frederick, MDNTSB IAD77FIG29Accident · No injuriesClosedChampion 7KCAB · Ocean City, MDNTSB IAD77FIG22Accident · No injuriesClosedLake LA4 · Essex, MDNTSB IAD77FIG21Accident · Minor injuriesClosedCessna 172 · College Park, MDNTSB IAD77DIA19Accident · No injuriesClosedCessna 150A · California, MDNTSB IAD77FA043Accident · 1 fatalClosedCessna 172 · Cavetown, MDNTSB IAD77FIG20Accident · Minor injuriesClosedSchweizer 1-26 · Frostburg, MDNTSB IAD77FIG19Accident · Minor injuriesClosedPiper PA22 · Laytonsville, MDNTSB IAD77FIG18Accident · Serious injuriesClosedAero Cmdr 200D · Sussex, MDNTSB IAD77FIG17Accident · No injuriesClosedGrum Amer AA1 · Darlington, MDNTSB IAD77FIA13Accident · Serious injuriesClosedBeech B-35 · Hollywood, MDNTSB IAD77FIG16Accident · No injuriesClosedEnstrom F28A · Pikesville, MDNTSB IAD77IA037Incident · No injuriesClosedPiper PA-32R · Forest Hills, MDNTSB IAD77FIG15Accident · Minor injuriesClosedChampion 7ECA · Churchville, MDNTSB IAD77DIA10Accident · Minor injuriesClosedPitts S1 · Clinton, MDNTSB IAD77FIG13Accident · Serious injuriesClosedCessna 172 · Cumberland, MDNTSB IAD77FIG11Accident · Serious injuriesClosedBellanca 7ECA · Galena, MDNTSB IAD77FIG10Accident · No injuriesClosedHughes 269B · Gaithersburg, MDNTSB IAD77FA017Accident · Serious injuriesClosedDouglas DC-8 · Baltimore, MD