NTSB investigations: Mcdonnell Douglas DC-9-82(MD-82), CO

8 cases on aircraft the registry lists as Mcdonnell Douglas DC-9-82(MD-82). 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

19872026

NTSB investigations: Mcdonnell Douglas DC-9-82(MD-82), CO per year, 1987–2026: 8 cases
1987	1
1992	1
1993	2
1994	1
2004	1
2005	1
2006	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."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022082')) 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\" = 'CO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022082'))
  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" = 'CO' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022082'))
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 DEN06IA051Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe captain's failure to follow existing company procedures for stabilized approach. **This report was modified on May 23, 2007.**Mar 21, 2006 · N574AA · Minor damage NTSB DEN05IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe reason for the occurrence was not determined.May 28, 2005 · N911TW · Minor damage NTSB DEN05IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe first officer's failure to maintain proper glide slope during the landing approach, and the captain's failure to adequately monitor the approach and landing, and his failure to challenge and/or intervene when the first officer continued to descend below…Nov 21, 2004 · N234AA · Minor damage NTSB FTW94IA227Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Denver, COFailure of the right main landing gear torque link assembly and shimmy dampener for unknown reasons.Jul 8, 1994 · N83873 · Minor damage NTSB DEN93FA049Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COA vibration in the right main landing gear, for undetermined reasons, which resulted in collapse of the right main gear. A factor was failure of the pilot in command to ensure deployment of the ground spoilers.Apr 27, 1993 · N72822 · Substantial damage NTSB DEN93FA047Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inflight encounterwith a microburst at an altitude insufficient to effect recovery.Apr 26, 1993 · N14816 · Substantial damage NTSB DEN93IA005Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inadvertent attempt, by unknown persons, to start the APU which had been placarded as inoperative. Factors were: inadequate procedures in rendering the APU incapable of being started when inoperative.Oct 13, 1992 · N72822 · Minor damage NTSB DEN88IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Denver, CODuring landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of…Dec 27, 1987 · N72830 · Minor damage