NTSB investigations: Mcdonnell Douglas MD-88, TX
4 cases on aircraft the registry lists as Mcdonnell Douglas MD-88. 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
| 1992 | 1 |
|---|---|
| 1998 | 1 |
| 2002 | 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.\"eventStateOrRegion\" = 'TX' 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 ('3023688', '3023689'))
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" = 'TX' 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 ('3023688', '3023689'))
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 DFW08IA073Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Austin, TXThe airplane struck a large bird while making a visual approach to the airport.NTSB FTW02LA199Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Houston, TXThe pilot's failure to maintain clearance with the parked vehicles. Factors contributing to the accident were the airport's failure to properly identify the construction area, their failure to publish a notice to airmen.NTSB FTW99LA054Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Dfw Airport, TXA passenger sustained a hairline fracture during an emergency evacuation of the airplane.NTSB FTW92IA208Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Dfw Airport, TXThe loss of engine power due to the fracture of a fan blade resulting from a manufacturing defect.