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 IAD75FIG15Accident · No injuriesClosedMooney M20E · White Marsh, MDMar 16, 1975 · N7743M · Substantial damage NTSB IAD75FIG13Accident · No injuriesClosedGrum Amer AA1-B · Stevensville, MDMar 1, 1975 · N6321L · Destroyed NTSB IAD75FIG14Accident · No injuriesClosedStinson 108-1 · Edgewater, MDFeb 22, 1975 · N8721K · Substantial damage NTSB IAD75FIG12Accident · No injuriesClosedPiper PA-28 · Bowie, MDFeb 16, 1975 · N5457S · Substantial damage NTSB IAD75DIA11Accident · Serious injuriesClosedCessna 182 · Clinton, MDJan 29, 1975 · N9336X · Substantial damage NTSB IAD75FIG11Accident · Serious injuriesClosedPiper PA-28 · Mitchellville, MDJan 12, 1975 · N9752W · Destroyed NTSB IAD75FIG10Accident · No injuriesClosedCessna 310 · Gaithersburg, MDJan 5, 1975 · N4145Q · Substantial damage NTSB IAD75AI037Accident · 2 fatalClosedPiper PA-32 · Laytonsville, MDDec 29, 1974 · N3840W · Substantial damage NTSB IAD75FIA01Accident · No injuriesClosedGrumman AA5 · California, MDDec 20, 1974 · N9516L · Destroyed NTSB IAD75FIA09Accident · No injuriesClosedCessna 150E · Clinton, MDNov 29, 1974 · N3518J · Substantial damage NTSB IAD75FIG09Accident · No injuriesClosedCessna 180 · Ridgely, MDNov 3, 1974 · N1717C · Substantial damage NTSB IAD75AI027Accident · 1 fatalClosedGlasflugel H301B · Fredrick, MDNov 3, 1974 · N301H · Destroyed NTSB IAD75FIG07Accident · Minor injuriesClosedPiper PA-18 · Emmitsburg, MDOct 23, 1974 · N10468 · Substantial damage NTSB IAD75FIG08Accident · No injuriesClosedCessna 310 · Easton, MDOct 18, 1974 · N157R · Destroyed NTSB IAD75II025Incident · No injuriesClosedPiper PA-34 · Ocean City, MDOct 16, 1974 · N15686 · Minor damage NTSB IAD75FIA04Accident · No injuriesClosedCessna 150 · Clinton, MDOct 1, 1974 · N6089G · Substantial damage NTSB IAD75FIG05Accident · No injuriesClosedMaule M-4C · Easton, MDSep 26, 1974 · N9845M · Substantial damage NTSB IAD75AI016Accident · No injuriesClosedCessna 172M · Indianhead, MDSep 26, 1974 · N20271 · 2 aircraft · Substantial damage NTSB IAD75F1A07Accident · No injuriesClosedPiper PA-28 · Churchton, MDSep 21, 1974 · N8764N · Substantial damage NTSB IAD75FIA06Accident · No injuriesClosedCessna 172B · Clinton, MDSep 8, 1974 · N6918X · Substantial damage NTSB IAD75FIG03Accident · 1 fatalClosedAmer Avco AA1-B · Laytonsville, MDAug 20, 1974 · N9946L · Substantial damage NTSB IAD75FIG02Accident · No injuriesClosedStinson 108-2 · Laurel, MDAug 15, 1974 · N9730K · Substantial damage NTSB IAD75FIG01Accident · No injuriesClosedBeech C18S · Ridgely, MDJul 2, 1974 · N334G · Substantial damage NTSB IAD74FIG31Accident · Minor injuriesClosedSmith Mini · Pasadena, MDJun 29, 1974 · N8426 · Substantial damage NTSB IAD74FIG29Accident · Minor injuriesClosedPiper PA-28 · Whitemarsh, MDJun 12, 1974 · N51175 · Substantial damage NTSB IAD74AI061Accident · 4 fatalClosedCessna 337 · Clinton, MDMay 24, 1974 · N6363F · Destroyed NTSB IAD74AI062Accident · No injuriesClosedPiper PA-23 · Cove Point, MDMay 22, 1974 · N40592 · Substantial damage NTSB IAD74FIG27Accident · Serious injuriesClosedAeronca 65-C · Rocks State Pk, MDMay 18, 1974 · N24277 · Substantial damage NTSB IAD74FIG30Accident · No injuriesClosedPiper PA-22 · Westminster, MDMay 17, 1974 · N5014Z · Substantial damage NTSB IAD74DIG26Accident · No injuriesClosedCessna 150 · Rhodesdale, MDMay 17, 1974 · N6364G · Substantial damage NTSB IAD74AI059Accident · 2 fatalClosedPiper PA-28 · Salisbury, MDMay 16, 1974 · N56624 · Destroyed NTSB IAD74FIG25Accident · Minor injuriesClosedCessna 150 · White Marsh, MDApr 26, 1974 · N6755G · Substantial damage NTSB IAD74FIG24Accident · No injuriesClosedCessna 182H · Stevensville, MDApr 21, 1974 · N2498X · Substantial damage NTSB IAD74FIG23Accident · No injuriesClosedAmer Avco AA1 · Stevensville, MDApr 21, 1974 · N1012G · Substantial damage NTSB IAD74FIG22Accident · No injuriesClosedBeech F35 · College Park, MDApr 21, 1974 · N3811B · Substantial damage NTSB IAD74DIG21Accident · No injuriesClosedCessna 172K · Oakland, MDApr 3, 1974 · N78149 · Substantial damage NTSB IAD74DIG20Accident · No injuriesClosedPiper PA-24 · Harrisonville, MDMar 23, 1974 · N7608P · Substantial damage NTSB IAD74FIA08Accident · No injuriesClosedPiper PA-28 · Clinton, MDMar 22, 1974 · N7126R · Substantial damage NTSB IAD74AI053Accident · 3 fatalClosedNavion B · Bowie, MDMar 17, 1974 · N5245K · Destroyed NTSB IAD74AI052Accident · 1 fatalClosedBellanca 17-31A · Upper Marlboro, MDMar 10, 1974 · N39824 · Destroyed NTSB IAD74AI046Accident · 1 fatalClosedPiper PA-28 · Mchenry, MDFeb 24, 1974 · N6010W · Destroyed NTSB IAD74DIG19Accident · No injuriesClosedHughes 269B · Gaithersburg, MDFeb 13, 1974 · N9397F · Substantial damage NTSB IAD74AI036Accident · 1 fatalClosedBeech D95A · Hagerstown, MDDec 27, 1973 · N8566M · Destroyed NTSB IAD74FIG18Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDDec 15, 1973 · N5663Z · Substantial damage NTSB IAD74FIG16Accident · Serious injuriesClosedCessna 150 · Laurel, MDDec 4, 1973 · N19327 · Substantial damage NTSB IAD74FIG15Accident · No injuriesClosedPiper PA-28 · Frederick, MDDec 2, 1973 · N9185W · Substantial damage NTSB IAD74FIG14Accident · 1 fatalClosedVolksplane VP-1 · Uniontown, MDNov 23, 1973 · N47244 · Substantial damage NTSB IAD74FIG13Accident · No injuriesClosedPiper PA-24 · Aldino, MDNov 13, 1973 · N6970P · Substantial damage NTSB IAD74FIG11Accident · No injuriesClosedCessna 337F · Preston, MDSep 25, 1973 · N8922M · Substantial damage NTSB IAD74FIG10Accident · No injuriesClosedPiper J-3 · College Park, MDSep 23, 1973 · N38004 · Substantial damage