Fatal NTSB investigations: Douglas DC-9-31

11 cases on aircraft the registry lists as Douglas DC-9-31. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Fatal NTSB investigations: Douglas DC-9-31 per year, 1969–2026: 11 cases
1969	1
1970	2
1971	2
1972	1
1973	1
1974	1
1983	1
1990	1
2000	1

Where

Open the map

Latest cases

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065'))
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 FTW01RA006Accident · 4 fatalForeign investigationDouglas DC-9-31 · Reynosa, MexicoOct 6, 2000 · N936ML NTSB MIA91LA005Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-31 · Cape Canaveral, FLFailure of the captain to follow procedures, his improper in-flight planning/decision by allowing the aircraft to continue into the overhang (anvil) of a thunderstorm, failure of the passengers to abide by procedures/instructions concerning use of seat belts,…Oct 4, 1990 · N8923E · No damage NTSB DCA84AA012Accident · 1 fatalFinal reportDouglas DC-9-31 · Sioux Falls, SDDuring landing the crew acquired visual reference with the ground & apch lights about 200 ft AGL, followed by visual sighting of the rwy. Since the ATIS reported blowing snow, the crew expected to see, & was not surprised to see, snow blowing across the rwy…Dec 20, 1983 · N994Z · Substantial damage NTSB DCA75AZ009Accident · 71 fatalClosedDouglas DC9-31 · Charlotte, NCSep 11, 1974 · N8984E · Destroyed NTSB DCA74AZ004Accident · 88 fatalClosedDouglas DC-9 · Boston, MAJul 31, 1973 · N975NE · Destroyed NTSB DCA73AZ004Accident · 10 fatalClosedConvair 880 · Chicago, ILDec 20, 1972 · N8807E · 2 aircraft · Substantial damage NTSB NYC72AN074Accident · 2 fatalClosedCessna 206 · Raleigh, NCDec 4, 1971 · N2110F · 2 aircraft · Destroyed NTSB DCA71A0010Accident · 50 fatalClosedDouglas DC-9 · Duarte, CAJun 6, 1971 · N9345 · 2 aircraft · Destroyed NTSB DCA71AZ005Accident · 75 fatalClosedDouglas DC-9 · Huntington, WVNov 14, 1970 · N97S · Destroyed NTSB NYC70IN101Incident · 1 fatalClosedDouglas DC-9 · Boston, MAMar 17, 1970 · N8925E · No damage NTSB DCA70A0004Accident · 83 fatalClosedPiper PA-28 · Fairland, INSep 9, 1969 · N7374J · 2 aircraft · Destroyed