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 NYC66D0606Accident · No injuriesClosedPiper PA-28 · Laurel, MDApr 8, 1966 · N6378W · Substantial damage NTSB NYC66D0605Accident · No injuriesClosedCessna 172 · Taylorsville, MDApr 3, 1966 · N7046A · Substantial damage NTSB NYC66D0583Accident · No injuriesClosedPiper J3C · Bowie, MDMar 22, 1966 · N6627H · Destroyed NTSB NYC66D0580Accident · No injuriesClosedPiper PA-12 · Gaithersburg, MDMar 21, 1966 · N4231M · Substantial damage NTSB NYC66F0598Accident · No injuriesClosedCessna 170B · Friendly, MDMar 20, 1966 · N2754C · Substantial damage NTSB NYC66A0101Accident · No injuriesClosedHughes 269B · Edmonston, MDMar 18, 1966 · N9359F · Substantial damage NTSB NYC66A0099Accident · Serious injuriesClosedBrantly B-2B · Clinton, MDMar 15, 1966 · N2177U · Destroyed NTSB NYC66F0561Accident · No injuriesClosedBeechcraft A23 · Gaithersburg, MDMar 10, 1966 · N2395W · Substantial damage NTSB NYC66D0533Accident · No injuriesClosedCessna 150 · Friendly, MDFeb 26, 1966 · N5954T · Substantial damage NTSB NYC66F0544Accident · Minor injuriesClosedAero Comdr 500-B · Hagerstown, MDFeb 24, 1966 · N9388R · Substantial damage NTSB NYC66F0543Accident · No injuriesClosedAeronca 7BCM · Cumberland, MDFeb 20, 1966 · N4064A · Substantial damage NTSB NYC66D0515Accident · Minor injuriesClosedPiper J-3 · Edgewater, MDFeb 19, 1966 · N70255 · Substantial damage NTSB NYC66D0514Accident · No injuriesClosedPiper PA-22 · Newberg, MDFeb 19, 1966 · N7040B · Substantial damage NTSB NYC66D0507Accident · No injuriesClosedCessna 150 · Gaithersburg, MDFeb 12, 1966 · N8716S · Substantial damage NTSB NYC66D0506Accident · No injuriesClosedPiper PA-22 · Glen Arm, MDFeb 12, 1966 · N9028D · Substantial damage NTSB NYC66A0084Accident · No injuriesClosedBell 47G2 · Bowie, MDFeb 3, 1966 · N7890B · Substantial damage NTSB NYC66A0075Accident · 1 fatalClosedPiper PA-28 · Gaithersburg, MDJan 16, 1966 · N7256W · No damage NTSB NYC66F0460Accident · No injuriesClosedPiper PA-28 · Baltimore, MDJan 12, 1966 · N6297W · Substantial damage NTSB NYC66F0440Accident · No injuriesClosedCessna 172F · Baltimore, MDJan 8, 1966 · N7950U · Substantial damage NTSB NYC66F0443Accident · No injuriesClosedErcoupe 415-C · Laytonsville, MDDec 31, 1965 · N2527H · Substantial damage NTSB NYC66F0398Accident · No injuriesClosedCessna 172 · Gaithersburg, MDDec 11, 1965 · N6836X · Substantial damage NTSB NYC66F0388Accident · Serious injuriesClosedCessna 172 · Stevensville, MDDec 4, 1965 · N2560U · Destroyed NTSB NYC66D0425Accident · No injuriesClosedCessna 175 · Rockville, MDNov 28, 1965 · N7373M · Substantial damage NTSB NYC66D0342Accident · No injuriesClosedCessna 172 · College Park, MDNov 13, 1965 · N6225E · Substantial damage NTSB NYC66D0337Accident · No injuriesClosedChampion 7ECA · Clinton, MDOct 31, 1965 · N9539S · Substantial damage NTSB NYC66D0331Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDOct 30, 1965 · N8748S · Substantial damage NTSB NYC66F0359Accident · No injuriesClosedCessna 210B · Clinton, MDOct 26, 1965 · N9741X · Substantial damage NTSB NYC66D0316Accident · No injuriesClosedCessna 170B · Baltimore, MDOct 18, 1965 · N3483D · Substantial damage NTSB NYC66D0315Accident · No injuriesClosedCessna 150 · Pocomoke City, MDOct 17, 1965 · N7335X · Substantial damage NTSB NYC66F0322Accident · No injuriesClosedPiper PA-23 · Reverdale, MDOct 14, 1965 · N4622P · Substantial damage NTSB NYC66D0304Accident · No injuriesClosedCessna 150 · Clinton, MDOct 13, 1965 · N5830E · Substantial damage NTSB NYC66F0306Accident · No injuriesClosedCessna 140 · Gaithersburg, MDOct 10, 1965 · N2318N · Substantial damage NTSB NYC66D0281Accident · Minor injuriesClosedPiper PA-22 · Stevensville, MDOct 10, 1965 · N1425C · Substantial damage NTSB NYC66F0285Accident · No injuriesClosedPiper PA-12 · College Park, MDOct 9, 1965 · N2573M · Substantial damage NTSB NYC66D0303Accident · No injuriesClosedPiper PA-28 · Annapolis, MDOct 9, 1965 · N6297W · Substantial damage NTSB NYC66F0305Accident · Minor injuriesClosedRyan ST-3KR · Laurel, MDOct 8, 1965 · N1144 · Substantial damage NTSB NYC66D0280Accident · No injuriesClosedCessna 170 · Gaithersburg, MDOct 3, 1965 · N707F · Substantial damage NTSB NYC66A0044Accident · Minor injuriesClosedBell 47H-1 · Clinton, MDOct 2, 1965 · N996B · Substantial damage NTSB NYC66F0259Accident · No injuriesClosedStinson 108 · Ocean City, MDSep 26, 1965 · N9209K · Substantial damage NTSB NYC66A0036Accident · 1 fatalClosedPiper PA-23 · Glen Burnie, MDSep 20, 1965 · N5759Y · Destroyed NTSB NYC66D0250Accident · No injuriesClosedPiper PA-22 · Baltimore, MDSep 19, 1965 · N5863Z · Substantial damage NTSB NYC66D0239Accident · No injuriesClosedLeister-K 10-A · Frizzelburg, MDSep 6, 1965 · N58179 · Substantial damage NTSB NYC66F0223Accident · No injuriesClosedPiper PA-24 · Gaithersburg, MDSep 5, 1965 · N7162P · Substantial damage NTSB NYC66F0202Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDAug 31, 1965 · N1429A · Substantial damage NTSB NYC66D0173Accident · No injuriesClosedPiper PA-22 · Laytonsville, MDAug 20, 1965 · N4796Z · Substantial damage NTSB NYC66F0217Accident · Minor injuriesClosedBeechcraft C-45H · Cambridge, MDAug 17, 1965 · N159L · Destroyed NTSB NYC66F0142Accident · No injuriesClosedBeechcraft A35 · Elkton, MDAug 13, 1965 · N693B · Substantial damage NTSB NYC66D0149Accident · No injuriesClosedCessna 172 · Essex, MDAug 10, 1965 · N2553U · Substantial damage NTSB NYC66A0020Accident · Serious injuriesClosedBrantly B-2B · Cumberland, MDAug 9, 1965 · N2263U · Substantial damage NTSB NYC66A0019Accident · No injuriesClosedBrantly B-2B · Silver Spring, MDAug 8, 1965 · N2261U · Substantial damage