# NTSB investigations: Enroute 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 381 of 718 · 35,889 cases ## Cases, newest first - [NTSB LAX82FVG29](https://openairdocs.org/ntsb/LAX82FVG29.md): Cessna 150 · Sacramento, CA · Accident · No injuries · Final report · Jul 21, 1982 · N22912 · Substantial damage > The purpose of the flight was to "shakedown" the aircraft and to break in a newly overhauled engine. A thorough preflight was made and some water was drained from the fuel tanks. (The aircraft had not been flown for some period of time.) While climbing after… - [NTSB CHI82DA265](https://openairdocs.org/ntsb/CHI82DA265.md): Eagle DW-1 · Murdock, MN · Accident · No injuries · Final report · Jul 21, 1982 · N8801Y · Substantial damage > The pilot was en route to a bean field when the ground adjustable propeller came out of adjustment. The pilot dumped the load and made a forced landing in a beanfield. During the landing, the aircraft nosed over and was substantially damaged. An investigation… - [NTSB NYC82FNC11](https://openairdocs.org/ntsb/NYC82FNC11.md): Firefly 7 · Winslow, ME · Accident · Serious injuries · Final report · Jul 20, 1982 · N4041P · Substantial damage > While descending to land in an open field, the balloon began drifting towards high powerlines. In an attempt to avoid a collision, the pilot fired the burner approximately nine times, using short blasts of the burner. The balloon failed to gain altitude and… - [NTSB FTW82DA285](https://openairdocs.org/ntsb/FTW82DA285.md): Aerospatiale AS-350D · Gulf Of Mexico · Accident · No injuries · Final report · Jul 19, 1982 · N5771L · Substantial damage > During an over water flight, the engine chip detector light illuminated and shortly thereafter, the engine failed. The pilot made an autorotative landing in the Gulf Of Mexico with no further damage. All three rotor blades were full of holes and tears and one… - [NTSB LAX82DA265](https://openairdocs.org/ntsb/LAX82DA265.md): Air Tractor AT-301 · San Joaquin, CA · Accident · No injuries · Final report · Jul 18, 1982 · N4326S · Substantial damage > The aircraft engine started running rough on a ferry flight and the pilot decided to make a precautionary landing in a cotton field. During the landing the aircraft nosed over. - [NTSB ATL82FID11](https://openairdocs.org/ntsb/ATL82FID11.md): Volmer VJ-22 · Lewiston, VA · Accident · No injuries · Final report · Jul 18, 1982 · N2297Z · Destroyed > Pilot ferrying aircraft to new owner and lost power. A hard forced landing was made in a pasture. Aircraft contacted ground at a 30 degree angle which failed landing gear. Pilot had zero time in the aircraft prior to this flight. Owner of aircraft had power… - [NTSB SEA82FYP09](https://openairdocs.org/ntsb/SEA82FYP09.md): Cessna 172M · Wenatchee, WA · Accident · 3 fatal · Final report · Jul 17, 1982 · N72655 · Destroyed > Reportedly, the pilot, a geologist, was on a flight to check rock formations. Prior to the accident, the plane was observed flying up a canyon at low altitude and airspeed. About 3/4 mile from the accident site, two witnesses on a rocky cliff at about 3500 ft… - [NTSB LAX82FA260](https://openairdocs.org/ntsb/LAX82FA260.md): Cessna TR182 · Happy Camp, CA · Accident · 5 fatal · Field investigation · Final report · Jul 17, 1982 · N736EY · Destroyed > The aircraft impacted the side of a narrow and steep canyon in a climb attitude. The weather was VFR. The crash occurrednorthwest of the departure point after about 1 hour and 15 minutes of flight. No flight plan was filed, destination was not determined. - [NTSB ANC82DA060](https://openairdocs.org/ntsb/ANC82DA060.md): Piper PA-22 · 65 Mi.Ene Of Mc, AK · Accident · No injuries · Final report · Jul 17, 1982 · N891A · Substantial damage > During flight, the pilot noticed a progressive loss of power. He elected to make an emergency landing on a gravel bar. During the landing, the aircraft rolled through a shallow slough where the left main gear hit a log. The nose gear then hit a bank at the… - [NTSB NYC82DA156](https://openairdocs.org/ntsb/NYC82DA156.md): Downer Aircraft Industries Republic RC-3 · Southwick, MA · Accident · Minor injuries · Final report · Jul 16, 1982 · N6426K · Substantial damage > During flight, the engine began to run rough. The pilot attempted to correct the situation but the engine continued to operate at reduced power. He elected to land the amphibious plane in a field and extended the gear. However the pilot saw that the aircraft… - [NTSB LAX82FA262](https://openairdocs.org/ntsb/LAX82FA262.md): Cessna T-210L · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1982 · N66GH · Destroyed > The pilot was descending in a mountainous area and did not clear the high terrain before collision with the ground occurred. The pilot was in radio communication with Reno tower and was given landing instructions. There was no verbal indication of trouble on… - [NTSB LAX82FA258](https://openairdocs.org/ntsb/LAX82FA258.md): Cessna 210L · Santa Ana, CA · Accident · Minor injuries · Field investigation · Final report · Jul 16, 1982 · N59242 · Substantial damage > About 3 mi se of the arpt, with gear down & full flaps, the eng fuel pressure went to zero & the eng lost power. The pltdid not declare an emergency, but advised tower that the acft lost the fuel pressure. The plt was then cleared for a landing on rwy 19R. As… - [NTSB LAX82AA259](https://openairdocs.org/ntsb/LAX82AA259.md): Mcdonnell Douglas DC-10-10 · Morton, WY · Accident · Serious injuries · Final report · Jul 16, 1982 · N1815U · Minor damage > While flying in good wx over central Wyoming, the captain noted a gentle wave motion that caused the autothrottles to react. Therefore, he disengaged the autothrottles and autopilot. The acft had lost 250 ft drg the wave motion, so the captain turned on the… - [NTSB SEA82DA112](https://openairdocs.org/ntsb/SEA82DA112.md): Bell 47G-2 · Harrah, WA · Accident · Serious injuries · Final report · Jul 15, 1982 · N6145C · Substantial damage > The pilot reported that before taking off, the fuel quantity guages indicated there was sufficient fuel to complete one more load and still have an adequate reserve. After dispensing the load, the engine lost power while he was returning to the nurse truck.… - [NTSB NYC82FA155](https://openairdocs.org/ntsb/NYC82FA155.md): Cessna 177RG · Cross Fork, PA · Accident · 4 fatal · Field investigation · Final report · Jul 15, 1982 · N7584V · Destroyed > At 2132 the plt contacted fss reporting his position, lightning to his east & requested wx around his position. He was advised of thunderstorm activity, deteriorating conditions & that VFR flt was not recommended. He was also advised to reverse course. At… - [NTSB ATL82IA198](https://openairdocs.org/ntsb/ATL82IA198.md): Cessna 177RG · Near Sparta, GA · Incident · No injuries · Incident investigation · Final report · Jul 15, 1982 · N33226 · Minor damage > The aircraft experienced power failure while in cruise flight en route from wilmington, NC to atlanta ga. Following the power loss, the pilot landed gear up in an open field Near Sparta, GA. Investigation revealed that the aircraft had last been refueled on… - [NTSB ATL82FA196](https://openairdocs.org/ntsb/ATL82FA196.md): Piper PA-24-250 · Roswell, GA · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1982 · N6868P · Destroyed > About 12 minutes after takeoff the plt reported "...alternator or generator trouble" & requested to return to the arpt. He later reported that he was having radio problems. The plt was vectored to intercept the ILS rwy 20L apch course. The accident occurred… - [NTSB MIA82DA154](https://openairdocs.org/ntsb/MIA82DA154.md): Bellanca 17-31 · Lake Wales, FL · Accident · No injuries · Final report · Jul 14, 1982 · N7373V · Destroyed > The aircraft was on a maintenance flight to check a recently installed engine oil temperature gauge. After determining that the gauge was operating satisfactorily, the pilot began a descent toward the airport. While descending through 3000 ft, the pilot… - [NTSB FTW82DA281](https://openairdocs.org/ntsb/FTW82DA281.md): Bell 206B · Sabine, TX · Accident · No injuries · Final report · Jul 14, 1982 · N116AL · Substantial damage > During flight at about 500 ft AGL, the engine lost power. The pilot began an autorotative landing and made a mayday call. He autorotated to a marshy area which had 4 to 5 ft grass. The helicopter touched down hard and the main rotor blades flexed down and… - [NTSB MIA82DA153](https://openairdocs.org/ntsb/MIA82DA153.md): Piper PA-18 · Kenneth City, FL · Accident · Minor injuries · Final report · Jul 13, 1982 · N225NY · Substantial damage > While cruising the aircraft oil pressure dropped and smoke entered the cockpit, so made a forced landing in a small field. The aircraft hit a stump and nosed over. An investigation revealed a broken oil line to a pressure gauge and oil leaked on a hot exhaust… - [NTSB FTW82DA280](https://openairdocs.org/ntsb/FTW82DA280.md): Piper PA-38-112 · New Braunfels, TX · Accident · No injuries · Final report · Jul 13, 1982 · N25187 · Substantial damage > The pilot reported that as he attempted to apply power at the end of a descent, the engine failed to respond. Approach control provided vectors to an airport, but the aircraft was too low to reach it. The pilot selected a road for a landing, but noticed power… - [NTSB ATL82DA214](https://openairdocs.org/ntsb/ATL82DA214.md): Hiller UH-12E · Centre, AL · Accident · No injuries · Final report · Jul 13, 1982 · N28872 · Substantial damage > While returning from a spraying operation, the pilot was flying low toward the rising sun when the helicopter collided with power lines. An autorotation was initiated, but the skids collapsed during the landing. - [NTSB FTW82DA279](https://openairdocs.org/ntsb/FTW82DA279.md): Grumman G-164B · Beedeville, AR · Accident · No injuries · Final report · Jul 12, 1982 · N6678K · Destroyed > The pilot proceeded to the job site with a load of urea. He circled for about 15 minutes waiting for the flagmen to arrive, then elected to return to the airport. As he leveled the plane, he experienced a gradual loss of power and was unable to maintain… - [NTSB CHI82DA246](https://openairdocs.org/ntsb/CHI82DA246.md): Republic RC-3 · Saginaw, MI · Accident · No injuries · Final report · Jul 12, 1982 · N6444K · Substantial damage > The pilot stated that he took off with 35 gal of fuel aboard. After about 128 nautical miles, the engine lost power. While landing in a muddy corn field with the gear retracted, the aircraft slid a short distance then nosed over. One of the first persons to… - [NTSB ANC82DAG35](https://openairdocs.org/ntsb/ANC82DAG35.md): Piper PA-28-140 · Wasilla, AK · Accident · Minor injuries · Final report · Jul 12, 1982 · N9891W · Substantial damage > Pilot had opportunity to refuel and did not. On one flight before accident he successfully made a forced landing due to fuel starvation. He figured he had enough fuel for one more flight. During this flight engine quit and the pilot landed in a ditch… - [NTSB SEA82FYP08](https://openairdocs.org/ntsb/SEA82FYP08.md): Lark IS28B2 · Springdale, WA · Accident · Serious injuries · Final report · Jul 11, 1982 · N9255Z · Destroyed > The pilot received an aerial tow to 5000 feet and was able to find lifting currents for approximately 1.5 hours. Unable to obtain adequate lift the pilot decided to attempt an off airport landing on a dirt road crossing a wheat field. At an altitude of… - [NTSB NYC82FA148](https://openairdocs.org/ntsb/NYC82FA148.md): Gulfstream American AA-5B · Newburg, PA · Accident · 1 fatal · Field investigation · Final report · Jul 11, 1982 · N28970 · Destroyed > The pilot on a personal cross-country flew into trees on a slope of blue mountain, PA at the 2284 foot level. The weather in the area was foggy and the mountain tops were obscured in clouds. There is no record of a weather briefing or communication by the… - [NTSB ANC82FA056](https://openairdocs.org/ntsb/ANC82FA056.md): Bell 212 · 38 Se Barrow, AK · Accident · Minor injuries · Field investigation · Final report · Jul 11, 1982 · N59572 · Substantial damage > While executing a precautionary landing after hearing a screeching sound the plt lost directional control & the helicopter landed while spinning. Examination revealed that the primary tail rotor driveshaft quill coupling had failed. The 204-040-604-5 female… - [NTSB NYC82DA152](https://openairdocs.org/ntsb/NYC82DA152.md): Enstrom F28A · Hammonton, NJ · Accident · No injuries · Final report · Jul 10, 1982 · N22BF · Substantial damage > The pilot performed an autorotation when the aircraft's engine lost power. Examination revealed no preimpact malfunction or failure. - [NTSB NYC82FNA19](https://openairdocs.org/ntsb/NYC82FNA19.md): Breezy RL4-1 · Andover, MA · Accident · No injuries · Final report · Jul 9, 1982 · N2343 · Substantial damage > During flt the plt felt something snap or break on the acft. The control wheel movement for the aileron became exceedingly harder to move & the acft started to flutter in an up & down motion. He reduced power to slow the flutteringaction, but was not able to… - [NTSB NYC82DA147](https://openairdocs.org/ntsb/NYC82DA147.md): Piper PA-18-150 · Cape May, NJ · Accident · No injuries · Final report · Jul 9, 1982 · N6897B · Substantial damage > After departing on a banner towing mission, the pilot experienced a sudden power loss. He had insufficient power and altitude to return to the field and elected to ditch in a creek. An examination of the engine revealed that the no.2 exhaust valve, pn 75068,… - [NTSB FTW82DA274](https://openairdocs.org/ntsb/FTW82DA274.md): Cessna 152 · Bryan, TX · Accident · Minor injuries · Final report · Jul 9, 1982 · N24890 · Substantial damage > While on a solo cross-country flight, the student pilot landed twice for fuel, but his credit cards were not accepted to obtain services. He was told that the cards would be acceptable at coulter field which was 7 mi away. He visually checked the fuel and… - [NTSB CHI82DA242](https://openairdocs.org/ntsb/CHI82DA242.md): Grumman American AA-1B · Near Zanesville, OH · Accident · No injuries · Final report · Jul 9, 1982 · N32NA · Substantial damage > During flight in his newly purchased aircraft, the pilot let his right tank run dry. He then switched to his left tank which he believed was more than 1/2 full. After flying about 15 miles further, the engine began running rough and then quit. While landing… - [NTSB ATL82DA192](https://openairdocs.org/ntsb/ATL82DA192.md): Piper PA-28-180R · Carrollton, GA · Accident · No injuries · Final report · Jul 9, 1982 · N7550J · Substantial damage > During cruise flight the pilot smelled oil followed shortly thereafter by the engine oil pressure going to zero and then the engine failing. The pilot made a forced landing in a field where the left main gear collapsed after contacting a rock. Investigation… - [NTSB FTW82DA271](https://openairdocs.org/ntsb/FTW82DA271.md): Cessna 182J · Munester, TX · Accident · No injuries · Final report · Jul 7, 1982 · N2405Q · Destroyed > During flight, the engine began losing power and both occupants detected a strong odor of gasoline. The pilot made a successful forced landing in a field. He stated that the engine lost all power on final approach. After coming to a stop, the pilot and… - [NTSB ATL82DA191](https://openairdocs.org/ntsb/ATL82DA191.md): Beech V35 · Huntington, WV · Accident · No injuries · Final report · Jul 6, 1982 · N7969M · Substantial damage > Before departing st louis, MO, attempts to restart the engine were unsuccessful until an auxiliary power unit was used. The aircraft took off at 1746, and about one hour later, the pilot noticed that the ammeter indicated a discharge. The flight was… - [NTSB NYC82IA137](https://openairdocs.org/ntsb/NYC82IA137.md): Boeing 727-233 · Flushing, NY · Incident · No injuries · Incident investigation · Final report · Jul 5, 1982 · CGAAA · Minor damage > During initial climb, the amber leading edge flat light remained lit after flap retraction from 5 degrees to 2 degrees. Moderate aileron and rudder inputs were required to maintain wings level flight. After cycling the flaps from 5 back to 2 degrees, the same… - [NTSB NYC82FGM12](https://openairdocs.org/ntsb/NYC82FGM12.md): Aerospatiale SA 316B · Crafton, PA · Accident · No injuries · Final report · Jul 5, 1982 · N8259 · Substantial damage > Shortly after takeoff the pilot heard a loud grinding noise and felt a vibration emanating from the rear of the aircraft. Immediately, the nose yawed to the left and the engine failed. The pilot entered autoration and made a hard landing. Examination of the… - [NTSB NYC82DA142](https://openairdocs.org/ntsb/NYC82DA142.md): Beech B23 · North Castle, NY · Accident · Minor injuries · Final report · Jul 5, 1982 · N9133T · Substantial damage > Aircraft was ditched and sank in a reservoir in 20 feet of water after the engine failed in flight. The crankshaft was found to be fractured when aircraft was raised. Oil had sprayed on the windshield. Avco-lycoming part number that failed was 74968 serial… - [NTSB MIA82DA157](https://openairdocs.org/ntsb/MIA82DA157.md): Piper PA-28R-201T · West Of Cross C, FL · Accident · 4 fatal · Final report · Jul 5, 1982 · N505HP > At about 1605 CDT, the pilot activated his VFR flight plan from nashville, TN to venice, FL. At 1813, the pilot contacted tallahasee fss and was briefed on the weather conditions to sarasota, FL. This was the last known radio communication with the aircraft.… - [NTSB CHI82DA235](https://openairdocs.org/ntsb/CHI82DA235.md): Grumman American AA-1C · Danville, IL · Accident · Minor injuries · Final report · Jul 5, 1982 · N9830U · Destroyed > The student pilot stated that at 3000 ft, 14 NM north of the Danville VOR, the engine began vibrating. The engine lost power and the pilot was forced to land in a bean field approximately 4 miles north of the Danville airport. Engine examination revealed the… - [NTSB LAX82FA242](https://openairdocs.org/ntsb/LAX82FA242.md): Bell 206B · Grand Canyon, AZ · Accident · No injuries · Field investigation · Final report · Jul 4, 1982 · N4778R · Substantial damage > Pilot lost power during sight-seeing flight and decided to make a precautionary landing. He aborted one landing due to wind and was at 50 AGL for 2nd attempt when power decreased. Due to wind and lack of power the aircraft made contact with a tree and the… - [NTSB LAX82DA243](https://openairdocs.org/ntsb/LAX82DA243.md): Cessna 182J · Deer Valley, AZ · Accident · No injuries · Final report · Jul 4, 1982 · N3317F · Substantial damage > While climbing through about 6500 ft, a loud bang was heard and the pilot saw the engine cowling buckle. About 10 seconds later, the engine ceased to operate. The pilot declared an emergency and landed on an uncontrolled airport. After landing, an examination… - [NTSB FTW82DA267](https://openairdocs.org/ntsb/FTW82DA267.md): Cessna 182G · Abbeyville, LA · Accident · No injuries · Final report · Jul 4, 1982 · N2408R · Destroyed > The pilot reported that he had taken off on a local flight and was at about 1000 ft AGL when the engine lost power. He attempted to restart the engine, but was unable. The aircraft was landed firmly on a roadway. The pilot smelled gas fumes and exited from… - [NTSB FTW82DA266](https://openairdocs.org/ntsb/FTW82DA266.md): Great Lakes 2T-1A-2 · Mexia, TX · Accident · No injuries · Final report · Jul 4, 1982 · N5762N · Substantial damage > The aircraft nosed over during a landing on the taxiway. The pilot said he landed on the taxiway because his engine quit. - [NTSB FTW82DA265](https://openairdocs.org/ntsb/FTW82DA265.md): Aero Commander 100 · Dekalb, TX · Accident · No injuries · Final report · Jul 4, 1982 · N3780X · Substantial damage > The pilot lost power during a local flight and attempted a landing on a highway. Control was lost and aircraft collided with a fence. The aircraft was landed downwind. Post accident check showed 125 mag drop on both mags and a maximum static of 2350. - [NTSB CHI82DA237](https://openairdocs.org/ntsb/CHI82DA237.md): Waco UPF-7 · Popular Grove, IL · Accident · No injuries · Final report · Jul 4, 1982 · N39714 · Substantial damage > The pilot experienced severe engine vibration during cruise flight. The pilot performed an emergency landing in a field. Because of the length of the field the pilot landed hard and the left main gear collapsed. The separated gear struck and fractured the… - [NTSB ATL82DA194](https://openairdocs.org/ntsb/ATL82DA194.md): Cessna 182 · Madison, IN · Accident · Minor injuries · Final report · Jul 4, 1982 · N5584B · Destroyed > The pilot reported that he experienced a gradual loss of power on a dark night. The terrain was hilly and covered with trees, and reportedly, the pilot elected to land upwind on the Ohio river. After ditching, the occupants egressed and swam to shore, but the… - [NTSB FTW82FRA24](https://openairdocs.org/ntsb/FTW82FRA24.md): Blanik L-13 · Katy, TX · Accident · Serious injuries · Final report · Jul 3, 1982 · N273AS · Substantial damage > The pilot rented the glider after a flight check-out was completed and was given an aerial tow to an altitude of approximately 2000 feet. According to the passenger, the pilot became disoriented and lost sight of the airport. Unable to find any lifting… - [NTSB CHI82DA233](https://openairdocs.org/ntsb/CHI82DA233.md): Cessna 150M · Santisgo, MN · Accident · No injuries · Final report · Jul 3, 1982 · N63183 · Substantial damage > During aerial photo mission engine began to run rough. Pilot headed home but was forced to land enroute. Aircraft swerved and nosed over. Exam of engine showed exhaust valve stuck open. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=382 ## 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 c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=381 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.