# NTSB investigations: Emergency descent 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 8 of 11 · 505 cases ## Cases, newest first - [NTSB MIA93LA077](https://openairdocs.org/ntsb/MIA93LA077.md): Beech N35 · Fort Meade, FL · Accident · No injuries · Limited investigation · Final report · Feb 28, 1993 · N1354Z · Substantial damage > The collision with a road sign during a forced landing. Contributing to the accident was the total loss of engine power due to fatigue failure of the crankshaft. - [NTSB ANC92LA160](https://openairdocs.org/ntsb/ANC92LA160.md): Dale Conover Tundra PUP · Beluga, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1992 · N2072Y · Substantial damage > The inadequate preflight planning/preparation by the pilot. A factor was the pilot misjudged his clearance from the trees. - [NTSB CHI92LA252](https://openairdocs.org/ntsb/CHI92LA252.md): Cameron N-90 · Centralia, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 1992 · N75250 · No damage > Abrupt touchdown. - [NTSB ANC92LA094](https://openairdocs.org/ntsb/ANC92LA094.md): Piper PA-22 · Oshetna River, AK · Accident · No injuries · Limited investigation · Final report · Jun 15, 1992 · N3516P · Destroyed > The tailwind and the pilot not understanding the effects. Factors relating to the accident were the attempted precautionary landing and the high vegetation in the forced landing area. - [NTSB FTW92DPD01](https://openairdocs.org/ntsb/FTW92DPD01.md): Eichblatt X-5 · Fort Worth, TX · Accident · 1 fatal · Final report · Apr 19, 1992 · N99747 · Substantial damage > The loss of engine power for undetermined reasons and an inadvertent stall. A factor was the pilot's lack of familiarity with the airplane. - [NTSB LAX91LA414](https://openairdocs.org/ntsb/LAX91LA414.md): Let L-13 · Adelanto, CA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1991 · N86661 · Substantial damage > Improper planning/decision by the pilot. Loss of thermal lift was a related factor. - [NTSB DEN91LA134](https://openairdocs.org/ntsb/DEN91LA134.md): Abernathy LONG-EZ · Raton, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 1991 · N123LH · Substantial damage > Physical impairment of the pilot. Factors were: rough terrain. - [NTSB LAX91LA346](https://openairdocs.org/ntsb/LAX91LA346.md): Schweizer SGS 126E · Sutcliffe, NV · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 1991 · N65932 · Substantial damage > The pilot's inadvertent stall of the glider. - [NTSB FTW91LA121](https://openairdocs.org/ntsb/FTW91LA121.md): Bell 206B · Freeport, TX · Accident · No injuries · Limited investigation · Final report · Jul 14, 1991 · N16962 · Substantial damage > The pilot's failure to maintain sufficient rotor RPM during the autorotation. Factors were the fuel exhaustion induced power loss due to the pilot's improper pre-flight inspection. - [NTSB ANC91LA092](https://openairdocs.org/ntsb/ANC91LA092.md): Cessna 152 · Woodchopper Crk, AK · Accident · No injuries · Limited investigation · Final report · Jul 6, 1991 · N6276P · Substantial damage > Engine failure due to fuel exhaustion, the pilot's inadequate preflight planning and the unsuitable terrain. Contributing to the accident was the pilot's lack of total experience. - [NTSB NYC91LA169](https://openairdocs.org/ntsb/NYC91LA169.md): Cessna 172 · Millville, OH · Accident · No injuries · Limited investigation · Final report · Jul 5, 1991 · N21662 · Substantial damage > The pilot's improper in-flight planning/decision after becoming lost, resulting in engine fuel exhaustion. Factors related to the accident were: the pilot's lack of familiarity with the geographic area, and his lack of experience in this type of operation. - [NTSB CHI91FA159](https://openairdocs.org/ntsb/CHI91FA159.md): Luscombe 8E · Clinton, MI · Accident · 1 fatal · Field investigation · Final report · May 20, 1991 · N333LR · Substantial damage > Physical impairment of the pilot due to heart attack. - [NTSB LAX91FA209](https://openairdocs.org/ntsb/LAX91FA209.md): Universal Globe GC-1B · Chandler, AZ · Accident · 1 fatal · Field investigation · Final report · May 12, 1991 · N42WW · Destroyed > The pilot-in-command's failure to maintain airspeed in a forced landing resulting in an in flight loss of control, stall, and subsequent in flight colliison with terrain. Factor related to the accident was the pilot's improper procedure which restuled in a… - [NTSB MIA91LA006](https://openairdocs.org/ntsb/MIA91LA006.md): Cessna 150M · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Oct 5, 1990 · N704BB · Substantial damage > The pilot's decision to fly an airplane with known deficiencies. This resulted in a partial loss of engine power, and a ground collision with a fixed object. - [NTSB CHI90LA220](https://openairdocs.org/ntsb/CHI90LA220.md): Schleicher ASK-21 · Plainfield, IL · Accident · No injuries · Limited investigation · Final report · Jul 31, 1990 · N342KS · Substantial damage > The glider pilot's improper aircraft handling at low atitude. - [NTSB LAX90LA199](https://openairdocs.org/ntsb/LAX90LA199.md): Robinson R-22B · Sacramento, CA · Accident · Minor injuries · Limited investigation · Final report · May 29, 1990 · N649MB · Substantial damage > The instructor pilot's failure to follow the aircraft manufacturer's checklist by neglecting to apply full carburetor heat at low power settings. - [NTSB LAX90LA168](https://openairdocs.org/ntsb/LAX90LA168.md): Robinson R22 · Irvine, CA · Accident · No injuries · Limited investigation · Final report · May 9, 1990 · N9070N · Substantial damage > The cfi's failure to maintain rotor RPM during the practice autorotation. - [NTSB SEA89LA150](https://openairdocs.org/ntsb/SEA89LA150.md): Schleicher ASW-20BL · Minden, NV · Accident · No injuries · Limited investigation · Final report · Aug 15, 1989 · N300Y · Substantial damage > Misunderstood emergency procedures, the glider pilot released from the tow which resulted in a hard landing. The pilot's preflight of the glider and radio communications were inadequate before and during the flight. - [NTSB LAX89LA234](https://openairdocs.org/ntsb/LAX89LA234.md): Piper PA-38-112 · Hollister, CA · Accident · No injuries · Limited investigation · Final report · Jul 9, 1989 · N23916 · Substantial damage > Flight instructor's failure to take corrective action in sufficient time to prevent the airplane from striking the ground. - [NTSB NYC89LA060](https://openairdocs.org/ntsb/NYC89LA060.md): Cessna 170A · Speculator, NY · Accident · Minor injuries · Limited investigation · Final report · Jan 1, 1989 · N1432D · Destroyed > Inaccurate inflight planning and decisions by the pilot who inadvertently flew his aircraft from VFR into instrument meteorological conditions while making a descent at night. - [NTSB ANC89LA029](https://openairdocs.org/ntsb/ANC89LA029.md): Cessna 207 · Kivalina, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1988 · N9651M · Substantial damage > The air taxi pilot was on a scheduled cargo flight to a remote village in western Alaska when he reportedly had a partial loss of engine power. He said that he was unable to maintain altitude and made a forced landing on a frozen lake. He is uncertain why the… - [NTSB LAX88FA251](https://openairdocs.org/ntsb/LAX88FA251.md): Piper PA-22-150 · Compton, CA · Accident · 2 fatal · Field investigation · Final report · Jul 13, 1988 · N6926B · Destroyed > Student pilots failure to adequately remove moisture from the fuel system during his preflight inspection which led to a loss of engine power during a critical phase of flight. - [NTSB LAX88LA182](https://openairdocs.org/ntsb/LAX88LA182.md): Slingsby T59D Kestrel 19 · Middletown, CA · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N74T · Substantial damage - [NTSB LAX88DUG01](https://openairdocs.org/ntsb/LAX88DUG01.md): Smith DSA-1 · Upland, CA · Accident · Minor injuries · Final report · Jan 7, 1988 · N2Q · Substantial damage > The pilot reported that he had performed a moderate to severe 'noseover' at 4000 ft AGL. The engine started to run rough and then quit. The pilot stated that he had performed maintenance on the carburetor just prior to this flight. An emergency landing was… - [NTSB MIA88LA036](https://openairdocs.org/ntsb/MIA88LA036.md): Raven S-66A · Naples, FL · Accident · No injuries · Limited investigation · Final report · Nov 5, 1987 · N4094G · Substantial damage > After liftoff with the deflation panel partially open, the flt continued towards the landing location. With a high rate of descent established, the plt realized that the balloon would not clear the powerlines that were ahead of the landing location. He then… - [NTSB ATL88LA018](https://openairdocs.org/ntsb/ATL88LA018.md): Burkhart Grob G-102 · Whitwell, TN · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N792G · Substantial damage > The glider plt made an off-arpt ldg after realizing that he didn't have enough altitude to return to his departure point. During ldg rollout on uneven terrain, one of the wingtips contacted the terrain and the glider ground-looped. - [NTSB NYC87LA174](https://openairdocs.org/ntsb/NYC87LA174.md): Cessna 172 · West Milford, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1987 · N9638L · Substantial damage > The Cessna 172 is reported to have lost power after getting airborne while making a short field takeoff from a 1838 ft long runway. The student pilot told the operator he landed the aircraft on the remaining runway and ran off the departure end of the runway.… - [NTSB NYC87LA136](https://openairdocs.org/ntsb/NYC87LA136.md): Beech BE-18 · York, PA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1987 · N66PA · Substantial damage > While the aircraft was being ferried from massy, Maryland to ankeny, Iowa, a loss of oil pressure on the left engine was experienced. A precautionary landing was made in a cornfield with the landing gear in the up position when the gear failed to extend. Fire… - [NTSB FTW87LA107](https://openairdocs.org/ntsb/FTW87LA107.md): Bell 47D1 · Ardmore, OK · Accident · No injuries · Limited investigation · Final report · Apr 25, 1987 · N3575 · Substantial damage > The pilot reportedly heard an unusual noise in the engine and made a precautionary autorotation to landing. Touchdown was on uneven terrain and in a nose low attitude. This resulted in the tail rotor assembly being chopped off the tail boom by the main rotor… - [NTSB MKC87LA093](https://openairdocs.org/ntsb/MKC87LA093.md): Forney Ercoupe · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Apr 24, 1987 · N7515C · Substantial damage > The annual inspection on this acft was completed the day prior to this accident. During this flt, the wire holding the fuel filter bowl in place came loose and the bowl came off. The eng quit from fuel starvation and the plt made a forced landing in a plowed… - [NTSB ATL87LA116](https://openairdocs.org/ntsb/ATL87LA116.md): Cessna 177 · Brookville, OH · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N2356Y · Substantial damage > The plt reported a partial pwr loss at about 30 ft AGL during the initial takeoff climb. He elected to land straight ahead in a soft, plowed field. The acft nosed over during the landing. Post accident inspection revealed evidence of water in the fuel lines. - [NTSB FTW87FA090](https://openairdocs.org/ntsb/FTW87FA090.md): Piper PA-38-112 · Uvalde, TX · Accident · Minor injuries · Field investigation · Final report · Apr 2, 1987 · N4450E · Substantial damage > On 04-02-87, a Piper PA-38-112, N5540E, owned and operated by southwest Texas junior college, impacted the terrain near Uvalde, TX. The flight was conducted for training purposes. Visual meteorological conditions prevailed at the time of the accident. The… - [NTSB LAX87LA104](https://openairdocs.org/ntsb/LAX87LA104.md): Schweizer SGS 2-33 · Marana, AZ · Accident · Serious injuries · Limited investigation · Final report · Jan 31, 1987 · N5727S · Substantial damage > During a winch tow, the cable prematurely released the glider at approximately 100 to 150 feet. The glider remained in a nose high attitude momentarily then began a shallow descending right turn. At approximately 75 feet the roll, pitch, and descent rate… - [NTSB ATL86FA266](https://openairdocs.org/ntsb/ATL86FA266.md): Piper TG8-J3C-65 · Apex, NC · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1986 · N27047 · Destroyed > The plt was practicing takeoffs and landings in his newly acquired J3 at a private airstrip when the eng sputtered and then quit. The plt lost control of the acft and hit a 't' hanger prior to hitting the ground. The acft caught fire and was destroyed,… - [NTSB FTW86LQG17](https://openairdocs.org/ntsb/FTW86LQG17.md): Mcculloch J-2 · Stanton, TX · Accident · No injuries · Final report · Jul 28, 1986 · N4319G · Destroyed > Pilot attempted take off from pasture. Just after lift off the nose gear caught on a single strand electric fence and brought aircraft to a stop where it rolled over. The plts flt time was not reported or available. - [NTSB ATL86LA189](https://openairdocs.org/ntsb/ATL86LA189.md): Cessna 172 · Kirkland, OH · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N7098A · Substantial damage > Pilot had flown from wisconson to cape cod on Wednesday and was returning to Wisconsin on Sunday. He had departed provincetown on Sunday morning and stopped at hyannis due to weather. He then flew on to saratoga springs, NY with a stop at westover, arriving… - [NTSB MKC86FCD02](https://openairdocs.org/ntsb/MKC86FCD02.md): Piper PA18 · Sloan, IA · Accident · Serious injuries · Final report · Jun 24, 1986 · N243T · Substantial damage > The acft stalled during a low alt steep turn immediately after takeoff. The acft collided with the ground aprx 300 ft east of the rwy. No malfunctions in equipment were found. The plt stated that he was turning steeply to avoid another acft. Statements of two… - [NTSB ANC86FA085](https://openairdocs.org/ntsb/ANC86FA085.md): Piper L-4H · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jun 21, 1986 · N58988 · Substantial damage > The pilot/mechanic stated the engine oil pressure gauge began flickering, so he elected to land and during the descent the engine failed. He landed downwind in 20 knot winds and during the landing roll, across tundra/mud the airplane's wheels struck a large… - [NTSB LAX86LA208](https://openairdocs.org/ntsb/LAX86LA208.md): Schweizer SGS 1-26E · Banning, CA · Accident · No injuries · Limited investigation · Final report · May 3, 1986 · N777SK · Substantial damage > The glider plt lost lift as he flew farther into the mountains with lack of thermal and ridge effect. A landing was attempted which resulted in an overrun into a ravine. - [NTSB LAX86LA203](https://openairdocs.org/ntsb/LAX86LA203.md): Bell 47G-2 · Palmdale, CA · Accident · No injuries · Limited investigation · Final report · May 2, 1986 · N4239J · Substantial damage > The helicopter landed hard in the desert while on a VFR personal flt. The plt indicated that he just departed a mountian area for refueling. He also indicated he was disoriented and the compass was inoperable. He decided to land and check the fuel quantity.… - [NTSB LAX86LA197](https://openairdocs.org/ntsb/LAX86LA197.md): Schempp-Hirth Standard Cirrus · Benson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 28, 1986 · N5RM · Substantial damage > A Schempp-Hirth standard Cirrus glider collided with rocks on landing roll in an open field. The pilot stated he was competing in an air meet. While enroute he lost altitude and was unable to regain it. He selected an open field to land in, but did not see… - [NTSB LAX86LA156](https://openairdocs.org/ntsb/LAX86LA156.md): Cessna 210P · Ontario, CA · Accident · No injuries · Limited investigation · Final report · Mar 30, 1986 · N3896P · Substantial damage > A Cessna 210P collided with the runway surface after a total loss of engine power. Examination of the aircraft revealed that the right fuel tank was empty. The pilot indicated that he had a total of 60 gallons of 100LL on departure and he had selected the… - [NTSB FTW86LA043](https://openairdocs.org/ntsb/FTW86LA043.md): Bell 47G · Beaumont, TX · Accident · No injuries · Limited investigation · Final report · Mar 18, 1986 · N2275B · Substantial damage > The pilot was taking off from an area which was protected from the wind by a large building. After obtaining translational lift and climbing above the building, a right quartering tail wind, with gusts to 20 knots, was encountered. The pilot stated he lost… - [NTSB ATL86LA083](https://openairdocs.org/ntsb/ATL86LA083.md): Piper PA-28-181 · Hickory, NC · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1986 · N9153K · Destroyed > During cruise flt, plt felt eng vib and diverted to nearest aprt. During the descent the plt heard an explosion, saw the eng cowl pop up and oil covered the windscreen. Established in a glide the acft collided with trees then the ground. Exam of the eng… - [NTSB DEN86LA037](https://openairdocs.org/ntsb/DEN86LA037.md): Grumman AA-5A · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Dec 1, 1985 · N991OU · Substantial damage > The plt stated that during takeoff roll the acft used over twice the normal distance to rwy to become airborne. After becoming airborne, the stall warning sounded, and continued to sound until the forced landing when the plt said he couldnot maintain alt. The… - [NTSB LAX86LA026](https://openairdocs.org/ntsb/LAX86LA026.md): Grumman American AA-5A · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Oct 25, 1985 · N26714 · Substantial damage > The plt reported that while sight-seeing in the vicinity of the grand canyon, he became disoriented and lost. The fuel in the left tank was exhausted and the right fuel tank contained minimum fuel. The pilot negotiated a precautionary landing on the hard… - [NTSB CHI85LA298](https://openairdocs.org/ntsb/CHI85LA298.md): Piper PA-28-140 · Pepin, WI · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N38174 · Destroyed > The aircraft traveled three quarters down a 2300 foot sod runway and the pilot attempted to takeoff with 55 KIAS. The aircraft mushed into trees off the end of the runway when the pilot couldn't obtain flying speed. The pilot reported full engine RPM was… - [NTSB CHI85LA294](https://openairdocs.org/ntsb/CHI85LA294.md): Piper PA-28-161 · Schaumburg, IL · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N4349K · Substantial damage > The acft contacted a ditch during a forced landing following a loss of pwr shortly after takeoff. The plt reported that at an alt of aprx 200 ft AGL, during the takeoff climb, a total loss of pwr occurred. A left turn was made in an attemptto avoid buildings… - [NTSB CHI85LA297](https://openairdocs.org/ntsb/CHI85LA297.md): Piper PA-22 · Iola, WI · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N1487A · Substantial damage > Upon takeoff at approximately 100 ft AGL the pilot experienced a partial power loss which necessitated a forced landing in a soft, wet potato field. The pilot had time to switch fuel tanks and magnetos prior to touchdown, but the power loss remained constant.… - [NTSB ATL85LA203](https://openairdocs.org/ntsb/ATL85LA203.md): Stinson 108-2 · Lewisburg, WV · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 1985 · N9818K · Substantial damage > Acft lost power in cruise flight shortly after takeoff. Descent was begun to a field followed by engine quitting. During the turn to final, pilot said, left wing stalled resulting in hard landing on left wheel and left wing. Later, fuel cap vents were found… Next page: https://openairdocs.org/ntsb-phases/600/cases.md?page=9 ## 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 = 600) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/600/cases?page=8 --- 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.