# 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 7 of 9 · 435 cases ## Cases, newest first - [NTSB LAX87FA213](https://openairdocs.org/ntsb/LAX87FA213.md): Cessna P206 · Tehachapi, CA · Accident · 4 fatal · Field investigation · Final report · May 22, 1987 · N2520X · 2 aircraft · Destroyed > An USAF T-38 aircraft and a Cessna 206 aircraft collided in mid-air during visual flight operations in a military operations area. Radar data revealed that the overtaking T-38 collided with the Cessna 206 from the right. The Cessna was on a local government… - [NTSB MIA87FA153](https://openairdocs.org/ntsb/MIA87FA153.md): Cessna 152 · Lantana, FL · Accident · No injuries · Field investigation · Final report · May 2, 1987 · N152LG · 2 aircraft · Minor damage > The plt stated that he was at 60 KTS. With full flaps & just about to flare when somthing forced the nose down. He then pulled back on the controls, hit the ground, veered off the left side of the runway & collided with a C152 that was holding for takeoff,… - [NTSB DCA87MA029](https://openairdocs.org/ntsb/DCA87MA029.md): Cessna 340A · Orlando, FL · Accident · 4 fatal · Class 1 · Major · Final report · May 1, 1987 · N8716K · 2 aircraft · Destroyed > The two acft, a Cessna 340A and a north American SNJ-4, collided in flt at aprx 3000 ft MSL over Orlando FL in VMC with a visibility of 7 miles. Both acft were in contact with and being radar vectored by Orlando approach control. The C-340 was in level flt… - [NTSB ATL87FA130](https://openairdocs.org/ntsb/ATL87FA130.md): Cessna 182R · Kennesaw, GA · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1987 · N5511N · 2 aircraft · Destroyed > N5511N was in the traffic pattern at cobb county airport-mc collum field and was near the turning point from crosswind to dwnd when it was struck by N52995. N52995 was making a straight-in entry into the downwind leg of the traffic pattern from the west with… - [NTSB DEN87FA091](https://openairdocs.org/ntsb/DEN87FA091.md): Grumman G-164A · Lamar, CO · Accident · 1 fatal · Field investigation · Final report · Apr 8, 1987 · N8369 · 2 aircraft · Destroyed > The aircraft had completed a formation aerial application operation and were in the process of single airplane spraying around the perimeters of a field. They collided at 10 feet above the ground on perpendicular flight paths, descended out of control and… - [NTSB DCA87MA023](https://openairdocs.org/ntsb/DCA87MA023.md): Cessna 172N · Oakland, CA · Accident · 3 fatal · Class 1 · Major · Final report · Mar 31, 1987 · N75584 · 2 aircraft · Destroyed > At 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn… - [NTSB BFO87LA028](https://openairdocs.org/ntsb/BFO87LA028.md): Piper PA-23-250 · Dover, DE · Accident · No injuries · Limited investigation · Final report · Mar 29, 1987 · N5216Y · 2 aircraft · Substantial damage > The rockwell was in level flight at 2800 ft and the Piper was climbing when midair collision occurred. Neither acft was operating under ATC. Neither plt saw the otr acft before the collision occurred. The bottom of the rockwell cabin and the left tiptank of… - [NTSB NYC87FA098](https://openairdocs.org/ntsb/NYC87FA098.md): Cessna 402 · Montgomery, NY · Accident · No injuries · Field investigation · Final report · Feb 26, 1987 · N36139 · 2 aircraft · Minor damage > Both acft were operating under visual flight rules in the vicinity of active airports. The Cessna 402 was in a cruise descent. The decathlon was in level flight. Neither pilot in the 402 recalls seeing the decathlon, which was struck on the rt wing. The… - [NTSB NYC87FA061](https://openairdocs.org/ntsb/NYC87FA061.md): Piper PA-32-260 · Westerly, RI · Accident · No injuries · Field investigation · Final report · Jan 20, 1987 · N3293W · 2 aircraft · Minor damage > The Piper PA-32-260 was taking off from an uncontrolled airport and making a left downwind departure. A second aircraft, a Piper PA-28-181 was transiting the area 1 mile south of the airport an an altitude of 1500 ft AGL. The PA-28-181 saw the PA-32-260 just… - [NTSB DCA87MA020](https://openairdocs.org/ntsb/DCA87MA020.md): Piper PA-31-350 · Independence, MO · Accident · 6 fatal · Class 1 · Major · Final report · Jan 20, 1987 · N60SE · 2 aircraft · Destroyed > The two acft, a Beech U-21A and a Piper PA-31-350, collided nearly head on at 7000 ft MSL over Independence, MO. In daylight VMC conditions with a visibility of 20 miles. The U-21 was in level cruise and the PA-31 was climbing eastbound to an undisclosed alt… - [NTSB DCA87MA018](https://openairdocs.org/ntsb/DCA87MA018.md): Swearingen SA-226TC · Kearns, UT · Accident · 10 fatal · Class 1 · Major · Final report · Jan 15, 1987 · N163SW · 2 aircraft · Destroyed > The two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the… - [NTSB LAX87MA068](https://openairdocs.org/ntsb/LAX87MA068.md): Piper PA-28-181 · Long Beach, CA · Accident · No injuries · Major investigation · Final report · Dec 26, 1986 · N7646F · 2 aircraft · Substantial damage > A Piper PA-28-161, N7646F, and a Mooney M-20K, N231LY, collided near pader intersection abt 16 miles southwest of lgb airport. Both airplanes were conducting instrument flight training and none of the occupants were injured. N231LY had conducted an ILS… - [NTSB NYC87FA049](https://openairdocs.org/ntsb/NYC87FA049.md): Cessna 172M · Kingston, NY · Accident · 1 fatal · Field investigation · Final report · Dec 21, 1986 · N64342 · 2 aircraft · Destroyed > Cessna 172M, N64342, was on his initial climb after taking off on runway 33 at the uncontrolled Kingston-ulster airport when the pilot failed to see Cessna 177, N2981X, or hear, on the UNICOM frequency, the transmissions by N2981X who was on his final… - [NTSB ATL87FA038](https://openairdocs.org/ntsb/ATL87FA038.md): Cessna 185D · Hammonton, NJ · Accident · 2 fatal · Field investigation · Final report · Dec 7, 1986 · N5878T · 2 aircraft · Destroyed > The mid-air collision occurred while the Cessna 185 was attempting a steep climbout during takeoff from rwy 21 and the Mooney was making a landing to the same runway. Another aircraft attemped to warn both aircraft over the UNICOM freq. Neither aircraft… - [NTSB LAX87FA057](https://openairdocs.org/ntsb/LAX87FA057.md): Cessna 172N · Santa Paula, CA · Accident · No injuries · Field investigation · Final report · Nov 28, 1986 · N2371E · 2 aircraft · Substantial damage > A Cessna 172 & a Dehavilland gipsy moth collided at 150 ft. AGL while on short final approach to the uncontrolled arpt. On base leg the plt flying the moth failed to observe & yield the right of way to the Cessna which was already established on the final… - [NTSB FTW87FA022](https://openairdocs.org/ntsb/FTW87FA022.md): Cessna 172C · Amarillo, TX · Accident · Minor injuries · Field investigation · Final report · Nov 27, 1986 · N7709U · 2 aircraft · Destroyed > The certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of… - [NTSB LAX87FA040](https://openairdocs.org/ntsb/LAX87FA040.md): Boeing A75N1 · Corona, CA · Accident · Serious injuries · Field investigation · Final report · Nov 15, 1986 · N621SR · 2 aircraft · Substantial damage > The plt of N621SR said that as he entered the pattern downwind he saw only one low wing acft which was just turning final for rwy 25. On short final the plt said he noticed the wing and cockpit of the other acft in his left side periphial vision one second… - [NTSB NYC87FA027](https://openairdocs.org/ntsb/NYC87FA027.md): Piper PA-31-325 · Mansfield, MA · Accident · Serious injuries · Field investigation · Final report · Oct 30, 1986 · N200GG · 2 aircraft · Substantial damage > Piper PA-31, N200GG, was on a VFR flt to boston, MA. The PA-31 plt contacted boston TRACON & adzd he had ATIS info & would be lndg at boston. TRACON suggested a hdg & alt of 070 deg & 2500' for rwy 33R & told the plt to maint VFR. At aprx the same time, a… - [NTSB ATL87FA006](https://openairdocs.org/ntsb/ATL87FA006.md): Cessna 140A · Hamilton, OH · Accident · No injuries · Field investigation · Final report · Oct 19, 1986 · N9612A · 2 aircraft · Substantial damage > The Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft… - [NTSB CHI87FA004](https://openairdocs.org/ntsb/CHI87FA004.md): Piper PA-28-161 · Charleston, IL · Accident · 1 fatal · Field investigation · Final report · Oct 15, 1986 · N8267W · 2 aircraft · Substantial damage > N8267W was on practice NDB approach to rwy 29 under ATC clrnc with hooded stu at controls in left seat, ip in right seat, proceeding level at mda for low pass. Evidence indicates N30019 had entered downwind for rwy 24 and was in left turn VFR approach for rwy… - [NTSB ATL87FA001](https://openairdocs.org/ntsb/ATL87FA001.md): Piper J3-65C · Goldsboro, NC · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1986 · N70414 · 2 aircraft · Destroyed > The J-3 cub had been practicing touch and go landings at the uncontrolled airport when the Cessna 182 was returning from a cross-country flight. The pilot of the Cessna had received UNICOM airport advisories that indicated rwy 22 was the active runway. The… - [NTSB DCA86AA041](https://openairdocs.org/ntsb/DCA86AA041.md): McDonnell Douglas DC-9-32 · Cerritos, CA · Accident · 82 fatal · Class 1 · Final report · Aug 31, 1986 · XAJED · 2 aircraft · Destroyed > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/07. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm At… - [NTSB CHI86MA212](https://openairdocs.org/ntsb/CHI86MA212.md): Piper PA-31-T1 · Montgomery, NY · Accident · 1 fatal · Major investigation · Final report · Aug 29, 1986 · N284MC · 2 aircraft · Substantial damage > After canceling his IFR flight plan, the PA-31 pilot entered the traffic pattern for rwy 26 on a crosswind leg. He did not see any traffic on downwind as he entered the pattern. He visually cleared the area below and to his right while on downwind and as he… - [NTSB LAX86FA320](https://openairdocs.org/ntsb/LAX86FA320.md): Bellanca 7GCBC · Van Nuys, CA · Accident · No injuries · Field investigation · Final report · Aug 9, 1986 · N50443 · 2 aircraft · Substantial damage > Two plts, 1 flying Bellanca 7GCBC, N50443, the other flying champion 7KCAB, N443E, took their girl friends on a flt which included formation flying. The champion plt rprtd he flew formation with the Bellanca with aprx a 20' spread. Rprtdly, about half way… - [NTSB DEN86FA208](https://openairdocs.org/ntsb/DEN86FA208.md): Piper PA-46-310P · Boulder, CO · Accident · 1 fatal · Field investigation · Final report · Jul 26, 1986 · N4346L · 2 aircraft · Destroyed > The purpose of the flt for both acft was an aerial photo mission. N5113S was used as the camera platform. The plts of N5113S and N4346L discussed prior to takeoff the procedures of the flt. Both acft departed and flew a course to position the airplanes on a… - [NTSB DCA86AA028](https://openairdocs.org/ntsb/DCA86AA028.md): de Havilland DHC-6-300 · Grand Canyon, AZ · Accident · 25 fatal · Final report · Jun 18, 1986 · N76GC · 2 aircraft · Destroyed > At about 0933 MST, Dehavilland DHC-6, N76GC, (owned & operated by Canyon airlines) & bell 206B, N6TC, (operated by heliteck) collided while on sightseeing flts over the Grand Canyon national park. After colliding in flt, both acft crashed & burned in the… - [NTSB ANC86LA072](https://openairdocs.org/ntsb/ANC86LA072.md): Piper PA-18 · Fairbanks, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1986 · N8597D · 2 aircraft · Substantial damage > The pilots of each acft stated they thought that the left float and prop of the Taylorcraft had come in contact with the rt wing and rt landing gear of the Piper. The plts failed to see the other acft in time to avoid the collision. Both acft nosed over… - [NTSB MKC86FA123](https://openairdocs.org/ntsb/MKC86FA123.md): Cessna 140 · Des Arc, AR · Accident · 3 fatal · Field investigation · Final report · Jun 1, 1986 · N89247 · 2 aircraft · Destroyed > Numerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the… - [NTSB SEA86FA121](https://openairdocs.org/ntsb/SEA86FA121.md): Cessna 152 · Mead, WA · Accident · 2 fatal · Field investigation · Final report · May 20, 1986 · N6161M · 2 aircraft · Destroyed > Both acft were operating in VFR conditions modified by slight haze, high overcast and low sun angle near airport. N6161M was performing lazy eight maneuvers in a normal practice area two miles east of airport; N8267Q was in clockwise orbital descent for… - [NTSB FTW86FA086](https://openairdocs.org/ntsb/FTW86FA086.md): Cessna 172G · Blackwell, OK · Accident · 1 fatal · Field investigation · Final report · May 13, 1986 · N5878R · 2 aircraft · Destroyed > The pilot of N5878R, a Cessna 172G, had no previous experience in formation flying. The pilot of N2603E, an Aeronca 7AC, stated he had many hours of formation flying in the military during world war ii and has made an occasional formation flight since that… - [NTSB NYC86FA114](https://openairdocs.org/ntsb/NYC86FA114.md): Glaser-Dirks DIRK-DG-400 · Julian, PA · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1986 · N40MS · 2 aircraft · Destroyed > The plt of N686U reported he was established in weak thermal at an alt of aprx 2500 AGL when two other gliders were seen. One at aprx the same alt and one below his alt. He continued to state that the glider which was at his alt passed very close to but… - [NTSB LAX86LA189](https://openairdocs.org/ntsb/LAX86LA189.md): Cessna 195A · San Rafael, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 1986 · N4496C · 2 aircraft · Substantial damage > The two aircraft collided on the runway during landing approach. The Cessna pilot had washed his aircraft and had made a local flight to dry it off. The beeck pilot was returning from a nearby airport where an annual inspection had been performed. Witnesses… - [NTSB LAX86MA186](https://openairdocs.org/ntsb/LAX86MA186.md): LTV Aerospace Industries A7E · Warner Springs, CA · Accident · No injuries · Major investigation · Final report · Apr 20, 1986 · USN · 2 aircraft · Substantial damage > A rolladen-schneider LS-4 glider and an Ltv A7E jet collided over hot Springs mtn, near Warner Springs, CA. The A7E was attempting a rapid pull up and the glider was attempting a nose down, 30 deg right turn when they collided. Both aircraft were operating… - [NTSB ATL86FA116](https://openairdocs.org/ntsb/ATL86FA116.md): Cessna 150M · Gaston, SC · Accident · Minor injuries · Field investigation · Final report · Apr 19, 1986 · N714PU · 2 aircraft · Substantial damage > Two aircraft collided and were substantially damaged during landing flare/touchdown at the uncontrolled airport. Both aircraft flew a left hand traffic pattern at a pattern altitude of 1000 ft MSL. A witness to the accident related that one aircraft flew… - [NTSB FTW86FA066](https://openairdocs.org/ntsb/FTW86FA066.md): Grumman G164A · Hankamer, TX · Accident · 2 fatal · Field investigation · Final report · Apr 15, 1986 · N8751H · 2 aircraft · Destroyed > Two Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot… - [NTSB ATL86MA114](https://openairdocs.org/ntsb/ATL86MA114.md): Bell 206L-3 · Holliston, MA · Accident · 4 fatal · Major investigation · Final report · Apr 14, 1986 · N302MC · 2 aircraft · Destroyed > The Cessna 172 and a Bell 206L collided at 2,000 feet over Holliston, MA. Both aircraft were operating under visual flight rules with no flight plan or communications established with air traffic control. According to witnesses, the Bell was traveling in a… - [NTSB SEA86FA092](https://openairdocs.org/ntsb/SEA86FA092.md): Cessna 172P · Seattle, WA · Accident · 4 fatal · Field investigation · Final report · Apr 5, 1986 · N99034 · 2 aircraft · Destroyed > N99034 departed kenmore air harbor on a short local solo flight. Witnesses reported observing the aircraft takeoff and initiate a climb to the south. N65783 was returning from a recurrency check flight and was approaching from a southerly direction in a climb… - [NTSB FTW86FA049](https://openairdocs.org/ntsb/FTW86FA049.md): Spencer Pitts S-1 · Mckinney, TX · Accident · Serious injuries · Field investigation · Final report · Mar 28, 1986 · N66D · 2 aircraft · Substantial damage > As a pitts special, N66D, was in the traffic pattern to lnd, a Cessna L-19E towplane, N4431B, was on the 1300' grass overrun near the apch end of the rwy with a glider being readied for tow. The glider (sailplane) was a grob 103, N226BG.the plt of the pitts… - [NTSB CHI86FA100](https://openairdocs.org/ntsb/CHI86FA100.md): Cessna 172M · Lafox, IL · Accident · 2 fatal · Field investigation · Final report · Mar 8, 1986 · N72MA · 2 aircraft · Destroyed > An instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was… - [NTSB CHI86FA094](https://openairdocs.org/ntsb/CHI86FA094.md): Cessna 152 · Drayton Plaines, MI · Accident · 1 fatal · Field investigation · Final report · Mar 1, 1986 · N93604 · 2 aircraft · Destroyed > After a home built dragon fly gnd looped, other acft in the VFR traffic pattern were sent around, including a Cessna 152(C-152), N93604, flown by a student plt. Shortly after the dragon fly was clrd fm the rwy, Cessna 172 (C-172), N48003, entered the pattern,… - [NTSB FTW86FA027](https://openairdocs.org/ntsb/FTW86FA027.md): Cessna 172B · Caddo Mills, TX · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1985 · N6876X · 2 aircraft · Destroyed > Mid-air occurred at uncontrolled arpt with the S-2B executing rt traffic, as published, and the C-172 executing a long final or an arcing lft turn to final. Both acft were attempting to land on rwy 17R. Acdt occurred during late afternoon and there was… - [NTSB LAX86MA050](https://openairdocs.org/ntsb/LAX86MA050.md): Bell 206L-1 · San Pedro, CA · Accident · 1 fatal · Major investigation · Final report · Dec 1, 1985 · N3913Z · 2 aircraft · Destroyed > Two Bell 206L'S (N3913Z oprd by helitrans, N5759Y oprd by island express) deptd avalon 2 min apart on flts to San Pedro. Arr route at destn was ovr a RVR with angling fnl acph arnd a floating restaurant (fr). Heliport (HP) was in congested area nr bridge,… - [NTSB DCA86AA004](https://openairdocs.org/ntsb/DCA86AA004.md): Dassault Falcon 50 · Fairview, NJ · Accident · 6 fatal · Final report · Nov 10, 1985 · N784B · 2 aircraft · Destroyed > Dassalt falcon 50 (D50), N784B, was on vor/dme-a apch at dusk to circle/lnd at teterboro (teb), as Piper PA-28, N1977H, was transiting arpt traffic area (ata) fm west to east at 1500' in VFR (no flt pln). PA-28 plt was clrd thru ata by teb twr (staying blo… - [NTSB LAX86LA034](https://openairdocs.org/ntsb/LAX86LA034.md): Aerotek Pitts S-2A · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Nov 6, 1985 · N42XX · 2 aircraft · Substantial damage > During a dual instructional flight the CFI stated that he was looking for traffic while monitoring his student's performance. The CFI failed to observe that an acft was ahead of him in the traffic pattern. That acft was at a lower altitude & was on short… - [NTSB LAX86LA031](https://openairdocs.org/ntsb/LAX86LA031.md): Piper PA-28-181 · Angwin, CA · Accident · No injuries · Limited investigation · Final report · Nov 3, 1985 · N21491 · 2 aircraft · Minor damage > Near the completion of a dual instructional flt with a pre-solo student, the CFI followed the procedures recommended in the aim 7 & announced his Cessna acft's position over the CTAF stating his intentions & identifying his location on the 45 deg. Entry &… - [NTSB LAX86FA025](https://openairdocs.org/ntsb/LAX86FA025.md): Cessna 182P · Sacramento, CA · Accident · No injuries · Field investigation · Final report · Oct 25, 1985 · N7371S · 2 aircraft · Substantial damage > As the Cessna 182P pilot flew through a control zone without establishing communications at an altitude of 3,500 ft, a Piper PA28 was beginning its approach for landing. The Piper's pilot was practicing instrument flight using a hood and a safety pilot. The… - [NTSB FTW86MA001](https://openairdocs.org/ntsb/FTW86MA001.md): Cessna 441 · Dallas, TX · Accident · 5 fatal · Major investigation · Final report · Oct 1, 1985 · N400BG · 2 aircraft · Destroyed > A student plt in a Cessna 152, N5522L, had deptd redbird arpt at Dallas. He was practicing solo maneuvers in a privatelydesignated practice area that overlapped the extended inbnd course to rwys 31L & r at love field. At the same time, a Cessna 441, N400BG,… - [NTSB ATL85MA282](https://openairdocs.org/ntsb/ATL85MA282.md): Gates Learjet 35A · Auburn, AL · Accident · 2 fatal · Major investigation · Final report · Sep 22, 1985 · N873LP · 2 aircraft · Destroyed > Drg arrival, the aircrew of a Gates lear jet 35A, N873LP, canceled their IFR clearance & contacted the Auburn UNICOM, then entered the traffic pattern to land on rwy 18. The UNICOM operator rprtd that the lear jet crew had rprtd their position on each portion… - [NTSB MIA85FA253](https://openairdocs.org/ntsb/MIA85FA253.md): Cessna 152 · Panama City, FL · Accident · No injuries · Field investigation · Final report · Sep 13, 1985 · N4894B · 2 aircraft · Substantial damage > The plt of 757 hm stated that he understood he was second to land so he processed to turn final unknowningly cutting off threeother acft on final apch to twy 05. The tower told him 'break left there is two acft on final', he applied power to go around and… - [NTSB MIA85FA247](https://openairdocs.org/ntsb/MIA85FA247.md): Cessna 150 · Pensacola, FL · Accident · No injuries · Field investigation · Final report · Sep 7, 1985 · N6177K · 2 aircraft · Substantial damage > The commercial plt & CFI departed from gulfport, ms on a night VFR x-country flt to gulf shores. Al. The flt landed at foley, al after the plt mistook foley for gulfshores 10 mi south. The flt departed again & was advised by ATC to fly a heading of 170 deg… Next page: https://openairdocs.org/ntsb.md?occurrence=270&page=8 ## 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=7 --- 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.