# 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 134 of 281 · 14,038 cases ## Cases, newest first - [NTSB MKC88LA149](https://openairdocs.org/ntsb/MKC88LA149.md): Beech C23 · Crete, NE · Accident · No injuries · Limited investigation · Final report · Aug 5, 1988 · N3566R · Substantial damage > The student pilot said he lost control shortly after liftoff while attempting a soft field takeoff. The acft made an uncontrolled descent to the terrain on a farm field adjacent the airstrip, causing substantial damage to the acft, but no injuries to the… - [NTSB ATL88IA227](https://openairdocs.org/ntsb/ATL88IA227.md): Douglas DC-9-51 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Aug 5, 1988 · N775NC · Minor damage - [NTSB ANC88LA104](https://openairdocs.org/ntsb/ANC88LA104.md): Taylorcraft 15A · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Aug 5, 1988 · N6659N · Substantial damage > The pilot stated that during the takeoff roll on a gravel bar type airstrip he lost control of the airplane. The airplane bounced and landed on a stump. - [NTSB DEN88LA164](https://openairdocs.org/ntsb/DEN88LA164.md): Stinson 108 · Lordsburg, NM · Accident · No injuries · Limited investigation · Final report · Jul 31, 1988 · N97395 · Substantial damage > During takeoff the plane swerved to the lt and the plt aborted the takeoff. On the second takeoff, the airplane again swerved lt and departed the rwy. The plane entered loose sand off the lt side of the rwy and nosed over. The plt stated that he had made 10… - [NTSB LAX88LA275](https://openairdocs.org/ntsb/LAX88LA275.md): Piper PA-28-161 · Placerville, CA · Accident · No injuries · Limited investigation · Final report · Jul 30, 1988 · N8414A · Substantial damage > The plt initiated a touch & go landing in an acft that was loaded near its max certificated gross weight. He landed slightly long & applied power for takeoff. However, he stated that the eng sputtered & the acft contd to decelerate, so he rejected the… - [NTSB CHI88DER06](https://openairdocs.org/ntsb/CHI88DER06.md): Hiller UH-12E · Buffalo Lake, MN · Accident · No injuries · Final report · Jul 30, 1988 · N173HA · Destroyed > When the helicopter lifted off, the left tail rotor cable separated. Directional control was lost and the aircraft collided with the terrain. The pilot reported no injuries, however the helicopter sustained substantial damage. An inspection of the left tail… - [NTSB ATL88LA222](https://openairdocs.org/ntsb/ATL88LA222.md): Beech V35B · Parson, TN · Accident · No injuries · Limited investigation · Final report · Jul 30, 1988 · N38573 · Substantial damage > The pilot reported that shortly after a heavy weather system passed over, he attempted a takeoff from a wet runway. During the takeoff roll he did not allow the airspeed to accelerate to the lift off speed. As he prematurely lifted off he lost directional… - [NTSB CHI88DEV03](https://openairdocs.org/ntsb/CHI88DEV03.md): Hughes 369HS · Ashland, IL · Accident · No injuries · Final report · Jul 28, 1988 · N9033F · Substantial damage > As the helicopter was taking off, there was a loss of rotor RPM which was accompanied by a loss of fuel flow to the eng. The plt aborted the takeoff, but during touchdown, the main rotor blades flexed downward & severed the. Tail boom. An inspn of the eng… - [NTSB CHI88LA176](https://openairdocs.org/ntsb/CHI88LA176.md): Cessna 172 · Carbon, IN · Accident · No injuries · Limited investigation · Final report · Jul 27, 1988 · N6818A · Substantial damage - [NTSB LAX88LA269](https://openairdocs.org/ntsb/LAX88LA269.md): Cessna 172N · Redlands, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1988 · N9850J · Substantial damage > During the takeoff ground run on a solo instructional flight, the student pilot lost control of the airplane. The airplane veered to the left. The pilot applied right rudder, however, the airplane continued to the left, exited the runway and collided with the… - [NTSB FTW88LA140](https://openairdocs.org/ntsb/FTW88LA140.md): Piper PA-28R · Oklahoma City, OK · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 1988 · N2970M · Substantial damage > The air taxi airplane, hauling cargo, was attempting a takeoff and ran off the end of the runway and ended up in a ditch. The pilot said the engine had failed. A check on the wreckage revealed the engine had the wrong type of spark plugs, one magneto was… - [NTSB MIA88LA228](https://openairdocs.org/ntsb/MIA88LA228.md): Aero Commander S2R · Lambert, MS · Accident · No injuries · Limited investigation · Final report · Jul 19, 1988 · N8806Q · Substantial damage > The plt stated there were tstrms in the area when he attempted to takeoff on an aerial application flt. He began his takeoff roll from the duster strip & a strong wind gust from the approaching tstrm blew the tail around. The acft came to rest on its belly in… - [NTSB CHI88LA169](https://openairdocs.org/ntsb/CHI88LA169.md): Beech E18S · Elyria, OH · Accident · No injuries · Limited investigation · Final report · Jul 19, 1988 · N136JR · Substantial damage > During the takeoff roll, the right engine 'surged'. The pilot was unable to maintain directional control of the aircraft, and the aircraft swerved to the right, departed the right side of the runway, struck a ditch and groundlooped, collapsing the left main… - [NTSB ANC88LA092](https://openairdocs.org/ntsb/ANC88LA092.md): Piper PA-12 · Illiamna, AK · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N7958H · Substantial damage > During the takeoff roll on the beach, the aircraft struck a large rock and the pilot lost directional control of the aircraft. - [NTSB NYC88LA182](https://openairdocs.org/ntsb/NYC88LA182.md): Lake LA-4-200 · Candlewood Lake, CT · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1988 · N5033L · Substantial damage > The LA-4-200 made a takeoff under reported conditions of gusty wind and waves of 1 to 2 feet. The maximum demonstrated wave height for the aircraft is 1 foot. The pilot reported he aborted the takeoff due to a person on a jet ski in his way and as he tried to… - [NTSB LAX88DUG05](https://openairdocs.org/ntsb/LAX88DUG05.md): Costa TEENY-TWO · Corona, CA · Accident · No injuries · Final report · Jul 16, 1988 · N5428R · Substantial damage > The homebuilt teeny-two acft was built with a 40 HP, british reliant, hawk ae eng, rather than a volkswagon eng which builders normally used. It had been flown only one time before the acdnt flt. The 1st flt was made in cooler temp conds without incident; the… - [NTSB DEN88LA158](https://openairdocs.org/ntsb/DEN88LA158.md): Piper PA-28-140 · Gallup, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1988 · N1578J · Substantial damage > The private plt & his wife were starting a cross-country personal transportation flt. The acft was loaded to near max gwt, & the fss had reported a density alt of 9,600 ft to the plt. After takeoff on a 6,300 x 100 ft, asphalt rwy, the plt said the acft… - [NTSB FTW88FA131](https://openairdocs.org/ntsb/FTW88FA131.md): Aerospatiale SA330J · Gulf-Of-Mexico · Accident · 1 fatal · Field investigation · Final report · Jul 14, 1988 · N47307 · Destroyed > None submitted - [NTSB NYC88LA201](https://openairdocs.org/ntsb/NYC88LA201.md): Bell 206B · Plymouth, MA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1988 · N543CC · Substantial damage > A loss of power to the engine because the fuel control was not properly adjusted and collision with terrain due to an unsuitable landing area. - [NTSB CHI88DEE05](https://openairdocs.org/ntsb/CHI88DEE05.md): Weatherly 620 · Dekalb, IL · Accident · No injuries · Final report · Jul 11, 1988 · N4605P · Substantial damage > An on ground encounter with weather. - [NTSB LAX88FA249](https://openairdocs.org/ntsb/LAX88FA249.md): Hughes 269C · Van Nuys, CA · Accident · Minor injuries · Field investigation · Final report · Jul 9, 1988 · N750AM · Substantial damage > Flight with undertorqued rotor dampers. - [NTSB ANC88LA086](https://openairdocs.org/ntsb/ANC88LA086.md): Hughes 369D · Kitoi Bay, AK · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N1089D · Substantial damage > The helicopter landed with the left skid against a survey stake which protruded from the ground about 6 inches. Upon liftoff the skid did not clear the metal stake before the helicopter started moving laterally to the left. The left skid remained against the… - [NTSB LAX88LA244](https://openairdocs.org/ntsb/LAX88LA244.md): Cessna TR182 · Niland, CA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1988 · N736UX · Substantial damage > During the takeoff ground run on a dirt road, witnesses stated that the pilot had lifted the nose of the airplane so high that the tail dragged on the ground. The airplane became entangled in weeds near the road, the pilot lost control and the airplane… - [NTSB CHI88LA148](https://openairdocs.org/ntsb/CHI88LA148.md): Cessna 182M · Menomonee Falls, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1988 · N70916 · Substantial damage - [NTSB CHI88DEI01](https://openairdocs.org/ntsb/CHI88DEI01.md): Van Wormer Emeraude SSE-328R · Elyria, OH · Accident · No injuries · Final report · Jul 2, 1988 · N85HT · Substantial damage > According to the plt, the eng seemed to lose power as the acft was climbing thru about 50 ft AGL after takeoff. Subsequently, the acft settled to the ground, crossed a road & collided with a chain link fence. It came to rest about 150 ft from where it 1st… - [NTSB NYC88LA173](https://openairdocs.org/ntsb/NYC88LA173.md): Piper PA-32-300 · Akron, NY · Accident · No injuries · Limited investigation · Final report · Jul 1, 1988 · N1954H · Substantial damage > The pilot's inadequate preflight resulted in a delayed aborted take-off. After an inadvertent retraction of the landing gear the aircraft skidded off the end of the runway into rough terrain. - [NTSB ANC88LA076](https://openairdocs.org/ntsb/ANC88LA076.md): Champion 7GCB · Fairbanks, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1988 · N9892Y · Substantial damage > The 70 hour private pilot was attempting to take off from a private turf airstrip with her non-pilot husband onboard. As she advanced the throttle to the one-half open position, the airplane veered sharply to the left. She said that she pulled the airplane… - [NTSB ANC88LA078](https://openairdocs.org/ntsb/ANC88LA078.md): Cessna 185F · Barter Island, AK · Accident · No injuries · Limited investigation · Final report · Jun 27, 1988 · N53042 · Substantial damage > The 5100 hour commercial pilot had landed at a remote lake on an air taxi flight to pick up three passengers. On the ensuing takeoff attempt, he elected to abort the takeoff due to what he felt was an insufficent amount of lake remaining for a successful… - [NTSB MIA88LA205](https://openairdocs.org/ntsb/MIA88LA205.md): Cessna 182R · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Jun 24, 1988 · N9658X · Substantial damage > The plt rprtd that drg the takeoff roll, he 'rotated aircraft at 65 kts' but it would not become airborne. He then aborted the takeoff, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit a ditch & nosed over. An exam of the flt… - [NTSB LAX88DVG06](https://openairdocs.org/ntsb/LAX88DVG06.md): Cessna 188 · Upper Lake, CA · Accident · No injuries · Final report · Jun 23, 1988 · N4946Q · Destroyed > The acdt occurred drg an aerial app flt. The pilot reported that he had flown 6 or 7 flights earlier in the day. Each flight the load was reduced due to the increasing temperature of the day. Just prior to the accident, the pilot reported that the takeoff… - [NTSB ANC88LA068](https://openairdocs.org/ntsb/ANC88LA068.md): Piper PA-16 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Jun 23, 1988 · N5630H · Substantial damage > The 276 hour private pilot attempted to take off from the Bethel airport, Bethel, AK., on runway 36 in a left crosswind condition given by the tower as 280 degrees at 10 knots. The pilot stated that shortly after the takeoff roll began, the left wing lifted… - [NTSB CHI88IA141](https://openairdocs.org/ntsb/CHI88IA141.md): Swearingen SA226-TC · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 22, 1988 · N329BA · No damage > Failure of the front motor bearing in the sas servo motor assembly, and the resultant 'jamming' of the elevator control cables. The pilot aborted the takeoff as a result of the vibration in the yoke. - [NTSB LAX88LA228](https://openairdocs.org/ntsb/LAX88LA228.md): Consolidated Aeronautics Lake LA-4-200 · Clearlake, CA · Accident · No injuries · Limited investigation · Final report · Jun 20, 1988 · N6026V · Substantial damage > The pilot reported the airplane's right wing struck a swell during takeoff from a lake. The surface winds, however, were out of the southwest at 10 knots. The pilot had not flown within the preceding 24 calendar months. There were no reported airplane… - [NTSB FTW88DRD09](https://openairdocs.org/ntsb/FTW88DRD09.md): Grumman G-164A · Basile, LA · Accident · No injuries · Final report · Jun 17, 1988 · N4243 · Substantial damage > During or after lift-off, the right landing gear axle assembly separated from the landing gear leg when the mounting bolts sheared. During landing, the airplane ground-looped and then flipped to the inverted position. - [NTSB DEN88LA165](https://openairdocs.org/ntsb/DEN88LA165.md): Hall HP-18 · Westcliffe, CO · Accident · No injuries · Limited investigation · Final report · Jun 13, 1988 · N81940 · Substantial damage > The plt said his glider was being towed for takeoff from a dry, dusty, grass strip. He said the tow plane blew up the dust and he was unable to see to maintain alignment with the 75 ft wide strip. There was a drop off on the lt side of the strip and tall… - [NTSB NYC88LA163](https://openairdocs.org/ntsb/NYC88LA163.md): Piper PA-28-140 · Lehighton, PA · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 1988 · N44699 · Destroyed > The student pilot, on his third solo, experienced a loss of directional control during a go-around and settled into low trees and brush on the south side of the runway. The pilot reported the winds as calm. He stated that the left main wheel went off the left… - [NTSB FTW88LA118](https://openairdocs.org/ntsb/FTW88LA118.md): Aeronca 7AC · Roanoke, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1988 · N84889 · Substantial damage > The pilot lost directional control while attempting a takeoff. The airplane ran off the right side of the runway and struck a wind tetrahedron, a fence, and a low concrete wall. The plt did not submit an acc report. - [NTSB FTW88LA116](https://openairdocs.org/ntsb/FTW88LA116.md): Cessna 182L · Angola, LA · Accident · No injuries · Limited investigation · Final report · Jun 8, 1988 · N3153R · Substantial damage > The pilot stated the airplane was on the takeoff roll when the seat slid to the rear. He was unable to control the airplane and it ran off the side of the runway and struck a fence. The seat track holes were worn enough that the locking pins would not stay in… - [NTSB FTW88DRA14](https://openairdocs.org/ntsb/FTW88DRA14.md): Grumman G-164B · College Port, TX · Accident · No injuries · Final report · Jun 6, 1988 · N6615Q · Substantial damage > Acft was substantially damaged when it executed an off-arpt landing following takeoff FR0M a wet sod strip on an ag flt. The plt stated that he was taking off to the north and that during the t/o roll the wind shifted to out of the south. He further stated… - [NTSB NYC88DGT02](https://openairdocs.org/ntsb/NYC88DGT02.md): Bell 47G3B1 · Cove Gap, PA · Accident · Minor injuries · Final report · May 30, 1988 · N48181 · Substantial damage > The helicopter plt was taking off from an area surrounded by trees & buildings for a local spray operation. The wind was calm. Reportedly, during the attempted departure, the plt 'exhausted all power available then made right turn to return to field.' After… - [NTSB ATL88FA186](https://openairdocs.org/ntsb/ATL88FA186.md): Cessna 402B · West Columbia, SC · Accident · 1 fatal · Field investigation · Final report · May 26, 1988 · N8493A · Destroyed > The airplane used about 1/2 of the 8,602 ft rwy for the t/o roll. After t/o it pitched nose-down briefly over the rwy during init climb. The plt radioed that he was having a problem with the elevator which required 'full back pressure' to keep the nose up,… - [NTSB LAX88LA194](https://openairdocs.org/ntsb/LAX88LA194.md): Cessna 150 · Hesperia, CA · Accident · No injuries · Limited investigation · Final report · May 22, 1988 · N5411Q · Substantial damage - [NTSB FTW88NA106](https://openairdocs.org/ntsb/FTW88NA106.md): Mcdonnell Douglas DC-10-30 · Dfw Airport, TX · Accident · Serious injuries · Final report · May 21, 1988 · N136AA · Substantial damage - [NTSB SEA88LA100](https://openairdocs.org/ntsb/SEA88LA100.md): Piper PA-25-260 · Clementsville, ID · Accident · No injuries · Limited investigation · Final report · May 20, 1988 · N4842Y · Substantial damage > The pilot was using a road as his base of operations for an aerial applications operation. During takeoff the aircrafts' wingtip struck a moving automobile's windshield. The plt did not file an accident report. - [NTSB CHI88DET03](https://openairdocs.org/ntsb/CHI88DET03.md): Davis Heath Model V · Valparaiso, IN · Accident · No injuries · Final report · May 20, 1988 · N312HD · Substantial damage > The plt rprtd that when he applied power to takeoff, the acft 'pulled to the right.' He said the acft became airborne, but touched down again & contd to go to the right. Also, he said he tried to correct the situation with left rudder, but the rudder seemed… - [NTSB FTW88FA103](https://openairdocs.org/ntsb/FTW88FA103.md): Globe GC-1B · Powderly, TX · Accident · Serious injuries · Field investigation · Final report · May 18, 1988 · N78143 · Destroyed > The airplane had not been flown for more than seven months. It did not have a current annual inspection. Witnesses said the pilot ran the engine and it ran rough. Then he washed the airplane, then refueled, drained the sumps and ran the engine again at the… - [NTSB ATL88LA176](https://openairdocs.org/ntsb/ATL88LA176.md): Cessna 152 · Florence, SC · Accident · No injuries · Limited investigation · Final report · May 18, 1988 · N757VH · Substantial damage > The accident occurred as the student pilot was attempting to depart rwy 27. He reported that the airplane began to turn to the left as he initiated rotation. He was unable to correct the turn, and he attempted to abort the takeoff. The airplane veered off of… - [NTSB ANC88LA061](https://openairdocs.org/ntsb/ANC88LA061.md): Piper PA-32-301 · Port Heiden, AK · Accident · No injuries · Limited investigation · Final report · May 18, 1988 · N8259V · Substantial damage > The pilot elected to abort the takeoff of a heavily loaded Piper from a soft strip. His decision was tardy and the airplane struck a cinder bank. - [NTSB SEA88LA097](https://openairdocs.org/ntsb/SEA88LA097.md): Hughes 369E · Chemult, OR · Accident · Serious injuries · Limited investigation · Final report · May 17, 1988 · N5258C · Substantial damage > The pilot was attempting to takeoff with a density altitude of 6,300 feet. The aircraft was operated near its maximum gross weight limitation. 150 feet from the initial takeoff the helicopter rotor stirred up dust and debris from a road, causing the pilot to… - [NTSB ANC88DAG04](https://openairdocs.org/ntsb/ANC88DAG04.md): Piper PA-18 · Togiak, AK · Accident · No injuries · Final report · May 17, 1988 · N842JT · Substantial damage > During the takeoff from a beach, the aircraft hit a log causing substantial damage to the landing gear. The pilot stated that during the takeoff run he did not see the log. He then proceeded to an airport where during the landing roll the landing gear… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=135 ## 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=134 --- 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.