NTSB investigations, 1968, 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\") = 1968
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") = 1968 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 DIA69D0120Accident · No injuriesClosedPiper PA-30 · Friendship, MDNTSB DIA69D0125Accident · No injuriesClosedAero Comdr 100 · White Marsh, MDNTSB DIA69D0114Accident · No injuriesClosedCessna 150 · Brookeville, MDNTSB DIA69F0112Accident · No injuriesClosedAeronca 7EC · Gaithersburg, MDNTSB DIA69D0100Accident · Minor injuriesClosedPiper PA-28 · Chester, MDNTSB DIA69I0023Incident · No injuriesClosedBoeing 727 · Baltimore, MDNTSB DIA69D0089Accident · No injuriesClosedBeech A23 · Piney Point, MDNTSB DIA69F0090Accident · No injuriesClosedPiper PA-28 · Linthicum, MDNTSB DIA69A0019Accident · 2 fatalClosedPiper PA-28 · Blu Rdge Summt, MDNTSB DIA69F0099Accident · No injuriesClosedBeech 65-80 · Friendship, MDNTSB DIA69F0085Accident · No injuriesClosedPiper PA-22 · Cumberland, MDNTSB DIA69D0070Accident · No injuriesClosedCessna 182 · Harmony Hall, MDNTSB DIA69D0078Accident · No injuriesClosedBell 47G · Gaithersburg, MDNTSB DIA69F0071Accident · No injuriesClosedNavion L-17A · Edgewood, MDNTSB DIA69A0013Accident · 1 fatalClosedMooney M20E · White Marsh, MDNTSB DIA69F0061Accident · No injuriesClosedMooney M20C · Mitchellville, MDNTSB DIA69F0057Accident · No injuriesClosedMooney M21 · Mitchellville, MDNTSB DIA69A0010Accident · 2 fatalClosedCessna 172C · Rock Hall, MDNTSB DIA69A0009Accident · No injuriesClosedBeech C-45G · Cambridge, MDNTSB DIA69D0045Accident · No injuriesClosedPiper PA-28 · Mitchellville, MDNTSB DIA69F0059Accident · No injuriesClosedBeech 35-B33 · Ocean City, MDNTSB DIA69F0028Accident · Serious injuriesClosedCessna 150 · Oxon Hill, MDNTSB DIA69D0025Accident · No injuriesClosedPiper PA-24 · Ocean City, MDNTSB DIA69F0019Accident · No injuriesClosedN.American SNJ4 · Frederick, MDNTSB DIA69A0001Accident · 1 fatalClosedPiper PA-28 · Chase, MDNTSB DIA69F0022Accident · Minor injuriesClosedPiper PA-12 · Ocean City, MDNTSB DIA69D0016Accident · No injuriesClosedPiper J-3 · Waldorf, MDNTSB DIA69D0010Accident · No injuriesClosedCessna 150 · Solomons, MDNTSB DIA69F0007Accident · Minor injuriesClosedPiper PA-22 · Chestertown, MDNTSB DIA69F0006Accident · No injuriesClosedCessna 150 · Fallston, MDNTSB DIA69D0002Accident · No injuriesClosedCessna 182G · Lexington Park, MDNTSB DIA68D0236Accident · Minor injuriesClosedCessna 172 · Sykesville, MDNTSB DIA68F0226Accident · Minor injuriesClosedPiper PA-17 · Edgewater, MDNTSB DIA68A0049Accident · 4 fatalClosedPiper PA-28 · Myersville, MDNTSB DIA68F0229Accident · No injuriesClosedCessna 195 · Gaithersburg, MDNTSB DIA68F0195Accident · Minor injuriesClosedMooney M20C · Mitchellville, MDNTSB DIA68F0213Accident · Minor injuriesClosedPiper PA-22 · Rising Sun, MDNTSB DIA68F0206Accident · Minor injuriesClosedCessna 172 · Queenstown, MDNTSB DIA68F0199Accident · Minor injuriesClosedCessna 182 · Stevensville, MDNTSB DIA68F0207Accident · No injuriesClosedPiper J5A · College Park, MDNTSB DIA68A0040Accident · 2 fatalClosedCessna 150F · Churchville, MDNTSB DIA68F0192Accident · Minor injuriesClosedPiper PA-22 · Laurel, MDNTSB DIA68F0188Accident · No injuriesClosedN American P-51D · Frederick, MDNTSB DIA68A0039Accident · 2 fatalClosedHughes 300 · Marlow Heights, MDNTSB DIA68F0183Accident · No injuriesClosedErco 415-C · Gaithersburg, MDNTSB DIA68F0176Accident · Minor injuriesClosedPiper PA-22 · Simpsonville, MDNTSB DIA68F0179Accident · Minor injuriesClosedCessna 170B · Friendship Apt, MDNTSB DIA68F0168Accident · No injuriesClosedCessna 182 · Friendship Apt, MDNTSB DIA68F0163Accident · No injuriesClosedPiper PA-24 · Crisfield, MDNTSB DIA68D0146Accident · Serious injuriesClosedNavion A · Lusby, MD