Skip to content

NTSB investigations · 16

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.engine_model_code IN ('30109') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.engine_model_code IN ('30109')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('30109')
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 DCA26MA352Accident · 5 fatalClass 1 · MajorPreliminary reportBoeing 767 · Miami, FLOn September 6, 2026, about 1353 eastern daylight time (EDT), 21 Air flight 7598, a Boeing 767-33A, N1997A, overran runway 30 after landing at Miami International Airport (MIA), Miami, Florida and subsequently impacted two ground passenger vehicles. The two…Sep 6, 2026 · N1997A · Substantial damage NTSB DCA25FA148Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 767 · Newark, NJOn March 1, 2025, at 0800 eastern standard time, FedEx flight 3609, a Boeing 767-300F, powered by two General Electric CF6-80C2 turbofan engines, registration number N178FE, struck birds during initial climb after takeoff from Newark Liberty International…Mar 1, 2025 · N178FE · Minor damage NTSB DCA24WA180Incident · No injuriesClass 2 · ForeignBoeing 767-3S2F · Istanbul, TürkiyeMay 8, 2024 · N110FE · Minor damage NTSB ENG24FA003Incident · No injuriesClass 3 · FieldFinal reportBoeing 767-300F · Memphis, TNA high-pressure fuel leak from a gap in the bolted flange interface between the main fuel pump’s fuel crossover supply tube and the hydromechanical unit idler adapter pad, which resulted in the crossover tube flange bolts partially pulling out and allowing…Oct 18, 2023 · N287FE · Minor damage NTSB DCA23WA184Occurrence · Serious injuriesClass 5 · ForeignBoeing 767-300F · Derby, United KingdomFeb 4, 2023 · N370UP · No damage NTSB DCA23FA149Incident · No injuriesClass 1 · FieldFinal reportBoeing 767-32LF · Austin, TXthe local controller’s incorrect assumption that the Southwest Airlines (SWA) airplane would depart from the runway before the Federal Express airplane arrived on the same runway, which resulted in a loss of separation between both airplanes. Contributing to…Feb 4, 2023 · N297FE · 2 aircraft · No damage NTSB DCA21WA090Incident · No injuriesClass 4 · ForeignBoeing 767-316 · Panama City, PanamaFeb 27, 2021 · N542LA · No damage NTSB DCA20LA138Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 767 · Los Angeles, CAThe left main landing gear’s failure to extend due to the separation of the brake rod retaining hardware from the aft inboard wheel for reasons that could not be determined based on the available evidence.Aug 19, 2020 · N146FE · Substantial damage NTSB DCA20WA093Accident · No injuriesClass 5 · ForeignBoeing 767 · Shannon, IrelandMar 8, 2020 · N477AX · Substantial damage NTSB DCA19WA202Incident · Minor injuriesForeign investigationBoeing 767 · Shannon, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions of ICAO…Aug 15, 2019 · N378AX · Minor damage NTSB DCA19MA086Accident · 3 fatalClass 1 · MajorFinal reportBoeing 767 · Trinity Bay, TXThe inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…Feb 23, 2019 · N1217A · Destroyed NTSB DCA18CA252Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 767 · Portsmouth, NHan improper landing flare technique and the lack of the appropriate bounced landing recovery procedure.Jul 27, 2018 · N641GT · Substantial damage NTSB DCA18CA007Accident · Serious injuriesData collectionFinal reportBoeing 767 328 · Honolulu, HIan inadvertent encounter of clear air turbulence.Oct 15, 2017 · N342AX · No damage NTSB DCA17WA073Accident · No injuriesForeign investigationBoeing 767 33A · Azraq, JordanFeb 28, 2017 · N351AX · Substantial damage NTSB DCA16WA150Incident · No injuriesForeign investigationBoeing 767 · Cologne, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on May 06, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…May 6, 2016 · N341UP · No damage NTSB OPS15IA017Incident · No injuriesIncident investigationFinal reportBoeing 767 34AF · Miami, FLThe controller's issuance of a landing clearance to an arriving aircraft while another aircraft was in position on the same runway. Contributing to the incident was the controller's non-compliance with traffic advisory procedures, and insufficient…Apr 12, 2015 · N342UP · 2 aircraft · No damage

Back to GE CF6-80C2B6F