NTSB investigations: Mcdonnell Douglas DC-10-10
9 cases on aircraft the registry lists as Mcdonnell Douglas DC-10-10, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1998 | 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 ('3022110')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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 ('3022110')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 FTW98IA158Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COThe total failure of one main landing gear tire.NTSB LAX91IA308Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAThe failure of the number 2 engine's fire detection system, systron donner fire detector.NTSB BFO90FA017Accident · Serious injuriesField investigationFinal reportDouglas DC-10 · Baltimore, MDInjuries associated with the evacuation of the aircraft.NTSB DCA89MA063Accident · 111 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-10-10 · Sioux City, IAThe inadequate consideration given to human factors limitations in the inspection and quality control procedures used by united airlines' engine overhaul facility which resulted in the failure to detect a fatigue crack originating from a previously…NTSB LAX87IA230Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAOver the outer marker, the captain extended the flaps to 50 degrees. As the flaps extended past 35 degrees, the airplane rolled to the left. The flaps were retracted to the 35 degree position and a go-around was executed. The flaps were set at 22 degrees and…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 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…NTSB NYC85IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Jamaica, NYDuring taxi for departure, acft experienced several jolts to the right. Capt stopped acft and requested grnd personnel to inspect landing gear. Inspection revealed rt main gear truck beam failed. Metallurgical inspection of truck beam ass'y concluded the…NTSB NYC84IA048Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Newark, NJThe acft experienced a complete truck beam failure after touchdown. Metallurgical examination revealed a crack near the right rear truck pivot pin lubrication hole which showed propagation to the lower end of the grease hole on the mating surface. Grease hole…