NTSB investigations: Douglas DC-9-31

5 cases on aircraft the registry lists as Douglas DC-9-31, where the first occurrence was “In flight encounter with weather”. 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

19842026

NTSB investigations: Douglas DC-9-31 per year, 1984–2026: 5 cases
1984	2
1986	1
1990	1
1991	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 CHI91IA175Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-32 · Kansas City, MOInadequate design by the manufacturers. Factors associated with the incident are inadequate certification/approval by the federal aviation administration and clear air turbulence.May 29, 1991 · N933ML · No damage 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 ATL86LA202Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Montgomery, ALDuring flt, the acft encountered turbulence (turbc) while flying in the vicinity of a thunderstorm (tstm). During the occurrence, a flt attendant, who was serving beverages, sustained a fractured lumbar vertebrae. Radar data revealed the acft was about 4 mi…Jul 21, 1986 · N9332 · Minor damage NTSB ATL84LA235Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-31 · Augusta, GADuring a turbulence encounter a pax standing in the rear of the cabin fell and suffered a fractured leg. The seat belt sign was illuminated for the entire flt. At the direction of the capt, in-flt service by the flt attendants was terminated. The injured pax…Jul 25, 1984 · N8978E · No damage NTSB DCA84AA028Accident · Minor injuriesFinal reportMcdonnell Douglas DC-9-31 · Detroit, MIDuring arrival, the aircrew (visually & by use of wx radar) noted thunderstorms (tstms) west & southwest of the arpt. The crew elected to continue & make an ILS apch. At 1636, a spcl wx obsn had tstm info, but was not noted. At 1650, the vis dropped to 1/4 mi…Jun 13, 1984 · N964VJ · Substantial damage