NTSB investigations: Mcdonnell Douglas DC-8-62
6 cases on aircraft the registry lists as Mcdonnell Douglas DC-8-62. 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
| 1970 | 1 |
|---|---|
| 1974 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1989 | 1 |
| 1999 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('302197B'))
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 ('302197B'))
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 CHI00LA047Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Indianapolis, INthe flight crew misjudged the clearance between their right wing and the radome of the parked aircraft. A factor associated with the accident was the ground handling contractor failed to identify the unsafe/hazardous condition that existed on the congested…NTSB DCA89RA056Accident · 174 fatalForeign investigationMcDonnell Douglas DC-8-62 · Paramaribo, SurinameNTSB MIA80RA003Accident · Minor injuriesClosedDouglas DC-8 · Panama Cty, St. Pierre & MiquelonNTSB MIA77IA057Incident · No injuriesClosedDouglas DC-8 · Miami, FLNTSB FTW75AF040Accident · Serious injuriesClosedDouglas DC-8 · Bogota, ColombiaNTSB FTW70AF060Accident · Serious injuriesClosedDouglas DC-8 · Guayaquil, Ecuador