NTSB investigations: Mcdonnell Douglas DC-9-82(MD-82), 2002
4 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\") = 2002
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") = 2002
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 NYC03LA016Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Flushing, NYAn inadvertent trauma to the passenger's foot during an emergency evacuation.NTSB ATL03LA014Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Orlando, FLThe airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.NTSB CHI02IA151Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Wichita, KSThe flightcrew's failure to verify the engine instrument indications and powerplant controls while on autopilot with the autothrottles engaged, and their failure to recognize the drop in airspeed which led to an aerodynamic stall associated with the reduction…NTSB ANC02FA023Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-82 · Anchorage, AKThe MD-11 flight crew's failure to maintain clearance while taxiing and the other's airplane's (MD-82) ground-marshaling personnel's failure to follow procedures/directives when they did not display an emergency stop signal to the crew of the MD-11. Factors…