NTSB investigations: Mcdonnell Douglas DC-10-10, 1986
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\") = 1986
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") = 1986
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 LAX87MA044Accident · Serious injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAThe captain stated that about 90 min after departure, the acft experienced an abrupt pitch-up, followed by an abrupt pitch-down. Drg the occurrence, one flt attendant was seriously injured; two flt attendants & one passenger received minor injuries. The…NTSB FTW86IA078Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Dallas/Ftw Apt, TXThe crew stated that during an attempted start the no. 1 eng failed to gain ignition during the prescribed 25 sec limit and that they aborted the start. Shortly thereafter, grnd pers reported that the eng had developed a tail pipe fire. Following emerg…NTSB CHI86MA056Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Detroit, MIN101AA was operating as American flt 192. Flt 192 was originally cleared to land on rwy 21R; however, a preceeding acft had a landing gear problem, so flt 192 was cleared to land on rwy 21C, instead. The coplt, who was flying the acft, made a side-step…