NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 NYC66F0443Accident · No injuriesClosedErcoupe 415-C · Laytonsville, MDNTSB NYC66F0398Accident · No injuriesClosedCessna 172 · Gaithersburg, MDNTSB NYC66F0388Accident · Serious injuriesClosedCessna 172 · Stevensville, MDNTSB NYC66D0425Accident · No injuriesClosedCessna 175 · Rockville, MDNTSB NYC66D0342Accident · No injuriesClosedCessna 172 · College Park, MDNTSB NYC66D0337Accident · No injuriesClosedChampion 7ECA · Clinton, MDNTSB NYC66D0331Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDNTSB NYC66F0359Accident · No injuriesClosedCessna 210B · Clinton, MDNTSB NYC66D0316Accident · No injuriesClosedCessna 170B · Baltimore, MDNTSB NYC66D0315Accident · No injuriesClosedCessna 150 · Pocomoke City, MDNTSB NYC66F0322Accident · No injuriesClosedPiper PA-23 · Reverdale, MDNTSB NYC66D0304Accident · No injuriesClosedCessna 150 · Clinton, MDNTSB NYC66F0306Accident · No injuriesClosedCessna 140 · Gaithersburg, MDNTSB NYC66D0281Accident · Minor injuriesClosedPiper PA-22 · Stevensville, MDNTSB NYC66F0285Accident · No injuriesClosedPiper PA-12 · College Park, MDNTSB NYC66D0303Accident · No injuriesClosedPiper PA-28 · Annapolis, MDNTSB NYC66F0305Accident · Minor injuriesClosedRyan ST-3KR · Laurel, MDNTSB NYC66D0280Accident · No injuriesClosedCessna 170 · Gaithersburg, MDNTSB NYC66A0044Accident · Minor injuriesClosedBell 47H-1 · Clinton, MDNTSB NYC66F0259Accident · No injuriesClosedStinson 108 · Ocean City, MDNTSB NYC66A0036Accident · 1 fatalClosedPiper PA-23 · Glen Burnie, MDNTSB NYC66D0250Accident · No injuriesClosedPiper PA-22 · Baltimore, MDNTSB NYC66D0239Accident · No injuriesClosedLeister-K 10-A · Frizzelburg, MDNTSB NYC66F0223Accident · No injuriesClosedPiper PA-24 · Gaithersburg, MDNTSB NYC66F0202Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDNTSB NYC66D0173Accident · No injuriesClosedPiper PA-22 · Laytonsville, MDNTSB NYC66F0217Accident · Minor injuriesClosedBeechcraft C-45H · Cambridge, MDNTSB NYC66F0142Accident · No injuriesClosedBeechcraft A35 · Elkton, MDNTSB NYC66D0149Accident · No injuriesClosedCessna 172 · Essex, MDNTSB NYC66A0020Accident · Serious injuriesClosedBrantly B-2B · Cumberland, MDNTSB NYC66A0019Accident · No injuriesClosedBrantly B-2B · Silver Spring, MDNTSB NYC66D0147Accident · No injuriesClosedPiper PA-22 · Ft Meade, MDNTSB NYC66D0141Accident · No injuriesClosedBeechcraft 23 · Gaithersburg, MDNTSB NYC66A0018Accident · 2 fatalClosedPiper PA-23 · Union Bridge, MDNTSB NYC66A0016Accident · 4 fatalClosedCessna 172F · Newburg, MDNTSB NYC66A0014Accident · No injuriesClosedBell 47G2 · Hollywood, MDNTSB NYC66D0140Accident · No injuriesClosedCessna 172 · Princess Anne, MDNTSB NYC66F0148Accident · No injuriesClosedPiper PA-22 · Salisbury, MDNTSB NYC66D0159Accident · Minor injuriesClosedChampion 7FC · Easton, MDNTSB NYC66F0060Accident · No injuriesClosedCessna 172 · Still Pond, MDNTSB NYC66F0064Accident · Serious injuriesClosedPiper J3C · Baltimore, MDNTSB NYC66A0009Accident · No injuriesClosedBrantly B-2 · Suitland, MDNTSB NYC66A0003Accident · 1 fatalClosedHughes 269B · Waldorf, MDNTSB NYC66F0070Accident · No injuriesClosedPiper PA-22 · Cumberland, MDNTSB NYC66D0058Accident · No injuriesClosedCessna 150 · Friendly, MDNTSB NYC66D0059Accident · Minor injuriesClosedCessna 140 · Odenton, MDNTSB NYC66F0097Accident · No injuriesClosedMoonraker 100 · Gaithersburg, MDNTSB NYC66F0071Accident · No injuriesClosedNavion L-17A · Potomac, MDNTSB NYC66F0003Accident · Serious injuriesClosedLuscombe 8A · Mitchellville, MDNTSB NYC65A0147Accident · No injuriesClosedBell 47G2 · Laurel, MD