NTSB investigations, 1973, MD
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1973
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") = 1973 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 IAD74AI036Accident · 1 fatalClosedBeech D95A · Hagerstown, MDNTSB IAD74FIG18Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDNTSB IAD74FIG16Accident · Serious injuriesClosedCessna 150 · Laurel, MDNTSB IAD74FIG15Accident · No injuriesClosedPiper PA-28 · Frederick, MDNTSB IAD74FIG14Accident · 1 fatalClosedVolksplane VP-1 · Uniontown, MDNTSB IAD74FIG13Accident · No injuriesClosedPiper PA-24 · Aldino, MDNTSB IAD74FIG11Accident · No injuriesClosedCessna 337F · Preston, MDNTSB IAD74FIG10Accident · No injuriesClosedPiper J-3 · College Park, MDNTSB IAD74AI017Accident · 2 fatalClosedBell 206A · Beltsville, MDNTSB IAD74FIG08Accident · Serious injuriesClosedLake 4-200 · Betterton, MDNTSB IAD74AI012Accident · Serious injuriesClosedBritish AC 1-11 · Baltimore, MDNTSB IAD74FIG07Accident · No injuriesClosedPiper PA-24 · Edgewater, MDNTSB IAD74AI010Accident · No injuriesClosedPiper PA-28R · Churchville, MDNTSB IAD74FIA02Accident · No injuriesClosedPiper PA-22 · Brandywine, MDNTSB IAD74FIA03Accident · No injuriesClosedPiper PA-28 · Newburg, MDNTSB IAD74II009Incident · No injuriesClosedBeech D95A · Sparks, MDNTSB IAD74FIG06Accident · Minor injuriesClosedBell 47G-5 · Berlin, MDNTSB IAD74FIG04Accident · Minor injuriesClosedCessna 150K · Edgewater, MDNTSB IAD74FIG03Accident · Serious injuriesClosedPiper PA-28 · Middletown, MDNTSB IAD74FIG02Accident · No injuriesClosedBrewster FLEET7 · Gaithersburg, MDNTSB IAD74AI003Accident · No injuriesClosedLuscombe 8E · Pasadena, MDNTSB IAD74FIG01Accident · Minor injuriesClosedAmer Avco AA1 · Stevensville, MDNTSB IAD73AI019Accident · Serious injuriesClosedPiper PA-30B · Cordova, MDNTSB IAD73DIG28Accident · Minor injuriesClosedPiper PA-24 · Westminster, MDNTSB IAD73FIG27Accident · No injuriesClosedPiper PA-24 · Baltimore, MDNTSB IAD73FIA15Accident · No injuriesClosedFleet 2 · Huntington, MDNTSB IAD73FIG25Accident · No injuriesClosedCessna 172A · Essex, MDNTSB IAD73FIG24Accident · No injuriesClosedCessna 195 · Federalsburg, MDNTSB IAD73AI014Accident · 1 fatalClosedPiper PA-23 · Cumberland, MDNTSB IAD73FIG22Accident · No injuriesClosedCessna 182P · Laurel, MDNTSB IAD73FIG23Accident · No injuriesClosedCessna 182M · Stevensville, MDNTSB IAD73DIG21Accident · No injuriesClosedCessna 150K · Salisbury, MDNTSB NYC73AN101Accident · Serious injuriesClosedPiper PA-22 · Edgewater, MDNTSB NYC73IN099Incident · No injuriesClosedDouglas DC-9 · Baltimore, MDNTSB NYC73AN096Accident · 3 fatalClosedMooney M20F · Elkton, MD