# NTSB investigations: Standing 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 19 of 42 · 2,085 cases ## Cases, newest first - [NTSB FTW89FA134](https://openairdocs.org/ntsb/FTW89FA134.md): Cessna 150L · Fort Worth, TX · Accident · Serious injuries · Field investigation · Final report · Jul 11, 1989 · N17250 · Substantial damage > A loss of control of the airplane due to the pilot's inability to raise the flaps which resulted in a stall. The flap failure and subsequent full flap takeoff were the result of the operator's improper maintenance of the airplane and the operator's use of a… - [NTSB ANC89LA109](https://openairdocs.org/ntsb/ANC89LA109.md): Piper PA-28 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1989 · N5302W · Substantial damage > Failure of the pilot to obtain proper assistance in starting the engine and/or his inadequate supervision. The passenger's lack of familiarity with the aircraft resulted in her improper use of the throttle which contributed to the accident. - [NTSB ATL89LA172](https://openairdocs.org/ntsb/ATL89LA172.md): Boeing 737-291 · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1989 · N7375F · No damage > Failure of the ground employee to follow normal safety procedures. His lack of familiarity with the operation was a related factor. - [NTSB SEA89LA109](https://openairdocs.org/ntsb/SEA89LA109.md): Cessna 177B · Minden, NV · Accident · No injuries · Limited investigation · Final report · Jun 11, 1989 · N34211 · Destroyed > The inadequate maintenance which caused a crack in the fuel pressure line leading into the carburetor. - [NTSB SEA89LA102](https://openairdocs.org/ntsb/SEA89LA102.md): Beech 19A · Cashmere, WA · Accident · No injuries · Limited investigation · Final report · Jun 3, 1989 · N6061N · Substantial damage > The pilot used poor starting procedures. The airplane was inadequately secured resulting in a collision with an object when the airplane broke free of the tiedown ropes. - [NTSB MIA89LA163](https://openairdocs.org/ntsb/MIA89LA163.md): Cessna 150L · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · May 30, 1989 · N17018 · Substantial damage > The pilot's failure to have someone operate the airplane's brakes and engine controls during hand propping the engine. - [NTSB MIA89LA162](https://openairdocs.org/ntsb/MIA89LA162.md): Cessna A152 · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · May 29, 1989 · N4896A · Substantial damage > Improper planning/decision by the pilot by not properly securing the aircraft or obtaining proper assistance. - [NTSB CHI89LA075](https://openairdocs.org/ntsb/CHI89LA075.md): Bellanca 17-30A · Watertown, WI · Accident · No injuries · Limited investigation · Final report · Apr 24, 1989 · N39868 · Substantial damage > The pilot's improper use of brakes and throttle. A contributing factor was the parked aircraft which was nearby. - [NTSB FTW89LA086](https://openairdocs.org/ntsb/FTW89LA086.md): Beech V35B · Lampasas, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 1989 · N17513 · Substantial damage > The pilot's failure to follow proper procedures and directives for the attempted operation. A factor was the undetermined status of the magnetos. - [NTSB NYC89LA112](https://openairdocs.org/ntsb/NYC89LA112.md): Champion 8KCAB · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Apr 3, 1989 · N2520Z · Substantial damage > The loss of control and collision with a parked aircraft due to the inadvertent application of the throttle that took place as the pilot was fastening the over the shoulder safety harness while warming the engine in preparation for departure. - [NTSB LAX89LA144](https://openairdocs.org/ntsb/LAX89LA144.md): Boeing 767-201 · Los Angeles, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 3, 1989 · N645US · No damage > The first officer did not properly evacuate the airplane. - [NTSB FTW89LA077](https://openairdocs.org/ntsb/FTW89LA077.md): Gulfstream 680FLP · Lohn, TX · Accident · No injuries · Limited investigation · Final report · Apr 1, 1989 · N721F · Destroyed > Arson undertaken to conceal illegal activity. - [NTSB LAX89LA127](https://openairdocs.org/ntsb/LAX89LA127.md): Hughes 269A · Malibu, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 1989 · N8784F · No damage > The failure of the passenger to follow briefed procedures and the failure of ground personnel to provide adequate assistance. - [NTSB DCA89MA035](https://openairdocs.org/ntsb/DCA89MA035.md): McDonnell Douglas DC-9-33F · Saginaw, TX · Accident · 2 fatal · Class 1 · Major · Final report · Mar 18, 1989 · N931F · Destroyed > The loss of control of the airplane for undetermined reasons following the inflight opening of the improperly latched cargo door. Contributing to the accident were: inadequate procedures used by evergreen airlines and approved by the FAA for preflight… - [NTSB DCA89MA034](https://openairdocs.org/ntsb/DCA89MA034.md): Boeing 737-300 · Oakland, CA · Accident · No injuries · Major investigation · Final report · Mar 17, 1989 · N12318 · Substantial damage > Ignition of puddled fuel from a blocked combustor drain line, and a slow start during which fuel was misted and blown out the tail pipe. An existing tailwind at the gate allowed the fuel to wet the tail surfaces and be ignited during the APU start. The… - [NTSB MKC89LA075](https://openairdocs.org/ntsb/MKC89LA075.md): Grumman G-164A · Wynne, AR · Accident · No injuries · Limited investigation · Final report · Mar 10, 1989 · N6602Q · Destroyed > An engine fire during engine start for undetermined reasons. - [NTSB BFO89LA018](https://openairdocs.org/ntsb/BFO89LA018.md): Cessna 172I · Fort Washington, MD · Accident · Serious injuries · Limited investigation · Final report · Feb 26, 1989 · N8359L · No damage > The passenger failed to maintain adequate clearance from the propeller as she attempted to board the aircraft. Both the pilot failure to supervise the boarding of the passenger and the night light conditions are contributing factors to the accident. - [NTSB NYC89LA081](https://openairdocs.org/ntsb/NYC89LA081.md): Cessna 402B · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Feb 4, 1989 · N49PB · Substantial damage > Inadequate preflight planning and preparation by the pilot which resulted in improper weight and balance (aft CG). The aft CG also contributed to the uncommanded altitude deviation after takeoff. - [NTSB MIA89LA073](https://openairdocs.org/ntsb/MIA89LA073.md): Beech A36 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 27, 1989 · N2860W · Substantial damage > Failure of the driver of the automobile to maintain an adequate visual lookout and to yield the right of way to the aircraft. - [NTSB SEA89LA038](https://openairdocs.org/ntsb/SEA89LA038.md): Cessna 180A · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Jan 19, 1989 · N9104R · Substantial damage > The pilot attempted to hand-prop the engine without properly securing it. - [NTSB ANC89IA032](https://openairdocs.org/ntsb/ANC89IA032.md): Boeing 727-222 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Jan 9, 1989 · N7298U · 2 aircraft · Minor damage > Improper placement of the 727 on the ramp and the failure of the 747 crew to maintain separation. - [NTSB DEN89LA059](https://openairdocs.org/ntsb/DEN89LA059.md): Bell 206B III · Park City, UT · Accident · No injuries · Limited investigation · Final report · Jan 8, 1989 · N16733 · Substantial damage > The selection of an unsuitable landing site by the pilot, resulting in tail rotor contact with the terrain and shearing of the tail rotor driveshaft. - [NTSB ATL89IA057](https://openairdocs.org/ntsb/ATL89IA057.md): Lockheed L-1011 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Dec 19, 1988 · UNK · No damage > 1St officer was observed to be sick & was replaced on the flt prior to departing the originating city. Subsequently, he was confronted by an intervention group regarding his condition and requested medical assistance under the company employee assistance… - [NTSB MIA89LA051](https://openairdocs.org/ntsb/MIA89LA051.md): Cessna 172G · Venice, FL · Accident · No injuries · Limited investigation · Final report · Dec 16, 1988 · N4419L · Substantial damage > The pilot experienced difficulty when he attempted to start the eng with a less than fully-charged battery. The former navy plt exited the acft, leaving his nonplt pax aboard, and the mag switch 'on'. He attempted to slowly pull the prop thru compression… - [NTSB BFO89LA010](https://openairdocs.org/ntsb/BFO89LA010.md): Piper J3C-65 · Dublin, WV · Accident · No injuries · Limited investigation · Final report · Nov 15, 1988 · N88054 · Substantial damage > The pilot was attempting to hand prop his acft without any assistance. He stated he chocked both the front and back of the right main gear. After several unsuccessful attempts the engine finally started. The acft ran at what the pilot described as sounding… - [NTSB DEN89LA032](https://openairdocs.org/ntsb/DEN89LA032.md): Taylorcraft BC12D · Carrizozo, NM · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 1988 · N43603 · Substantial damage > The private plt said his Taylorcraft was secured to the ramp by 3 chains. He tried to hand start the engine, with no one at the controls, and the throttle full open. The engine started, the acft broke the right wing tie down ring, and straightened an 's' hook… - [NTSB ATL89LA032](https://openairdocs.org/ntsb/ATL89LA032.md): Beech 35-A33 · Marietta, GA · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1988 · N431T · Substantial damage > During preflt 'run-up' at the end of the active rwy, the right brake failed and the airplane pivoted left while the engine was at a high power setting. The plt rpted that things happened so fast that he may have added power while attempting to reduce power.… - [NTSB MIA89IA031](https://openairdocs.org/ntsb/MIA89IA031.md): Cessna 210L · Stuart, FL · Incident · No injuries · Incident investigation · Final report · Nov 12, 1988 · N2267S · Minor damage > While hand-propping the engine with a passenger in the right front seat, the eng started. The acft travelled uncontrolled into a parked unoccupied acft. Both acft sustained substantial damage. The plt on the ground & the passenger in the acft were not… - [NTSB MIA89LA019](https://openairdocs.org/ntsb/MIA89LA019.md): Piper PA-23-250 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Oct 29, 1988 · N5237Y · Substantial damage > The pilot noted an explosion in the right wing during engine start. He stated that the aircraft had been 'topped off' prior to the flight. Residue of fuel was found in the wing outside the fuel cells after the explosion. - [NTSB ANC89LA014](https://openairdocs.org/ntsb/ANC89LA014.md): Cessna TU206A · Soldotna, AK · Accident · No injuries · Limited investigation · Final report · Oct 26, 1988 · N4850F · Destroyed > The ATP certificated pilot and his two passengers were returning from a hunting trip when the turbocharged Cessna 206 caught fire soon after landing. The pilot stated that the engine quit during the landing roll and an attempt at restarting the engine as the… - [NTSB NYC89LA008](https://openairdocs.org/ntsb/NYC89LA008.md): American AA-5B · Wrightstown, NJ · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 1988 · N666GA · No damage > The plt said that the battery ran low while he was attempting to start his acft. He said he hand-propped the eng for several minutes and when he became fatigued, the passenger, who is also a pilot, began to hand prop the eng. When the passenger turned the… - [NTSB DEN88LA183](https://openairdocs.org/ntsb/DEN88LA183.md): Piper PA-22-108 · Hoven, SD · Accident · No injuries · Limited investigation · Final report · Aug 14, 1988 · N5301Z · Substantial damage > The private plt and his wife were going to make a local flight in their airplane at 0215. The plt said he hand- propped the acft and moved to enter the cabin as the engine started. The acft began to move, and his wife pulled the parking brake lock, which… - [NTSB NYC88LA212](https://openairdocs.org/ntsb/NYC88LA212.md): Cessna 152 · Swanton, VT · Accident · 1 fatal · Limited investigation · Final report · Aug 10, 1988 · N757LD · Minor damage > The plt took the passenger (his wife) on a short flt, which was her 1st flt. She was described as apprehensive. Before going back to the parking area after landing, the plt taxied to the terminal bldg for his wife to deplane. He stopped the acft with the left… - [NTSB NYC88LA208](https://openairdocs.org/ntsb/NYC88LA208.md): Ercoupe 415C · Auburn-Lewiston, ME · Accident · No injuries · Limited investigation · Final report · Aug 3, 1988 · N169WS · Substantial damage > The student pilot of an Ercoupe 415C hand-propped the aircraft with no one at the controls and the tail not tied down. The engine started and the Ercoupe struck a parked, unoccupied, tied down Cessna 170. - [NTSB SEA88LA194](https://openairdocs.org/ntsb/SEA88LA194.md): Aeronca 65-LB · Ephrata, WA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1988 · N33713 · Substantial damage > The pilot set the parking brake, then hand-propped the aircraft. He did not tie the aircraft down nor was it chocked. Also, he momentarily left the aircraft unattended; at that time, it began moving & subsequently collided with a parked aircraft. - [NTSB SEA88LA127](https://openairdocs.org/ntsb/SEA88LA127.md): Enstrom F-28F · Haines, AK · Accident · No injuries · Limited investigation · Final report · Jul 13, 1988 · N8620C · Substantial damage > The pilot purchased the helicopter with an undocumented modification designed to restrain the collective. Reportedly, hereceived no guidance regarding the use of the collective hold-down device. According to the aircraft manufacturer there existed no Enstrom… - [NTSB NYC88IA186](https://openairdocs.org/ntsb/NYC88IA186.md): MBB BK-117 · Manhattan, NY · Incident · No injuries · Incident investigation · Final report · Jul 12, 1988 · N135CP · Minor damage > Failure of the main rotor blade appears to be the result of a static downward bending overstress, caused by another helicopter hovering over or very close to the main rotor blade as it was in a static/stopped position. - [NTSB MKC88LA116](https://openairdocs.org/ntsb/MKC88LA116.md): Grumman G-164A · Cotton Plant, AR · Accident · No injuries · Limited investigation · Final report · Jun 22, 1988 · N8644H · Substantial damage > The pilot did not adequately secure the aircraft prior to hand-propping the engine. The engine started and resulted in the aircraft taxiing without a pilot at the controls. The pilot-less aircraft impacted a utility pole causing substantial damage. - [NTSB ANC88LA150](https://openairdocs.org/ntsb/ANC88LA150.md): Robinson R22HP · Mekoryuk, AK · Accident · No injuries · Limited investigation · Final report · Jun 17, 1988 · N9076D · Substantial damage > The pilot-in-command was herding reindeer for a native corporation and he and his passenger had to relieve themselves so they landed on the tundra and left the helicopter's engine and rotors operating. As they were exiting the helicopter, it shifted on the… - [NTSB DEN88LA127](https://openairdocs.org/ntsb/DEN88LA127.md): Cessna 182K · Cotton City, NM · Accident · No injuries · Limited investigation · Final report · Jun 14, 1988 · N2829R · Destroyed > The pilot reported that he was attempting to start the Cessna 182 for a cross country, solo, personal transportation flight. During the starting procedures, the engine backfired and the pilot smelled and saw smoke coming from the engine cowling area. The… - [NTSB FTW88LA117](https://openairdocs.org/ntsb/FTW88LA117.md): Cessna 172A · Cleveland, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1988 · N7317T · Substantial damage > This acft was damaged when it collided with a ditch and flipped over. The acft's battery was dead and the plt hand propped the eng without the benefit of chocks or an experienced individual in the cockpit. The eng started and as the plt was attempting to… - [NTSB DEN88LA116](https://openairdocs.org/ntsb/DEN88LA116.md): Cessna TR-182RG · Englewood, CO · Accident · Serious injuries · Limited investigation · Final report · Jun 1, 1988 · N999HP · No damage > The CFI, a private rated dual student, and one passenger were preparing to depart on a training flight. The CFI attempted to hand prop the airplane when the battery was found to be inoperative. During the attempt, the CFI was struck in the back of the head. - [NTSB MIA88LA165](https://openairdocs.org/ntsb/MIA88LA165.md): Rockwell 500-S · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · May 8, 1988 · N57222 · Substantial damage > The plt stated that he had just brought the acft to a stop & had shut down both engs. At that time, the lt. gear collapsed. Maintenance crew found that one of the actuating cyls was out of adjustment & the bungee cords were weak. The gear assy itself appeared… - [NTSB BFO88LA044](https://openairdocs.org/ntsb/BFO88LA044.md): Cessna 150J · Winchester, VA · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N905PS · 2 aircraft · Substantial damage > The T-6 struck the C-150 from behind while both were taxiing for takeoff. The C-150 was stopped at the time. There was an annual fly-in being held at the arpt with about 300 acft in attendance. Ground personnel were directing ground traffic. The T-6 plt said… - [NTSB NYC88LA130](https://openairdocs.org/ntsb/NYC88LA130.md): Beech 35 · New Haven, CT · Accident · No injuries · Limited investigation · Final report · Apr 25, 1988 · N4528V · Substantial damage > During engine start the throttle jammed in the full forward position and could not be pulled back to the idle position to retard the power. The aircraft started rolling and collided with an unoccupied parked aircraft. Examination of the throttle control… - [NTSB MIA88LA160](https://openairdocs.org/ntsb/MIA88LA160.md): Piper PA-28-161 · Hialeah, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 1988 · N47966 · Destroyed > Engine stalled during landing roll. During attempts to restart engine pilot flooded it. The engine backfired and the excess fuel in the carburetor caught fire. The pilot did not motor the engine in time to draw the flames into the engine and the fire spread… - [NTSB ANC88LA046](https://openairdocs.org/ntsb/ANC88LA046.md): Aerospatiale SA315B · Near Central, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1988 · N65185 · Substantial damage > The pilot-in-command landed at the 'hot' refueling site and was attempting to exit the helicopter for a crew change. The hot refueling landing pad consisted of a black membrane with bundles of laths placed perpendicular to the helicopter's skids to prevent… - [NTSB ATL88IA139](https://openairdocs.org/ntsb/ATL88IA139.md): Boeing 727-225A · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Apr 12, 1988 · N889Z · Minor damage > The left MLG outer cylinder main trunnion fractured and separated while the airplane was sitting at the gate, shortly before the planned departure. Subsequent metallurgical exam of the part revealed that it was improperly overhauled, which significantly… - [NTSB MIA88FA138](https://openairdocs.org/ntsb/MIA88FA138.md): Boeing 727-224 · Sarasota, FL · Accident · Serious injuries · Field investigation · Final report · Apr 3, 1988 · N88703 · No damage > The captain of the Boeing 727 aircraft was aware that a refueler was utilizing known quantity refueling procedures due to an inoperative fuel guage. He allowed the flight engineer to activate the b hydraulic system and the ground interconnect switch, without… - [NTSB MIA88FA132](https://openairdocs.org/ntsb/MIA88FA132.md): Swearingen SA-227-TT · Miami, FL · Accident · No injuries · Field investigation · Final report · Mar 29, 1988 · N30042 · 2 aircraft · Substantial damage > The plt stated that during his attempt to taxi around N30042, he thought he had enough clearance to get by, but misjudged the distance & the rudder of the merlin acft was struck by the DC6B'S left wing tip. Next page: https://openairdocs.org/ntsb-phases/150/cases.md?page=20 ## 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 = 150) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/150/cases?page=19 --- 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.