Skip to content

NTSB investigations · 24

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 ('1384077') 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 ('1384077')
  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 ('1384077')
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 DFW06LA024Accident · Serious injuriesLimited investigationFinal reportBoeing 727-225 · San Antonio, TXThe captain's improper decision to maneuver a transport category airplane in a confined and unapproved area with engine thrust, which resulted in ground damage and personal injury to an individual.Oct 23, 2005 · N679MG · No damage NTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.May 28, 1999 · N282SC · Substantial damage NTSB DCA99WA049Incident · No injuriesForeign investigationBoeing 727-200 · Calgary, CanadaMar 11, 1999 · N8873Z · Minor damage NTSB LAX99IA072Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Phoenix, AZThe failure of the ground handling personnel to properly secure the aft cargo door following the loading of the late arriving baggage. A factor in the incident was an intermittent cargo door warning light circuit due to contamination in the proximity switch…Jan 5, 1999 · N804MA · Minor damage NTSB DCA99WA008Incident · No injuriesForeign investigationBoeing 727 · Point A Pitre, FranceOct 20, 1998 · N886MA · No damage NTSB DCA97IA030Incident · No injuriesIncident investigationFinal reportBoeing 727F · Atlanta, GAA jammed elevator resulting from a backed-off elevator trim tab nut.Mar 3, 1997 · N465FE · Minor damage NTSB MIA96LA107Accident · No injuriesLimited investigationFinal reportBoeing 727-225 · Memphis, TNfailure of the flightcrew to maintain clearance from construction equipment while taxiing after landing. Factors relating to the accident were: failure of operator personnel to supply the flightcrew with current NOTAM information, failure of ATC personnel to…Mar 27, 1996 · N468FE · Substantial damage NTSB MIA93IA030Incident · Minor injuriesIncident investigationFinal reportBoeing 727-225A · Miami, FLThe failure of the window pane for undetermined reasons.Dec 17, 1992 · N804MA · Minor damage NTSB MIA90IA070Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Sarasota, FLImproper servicing of the forward lavatory by contract service personnel.Feb 13, 1990 · N8889Z · Minor damage NTSB DCA90MA017Accident · 1 fatalClass 1 · MajorFinal reportBoeing 727 · Atlanta, GA(1) Failure of the federal aviation administration to provide air traffic control procedures that adequately take into consideration human performance factors such as those which resulted in the failure of the north local controller to detect the developing…Jan 19, 1990 · N8867E · 2 aircraft · Substantial damage NTSB ATL90IA033Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Atlanta, GAInadequate maintenance and inspection by the operator.Nov 29, 1989 · N8835E · Minor damage NTSB MIA87FA248Accident · No injuriesField investigationFinal reportBoeing 727 · Tulsa, OKThe crew of the Boeing 727 aircraft on a domestic passenger flight initiated an approach to a runway with a known crosswind and tailwind component. On final approach the tower controllers re-stated the wind and issued a windshear warning. On short final at…Sep 16, 1987 · N8857E · Substantial damage NTSB MIA87IA204Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Washington, DCDrg arr, the acft's radar showed tstms in the area of the arpt. As the flt contd, ATIS info chgd. When the plts ctcd Washington apch ctl with old ATIS info, the ctlr did not correct the flt. They were adzd of hvy rain, strong wnds & a PIREP of wndshr nr the…Jul 11, 1987 · N8892Z · Minor damage NTSB ATL85IA263Incident · Minor injuriesIncident investigationFinal reportBoeing 727-225 · Charleston, SCThe flight was level at 330 when it encountered turbulance and the arcraft moved an estimated 200 feet down then up before the crew could regain altitude control. Two flight attendents and several passengers initially complained of injuries. No documentation…Aug 29, 1985 · N8832E · No damage NTSB BFO85IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Richmond, VAThe flt was in cruise at FL 350 when the cabin crew reported a cabin fire in the vicinity of seat 28A. Shortly after, a lower aft body overheat warning was recvd. The flt diverted to Richmond, VA. During descent, the flt crew performed the appropriate…Aug 11, 1985 · N8856E · Minor damage NTSB MIA84IA063Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Tampa, FLThe acft experienced a rapid loss of fuel quanity on the #1 fuel tank during the climb to cruise. Investigation revealed that prior to this flt the water separator access door had been replaced by a fabricated metal plate which separated in flt. The separated…Jan 20, 1984 · N8852E · Minor damage NTSB MIA83IA075Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Miami, FLDuring gear retraction after takeoff, the aircrew noted that the left main landing gear (MLG) door warning light remained illuminated. The landing gear control was cycled, but the condition was not corrected. Attempts to extend the left MLG were also…Feb 16, 1983 · N8831E · Minor damage NTSB MIA81IA063Incident · No injuriesClosedBoeing 727 · Miami, FLApr 14, 1981 · N356PA · Minor damage NTSB IAD80IA043Incident · No injuriesClosedBoeing 727 · Washington, DCApr 11, 1980 · N8873Z · Minor damage NTSB MIA78DA057Accident · Serious injuriesClosedBoeing 727 · Greensboro, NCMar 9, 1978 · N8842E · No damage NTSB IAD77IA042Incident · No injuriesClosedBoeing 727 · Washington, DCMay 25, 1977 · N8832E · Minor damage NTSB IAD77IA010Incident · No injuriesClosedBoeing 727 · Washington, DCOct 25, 1976 · N8837E · No damage NTSB DCA76AZ011Accident · Serious injuriesClosedBoeing 727 · Raleigh, NCNov 12, 1975 · N8838E · Substantial damage NTSB DCA75AZ015Accident · 112 fatalClosedBoeing 727 · Jamaica, NYJun 24, 1975 · N8845E · Destroyed

Back to Boeing 727-225