Final NTSB investigations: Boeing 787-9
7 cases on aircraft the registry lists as Boeing 787-9. 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
| 2015 | 1 |
|---|---|
| 2018 | 1 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1385609'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1385609'))
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 DCA26LA167Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean (Pacific Ocean)An unanticipated encounter with clear air turbulence while in cruise flight.NTSB DCA25LA173Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787 · Claveria, PhilippinesAn encounter with convective turbulence during cruise that was not detected in advance by cockpit weather radar or weather information services.NTSB DCA25LA055Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Pacific Ocean, Hong Kong SAR ChinaAn encounter with unexpected turbulence during descent.NTSB DCA25LA044Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 787-9 · Tokyo, JapanAn encounter with turbulence while in cruise flight, resulting in serious injuries to two flight attendants.NTSB ENG24LA014Incident · No injuriesClass 3 · LimitedFinal reportBoeing 787 · Singapore, SingaporeThe uncontained left engine failure was caused by the failure and liberation of the HPT stage 1 aft blade retainer as a result of a fatigue crack in the upper collet radius that originated from a surface connected cluster of Oxide/Carbonitride/Nitride/Carbide…NTSB DCA18CA219Accident · Serious injuriesData collectionFinal reportBoeing 787-9 · Harbin, Chinathe accidental tipping over of a beverage service cart, when there was no turbulence, which caused pots of hot water to burn two flight attendants.NTSB DCA16CA021Accident · Serious injuriesData collectionFinal reportBoeing 787 · Beaumont, TXAn inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.