# NTSB investigations, 1983: Unknown 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. ## Latest cases - [NTSB LAX84FU024](https://openairdocs.org/ntsb/LAX84FU024.md): Eipper MX · Ramona, CA · Accident · 1 fatal · Final report · Dec 28, 1983 · UNREG · Destroyed > The plt was flying the ultralight vehicle to check it out before allowing his student to solo. Aprx 15 min after the plt took off, he was flying over the arpt at about 400 ft AGL when witnesses heard a 'loud non-metallic' sound from the vehicle. At about that… - [NTSB FTW84FA086](https://openairdocs.org/ntsb/FTW84FA086.md): Beech D18S · Brownsville, TX · Accident · 1 fatal · Field investigation · Final report · Dec 6, 1983 · N44609 · Destroyed > The plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,… - [NTSB CHI84FAMS1](https://openairdocs.org/ntsb/CHI84FAMS1.md): Mooney M20C · Near Green Bay, WI · Accident · 1 fatal · Missing aircraft · Final report · Nov 22, 1983 · N9232M · Destroyed > After a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further… - [NTSB MIA84LA035](https://openairdocs.org/ntsb/MIA84LA035.md): Cessna 340A · Nr. Orangeville, FL · Accident · 1 fatal · Limited investigation · Final report · Nov 20, 1983 · N85JK · Destroyed > The acft disappeared fm radar coverage while in cruise flt at 10,000 feet MSL near Orangeville, FL. The ATC transcript revealed that the plt had been inquiring abt the weather ahead of him and was cleared to descend to 6000 in order to get below strong… - [NTSB FTW84FA057](https://openairdocs.org/ntsb/FTW84FA057.md): Cessna 210N · Childress, TX · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1983 · N6616N · Substantial damage > The plt contacte fss requesting info as to fuel service. He was advised that the rwy lights at Childress arpt was out of service. About 34 min later the plt stated his eng had quit & he would try to make the arpt. The acft subsequently struck power lines… - [NTSB DEN84FA231](https://openairdocs.org/ntsb/DEN84FA231.md): Cessna 182P · Climax, CO · Accident · 4 fatal · Field investigation · Final report · Nov 14, 1983 · N7292S · Destroyed > The wreckage of N7292S was located by the Colorado civil air patrol on July 22, 1984. An on-scene examination of the wreckage revealed that the acft had impacted tall pine trees in a near vertical right hand spiral maneuver. Impact forces destroyed the acft… - [NTSB CHI84FA042](https://openairdocs.org/ntsb/CHI84FA042.md): Piper PA-22-150 · Easton Township, MI · Accident · 3 fatal · Field investigation · Final report · Nov 12, 1983 · N6903D · Destroyed > The acft crashed aprx 3 mi from the departure arpt. According to witnesses, it was flying at aprx 200 ft AGL when the right wing dipped & then the acft went nearly straight into the ground. An inspection of the airframe & flt control sys revealed no evidence… - [NTSB CHI84LA038](https://openairdocs.org/ntsb/CHI84LA038.md): Beech A36 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Nov 5, 1983 · N6739U · Substantial damage > On the return flt to Columbus, OH, the alternator warning light was on. After recycling the switch, the plt shut down all electrical equipment. During arrival at the destination, the plt put the gear handle down, but noted a dim unsafe gear light & a… - [NTSB ATL84LA035](https://openairdocs.org/ntsb/ATL84LA035.md): Piper PA-23-250 · Greer, SC · Accident · No injuries · Limited investigation · Final report · Nov 1, 1983 · N40249 · Substantial damage > During the flt, hydraulic failure of the landing sys occurred & the aircrew were unable to get the gear locked in the down position. After orbiting for over an hour, a landing was made. During touchdown, the gear collapsed. An exam revealed that an aileron… - [NTSB ANC84FA013](https://openairdocs.org/ntsb/ANC84FA013.md): Cessna 206 · Kenai, AK · Accident · 4 fatal · Field investigation · Final report · Oct 31, 1983 · N9975 · Destroyed > The acft departed nondalton, AK at aprx 1135 yst on a flt to Kenai, AK. At aprx 1215 yst, the plt report that he was over west forelands & requested the Kenai wx. About 4 min later, he requested a df steer to the Kenai arpt. A short time later, radio contact… - [NTSB NYC84LA008](https://openairdocs.org/ntsb/NYC84LA008.md): Cessna 172L · Wilkes-Barre, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1983 · N7759G · Substantial damage > During flt, the eng lost power from fuel exhaustion & the plt tried to land on a highway. According to witnesses, when he tried to maneuver into the northbound land, while traveling south, the right main gear hit the side of a bank. The wing fuel tanks were… - [NTSB FTW84LAMS1](https://openairdocs.org/ntsb/FTW84LAMS1.md): Piper PA-34-200 · Gulf Of Mexico · Accident · 1 fatal · Final report · Oct 9, 1983 · N4437T · Destroyed > The acft disappeared on a flt over a part of the Gulf Of Mexico south of corpus christi in an area of thunderstorm activity. The storms were densely packed and it was considered unlikely that VFR flt could be conducted in the area. Theaccident acft was in… - [NTSB MIA84LA007](https://openairdocs.org/ntsb/MIA84LA007.md): Cessna T-210-J · FL · Accident · 3 fatal · Limited investigation · Final report · Oct 4, 1983 · N2284R · Destroyed > This acft is missing on a flt from andros town, Bahamas to ft. pierce, FL. After departure the acft contacted nassau to file a VFR clearance and called miami fss to report 60 DME east of ft. lauderdale in heavy rain. The plt requested information on how to… - [NTSB NYC83FA254](https://openairdocs.org/ntsb/NYC83FA254.md): Bellanca 17-31ATC · Provincetown, MA · Accident · 3 fatal · Field investigation · Final report · Sep 11, 1983 · N28077 · Destroyed > The acft crashed in cape cod bay during a night x-country flt. Two sections of wooden wing identified as from the same make and model as the missing acft were recovered from the bay during the 3 days following the flt of the acft. Other identified parts of… - [NTSB ATL83FA366](https://openairdocs.org/ntsb/ATL83FA366.md): Pterodactyl/Lambert None · Mt. Holly, NC · Accident · 1 fatal · Field investigation · Final report · Sep 10, 1983 · N2084Q · Destroyed > The plt was on a x-country accompanied by a plt in another ultralight vehicle. The accident acft was faster, so the plt maneuvered around while en route. During a turn, the accident vehicle got out of sight from the plt of the other vehicle & became… - [NTSB FTW83LA422](https://openairdocs.org/ntsb/FTW83LA422.md): Cessna 150G · Freer, TX · Accident · No injuries · Limited investigation · Final report · Sep 6, 1983 · N3374J · Substantial damage > Reportedly, the non-rated plt encountered a loss of power after the fuel exhausted near the destination arpt. Subsequently, he made an emergency landing at night on umimproved terrain aprx 1 mi from the arpt. During the landing sequence, the acft bounced, the… - [NTSB LAX83FU015](https://openairdocs.org/ntsb/LAX83FU015.md): Waspair Tomcat HM-81 · Roseville, CA · Accident · 1 fatal · Final report · Sep 3, 1983 · UNREG · Substantial damage > The plt had only flown 1 flt since he had crashed the same ultralight vehicle nearly 1 yr previously. An eye witness, who was president of the local ultralight association, had test flown the repaired vehicle before the plt flew it. The plt, the eye witness &… - [NTSB FTW83FA407](https://openairdocs.org/ntsb/FTW83FA407.md): Luscombe 8C · Post, TX · Accident · 2 fatal · Field investigation · Final report · Aug 31, 1983 · N25285 · Destroyed > The acft had impacted in a steep right wing down, nose low attitude. No preimpact, mechanical malfunction or failure was found. The plt's blood alcohol level was 0.054%. There were no entries in the plt's log book for previous flts in Luscombe acft. - [NTSB MIA83LA212](https://openairdocs.org/ntsb/MIA83LA212.md): Bell 47J · Labelle, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 1983 · N5824 · Substantial damage > While at an altitude of about 150 ft, the eng lost power. The plt initiated an autorotation, but during the landing, the main rotor struck trees & the helicopter was substantially damaged. The plt estimated there was 15 gal of fuel on board during the… - [NTSB FTW83LA399](https://openairdocs.org/ntsb/FTW83LA399.md): Cessna 172D · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 25, 1983 · N2665U · Substantial damage > The plt reported that the eng lost power & he had to make a forced landing on desert terrain. The acft touched down short of the rwy near the coronado arpt & the plt received head injuries. The reason for the power loss was not determined. However, the temp &… - [NTSB SEA83AA176](https://openairdocs.org/ntsb/SEA83AA176.md): Fairchild Hiller FH-1100 · Toutle, WA · Accident · 5 fatal · Final report · Aug 13, 1983 · N29917 · Destroyed > The helicopter took off on a sight-seeing, passenger flt in the mount st helens area. When the flt became overdue, a search was initiated. Later, the helicopter was found where it crashed & burned in a heavily wooded area on relatively level terrain, near the… - [NTSB ANC83FA143](https://openairdocs.org/ntsb/ANC83FA143.md): Piper PA-18 · Hope, AK · Accident · Serious injuries · Field investigation · Final report · Aug 7, 1983 · N4301Z · Substantial damage > The acft crashed under unknown circumstances. The wreckage was removed after an aerial survey & has not been located. - [NTSB LAX83LA468](https://openairdocs.org/ntsb/LAX83LA468.md): Mooney M20K · Essex, CA · Accident · 3 fatal · Limited investigation · Final report · Aug 6, 1983 · N3624H · Destroyed > An in-flight loss of control for undetermined reasons. - [NTSB CHI83FA365](https://openairdocs.org/ntsb/CHI83FA365.md): Cessna 182 · Marseilles, IL · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1983 · N6351A · Destroyed > The acft was on a parachute jumping mission. After climbing to 9000 ft MSL, 4 sky divers jumped out & the plt began a descent back to the arpt. The acft was seen level at aprx 500 ft AGL & in the aprx position for a downwind leg for a left pattern for runway… - [NTSB SEA83FA162](https://openairdocs.org/ntsb/SEA83FA162.md): Piper PA-36 · Firth, ID · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1983 · N57588 · Destroyed > According to witnesses, the acft was overheard returning to the strip for a second load. Reportedly, it went into a steep bank at about 70 ft AGL & turned toward the strip. As the wings leveled, sounds of high eng power ceased & the acft descend to the… - [NTSB LAX83FA371](https://openairdocs.org/ntsb/LAX83FA371.md): Cessna 152 · Pleasanton, CA · Accident · 1 fatal · Field investigation · Final report · Jul 31, 1983 · N6599L · Destroyed > The acft crashed in a steep nose down attitude in hilly terrain. Debris was scattered for about 100 ft but the acft did not travel after initial impact. The fuel tanks were ruptured and no fuel remained. The sheriff's deputies said no odor of fuel was noted… - [NTSB NYC83FFJ03](https://openairdocs.org/ntsb/NYC83FFJ03.md): Sopwith Triplane · Allegany, NY · Accident · 1 fatal · Final report · Jul 22, 1983 · N5004 · Destroyed > The owner/plt of the home built, Sopwith triplane took off on a local flt. This was the 1st flt since some maintenance rework & a new propeller installation. After the acft was airborne for aprx 20 min, it was observed flying at about 500 ft AGL. Reportedly,… - [NTSB LAX83FVM09](https://openairdocs.org/ntsb/LAX83FVM09.md): Twitchell LONG-EZE · Oceano, CA · Accident · 2 fatal · Final report · Jul 3, 1983 · N3149K · Destroyed > The acft was observed in a 3-4 turn spin until impact. A control stick was mounted on the right armrest in the rear cockpit. A complete set of controls; stick, rudder & throttle, was installed in the front cockpit. - [NTSB FTW83FA302](https://openairdocs.org/ntsb/FTW83FA302.md): Cessna 150J · El Campo, TX · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1983 · N60655 · Substantial damage > The acft impacted the ground in a steep nose down attitude. After impact, the acft remained in a tail-high attitude. No known witnesses observed the accident. An exam of the eng & prop showed a minimum of power being developed at the time of impact. A… - [NTSB ATL83FAMS1](https://openairdocs.org/ntsb/ATL83FAMS1.md): Piper PA-24 · Fleeton, VA · Accident · 2 fatal · Missing aircraft · Final report · Jun 29, 1983 · N7284P · Destroyed > On July 2, a main landing gear, identified by the FAA as part of N7284P, was found floating in the chesapeake bay. The body of the deseased passenger was located on July 9, 1983 in the bay. Investigation revealed no record of communicationbetween the acft and… - [NTSB FTW83FA280](https://openairdocs.org/ntsb/FTW83FA280.md): Bell 206B III · Eugene Isl.Blk · Accident · 3 fatal · Field investigation · Final report · Jun 16, 1983 · N5010U · Destroyed > The helicopter was used to shuttle pax & supplies between various oil drilling platforms & was en route between two islands when the accident occurred. Wreckage was spotted 6 miles west of the destination island. Only the pilot's body was retrieved & 2 pax… - [NTSB LAX83FVG12](https://openairdocs.org/ntsb/LAX83FVG12.md): Yarnell Grass Hopper · Redding, CA · Accident · 1 fatal · Final report · Jun 4, 1983 · N80546 · Destroyed > The acft crashed into steep mountainous terrain under unknown circumstances. The wreckage was 50 feet below a ridge line in deep brush. The engine and nose section were buried to the firewall. Eight inches of one prop blade showed aboveground and revealed no… - [NTSB LAX83FA260](https://openairdocs.org/ntsb/LAX83FA260.md): Piper PA-32 300C · Buckeye, AZ · Accident · 2 fatal · Field investigation · Final report · Jun 1, 1983 · N8926N · Destroyed > The acft collided with a utility pole about 36 ft AGL less than a mile north of a private dirt airstrip. The acft had departed scottsdale municipal arpt at about 0045. The accident occurred at about 0200 aproximately 4 miles west of Buckeye,AZ. A witness… - [NTSB LAX83FA246](https://openairdocs.org/ntsb/LAX83FA246.md): Herpst Varieze · Portola, CA · Accident · 2 fatal · Field investigation · Final report · May 23, 1983 · N882BF · Destroyed > The home built acft collided with trees & crashed on rising terrain while the plt & passenger were on a sight-seeing flt. The accident occurred at an elevation of 7000 ft, the density altitude was estimated to be aprx 10000 ft. the wreckage was scattered aprx… - [NTSB MKC83FU002](https://openairdocs.org/ntsb/MKC83FU002.md): Weedhopper JC-24C · 5n Battle Creek, NE · Accident · 1 fatal · Final report · May 21, 1983 · UNREG · Substantial damage > The plt had assembled & flown the ultralight vehicle during the previous summer. This was his 1st flt after removing it from winter storage. He was observed preflighting the vehicle before takeoff. At about the time of the accident, a ground witness heard the… - [NTSB DCA83AA025](https://openairdocs.org/ntsb/DCA83AA025.md): Piper PA-23 · Gaithersburg, MD · Accident · 3 fatal · Final report · May 7, 1983 · N1236P · Destroyed > The owner/plt was on a flt, accompanied by two nephews, ages 19 & 8 yrs old. An associate of the owner/plt reported that the 19 yr old nephew, who occupied the right front seat, was a single eng plt, but had no multi-eng instruction. However, no FAA records… - [NTSB LAX83IA216](https://openairdocs.org/ntsb/LAX83IA216.md): Cessna C-172-N · Huntington Beac, CA · Incident · No injuries · Incident investigation · Final report · May 6, 1983 · N4913G · Minor damage > The left aileron sustained damag under undetermined circumstancea. A near miss was described by the pilot and could not be substantiated by radar. - [NTSB NYC83FA106](https://openairdocs.org/ntsb/NYC83FA106.md): Bell 47G-2 · Waymart, PA · Accident · 2 fatal · Field investigation · Final report · Apr 30, 1983 · N2829B · Destroyed > This was an introductory instructional flt. Witnesses observed the helicopter flying straight & level prior to the accident. The helicopter had impacted a 60-FT tree at about the 40-FT level. No preimpact failure/falfunction of either the airframe or engine… - [NTSB MKC83FU001](https://openairdocs.org/ntsb/MKC83FU001.md): American Eagle 430B · Hartshorn, MO · Accident · 1 fatal · Final report · Apr 28, 1983 · UNREG · Substantial damage > The co-owner of the ultralight vehicle was watching the flt & observed the accident. He said the vehicle approached the pasture & was descending from aprx 200 ft as if the plt was going to land or fly by. The ultralight passed over the takeoff/landing area at… - [NTSB LAX83LA200](https://openairdocs.org/ntsb/LAX83LA200.md): Beech E-18S · Davis, CA · Accident · No injuries · Limited investigation · Final report · Apr 16, 1983 · N4980V · Substantial damage > While in flt on a parachute jumping mission, a fire erupted in the right eng area & a precautionary landing was made. An exam revealed that the float fulcrum screw, pn 13773, on the stromberg carburetor had backed out & allowed fuel to escape into the exhaust… - [NTSB ATL83FA161](https://openairdocs.org/ntsb/ATL83FA161.md): Cessna 177RG · Mobile, AL · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1983 · N2765V · Destroyed > The plt had not flown actively for aprx 1 yr. However, shortly before the accident, he had told friends that he had missed flying & was going to resume this activity. He received a checkout in the Cessna 177RG on 12/12/82 in anticipation of flying again. This… - [NTSB LAX83LAMS4](https://openairdocs.org/ntsb/LAX83LAMS4.md): Cessna 152 · Missing Acft · Accident · 1 fatal · Final report · Mar 29, 1983 · N6329M · Destroyed > The plt reportedly took off on a 1 hr local. The Acft did not return & was presumed to have crashed. Also, it was presumed to have been destroyed & the plt was presumed to have been fatally injured. The owner/operator provided info which suggested that the… - [NTSB LAX83FA124](https://openairdocs.org/ntsb/LAX83FA124.md): Thorp T-18 · Simi, CA · Accident · 1 fatal · Field investigation · Final report · Mar 5, 1983 · N3124 · Destroyed > The acft crashed in a school playground in a steep uncontrolled descent. Witnesses said the acft was observed in a 60 degree nose down attitude at about 1000 ft AGL and this continued until ground impact. The engine was producing high power at this time. No… - [NTSB FTW83LA103](https://openairdocs.org/ntsb/FTW83LA103.md): Cessna P337H · La Porte, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1983 · N4BX · Substantial damage > Shortly after lift-off, the acft started its initial climb, then entered a slow descent. The flight was continued until the acft collided with a tv cable, suspended below telephone cables on the same poles. The acft contacted the ground, bounced & became… - [NTSB ANC83FA042](https://openairdocs.org/ntsb/ANC83FA042.md): Bellanca 8GCBC · Melozi Hot Spgs, AK · Accident · 3 fatal · Field investigation · Final report · Feb 1, 1983 · N8639V · Destroyed > Acft deptd a private airstrip with no flt plan and was later reported overdue. Acft wreckage was found on sept. 27, 1984. Debris was scattered near the bottom of a 1000 ft box canyon cliff. The main fuselage was found in a lake at the bottom of the canyon.… - [NTSB SEA83FA044](https://openairdocs.org/ntsb/SEA83FA044.md): Cessna P210N · Burns, OR · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1983 · N5162W · Destroyed > The plt was on a bank-check courier flt from troutdale to portland, with en route stops at Burns & redmond, OR. Routinely, the acft would depart troutdale between 0900 & 0930 & arrive at Burns at 1130 to 1200 local time. After a ground time of aprx 8 hrs, it… ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) 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 year(c."eventDate") = 1983 AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 990) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?year=1983 --- 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.