Skip to content

NTSB investigations · 18

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 ('1384073') 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 ('1384073')
  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 ('1384073')
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 CHI96IA145Incident · Minor injuriesIncident investigationFinal reportBoeing 727-222A · Chicago, ILa passenger disturbance that required the flight attendant to leave her seat. A factor in this accident was the encounter with turbulence as the flight attendant was performing her assigned duties.Apr 28, 1996 · N7443U · No damage NTSB CHI91LA115Accident · Serious injuriesLimited investigationFinal reportBoeing 727-222 · Buffalo, NYA clear air turbulence encounter.Mar 23, 1991 · N7449U · No damage NTSB CHI87IA109Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Chicago, ILA united airlines Boeing 727 domestic passenger flight was holding short of runway 32L at the Chicago-o'hare international airport awaiting clearance for an intersection takeoff. A northwest airlines Boeing 747 international passenger flight was holding in…Apr 7, 1987 · N7258U · No damage NTSB ANC87FA021Accident · Serious injuriesField investigationFinal reportBoeing 727-222 · Anchorage, AKAbout 10 min before arrival, the acft suddenly encountered turbulence which one occupant described as a single tremendous jolt. The mishap occurred while the acft was aprx 39 miles east of Anchorage intl arpt and was descending thru 10,000 ft. the seat belt…Dec 16, 1986 · N7635U · Minor damage NTSB LAX87IA027Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Los Angeles, CADrg arr, united flt 282 (Boeing 727, N7255U) was vectored by Los Angeles (lax) TRACON for an ILS rwy 25L apch. While in a dscndg turn at 2100' MSL to intercept the ILS LOC at 2000', the capt saw a helicopter (hel) ahead & pulled up. He estdhis acft passed w/i…Oct 29, 1986 · N7255U · 2 aircraft · No damage NTSB DCA84AA025Accident · No injuriesFinal reportBoeing 727-222 · Denver, COBefore takeoff, the crew of N7647U (ua flt 663) noted cumulus clouds & virga in the area. At 1327, a Dehavilland dash 7 crew rprtd a 25 kt loss of airspeed, but svrl other acft then took off without rprtg a problem. Due to radio conjestion,the captain did not…May 31, 1984 · N7640U · Substantial damage NTSB MIA84IA012Incident · No injuriesIncident investigationFinal reportBoeing 727-21 · Miami, FLThe nose gear failed to extend due to impairment of the retraction/extension mechanism by the complete blockage of a hydraulic passagway with foreign matter similar to rubber.Oct 19, 1983 · N357PA · Minor damage NTSB CHI83FA251Accident · Serious injuriesField investigationFinal reportBoeing 727-222A · Chicago, ILDuring the takeoff roll, the #1 eng failed & the takeoff was aborted at aprx 70 KTS. The aircrew taxied the acft clear of the rwy & stopped on the reverse high speed turnoff. The aircrew of another company acft transmitted that the #1 eng was on fire. There…Jun 11, 1983 · N7273U · Substantial damage NTSB CHI82IA117Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Youngstown, OHAfter aborting one approach and holding for several minutes, the flight was cleared for the ILS approach runway 32 at 0947 EST. While the flight was holding, the crew had several conversations with approach control and the company representative regarding…Apr 9, 1982 · N7627U · Minor damage NTSB CHI81IA088Accident · Serious injuriesClosedBoeing 727 · Columbus, OHJun 5, 1981 · N7255U · No damage NTSB IAD76II057Incident · No injuriesClosedBoeing 727 · Washington, DCFeb 19, 1976 · N7624U · Minor damage NTSB SEA76AS036Accident · Serious injuriesClosedBoeing 727 · Boise, IDFeb 16, 1976 · N7629U · No damage NTSB MIA75IM042Incident · No injuriesClosedBoeing 727 · Birmingham, ALJan 8, 1975 · N7642U · Minor damage NTSB MIA74AM055Accident · Serious injuriesClosedBoeing 727 · Tampa, FLJan 4, 1974 · N7624U · Minor damage NTSB MIA74IM008Incident · No injuriesClosedBoeing 727 · Opa Locka, FLJun 10, 1973 · N7625U · No damage NTSB IAD71II039Incident · No injuriesClosedBoeing 727 · Dulles Int Apt, DCFeb 15, 1971 · N7644U · No damage NTSB LAX69A0043Accident · Serious injuriesClosedBoeing 727 · San Diego, CAJan 16, 1969 · N7624U · No damage NTSB LAX69A0021Accident · Serious injuriesClosedBoeing 727 · Fillmore, CAOct 3, 1968 · N7622U · No damage

Back to Boeing 727-222