Skip to content

NTSB investigations, MD

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'MD' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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 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 DIA68D0048Accident · No injuriesClosedPiper PA-28 · Baltimore, MDJul 22, 1967 · N9682W · Substantial damage NTSB DIA68F0057Accident · No injuriesClosedPiper J3L-65 · Fallston, MDJul 16, 1967 · N38118 · Destroyed NTSB DIA68A0001Accident · No injuriesClosedHughes 269B · Silver Spring, MDJul 14, 1967 · N9474F · Substantial damage NTSB DIA68D0037Accident · No injuriesClosedPiper PA-18 · Fort Meade, MDJul 12, 1967 · N1005A · Substantial damage NTSB DIA68F0027Accident · No injuriesClosedCessna 172G · Clinton, MDJul 5, 1967 · N3876L · Substantial damage NTSB DIA68F0026Accident · No injuriesClosedPiper PA-28 · Aberdeen, MDJun 23, 1967 · N6614W · Substantial damage NTSB DIA68F0030Accident · Serious injuriesClosedBoeing A75N1 · Kennedyville, MDJun 21, 1967 · N60700 · Destroyed NTSB DIA67A0022Accident · No injuriesClosedBeech 65 · Baltimore, MDJun 20, 1967 · N3666B · Substantial damage NTSB DIA68F0020Accident · Serious injuriesClosedBeech F35 · Oxon Hill, MDJun 17, 1967 · N4256B · Destroyed NTSB DIA68F0001Accident · No injuriesClosedPiper PA-22 · Mitchelville, MDJun 17, 1967 · N8811C · Substantial damage NTSB DIA68F0024Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDJun 16, 1967 · N3496J · Substantial damage NTSB DIA68D0019Accident · No injuriesClosedErco 415-C · Mitchellville, MDJun 13, 1967 · N94394 · Substantial damage NTSB DIA68F0017Accident · No injuriesClosedBoeing YL-15 · Westminster, MDJun 1, 1967 · N4210A · Substantial damage NTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDMay 29, 1967 · N8692S · Substantial damage NTSB DIA67D0111Accident · No injuriesClosedBeech 35C · Cecilton, MDMay 29, 1967 · N822M · Substantial damage NTSB DIA68D0018Accident · No injuriesClosedCessna U206B · Friendship, MDMay 24, 1967 · N3495L · Substantial damage NTSB DIA68F0010Accident · No injuriesClosedBeech 35 · Easton, MDMay 19, 1967 · N4204D · Substantial damage NTSB DIA67D0099Accident · No injuriesClosedPiper PA-24 · Aberdeen, MDMay 19, 1967 · N9006P · Substantial damage NTSB DIA67F0103Accident · Minor injuriesClosedPiper J3C · Cumberland, MDMay 10, 1967 · N22831 · Substantial damage NTSB DIA68D0008Accident · No injuriesClosedPiper PA-28 · Laurel, MDMay 7, 1967 · N6511W · Substantial damage NTSB DIA67A0016Accident · 1 fatalClosedBeech D18S · Baltimore, MDMay 2, 1967 · N44596 · Destroyed NTSB DIA67F0105Accident · No injuriesClosedPiper PA-30 · Baltimore, MDApr 30, 1967 · N7435Y · Substantial damage NTSB DIA67F0094Accident · No injuriesClosedPiper PA-24 · Silesia, MDApr 30, 1967 · N6385P · Substantial damage NTSB DIA67D0083Accident · No injuriesClosedCessna 172 · Cambridge, MDApr 21, 1967 · N1713F · Substantial damage NTSB DIA67D0093Accident · No injuriesClosedCessna 182 · Clinton, MDApr 19, 1967 · N381LA · Substantial damage NTSB DIA67D0090Accident · No injuriesClosedBeech 95-B55 · Gaithersburg, MDApr 17, 1967 · N4314Y · Substantial damage NTSB DIA67F0089Accident · No injuriesClosedBeech H35 · Smithberg, MDApr 16, 1967 · N7970D · Destroyed NTSB DIA67D0078Accident · No injuriesClosedCessna 182 · Clinton, MDApr 12, 1967 · N7172E · Substantial damage NTSB DIA67D0081Accident · No injuriesClosedCessna 172 · Pittsville, MDApr 3, 1967 · N8852B · Substantial damage NTSB DIA67D0077Accident · No injuriesClosedPiper PA-28 · Gaithersburg, MDApr 2, 1967 · N4249J · Substantial damage NTSB DIA67D0075Accident · No injuriesClosedPiper PA-22 · Patuxent Nas, MDMar 27, 1967 · N5730Z · Substantial damage NTSB DIA67A0013Accident · No injuriesClosedHughes 269B · College Park, MDMar 24, 1967 · N700 · Substantial damage NTSB DIA67D0066Accident · No injuriesClosedBeech T-34A · Beltsville, MDMar 18, 1967 · N10516 · Substantial damage NTSB DIA67D0065Accident · No injuriesClosedPiper PA-28 · Pr.Frederick, MDMar 11, 1967 · N7555W · Substantial damage NTSB DIA67A0012Accident · 1 fatalClosedPiper PA-23 · Oldtown, MDMar 1, 1967 · N5868Y · Destroyed NTSB DIA67D0062Accident · No injuriesClosedPiper PA-28 · Westminster, MDFeb 24, 1967 · N8237W · Substantial damage NTSB DIA67F0049Accident · No injuriesClosedErcoupe 415-C · Laurel, MDFeb 19, 1967 · N99981 · Substantial damage NTSB DIA67D0048Accident · No injuriesClosedPiper PA-22 · Gaithersburg, MDFeb 14, 1967 · N5324Z · Substantial damage NTSB DIA67D0044Accident · No injuriesClosedPiper PA-28 · Salisbury, MDFeb 12, 1967 · N6337R · Substantial damage NTSB DIA67D0043Accident · No injuriesClosedCessna 150 · College Park, MDFeb 11, 1967 · N8259S · Substantial damage NTSB DIA67D0041Accident · No injuriesClosedPiper PA-28 · Essex, MDFeb 11, 1967 · N7007J · Substantial damage NTSB DIA67F0040Accident · No injuriesClosedChampion 402 · Friendly, MDFeb 10, 1967 · N9954Y · Destroyed NTSB DIA67D0035Accident · No injuriesClosedPiper PA-28 · Frederick, MDFeb 5, 1967 · N6255W · Substantial damage NTSB DIA67D0025Accident · No injuriesClosedCessna Wren · Laurel, MDFeb 2, 1967 · M2427X · Substantial damage NTSB DIA67D0042Accident · No injuriesClosedPiper PA-12 · Westminster, MDJan 29, 1967 · N2918M · Substantial damage NTSB DIA67D0032Accident · No injuriesClosedCessna 150 · Hagerstown, MDJan 24, 1967 · N8098S · Substantial damage NTSB DIA67D0031Accident · No injuriesClosedCessna 150F · Gaithersburg, MDJan 24, 1967 · N8716S · Substantial damage NTSB DIA67A0007Accident · 2 fatalClosedAeronca 65-CA · Fruitland, MDJan 23, 1967 · N31932 · Destroyed NTSB DIA67D0012Accident · No injuriesClosedPiper PA-22 · Randallstown, MDJan 18, 1967 · N3618Z · Substantial damage NTSB DIA67F0029Accident · No injuriesClosedPiper PA-28 · Pasadena, MDJan 16, 1967 · N8773W · Substantial damage