NTSB investigations: Douglas DC-9-31, 1984
3 cases on aircraft the registry lists as Douglas DC-9-31. 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
| 1969 | 5 |
|---|---|
| 1970 | 3 |
| 1971 | 3 |
| 1972 | 4 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 3 |
| 1978 | 1 |
| 1980 | 3 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 6 |
| 1991 | 1 |
| 1992 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 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\") = 1984
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065'))
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") = 1984
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022065'))
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 DCA85IA001Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Erie, PAThe orig destn was youngstown, OH, but its wx was blo mins, so the flt to transport a football team was planned to Erie which was slightly above mins. The coach & business manager were not happy about this, but plans were made to bus the team on to…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…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…