NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 DIA67F0009Accident · No injuriesClosedLuscombe 8F · Gaithersburg, MDNTSB DIA67F0015Accident · No injuriesClosedPiper PA-28 · Frederick, MDNTSB DIA67D0019Accident · No injuriesClosedPiper PA-22 · Laurel, MDNTSB NYC67A0094Accident · No injuriesClosedBrantly B-2B · Riverdale, MDNTSB DIA67F0003Accident · No injuriesClosedPiper PA-23 · Stevensville, MDNTSB NYC67A0093Accident · 1 fatalClosedPiper PA-22 · Frederick, MDNTSB DIA67F0014Accident · No injuriesClosedPiper PA-28 · Friendship, MDNTSB DIA67D0051Accident · No injuriesClosedBeech G35 · Rising Sun, MDNTSB NYC67F0393Accident · No injuriesClosedBeech G35 · Gaithersburg, MDNTSB NYC67D0386Accident · No injuriesClosedPiper PA-23 · Waldorf, MDNTSB DIA67F0002Accident · Minor injuriesClosedCessna 150F · Hagerstown, MDNTSB NYC67F0352Accident · No injuriesClosedAlon A-2 · Deale, MDNTSB NYC67D0362Accident · No injuriesClosedCessna 150 · Lower Marlboro, MDNTSB DCA67I0008Incident · No injuriesClosedLockheed 1049G · Andrews Afb, MDNTSB NYC67F0315Accident · No injuriesClosedCessna 210E · Newburg, MDNTSB NYC67F0302Accident · No injuriesClosedPiper PA-23 · Baltimore, MDNTSB NYC67F0301Accident · Minor injuriesClosedMooney M20C · Mitchellville, MDNTSB NYC67D0269Accident · No injuriesClosedPiper PA-28 · College Park, MDNTSB NYC67F0291Accident · Minor injuriesClosedChampion 7EC · Friendly, MDNTSB NYC67A0050Accident · No injuriesClosedHiller 1100 · Hagerstown, MDNTSB NYC67F0237Accident · No injuriesClosedStinson 108-1 · Clinton, MDNTSB NYC67F0245Accident · Serious injuriesClosedCassutt Q SPL · Frederick, MDNTSB NYC67A0044Accident · 1 fatalClosedArquilla WBB · Frederick, MDNTSB NYC67A0042Accident · 2 fatalClosedHughes 269B · Tuxedo, MDNTSB NYC67D0214Accident · No injuriesClosedPiper PA-28 · Laurel, MDNTSB NYC67D0215Accident · No injuriesClosedCessna 150 · Clinton, MDNTSB NYC67A0032Accident · 1 fatalClosedPiper PA-22 · Ocean City, MDNTSB NYC67F0188Accident · Minor injuriesClosedCessna 140 · Princess Anne, MDNTSB NYC67D0177Accident · No injuriesClosedCessna 150F · Hurlock, MDNTSB NYC67D0157Accident · No injuriesClosedCessna 182E · Hagerstown, MDNTSB NYC67D0101Accident · No injuriesClosedCessna 182J · Rock Hall, MDNTSB NYC67D0084Accident · No injuriesClosedCessna 150 · Clinton, MDNTSB NYC67F0107Accident · No injuriesClosedPiper PA-18A · Huntington, MDNTSB NYC67D0102Accident · No injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC67F0088Accident · Minor injuriesClosedPiper PA-24 · Chester, MDNTSB NYC67F0050Accident · No injuriesClosedBeech N35 · Hestertown, MDNTSB NYC67F0030Accident · Serious injuriesClosedPiper J3 · Ellicott City, MDNTSB NYC67D0049Accident · No injuriesClosedLuscombe 8F · Newburg, MDNTSB NYC67D0065Accident · No injuriesClosedCessna 150 · Frederick, MDNTSB NYC66A0149Accident · No injuriesClosedBell 47D1 · Newark, MDNTSB NYC66F0718Accident · No injuriesClosedPiper PA23 · Salisbury, MDNTSB NYC66D0683Accident · Minor injuriesClosedCessna 182 · White Plains, MDNTSB NYC66D0684Accident · No injuriesClosedPiper PA-22 · Frederick, MDNTSB NYC66F0712Accident · No injuriesClosedCessna 150 · Friendly, MDNTSB NYC66A0714Accident · Serious injuriesClosedCessna 172 · Clinton, MDNTSB NYC66A0132Accident · No injuriesClosedBrantly 305 · Annapolis, MDNTSB NYC66F0681Accident · Minor injuriesClosedPiper PA-17 · Frederick, MDNTSB NYC66D0693Accident · No injuriesClosedBeech 95 · Drayden, MDNTSB NYC66F0633Accident · No injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC66D0606Accident · No injuriesClosedPiper PA-28 · Laurel, MD