Final NTSB investigations: Douglas DC-8-62
7 cases on aircraft the registry lists as 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
| 1968 | 2 |
|---|---|
| 1971 | 1 |
| 1991 | 1 |
| 1996 | 2 |
| 2000 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3021970'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3021970'))
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 DEN00FA078Accident · No injuriesField investigationFinal reportDouglas DC-8-62F · Denver, COThe failure of the clamp that secured the high-pressure bleed air duct to the high-pressure relief valve. Factors were the resulting excessive pressurization of the engine nacelle, and the subsequent separation of the engine cowling.NTSB MIA97IA050Incident · No injuriesIncident investigationFinal reportDouglas DC8-62 · Orlando, FLThe failure of the captain to center the rudder and close all engine throttles during an aborted takeoff resulting in an uncontrolled turn to the right due to nose wheel steering through the rudder pedals and asymmetric engine thrust. A factor in the incident…NTSB IAD96LA052Accident · No injuriesLimited investigationFinal reportDouglas DC-8-62 · Wilmington, OHThe pilot-in-command's inadequate visual lookout and the company/operator's inadequate crew/group coordination and communication during taxi and snow removal operations. Related factors were the snowy weather conditions affecting visibility and the snowplow…NTSB NYC91FA086Accident · Minor injuriesField investigationFinal reportDouglas DC-8-62 · Jamaica, NYImproper preflight planning/preparation, in that the flight engineer miscalculated (misjudged) the aircraft's gross weight by 100,000 lbs and provided the captain with improper takeoff speeds; and improper supervision by the captain. Factors related to the…NTSB CHI72AC010Accident · Serious injuriesClosedDouglas DC-8 · No.Pacific Ocean (Pacific Ocean)NTSB MIA69I0007Incident · No injuriesClosedDouglas DC-8 · No.Atlantic Ocean (Atlantic Ocean)NTSB UNK68X0135Accident · Minor injuriesClosedDouglas DC-8 · Quito, Ecuador