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 ('1384002') 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 ('1384002')
  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 ('1384002')
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 ATL01IA083Incident · No injuriesIncident investigationFinal reportBoeing B-727-100 · Memphis, TNThe failure of the #3 engine starter turbine.Jul 13, 2001 · N189FE · Minor damage NTSB FTW97IA084Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Oklahoma City, OKexistence of fumes from the cargo compartment and activation of the cargo smoke detector for undetermined reasons.Jan 22, 1997 · N198FE · No damage NTSB DEN91IA028Incident · No injuriesIncident investigationFinal reportBoeing 727-22 · Denver, COFailure of an engine bearing.Dec 20, 1990 · N40486 · Minor damage NTSB CHI87IA067Incident · No injuriesIncident investigationFinal reportBoeing 727-122 · Fort Wayne, INAircraft exterior skin failed in fatigue while in cruise flight. The aircraft lost cabin pressure and the passenger oxygen masks automatically deployed. The flight crew donned oxygen masks, declared an emergency to ATC and descended to 10,000 ft. the aircraft…Jan 25, 1987 · N7015U · Minor damage NTSB ATL87IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-22 · Livingston, TNThe braniff and united Boeing 727 jetliners were approaching 'swapp' intersection on converging jetways at their proper assigned alt of 35,000'. The controller was in the process of issuing radar vectors to assure proper lateral separation when the control…Nov 12, 1986 · N7014U · 2 aircraft · No damage NTSB DEN86IA031Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Casper, WYAcft was parked at gate awaiting departure. A bus used to shuttle flt crews around the ramp arrived at flt 855 to deliver a flt attendant. The driver was backing away from acft when the left side to bus contacted rt wing tip. Damage was limited to wing tip…Nov 27, 1985 · N7011U · Minor damage NTSB MKC83FA112Accident · No injuriesField investigationFinal reportBoeing 727-100 · St. Louis, MOThe acft was scheduled as Continental flt 415 & was departing from eastern airlines gate 14A. While departing from the gate, the aircrew turned left to avoid a DC-9 parked at gate 14, then turned right to a yellow taxi line. While maneuvering, the left wing…May 20, 1983 · N40483 · Substantial damage NTSB FTW79FA099Accident · Minor injuriesClosedBoeing 727 · El Paso, TXAug 7, 1979 · N40490 · Substantial damage NTSB DEN72AD001Accident · Minor injuriesClosedBoeing 727 · Denver, COJul 19, 1971 · N7020U · Substantial damage NTSB NYC71IN127Incident · No injuriesClosedBoeing 727 · Rochester, NYJun 27, 1971 · N7026U · No damage NTSB DIA69I0054Incident · No injuriesClosedBoeing 727 · Raleigh, NCApr 12, 1969 · N7024U · No damage NTSB CHI69I0051Incident · No injuriesClosedBoeing 727 · Detroit, MINov 16, 1968 · N7027U · No damage NTSB DCA68A0001Accident · 82 fatalClosedBoeing 727 · Hendersonville, NCJul 19, 1967 · N68650 · 2 aircraft · Destroyed NTSB CHI67I0129Incident · No injuriesClosedBoeing 727 · Chicago, ILJun 8, 1967 · N7012U · Minor damage NTSB DEN67A0068Accident · No injuriesClosedBoeing B-727 · Salt Lke Cty, UTApr 29, 1967 · N7044U · Substantial damage NTSB MIA67A0104Accident · Serious injuriesClosedBoeing B-727 · Tampa, FLApr 7, 1967 · N7048U · Substantial damage NTSB NYC67I0039Incident · No injuriesClosedBoeing 727 · Buffalo, NYAug 27, 1966 · N7025U · Minor damage NTSB DEN67I0013Incident · No injuriesClosedBoeing B-727 · Pueblo, COJul 28, 1966 · N7011U · Minor damage NTSB OAK66I0047Incident · No injuriesClosedBoeing 727-22 · Sacramento, CAApr 20, 1966 · N7020U · Minor damage NTSB LAX66I0053Incident · No injuriesClosedBoeing B-727 · Sacramento, CAJan 5, 1966 · N7024U · Minor damage NTSB DCA66A0004Accident · 43 fatalClosedBoeing B-727 · Salt Lke Cty, UTNov 11, 1965 · N7030U · Destroyed NTSB DCA66A0002Accident · 30 fatalClosedBoeing B-727 · Lake Michigan, ILAug 16, 1965 · N7036U · Destroyed NTSB UNK65X0904Incident · No injuriesClosedBoeing 727 · Flushing, NYDec 2, 1964 · N7025U · Minor damage NTSB UNK64X1518Incident · No injuriesClosedBoeing 727 · Pueblo, COApr 30, 1964 · N7008U · Minor damage

Back to Boeing 727-22