NTSB investigations, 1967, 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\") = 1967
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") = 1967 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 DIA68D0133Accident · No injuriesClosedBeech D95A · Salisbury, MDNTSB DIA68F0131Accident · No injuriesClosedPiper PA-22 · Odenton, MDNTSB DIA68D0126Accident · No injuriesClosedCessna 170 · Laurel, MDNTSB DIA68A0020Accident · 3 fatalClosedPiper PA-18 · Conowingo, MDNTSB DIA68D0119Accident · No injuriesClosedBeech D35 · College Park, MDNTSB DIA68F0098Accident · No injuriesClosedCessna 182J · Clinton, MDNTSB DIA68F0104Accident · No injuriesClosedPiper PA-28 · College Park, MDNTSB DIA68D0116Accident · No injuriesClosedChampion 7KC · Lothian, MDNTSB DIA68D0087Accident · No injuriesClosedPiper PA-28 · Laurel, MDNTSB DIA68D0084Accident · No injuriesClosedWaco RNF · Huntington, MDNTSB DIA68D0085Accident · No injuriesClosedN American P-51 · Frederick, MDNTSB DIA68F0077Accident · Serious injuriesClosedPiper PA-28 · Federalsburg, MDNTSB DIA68D0076Accident · No injuriesClosedPiper PA-24 · Mitchelville, MDNTSB DIA68D0071Accident · No injuriesClosedPiper PA-28 · Edgewater, MDNTSB DIA68F0072Accident · No injuriesClosedMooney M20E · Friendship Int., MDNTSB DIA68A0008Accident · 1 fatalClosedNavion NAV-A · Maugansville, MDNTSB DIA68A0005Accident · No injuriesClosedBeech E18S · Friendship, MDNTSB DIA68D0056Accident · No injuriesClosedBeech D18S · Baltimore, MDNTSB DIA68F0059Accident · Minor injuriesClosedCessna 140 · Davidsonville, MDNTSB DIA68F0061Accident · Minor injuriesClosedPiper PA-28 · Laurel, MDNTSB DIA68D0040Accident · No injuriesClosedLuscombe 8E · Edgewater, MDNTSB DIA68D0048Accident · No injuriesClosedPiper PA-28 · Baltimore, MDNTSB DIA68F0057Accident · No injuriesClosedPiper J3L-65 · Fallston, MDNTSB DIA68A0001Accident · No injuriesClosedHughes 269B · Silver Spring, MDNTSB DIA68D0037Accident · No injuriesClosedPiper PA-18 · Fort Meade, MDNTSB DIA68F0027Accident · No injuriesClosedCessna 172G · Clinton, MDNTSB DIA68F0026Accident · No injuriesClosedPiper PA-28 · Aberdeen, MDNTSB DIA68F0030Accident · Serious injuriesClosedBoeing A75N1 · Kennedyville, MDNTSB DIA67A0022Accident · No injuriesClosedBeech 65 · Baltimore, MDNTSB DIA68F0020Accident · Serious injuriesClosedBeech F35 · Oxon Hill, MDNTSB DIA68F0001Accident · No injuriesClosedPiper PA-22 · Mitchelville, MDNTSB DIA68F0024Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDNTSB DIA68D0019Accident · No injuriesClosedErco 415-C · Mitchellville, MDNTSB DIA68F0017Accident · No injuriesClosedBoeing YL-15 · Westminster, MDNTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDNTSB DIA67D0111Accident · No injuriesClosedBeech 35C · Cecilton, MDNTSB DIA68D0018Accident · No injuriesClosedCessna U206B · Friendship, MDNTSB DIA68F0010Accident · No injuriesClosedBeech 35 · Easton, MDNTSB DIA67D0099Accident · No injuriesClosedPiper PA-24 · Aberdeen, MDNTSB DIA67F0103Accident · Minor injuriesClosedPiper J3C · Cumberland, MDNTSB DIA68D0008Accident · No injuriesClosedPiper PA-28 · Laurel, MDNTSB DIA67A0016Accident · 1 fatalClosedBeech D18S · Baltimore, MDNTSB DIA67F0105Accident · No injuriesClosedPiper PA-30 · Baltimore, MDNTSB DIA67F0094Accident · No injuriesClosedPiper PA-24 · Silesia, MDNTSB DIA67D0083Accident · No injuriesClosedCessna 172 · Cambridge, MDNTSB DIA67D0093Accident · No injuriesClosedCessna 182 · Clinton, MDNTSB DIA67D0090Accident · No injuriesClosedBeech 95-B55 · Gaithersburg, MDNTSB DIA67F0089Accident · No injuriesClosedBeech H35 · Smithberg, MDNTSB DIA67D0078Accident · No injuriesClosedCessna 182 · Clinton, MDNTSB DIA67D0081Accident · No injuriesClosedCessna 172 · Pittsville, MD