Skip to content

NTSB investigations, MD

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 IAD79FIG11Accident · Minor injuriesClosedPiper J5A · Taneytown, MDJul 31, 1979 · N33415 · Substantial damage NTSB IAD79FI610Accident · No injuriesClosedBellanca 7GCBC · Ocean City, MDJul 17, 1979 · N11718 · Substantial damage NTSB IAD79FIG09Accident · Serious injuriesClosedPiper PA-23 · Baltimore, MDJul 15, 1979 · N555WP · Destroyed NTSB IAD79FIG08Accident · No injuriesClosedCessna 177 · Westminster, MDJun 20, 1979 · N29400 · Substantial damage NTSB IAD79DIA13Accident · Minor injuriesClosedPiper J-3 · Naylor, MDJun 16, 1979 · N1500N · Substantial damage NTSB IAD79FIG07Accident · No injuriesClosedPiper PA-22 · College Park, MDJun 1, 1979 · N3618Z · Substantial damage NTSB IAD79FIG06Accident · Minor injuriesClosedPiper PA-28 · Oakland, MDMay 10, 1979 · N56112 · Substantial damage NTSB IAD79FIA12Accident · Minor injuriesClosedPiper PA-28 · Pomonkey, MDMay 6, 1979 · N6583W · Destroyed NTSB IAD79FIG05Accident · No injuriesClosedLake LA4200 · Dayton, MDApr 11, 1979 · N6158Y · Substantial damage NTSB IAD79FIA09Accident · No injuriesClosedCessna 170B · Clinton, MDMar 17, 1979 · N2735D · Substantial damage NTSB IAD79FA038Accident · 1 fatalClosedBellanca 8KCAB · Queenstown, MDMar 7, 1979 · N31278 · Destroyed NTSB IAD79FA033Accident · 3 fatalClosedPiper PA-31T · Baltimore, MDFeb 23, 1979 · N6123A · Destroyed NTSB IAD79IA031Incident · No injuriesClosedShorts SD3-30 · Baltimore, MDFeb 13, 1979 · N796HA · Minor damage NTSB IAD79FIG03Accident · No injuriesClosedPiper PA-28 · Laurel, MDDec 22, 1978 · N4472X · Substantial damage NTSB IAD79FA011Accident · 4 fatalClosedPiper PA-24 · Bowie, MDNov 16, 1978 · N6147P · Destroyed NTSB IAD79FIG02Accident · Serious injuriesClosedCessna 150 · Elkton, MDNov 15, 1978 · N9462U · Destroyed NTSB IAD79FIA02Accident · Serious injuriesClosedPiper PA-28R · Morganza, MDOct 15, 1978 · N1235T · Substantial damage NTSB IAD79FIG01Accident · No injuriesClosedCessna 150 · Fort Meade, MDOct 9, 1978 · N3481V · Substantial damage NTSB IAD79DA007Accident · No injuriesClosedSchemp Hirt Cirrus · Cresaptown, MDOct 8, 1978 · CF-QJH · Substantial damage NTSB IAD78FIA19Accident · 1 fatalClosedPiper PA-28 · Indian Head, MDSep 23, 1978 · N5179F · Destroyed NTSB IAD78FA106Accident · No injuriesClosedHughes 269B · Damascus, MDSep 4, 1978 · N9568F · Destroyed NTSB IAD78FIA15Accident · No injuriesClosedBoeing A75 · Lower Marlboro, MDAug 15, 1978 · N1967M · Substantial damage NTSB IAD78FA092Accident · 1 fatalClosedPiper J-3 · White Marsh, MDAug 10, 1978 · N51537 · Destroyed NTSB IAD78FA090Accident · 1 fatalClosedPiper PA-22 · Westminister, MDAug 9, 1978 · N2851Z · Destroyed NTSB IAD78FIG15Accident · Serious injuriesClosedUnited Cons UC-1 · Edgewater, MDAug 8, 1978 · N250MP · Destroyed NTSB IAD78FIG14Accident · Serious injuriesClosedPiper J3C · Westport, MDJul 23, 1978 · N42442 · Substantial damage NTSB IAD78FIG13Accident · No injuriesClosedPiper PA-18 · Gaithersburg, MDJul 20, 1978 · N283T · Substantial damage NTSB IAD78IA080Incident · No injuriesClosedPiper PA-31 · Baltimore, MDJul 13, 1978 · N66892 · Minor damage NTSB IAD78FIG12Accident · Minor injuriesClosedCessna 172 · Largo, MDJul 9, 1978 · N738RB · Substantial damage NTSB IAD78FIA12Accident · No injuriesClosedCessna 172 · Andrews Afb, MDJun 27, 1978 · N5164F · Substantial damage NTSB IAD78FIG10Accident · Serious injuriesClosedChampion 7KCAB · Oakland, MDJun 25, 1978 · N1859G · Substantial damage NTSB IAD78FIG09Accident · No injuriesClosedBeech B23 · Gaithersburg, MDMay 26, 1978 · N2321 · Substantial damage NTSB IAD78FIG08Accident · Minor injuriesClosedDehavilland DH82C · Cumberland, MDMay 25, 1978 · N18840 · Substantial damage NTSB IAD78FIG07Accident · Minor injuriesClosedCessna 150 · Rising Sun, MDMay 2, 1978 · N23427 · Substantial damage NTSB IAD78FA060Accident · Serious injuriesClosedPiper PA-28R · California, MDApr 19, 1978 · N4448X · Destroyed NTSB IAD78FA056Accident · 5 fatalClosedAero Comdr 500B · Salisbury, MDMar 31, 1978 · N313UT · Destroyed NTSB IAD78FIG06Accident · No injuriesClosedCessna 150J · College Park, MDMar 25, 1978 · N60245 · Substantial damage NTSB IAD78FA045Accident · 1 fatalClosedPiper PA-32 · Myersville, MDFeb 27, 1978 · N40012 · Destroyed NTSB IAD78FIG05Accident · Serious injuriesClosedGrumman AA1-B · Salisbury, MDFeb 12, 1978 · N8970L · Destroyed NTSB IAD78IA039Incident · Minor injuriesClosedBeech 100 · Baltimore, MDFeb 9, 1978 · N212Q · Minor damage NTSB IAD78FIA03Accident · Minor injuriesClosedCessna 182N · Friendly, MDFeb 4, 1978 · N9061G · Substantial damage NTSB IAD78DA042Accident · 1 fatalClosedStinson 108 · Ocean City, MDJan 27, 1978 · N8980K · Destroyed NTSB IAD78FA035Accident · Serious injuriesClosedPiper PA-32R · Laurel, MDJan 22, 1978 · N5420F · Destroyed NTSB IAD78FA034Accident · No injuriesClosedMitsubishi MU2-J · Cumberland, MDJan 17, 1978 · N44KS · Substantial damage NTSB IAD78DIG04Accident · No injuriesClosedCessna 182 · Hempstead, MDDec 23, 1977 · C-FUFE · Substantial damage NTSB IAD78FA019Accident · 2 fatalClosedVarga 2150A · Jessup, MDDec 5, 1977 · N4612V · Destroyed NTSB IAD78FIG03Accident · Minor injuriesClosedCessna 195B · Elkton, MDDec 4, 1977 · N4472C · Substantial damage NTSB IAD78FA011Accident · 2 fatalClosedPiper PA-32 · Emmitsburg, MDNov 7, 1977 · N3347W · Destroyed NTSB IAD78FIG02Accident · No injuriesClosedCessna 210 · Edgewater, MDNov 1, 1977 · N7429E · Substantial damage NTSB IAD78FIG01Accident · Minor injuriesClosedPiper PA28 · Baltimore, MDOct 10, 1977 · N5310T · Destroyed