# NTSB investigations, 1982: Landing 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 1 of 19 · 939 cases ## Latest cases - [NTSB MKC83LA049](https://openairdocs.org/ntsb/MKC83LA049.md): Piper PA-28-161 · Oakley, KS · Accident · No injuries · Limited investigation · Final report · Dec 31, 1982 · N2973T · Substantial damage > During landing the aircraft hit a patch of ice, swerved to the left, hit a runway light and slid off the runway. - [NTSB MKC83LA047](https://openairdocs.org/ntsb/MKC83LA047.md): Cessna 172 · Kearney, NE · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1982 · N6532F · Substantial damage > Pilot landed on icy runway and started to swerve. Go-around was initiated. Before aircraft could takeoff it collided with a snow bank. - [NTSB LAX83LA065](https://openairdocs.org/ntsb/LAX83LA065.md): Aeronca 7AC · Calistoga, CA · Accident · No injuries · Limited investigation · Final report · Dec 31, 1982 · N85400 · Substantial damage > Initial information indicated that the acft landed with a quartering tailwind, ground looped & collided with a parked glider. A pilot/operator accident report was not received. - [NTSB LAX83LA062](https://openairdocs.org/ntsb/LAX83LA062.md): Piper PA-34-200T · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Dec 31, 1982 · N477BL · Substantial damage > The right main landing gear collapsed during the landing roll. On-scene examination revealed that the right main gear was down & locked, but a material failure in the trunnion allowed the gear to rotate out & clockwise leading to collapse. A similarly located… - [NTSB LAX83FVG07](https://openairdocs.org/ntsb/LAX83FVG07.md): Piper PA-28-180 · Clearlake, CA · Accident · 1 fatal · Final report · Dec 31, 1982 · N67145 · Destroyed > The acft was observed to touch down 1/2 to 2/3 down the rwy at a high rate of speed. The acft then veered right off the rwy into some brush & then came back onto the rwy. Power was applied & the acft became airborne in a stall attitude, turned left & went… - [NTSB DEN83LA043](https://openairdocs.org/ntsb/DEN83LA043.md): Bell 206B · 11mi. So.Oftell, CO · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1982 · N2750D · Substantial damage > Pilot tried to land at 12,500 foot level. In the rotorwash whiteout he lost visual cues and rotor struck the slope because the right landing gear made snow contact. - [NTSB DEN83LA042](https://openairdocs.org/ntsb/DEN83LA042.md): Beech V35B · Kamis, UT · Accident · No injuries · Limited investigation · Final report · Dec 30, 1982 · N3803M · Substantial damage > The plt stated he noticed a drop in oil pressure & a prop surge & decided to make a precautionary landing on a road. During the landing the acft struck several sign posts. Post accident tests showed no evidence of oil starvation or drop in oil pressure. - [NTSB ANC83LA028](https://openairdocs.org/ntsb/ANC83LA028.md): Taylorcraft BC12-D1 · Drift River, AK · Accident · No injuries · Limited investigation · Final report · Dec 30, 1982 · N44219 · Substantial damage > The pilot reported that while he was landing on crusty snow, the left ski broke through the crust and hit a log that was buried beneath the snow. Subsequently, the left gear failed and the plane nosed over. - [NTSB FTW83LA070](https://openairdocs.org/ntsb/FTW83LA070.md): Cessna 152 · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1982 · N89757 · Substantial damage > The student plt was cleared to land on rwy 34R but overflew his base leg & turned final to rwy 34L. He turned in close behind a C-150 that was cleared to land on 34L & was instructed by the tower to go-around. The acft was observed flying the length of the… - [NTSB ATL83LA076](https://openairdocs.org/ntsb/ATL83LA076.md): Cessna 152 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Dec 28, 1982 · N6537P · Substantial damage > The student pilot stated he attempted to land beyond the mid-point of the runway from a high threshold position with full flaps deployed. The aircraft was forced onto the runway, bounced 3 times, and the nose gear collapsed. - [NTSB ATL83FA073](https://openairdocs.org/ntsb/ATL83FA073.md): Cessna 421B · Fort Payne, AL · Accident · No injuries · Field investigation · Final report · Dec 23, 1982 · N3380Q · Substantial damage > During landing the right main landing gear scissors bolt & bushing pulled through the scissors mount hole allowing the landing gear to rotate 90 deg. An incorrect washer (standard 5/16 in) had been installed in the scissors assembly duringrecent maintenance.… - [NTSB MKC83LA043](https://openairdocs.org/ntsb/MKC83LA043.md): Piper PA-20 · Lee'S Summit, MO · Accident · No injuries · Limited investigation · Final report · Dec 22, 1982 · N1961A · Substantial damage > The student pilot was on a supervised solo flight in a tail wheel equipped aircraft. The instructor pilot was observing from about 300 ft from the touchdown point. He stated that the plane touched down hard, bounced and turned to the left. The right main gear… - [NTSB DEN83LA037](https://openairdocs.org/ntsb/DEN83LA037.md): Cessna TR182 · Lander, WY · Accident · No injuries · Limited investigation · Final report · Dec 22, 1982 · N756CK · Substantial damage > The aircraft nose wheel collapsed during landing. The plane then turned left went off the runway and collided with a snowbank. An examination of the aircraft revealed no evidence of a mechanical malfunction or failure of the nose gear prior to touchdown. - [NTSB CHI83LA064](https://openairdocs.org/ntsb/CHI83LA064.md): Cessna 152 · Ridott, IL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1982 · N6477P · Substantial damage > This was the pilot's first operation on the 1320 ft strip. After touchdown, he encountered poor braking action and attempted to go around. When he realized he had insufficient runway remaining, he aborted the go-around. Subsequently, the aircraft collided… - [NTSB ATL83FKG06](https://openairdocs.org/ntsb/ATL83FKG06.md): Quickie 2 · Stockbridge, GA · Accident · No injuries · Final report · Dec 22, 1982 · N14QP · Substantial damage > Reportedly, when the aircraft was landed, it touched down long and with excessive airspeed. The aircraft veered off the right side of the runway, when brakes were applied, and overturned. The wind was report as light and variable. - [NTSB MKC83IA042](https://openairdocs.org/ntsb/MKC83IA042.md): Piper PA31-350 · Waterloo, IA · Incident · No injuries · Incident investigation · Final report · Dec 21, 1982 · N600TS · Minor damage > Prior to landing N600TS reportedly had an unsafe nose gear down indication. At landing touchdown, the nose gear collapsed. Examination revealed no evidence of mechanical malfunction however the bearing ends, p/n 452-412, showed evidence of overload failure.… - [NTSB FTW83LA064](https://openairdocs.org/ntsb/FTW83LA064.md): Beech E33 · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Dec 21, 1982 · N7873R · Substantial damage > During the landing roll, all three of the landing gear retracted as the pilot was applying brakes to turn off at the first exit. FAA inspectors found the landing gear handle in the down position with the circuit breaker popped. The flaps were also found in… - [NTSB ATL83IA070](https://openairdocs.org/ntsb/ATL83IA070.md): Piper PA-24-250 · Moultrie, GA · Incident · No injuries · Incident investigation · Final report · Dec 21, 1982 · N6262P · Minor damage > The pilot was making a refueling stop in Moultrie, GA when the aircraft touched down on runway 14 at spence field with the landing gear in the up position. The pilot does not recall what events led to the wheels up landing. On exiting the aircraft, he noted… - [NTSB ATL83FID03](https://openairdocs.org/ntsb/ATL83FID03.md): Cessna 150 · Lynchburg, VA · Accident · Serious injuries · Final report · Dec 21, 1982 · N11181 · Destroyed > The acft was observed on final drifting right. It then rolled sharply to the left back towards the trees south of rwy 28. The acft pulled up to a steep climb into a left turn & disappeared over the trees. The acft was found nose down in a vertical position on… - [NTSB ANC83LA025](https://openairdocs.org/ntsb/ANC83LA025.md): Piper PA-18-150 · Alexander Creek, AK · Accident · No injuries · Limited investigation · Final report · Dec 21, 1982 · N742GF · Substantial damage > The pilot landed on rough, snow covered terrain and the landing gear collapsed. This aircraft had an out of date annual inspection. - [NTSB FTW83LA063](https://openairdocs.org/ntsb/FTW83LA063.md): Cessna 421C · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Dec 20, 1982 · N78TV · Substantial damage > Nose gear collapsed during landing. No reason for collapse found. - [NTSB ATL83LA069](https://openairdocs.org/ntsb/ATL83LA069.md): Piper PA-34-200 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Dec 20, 1982 · N41336 · Substantial damage > The pilot landed on runway 23 with winds that were variable from 250 to 290 deg at 14 gusting 24 KTS. With these winds, the maximum crosswind component would have been about 21 KTS. The maximum demonstrated crosswind component for this aircraft was 15 KTS.… - [NTSB MIA83LA053](https://openairdocs.org/ntsb/MIA83LA053.md): Piper PA-23 · Stuart, FL · Accident · No injuries · Limited investigation · Final report · Dec 19, 1982 · N4981P · Substantial damage > Aircraft made a hard landing and damaged wings. - [NTSB CHI83IA063](https://openairdocs.org/ntsb/CHI83IA063.md): Douglas DC9-30 · Pellston, MI · Incident · No injuries · Incident investigation · Final report · Dec 19, 1982 · N9344 · No damage > Before departing traverse city the captain was informed that emmet city arpt was sanded at about 1736 and that icy runway conditions were turning to slush. He was also told that rwy 32 would be sanded again prior to his arrival. This was accomplished, with a… - [NTSB ANC83LA024](https://openairdocs.org/ntsb/ANC83LA024.md): de Havilland DHC-2 · Near Port Alswo, AK · Accident · No injuries · Limited investigation · Final report · Dec 18, 1982 · N94DC · Substantial damage > While landing on the 3,500 ft level of tuxedni glacier the acft skis sank in deep soft snow & the acft flipped over. - [NTSB FTW83FRA03](https://openairdocs.org/ntsb/FTW83FRA03.md): S.N.I.A.S. AS350D · Houston, TX · Accident · Serious injuries · Final report · Dec 16, 1982 · N801DB · Destroyed > The pilot stated that as he came to a hover to land, an engine surge occurred which sent the helicopter back into the air. Reportedly, the engine continued to surge off and on, and as helicopter came down, it would impact the ground and bounce back in the… - [NTSB FTW83LA059](https://openairdocs.org/ntsb/FTW83LA059.md): Piper PA-28-140 · Solgohachia, AR · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 1982 · N7325F · Substantial damage > Pilot overran runway and slid on grass into a tree. Pilot says he did not go-around because of rise in terrain. - [NTSB LAX83LUG09](https://openairdocs.org/ntsb/LAX83LUG09.md): Cessna 170B · Big Bear City, CA · Accident · No injuries · Final report · Dec 14, 1982 · N2962D · Substantial damage > The accident occured after touchdown when the pilot temporarily lost control and the aircraft veered off the runway. The wing and propeller collided with a frozen snow bank. - [NTSB ATL83LA064](https://openairdocs.org/ntsb/ATL83LA064.md): Mitsubishi MU-2 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Dec 14, 1982 · N522MA · Substantial damage > On landing a scraping sound was heard and a go-around was performed. While on downwind, for the second landing, the gear handle was observed in the gear-up position. The gear was lowered and an uneventful landing was made. - [NTSB NYC83LA043](https://openairdocs.org/ntsb/NYC83LA043.md): Piper PA-23-250 · Fall River, MA · Accident · No injuries · Limited investigation · Final report · Dec 13, 1982 · N62635 · Substantial damage > On short final & aligned with the rwy lights the plt cancelled his IFR flt plan with approach control. The acft landed on the rwy which had the middle third of its width covered with 6-8 inches of snow. The outer thirds were plowed but icy. - [NTSB MKC83IA036](https://openairdocs.org/ntsb/MKC83IA036.md): Beech B200 · Chesterfield, MO · Incident · No injuries · Incident investigation · Final report · Dec 13, 1982 · N6338T · Minor damage > Upon arrival over chicago, IL, the crew discovered that the landing gear would not extend. After numerous unsuccessful attempts to lower the gear, the crew elected to return to their home base airport and make a gear up landing. The landing was successful and… - [NTSB FTW83LA058](https://openairdocs.org/ntsb/FTW83LA058.md): Cessna 172 · Katy, TX · Accident · No injuries · Limited investigation · Final report · Dec 12, 1982 · N54667 · Substantial damage > During landing the nose wheel contacted a 12 inch rice field type mud dam & the acft flipped over. - [NTSB FTW83LA056](https://openairdocs.org/ntsb/FTW83LA056.md): Luscombe 8A · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Dec 12, 1982 · N1026K · Substantial damage > Pilot used brakes to attempt to straighten aircraft veering in crosswind and aircraft nosed over. - [NTSB CHI83LA056](https://openairdocs.org/ntsb/CHI83LA056.md): Cessna 172 · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Dec 12, 1982 · N62332 · Substantial damage > The student pilot touched down on runway 06, bounced, the nose gear collapsed and the pilot loss direction control. The aircraft nosed over. - [NTSB MIA83LA049](https://openairdocs.org/ntsb/MIA83LA049.md): Cessna 182Q · Ocoee, FL · Accident · No injuries · Limited investigation · Final report · Dec 11, 1982 · N95897 · Substantial damage > Plt approached with a higher than normal airspeed. The acft touched down nose wheel first about 1/3 down the rwy collapsing the nose gear causing the propeller to strike the rwy. - [NTSB CHI83LA057](https://openairdocs.org/ntsb/CHI83LA057.md): Colonial C-1 · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Dec 11, 1982 · N256B · Substantial damage > Pilot lost oil pressure and elected to land in a plowed field. Nose gear collapsed during landing. Oil leak was the cause of the drop in quantity and pressure. - [NTSB MKC83LA034](https://openairdocs.org/ntsb/MKC83LA034.md): Cessna 140 · Alliance, NE · Accident · No injuries · Limited investigation · Final report · Dec 9, 1982 · N89838 · Substantial damage > Right landing gear collapsed during landing. A hole was found drilled through strut. The hole was not shown on parts catalog. - [NTSB LAX83LVM05](https://openairdocs.org/ntsb/LAX83LVM05.md): Pitts S1C · 6 N.W. Half Moo, CA · Accident · No injuries · Final report · Dec 9, 1982 · N2363 · Substantial damage > Aircraft landed and a gust of wind turned the aircraft. Aircraft continued off right side of runway and nosed over in soft ground. - [NTSB CHI83LA053](https://openairdocs.org/ntsb/CHI83LA053.md): Cessna T210 · Frankfort, IL · Accident · No injuries · Limited investigation · Final report · Dec 8, 1982 · N6195Y · Substantial damage > After touchdown the right wing of the aircraft suddenly lifted, directional control was lost and the aircraft struck a row of trees. - [NTSB ATL83LA055](https://openairdocs.org/ntsb/ATL83LA055.md): Pitts Special 51C · London, KY · Accident · No injuries · Limited investigation · Final report · Dec 8, 1982 · N2148 · Substantial damage > The aircraft ground looped during landing. Investigation revealed there was slight crosswind and the tail wheel steering spring failed. - [NTSB NYC83IA040](https://openairdocs.org/ntsb/NYC83IA040.md): Aeronca 11AC · Monticello, NY · Incident · No injuries · Incident investigation · Final report · Dec 7, 1982 · N3809E · Minor damage > As the flight made a three point landing in strong, gusting, left crosswinds, a gust of wind lifted the aircraft's left wing. Directional control was lost and the aircraft departed the right side of the runway. It came to rest at the bottom of a grassy slope… - [NTSB LAX83FVM04](https://openairdocs.org/ntsb/LAX83FVM04.md): Swearingen SA226-T · San Francisco, CA · Accident · No injuries · Final report · Dec 7, 1982 · N4273X · Substantial damage > During arrival, the winds were reported from 350 to 360 deg at 20 gusting 25 KTS, and while landing, they were from 360 deg at 21 KTS. The acft's max demo x-wind capability was 22 KTS. The plt reported that during the landing, the power levers were retarded… - [NTSB DCA83AA009](https://openairdocs.org/ntsb/DCA83AA009.md): Swearingen SA-226TC · Chantilly, VA · Accident · No injuries · Final report · Dec 7, 1982 · N126AV · Substantial damage > Approaching the arpt the flt was given vectors to rwy 01L & cleared to descend to 2,000 ft. the controller requested that the plt expedite the descent through 3,000 ft. the first officer, who was flying the acft, requested the gear down. The captain stated… - [NTSB MIA83LA044](https://openairdocs.org/ntsb/MIA83LA044.md): Cessna 210L · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Dec 6, 1982 · N1666X · Substantial damage > The pilot attempted to extend the landing gear using both normal and emergency procedures. All attempts to lower the gear were unsuccessful. The pilot landed gear up on a foamed runway. Investigation revealed that the landing gear power pack solenoid, part… - [NTSB NYC83FHA02](https://openairdocs.org/ntsb/NYC83FHA02.md): Cessna 182G · Rocky Hill, NJ · Accident · Serious injuries · Final report · Dec 5, 1982 · N2366R · Destroyed > The acft touched down on the last third of the rwy, made a series of bounces followed by a go-around at which time the acft collided with several tree tops & crashed. - [NTSB ATL83IA053](https://openairdocs.org/ntsb/ATL83IA053.md): Piper PA-23-250 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Dec 5, 1982 · N501BC · Minor damage > The pilot reported that he had 3 green lights after extending the landing gear. During landing roll, the left main ldg gr collapsed for an undetermined reason. The landing gear handle was found in the down position. - [NTSB FTW83LA076](https://openairdocs.org/ntsb/FTW83LA076.md): Cessna 340A · Austin, TX · Accident · No injuries · Limited investigation · Final report · Dec 2, 1982 · N4326C · Substantial damage > The pilot reported that while on final approach to land, full flaps were extended as the aircraft crossed over a hill immediately before the runway threshold. After full flaps were selected, the aircraft entered a high sink rate and landed hard on the end of… - [NTSB DEN83LA029](https://openairdocs.org/ntsb/DEN83LA029.md): Cessna 310R · Miles City, MT · Accident · No injuries · Limited investigation · Final report · Dec 2, 1982 · N30RA · Substantial damage > After executing a missed approach to rwy 22 the acft began accumulating rime ice. An approach was made to rwy 4. The acft had accumulated about 1/4 in ice, & during the flare the acft shuddered & stalled onto the rwy. - [NTSB DEN83LA028](https://openairdocs.org/ntsb/DEN83LA028.md): Cessna T188C · Santa Rita, MT · Accident · No injuries · Limited investigation · Final report · Dec 1, 1982 · N2066J · Substantial damage > Aircraft nosed over during landing. Aircraft was swerving left after brake application. More braking was used and aircraft nosed over. - [NTSB FTW83LA048](https://openairdocs.org/ntsb/FTW83LA048.md): Piper PA-38-112 · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Nov 30, 1982 · N2521N · Substantial damage > On landing the pilot elected to make a go-around due to gusty wind conditions. On the next landing attempt the pilot initiated a go-around from short final at an altitude of approximately 30 feet. The pilot was unable to maintain alignment with the runway,… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?year=1982&page=2 ## 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") = 1982 AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?year=1982 --- 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.