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 IAD71DIG25Accident · No injuriesClosedPiper J-3 · College Park, MDMar 6, 1971 · N70294 · Substantial damage NTSB IAD71II033Incident · No injuriesClosedBoeing 720 · Baltimore, MDJan 12, 1971 · N7207U · Minor damage NTSB IAD71FIG27Accident · Minor injuriesClosedLuscombe 8A · Laytonsville, MDDec 19, 1970 · N45526 · Destroyed NTSB IAD71FIG23Accident · No injuriesClosedCessna 150 · White Marsh, MDDec 7, 1970 · N5114G · Substantial damage NTSB IAD71FIG22Accident · Minor injuriesClosedCessna 172K · Baltimore, MDDec 4, 1970 · N78437 · Substantial damage NTSB IAD71FIG21Accident · Minor injuriesClosedCessna 172 · Reistertown, MDNov 14, 1970 · N1174F · Substantial damage NTSB IAD71FIG19Accident · No injuriesClosedPiper J-3 · College Park, MDNov 7, 1970 · N1399V · Substantial damage NTSB IAD71AI017Accident · 4 fatalClosedBeech A23-24 · Ocean City, MDOct 24, 1970 · N7955L · Destroyed NTSB IAD71FIG16Accident · No injuriesClosedCessna 310 · Frienship Arpt, MDSep 21, 1970 · N670R · Substantial damage NTSB IAD71FIG15Accident · No injuriesClosedCessna 175 · Edgewater, MDSep 21, 1970 · N7417M · Substantial damage NTSB IAD71FIA08Accident · No injuriesClosedPiper PA-32 · Rose Haven, MDSep 3, 1970 · N3398W · Substantial damage NTSB IAD71FIG10Accident · No injuriesClosedPiper PA-28 · Chestertown, MDAug 31, 1970 · N6455J · Substantial damage NTSB IAD71FIG12Accident · No injuriesClosedCessna 195B · Stevensville, MDAug 30, 1970 · N3015B · Substantial damage NTSB IAD71DIG11Accident · No injuriesClosedPiper PA-28 · Fallston, MDAug 30, 1970 · N8047N · Substantial damage NTSB IAD71FIG14Accident · No injuriesClosedCessna 210 · Churchville, MDAug 26, 1970 · N7366E · Substantial damage NTSB IAD71FIG08Accident · Serious injuriesClosedLuscombe 8A · Frederick, MDAug 23, 1970 · N71478 · Destroyed NTSB IAD71FIG09Accident · No injuriesClosedCessna 170B · Taneytown, MDAug 21, 1970 · N1648D · Destroyed NTSB IAD71FIG07Accident · No injuriesClosedPiper PA-23 · Friendshp Arpt, MDAug 13, 1970 · N3325P · Substantial damage NTSB IAD71FIG13Accident · No injuriesClosedPiper PA-24 · Edgewater, MDAug 10, 1970 · N6558P · Substantial damage NTSB IAD71FIA02Accident · No injuriesClosedCessna 177 · Clinton, MDAug 4, 1970 · N2978X · Substantial damage NTSB IAD71FIG06Accident · Serious injuriesClosedErco 415-C · Cumberland, MDAug 2, 1970 · N2154H · Substantial damage NTSB IAD71FIG05Accident · No injuriesClosedBeech A23-19 · Whiteford, MDAug 1, 1970 · N6902Q · Substantial damage NTSB IAD71FIA01Accident · No injuriesClosedCessna 172D · Lothian, MDJul 23, 1970 · N2383U · Substantial damage NTSB IAD71AI006Accident · 2 fatalClosedPiper PA-18 · Clear Spring, MDJul 18, 1970 · N341T · Destroyed NTSB IAD71FIG03Accident · Minor injuriesClosedPiper PA-22 · Sykesville, MDJul 11, 1970 · N4522Z · Substantial damage NTSB IAD71FIG02Accident · Serious injuriesClosedPiper PA-28 · Sykesville, MDJul 2, 1970 · N8009N · Substantial damage NTSB IAD70AI063Accident · No injuriesClosedBeech 99 · Hagerstown, MDJun 17, 1970 · N7899R · Substantial damage NTSB IAD70FIG18Accident · Minor injuriesClosedTaylorcraft DCO-65 · Cumberland, MDJun 11, 1970 · N46113 · Destroyed NTSB IAD71FIG17Accident · No injuriesClosedFairchild M-62C · Baltimore, MDMay 24, 1970 · N52020 · Substantial damage NTSB IAD70DIG19Accident · No injuriesClosedChampion L-16 · Davidsonville, MDMay 24, 1970 · N3948A · Substantial damage NTSB IAD70FIG16Accident · No injuriesClosedMooney M20E · Mitchellville, MDMay 12, 1970 · N1988Y · Substantial damage NTSB IAD70DIG15Accident · No injuriesClosedErco 415-C · College Park, MDMay 2, 1970 · N2237H · Substantial damage NTSB IAD70FIA13Accident · Serious injuriesClosedPiper PA-23 · Clinton, MDApr 30, 1970 · N2045P · Substantial damage NTSB IAD70AI059Accident · 2 fatalClosedPiper PA-28 · Frederick, MDApr 25, 1970 · N5113G · Destroyed NTSB IAD70DIG14Accident · No injuriesClosedCessna 172 · Friendsville, MDApr 19, 1970 · N1324F · Substantial damage NTSB NYC70FHG05Accident · No injuriesClosedPiper PA-28 · Woodland Beach, MDApr 12, 1970 · N5336L · Substantial damage NTSB IAD70FIA09Accident · Serious injuriesClosedPiper PA-24 · Lusby, MDApr 12, 1970 · N8188P · Destroyed NTSB IAD70DIG13Accident · No injuriesClosedEnstrom F-28A · Silver Springs, MDApr 10, 1970 · N4886 · Substantial damage NTSB IAD70FIG12Accident · No injuriesClosedAero Comdr 100 · Friendshp Arpt, MDApr 5, 1970 · N5533M · Substantial damage NTSB IAD70AI054Accident · 3 fatalClosedPiper PA-32 · Cambridge, MDApr 2, 1970 · N3241W · Destroyed NTSB IAD70DIA10Accident · No injuriesClosedPiper PA-24 · Accokeek, MDMar 31, 1970 · N5038P · Substantial damage NTSB IAD70FIG09Accident · Minor injuriesClosedCessna 150G · Hagerstown, MDMar 17, 1970 · N4678X · Destroyed NTSB IAD70DIG11Accident · No injuriesClosedAero Comdr 100 · Centreville, MDMar 14, 1970 · N3783X · Substantial damage NTSB IAD70DIG10Accident · No injuriesClosedCallair A-9 · Massey, MDMar 12, 1970 · N7220V · Substantial damage NTSB IAD70FIG07Accident · No injuriesClosedPiper PA-28 · Laurel, MDMar 8, 1970 · N9624W · Substantial damage NTSB IAD70FI608Accident · No injuriesClosedCessna 182 · Ridgely, MDMar 8, 1970 · N8862X · Substantial damage NTSB IAD70DIA06Accident · Minor injuriesClosedPiper PA-28 · Clinton, MDMar 7, 1970 · N4225J · Substantial damage NTSB IAD70FIG06Accident · No injuriesClosedCessna 120 · Gaithersburg, MDMar 2, 1970 · N76478 · Substantial damage NTSB IAD70FIG05Accident · No injuriesClosedCessna 170B · Friendship Apt, MDFeb 12, 1970 · N3244A · Substantial damage NTSB IAD70FIA03Accident · 1 fatalClosedCessna 172K · Chesapeake Bch, MDFeb 7, 1970 · N84262 · Substantial damage