NTSB investigations: Mcdonnell Douglas MD-11F
4 cases on aircraft the registry lists as Mcdonnell Douglas MD-11F, where the first occurrence was “Hard landing”. 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
| 1994 | 1 |
|---|---|
| 1997 | 1 |
| 2004 | 1 |
| 2005 | 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 ('3023600')
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\" = 200))
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 ('3023600')
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" = 200))
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 NYC05FA094Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11F · Louisville, KYThe flying pilot's improper aircraft handling after main landing gear touchdown, which resulted in the collapse of the nose landing gear assembly. Conributing to the accident was the pilot-in-command's inadequate supervision during the landing.NTSB DCA04MA082Accident · No injuriesMajor investigationFinal reportBoeing MD-11 · Memphis, TNThe pilot's over-rotation during a go-around maneuver initiated because of a bounced landing. The go-around maneuver was initiated at a low speed and high pitch angle, and after reverse thrust was selected, contrary to Boeing and FedEx training guidance.NTSB DCA97MA055Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-11 · Newark, NJThe captain's overcontrol of the airplane during the landing and his failure to execute a go-around from a destabilized flare. Contributing to the accident was the captain's concern with touching down early to ensure adequate stopping distance.NTSB ANC95FA008Accident · No injuriesField investigationFinal reportMcdonnell Douglas MD-11/F · Anchorage, AKThe flight crew's improper recovery from a bounced landing. Factors associated with the accident are the first officer's lack of familiarity with the airplane, his failure to stabilize the approach, and the captain's delayed remedial action.