# NTSB investigations, 1983: Standing

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 FTW84LA105](https://openairdocs.org/ntsb/FTW84LA105.md): Bell 206B III · Vermillion 255b · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1983 · N2145C · Minor damage
  > While waiting for passengers to board the helicopter the plt heard and felt something hit the tail rotor. The eng was immediately shut down and it was revealed that a passenger had walked into the tail rotor. The passenger was was well experienced in…
- [NTSB MKC84FA046](https://openairdocs.org/ntsb/MKC84FA046.md): Cessna 182G · Olathe, KS · Accident · Serious injuries · Field investigation · Final report · Dec 26, 1983 · N2123R · No damage
  > The plt was struck on the leg by the acft propeller as he pulled the propeller through during preflight. The eng had been preheated in an enclosed hanger due to the frigid temperatures. The plt stated he primed the engine and put the keyin the ignition prior…
- [NTSB LAX84LA122](https://openairdocs.org/ntsb/LAX84LA122.md): Boeing 737-200 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 1983 · N133AW · No damage
  > The acft was standing with engines running and a baggage handler was blown off his feet when he went behind the acft. The acft had been called back to the ramp because an access door was open. The baggage handler approaching the acft fromthe rear to close the…
- [NTSB ATL84LA072](https://openairdocs.org/ntsb/ATL84LA072.md): Cessna 182B · Spartanburg, SC · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1983 · N2354G · No damage
  > The acft propeller struck a passenger approaching to board the acft. The plt had started the acft for warm-up prior to the boarding. The passenger stumbled approaching the acft and fell into the revolving propeller.
- [NTSB MKC84FA036](https://openairdocs.org/ntsb/MKC84FA036.md): Beech A36 · Kansas City, MO · Accident · No injuries · Field investigation · Final report · Dec 12, 1983 · N6416N · 2 aircraft · Substantial damage
  > The BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he…
- [NTSB DEN84LA034](https://openairdocs.org/ntsb/DEN84LA034.md): Cessna 172N · Helena, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1983 · N4818D · Minor damage
  > The acft propeller struck a passenger who was attemping to sweep snow off the acft. The plt's and passenger's version of mishap vary. The plt stated he instructed the passenger to stay away from the acft. The passenger stated the plt toldhim to sweep the snow…
- [NTSB LAX84LA093](https://openairdocs.org/ntsb/LAX84LA093.md): Beech C24R · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Nov 26, 1983 · N3824R · Substantial damage
  > Fire erupted in the eng compartment during the eng run-up. Investigaiton revealed that 7 of the 8 nuts securing the exhaust manifold to the cylinders were missing. The only nut present was loose but retained the #1 cyl exhaust tube. The #2 cyl exhaust tube,…
- [NTSB DEN84LA033](https://openairdocs.org/ntsb/DEN84LA033.md): Cessna 172 · Yankton, SD · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1983 · N52419 · No damage
  > The plt stated the eng wouldn't start & he suspected a dead spot on the starter. He then asked a mechanic to rotate the prop. All switches were off except the battery switch. When the mechanic moved the prop the eng started & the prop struck the mechanic.…
- [NTSB DEN84LA050](https://openairdocs.org/ntsb/DEN84LA050.md): Mitsubishi MU-2B-60 · Richfield, UT · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 1983 · N477MA · No damage
  > The acft propeller struck a 12 year old male passenger after he deplaned. The accident occurred on an unlighted ramp at about 1930 hours MST. The boy had walked forward along the fuselage to look into the cockpit when he was hit. His father was in the…
- [NTSB NYC84LA021](https://openairdocs.org/ntsb/NYC84LA021.md): Piper PA-28-181 · New Milford, CT · Accident · No injuries · Limited investigation · Final report · Nov 4, 1983 · N2222R · Destroyed
  > The pilot reported that as he was starting the engine, fire broke out. He attempted to put out the fire with on-board extinguishers, but failed. The acft was destroyed by fire.
- [NTSB LAX84LA044](https://openairdocs.org/ntsb/LAX84LA044.md): Cessna TU206G · Reno, NV · Accident · 1 fatal · Limited investigation · Final report · Nov 3, 1983 · N756DG · No damage
  > The pilot's body was found under the front of the acft by the propeller. All cockpit controls were in the start positionand the acft was not chocked or tied down. The payroll checks the pilot was to deliver were found in the acft.
- [NTSB NYC84LA005](https://openairdocs.org/ntsb/NYC84LA005.md): Cessna 172M · Toughkenamon, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1983 · N4333R · Substantial damage
  > The plt had difficulty in starting the eng & got a mechanic to be at the controls while he hand propped the acft. He had tried several times to start the eng, then tried with the throttle open. On that attempt, the eng started and the acft began to move…
- [NTSB LAX84LA009](https://openairdocs.org/ntsb/LAX84LA009.md): North American SNJ-2 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1983 · N61563 · 2 aircraft · Substantial damage
  > A flt of 5 North American SNJ-2 acft were on a flt from long beach to Fresno, CA. By prior arrangement, the lead plt in N61563 was to handle the radio communication with ATC facilities. During arrival at Fresno, the local controller inquired whether the group…
- [NTSB LAX83LA459](https://openairdocs.org/ntsb/LAX83LA459.md): Cessna 152 · Hawthorne, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 1983 · N47048 · No damage
  > After landing at night, the plt taxied to an unlighted parking area & stopped. He stated that while he was looking for a parking space, his friends came out of the waiting room & 1 of them approached the right side of the acft. The plt said he saw his friend…
- [NTSB FTW83IA438](https://openairdocs.org/ntsb/FTW83IA438.md): Boeing 727-223B · Dallas/Ft Worth, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 23, 1983 · N897AA · No damage
  > After landing & taxi to the ramp while standing with one engine & the APU running smoke filled the cabine. The captain ordered an emergency evacuation which was accomplished. The origin and cause of the smoke is undetermined.
- [NTSB LAX83FA444](https://openairdocs.org/ntsb/LAX83FA444.md): Cessna T210M · Santa Ana, CA · Accident · 1 fatal · Field investigation · Final report · Sep 19, 1983 · N8052M · Minor damage
  > After landing at night, the plt taxied to a non-illuminated ramp area & stopped to deplane the passenger, who held a student plt certificate. The purpose of the passenger deplaning in that area was for her to obtain a vehicle & meet the plt at the acft's…
- [NTSB MIA83LA229](https://openairdocs.org/ntsb/MIA83LA229.md): Cessna 172I · Miami, FL · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 1983 · N8366L · Minor damage
  > The acft landed at aprx 0215 EDT. After arriving at the ramp, the plt's wife exited from the acft thru the right door. She then walked in front of the acft & was struck by the propeller. The plt's wife was fatally injured & he was taken to a hospital & was…
- [NTSB FTW83LA418](https://openairdocs.org/ntsb/FTW83LA418.md): Piper PA-28-140 · Belen, NM · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N43340 · Destroyed
  > The student & instructor plt (CFI) had flown the acft from albuquerque to Belen, NM, & had shut down the eng. During an eng start to continue the flt about 20 min later, a fire started in the eng & the acft was destroyed by fire. The source of the fire was…
- [NTSB MKC83FA196](https://openairdocs.org/ntsb/MKC83FA196.md): Bell 47G-3B · Paxton, NE · Accident · Serious injuries · Field investigation · Final report · Aug 18, 1983 · N73248 · Destroyed
  > The plt stated that after landing on a truck platform, he did not decrease rotor RPM & did not lower collective to flat pitch as he was attempting to recover a piece of paper that had fallen to the floor on the right side of the cockpit. As he released the…
- [NTSB LAX83FA393](https://openairdocs.org/ntsb/LAX83FA393.md): Hughes 369HS · San Pedro, CA · Accident · 1 fatal · Field investigation · Final report · Aug 18, 1983 · N90958 · Substantial damage
  > The plt was on a mission to transport company personnel & had landed on a barge that was being used as a helipad. The barge was about 250 ft long & 75 ft wide. After arriving, the plt parked the helicopter with the tail boom as close to the edge of the barge…
- [NTSB CHI83LA372](https://openairdocs.org/ntsb/CHI83LA372.md): Cessna 177B · Wheeling, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 1983 · N35083 · No damage
  > The plt was unable to start the eng using normal procedures. He obtained the use of an APU & still could not make an electrical start. He stated that he turned the magneto & master switches off & rotated the propeller (prop) backwards 1/2 turn (to check for…
- [NTSB ATL83LKW02](https://openairdocs.org/ntsb/ATL83LKW02.md): Cessna 152 · Nashville, TN · Accident · Serious injuries · Final report · Jul 30, 1983 · N5270B · Minor damage
  > The acft propeller struck a deplaned female passenger as she proceeded to the front of the acft prior to engine shutdown. The plt stated that his attention was primarily on the fact that the idle RPM seemed high to him and he failed to note his passenger exit…
- [NTSB LAX83FA349](https://openairdocs.org/ntsb/LAX83FA349.md): Beech C-45G · Kahalui, HI · Accident · Minor injuries · Field investigation · Final report · Jul 23, 1983 · N888M · 2 aircraft · Substantial damage
  > A Beech C-45G, N888M, call sign lani 8 and a Beech E185, N162SP, call sign lani 9 were part of a flt of 5 acft, with call signs of lani 6 thru 10, that where being used on an inter-island tour. The 1st act, lani 6, was cleared for takeoff & departed…
- [NTSB NYC83FA171](https://openairdocs.org/ntsb/NYC83FA171.md): Stinson 108 · Farmingdale, NY · Accident · 2 fatal · Field investigation · Final report · Jul 11, 1983 · N90DD · Destroyed
  > The carburetor had been previously removed & reworked, then was reinstalled. After the installation, which included a leak check, the plt got into the left front seat & the passenger/mechanic got into the right front seat. The plt primed the eng, then made a…
- [NTSB LAX83FUA04](https://openairdocs.org/ntsb/LAX83FUA04.md): Cessna 182 · Avalon Catalina, CA · Accident · Serious injuries · Final report · Jul 11, 1983 · N3602U · No damage
  > The acft propeller struck the arm of a lineman who was assisting the plt to start the acft the plt stated that the propeller was turning slowly and he asked for help. The lineman requested that all switches be turned off and proceed toturn the propeller which…
- [NTSB SEA83LA148](https://openairdocs.org/ntsb/SEA83LA148.md): Cessna 150-J · Connell, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 1983 · N1053M · No damage
  > The plt stated he was preparing to shut down the engine when the passenger deplaned & inadvertently walked into the prop.
- [NTSB NYC83LNA03](https://openairdocs.org/ntsb/NYC83LNA03.md): Cessna 150 · Stow, MA · Accident · Serious injuries · Final report · Jul 7, 1983 · N11196 · No damage
  > The acft propeller struck a passenger who was walking around the acft in preparation for boarding. The acft had been taxied in from landing and stopped near the coffee shop. The wife of the passenger on board the acft approached theacft prior to engine shut…
- [NTSB FTW83FA303](https://openairdocs.org/ntsb/FTW83FA303.md): Grumman American AA-5A · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1983 · N9844U · 2 aircraft · Destroyed
  > The Grumman American AA-5A, N9844U, had just landed. While taxing, the aircrew stopped short of rwy 13R as Beechcraft. Hawker BH-125, N125E, was taking off. The rated student in N125E, who was on a training flt, was at the controls & beganthe takeoff. The…
- [NTSB CHI83LA275](https://openairdocs.org/ntsb/CHI83LA275.md): Cessna 152 · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Jun 22, 1983 · N93407 · 2 aircraft · Substantial damage
  > The aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…
- [NTSB CHI83IA269](https://openairdocs.org/ntsb/CHI83IA269.md): Boeing B-747 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 20, 1983 · N4717U · 2 aircraft · Minor damage
  > The united airlines B747 was standing in the run up area adjacent to the runway. A flying tigers B747 was passing to his left. The crew of the parked B747 opened their overhead escape hatch and indicated to the taxiing B747 with a thumbs up sign that there…
- [NTSB MIA83FA159](https://openairdocs.org/ntsb/MIA83FA159.md): Boeing 727-200 · San Juan, PR · Accident · Serious injuries · Field investigation · Final report · Jun 11, 1983 · HI242 · No damage
  > As the acft was departing, the airline company received info concerning a bomb threat. The aircrew were instructed to return to the arpt & land. After landing, the acft was parked at an isolated area & portable stairs were positioned at the left forward door.…
- [NTSB ATL83LA221](https://openairdocs.org/ntsb/ATL83LA221.md): Robinson R-22 · Jackson, KY · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 1983 · N90672 · Substantial damage
  > The pilot reported that when he exited the helicopter for the purpose of retrieveing a map from below the plt's seat, the acft began to lift and move laterally. The acft then tipped over trapping his leg and hip beneath it. He stated that he had not fully…
- [NTSB LAX83LA284](https://openairdocs.org/ntsb/LAX83LA284.md): Cessna 172A · Carmel Valley, CA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N9854T · Substantial damage
  > According to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the…
- [NTSB SEA83IA116](https://openairdocs.org/ntsb/SEA83IA116.md): Boeing 727-200 · Portland, OR · Incident · No injuries · Incident investigation · Final report · Jun 4, 1983 · N296AS · No damage
  > A broken hydraulic line near the left main landing gear allowed hydraulic fluid to leak on to the APU exhaust. The resultant smoke then was picked up by the left airpack and was blown into the cabin. The crew then ordered an evacuationof the passengers.
- [NTSB LAX83LA238](https://openairdocs.org/ntsb/LAX83LA238.md): Cessna 182 · Riverside, CA · Accident · No injuries · Limited investigation · Final report · May 20, 1983 · N5547B · Substantial damage
  > The acft collided with a hangar after being hand propped without a qualified person in the cockpit. The acft had been borrowed and was known to have a low battery. The pilot did a start by hand propping the acft with a non-pilot in the right front seat.…
- [NTSB CHI83LA216](https://openairdocs.org/ntsb/CHI83LA216.md): Cessna 150 · Janesville, WI · Accident · No injuries · Limited investigation · Final report · May 16, 1983 · N8576J · 2 aircraft · Minor damage
  > N13364 had stopped short of the runway for a run-up check prior to takeoff. The pilot of N8576J continued his taxi while he was checking the field elevation and setting his altimeter he taxied into the empennage of N13364.
- [NTSB SEA83LYK02](https://openairdocs.org/ntsb/SEA83LYK02.md): Cessna 210L · North Bend, OR · Accident · Serious injuries · Final report · Apr 17, 1983 · N30784 · Substantial damage
  > The aircraft collided with a parked fuel trailer after the engine started when the pilot turned the prop to loosen up the engine oil. The pilot received serious injuries when he was knocked down by the left horizontal stabilizer as he tried to reenter the…
- [NTSB FTW83LA177](https://openairdocs.org/ntsb/FTW83LA177.md): de Havilland DHC-6 · Mckinney, TX · Accident · 1 fatal · Limited investigation · Final report · Apr 3, 1983 · N927BA · No damage
  > Three observers accompanied the aircrew & other passengers on a flt to transport skydivers aloft. Prior to the flt, all 3 of the observers were briefed not to exit the acft until the engines were secured. However, 1 of the 3 discussed the need to move a…
- [NTSB MKC83FA072](https://openairdocs.org/ntsb/MKC83FA072.md): Swearingen SA 226TC · St. Louis, MO · Accident · Serious injuries · Field investigation · Final report · Feb 25, 1983 · N237AM · Minor damage
  > Rotating right prop struck a female child passenger who had run down the acft airstair to retrieve a doll she had dropped while climbing the airstair to board for the flt. A company attendant was stationed at the left (stopped) prop, but not on or near the…
- [NTSB LAX83LA103](https://openairdocs.org/ntsb/LAX83LA103.md): Beech 95-55 · San Francisco, CA · Accident · No injuries · Limited investigation · Final report · Feb 15, 1983 · N704CC · Substantial damage
  > The pilot was preparing to taxi when he noticed a loose fuel cap on the acft's left wing. He set the parking brake, exited the acft with both engines operating, placed a chock on the right wheel and was securing the loose fuel cap when the acft started to…
- [NTSB MKC83LA067](https://openairdocs.org/ntsb/MKC83LA067.md): Beech B23 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Feb 14, 1983 · N4013T · Substantial damage
  > The pilot was not totally familiar with the operation of this aircraft. The aircraft engine was started without setting the parking brake properly. The pilot did not have his feet on the brakes and could not reduce the throttle because of the throttle lock.…
- [NTSB FTW83LA111](https://openairdocs.org/ntsb/FTW83LA111.md): Bellanca 14-19-3A · Plainview, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1983 · N1264R · Substantial damage
  > The flt reported that the battery was too low to start the engine. A 72 yr old ex-pilot offered to hand prop the plane, but after trying, he then offered to hold the brakes. With the ex-pilot at the controls & holding the brakes, the plt began to hand prop…
- [NTSB MKC83FA061](https://openairdocs.org/ntsb/MKC83FA061.md): Beech M35 · Cedar Rapids, IA · Accident · Serious injuries · Field investigation · Final report · Jan 31, 1983 · N9708R · No damage
  > The acft engine fired as the pilot hand-propped it and the propeller struck the pilot in the leg. The pilot had tried the starter but could not get a start. He turned the switches off and decided to pull the prop through by hand. He pulled it through…
- [NTSB FTW83FA100](https://openairdocs.org/ntsb/FTW83FA100.md): Robinson R22 · Zapata, TX · Accident · No injuries · Field investigation · Final report · Jan 27, 1983 · N9021J · Destroyed
  > The helicopter was landed in an area of dry grass, 18 to 28 inches tall. The plt stated that within 30 sec after a normal approach & touchdown, the passenger noticed a fire as he was exiting the acft. The pilot then rolled the throttle on in an attempt to…
- [NTSB LAX83FA076](https://openairdocs.org/ntsb/LAX83FA076.md): Beech C-99 · San Francisco, CA · Accident · 1 fatal · Field investigation · Final report · Jan 20, 1983 · N64002 · Minor damage
  > The acft propeller struck a station agent who was assisting in the parking of the acft. After signaling the acft to stopthe agent placed her lighted wanes on the ramp and moved toward the stationary acft to get the wheel chocks. As she approached the chocks…
- [NTSB MKC83IA054](https://openairdocs.org/ntsb/MKC83IA054.md): Cessna 402B · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jan 10, 1983 · N8200Q · Minor damage
  > The right engine of the acft started to burn while the acft was being started. The pilot noticed flames coming out of the top of the right engine after the left engine was started. The pilot initiated shut down of both engines and evacuation of the…

## 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 = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/150/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.