NTSB investigations: Mcdonnell Douglas DC-10-10, CA
9 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 | 1 |
|---|---|
| 1972 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1998 | 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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
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 SEA07TA181Accident · No injuriesFinal reportMcDonnell Douglas DC 10-10 · Tehachapi, CAThe captain's failure to maintain clearance from trees.NTSB LAX98FA169Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas DC-10-10 · Los Angeles, CAThe contaminated strain gage, which resulted in shorting of the strain gage's terminal lugs which lead to excessive autopilot initiated elevator movement, and excessive elevator actuation during recovery by the captain. Contributing factors were the failure…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 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 DCA78AA008Accident · 2 fatalClosedDouglas DC-10 · Los Angeles, CANTSB LAX76IL019Incident · No injuriesClosedDouglas DC-10 · Banning, CANTSB LAX73IL003Incident · No injuriesClosedDouglas DC-10 · Los Angeles, CANTSB CHI72IC015Incident · No injuriesClosedDouglas DC-10 · Los Angeles, CA