# NTSB investigations: Takeoff 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 132 of 281 · 14,041 cases ## Cases, newest first - [NTSB DEN89LA096](https://openairdocs.org/ntsb/DEN89LA096.md): Cessna 180 · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Mar 28, 1989 · N4756B · Substantial damage > The pilot's inadequate compensation for wind conditions, failing to maintain directional control, and inadvertent ground swerve. Gusty crosswinds contributed to the accident. - [NTSB ANC89LA064](https://openairdocs.org/ntsb/ANC89LA064.md): Piper PA-11 · Beluga Mountain, AK · Accident · No injuries · Limited investigation · Final report · Mar 28, 1989 · N4620M · Substantial damage > Pilot's selection of unsuitable terrain for an off-airport landing and takeoff. The uneven terrain (with a snow berm) was a related factor. - [NTSB DEN89FA093](https://openairdocs.org/ntsb/DEN89FA093.md): Cessna 177RG · Albuquerque, NM · Accident · 2 fatal · Field investigation · Final report · Mar 25, 1989 · N2972X · Destroyed > The pilot's improper use of flaps during takeoff which resulted in inadequate airspeed, a stall, and loss of control. - [NTSB ANC89LA054](https://openairdocs.org/ntsb/ANC89LA054.md): Cessna 180-A · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Mar 25, 1989 · N9685B · Substantial damage > The pilot's failure to maintain directional control of the airplane during the takeoff run. A contributing factor to the accident is the pilot's selection of an unsuitable landing/takeoff site. - [NTSB SEA89LA058](https://openairdocs.org/ntsb/SEA89LA058.md): North American T-28A · Jerome, ID · Accident · No injuries · Limited investigation · Final report · Mar 18, 1989 · N128AF · Substantial damage > The failure of another person to report a hard landing which resulted in the airplane not being inspected by authorized personnel. - [NTSB LAX89LA125](https://openairdocs.org/ntsb/LAX89LA125.md): Bell 206B · Corona, CA · Accident · No injuries · Limited investigation · Final report · Mar 16, 1989 · N131AT · Substantial damage > Improper operation of the cyclic by the student pilot, failure of the student to relinquish control and inadequate supervision by the flight instructor. - [NTSB DEN89LA087](https://openairdocs.org/ntsb/DEN89LA087.md): Cessna TU206G · Broomfield, CO · Accident · Minor injuries · Limited investigation · Final report · Mar 13, 1989 · N735VE · Substantial damage > Pilot's failure to properly control the aircraft while conducting a crosswind takeoff. - [NTSB MKC89LA077](https://openairdocs.org/ntsb/MKC89LA077.md): Jennings Pietenpol Aircamper · Lincoln, NE · Accident · No injuries · Limited investigation · Final report · Mar 11, 1989 · N81GJ · Substantial damage > Failure of the pilot in command to adequately preflight the aircraft resulting in a front cockpit seat cushion interfering with the rudder pedals and brakes. - [NTSB LAX89LA118](https://openairdocs.org/ntsb/LAX89LA118.md): Cessna 310 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1989 · N4899B · Substantial damage > The failure of the landing gear strut on the right main gear due to improper maintenance. - [NTSB DEN89LA086](https://openairdocs.org/ntsb/DEN89LA086.md): Cessna 182 · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Mar 9, 1989 · N3613U · Substantial damage > Inadequate compensation for wind conditions by the pilot which resulted in loss of directional control and inadvertent ground swerve. The quartering crosswind, gusts, and lack of pilot experience were contributing factors. - [NTSB NYC89LA094](https://openairdocs.org/ntsb/NYC89LA094.md): Cessna 152 · Lincoln Park, NJ · Accident · No injuries · Limited investigation · Final report · Mar 8, 1989 · N94252 · Substantial damage > Improper decision and planning by the check pilot (f/e) which resulted in loss of proper alignment and collision with a snowbank at the edge of the runway. Contributing factors were: inadequate preflight by the f/e, f/e's unsecured shoulder harness, premature… - [NTSB CHI89IA054](https://openairdocs.org/ntsb/CHI89IA054.md): Short Brothers SD360 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Mar 8, 1989 · N366MQ · No damage > The PIC followed a clearance intended for another airplane. - [NTSB NYC89FA095](https://openairdocs.org/ntsb/NYC89FA095.md): Piper PA-28 · Douglas Twsp, PA · Accident · 1 fatal · Field investigation · Final report · Mar 5, 1989 · N5348S · Destroyed > Poor judgement of the student pilot by flying while under the influence of alcohol, and his VFR flight in instrument meteorological conditions (IMC) without the required qualification or training. Factors factors related to the accident were: failure of the… - [NTSB LAX89LA115](https://openairdocs.org/ntsb/LAX89LA115.md): Robinson R22 · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Feb 24, 1989 · N9076K · Substantial damage > Failure of airport personnel to assure the taiway was free of objects after the taxiway was painted. - [NTSB ANC89LA045](https://openairdocs.org/ntsb/ANC89LA045.md): Cessna 152 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Feb 19, 1989 · N5312Q · Substantial damage > The pilot's failure to maintain directional control during a touch and go landing. A contributing factor is the pilot's lack of total flight experience. - [NTSB MIA89LA086](https://openairdocs.org/ntsb/MIA89LA086.md): Aero Commander 500U · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Feb 16, 1989 · N1010U · Substantial damage > Control malfunction of undetermined cause that made further flight inadvisable. - [NTSB LAX89LA117](https://openairdocs.org/ntsb/LAX89LA117.md): Cessna 182C · Adalanto, CA · Accident · No injuries · Limited investigation · Final report · Feb 15, 1989 · N8923T · Substantial damage > The pilot was inattentive, did not maintain proper alignment with the runway and did not maintain an adequate visual lookout during takeoff. - [NTSB DEN89FA076](https://openairdocs.org/ntsb/DEN89FA076.md): Swearingen SA226TC · Saint George, UT · Accident · No injuries · Field investigation · Final report · Feb 11, 1989 · N1010Z · Substantial damage > Malfunction of the nosewheel steering system due to improper installation of the nosewheel steering poppet valve & inadequate maintenance instructions. - [NTSB ANC89FA043](https://openairdocs.org/ntsb/ANC89FA043.md): de Havilland DHC-3 · Fairbanks, AK · Accident · No injuries · Field investigation · Final report · Feb 10, 1989 · N5056Q · Substantial damage > Failure of the pilot to remove frost from the aircraft. Contributing factors were: improper weight and balance and snow covered terrain. - [NTSB DEN89LA073](https://openairdocs.org/ntsb/DEN89LA073.md): Cessna 152 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Feb 6, 1989 · N89038 · Substantial damage > The failure of the pilot to correct a ground loop swerve. A lack of total flight experience is considered to be a contributing factor. - [NTSB SEA89LA047](https://openairdocs.org/ntsb/SEA89LA047.md): Cessna 180 · Wrangell, AK · Accident · No injuries · Limited investigation · Final report · Feb 5, 1989 · N9024C · Substantial damage > The plt's failure to properly compensate for the wind during takeoff on unsuitable terrain. Contributing to the accident were the terrain conditions and gusting winds. - [NTSB ATL89LA084](https://openairdocs.org/ntsb/ATL89LA084.md): Cessna 172 · Galion, OH · Accident · No injuries · Limited investigation · Final report · Feb 1, 1989 · N8121B · Substantial damage > The pilot's failure to retract the flaps prior to adding power for takeoff resulting in a premature lift-off, and the pilot's failure to maintian control of the airplane after lift-off which resulted in a stall/mush. - [NTSB SEA89LA039](https://openairdocs.org/ntsb/SEA89LA039.md): Cessna 152 · Puyallup, WA · Accident · No injuries · Limited investigation · Final report · Jan 26, 1989 · N49104 · Substantial damage > Failure on the part of the student pilot to maintain directional control of the aircraft. Contributing to the accident were poor approach and flare technique and lack of recent experience. - [NTSB SEA89IA042](https://openairdocs.org/ntsb/SEA89IA042.md): Fairchild SA-227-AC · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jan 23, 1989 · N386PH · Minor damage > Inoperative nosewheel steering due to improper maintenance. Contributing to the incident was the lack of adequate maintenance information available in the aircraft manuals. - [NTSB LAX89LA094](https://openairdocs.org/ntsb/LAX89LA094.md): Piper PA-28-180 · Show Low, AZ · Accident · No injuries · Limited investigation · Final report · Jan 23, 1989 · N8162W · Substantial damage > Delayed retraction of flaps and the inadvertent application of left rudder due to diversion of attention resulting in the airplane's departure from the runway. A contributing factor was the inexperience of the student pilot. - [NTSB LAX89LA090](https://openairdocs.org/ntsb/LAX89LA090.md): Boeing A75 · Huntington Bch, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1989 · N58072 · Substantial damage > The pilot's inadequate evaluation of the weather, and the sudden wind shift that was encountered during takeoff. The trees & wall were related factors. - [NTSB LAX89LA088](https://openairdocs.org/ntsb/LAX89LA088.md): Piper PA-32R-301T · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1989 · N6913D · Substantial damage > Poor preflight planning and preparation by selecting the wrong runway despite NOTAM and ATIS information indicating the runway was closed. - [NTSB ATL89MA072](https://openairdocs.org/ntsb/ATL89MA072.md): Hawker Siddeley HS.748 Series 2A · Tipp City, OH · Accident · 2 fatal · Major investigation · Final report · Jan 12, 1989 · CGDOV · Destroyed > Improper IFR procedure by the first officer (copilot) during takeoff, his lack of instrument scan (improper use of flight/navigation instruments), his failure to maintain a positive rate of climb or to identify the resultant descent, and the captain's… - [NTSB DEN89LA058](https://openairdocs.org/ntsb/DEN89LA058.md): Piper PA-31T · Craig, CO · Accident · No injuries · Limited investigation · Final report · Jan 6, 1989 · N82290 · Substantial damage > Unsuitable terrain (runway condition) selected by the pilot. Factors related to the accident were: the adverse weather conditions, inadequate removal of snow from the runway by airport personnel, uneven snow covered runway, lack of visual perception by the… - [NTSB MKC89IA048](https://openairdocs.org/ntsb/MKC89IA048.md): Gulfstream Commander 690A · St. Paul, MN · Incident · No injuries · Incident investigation · Final report · Dec 29, 1988 · N690MF · No damage > The PIC had prefltd his commander turboprop and prepared for takeoff fm the St. Paul arpt. During the takeoff roll just as the acft was rotated to takeoff attitude, the rt eng failed. The PIC eased the acft back to the rwy, reduced pwr and came to a stop on… - [NTSB ATL89IA063](https://openairdocs.org/ntsb/ATL89IA063.md): Lake LA-4-200 · Silver Grove, KY · Incident · No injuries · Incident investigation · Final report · Dec 29, 1988 · N85020 · Minor damage > During a takeoff run from the Ohio river, the right sponson collided with a submerged log. The a/c sustained minor damage. - [NTSB MKC89LA045](https://openairdocs.org/ntsb/MKC89LA045.md): Cessna 175 · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · Dec 22, 1988 · N7159M · Substantial damage > The plt said that shortly after takeoff, the engine began to misfire and lose power. He elected to abort the takeoff, but was unable to stop on the remaining portion of the runway. He ran off the end, into a farm field, where the acft nosed down and was… - [NTSB DEN89LA046](https://openairdocs.org/ntsb/DEN89LA046.md): Piper PA-11 · Hammond, MT · Accident · No injuries · Limited investigation · Final report · Dec 17, 1988 · N78654 · Substantial damage > The plt, who was a veterinarian, landed his acft in rough, cultivated farm fld at a ranch in order to conduct business. Upon completion of his business, the plt selected a smoother area in the same field for takeoff. The area was smoother but was shorter and… - [NTSB CHI89LA032](https://openairdocs.org/ntsb/CHI89LA032.md): Cessna 152II · Lake In The Hls, IL · Accident · No injuries · Limited investigation · Final report · Dec 16, 1988 · N714ZE · Substantial damage > The pilot in command failed to maintain directional control of the aircraft while correcting for a crosswind. Contributing to the cause is the pilot's lack of experience. - [NTSB ANC89LA023](https://openairdocs.org/ntsb/ANC89LA023.md): Cessna 207 · Napaskiak, AK · Accident · No injuries · Limited investigation · Final report · Dec 12, 1988 · N70076 · Substantial damage > During an aborted takeoff, the airplane collided with a bulldozer on the departure end of the snow covered runway. The pilot reported that he elected to abort the takeoff due to a low fuel flow indication. The director of operations stated that during an… - [NTSB MKC89LA033](https://openairdocs.org/ntsb/MKC89LA033.md): Cessna 152 · Hibbing, MN · Accident · No injuries · Limited investigation · Final report · Dec 4, 1988 · N6132H · Substantial damage > While practicing takeoffs and landings on a patchy snow and ice covered runway, the student pilot lost directional control on takeoff and veered off the runway into a snow bank. The acft nosed down and damaged the prop and right wing. - [NTSB ATL89LA050](https://openairdocs.org/ntsb/ATL89LA050.md): Cessna 172 · Lawrenceville, GA · Accident · No injuries · Limited investigation · Final report · Dec 4, 1988 · N5518D · Substantial damage > After 3 full stop landings, the pilot reported that the airplane would not accelerate to liftoff airspeed on 4th takeoff after rolling about 2000 feet. The pilot elected to abort the takeoff. The airplane rolled off the departure end of runway 07 and nosed… - [NTSB MKC89LA032](https://openairdocs.org/ntsb/MKC89LA032.md): Cessna 172 · Little Falls, MN · Accident · No injuries · Limited investigation · Final report · Dec 2, 1988 · N65642 · Substantial damage > While attempting a touch and go ldg during a student solo cross country flt, directional control was lost during the takeoff phase on the snow packed runway. The student pilot said he had never landed and taken off under those runway conditions. The acft… - [NTSB DEN89LA037](https://openairdocs.org/ntsb/DEN89LA037.md): Piper PA-18-150 · Casper, WY · Accident · No injuries · Limited investigation · Final report · Nov 27, 1988 · N743L · Substantial damage > The plt attempted a takeoff to the west on a county gravel road. The pilot said he had routinely used the gravel road for about 10 years because of its convenience to his hangar/tool shed. He reported the winds were from 210 deg at 15 KTS. During the ground… - [NTSB FTW89LA026](https://openairdocs.org/ntsb/FTW89LA026.md): Bell 206B · Chalmette, LA · Accident · No injuries · Limited investigation · Final report · Nov 23, 1988 · N83109 · Substantial damage > The rated pilot's inadequate takeoff technique the the instructor pilot's momentary lack of judgement in having the pilot attempt a hydraulics off takeoff. - [NTSB MKC89IA024](https://openairdocs.org/ntsb/MKC89IA024.md): Mcdonnell Douglas DC9-31 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Nov 16, 1988 · N965VJ · Minor damage > The failure of the left main landing gear tire carcass and the ingestion of the tire debris into the left engine which hindered normal operation. - [NTSB NYC89IA028](https://openairdocs.org/ntsb/NYC89IA028.md): Boeing 727-227 · Boston, MA · Incident · No injuries · Incident investigation · Final report · Nov 14, 1988 · N555PE · 2 aircraft · Minor damage > Failure of the local controller to detect the red t on the departure strip on PRE659 when he cleared him into position and hold. Factors related to the accident were: darkness and the lack of positive coordination between the ground controller and local… - [NTSB NYC89FA029](https://openairdocs.org/ntsb/NYC89FA029.md): Ryan Navion A · Franklin, PA · Accident · 3 fatal · Field investigation · Final report · Nov 14, 1988 · N5164K · Destroyed > Due to improper grade of fuel in the airplane and bent and binding exhaust valves, the airplane engine had a partial loss of power during the takeoff ground run. The pilot did not abort the takeoff and the airplane stalled and collided with trees when the… - [NTSB LAX89LA045](https://openairdocs.org/ntsb/LAX89LA045.md): Cessna 180H · Eureka, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1988 · N7904V · Substantial damage > During the takeoff run on calm water, the floatplane pilot noticed three pylons ahead. He felt there was insufficient space to abort, so he continued the takeoff. Just before reaching the pylons, he rotated the airplane in an effort to lift-off & clear the… - [NTSB ATL89LA031](https://openairdocs.org/ntsb/ATL89LA031.md): Cessna 310J · Carrollton, OH · Accident · No injuries · Limited investigation · Final report · Nov 12, 1988 · N3066L · Substantial damage > The pilot had landed at Carrollton, OH for refuelling and breakfast. After refuelling he taxied out for departure from runway 25 for a flight back to his home base. The runup was reportedly normal. After application of maximum power, he started his takeoff… - [NTSB CHI89IA023](https://openairdocs.org/ntsb/CHI89IA023.md): British Aerospace JS-3101 · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Nov 10, 1988 · N333PX · Minor damage > Loss of lubrication to the outer wheel bearing, and the subsequent disintegration of the bearing. Contributing to the incident was the failure by maintenance personnel to properly inspect and grease the bearing. - [NTSB LAX89LA036](https://openairdocs.org/ntsb/LAX89LA036.md): Cessna T210L · Camarillo, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 5, 1988 · N777HS · 2 aircraft · Destroyed > Pilot of N8219J used poor judgement when she elected to execute the high speed taxi operation. - [NTSB DEN89FA024](https://openairdocs.org/ntsb/DEN89FA024.md): Canadair CL-600-1A11 · Aspen, CO · Accident · Minor injuries · Field investigation · Final report · Oct 29, 1988 · N909MG · Substantial damage > The pic's failure to follow approved procedures and directives; the pic's failure to attain/maintain direction control of the airplane, the pic's failure to abort the takeoff in a timely manner; and the pic's failure to follow proper aborted takeoff… - [NTSB ATL89LA018](https://openairdocs.org/ntsb/ATL89LA018.md): Cessna 152 · Reidsville, NC · Accident · No injuries · Limited investigation · Final report · Oct 26, 1988 · N4713B · Substantial damage > The student plt reported that the airplane nose '...was wanting to come up sooner than it should' during the takeoff roll on his first solo flt; he checked the elevator trim and found it properly set. He elected to abort the takeoff. He reduced the pwr and… - [NTSB CHI89LA017](https://openairdocs.org/ntsb/CHI89LA017.md): Aeronca 15AC · Mora, MN · Accident · No injuries · Limited investigation · Final report · Oct 24, 1988 · N1162H · Destroyed Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=133 ## 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 = 300) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=132 --- 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.