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 NYC72FIG26Accident · Serious injuriesClosedPiper PA-32 · Oakland, MDMay 25, 1972 · N3930W · Substantial damage NTSB NYC72FIG23Accident · No injuriesClosedMaule M4220C · Keedysville, MDMay 17, 1972 · N2034U · Substantial damage NTSB NYC72FIG21Accident · No injuriesClosedCessna 182 · Gaithersburg, MDApr 23, 1972 · N3046F · Substantial damage NTSB NYC72FIG22Accident · No injuriesClosedCessna 150 · College Park, MDApr 21, 1972 · N2903S · Substantial damage NTSB NYC72AN119Accident · 1 fatalClosedPiper PA-28 · Laytonsville, MDMar 29, 1972 · N4353T · Destroyed NTSB NYC72AN115Accident · 1 fatalClosedCessna 150L · Stevensville, MDMar 18, 1972 · N1670Q · Destroyed NTSB NYC72IN112Incident · No injuriesClosedBeech 99 · Friendship Int, MDMar 16, 1972 · N296HA · No damage NTSB NYC72FIG20Accident · No injuriesClosedCessna 150 · Laurel, MDMar 12, 1972 · N6413G · Substantial damage NTSB NYC72AN107Accident · 2 fatalClosedPiper J-3 · College Park, MDMar 5, 1972 · N1399V · Destroyed NTSB NYC72FIG18Accident · No injuriesClosedCessna 172K · Westminster, MDFeb 27, 1972 · N7213G · Substantial damage NTSB NYC72AN088Accident · 2 fatalClosedCessna 172D · Perryville, MDJan 9, 1972 · N2551Y · Destroyed NTSB NYC72AN087Accident · 1 fatalClosedPiper PA-30 · Hanover, MDJan 4, 1972 · N8821Y · Destroyed NTSB NYC72FIA13Accident · No injuriesClosedBellanca 14-19 · Friendly, MDJan 1, 1972 · N522A · Substantial damage NTSB NYC72DIG17Accident · No injuriesClosedPiper PA-28 · Montgomery, MDDec 31, 1971 · N3978K · Substantial damage NTSB NYC72FIG16Accident · No injuriesClosedCessna 150J · Crownsville, MDDec 30, 1971 · N50534 · Substantial damage NTSB NYC72FIA10Accident · No injuriesClosedBeech A23-24 · Lexington Park, MDDec 20, 1971 · N5773V · Destroyed NTSB NYC72FIA09Accident · 2 fatalClosedLake LA-4A · Laplata, MDDec 12, 1971 · N1001L · Destroyed NTSB NYC72DIG15Accident · No injuriesClosedCessna 140 · Ocean City, MDDec 4, 1971 · N72619 · Substantial damage NTSB NYC72AN058Accident · 2 fatalClosedFairchild M-62A · Stevensville, MDOct 21, 1971 · N91022 · Destroyed NTSB NYC72FIG14Accident · Minor injuriesClosedGlobe GC-1B · Perry Hall, MDOct 16, 1971 · N80551 · Substantial damage NTSB NYC72AN041Accident · 3 fatalClosedCessna 337A · Boonsboro, MDSep 18, 1971 · N6333F · Destroyed NTSB NYC72DIA04Accident · No injuriesClosedChampion 7ECA · California, MDSep 11, 1971 · N5218X · Substantial damage NTSB NYC72FIG13Accident · Minor injuriesClosedMooney M20A · Mitchellville, MDSep 10, 1971 · N1082C · Substantial damage NTSB NYC72DIG12Accident · No injuriesClosedPiper PA-22 · Pasadena, MDSep 5, 1971 · N2240A · Substantial damage NTSB NYC72AN032Accident · 3 fatalClosedPiper PA-32 · Corriganville, MDSep 1, 1971 · N5225S · Destroyed NTSB NYC72AN030Accident · 3 fatalClosedPiper PA-28 · Accident, MDAug 27, 1971 · N6993W · Destroyed NTSB NYC72FIG10Accident · 1 fatalClosedDehavnd Can DHC-1B · Stevensville, MDAug 15, 1971 · N7749 · Destroyed NTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDAug 13, 1971 · N6273G · 2 aircraft · Minor damage NTSB NYC72FIG06Accident · No injuriesClosedBell 47D-1 · Union Bridge, MDAug 12, 1971 · N4253A · Destroyed NTSB NYC72FIG09Accident · No injuriesClosedPiper PA-23 · Westminster, MDAug 9, 1971 · N2106P · Substantial damage NTSB NYC72FIG08Accident · No injuriesClosedPiper PA-28 · White Marsh, MDAug 7, 1971 · N5719U · Substantial damage NTSB NYC72DIG07Accident · No injuriesClosedCessna 182 · Cambridge, MDJul 21, 1971 · N3706D · Substantial damage NTSB IAD72AI003Accident · 1 fatalClosedPiper PA-28 · St.Michaels, MDJul 20, 1971 · N5298L · Destroyed NTSB IAD72FIG05Accident · Serious injuriesClosedMooney M20G · College Park, MDJul 16, 1971 · N3593X · Destroyed NTSB IAD72DIG03Accident · No injuriesClosedCessna 150 · Finksburg, MDJul 5, 1971 · N4538U · Substantial damage NTSB IAD72FIG02Accident · Minor injuriesClosedHughes 269B · Bowie, MDJul 4, 1971 · N9424F · Substantial damage NTSB IAD72FIG01Accident · No injuriesClosedBell 206A · Rosedale, MDJul 3, 1971 · N2282W · Substantial damage NTSB IAD72FIG33Accident · No injuriesClosedPiper PA-22 · White Marsh, MDJun 30, 1971 · N7106B · Substantial damage NTSB IAD71FIG32Accident · No injuriesClosedBeech 35 · Golts, MDJun 20, 1971 · N3043V · Substantial damage NTSB IAD71DIA22Accident · No injuriesClosedCessna 170B · Cobb Island, MDJun 13, 1971 · N3483D · Substantial damage NTSB IAD71FIG31Accident · Serious injuriesClosedBeech B35 · Stevensville, MDMay 31, 1971 · N5142C · Destroyed NTSB MIA71IM101Incident · No injuriesClosedDouglas DC-9 · Baltimore, MDMay 21, 1971 · N8962E · Minor damage NTSB IAD71FIA21Accident · Minor injuriesClosedCessna 150 · Lusby, MDMay 15, 1971 · N6426F · Substantial damage NTSB IAD71II052Incident · No injuriesClosedBeech B55 · Easton, MDMay 13, 1971 · N7956R · Minor damage NTSB IAD71AI050Accident · 1 fatalClosedCessna 172H · Hollywood, MDMay 8, 1971 · N2658L · Destroyed NTSB IAD71DIG30Accident · No injuriesClosedPiper PA-28 · Westminster, MDApr 27, 1971 · N6756W · Substantial damage NTSB IAD71FIG28Accident · Minor injuriesClosedCessna 172K · Fallston, MDApr 25, 1971 · N7028G · Destroyed NTSB IAD71FIG27Accident · Minor injuriesClosedPiper J3L-65 · Edgewater, MDApr 9, 1971 · N23Q · Substantial damage NTSB IAD71FIG29Accident · No injuriesClosedPiper PA-28 · White Marsh, MDApr 3, 1971 · N6692J · Substantial damage NTSB IAD71FIG26Accident · Serious injuriesClosedCessna 172 · College Park, MDMar 28, 1971 · N3704R · Substantial damage