# NTSB investigations: Midair collision 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 8 of 9 · 435 cases ## Cases, newest first - [NTSB LAX85LA367](https://openairdocs.org/ntsb/LAX85LA367.md): Cessna 172P · Glendale, CA · Accident · No injuries · Limited investigation · Final report · Aug 26, 1985 · N62868 · 2 aircraft · Substantial damage > As the acft approached its home arpt, on a westerly heading and looking into the sun, the plt began the descent. The acft's left wing severed the left horizontal stabilizer and elevator from an approaching acft. The plt continued his approach and landed… - [NTSB ANC85FA163](https://openairdocs.org/ntsb/ANC85FA163.md): Cessna 180H · Mt. Palmer, AK · Accident · 6 fatal · Field investigation · Final report · Aug 25, 1985 · N417GP · 2 aircraft · Destroyed > Aircraft collided with Cessna 180 and crashed on mountain side about one-quarter mile apart. Piper was sightseeing and Cessna was spotting sheep. Scattered clouds were reported about 300 feet above the points of ground impact. - [NTSB MIA85FA233](https://openairdocs.org/ntsb/MIA85FA233.md): Cessna C-150 · Kissimmee, FL · Accident · No injuries · Field investigation · Final report · Aug 12, 1985 · N704MH · 2 aircraft · Minor damage > The acft collided with another acft at about 300 ft AGL during the aproach to a practice precision lndg. After the collision both acft landed saftely. - [NTSB FTW85MA317](https://openairdocs.org/ntsb/FTW85MA317.md): Beech 200 · Quinlan, TX · Accident · 3 fatal · Major investigation · Final report · Aug 12, 1985 · N100HC · 2 aircraft · Destroyed > N100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed… - [NTSB CHI85LA291](https://openairdocs.org/ntsb/CHI85LA291.md): Balloon Works Firefly 6B · Battle Creek, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1985 · N1533S · 2 aircraft · Substantial damage > The envelope of Balloon N1533S was penetrated and torn by the basket of Balloon i-frog. The envelope was damaged to the degree that altitude could not be sustained. The aeronqut of N1533S was seriously injured upon ground impact. I-frog was landed without… - [NTSB FTW85FA261](https://openairdocs.org/ntsb/FTW85FA261.md): Cessna 150 · Temple, TX · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1985 · N8496J · 2 aircraft · Substantial damage > A midair collision occurred between a Cessna 150 in the traffic pattern and a Cessna 152 on a long low final to the same runway. The Cessna 152'S radio was mistuned, and the Cessna 150 had no radio installed. Neither could have heard warnings broadcast by… - [NTSB NYC85FA145](https://openairdocs.org/ntsb/NYC85FA145.md): Sikorsky S76A · Belmar, NJ · Accident · 1 fatal · Field investigation · Final report · Jun 11, 1985 · N176FJ · 2 aircraft · Substantial damage > During takeoff & landing practice for a pre-solo plt the CFI saw a helicopter, N176FJ, approaching the arpt. N4956B, at the time of 1st sighting, was on a left base for rwy 3. The rotorcraft apparently did not see N4956B or hear any radio calls at this… - [NTSB FTW85FA230](https://openairdocs.org/ntsb/FTW85FA230.md): Piper PA-28-140 · Junction City, KS · Accident · 1 fatal · Field investigation · Final report · May 22, 1985 · N7053R · 2 aircraft · Destroyed > Army UH-1V and N7053R, a Piper PA-28, collided in mid air at 700 feet AGL. Both acft were in lvl flt. UH-1V was operating on a medical evacuation flt with a crew of four, one patient and two attendants. The UH-1V executed a successful autorotation with… - [NTSB ANC85LA109](https://openairdocs.org/ntsb/ANC85LA109.md): Cessna 207 · Emmonak, AK · Accident · No injuries · Limited investigation · Final report · May 12, 1985 · N9975M · 2 aircraft · Minor damage > The pilot-in-command stated he was passed by the airplane N9975M and did not see it again until he was at his right rear and slightly below. The propeller of N9975M struck the aileron and during the evasive maneuvering the left main gear of N9975M struck the… - [NTSB LAX85FA239](https://openairdocs.org/ntsb/LAX85FA239.md): Earnst Skybolt · Paso Robles, CA · Accident · No injuries · Field investigation · Final report · May 4, 1985 · N10DE · 2 aircraft · Substantial damage > A Cessna 150 and a home built skybolt acft collided while on a downwind leg of a traffic pattern to land. The skybolt was a competitor in a local aerobatic competition east of the arpt. The C-150 was returning from a student plt training x-country flt. Both… - [NTSB CHI85FA185](https://openairdocs.org/ntsb/CHI85FA185.md): Beech B35 · Sussex, WI · Accident · No injuries · Field investigation · Final report · May 2, 1985 · N5182C · 2 aircraft · Substantial damage > A student plt was on his 1st solo x-country flt in a Cessna 152, N6464L. After taking off at the brookfield arpt (elev 850 ft), he had climbed to 2000 ft MSL & was heading 350 deg when he saw a Beech B35 (bonanza), N5182C, converging from his right. The… - [NTSB CHI85FA176](https://openairdocs.org/ntsb/CHI85FA176.md): Cessna R182 · Prairie Dusac, WI · Accident · 1 fatal · Field investigation · Final report · Apr 26, 1985 · N4707T · 2 aircraft · Substantial damage > This midair collision occurred approx 2 mi NE of sauk-Prairie apt. The pilots of the Cessna were in a climbing right departure turn at approx 1600 ft MSL heading approx 120 deg when a collsion occurred with a Piper heading approx 270 deg and descending. One… - [NTSB LAX85FA202](https://openairdocs.org/ntsb/LAX85FA202.md): Cessna 172M · Camp Verde, AZ · Accident · 2 fatal · Field investigation · Final report · Apr 14, 1985 · N73708 · 2 aircraft · Destroyed > Both acft involved in the collision were part of a 4-plane formation flt en route to a group fly-in. N6439R was seen to change positions several times during the flt while the other acft remained stable. Reports from witnesses say that N6439R made 'close… - [NTSB FTW85FA117](https://openairdocs.org/ntsb/FTW85FA117.md): Piper PA-32RT-300 · Healdton, OK · Accident · 3 fatal · Field investigation · Final report · Feb 12, 1985 · N39516 · 2 aircraft · Destroyed > The acft collided at 4,500 ft MSL within aprx 15 degrees of head-on. VMC with 30 mi visibility existed with plt reported winds aloft as being light from the west. En route recorded data indicated that N39516 was on a true course of 180 deg and N1162N was on a… - [NTSB LAX85FA123](https://openairdocs.org/ntsb/LAX85FA123.md): Cessna 120 · Irwindale, CA · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1985 · N9058Y · 2 aircraft · Destroyed > A Cessna 120, N9058Y, & a Cessna 152, N65599, collided in midair in the practice area for el monte, CA. Arpt. The two aircraft had departed the controlled arpt within three minutes of each other. Both had one instructor & one student aboard. The Cessna 152… - [NTSB DEN85IA025](https://openairdocs.org/ntsb/DEN85IA025.md): Aerospatiale SA315B (Lama) · Oak City, UT · Incident · Minor injuries · Incident investigation · Final report · Nov 11, 1984 · N5785V · 2 aircraft · Minor damage > Both acft were performing external load operations. N5785V was in level flt to the north. N9362 was in a 60-70 kt slight climb to the southeast. Neither plt, both in rt seats, saw the other acft before contact. Three main rotor blades of N5785V passed through… - [NTSB ATL85FA007](https://openairdocs.org/ntsb/ATL85FA007.md): Piper PA-28-151 · Morgantown, NC · Accident · 2 fatal · Field investigation · Final report · Oct 11, 1984 · N32828 · 2 aircraft · Destroyed > N2553A was in traffic pattern conducting touch and go landings. N32828 was maneuvering below the traffic pattern and was seen climbing in direction of N2553A. N32828 was flying westerly into the sun. N2553A was seen in a shallow left turn from crosswind to… - [NTSB MKC84FA272](https://openairdocs.org/ntsb/MKC84FA272.md): Cessna 195A · Akron, IA · Accident · 2 fatal · Field investigation · Final report · Sep 9, 1984 · N19JW · 2 aircraft · Destroyed > N19JW, a Cessna 195A and N8783X, a Cessna 182 departed mapleton, IA, at aprx 0805 on a VFR flt to Akron, IA, to attend a fly-in breakfast. The two acft did not travel the same route of flight to Akron, N19JW crossed over the midpoint of the arpt on crosswind… - [NTSB SEA84FA215](https://openairdocs.org/ntsb/SEA84FA215.md): Piper PA-28-180 · The Dalles, OR · Accident · 6 fatal · Field investigation · Final report · Sep 1, 1984 · N6499J · 2 aircraft · Destroyed > N6499J departed The Dalles municipal arpt shortly after 0930 PDT on a flt to vancouver, WA. N4622T departed chenoweth airfield ( aprx 4 NM west of The Dalles) at about 0930 PDT on a flt to The Dalles municipal arpt. A witness who observed both acft before the… - [NTSB NYC84FA293](https://openairdocs.org/ntsb/NYC84FA293.md): Cessna 150M · Meriden, CT · Accident · No injuries · Field investigation · Final report · Aug 26, 1984 · N45288 · 2 aircraft · Minor damage > A cesnna N45288 was above and slightly to the rear of Cessna N4669V when they collided on final approach over the displaced threshold to runway 36 at mmk. Both aircraft landed without further incident. There were no injuries. - [NTSB MIA84FA241](https://openairdocs.org/ntsb/MIA84FA241.md): Cessna 152 · Valdosta, GA · Accident · 4 fatal · Field investigation · Final report · Aug 25, 1984 · N25853 · 2 aircraft · Destroyed > The two acft collided about a mile east of the arpt on the downwind leg of the traffic pattern. One of the acft, N25853,called Valdosta radio and reported left downwind for rwy 17.Valdosta advised that another acft had just departed rwy 17 2 minutes prior.… - [NTSB DCA84AA034](https://openairdocs.org/ntsb/DCA84AA034.md): Beech C-99 · San Luis Obispo, CA · Accident · 17 fatal · Class 1 · Final report · Aug 24, 1984 · N6399U · 2 aircraft · Destroyed > At about 1118, a Beech C-99 (wings west flt 628), N6399U, & a rockwell 112TC, N112SM, collided in midair aprx 8 mi west-northwest of the san loui Obispo county arpt. The rockwell 112TC had departed paso robles, CA & was descending toward the san loui Obispo… - [NTSB MKC84FA240](https://openairdocs.org/ntsb/MKC84FA240.md): Cessna A188B · Stonewall, AR · Accident · Minor injuries · Field investigation · Final report · Aug 5, 1984 · N8145G · 2 aircraft · Substantial damage > While engaged in aerial application, two acft working the same field collided in-flight. Pre-flight planning and briefing for the dual operation was not conducted. There were no inter-plane communications. - [NTSB MKC84FA229](https://openairdocs.org/ntsb/MKC84FA229.md): Piper PA 36-375 · Bertrand, NE · Accident · 1 fatal · Field investigation · Final report · Jul 23, 1984 · N3930E · 2 aircraft · Substantial damage > N3930E and N3968E had departed as a flight of two for aerial application. There was no record of preflight briefing or coordination planning. At completion of operations on the object field, N3930E advised N3968E by radio that he was making a final cleanup… - [NTSB SEA84FA172](https://openairdocs.org/ntsb/SEA84FA172.md): Schempp-Hirth Ventus A · Ephrata, WA · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1984 · N17KS · 2 aircraft · Minor damage > A 'gaggle' of about 7 gliders were maneuvering in a climb when N919R climbed into the group. The plt of N17KS said he saw N919R closing and increased his angle of bank to about 100 degrees to try and avoid a collision. The leadingedge of the left wing of… - [NTSB LAX84FA378](https://openairdocs.org/ntsb/LAX84FA378.md): Cessna 182Q · Richmond, CA · Accident · 2 fatal · Field investigation · Final report · Jul 5, 1984 · N95726 · 2 aircraft · Substantial damage > These two acft were flying between 1500 and 2000 ft AGL when they collided over Richmond, CA. N103PD was on police surveillance circling to the left. N95726 was on a x-country flying a heading of about 350 degrees. The collision tore the right wing tip off of… - [NTSB SEA84LA159](https://openairdocs.org/ntsb/SEA84LA159.md): Applebay Sailplanes Zuni II · Ephrata, WA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1984 · N22HL · 2 aircraft · Substantial damage > The two gliders collided while thermaling in vicinity of each other while engaged in a contest. According to the plts they lost sight of each other while spiraling in the lift. Both acft landed safely. The collision was nose to tail. - [NTSB CHI84FA250](https://openairdocs.org/ntsb/CHI84FA250.md): Grumman G-164B · Warren, MN · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1984 · N6533K · 2 aircraft · Destroyed > N9367K was on departure and climbout to aerial application operations. N6533K was about to enter the traffic pattern to land and reload. Marks on respective airframes indicate N9367K was above and approaching N6533K from the latter's forward left quarter;… - [NTSB MKC84LA178](https://openairdocs.org/ntsb/MKC84LA178.md): Snow AT400 · Portland, AR · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N501PR · 2 aircraft · Substantial damage > Both acft were about to touch down. N501PR was above N501JS. The pilot of N501PR stated that just before touchdown the collision occurred and resulted in severing of the tail section of N501PR. The pilot of 501JS stated N501PR flared out to land directly in… - [NTSB CHI84FA225](https://openairdocs.org/ntsb/CHI84FA225.md): Schleicher AS-K13 · Stanton, MN · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1984 · N3313 · 2 aircraft · Destroyed > The tow plane and the sailplane it had towed to pattern alt collided on final approach of the pattern. The tow plane was supposed to follow the sailplane to land after it had dropped the tow rope. There was a low sun glare facing the towplt on the heading of… - [NTSB ANC84FA080](https://openairdocs.org/ntsb/ANC84FA080.md): Cessna 180G · Tyonek, AK · Accident · 2 fatal · Field investigation · Final report · Jun 2, 1984 · N4708U · 2 aircraft · Destroyed > Taking off from an abandoned road near a fishing camp, the Cessna turned back and descended with power on over his departure point, heading into the sun which was low on the horizon. It collided left wing to left wing with the Maule which had climbed out at a… - [NTSB LAX84FA319](https://openairdocs.org/ntsb/LAX84FA319.md): Cessna 152 · Half Moon Bay, CA · Accident · 2 fatal · Field investigation · Final report · May 28, 1984 · N5157B · 2 aircraft · Destroyed > The two acft collided after N1920Y declared his intention to takeoff and was airborne aprx Half way down the rwy. The other acft was in a steep descent at mid-field when he dove into N1920Y. Both acft then crashed uncontrolled into the ground from an alt of… - [NTSB LAX84LA313](https://openairdocs.org/ntsb/LAX84LA313.md): Cessna 172N · Ballard, CA · Accident · No injuries · Limited investigation · Final report · May 22, 1984 · N73857 · 2 aircraft · Minor damage > The pilot of N73857, a Cessna 172 and the pilot of N521ST, a Cessna 305 arranged prior to the flight to fly a 'missing man' formation with two other aircraft. The plt of N73857 was instructed to fly to the left rear of the lead acft, N521ST. The pilot of… - [NTSB ANC84FA073](https://openairdocs.org/ntsb/ANC84FA073.md): Piper PA-18-150 · Platinum, AK · Accident · 2 fatal · Field investigation · Final report · May 21, 1984 · N82454 · 2 aircraft · Destroyed > The herring season was to open at 1600 hrs. According to witnesses, about 30 acft were circling in left turns over merging schools of herring while the plts & their respective boat crews were awaiting the opening signal. The acft were circling under a low… - [NTSB ANC84FA059](https://openairdocs.org/ntsb/ANC84FA059.md): Cessna 152 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Apr 25, 1984 · N45928 · 2 aircraft · Substantial damage > A student plt in a Cessna 152, N45928, was inbound to land on rwy 33 at merrill field at the same time that another student plt in Cessna 152, N6479L, was departing from rwt 15. The student in N6479L was cleared for a 'city high' departure. After taking off,… - [NTSB LAX84LA245](https://openairdocs.org/ntsb/LAX84LA245.md): Beech E18S · Buellton, CA · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N8711 · 2 aircraft · Substantial damage > These acft collided in flt while being ferried. The weather was VMC. N8711 was damaged substantially and N753CW receivedminor damage. Both acft landed at santa ynez arpt where N8711 lost control during rollout and ran off the rwy. N753CW was landed with the… - [NTSB MIA84LA127](https://openairdocs.org/ntsb/MIA84LA127.md): Bucker Flugzeugbau Jungmann · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Apr 2, 1984 · N1947G · 2 aircraft · Minor damage > The plts of a Bucker jungmann, N1947G, & a pitts S-2B, N5302M, were practicing for an airshow. They began a maneuver called a 'mirror fly-by' in which the Bucker was rolled upside down & the pitts was flown underneath it. Due to the air flow over the wings… - [NTSB NYC84LA147](https://openairdocs.org/ntsb/NYC84LA147.md): Cessna 152 · Fitchburg, MA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N45945 · 2 aircraft · No damage > The plt of N45945 stated that upon entering downwind for rwy 32 she reported her position on UNICOM, but did not receivea reply. She continued her approach failing to report base and final positions. At aprx 500 ft on final apch she felt the acft buffet and… - [NTSB ATL84FA119](https://openairdocs.org/ntsb/ATL84FA119.md): Piper PA-31T · Benson, NC · Accident · No injuries · Field investigation · Final report · Mar 7, 1984 · N9162Y · 2 aircraft · Substantial damage > A Piper PA-31T, N9162Y, and a Beech 200C, N390AC, were involved in a midair collision while both were cruising at 17,500 ft in unlimited visibility. The Piper was tracking inbound on the 210 deg radial of the richmond VOR. The Beech was tracking inbound on… - [NTSB FTW84LA155](https://openairdocs.org/ntsb/FTW84LA155.md): Cessna 152 · Durant, OK · Accident · No injuries · Limited investigation · Final report · Mar 2, 1984 · N4861B · 2 aircraft · Substantial damage > Before takeoff, a student & a commercial plt agreed to rendezvous & fly formation while the student took pictures of the commercial plt's acft. The student was to fly a Cessna 152, N4861B, while the commercial plt flew a Cessna 150, N704V6. They planned for… - [NTSB SEA84FA060](https://openairdocs.org/ntsb/SEA84FA060.md): Cessna 172N · Kent, WA · Accident · 3 fatal · Field investigation · Final report · Feb 24, 1984 · N4603F · 2 aircraft · Destroyed > At about 1345 PST, the plt of a Cessna 172N, N4603F, departed crest airpark, Kent, WA, on a local pleasure flt. Aprx 5 min later, the plt & 1 passenger of a float equipped Cessna 180, N4908A, took off from lake meridian, Kent, WA, & were also on a local… - [NTSB NYC84FA038](https://openairdocs.org/ntsb/NYC84FA038.md): Cessna 172P · Silver Greek, NY · Accident · 4 fatal · Field investigation · Final report · Nov 27, 1983 · N96268 · 2 aircraft · Destroyed > The two acft were involved in a midair collision near Silver creek, NY. The plt of N4089P was flying in the left seat & using an instrument hood with a safety plt in the right seat. The plt of the other acft was on a pleasure flt with his daughter. Both acft… - [NTSB LAX84LA077](https://openairdocs.org/ntsb/LAX84LA077.md): Cessna TU206F · Riverside, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 1983 · N7320Z · 2 aircraft · Substantial damage > The plt of a Cessna TU206F, N7320Z, stated that he advised other traffic of his position & intentions on the UNICOM freq as he entered a straight-in apch to rwy 24. At about the same time, the plt of a pitts special S-1, N20JK, had returned from a local flt &… - [NTSB NYC84FA032](https://openairdocs.org/ntsb/NYC84FA032.md): Beech K35 · Stockholm, NJ · Accident · 2 fatal · Field investigation · Final report · Nov 18, 1983 · N106Q · 2 aircraft · Destroyed > At 1455 EST, a Beech K35 (bonanza), N106Q, & a Piper PA-34-200, N56670, collided while the acft were flying over the vicinity of the sparta VORTAC. The bonanza plt was on a local flt while the PA-34 was on multi-eng training flt. The student in the PA-34… - [NTSB FTW84FA001](https://openairdocs.org/ntsb/FTW84FA001.md): Cessna 152 · La Porte, TX · Accident · 1 fatal · Field investigation · Final report · Oct 2, 1983 · N6281Q · 2 aircraft · Destroyed > Cessna 152, N6281Q, & Piper PA-38, N9132A, were both on local, solo student flts. The plt of a 3rd acft, who was holding short for takeoff on rwy 12, observed the Cessna 152 & Piper PA-38 on final apch. Recognizing the potential for a mid-air collision, he… - [NTSB LAX83FA382](https://openairdocs.org/ntsb/LAX83FA382.md): Stinson 108-3 · Temecula, CA · Accident · No injuries · Field investigation · Final report · Aug 11, 1983 · N12HK · 2 aircraft · Substantial damage > A Stinson 108-3, N12HK, piloted by a private plt, & a Cessna 152, N46757, piloted by a student plt, collided while both acft were ruising at 5500 ft MSL. The private plt (of N12HK) reported he was on a magnetic heading 130 deg & was indicating 92 mph (about… - [NTSB LAX83FA373](https://openairdocs.org/ntsb/LAX83FA373.md): Cessna 152 · Fullerton, CA · Accident · No injuries · Field investigation · Final report · Aug 6, 1983 · N6539L · 2 aircraft · Substantial damage > N6539L, a Cessna 152, and N1172H a Piper PA-32R-300 collided with each other approx 2 mi west of the Fullerton municipal arpt, at an alt of approx 1200 ft AGL. Both plts rept clear skies, a bright night, and no restrictions to vis. Both plts stated they made… - [NTSB NYC83FA188](https://openairdocs.org/ntsb/NYC83FA188.md): Cessna U206G · Brooklyn, NY · Accident · 4 fatal · Field investigation · Final report · Jul 22, 1983 · N5328X · 2 aircraft · Destroyed > A Cessna U206G float plane, N5328X, & a bell 206A police helicopter, N4797R, collided in flt over Brooklyn, NY. The aircrew of the police helicopter were on a traffic observation flt & had just reported traffic conditions in the vicinity of a toll station… - [NTSB MIA83FU005](https://openairdocs.org/ntsb/MIA83FU005.md): Pterodactyl Ascender · Jacksonville, FL · Accident · Serious injuries · Final report · Jul 10, 1983 · UNREG · 2 aircraft · Destroyed > The plts of 2 high wing, pterodactle ascender, ultralight vehicles took off & were operating in a designated area for ultralights. One plt (plt-a) was making touch & go landings while the other plt (plt-b) was maneuvering in the vicinity. After plt-a made a… - [NTSB ATL83FA224](https://openairdocs.org/ntsb/ATL83FA224.md): Cessna 172 · Mocksville, NC · Accident · Serious injuries · Field investigation · Final report · Jun 8, 1983 · N5722T · 2 aircraft · Substantial damage > N5722T, a Cessna 172, and N3452J, a Cessna 150, collided over the approach end of runway 09 while both acft were on short final approach. Both acft impacted the runway and came to rest about 280 ft east of runway 09 threshold. Next page: https://openairdocs.org/ntsb.md?occurrence=270&page=9 ## 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" = 270) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?occurrence=270&page=8 --- 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.