NTSB investigations: Mcdonnell Douglas DC-9-82(MD-82), 1996
6 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.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1987 | 6 |
| 1988 | 2 |
| 1989 | 5 |
| 1991 | 5 |
| 1992 | 1 |
| 1993 | 5 |
| 1994 | 3 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2010 | 1 |
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 year(c.\"eventDate\") = 1996
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 year(c."eventDate") = 1996
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" 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 SEA97IA040Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Seattle, WAThe failure of the left wing walker to verify the clearance between the left wing and the fuel truck during taxi, and his delay in signaling the lead marshaller to alert the pilot to stop the aircraft prior to impact. Factors contributing to the incident…NTSB ANC97IA011Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Anchorage, AKThe ground crew's failure to maintain communication with the flight crew while loading cargo after pushback and engine start, and the ground and flightcrew's failure to follow the procedure outlined in their manuals concerning use of marshallers during…NTSB FTW97IA045Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Dfw Airport, TXThe failure of the low pressure turbine shaft. A factor was the coke build up on the low pressure turbine shaft.NTSB NYC97LA009Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-80 · Jamaica, NYFailure of the nose landing gear upper lock link.NTSB FTW96IA237Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Albuquerque, NMthe flightcrew's inadvertent encounter with windshear at low altitude. Factors were: variable winds, high density altitude, and the FAA's inadequate location/height of the LLWAS sensor.NTSB FTW96IA235Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Childress, TXThe aircraft's encounter with unforcasted and unreported severe turbulence.