NTSB investigations: Boeing 767-223
8 cases on aircraft the registry lists as Boeing 767-223. 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
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 2 |
| 2006 | 1 |
| 2010 | 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 ('1385123'))
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 ('1385123'))
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 CEN10LA240Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Fort Dodge, IAThe flight crew's inadequate separation from convective activity that resulted in serious injury to an unrestrained flight attendant.NTSB ENG06IA018Incident · No injuriesIncident investigationFinal reportBoeing 767-223(ER) · Los Angeles, CAThe HPT stage 1 disk failed from an intergranular fatigue crack because of GE's inadequate design of the CF6-80 series HPT stage 1 disk. The inadequate design of the disk resulted in a high stress area in the blade slot bottom aft corner that was at or nearly…NTSB DCA01MA060Accident · 92 fatalMajor investigationFinal reportBoeing 767-200ER · New York City, NYThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…NTSB NYC01LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200ER · Boston, MAThe Boeing 767 captain's misjudgment of the distance between his airplane and the stationary Boeing 737, which resulted in a ground collision. A factor was sunglare.NTSB CHI98LA269Accident · Serious injuriesLimited investigationFinal reportBoeing 767-223 · Peotone, ILIn-flight encounter with turbulence.NTSB LAX96LA222Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · San Francisco, CAinadequate visual lookout by the United Airlines tug driver during the pushback operation. Contributing factors were: the driver's reduced ability to observe the American B-767 due to the nighttime condition, and United Airlines management's failure to ensure…NTSB CHI88FA048Accident · Serious injuriesField investigationFinal reportBoeing 767-200 · Chicago, ILA flight attendant and a passenger received serious and minor injuries respectively during an inflight encounter with severe turbulence during an enroute descent. Greater than moderate turbulence was forecast to be in the area and severe turbulence had been…NTSB DCA87RA047Incident · No injuriesForeign investigationBoeing B 767 200ER · Frankfurt, Germany