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 DIA69D0188Accident · No injuriesClosedPiper PA-28 · Chestertown, MDApr 25, 1969 · N8976W · Substantial damage NTSB DIA69I0058Incident · No injuriesClosedDornier DO-28D · Baltimore, MDApr 23, 1969 · N6012C · Minor damage NTSB DIA69I0057Incident · No injuriesClosedBoeing 707 · Baltimore, MDApr 22, 1969 · N706PA · No damage NTSB IAD69D0179Accident · No injuriesClosedPiper PA-28R · Accokeek, MDApr 19, 1969 · N3975T · Substantial damage NTSB DIA69D0178Accident · No injuriesClosedPiper PA-28 · Clinton, MDApr 19, 1969 · N6077W · Substantial damage NTSB DIA69F0180Accident · Serious injuriesClosedCessna 140 · Ocean City, MDApr 13, 1969 · N2179V · Substantial damage NTSB DIA69F0174Accident · No injuriesClosedPiper PA-28 · Rock Hall, MDApr 9, 1969 · N5113G · Substantial damage NTSB DIA69F0181Accident · No injuriesClosedPiper PA-22 · Westminster, MDApr 7, 1969 · N4522Z · Substantial damage NTSB DIA69F0170Accident · Minor injuriesClosedPiper PA-28 · Bower, MDApr 1, 1969 · N8564W · Substantial damage NTSB DIA69I0052Incident · No injuriesClosedLear Jet 23 · Hagerstown, MDMar 31, 1969 · N430JA · No damage NTSB DIA69F0168Accident · No injuriesClosedBrantly B-2 · Aberdeen, MDMar 30, 1969 · N2114U · Destroyed NTSB DIA69F0175Accident · Minor injuriesClosedCessna 172F · Gaithersburg, MDMar 24, 1969 · N7954U · Destroyed NTSB DIA69F0164Accident · No injuriesClosedAeronca 11AC · Frederick, MDMar 23, 1969 · N9636E · Destroyed NTSB DIA69D0163Accident · No injuriesClosedPiper PA-18 · Edgewood, MDMar 23, 1969 · N10468 · Substantial damage NTSB DIA69F0161Accident · No injuriesClosedPiper J3C-65 · Edgewater, MDMar 22, 1969 · N98224 · Destroyed NTSB DIA69F0166Accident · Minor injuriesClosedTaylorcraft BC12-D · Libertytown, MDMar 16, 1969 · N96520 · Destroyed NTSB DIA69D0159Accident · No injuriesClosedMooney MK-20E · Beltsville, MDMar 16, 1969 · N4030N · Substantial damage NTSB DIA69I0047Incident · No injuriesClosedDornier DO-28D · Baltimore, MDMar 3, 1969 · N3180 · Minor damage NTSB DIA69F0154Accident · No injuriesClosedPiper PA-23 · Gaithersburg, MDMar 1, 1969 · N4622P · Substantial damage NTSB DIA69F0147Accident · No injuriesClosedPiper PA-28 · Laurel, MDFeb 25, 1969 · N9611J · Substantial damage NTSB DIA69D0156Accident · No injuriesClosedCessna 150 · Clinton, MDFeb 15, 1969 · N51099 · Substantial damage NTSB DIA69D0138Accident · No injuriesClosedCessna 175A · White Marsh, MDFeb 3, 1969 · N6919E · Substantial damage NTSB DIA69A0039Accident · 1 fatalClosedCessna 150 · Flintstone, MDFeb 2, 1969 · N7244X · Destroyed NTSB DIA69D0133Accident · No injuriesClosedPiper PA-22 · Clinton, MDJan 26, 1969 · N3516Z · Substantial damage NTSB DIA69F0137Accident · Minor injuriesClosedPiper PA-18 · Fort Meade, MDJan 18, 1969 · N1005A · Substantial damage NTSB DIA69F0128Accident · No injuriesClosedHelio H-391B · Cumberland, MDJan 7, 1969 · N12620 · Substantial damage NTSB DIA69D0127Accident · No injuriesClosedPiper PA-22 · Frederick, MDJan 4, 1969 · N3343A · Substantial damage NTSB DIA69D0120Accident · No injuriesClosedPiper PA-30 · Friendship, MDDec 21, 1968 · N8017Y · Destroyed NTSB DIA69D0125Accident · No injuriesClosedAero Comdr 100 · White Marsh, MDNov 29, 1968 · N3742X · Substantial damage NTSB DIA69D0114Accident · No injuriesClosedCessna 150 · Brookeville, MDNov 28, 1968 · N3029J · Substantial damage NTSB DIA69F0112Accident · No injuriesClosedAeronca 7EC · Gaithersburg, MDNov 16, 1968 · N1292H · Substantial damage NTSB DIA69D0100Accident · Minor injuriesClosedPiper PA-28 · Chester, MDNov 1, 1968 · N6543W · Substantial damage NTSB DIA69I0023Incident · No injuriesClosedBoeing 727 · Baltimore, MDOct 24, 1968 · N4616 · No damage NTSB DIA69D0089Accident · No injuriesClosedBeech A23 · Piney Point, MDOct 23, 1968 · N2379Z · Substantial damage NTSB DIA69F0090Accident · No injuriesClosedPiper PA-28 · Linthicum, MDOct 13, 1968 · N6274W · Destroyed NTSB DIA69A0019Accident · 2 fatalClosedPiper PA-28 · Blu Rdge Summt, MDOct 10, 1968 · N4561J · Destroyed NTSB DIA69F0099Accident · No injuriesClosedBeech 65-80 · Friendship, MDOct 8, 1968 · N51025 · Substantial damage NTSB DIA69F0085Accident · No injuriesClosedPiper PA-22 · Cumberland, MDSep 29, 1968 · N8816D · Substantial damage NTSB DIA69D0070Accident · No injuriesClosedCessna 182 · Harmony Hall, MDSep 19, 1968 · N3078F · Destroyed NTSB DIA69D0078Accident · No injuriesClosedBell 47G · Gaithersburg, MDSep 18, 1968 · N616X · Substantial damage NTSB DIA69F0071Accident · No injuriesClosedNavion L-17A · Edgewood, MDSep 15, 1968 · N333P · Destroyed NTSB DIA69A0013Accident · 1 fatalClosedMooney M20E · White Marsh, MDSep 11, 1968 · N79852 · Destroyed NTSB DIA69F0061Accident · No injuriesClosedMooney M20C · Mitchellville, MDSep 2, 1968 · N5808Q · Destroyed NTSB DIA69F0057Accident · No injuriesClosedMooney M21 · Mitchellville, MDSep 2, 1968 · N3360X · Substantial damage NTSB DIA69A0010Accident · 2 fatalClosedCessna 172C · Rock Hall, MDAug 23, 1968 · N1505Y · Destroyed NTSB DIA69A0009Accident · No injuriesClosedBeech C-45G · Cambridge, MDAug 23, 1968 · N115V · Substantial damage NTSB DIA69D0045Accident · No injuriesClosedPiper PA-28 · Mitchellville, MDAug 14, 1968 · N5772W · Substantial damage NTSB DIA69F0059Accident · No injuriesClosedBeech 35-B33 · Ocean City, MDJul 30, 1968 · N1782G · Substantial damage NTSB DIA69F0028Accident · Serious injuriesClosedCessna 150 · Oxon Hill, MDJul 15, 1968 · N4172U · Destroyed NTSB DIA69D0025Accident · No injuriesClosedPiper PA-24 · Ocean City, MDJul 8, 1968 · N8687P · Substantial damage