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 IAD76AI089Accident · 1 fatalClosedBellanca 7GCBC · Ocean City, MDAug 6, 1976 · N11863 · Destroyed NTSB IAD76FIG23Accident · No injuriesClosedCessna 172M · Stevensville, MDAug 4, 1976 · N20594 · Substantial damage NTSB IAD76FIA13Accident · No injuriesClosedCessna 180 · Clinton, MDJul 28, 1976 · N19TW · Substantial damage NTSB IAD76FIG22Accident · No injuriesClosedLuscombe 8E · Mchenry, MDJul 11, 1976 · N1737K · Substantial damage NTSB IAD76FIG21Accident · No injuriesClosedBeech C35 · Annapolis, MDJul 11, 1976 · N652D · Substantial damage NTSB IAD76FIG20Accident · No injuriesClosedPiper PA-28 · Baltimore, MDJul 3, 1976 · N33859 · Substantial damage NTSB IAD76FIG19Accident · Minor injuriesClosedCessna 172 · Laurel, MDJun 26, 1976 · N6315E · Substantial damage NTSB IAD76DIG17Accident · No injuriesClosedAeronca 7CCM · Cumberland, MDJun 8, 1976 · N4635E · Substantial damage NTSB IAD76FIG16Accident · Minor injuriesClosedHughes 269B · Gaithersburgh, MDMay 31, 1976 · N9397F · Substantial damage NTSB IAD76FIG18Accident · No injuriesClosedFourney 415-D · Pasadena, MDMay 22, 1976 · N71D · Substantial damage NTSB IAD76FIG14Accident · No injuriesClosedGrumman G-164A · Downsville, MDApr 24, 1976 · N9828 · Substantial damage NTSB IAD76FIG15Accident · No injuriesClosedGrum Amer AA1-B · College Park, MDApr 23, 1976 · N9859L · Substantial damage NTSB IAD76FIA09Accident · No injuriesClosedCessna 177 · Clinton, MDMar 27, 1976 · N30198 · Substantial damage NTSB IAD76FIG13Accident · Serious injuriesClosedPiper J3C-65 · Mt Airy, MDMar 26, 1976 · N51537 · Destroyed NTSB IAD76FIG12Accident · No injuriesClosedPiper PA-28 · White Marsh, MDMar 12, 1976 · N5731U · Substantial damage NTSB IAD76AI062Accident · 1 fatalClosedCessna 172L · Accident, MDMar 12, 1976 · N4368Q · Substantial damage NTSB IAD76FIA06Accident · 1 fatalClosedSmith Mini · Lexington Park, MDMar 4, 1976 · N10G · Destroyed NTSB IAD76FIG11Accident · No injuriesClosedBellanca 7ECA · Fort Meade, MDFeb 28, 1976 · N36174 · Substantial damage NTSB IAD76FIA10Accident · Minor injuriesClosedCessna 150M · College Park, MDFeb 15, 1976 · N2978V · Substantial damage NTSB IAD76FIG09Accident · No injuriesClosedPiper PA-22 · College Park, MDFeb 8, 1976 · N3944P · Destroyed NTSB IAD76AI054Accident · 3 fatalClosedMitsubishi MU-2B · Easton, MDFeb 8, 1976 · N300MA · Destroyed NTSB IAD76FIA05Accident · No injuriesClosedCessna 177 · Clinton, MDJan 29, 1976 · N3430T · Substantial damage NTSB IAD76FIG08Accident · Minor injuriesClosedCessna 150 · Baltimore, MDJan 28, 1976 · N60489 · Substantial damage NTSB IAD76AI050Accident · 2 fatalClosedBeech D95A · Gaithersburg, MDJan 17, 1976 · N9388Y · Destroyed NTSB IAD76AI047Accident · 1 fatalClosedSikorsky S-55 · California, MDJan 9, 1976 · N3498 · Substantial damage NTSB IAD76II042Incident · No injuriesClosedDouglas DC-3C · Baltimore, MDDec 18, 1975 · N18255 · Minor damage NTSB IAD76FIA07Accident · Serious injuriesClosedCessna 182F · Cove Point, MDDec 15, 1975 · N3415U · Substantial damage NTSB IAD76FIG07Accident · Minor injuriesClosedStinson 108 · Davidsonville, MDNov 29, 1975 · N9520K · Substantial damage NTSB IAD76FIG06Accident · Minor injuriesClosedPiper PA-28 · Laurel, MDNov 20, 1975 · N32120 · Substantial damage NTSB IAD76FIG03Accident · No injuriesClosedPiper PA-28 · Frostburg, MDSep 26, 1975 · N9020W · Substantial damage NTSB IAD76DIA04Accident · Minor injuriesClosedHughes 369 · Mechanicsville, MDSep 19, 1975 · N9056F · Substantial damage NTSB IAD76FIA02Accident · Serious injuriesClosedAeronca SO-58B · Laplata, MDSep 2, 1975 · N46673 · Substantial damage NTSB IAD76FIG04Accident · Minor injuriesClosedKinner B-1 · Kysers Ridge, MDSep 1, 1975 · N727W · Substantial damage NTSB IAD76AI013Accident · 1 fatalClosedFairchild M62A · Accident, MDSep 1, 1975 · N1777 · Destroyed NTSB IAD76II010Incident · No injuriesClosedPiper PA-31 · Baltimore, MDAug 27, 1975 · N66873 · No damage NTSB IAD76FIG02Accident · Minor injuriesClosedCessna 150 · Rising Sun, MDJul 27, 1975 · N3614V · Destroyed NTSB IAD76FIG01Accident · Minor injuriesClosedCessna 172 · Pasadena, MDJul 18, 1975 · N64429 · Substantial damage NTSB IAD75FIG23Accident · Minor injuriesClosedPiper PA-22 · Bel Air, MDJun 29, 1975 · N3612P · Substantial damage NTSB IAD75DIG22Accident · Minor injuriesClosedPiper PA-22 · Swanton, MDJun 22, 1975 · N3460Z · Substantial damage NTSB IAD75FIG21Accident · Minor injuriesClosedChampion 7ECA · Lantz, MDJun 7, 1975 · N11049 · Destroyed NTSB IAD75DIA23Accident · Minor injuriesClosedCessna 150J · Clinton, MDJun 3, 1975 · N51099 · Substantial damage NTSB IAD75FIG19Accident · 1 fatalClosedB-Mustang Midget · Edgemere, MDJun 2, 1975 · N245 · Destroyed NTSB IAD75AI058Accident · 1 fatalClosedBeech E18S · Salisbury, MDMay 15, 1975 · N23XY · Destroyed NTSB IAD75FIG20Accident · No injuriesClosedFleet 7 · Gaithersburg, MDMay 11, 1975 · N9433 · Substantial damage NTSB IAD75DIA22Accident · No injuriesClosedPiper PA-28 · Friendly, MDMay 10, 1975 · N9024J · Substantial damage NTSB IAD75AIG18Accident · No injuriesClosedGrum Amer AA1-B · Stevensville, MDApr 27, 1975 · N6429L · Substantial damage NTSB IAD75FIG17Accident · Minor injuriesClosedCessna 180 · Laurel, MDApr 20, 1975 · N7689A · Destroyed NTSB IAD75DIA19Accident · No injuriesClosedBell 47G4 · Bowie, MDApr 18, 1975 · N420MC · Substantial damage NTSB IAD75AIG16Accident · No injuriesClosedCessna 172 · Easton, MDApr 4, 1975 · N20353 · Substantial damage NTSB IAD75FIA18Accident · Serious injuriesClosedBellanca 1731TC · Waldorf, MDMar 23, 1975 · N7330V · Substantial damage