NTSB investigations: Mcdonnell Douglas Helicopter MD 900
3 cases on aircraft the registry lists as Mcdonnell Douglas Helicopter MD 900. 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
| 2003 | 1 |
|---|---|
| 2004 | 1 |
| 2008 | 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 ('3027375'))
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 ('3027375'))
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 WPR09IA070Incident · No injuriesIncident investigationFinal reportMD Helicopter MD 900 · Kamuela, HIThe separation of the endplate bolts for undetermined reasons, resulting in an in-flight separation of the right endplate. Contributing to the accident was the manufacturer's failure to provide sufficient guidance for endplate bolt installation.NTSB LAX04LA333Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 900 · Mesa, AZfracture of a Tension-Torsion strap in the anti-torque fan due to progressive fiber failure of the composite strap material from compression and/or transverse shear stresses that occurred with repeated manipulation of the cockpit anti-torque control pedals…NTSB LAX04TA017Accident · No injuriesFinal reportMD Helicopter 900 · Fredonia, AZthe pilot's in-flight loss of control due to the fatigue fracture and separation of the force limiting control rod (an integral part of the anti-torque system), which resulted in the helicopter's uncommanded yaw/spin and subsequent collision with terrain.