# 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 161 of 281 · 14,038 cases ## Cases, newest first - [NTSB CHI82DA077](https://openairdocs.org/ntsb/CHI82DA077.md): Smith Aerostar 600 · Elyria, OH · Accident · No injuries · Final report · Mar 4, 1982 · N9530Q · Substantial damage > During takeoff on an icy runway, the pilot lost directional control after rolling a few hundred feet. He reported that the plane was sliding left and was below VMC, so he retarded the throttles. The plane struck a snowbank beside the runway and was… - [NTSB LAX82DA090](https://openairdocs.org/ntsb/LAX82DA090.md): Schweizer SGS1-260 · Phoenix, AZ · Accident · No injuries · Final report · Mar 1, 1982 · N7740S · Substantial damage > During the takeoff roll the glider's right wing collided with the left tire of a parked aircraft. The pilot stated that the accident could have been prevented by pulling the glider out farther. - [NTSB NYC82DA030](https://openairdocs.org/ntsb/NYC82DA030.md): Piper PA-38-112 · Easton, PA · Accident · No injuries · Final report · Feb 27, 1982 · N9344T · Substantial damage > A takeoff was initiated on runway 17 with the wind from the southwest at 15 knots. During the takeoff roll, control of the aircraft was lost when a gust of wind was encountered. The plane struck a snowbank beside the runway and was substantially damaged. - [NTSB CHI82DA076](https://openairdocs.org/ntsb/CHI82DA076.md): Barnes FIREFLY-7 · Cincinnati, OH · Accident · Serious injuries · Final report · Feb 27, 1982 · N1522W · Substantial damage > Pilot stated that after a normal inflation, before the balloon was hot enough to sustain flight, a gust of wind blew it into a school building. After striking the building, the balloon was dragged through a line of trees. - [NTSB CHI82DA073](https://openairdocs.org/ntsb/CHI82DA073.md): Cessna 150 · Manchester, MI · Accident · No injuries · Final report · Feb 26, 1982 · N9101U · Substantial damage > During takeoff the student pilot lost directional control and struck a snowbank. The student stated at 40-50 knots the left wheel bogged down in snow or encountered a rut and the aircraft twisted sharply left. - [NTSB SEA82FYM10](https://openairdocs.org/ntsb/SEA82FYM10.md): Weatherly 201C · Wasco, OR · Accident · No injuries · Final report · Feb 24, 1982 · N9243W · Substantial damage > The pilot reported that during takeoff, the engine did not maintain full power. While landing in a residential area, the aircraft struck a telephone wire and three trees. An examination of the engine revealed no obvious defects that would cause a loss of… - [NTSB CHI82DA070](https://openairdocs.org/ntsb/CHI82DA070.md): Cessna 152II · Oxford, OH · Accident · No injuries · Final report · Feb 23, 1982 · N68298 · Substantial damage > After a normal landing the pilot retracted the flaps and opened the throttle. As the aircraft gained speed it started drifting off the runway. The pilot attempted to correct with rudder but the aircraft veered off the runway. Power was reduced before the nose… - [NTSB CHI82DA068](https://openairdocs.org/ntsb/CHI82DA068.md): Piper PA-60 · Cleveland, OH · Accident · No injuries · Final report · Feb 23, 1982 · N8035J · Substantial damage > During takeoff roll from a dry runway the pilot reported the aircraft started veering to the left. The pilot attempted to straighten the aircraft with power & brakes to no avail then pushed in throttle in an attempt to fly out. The aircraft departed the… - [NTSB MKC82DA038](https://openairdocs.org/ntsb/MKC82DA038.md): Grumman AA-5A · Monona, IA · Accident · No injuries · Final report · Feb 21, 1982 · N9958U · Substantial damage > The pilot taxied to the south end of the runway to depart with three passengers. He began a soft field takeoff roll on a soft, wet runway with 10 degrees of flaps. The nose wheel was lifted off early. It was held off as the plane accelerated. The pilot… - [NTSB MKC82DA035](https://openairdocs.org/ntsb/MKC82DA035.md): Cessna 152 · Tipton, IA · Accident · No injuries · Final report · Feb 21, 1982 · N64998 · Substantial damage > The student pilot said that he was on the takeoff roll when the aircraft veered left and collided with a snowbank beside the runway. He reported that the runway was clear and dry, and the wind was not a factor. - [NTSB CHI82DA066](https://openairdocs.org/ntsb/CHI82DA066.md): Cessna 152 · Plainfield, IL · Accident · No injuries · Final report · Feb 21, 1982 · N6112Q · Substantial damage > The student pilot stated that during takeoff roll the aircraft began to drift left. Right rudder did not correct the drift and the left wheel contacted snow on the side of the runway causing drag on the aircraft. The aircraft nosed over as it departed the… - [NTSB CHI82DA062](https://openairdocs.org/ntsb/CHI82DA062.md): Beech 56TC · Huntington, IN · Accident · No injuries · Final report · Feb 21, 1982 · N291T · Substantial damage > During a night touch and go landing, the aircraft veered left and struck a snowberm as the pilot was adding power to takeoff. Snowberms were located inside of the runway lights making the usable runway less than 75 ft and possibly restricting the lighting.… - [NTSB FTW82DA065](https://openairdocs.org/ntsb/FTW82DA065.md): Cessna 150M · Lubbock, TX · Accident · No injuries · Final report · Feb 20, 1982 · N9320U · Substantial damage > After electing to abort takeoff the pilot realized he had insufficient room to stop on the remaining runway. He reapplied power to attempt to fly over a road but reported that the engine lost power. The aircraft bounced over a road into a plowed field and… - [NTSB SEA82IA029](https://openairdocs.org/ntsb/SEA82IA029.md): Embraer EMB-11OP1 · Boise, ID · Incident · No injuries · Incident investigation · Final report · Feb 18, 1982 · N101RA · Minor damage > This aircraft, which was departing on a scheduled flight to lewiston, ID., was just accelerated to rotation speed when the crew heard one of the passengers scream. The takeoff WA successfuly aborted and the aircraft was returned to the gate. Investigation… - [NTSB MIA82FA051](https://openairdocs.org/ntsb/MIA82FA051.md): Boeing 727-235 · Miami, FL · Accident · Serious injuries · Field investigation · Final report · Feb 17, 1982 · N4734 · Substantial damage > During takeoff roll a loud bang was heard & the takeoff aborted. The tower advised the flt of extensive fire in the tailarea. The plt cleared the active rwy & the acft was evacuated. 1 pax suffered a fractured ankle & another a sprained ankle. An explosion… - [NTSB MKC82DA032](https://openairdocs.org/ntsb/MKC82DA032.md): Cessna 152 · Chesterfield, MO · Accident · No injuries · Final report · Feb 15, 1982 · N24311 · Substantial damage > The student pilot was making a touch and go landing. He failed to keep the aircraft on the runway during the takeoff. The plane departed the runway to the left and ran up onto a snowbank. The right side of the aircraft tipped down. The propeller and right… - [NTSB CHI82DA052](https://openairdocs.org/ntsb/CHI82DA052.md): Piper PA-28-151 · Monee, IL · Accident · No injuries · Final report · Feb 15, 1982 · N56979 · Substantial damage > The pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen… - [NTSB MIA82DA057](https://openairdocs.org/ntsb/MIA82DA057.md): Piper PA-28-140 · Miami, FL · Accident · No injuries · Final report · Feb 14, 1982 · N98367 · Substantial damage > Takeoff was made on a north/south roadway with the surface winds reported out of the east at 18 knots. The aircraft veered off the road and collided with a tree. - [NTSB MIA82DA046](https://openairdocs.org/ntsb/MIA82DA046.md): Howard 500 · Ft. Lauderdale, FL · Accident · No injuries · Final report · Feb 12, 1982 · N1515V · Substantial damage > The pilot stated that partial power failure of the left engine combined with torque and a crosswind caused a loss of directional control approximately 100 yards into the takeoff roll. - [NTSB LAX82DA066](https://openairdocs.org/ntsb/LAX82DA066.md): Cessna 310R · Carlsbad, CA · Accident · No injuries · Final report · Feb 9, 1982 · N69DH · Substantial damage > During the takeoff roll, the pilot noticed that the passenger door was not closed. He tried unsuccessfully to close the door, then elected to abort the takeoff. The pilot was unable to stop on the remaining runway. The aircraft continued off the end and went… - [NTSB ATL82DA048](https://openairdocs.org/ntsb/ATL82DA048.md): Beech C-23 · Nashville, TN · Accident · No injuries · Final report · Feb 8, 1982 · N60427 · Substantial damage > The accident occurred while the pilot was making a touch and go landing on his second supervised solo flight. After touchdown on his first landing, the pilot inadvertently pulled back on the control yoke while adding power and raising the flaps. The nose… - [NTSB MKC82DA028](https://openairdocs.org/ntsb/MKC82DA028.md): Piper PA-38 · Washington, IA · Accident · No injuries · Final report · Feb 7, 1982 · N2501N · Substantial damage > The student pilot began taking off on runway 17 with a right quartering headwind. There was snow and ice on the runway. During the takeoff roll, the aircraft started toward the left and the pilot added right rudder for directional control. The aircraft… - [NTSB CHI82DA039](https://openairdocs.org/ntsb/CHI82DA039.md): Piper PA-28-181 · East Lansing, MI · Accident · No injuries · Final report · Feb 6, 1982 · N7644F · Substantial damage > The pilot initiated his takeoff on a snow covered, sod runway that had been plowed with a 50 ft wide strip. The plowed area had a snow base and there were four foot snow banks at the edges. Although the runway had been plowed on the previous night and it had… - [NTSB DCA82AA014](https://openairdocs.org/ntsb/DCA82AA014.md): Mcdonnell-Douglas DC-10-10 · Philadelphia, PA · Accident · Serious injuries · Final report · Feb 3, 1982 · N1814U · Minor damage > The aircrews of a united DC-10 (flt 99 heavy) and two U.S. Air DC-9'S (flt 25 and flt 199) taxied for takeoff at about the same time. Due to delays, the no. 2 engine of flt 199 was shut down in accordance with applicable fuel conservation procedures. After… - [NTSB LAX82FVD09](https://openairdocs.org/ntsb/LAX82FVD09.md): Bellanca 7ECA · Sonoma, CA · Accident · No injuries · Final report · Feb 1, 1982 · N5067C · Substantial damage > Control was lost during takeoff when, according to the pilot's statement, a sudden extreme wind gust caused the aircraftto change its heading. The aircraft contacted water at the side of the runway and came to rest nose down. Winds were reportedly gusting to… - [NTSB FTW82DA052](https://openairdocs.org/ntsb/FTW82DA052.md): Cessna 152 · Albuquerque, NM · Accident · No injuries · Final report · Jan 31, 1982 · N89963 · Substantial damage > The instructor elected to use a 2800 to 3200 ft road as a landing strip to practice a landing and takeoff. The instructor had used the road many times before and considered it an ideal practice area. The road had been recently graded, was located away from… - [NTSB DEN82DA027](https://openairdocs.org/ntsb/DEN82DA027.md): Piper PA-22 · Trinidad, CO · Accident · No injuries · Final report · Jan 31, 1982 · N3921P · Substantial damage > The pilot reported that the aircraft started to veer left as the tail came up during the takeoff roll. He corrected with rudder, but did not maintain directional control. As a ground loop developed, he noted there was insufficient airspeed to lift off and… - [NTSB LAX82FVA11](https://openairdocs.org/ntsb/LAX82FVA11.md): Cessna TR182 · Oakdale, CA · Accident · 1 fatal · Final report · Jan 30, 1982 · N5173R · Substantial damage > The aircraft was observed to porpoise several times during the takeoff roll, become airborne with the landing gear immediately retracting, then nose down with the propeller striking, the runway. The pilot continued the takeoff and the aircraft climbed to… - [NTSB SEA82DA021](https://openairdocs.org/ntsb/SEA82DA021.md): Cessna 340A · Sunriver, OR · Accident · No injuries · Final report · Jan 28, 1982 · N4604N · Substantial damage > The instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210… - [NTSB FTW82DA048](https://openairdocs.org/ntsb/FTW82DA048.md): Cessna A185F · S. Of Morgan Ci, LA · Accident · No injuries · Final report · Jan 28, 1982 · N6265E · Substantial damage > The pilot was making a westbound takeoff from a canal with a 15 knot south crosswind when his boot and pant leg became entangled in the aircraft's water rudder lever. This caused the pilot to lose control and the aircraft drifted to the right into a moored… - [NTSB DEN82DA023](https://openairdocs.org/ntsb/DEN82DA023.md): Bellanca 7GCBC · Havre, MT · Accident · No injuries · Final report · Jan 26, 1982 · N88202 · Substantial damage > While taking off to help gather cattle, the right axle failed as the left wing was picked up by gusty winds. The plane spun around 180 degrees and flipped over. The pilot reported that the axles were not heavy enough for consistent rough field use. - [NTSB CHI82DA029](https://openairdocs.org/ntsb/CHI82DA029.md): Mooney M-20 · Shell Lake, WI · Accident · No injuries · Final report · Jan 22, 1982 · N6029Q · Substantial damage > The pilot initiated his takeoff roll on a runway covered with hard packed snow. As the nosewheel was lifted off of the runway, the aircraft started to drift left. The pilot stated that when he applied right rudder and slightly lowered the nose, the plane came… - [NTSB MIA82FA037](https://openairdocs.org/ntsb/MIA82FA037.md): Douglas DC-3 · 15nm W. Opa Loc, FL · Accident · Minor injuries · Field investigation · Final report · Jan 21, 1982 · N211TA · Destroyed > During a touch & go the dual student added power rapidly & the left eng sputtered causing the acft to swerve left. The instructor took control but felt resistance on the controls from the student. He then reduced power on both engs & then reapplied power at… - [NTSB LAX82DA046](https://openairdocs.org/ntsb/LAX82DA046.md): Air Tractor 301 · Dos Palos, CA · Accident · No injuries · Final report · Jan 21, 1982 · N8793S · Substantial damage > During the takeoff roll the pilot decided that he was not going to clear an 8 foot chain-link fence at the end of the runway. He stated that he pulled the dump-gate, chopped the throttle, and put on the brake but the aircraft went into soft dirt and the right… - [NTSB CHI82DA028](https://openairdocs.org/ntsb/CHI82DA028.md): Piper PA-38-112 · Grand Rapids, MI · Accident · No injuries · Final report · Jan 19, 1982 · N26093 · Substantial damage > The pilot-in-command was a student on a check flight for a private license. The check pilot was an FAA inspector. The flight was conducted from an airport with runways that were partially covered with snow and ice. The mishap occurred while the pilot was… - [NTSB ANC82DA019](https://openairdocs.org/ntsb/ANC82DA019.md): Piper PA-32 · Tuntutuliak, AK · Accident · No injuries · Final report · Jan 19, 1982 · N4246T · Substantial damage > During takeoff on a runway covered with 7 to 8 inches of snow,the aircraft pulled to the right. The pilot reduced engine power,but was unable to maintain directional control. The aircraft veered off the side of the runway. Pilot reported snow removal… - [NTSB FTW82DA045](https://openairdocs.org/ntsb/FTW82DA045.md): Cessna 180K · S.E. Of Houma, LA · Accident · No injuries · Final report · Jan 18, 1982 · N2705K · Substantial damage > The pilot elected to takeoff from a canal with a quartering tailwind due to approaching fog. The aircraft drifted left and its wing struck a piling. - [NTSB FTW82DA040](https://openairdocs.org/ntsb/FTW82DA040.md): Beech A23-24 · Hobbs, NM · Accident · No injuries · Final report · Jan 14, 1982 · N2396W · Substantial damage > The pilot attempted to takeoff on a runway with icy patches, lost control and slid off the side into a snowbank. The pilot did not possess any type of pilots certificate due to the fact that he could not pass a medical examination. - [NTSB DEN82FTE16](https://openairdocs.org/ntsb/DEN82FTE16.md): Cessna 180 · Saquache, CO · Accident · No injuries · Final report · Jan 11, 1982 · N2332C · Substantial damage > During a round-robin VFR flight the pilot landed at cochetopa strip and shut down for 1 hour. The pilot stated that at the time of takeoff the wind velocity had increased to 20-25 knots with almost a direct crosswind. During takeoff the aircraft drifted left… - [NTSB LAX82FUG05](https://openairdocs.org/ntsb/LAX82FUG05.md): Quickie 1 · Upland, CA · Accident · No injuries · Final report · Jan 10, 1982 · N234Q · Substantial damage > The pilot took off on an upward sloping runway towards rising terrain. The pilot stated that he was unable to maintain enough speed to clear obstacles with the 22 horsepower engine. He elected to land on a residential street. While maneuvering around a street… - [NTSB CHI82DA023](https://openairdocs.org/ntsb/CHI82DA023.md): Cessna 152 · Peoria, IL · Accident · No injuries · Final report · Jan 8, 1982 · N6265P · Substantial damage > Reportedly, the student tookoff without his instructor's appproval. He initiated a takeoff roll on runway 35 with the wind from 230 degrees at 11 knots. He stated that the wind shifted and caught him from behind as he was about to lift off. Directional… - [NTSB DEN82DTI09](https://openairdocs.org/ntsb/DEN82DTI09.md): Air Tractor AT-301 · Greenough, MT · Accident · No injuries · Final report · Jan 3, 1982 · N23069 · Substantial damage > During takeoff the aircraft struck a snow berm. The aircraft received substantial damage to both wings and prop. The aircraft had been landed on a county road about a week earlier due to deteriorating weather. - [NTSB CHI82FEC08](https://openairdocs.org/ntsb/CHI82FEC08.md): Cessna 152 · Ypsilanti, MI · Accident · No injuries · Final report · Jan 2, 1982 · N68812 · Substantial damage > During takeoff from a hard packed snow and icy runway the aircraft veered left into a snowbank off the side of the runway. The student pilot stated that prior to the takeoff roll he had full deflection of the left aileron and was anticipating with right… - [NTSB SEA82DA022](https://openairdocs.org/ntsb/SEA82DA022.md): Cessna 140 · Pullman, WA · Accident · No injuries · Final report · Jan 1, 1982 · N2482N · Substantial damage > The pilot started to takeoff on a snow covered runway in calm wind conditions. He reported that about 3 inches of snow had fallen since the runway had been cleared. In his judgement, the aircraft did not accelerate fast enough to assure a safe takeoff, so he… - [NTSB NYC82FGT07](https://openairdocs.org/ntsb/NYC82FGT07.md): Aeronca 7AC · Wellsboro, PA · Accident · No injuries · Closed · Dec 31, 1981 · N83073 · Substantial damage - [NTSB NYC82DA013](https://openairdocs.org/ntsb/NYC82DA013.md): Aeronca 7AC · Wellsboro, PA · Accident · No injuries · Closed · Dec 31, 1981 · N83073 · Substantial damage - [NTSB MKC82DA015](https://openairdocs.org/ntsb/MKC82DA015.md): Swearingen SA227 · Lincoln, NE · Accident · No injuries · Closed · Dec 24, 1981 · N807M · Substantial damage - [NTSB MKC82FCG14](https://openairdocs.org/ntsb/MKC82FCG14.md): Cessna 421C · Olathe, KS · Accident · No injuries · Closed · Dec 22, 1981 · N990MB · Substantial damage - [NTSB DEN81DTK03](https://openairdocs.org/ntsb/DEN81DTK03.md): Cessna 172 · Timber Lake, SD · Accident · No injuries · Closed · Dec 21, 1981 · N8831Z · Substantial damage - [NTSB MKC82DCG13](https://openairdocs.org/ntsb/MKC82DCG13.md): Piper PA-28 · St.Joseph, MO · Accident · Minor injuries · Closed · Dec 19, 1981 · N33574 · Substantial damage Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=162 ## 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=161 --- 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.