NTSB investigations: Mcdonnell Douglas DC-10-10, 1985
3 cases on aircraft the registry lists as Mcdonnell Douglas DC-10-10. 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
| 1971 | 2 |
|---|---|
| 1972 | 4 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 4 |
| 1976 | 1 |
| 1978 | 2 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 4 |
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1998 | 2 |
| 2006 | 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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022110'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3022110'))
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 FTW85IA341Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Abilene, TXAa DC-10 enroute el paso, TX. To dfw arprt TX. Had fire warning #3 eng. Crew performed emerg. Proc. But lite remained on. Crew made emergency landing dyess afb Abilene, TX. Pax emer evac left side of a/c. aft slide L4 deflated during evac 1 pax received minor…NTSB CHI85IA339Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Detroit, MIOn August 7,1985 at 2000 EDT, a Mcdonnell Douglas DC-10-10 N111AA registered to American airlines, inc., had a piece of the engine exit the engine case and cowling. On climb to cruise at Detroit airport, Detroit, Michigan, while on a passenger flight. Visual…NTSB NYC85FA138Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC-10-10 · Jamaica, NYThe forward one-third portion of the core cowl door on no. 3 engine separated in flight first striking the leading edge of the right wing, then puncturing the fuselage. Causing rapid decompression at FL 170. The core cowl door latches were not adjusted & core…