NTSB investigations, DC
6 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1998 | 1 |
| 1999 | 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\" = 'DC' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE 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."eventStateOrRegion" = 'DC' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 IAD99IA059Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCThe inadequate lubrication of the landing gear side strut assembly by company maintenance personnel. A factor in the accident was the inadequate design of the assembly that trapped water and prevented adequate lubrication.NTSB CHI98IA167Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD82 · Washington, DCThe failure of the Dual Axis Accelerometer.NTSB BFO90IA028Incident · No injuriesIncident investigationFinal reportBoeing B-727-29 · Washington, DCThe accident was fatigue failure of the right main landing gear support link shaft because of overtorque.NTSB BFO88IA065Incident · No injuriesIncident investigationFinal reportCessna T210R · Washington, DCImproper maintenance resulting in the routing of wire which caused an electrical short and inflight smoke.NTSB CHI87IA026Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Washington, DCDrg an en route climb, aileron control (ctl) bcm progressively more stiff. At cruise alt, the autoplt disengaged & the ailerons would not move. Aileron ctl was restored after a dscnt below the freezing level. The acft was flown below the freezing lvl for the…NTSB ATL82IA038Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Washington, DCAircraft was being ferried to Washington, DC following rework in toronto, Canada. During letdown in IFR conditions and moderate icing, pilot noticed a glow on the right wing. As he leaned over to check it, the right engine fire warning light and fire bell…