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 IAD74AI017Accident · 2 fatalClosedBell 206A · Beltsville, MDSep 18, 1973 · N6294N · Destroyed NTSB IAD74FIG08Accident · Serious injuriesClosedLake 4-200 · Betterton, MDSep 2, 1973 · N39365 · Destroyed NTSB IAD74AI012Accident · Serious injuriesClosedBritish AC 1-11 · Baltimore, MDAug 15, 1973 · N136J · No damage NTSB IAD74FIG07Accident · No injuriesClosedPiper PA-24 · Edgewater, MDAug 13, 1973 · N9209P · Substantial damage NTSB IAD74AI010Accident · No injuriesClosedPiper PA-28R · Churchville, MDAug 13, 1973 · N56086 · 2 aircraft · Substantial damage NTSB IAD74FIA02Accident · No injuriesClosedPiper PA-22 · Brandywine, MDAug 11, 1973 · N3939P · Substantial damage NTSB IAD74FIA03Accident · No injuriesClosedPiper PA-28 · Newburg, MDAug 10, 1973 · N9096J · Substantial damage NTSB IAD74II009Incident · No injuriesClosedBeech D95A · Sparks, MDAug 8, 1973 · N6141V · 2 aircraft · Minor damage NTSB IAD74FIG06Accident · Minor injuriesClosedBell 47G-5 · Berlin, MDAug 4, 1973 · N1468W · Substantial damage NTSB IAD74FIG04Accident · Minor injuriesClosedCessna 150K · Edgewater, MDJul 27, 1973 · N6476G · Substantial damage NTSB IAD74FIG03Accident · Serious injuriesClosedPiper PA-28 · Middletown, MDJul 14, 1973 · N8333R · Substantial damage NTSB IAD74FIG02Accident · No injuriesClosedBrewster FLEET7 · Gaithersburg, MDJul 14, 1973 · N9433 · Substantial damage NTSB IAD74AI003Accident · No injuriesClosedLuscombe 8E · Pasadena, MDJul 8, 1973 · N1800K · 2 aircraft · Minor damage NTSB IAD74FIG01Accident · Minor injuriesClosedAmer Avco AA1 · Stevensville, MDJul 4, 1973 · N5787L · Substantial damage NTSB IAD73AI019Accident · Serious injuriesClosedPiper PA-30B · Cordova, MDJun 26, 1973 · N8005Y · Destroyed NTSB IAD73DIG28Accident · Minor injuriesClosedPiper PA-24 · Westminster, MDJun 15, 1973 · N8385P · Substantial damage NTSB IAD73FIG27Accident · No injuriesClosedPiper PA-24 · Baltimore, MDJun 4, 1973 · N8975P · Substantial damage NTSB IAD73FIA15Accident · No injuriesClosedFleet 2 · Huntington, MDMay 12, 1973 · N678M · Substantial damage NTSB IAD73FIG25Accident · No injuriesClosedCessna 172A · Essex, MDMay 6, 1973 · N7706T · Substantial damage NTSB IAD73FIG24Accident · No injuriesClosedCessna 195 · Federalsburg, MDApr 25, 1973 · N1593D · Substantial damage NTSB IAD73AI014Accident · 1 fatalClosedPiper PA-23 · Cumberland, MDApr 24, 1973 · N5557Y · Destroyed NTSB IAD73FIG22Accident · No injuriesClosedCessna 182P · Laurel, MDApr 11, 1973 · N79459 · Substantial damage NTSB IAD73FIG23Accident · No injuriesClosedCessna 182M · Stevensville, MDApr 6, 1973 · N91604 · Substantial damage NTSB IAD73DIG21Accident · No injuriesClosedCessna 150K · Salisbury, MDMar 17, 1973 · N6093G · Substantial damage NTSB NYC73AN101Accident · Serious injuriesClosedPiper PA-22 · Edgewater, MDJan 13, 1973 · N5483Z · 2 aircraft · Destroyed NTSB NYC73IN099Incident · No injuriesClosedDouglas DC-9 · Baltimore, MDJan 8, 1973 · N1291L · Minor damage NTSB NYC73AN096Accident · 3 fatalClosedMooney M20F · Elkton, MDJan 4, 1973 · N9570M · Destroyed NTSB NYC73FIG19Accident · Minor injuriesClosedCessna 150K · College Park, MDDec 14, 1972 · N6434G · Substantial damage NTSB NYC73FIG18Accident · Minor injuriesClosedAero Comdr 112 · Stevensville, MDNov 18, 1972 · N1014J · Substantial damage NTSB NYC73ANO67Accident · 2 fatalClosedSwift GC-1B · Salisbury, MDNov 12, 1972 · N80658 · Destroyed NTSB NYC73AN056Accident · 2 fatalClosedBell 206A · Graysonville, MDOct 28, 1972 · N4069G · Destroyed NTSB NYC73F1A07Accident · No injuriesClosedCessna 150 · Clinton, MDOct 22, 1972 · N5354Q · Substantial damage NTSB NYC73DIA06Accident · No injuriesClosedPiper PA-18 · Lothian, MDSep 26, 1972 · N236T · Substantial damage NTSB NYC73FIG16Accident · Serious injuriesClosedCessna 182 · Williamsport, MDSep 16, 1972 · N6472A · Destroyed NTSB NYC73FIG14Accident · Minor injuriesClosedCessna 172 · Sharpsburg, MDSep 15, 1972 · N6923A · Substantial damage NTSB NYC73FIG15Accident · No injuriesClosedLake LA-4 · Rockville, MDSep 14, 1972 · N39375 · Substantial damage NTSB NYC73FIG13Accident · No injuriesClosedPiper PA-22 · White Marsh, MDSep 10, 1972 · N5612Z · Substantial damage NTSB NYC73FIG12Accident · Serious injuriesClosedBoeing A75 · Vienna, MDSep 6, 1972 · N55432 · Substantial damage NTSB NYC73FIG11Accident · Minor injuriesClosedCessna 150G · College Park, MDSep 1, 1972 · N2631J · Destroyed NTSB NYC73FIG10Accident · Minor injuriesClosedPiper PA-28 · White Marsh, MDAug 20, 1972 · N5719U · Substantial damage NTSB NYC73FIG09Accident · Minor injuriesClosedPiper J-2 · Pasadena, MDJul 25, 1972 · N19511 · Destroyed NTSB NYC73FIG07Accident · No injuriesClosedBeech A45 · Keymar, MDJul 23, 1972 · N12257 · Substantial damage NTSB NYC73FIG06Accident · Minor injuriesClosedBeech A23-19 · Edgewater, MDJul 16, 1972 · N4764J · Destroyed NTSB NYC73FIG08Accident · No injuriesClosedCessna 150K · Sparrows Point, MDJul 15, 1972 · N6442G · Substantial damage NTSB NYC73FIG05Accident · Serious injuriesClosedChampion 7GCAA · Ocean City, MDJul 12, 1972 · N5145T · Substantial damage NTSB NYC73FIG03Accident · Serious injuriesClosedCessna 177 · College Park, MDJul 9, 1972 · N30027 · Destroyed NTSB NYC73DIG02Accident · No injuriesClosedPiper PA-28 · Churchville, MDJul 4, 1972 · N8941J · Substantial damage NTSB NYC73FIG01Accident · No injuriesClosedCessna 180 · Ridgely, MDJul 2, 1972 · N1717C · Substantial damage NTSB NYC72AN168Accident · No injuriesClosedPiper PA-32 · Catonsville, MDJun 30, 1972 · N8900N · Substantial damage NTSB NYC72FIG27Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDJun 25, 1972 · N5439Q · Substantial damage