Skip to content

NTSB investigations, MD

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 ATL81FIG10Accident · Minor injuriesClosedCessna R182 · Gaithersburg, MDMar 12, 1981 · N9854C · Substantial damage NTSB ATL81FIG09Accident · No injuriesClosedPiper PA-28 · Annapolis, MDMar 8, 1981 · N1548J · Substantial damage NTSB ATL81FIG08Accident · No injuriesClosedCessna 172 · Churchville, MDMar 7, 1981 · N739HM · Substantial damage NTSB ATL81FIG07Accident · Serious injuriesClosedBeech B24R · Frederick, MDFeb 15, 1981 · N825PJ · Destroyed NTSB ATL81FIG06Accident · No injuriesClosedCessna 310G · Mitchellville, MDFeb 9, 1981 · N8919Z · Destroyed NTSB ATL81FIG05Accident · Serious injuriesClosedPiper PA-28 · Edgewater, MDFeb 8, 1981 · N4495J · Substantial damage NTSB ATL81FIA02Accident · No injuriesClosedCessna 150 · Newburg, MDFeb 7, 1981 · N18668 · 2 aircraft · Substantial damage NTSB ATL81IA039Incident · No injuriesClosedPiper PA-31 · Baltimore, MDJan 28, 1981 · N400RA · 2 aircraft · Minor damage NTSB ATL81FIG04Accident · No injuriesClosedCessna 182M · Pocomoke City, MDJan 25, 1981 · N71637 · Substantial damage NTSB ATL81DA068Accident · No injuriesClosedPiper PA-28 · Gaithersburg, MDDec 18, 1980 · N4495X · Substantial damage NTSB ATL81FIA01Accident · No injuriesClosedBeech B19 · Indianhead, MDDec 17, 1980 · N1992L · Destroyed NTSB ATL81FA026Accident · 1 fatalClosedMooney M20J · New Carrollton, MDDec 10, 1980 · N3739H · Destroyed NTSB ATL81FIG03Accident · Serious injuriesClosedAeronca 65L · Pasadena, MDNov 8, 1980 · N29429 · Substantial damage NTSB ATL81FIG02Accident · Serious injuriesClosedAerosport Quail · Laytonsville, MDNov 8, 1980 · N8034H · Substantial damage NTSB ATL81FA005Accident · 3 fatalClosedBeech 35 · Dargan, MDOct 10, 1980 · N418F · Destroyed NTSB ATL81FIG01Accident · Minor injuriesClosedCessna 172N · College Park, MDOct 8, 1980 · N2812E · Substantial damage NTSB ATL80FIG18Accident · No injuriesClosedCessna 172 · Mitchellville, MDSep 1, 1980 · N737HC · Substantial damage NTSB ATL80FIG17Accident · Minor injuriesClosedNavion G · Chester, MDAug 31, 1980 · N2353T · Substantial damage NTSB ATL80FIG16Accident · No injuriesClosedPiper PA-28 · Elkton, MDAug 21, 1980 · N7251W · Substantial damage NTSB ATL80FIG15Accident · No injuriesClosedEnstrom 280C · Arbutus, MDAug 21, 1980 · N79ER · Substantial damage NTSB ATL80IA085Incident · No injuriesClosedSwearingen SA226 · Camp Springs, MDAug 15, 1980 · N255AV · Minor damage NTSB ATL80FIG14Accident · No injuriesClosedPiper PA-28R · Chester, MDAug 7, 1980 · N3994F · Substantial damage NTSB ATL80FIG13Accident · No injuriesClosedCessna 172M · Westminster, MDJul 25, 1980 · N9243H · Substantial damage NTSB ATL80FIG12Accident · No injuriesClosedPiper PA-12 · Edgewater, MDJun 29, 1980 · N3532M · Substantial damage NTSB ATL80FA061Accident · 2 fatalClosedBellanca 7GCBC · Worton, MDJun 25, 1980 · N2636Z · Destroyed NTSB ATL80FIG10Accident · Minor injuriesClosedBryan RS-15 · Fredrick, MDJun 1, 1980 · N29WB · Substantial damage NTSB ATL80FIA09Accident · No injuriesClosedCessna 150 · Clinton, MDMay 27, 1980 · N5368Q · Substantial damage NTSB ATL80FIG11Accident · No injuriesClosedCessna U206G · Woodbine, MDMay 25, 1980 · N7337C · Substantial damage NTSB IAD80FIG09Accident · No injuriesClosedCessna 172 · Mitchellville, MDApr 13, 1980 · N6944E · Substantial damage NTSB ATL80FIG08Accident · No injuriesClosedBeech B19 · Essex, MDApr 5, 1980 · N18871 · Substantial damage NTSB IAD80FA071Accident · 2 fatalClosedHughes 500 · Stephensville, MDMar 24, 1980 · N2769 · Destroyed NTSB IAD80FA024Accident · 1 fatalClosedPiper PA-22 · Clear Spring, MDFeb 18, 1980 · N7596D · Destroyed NTSB IAD80FIG05Accident · No injuriesClosedHughes 269C · Frederick, MDJan 28, 1980 · N9657F · Destroyed NTSB IAD80FA019Accident · Serious injuriesClosedAero Comdr 690 · Goldsboro, MDJan 15, 1980 · N182 · Destroyed NTSB IAD80DIG04Accident · No injuriesClosedSchleicher KA-7 · Lavale, MDDec 28, 1979 · N1047Z · Substantial damage NTSB IAD80FIG03Accident · No injuriesClosedPiper PA-28 · Edgewater, MDDec 12, 1979 · N8132R · Substantial damage NTSB IAD80FA012Accident · 1 fatalClosedBellanca 8KCAB · Churchton, MDNov 25, 1979 · N444HG · Destroyed NTSB IAD80FIG02Accident · No injuriesClosedPiper PA-28 · Grasonville, MDNov 18, 1979 · N2889G · Substantial damage NTSB IAD80FIG01Accident · Serious injuriesClosedBushby Mini Mustng · Stevensville, MDOct 21, 1979 · N3794 · Substantial damage NTSB IAD79FA086Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDSep 20, 1979 · N11593 · Substantial damage NTSB IAD79DA084Accident · No injuriesClosedPiper PA-18 · Stevensville, MDSep 18, 1979 · N7233K · Substantial damage NTSB IAD79FA083Accident · No injuriesClosedHughes 269B · Gaithersburg, MDSep 17, 1979 · N9482F · Substantial damage NTSB IAD79DA079Accident · No injuriesClosedGrumman AA1C · Mt Airy, MDSep 13, 1979 · N31NA · Destroyed NTSB IAD79FA078Accident · No injuriesClosedCessna 320F · Chestertown, MDSep 9, 1979 · N30CR · Substantial damage NTSB IAD79FA072Accident · No injuriesClosedCessna 182RG · Annapolis, MDAug 30, 1979 · N6014C · Substantial damage NTSB IAD79FA069Accident · 2 fatalClosedCessna 310K · Cresaptown, MDAug 20, 1979 · N7060L · Destroyed NTSB IAD79DA071Accident · No injuriesClosedCessna 150 · Oakland, MDAug 20, 1979 · N5344Q · Destroyed NTSB IAD79FIG13Accident · No injuriesClosedCessna 150 · Westminster, MDAug 15, 1979 · N7930U · Destroyed NTSB IAD79FIG12Accident · No injuriesClosedCessna 172 · Gaithersburg, MDAug 10, 1979 · N5660E · Substantial damage NTSB IAD79FIG14Accident · No injuriesClosedErco 415-D · Crofton Mews, MDAug 7, 1979 · N99291 · Substantial damage