# NTSB investigations: Near collision between aircraft NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 2 of 3 · 115 cases ## Cases, newest first - [NTSB BFO89IA036](https://openairdocs.org/ntsb/BFO89IA036.md): Northrop T-38A · Washington, DC · Incident · No injuries · Incident investigation · Final report · May 15, 1989 · N920NS · 2 aircraft · No damage > Failure of the T-38 pilot (in the other aircraft) to follow the ATC clearance and to maintain the proper altitude. Factors related to the incident were: failure of air traffic control (ATC) personnel to recognize the T-38'S improper altitude in a timely… - [NTSB LAX89IA184](https://openairdocs.org/ntsb/LAX89IA184.md): Boeing 747 · Los Angeles, CA · Incident · Minor injuries · Incident investigation · Final report · May 8, 1989 · ZKNZX · No damage > Inadequate visual look-out by the pilot of the other (small twin engine) aircraft. A factor related to the incident was: a delay of the 747 crew to see-and-avoid the other aircraft. - [NTSB NYC89IA222](https://openairdocs.org/ntsb/NYC89IA222.md): Cessna 421C · New York, NY · Incident · No injuries · Incident investigation · Final report · Apr 23, 1989 · N247CB · 2 aircraft · No damage > Failure of the liberty sector controller to advise pan am flight 542 of the presence of the Cessna 421 and/or restrict the climb of flight 542 until it had passed the Cessna, and failure of the pan am aircrew to see the Cessna in adequate time to avoid a near… - [NTSB NYC89IA123](https://openairdocs.org/ntsb/NYC89IA123.md): Fairchild Swearingen SA-227AC · New York, NY · Incident · No injuries · Incident investigation · Final report · Apr 23, 1989 · N3044J · 2 aircraft · No damage > The failure of the swearingen flight crew to properly identify the airplane they were to follow, prior to accepting the visual approach to runway 31R. - [NTSB DEN89IA089](https://openairdocs.org/ntsb/DEN89IA089.md): Boeing 727-200A · San Antonio, TX · Incident · No injuries · Incident investigation · Final report · Mar 22, 1989 · N728 · 2 aircraft · No damage > Failure of the ARTCC controller to assure that the aircraft maintained IFR separation standards. The controller's heavy workload was a related factor. - [NTSB CHI89IA054](https://openairdocs.org/ntsb/CHI89IA054.md): Short Brothers SD360 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 8, 1989 · N366MQ · No damage > The PIC followed a clearance intended for another airplane. - [NTSB FTW89IA064](https://openairdocs.org/ntsb/FTW89IA064.md): Mcdonnell Douglas DC-9-82 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Mar 1, 1989 · N820NY · 2 aircraft · No damage > Failure of the TRACON final approach controller to assure radar separation between the aircraft. Factors related to the accident were: inadequate supervision by the ATC supervisor, excessive workload for the controller, unclear instructions by the controller,… - [NTSB LAX89IA112](https://openairdocs.org/ntsb/LAX89IA112.md): British Aerospace BAE 146-200A · Los Alamitos, CA · Incident · No injuries · Incident investigation · Final report · Feb 14, 1989 · N141AC · No damage > Inadequate coordination among the ATC controllers which resulted in their failure to maintain adequate radar separation of the two aircraft. - [NTSB NYC89IA063](https://openairdocs.org/ntsb/NYC89IA063.md): McDonnell Douglas DC-10 · Atlantic Ocean (Atlantic Ocean) · Incident · No injuries · Incident investigation · Final report · Dec 30, 1988 · N153AA · 2 aircraft · No damage > American flt 1180 (McDonnell-douglas DC-10) was northbound ovr the Atlantic Ocean at flt lvl 350 as a british royal air force vickers VC10 was cruising east at the same alt (non-standard alt for the VC10'S drctn of flt). They were in a non-radar airspace… - [NTSB NYC89IA028](https://openairdocs.org/ntsb/NYC89IA028.md): Boeing 727-227 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Nov 14, 1988 · N555PE · 2 aircraft · Minor damage > Failure of the local controller to detect the red t on the departure strip on PRE659 when he cleared him into position and hold. Factors related to the accident were: darkness and the lack of positive coordination between the ground controller and local… - [NTSB FTW89IA016](https://openairdocs.org/ntsb/FTW89IA016.md): Boeing 727 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Nov 6, 1988 · N386PA · No damage > Poor planning/decision by the unidentified Cessna pilot by maneuvering in busy airspace near the arsa with no ATC coordination or transponder signal; no traffic advisory being issued by the approach controller; and inadequate visual lookout by the flight crew… - [NTSB ATL89MA012](https://openairdocs.org/ntsb/ATL89MA012.md): Aerospatiale ATR-42-300 · Yardley, PA · Incident · No injuries · Major investigation · Final report · Oct 12, 1988 · N17810 · 2 aircraft · No damage > Bfr tkof, corrected flt plan was put in ATC computer for airforce 1 (AF1) to take nonstandard rte to newark. After tkof,AF1 was vctrd nw with handoff to NY ARTCC (zny), then east via Yardley (ard) to newark; 15 mi west of ard, zny initiatedhandoff to NY… - [NTSB DEN89FA010](https://openairdocs.org/ntsb/DEN89FA010.md): Piper PA-24-180 · Albuquerque, NM · Accident · Serious injuries · Field investigation · Final report · Oct 9, 1988 · N7228P · Destroyed > Plt-rated pax told plt, coronado arpt 'in sight'. Plt was suspicious because loran indicated arpt was 3 mi away but trusted former instrument student's judgment & landed at closed alameda arpt instead of coronado arpt. Coronado UNICOM had told plt 'multiple… - [NTSB CHI88IA217](https://openairdocs.org/ntsb/CHI88IA217.md): Bell 206L · Indianapolis, IN · Incident · No injuries · Incident investigation · Final report · Aug 19, 1988 · N295CK · No damage - [NTSB MIA88IA176](https://openairdocs.org/ntsb/MIA88IA176.md): Airbus Industrie A-300 · Near San Juan, PR · Incident · No injuries · Incident investigation · Final report · May 23, 1988 · N209PA · 2 aircraft · No damage > Pan am flt 217 (Airbus A300, N209PA) was clrd by new york center oceanic ctl area (oca) to proceed south on airway amber 300 at FL 290 over the atlantic ocean. As it was en route, American flt 902 departed san Juan (sju), PR for a northbound flt on the same… - [NTSB MIA88IA168](https://openairdocs.org/ntsb/MIA88IA168.md): Piper PA-42-720 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 11, 1988 · N900MP · 2 aircraft · No damage > Condor flt 610 (Mcdonnell Douglas DC-10, german registration: dadso) was aprx 2 hrs late as the flt crew members were preparing to takeoff. Subsequently, flt 610 was clrd for takeoff with instructions to cross the 5 DME (on the standard instrument… - [NTSB MIA88IA167](https://openairdocs.org/ntsb/MIA88IA167.md): Beech 200 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 10, 1988 · N981LL · 2 aircraft · No damage > Midway flt 172 (Mcdonnell Douglas DC-9, N1065T) was on an IFR departure from Chicago midway arpt at the same time that Beech 200, N981LL, was on an IFR arrival for a visual apch to merrill c meigs arpt, although both were in VMC. Previously, o'hare TRACON had… - [NTSB NYC88IA109](https://openairdocs.org/ntsb/NYC88IA109.md): Boeing 737 · Morristown, NJ · Incident · No injuries · Incident investigation · Final report · Mar 19, 1988 · N69348 · 2 aircraft · No damage > Boeing 737 (N69348) was depg newark intl arpt as a lear jet 24 (N500NH) was depg fm teterboro. Both were being ctld by new york TRACON (newark sector). The strip for the 737 was mismarked as a north departure rather than an east departure. The instructor/full… - [NTSB ATL88IA108](https://openairdocs.org/ntsb/ATL88IA108.md): Boeing 737 · Greensboro, NC · Incident · No injuries · Incident investigation · Final report · Mar 10, 1988 · N13331 · 2 aircraft · No damage > Continental flt 458 (Boeing 737, N13331) was flying NE at FL370 as Continental flt 703 (Boeing 737, N432PE) was flying fm the opposite drctn at FL350. Both flts were on the same freq, being ctld by atlanta ARTCC (sector 47) ctlr, who had just come on duty. In… - [NTSB CHI88IA074](https://openairdocs.org/ntsb/CHI88IA074.md): Swearingen SA226T · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 7, 1988 · N600TA · 2 aircraft · No damage > The TRACON supervisor failed to comply with the established visual minima criteria and his incorrect issuance of a visual approach to an arriving aircraft. - [NTSB CHI88IA073](https://openairdocs.org/ntsb/CHI88IA073.md): Boeing 747-227B · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Feb 19, 1988 · N635US · 2 aircraft · No damage > Failure of the tower cab supervisor to assure that coordination between the south local controller and north local controller had been completed. A factor is the failure of FAA tower management to insure there were personnel manning the cab coordinator… - [NTSB MIA88IA099](https://openairdocs.org/ntsb/MIA88IA099.md): Beech C-99 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Feb 4, 1988 · N232BH · 2 aircraft · No damage > Drg a visual apch to Orlando intl arpt, bar harbor flt 3949 (Beech C-99, N232BH) contacted the tower (local controller) at 1817:07 & rprtd 5 mi north of the VOR for landing. The VOR was located 5.8 mi north of the rwy. About 20 sec later, the local controller… - [NTSB BFO88IA012](https://openairdocs.org/ntsb/BFO88IA012.md): Mcdonnell Douglas DC-9-32 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Dec 5, 1987 · N924L · 2 aircraft · No damage > Twa flt 388 (DC-9, N924L) was in clouds climbing to 7000' when Baltimore (bwi) TRACON adzd that an acft (Piper PA-28R) was straight ahead at 3 mi dscndg fm 6700'. Flt 388 had passed 6000' & the capt requested a traffic avoidance vector. The TRACON ctlr… - [NTSB MIA88IA055](https://openairdocs.org/ntsb/MIA88IA055.md): Mcdonnell Douglas DC-9-82 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Nov 1, 1987 · N806NY · 2 aircraft · No damage > At 1710:53 EST, the LCL twr ctlr (lc) at the Newark intl arpt clrd Continental flt 321 (DC-9-82, N806NY) for takeoff on rwy 22L; 11 sec later, Continental flt 688 (Boeing 727, N577PE) rprtd 'left downwind for rwy 29.' Lc told flt 688 to 'maintain 1500 as you… - [NTSB CHI88IA015](https://openairdocs.org/ntsb/CHI88IA015.md): Boeing 737-322 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Oct 29, 1987 · N305UA · 2 aircraft · No damage > The south rwys (32L, 9R, & 4R) were being ctld by the south LCL ctlr (slc) & the north rwys (9L & 4L) were ctld by the north LCL ctlr (nlc). At 1543:26, slc told united flt 973 (Boeing 737) to hold on 32L & expect a 3 min delay bfr tkof. Air Wisconsin flt 954… - [NTSB MIA88IA020](https://openairdocs.org/ntsb/MIA88IA020.md): Boeing 727-214 · St Croix · Incident · No injuries · Incident investigation · Final report · Oct 28, 1987 · N375PA · 2 aircraft · No damage > Paa flt was on visual apch and in contact with apch control who informed flt of two acft ahead also on visual apch. The controller offered vectors to clear traffic. Paa flt elected to continue current heading. The two preceding acft were on twr freq giving… - [NTSB LAX88IA009](https://openairdocs.org/ntsb/LAX88IA009.md): Mcdonnell Douglas DC-9-82 · Ontario, CA · Incident · No injuries · Incident investigation · Final report · Oct 9, 1987 · N413AA · No damage > Failure of the general aviation aircraft to visually identify the transport aircraft. Factures contributing to the incident were: failure of the general aviaiton aircraft to establish communications with ATC prior to entering the arsa and maintaining a poor… - [NTSB MIA87IA264](https://openairdocs.org/ntsb/MIA87IA264.md): Boeing 727-225 · Hampton, NY · Incident · No injuries · Incident investigation · Final report · Sep 29, 1987 · N8864E · 2 aircraft · No damage > A full performance level controller (fpl ctlr) at sector 31 of boston ARTCC was giving familiarization training to another fpl ctlr to familiarize the trainee with a new area that had been transferred from new york ARTCC to boston ARTCC. Sector 31 was… - [NTSB ATL87LA236](https://openairdocs.org/ntsb/ATL87LA236.md): Cessna A185F · Mt Airy, NC · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N3463Y · Substantial damage > After Cessna 185, N3462Y, entered the traffic pattern for rwy 18, the UNICOM operator warned the plt of another acft in the pattern. The other acft was a Mooney mite, N4129. The Cessna plt contd his apch, but didn't see the Mooney mite until after the Cessna… - [NTSB LAX87IA304](https://openairdocs.org/ntsb/LAX87IA304.md): Boeing 737 · Santa Monica, CA · Incident · No injuries · Incident investigation · Final report · Aug 12, 1987 · N754UA · No damage > The plts of a Boeing 737 reported that a near-collision occurred aprx 2.5 miles east of the Santa Monica VOR while they were descending through an altitude of about 7400 ft MSL. The coplt saw the other acft first & took immediate evasive action. He estimated… - [NTSB NYC87IA227](https://openairdocs.org/ntsb/NYC87IA227.md): Boeing 747 · New York, NY · Incident · No injuries · Incident investigation · Final report · Aug 9, 1987 · N93109 · 2 aircraft · No damage > Acft with similar call signs (twa flts 843H & 834; Boeing 747 & Boeing 727) apchd jfk intl arpt for ldg. Flt 843H was 22MIN late & flt 834 was 12 min early, causing same arr time. NY TRACON vctrd flt 834 bhnd flt 843H. While ctlg the acft, jfk final ctlr,… - [NTSB CHI87IA188](https://openairdocs.org/ntsb/CHI87IA188.md): Boeing 727-233 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Aug 8, 1987 · CGYNE · 2 aircraft · No damage > Air Canada flt 839 (Boeing 727, c-gyne) was depg Chicago o'hare intl arpt as Cessna 650 (citation), N20AT, was depg palwaukee (pwk) arpt, about 8 mi north of o'hare. Both flts tkof with IFR flt plans. Bfr the citation tkof, the pwk twr ctlr ctcd the TRACON… - [NTSB CHI87IA183](https://openairdocs.org/ntsb/CHI87IA183.md): Mcdonnell Douglas DC-10-10 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Aug 3, 1987 · N113AA · 2 aircraft · No damage > After ldg the co B727 was directed to make two right turns and follow an acft that had landed in front of him. The pilot made one right turn and taxied down an empty runway. This taxi route crossed an active runway. An aa#DC-10 on takeoff roll, at 110 knots,… - [NTSB NYC87IA199](https://openairdocs.org/ntsb/NYC87IA199.md): Douglas DC-10-30 · Atlantic Ocean (Atlantic Ocean) · Incident · No injuries · Incident investigation · Final report · Jul 9, 1987 · YV135 · 2 aircraft · No damage > A Mcdonnell Douglas DC-10 (viasa flt 800) & an Airbus A310 (pan am flt 221) were involved in a near collision while on intl flts ovr the Atlantic Ocean on (airway) amber 300. Both acft were operg under IFR & were in a non-radar environmentw/o drct radio ctc… - [NTSB ATL87IA179](https://openairdocs.org/ntsb/ATL87IA179.md): Boeing 727-232 · Nashville, TN · Incident · No injuries · Incident investigation · Final report · Jun 19, 1987 · N482DA · 2 aircraft · No damage > At aprx 2211 CDT, delta flt 314 (Boeing 727, N482DA) was clrd to taxi to rwy 31 with info india. Info india indcd rwy 31WAS active. Soon thereafter, southwest flt 715 (Boeing 737, N50SW) reqd & recd taxi clnc to rwy 13 for tkof. To accommo-date incoming… - [NTSB DEN87IA145](https://openairdocs.org/ntsb/DEN87IA145.md): Boeing 727-251 · Casper, WY · Incident · No injuries · Incident investigation · Final report · Jun 2, 1987 · N297US · 2 aircraft · No damage > Boeing 727 (northwest flt 354) & USAF EC-135 (slum 51) were involved in a nr collision at FL 330. The mishap occurred asflt 354 was ene bnd on J-158 & slum 51 was flying on a radial-distance (r/d) flt pln, flying btn r/d pts south of J-158.as slum 51 apchd… - [NTSB CHI87IA135](https://openairdocs.org/ntsb/CHI87IA135.md): Mcdonnell Douglas DC-9-82 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 30, 1987 · N224AA · No damage > American flt 637 was on departure from Chicago-o'hare intl arpt (ord), climbing thru 7300' MSL, when it passed American flt 393 with aprx 500' vertical sepn & 1/4 mi horizontal sepn. This occurred after an air traffic assistant, who was working the clnc… - [NTSB NYC87IA118](https://openairdocs.org/ntsb/NYC87IA118.md): de Havilland DHC-7-102 · Wrightstown, NJ · Incident · Minor injuries · Incident investigation · Final report · Apr 8, 1987 · N42RA · 2 aircraft · Minor damage > Ransom flt 444 (DHC-7) rprtd a near collision with USAF C-141 (gleek 41) as flt 444 was at 5000' & gleek 41 was clbg to 7500' fm a combat aircrew training (cat) mnvr. Flt 444 was under IFR ctl of mcguire afb rapcon; gleek 41 was VFR, rcvg radar adzys fm… - [NTSB CHI87IA109](https://openairdocs.org/ntsb/CHI87IA109.md): Boeing 727-222 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Apr 7, 1987 · N7258U · No damage > A 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… - [NTSB CHI87IA112](https://openairdocs.org/ntsb/CHI87IA112.md): Dassault-Breguet 50 · Cleveland, OH · Incident · No injuries · Incident investigation · Final report · Mar 31, 1987 · N52DC · No damage > An opnl error developed as a falcon 50, N52DC, was proceeding se toward the dryer VOR at FL290 & northwest flt 427 was proceeding westbound at the same alt toward the same fix (dryer VOR). When the full performance lvl (fpl) controller (ctlr) saw the… - [NTSB ATL87IA020](https://openairdocs.org/ntsb/ATL87IA020.md): Boeing 727-227 · Livingston, TN · Incident · No injuries · Incident investigation · Final report · Nov 12, 1986 · N471BN · 2 aircraft · No damage > The 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… - [NTSB ANC87IA012](https://openairdocs.org/ntsb/ANC87IA012.md): Mcdonnell Douglas DC-10 · Adak, AK · Incident · No injuries · Incident investigation · Final report · Nov 10, 1986 · CGCPJ · 2 aircraft · No damage > A canadian pacific Mcdonnell Douglas DC-10 (flt 3), cg-cpj, & a reeve aleutian Boeing 727 (flt 724), N832, were clrd to fly at FL 290 on 2 different airways. The airways crossed at picum intxn, ovr the bearing sea. While traveling in nrly opposite drctns at… - [NTSB LAX87IA027](https://openairdocs.org/ntsb/LAX87IA027.md): Boeing 727-222 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Oct 29, 1986 · N7255U · 2 aircraft · No damage > Drg 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… - [NTSB CHI86IA225](https://openairdocs.org/ntsb/CHI86IA225.md): Boeing 727-25 · Evansville, IN · Incident · No injuries · Incident investigation · Final report · Sep 18, 1986 · N8107N · No damage > After the aircrew of eastern flt 254 (a Boeing 727, N8107N) had landed on rwy 22 at night & was slowing, the tower controller (ctlr) instructed them to 'turn right on taxiway bravo, if able, hold short of rwy 18 and remain this frequency.' The crew of flt 254… - [NTSB CHI86MA216](https://openairdocs.org/ntsb/CHI86MA216.md): Boeing 737-222 · Lansing, MI · Incident · No injuries · Major investigation · Final report · Aug 30, 1986 · N749N · 2 aircraft · No damage > Piedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound… - [NTSB BFO86IA031](https://openairdocs.org/ntsb/BFO86IA031.md): Douglas DC-9-31 · Calverton, NY · Incident · No injuries · Incident investigation · Final report · May 30, 1986 · N1310T · 2 aircraft · No damage > N1031T a DC-9-31, was in a descent for landing at jamaica, NY. The captain reported he heard a noise that he thought was a failing cabin door pressure seal and advised the copilot. The copilot indicated he thought the noise was the soundof a jet eng. Between… - [NTSB CHI86MA142](https://openairdocs.org/ntsb/CHI86MA142.md): Mcdonnell Douglas DC-9-31 · Chicago, IL · Incident · No injuries · Major investigation · Final report · May 17, 1986 · N973VJ · 2 aircraft · Minor damage > U.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty… - [NTSB LAX86MA151](https://openairdocs.org/ntsb/LAX86MA151.md): Boeing 727-231 · Cincinnati, OH · Incident · No injuries · Major investigation · Final report · Mar 22, 1986 · N64315 · 2 aircraft · No damage > Indianapolis ctr (ctlr-a) clrd sluff 11 (S-11), a flt of 4 ANG A-7'S, to clb to FL210. Later, ctlr-a told S-11 to chg freq (to york low sector, ctlr-b). S-11 chgd freq, but neither S-11 nor ctlr-b established rdo contact with each other until S-11 had contd… - [NTSB ATL86IA100](https://openairdocs.org/ntsb/ATL86IA100.md): Boeing 737-200 · Nasville, TN · Incident · No injuries · Incident investigation · Final report · Mar 21, 1986 · N774N · 2 aircraft · No damage > A nr midair collision occurred aprx 38 mi se of the nashville metro arpt as a Boeing 737, piedmont flt 488, was dscndg thru aprx 12,000' & a flt of 4 F-4'S, call sign peach 41, were joining. Flt 488 was inbnd to nashville on an IFR clnc & memphis ARTCC had… - [NTSB SEA86FA052](https://openairdocs.org/ntsb/SEA86FA052.md): Cessna 195 · Black Diamond, WA · Accident · 1 fatal · Field investigation · Final report · Feb 1, 1986 · N4339N · Destroyed > Radar track shows C195 plt was descending into congested airspace at about 192 mph, above max structural cruise speed of 178 mph, less than 1 min from traffic pattern entry. Radar data and witness confirm a second acft in proximity, engaged in aerobatics.… Next page: https://openairdocs.org/ntsb.md?occurrence=280&page=3 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 280) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?occurrence=280&page=2 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.