NTSB investigations: Mcdonnell Douglas DC-9-32
8 cases on aircraft the registry lists as Mcdonnell Douglas DC-9-32. 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.
Cases per year
| 1979 | 1 |
|---|---|
| 1983 | 2 |
| 1989 | 1 |
| 2000 | 2 |
| 2002 | 2 |
Where
Open the mapLatest cases
Query with SQL
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 ('302206C'))
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 ('302206C'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI02FA289Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-32 · Minneapolis, MNThe fatigue failure of the main landing gear strut due to inclusions in the material, residual stresses, and dissolved hydrogen content.NTSB NYC02LA056Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-32 · Dulles, VAThe lack of direction from the operator on how to perform pushbacks on an icy ramp, which led to the tug driver positioning the tug at an angle to the nose of the airplane that allowed the airplane to move forward and strike the tug. Factors were the…NTSB DCA00MA079Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9-32 · Greensboro, NCA phase-to-phase arc in the left heat exchanger cooling fan relay, which ignited the surrounding wire insulation and other combustible materials within the electrical power center panel. Contributing to the left heat exchanger fan relay malfunction was the…NTSB CHI00IA087Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC9-32 · Milwaukee, WIthe chafing of the internal water heater wire. A factor was the missing ground strap.NTSB CHI89IA143Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILPoor lookout by the crew of the DC-9 and the Cessna pilot.NTSB LAX83IA302Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-32 · Las Vegas, NVDuring the ground run for takeoff a fatigue precipitated failure of the third stage turbine blade occurred with secondary damage to several guide vanes and the fourth stage turbine wheel. Imbalance of the turbine wheel caused the failure of the number six…NTSB LAX83IA257Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Luke Afb, AZWhile descending through 31,600 ft the master caution & the right 'inlet fuel pressure low' lights illuminated. The fuelquantity transfer circuit breaker was found tripped, & when reset the fuel quantity gauges went to zero. An emergency was declared to…NTSB CHI79FA047Accident · No injuriesClosedDouglas DC-9 · Mosinee, WI