Skip to content

NTSB investigations · 20

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.aircraft_model_code IN ('1384956') 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.aircraft_model_code IN ('1384956')
  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.aircraft_model_code IN ('1384956')
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 DCA14LA137Accident · No injuriesLimited investigationFinal reportBoeing 757 · San Diego, CAthe first officer's failure to maintain the correct airspeed and pitch attitude during landing that resulted in a tailstrike.Jul 30, 2014 · N553UA · Substantial damage NTSB WPR12LA057Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Modesto, CAThe flight's encounter with known severe turbulence associated with mountain wave activity, which resulted in a flight attendant sustaining a broken ankle.Dec 1, 2011 · N547UA · No damage NTSB ENG11IA051Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Denver, CO**This probable cause was modified on 4/5/2012. Please see the public docket for this accident to view the original probable cause.** The initial damage to the fan blades was caused by the ingestion of a Red-Tailed Hawk that caused one or more fan blades to…Sep 26, 2011 · N526UA · Minor damage NTSB WPR11LA300Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Los Angeles, CAThe ground crewmembers’ failure to follow proper procedures for removing a stuck or jammed tow bar, which resulted in a ground crew injury.May 31, 2011 · N526UA · Minor damage NTSB ENG10IA029Incident · No injuriesIncident investigationFinal reportBoeing 757 · Chantilly, VAThe ignition of the J5 power terminal located on the captain’s No. 1 windshield due to a loose electrical connection between the terminal connector lug and its respective terminal block. The loose connection resulted from a missing lock washer that allowed…May 17, 2010 · N510UA · Minor damage NTSB SEA08LA061Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · San Francisco, CAThe company tug operator's failure to maintain clearance with another aircraft during the pushback process. Also causal was the ground controller's failure to alert the pilot of the other aircraft and tug operator of this airplane of the simultaneous pushback…Jan 14, 2008 · N508UA · 2 aircraft · Substantial damage NTSB LAX07LA127Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Los Angeles, CAThe flight's encounter with a turbulence event that occurred while the flight attendants were unseated. Contributing to the accident was the apparent conflicting information provided by the flight deck to the flight attendants and the flight attendants'…Apr 12, 2007 · N525UA · No damage NTSB CHI06LA099Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Omaha, NEAn inadvertent encounter with unforecast mountain wave turbulence during cruise flight. A contributing factor was the mountain wave (terrain induced) turbulence.Mar 15, 2006 · N518UA · No damage NTSB SEA04IA175Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Richmond, BC, CanadaThe slat was impacted by birds after takeoff and subsequently the slat delaminated due to flight loads.Aug 27, 2004 · N526UA · Minor damage NTSB CHI04LA084Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Janesville, WIThe unexpected encounter with convective turbulence.Mar 1, 2004 · N516UA · No damage NTSB CHI03LA113Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Lithonia, GAThe flight into adverse weather encountered by the flight crew, and the flight attendant's restraint not available when she was informed to take her seat. The convective associated turbulence was a contributing factor.Apr 21, 2003 · N504UA · No damage NTSB DEN03IA033Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Salt Lake City, UTthe arcing wires in the lavatory sensor that resulted in the subsequent fire.Jan 11, 2003 · N551UA · Minor damage NTSB SEA02LA049Accident · No injuriesLimited investigationFinal reportBoeing 757-200 · Seattle, WAThe failure of the deicing truck driver to insure that the deicing basket boom remained clear of the aircraft structure as he backed away from the position he had been in while performing deicing procedures.Mar 2, 2002 · N589UA · Substantial damage NTSB DCA01MA065Accident · 44 fatalMajor investigationFinal reportBoeing 757 · Shanksville, PAThe 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…Sep 11, 2001 · N591UA · Destroyed NTSB CHI01LA154Accident · Serious injuriesLimited investigationFinal reportBoeing B757-200 · Kokomo, INthe turbulence encountered during descent and the passenger failure to return to his seat.Jun 5, 2001 · N563UA · No damage NTSB FTW96LA157Accident · Serious injuriesLimited investigationFinal reportBoeing B-757-222 · Taos, NMan encounter with unforecasted clear air turbulence.Mar 23, 1996 · N503UA · No damage NTSB ANC96LA026Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Fairbanks, AKinadequate visual lookout by the flightcrew of the Delta Boeing 757, N622DL, and their failure to follow procedures and directives by not closely following the ramp marshals' signals.Feb 20, 1996 · N524UA · 2 aircraft · Substantial damage NTSB DEN93LA098Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · Denver, COThe first officer's improper recovery from a bounced landing. Factors were: the first officer's delayed initiation of the flare, and the captain's improper supervision of the flight.Aug 2, 1993 · N508UA · Substantial damage NTSB DEN93IA027Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Grand Junction, COFailure of the left generator control unit (gcu), integrated drive generator (idg), right (side) engine indicator and crew alert system (eicas), and bus tie bar (btb).Feb 14, 1993 · N508UA · No damage NTSB DEN90LA046Accident · No injuriesLimited investigationFinal reportBoeing 757-222 · New York, NYOverrotation of the aircraft during takeoff. Factors related to the accident were: the first officer's improper use of the flight manual, which resulted in his improper calculations of the rotation speed, and inadequate supervision concerning verification of…Jan 16, 1990 · N505UA · Substantial damage

Back to Boeing 757-222