# NTSB investigations: Enroute 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 296 of 718 · 35,885 cases ## Cases, newest first - [NTSB MIA88IA256](https://openairdocs.org/ntsb/MIA88IA256.md): Bellanca 8KCAB · Miami, FL · Incident · No injuries · Incident investigation · Final report · Aug 18, 1988 · N7699S · Minor damage > While on a personal flt during normal cruise, the plt reported that the cockpit filled with smoke. He turned off the electrical system & secured the eng, then attempted a precautionary landing on a grass strip. The acft landed long, overran the rwy, & nosed… - [NTSB LAX88LA288](https://openairdocs.org/ntsb/LAX88LA288.md): Piper PA-28-236 · Camarillo, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 1988 · N2563Y · Substantial damage > During a cross country flight, the pilot reported that he was 'scud running' to the airport. The pilot was following a road that ran near the airport, however, the pilot lost sight of the road. The pilot decided to divert to another airport and then the… - [NTSB ANC88FA111](https://openairdocs.org/ntsb/ANC88FA111.md): Cessna 402B · Mt. Torbet, AK · Accident · 2 fatal · Field investigation · Final report · Aug 18, 1988 · N5718M · Substantial damage > The on-demand-charter flight was to originally pickup passengers and cargo but a landing gear problem forced another airplane with a mechanic to be dispatched. The other airplane returned with the passengers and the accident airplane was repaired by the… - [NTSB NYC88LA220](https://openairdocs.org/ntsb/NYC88LA220.md): Champion 7ECA · Lakeville, MA · Accident · Minor injuries · Limited investigation · Final report · Aug 17, 1988 · N9022L · Substantial damage > According to the acft owner, N9022L'S fuel tanks were only one quarter full of fuel when the plt took off. The pax said that after about an hour of flying the engine began to run roughly and then it finally quit. The plt made an unsuccessful forced landing.… - [NTSB CHI88LA212](https://openairdocs.org/ntsb/CHI88LA212.md): Cessna 172F · Crandon, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 17, 1988 · N5318R · Substantial damage > During cruise flight in deteriorating meteorological conditions, the pilot experienced a total loss of engine power. The pilot performed emergency procedures, was unable to restart the engine, and executed a forced landing in a clover field. The aircraft… - [NTSB SEA88FA154](https://openairdocs.org/ntsb/SEA88FA154.md): Cessna 210E · N Bonneville, WA · Accident · 2 fatal · Field investigation · Final report · Aug 16, 1988 · N3ME · Destroyed > While on a flt from oroville to orchards, WA, the acft was about 25 to 30 mi east of the destn when it collided with trees & crashed. Impact occurred aprx 100 ft below the top of a ridgeline at an elev of about 1755 ft. a witness, who heard the crash, rprtd… - [NTSB LAX88LA287](https://openairdocs.org/ntsb/LAX88LA287.md): Cessna T210N · Culver City, CA · Accident · No injuries · Limited investigation · Final report · Aug 15, 1988 · N9746Y · Substantial damage > During a pleasure flight, the engine experienced a loss of power. A forced landing was made during which the airplane collided with wires and was substantially damaged. During the inspection of the airplane, the fuel tanks were found exhausted of fuel. - [NTSB CHI88LA210](https://openairdocs.org/ntsb/CHI88LA210.md): Cessna 172N · Montgomery, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 1988 · N1925F · Destroyed > While on a local pleasure night flight, in normal cruise configuration, the pilot experienced a loss of engine power due to fuel contamination and executed a forced landing on a highway exit ramp. The pilot stated that he attempted to make the forced landing… - [NTSB CHI88LA209](https://openairdocs.org/ntsb/CHI88LA209.md): Cessna 172RG · Mt. Vernon, OH · Accident · No injuries · Limited investigation · Final report · Aug 14, 1988 · N9769B · Substantial damage > While in cruise flight in VFR conditions and on an IFR flight plan, the pilot experienced a total loss of engine power. The pilot executed a forced landing in a soy bean field after an unsuccessful restart attempt. Examination of the oil cooler hose revealed… - [NTSB CHI88FA201](https://openairdocs.org/ntsb/CHI88FA201.md): Cessna 210B · Noblesville, IN · Accident · 4 fatal · Field investigation · Final report · Aug 13, 1988 · N562D · Destroyed - [NTSB CHI88DEM08](https://openairdocs.org/ntsb/CHI88DEM08.md): Champion 7KCAB · Grand Haven, MI · Accident · No injuries · Final report · Aug 13, 1988 · N5124T · Substantial damage > The pilot's inattentive fuel system monitoring, and the resultant total failure of the aircraft's powerplant due to fuel exhaustion. A forced landing was executed on a stretch of beach with sand dunes, and the aircraft was substantially damaged during the… - [NTSB MKC88LA156](https://openairdocs.org/ntsb/MKC88LA156.md): Cessna 152 · St Charles, MO · Accident · No injuries · Limited investigation · Final report · Aug 12, 1988 · N96344 · Substantial damage > The plt rprtd that during the flt, he enctrd thunderstorm activity, as well as a downdraft, which resulted in a loss of about 400 ft of alt. Subsequently, the acft was landed in a corn field & was damaged. About 13 mi se at st louis, the visibility was rprtd… - [NTSB DEN88GA185](https://openairdocs.org/ntsb/DEN88GA185.md): Cessna 182R · Georgetown, CO · Accident · 1 fatal · Final report · Aug 12, 1988 · N9545H · Substantial damage - [NTSB DEN88LA180](https://openairdocs.org/ntsb/DEN88LA180.md): Bell 206B · Sturgis, SD · Accident · No injuries · Limited investigation · Final report · Aug 11, 1988 · N49727 · Substantial damage > The plt was on a flt with 2 pax to take pictures. He stated that 'while in level flight at 120 mph and 300 feet above the ground, a pitch over was initiated for picture taking. At that moment, it appeared that the fuel flow cavitated. The forward fuel pump… - [NTSB CHI88DEP10](https://openairdocs.org/ntsb/CHI88DEP10.md): Piper PA-25-235 · Beaver Dam, WI · Accident · No injuries · Final report · Aug 11, 1988 · N4856Y · Substantial damage > While in cruise flight the aircraft experienced a total loss of power due to fuel exhaustion. The pilot stated that there were no good landing areas available, so he elected to make the emergency landing in a marsh. The aircraft landed hard and sustained… - [NTSB MKC88LA153](https://openairdocs.org/ntsb/MKC88LA153.md): Cessna 150 · Macomb, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 9, 1988 · N4503U · Substantial damage > The acft had been flown 235 nautical miles the previous day without re-fueling. The PIC stated he thought that he could reach his next fuel stop without refueling at the departure arpt. The PIC stated he flew the acft in that gen dirctn for abt 1 hour. At the… - [NTSB CHI88DEP09](https://openairdocs.org/ntsb/CHI88DEP09.md): Eaa Acro II · Fond Du Lac, WI · Accident · Minor injuries · Final report · Aug 9, 1988 · N9EA · Substantial damage > The plt rprtd that after reaching cruise alt, the eng began to run rough & subsequently lost power. He made an emerg landing in a dry cultivated field. Drg the landing, the gear collapsed & the acft was substantially damaged. The fuel tank was equipped with a… - [NTSB SEA88LA149](https://openairdocs.org/ntsb/SEA88LA149.md): Cessna 152 · Yoncalla, OR · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N67992 · Substantial damage > Student plt was at 8500 ft crz when pwr loss occurred. Forced lndg made in open field where acft collided with fence on lndg roll. Engine ran normally post-mishap. Fuel sample clear of water or other contaminant. Plt did not use carb heat when pwr loss… - [NTSB NYC88LA203](https://openairdocs.org/ntsb/NYC88LA203.md): Cessna 182 · Wildwood, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1988 · N20722 · Substantial damage > The aircraft struck a building after if experienced a power loss due to fuel exhaustion caused by oil dilution and low engine compression. - [NTSB DEN88LA179](https://openairdocs.org/ntsb/DEN88LA179.md): Cessna 182P · Casper, WY · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N182AD · Substantial damage > Drg flt after an annual inspn, the eng lost power as the acft was climbing to cruise. Attempts to restart the eng were unsuccessful. Subsequently, the acft was landed on rough/rocky terrain where it nosed over. When the eng was being checked after the acdnt,… - [NTSB ANC88LA106](https://openairdocs.org/ntsb/ANC88LA106.md): Cessna 207A · Cooper Landing, AK · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N9829M · Substantial damage > After loss of oil pressure then engine failure at 2,800 feet MSL, the pilot elected to make an emergency Landing along the shore line. After the pilot and passengers exited the aircraft, the airplane sank into 100 to 150 feet of water. Neither the airplane… - [NTSB SEA88LA145](https://openairdocs.org/ntsb/SEA88LA145.md): Beech K-35 · Halley, ID · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N3PH · Substantial damage > Engine pwr loss occurred approaching destinaton about 2000 ft AGL. Plt switched fuel and attempted restart but failed to utilize proper procedures. Acft collided with wire fence hidden in tall vegetation on chosen forced lndg site. Investigation revealed left… - [NTSB MKC88DCA01](https://openairdocs.org/ntsb/MKC88DCA01.md): Rosenmayer Skyranger S/C · Maryland Hgts, MO · Accident · 1 fatal · Final report · Aug 7, 1988 · N830CR · Destroyed > Witnesses observed the a/c making a turn when the wings came off and the a/c nose-dived to the ground with the wings 'floating' down after the a/c. examination of the wreckage found a fatigue crack 1/3 the circumference with instantaneous cracking on the… - [NTSB LAX88LA283](https://openairdocs.org/ntsb/LAX88LA283.md): Cessna 175 · Needles, CA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N7355M · Substantial damage > While at cruise flight, the pilot noticed that the oil pressure was low and shutdown the engine. During the emergency landing, the prop freewheeled, vibrated severely, and smoke filled the cockpit. The acft landed on a pipeline right of way causing… - [NTSB LAX88LA282](https://openairdocs.org/ntsb/LAX88LA282.md): Cessna 150L · Corona, CA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N7297G · Substantial damage > During a cross country flight, the engine suddenly lost power. The pilot initiated a forced landing on a residential street where, during the landing roll, the airplane collided with a parked vehicle. Inspection of the airplane revealed that there was… - [NTSB LAX88DVM03](https://openairdocs.org/ntsb/LAX88DVM03.md): Wittman Tailwind W-8 · Watsonville, CA · Accident · No injuries · Final report · Aug 7, 1988 · N333HL · Substantial damage - [NTSB FTW88IA145](https://openairdocs.org/ntsb/FTW88IA145.md): Bell 222UT · Cameron, LA · Incident · No injuries · Incident investigation · Final report · Aug 7, 1988 · N3190K · Minor damage > Plt stated that the acft pitched 20 deg nose down without warning while in cruise flt at 1,200' and 120 KTS. Following recovery, the acft required additional rt pedal to stay in trim and it flew about 10 deg nosed down in lvl flt. Flt diverted to the opr's… - [NTSB DEN88DTM03](https://openairdocs.org/ntsb/DEN88DTM03.md): Falco F8L · Grantsville, UT · Accident · 2 fatal · Final report · Aug 7, 1988 · N69WD · Destroyed > This acdt involved a homebuilt, side-by-side, two place, low wing, high performance aircraft. The purpose of the flt was to visit an airshow at wendover. The weather was reported to be clear with light winds. Radar track data showed the acft tracked straight… - [NTSB CHI88LA199](https://openairdocs.org/ntsb/CHI88LA199.md): Piper PA-28 · Crestwood, IL · Accident · No injuries · Limited investigation · Final report · Aug 7, 1988 · N2098R · Substantial damage - [NTSB CHI88DER08](https://openairdocs.org/ntsb/CHI88DER08.md): Cessna T337D · Jacobson, MN · Accident · Serious injuries · Final report · Aug 7, 1988 · N11RA · Substantial damage > During the climb from takeoff, the front engine sustained a total power loss due to a fuel leak. The pilot secured the engine, however was unable to maintain altitude, losing about 50 ft per minute. Due to a thunderstorm at the departure airport, he elected… - [NTSB BFO88LA073](https://openairdocs.org/ntsb/BFO88LA073.md): Piper PA-28-180 · Racine, WV · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1988 · N4873T · Substantial damage > The pilot was on the first leg of a ferry flight to west germany. The aircraft was about 30 miles from charleston when the pilot noticed the fuel gauges indicated about 5 & 11 gals respectively remaining in the left & right fuel tanks. He proceeded to… - [NTSB ATL88LA229](https://openairdocs.org/ntsb/ATL88LA229.md): Ryan Navion · Cumming, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 1988 · N4575K · Substantial damage > The pilot had made a precautionary landing due to enroute weather. After conditions had improved he obtained a weather briefing for his intended destination. He was told that there were tstms in the area but that conditions were VFR. After departure from the… - [NTSB SEA88LA147](https://openairdocs.org/ntsb/SEA88LA147.md): Bell 206B · Enterprise, OR · Accident · No injuries · Limited investigation · Final report · Aug 6, 1988 · N300TW · Substantial damage > While in cruise flt at abt 500 ft AGL, the plt stated he heard a 'ping' sound from the eng and pwr decreased to flt idle. An autorotation was attempted into a cleared upsloping area but the plt had to pull 'up' collective in order to clear a fence. A hard… - [NTSB MIA88LA247](https://openairdocs.org/ntsb/MIA88LA247.md): Enstrom F-28F · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Aug 6, 1988 · N280MW · Substantial damage > While at an alt of aprx 800 ft 1 mile offshore, the plt reported a drop of the manifold pressure from 29 to 20'HG, & as a result, the main rotor and engine RPM needles split. He then turned on the boost pump with negative results. An autorotative landing in… - [NTSB ATL88LA228](https://openairdocs.org/ntsb/ATL88LA228.md): Mooney M20F · Burkesville, KY · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 1988 · N6864V · Destroyed > The plt reported that the airplane encountered heavy rain and extreme turbulence while flying over a black cloud at 8,500 ft. he stated that it was as if an 'invisible tornado had reached out' and grabbed the airplane; excessive climb & descent rates were… - [NTSB SEA88LA144](https://openairdocs.org/ntsb/SEA88LA144.md): Cessna 172K · Moses Lake, WA · Accident · No injuries · Limited investigation · Final report · Aug 5, 1988 · N84445 · Substantial damage > While on his first x-country flt in this type aircraft, the pilot decided to land short of the destination due to low fuel. The engine quit from fuel exhaustion during descent. The aircraft nosed over on touchdown in a soft irrigated field one mile from the… - [NTSB FTW88LA146](https://openairdocs.org/ntsb/FTW88LA146.md): Piper PA-24 · Westville, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 5, 1988 · N5932P · Substantial damage > The pilot descended the airplane from 5000 feet using reduced power but without using carburetor heat. At 3500 feet the pilot advanced the throttle but the engine did not accelerate and then stopped producing power completely. Despite corrective measures by… - [NTSB MIA88LA246](https://openairdocs.org/ntsb/MIA88LA246.md): Air Tractor AT-301 · Glen Allen, MS · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1988 · N3659G · Substantial damage > According to FAA personnel while returning to land during an aerial application flt, the eng quit due to fuel exhaustion. The acft was damaged drg the forced landing. - [NTSB DEN88LA172](https://openairdocs.org/ntsb/DEN88LA172.md): Cessna 182 · Guffey, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1988 · N182VR · Destroyed - [NTSB BFO88LA071](https://openairdocs.org/ntsb/BFO88LA071.md): Piper PA-22-150 · Harrisonburg, VA · Accident · No injuries · Limited investigation · Final report · Aug 4, 1988 · N1665A · Substantial damage > The plt encountered clouds during a night VFR flight. He decided to make a precautionary lndg on what he thought was a lighted farm landing strip. However, he later learned the strip was actually a row of lighted turkey barns. According to the plt, as he made… - [NTSB MKC88FA147](https://openairdocs.org/ntsb/MKC88FA147.md): Mooney M20C · Missouri City, MO · Accident · 2 fatal · Field investigation · Final report · Aug 3, 1988 · N6528U · Substantial damage > The co-owner of the acft stated he had experienced a fuel flow pblm while flying to the (ojc) arpt, where pax (one of them was a co-owner) were to board. He stated he advzd the other owner of the pblm, but no corrective action was taken. The acft was then… - [NTSB LAX88LA279](https://openairdocs.org/ntsb/LAX88LA279.md): Mooney M20E · Visalia, CA · Accident · No injuries · Limited investigation · Final report · Aug 3, 1988 · N9273M · Substantial damage > The pilot removed the vacuum pump from the engine prior to the flight because of an internal failure in the pump. The pilot did not install a cover plate on the accessory mounting hole vacated by the pump. After takeoff on the local flight, the pilot noticed… - [NTSB FTW88LA142](https://openairdocs.org/ntsb/FTW88LA142.md): Beech A36TC · Vega, TX · Accident · No injuries · Limited investigation · Final report · Aug 2, 1988 · N3707Z · Substantial damage > Unreported propeller strike. - [NTSB NYC88LA200](https://openairdocs.org/ntsb/NYC88LA200.md): Cessna 152 · Hillsville, PA · Accident · No injuries · Limited investigation · Final report · Aug 1, 1988 · N4609L · Destroyed > Engine power loss due to fuel starvation which resulted in an emergency landing in a field. - [NTSB CHI88FAMS2](https://openairdocs.org/ntsb/CHI88FAMS2.md): Mooney M20K · Racine, WI · Accident · Serious injuries · Missing aircraft · Final report · Aug 1, 1988 · N56352 · Destroyed > Engine failure due to fuel starvation. - [NTSB NYC88FA248](https://openairdocs.org/ntsb/NYC88FA248.md): Piper PA-39-30 · Margaretville, NY · Accident · 2 fatal · Field investigation · Final report · Jul 31, 1988 · N2875A · Destroyed > The acft departed block island, RI en route to stewart international airport, newburgh, new york, the aircraft never arrived and was reported missing August 2, 1988. The aircraft was missing until November 21, 1988 when it was found near Margaretville, NY by… - [NTSB MKC88LA143](https://openairdocs.org/ntsb/MKC88LA143.md): Cessna 188 · York, NE · Accident · No injuries · Limited investigation · Final report · Jul 31, 1988 · N21779 · Substantial damage > En route to perform an aerial application operation, the plt said he experienced a partial power loss followed by complete power failure. He attempted an emergency ldg in a farm cornfield, substantially damaging the acft. An on scene investigation by the FAA… - [NTSB NYC88LA198](https://openairdocs.org/ntsb/NYC88LA198.md): Lake LA-4-200 · Montpelier, VT · Accident · Serious injuries · Limited investigation · Final report · Jul 30, 1988 · N2883P · Substantial damage > Engine power loss due to fuel contamination of water and rust particles in fuel system. - [NTSB MKC88LA145](https://openairdocs.org/ntsb/MKC88LA145.md): Grumman G-164B · West Helena, AR · Accident · No injuries · Limited investigation · Final report · Jul 30, 1988 · N8257K · Substantial damage > The plt said, while enroute to an aerial application operation, the engine lost power and an emergency ldg was made into the trees. Post accident investigation revealed that an intake valve on number 9 cylinder had failed. - [NTSB LAX88FA272](https://openairdocs.org/ntsb/LAX88FA272.md): Cessna 177RG · Cedar Grove, CA · Accident · 3 fatal · Field investigation · Final report · Jul 30, 1988 · N52504 · Destroyed > Pilots decision to attempt a flight through a mountainous area at an altitude insufficient to ensure terrain clearance. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=297 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=296 --- 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.