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 IAD77FIG36Accident · No injuriesClosedBeech 200 · Gaithersburg, MDSep 26, 1977 · N725MC · Substantial damage NTSB IAD77FIG35Accident · No injuriesClosedHughes 269B · Gaithersburg, MDSep 15, 1977 · N9568F · Substantial damage NTSB IAD77FA066Accident · Serious injuriesClosedPiper PA-28 · Clinton, MDSep 15, 1977 · N9879W · Destroyed NTSB IAD77FIA23Accident · Serious injuriesClosedChampion 7ACA · Brandywine, MDAug 28, 1977 · N9110L · Substantial damage NTSB IAD77FIG34Accident · No injuriesClosedCessna 150L · Tryaskin, MDAug 21, 1977 · N10765 · Substantial damage NTSB IAD77FIG32Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDAug 14, 1977 · N8006C · Substantial damage NTSB IAD77FIG33Accident · No injuriesClosedPiper PA-22 · Mitchellville, MDAug 11, 1977 · N2544A · Substantial damage NTSB IAD77FA058Accident · 1 fatalClosedGrum Amer AA1-B · Unity, MDAug 11, 1977 · N9677L · Destroyed NTSB IAD77IA057Incident · No injuriesClosedBell 206L · Poolesville, MDAug 7, 1977 · N16664 · No damage NTSB IAD77FIG31Accident · No injuriesClosedBeech 23 · Essex, MDJul 27, 1977 · N824PJ · Substantial damage NTSB IAD77FIG28Accident · No injuriesClosedBeech 23 · Gaithersburg, MDJul 23, 1977 · N6VT · Substantial damage NTSB IAD77FIG26Accident · No injuriesClosedCessna 150 · Baltimore, MDJul 18, 1977 · N50823 · Substantial damage NTSB IAD77FIG27Accident · Minor injuriesClosedCessna 172C · Stevensville, MDJul 17, 1977 · N2029Y · Substantial damage NTSB IAD77FIG25Accident · No injuriesClosedBeech B24R · Carmichael, MDJul 15, 1977 · N2570W · Substantial damage NTSB IAD77FIG24Accident · Minor injuriesClosedCessna 150G · Aberdeen, MDJul 11, 1977 · N6310S · Substantial damage NTSB IAD77FIA20Accident · Minor injuriesClosedAeronca 7AC · Balalton, MDJul 7, 1977 · N85226 · Substantial damage NTSB IAD77FIG30Accident · No injuriesClosedRyan ST-A · Frederick, MDJul 1, 1977 · N17364 · Substantial damage NTSB IAD77FIG29Accident · No injuriesClosedChampion 7KCAB · Ocean City, MDJul 1, 1977 · N7532F · Substantial damage NTSB IAD77FIG22Accident · No injuriesClosedLake LA4 · Essex, MDJun 30, 1977 · N1236L · Substantial damage NTSB IAD77FIG21Accident · Minor injuriesClosedCessna 172 · College Park, MDJun 25, 1977 · N2477L · Substantial damage NTSB IAD77DIA19Accident · No injuriesClosedCessna 150A · California, MDJun 25, 1977 · N9852J · Substantial damage NTSB IAD77FA043Accident · 1 fatalClosedCessna 172 · Cavetown, MDMay 31, 1977 · N20480 · Destroyed NTSB IAD77FIG20Accident · Minor injuriesClosedSchweizer 1-26 · Frostburg, MDMay 21, 1977 · N8668R · Substantial damage NTSB IAD77FIG19Accident · Minor injuriesClosedPiper PA22 · Laytonsville, MDMay 20, 1977 · N1612P · Substantial damage NTSB IAD77FIG18Accident · Serious injuriesClosedAero Cmdr 200D · Sussex, MDMay 15, 1977 · N5501M · Substantial damage NTSB IAD77FIG17Accident · No injuriesClosedGrum Amer AA1 · Darlington, MDMay 8, 1977 · N5748L · Substantial damage NTSB IAD77FIA13Accident · Serious injuriesClosedBeech B-35 · Hollywood, MDMay 8, 1977 · N8922A · Destroyed NTSB IAD77FIG16Accident · No injuriesClosedEnstrom F28A · Pikesville, MDApr 21, 1977 · N9566 · Destroyed NTSB IAD77IA037Incident · No injuriesClosedPiper PA-32R · Forest Hills, MDApr 20, 1977 · N4505X · Minor damage NTSB IAD77FIG15Accident · Minor injuriesClosedChampion 7ECA · Churchville, MDMar 27, 1977 · N11030 · Substantial damage NTSB IAD77DIA10Accident · Minor injuriesClosedPitts S1 · Clinton, MDMar 19, 1977 · N4111 · Substantial damage NTSB IAD77FIG13Accident · Serious injuriesClosedCessna 172 · Cumberland, MDMar 18, 1977 · N75632 · Destroyed NTSB IAD77FIG11Accident · Serious injuriesClosedBellanca 7ECA · Galena, MDFeb 19, 1977 · N57679 · Substantial damage NTSB IAD77FIG10Accident · No injuriesClosedHughes 269B · Gaithersburg, MDJan 23, 1977 · N9483F · Substantial damage NTSB IAD77FA017Accident · Serious injuriesClosedDouglas DC-8 · Baltimore, MDJan 16, 1977 · N904CL · Minor damage NTSB IAD77FIG09Accident · Serious injuriesClosedCurtis MSTNG2 · Mitchelville, MDDec 19, 1976 · N2987 · Destroyed NTSB IAD77FA016Accident · 2 fatalClosedBoeing A75 · Crofton, MDDec 19, 1976 · N63806 · Substantial damage NTSB DCA77AA008Accident · Serious injuriesClosedPiper PA-28 · Baltimore, MDDec 19, 1976 · N6276J · Substantial damage NTSB IAD77FIA06Accident · Minor injuriesClosedCessna 182 · Friendly, MDDec 11, 1976 · N52581 · Substantial damage NTSB IAD77FIG05Accident · Minor injuriesClosedCessna 177 · Middle River, MDNov 21, 1976 · N4010K · Substantial damage NTSB IAD77FIG04Accident · Serious injuriesClosedEvans VP-2 · Westminster, MDNov 19, 1976 · N60BH · Substantial damage NTSB IAD77FIA03Accident · No injuriesClosedGrum Amer AA1-B · Leonardtown, MDOct 29, 1976 · N1476R · Substantial damage NTSB IAD77FIG02Accident · No injuriesClosedBeech B35 · Mitchellville, MDOct 16, 1976 · N3889N · Substantial damage NTSB IAD77DIG03Accident · No injuriesClosedCessna 150 · Easton, MDOct 16, 1976 · N7574U · Substantial damage NTSB IAD77FIG01Accident · Minor injuriesClosedCessna 182P · Hagerstown, MDOct 11, 1976 · N91388 · Substantial damage NTSB IAD76FIG27Accident · No injuriesClosedCessna 150 · Silver Springs, MDSep 23, 1976 · N50657 · Substantial damage NTSB IAD76FIG26Accident · No injuriesClosedBellanca 7KCAB · Bowie, MDSep 14, 1976 · N6360N · Substantial damage NTSB IAD76AI099Accident · 1 fatalClosedAmer Avco AA1 · Frederick, MDSep 12, 1976 · N6137L · Destroyed NTSB IAD76FIG28Accident · Minor injuriesClosedLuscombe 8E · Mitchellville, MDSep 7, 1976 · N1205K · Substantial damage NTSB IAD76FIG24Accident · Serious injuriesClosedSoneria 1 · Frederick, MDAug 22, 1976 · N131RA · Substantial damage