OpenAirDocs.org

NTSB investigations

35,885 cases where the phase of flight was Enroute.

Cases, newest first

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ATL87LA259Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Concord, NCWhile on climbout, the stu plt switched radios to the dest UNICOM freq. Unable to contact anyone on that freq, the departure arpt freq was reselected. No contact was established on this freq so the stu plt attempted to rtrn to the arpt. The haze was very…Sep 15, 1987 · N2280J · DestroyedNTSB ANC87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe engine stopped producing power but continued to windmill. The pilot was able to glide to a gravel bar and intentionally groundlooped to avoid hitting obstructions. The pilot stated he believed the aircraft ran out of fuel.Sep 15, 1987 · N4370A · Substantial damageNTSB NYC87LA253Accident · No injuriesLimited investigationFinal reportCessna 172D · Scottdale, PADuring a local pleasure flight, the pilot noticed the airspeed indicator was inoperative. On lndg the acft was obsvd to touchdown abt half-way down the rwy and faster than normal. The aircraft continued off the runway and crossed the airport road coming to…Sep 14, 1987 · N2467U · Substantial damageNTSB LAX87FA337Accident · Serious injuriesField investigationFinal reportPiper Aerostar 601P · Corona, CAThe airplane was refueled before it dept on the accd flight; the pilot did not supervise the fueling. Shortly after takeoff, the plt advised the ontario dept controller that both engines were experiencing a power loss and that he suspected jet fuel…Sep 14, 1987 · N902RG · DestroyedNTSB NYC87FA250Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Gaylordsville, CTThe pilot of the Piper PA-28-236 was cruising at 6000 ft at night when he reported a failure of his vacuum pump followed by loss of his attitude indicator and directional gyro. The aircraft was observed to make a 360 degree turn on the radar scope. The air…Sep 12, 1987 · N2186B · DestroyedNTSB FTW87FA214Accident · 4 fatalField investigationFinal reportBeech 58P · Austin, TXThe plt rcvd a full wx briefing at 0540 CDT & a wx update at 0737 when he filed an IFR flt plan. The flt was without incident with a final cruise alt of 16,000' until 1055:43, when the plt reqd a 'left turn for deviation.' About 3 min later, the ctlr noticed…Sep 12, 1987 · N1158T · DestroyedNTSB CHI87LA211Accident · No injuriesLimited investigationFinal reportCessna 172K · Jefferson, WIThe aircraft was en route on a personal cross country flight when it experienced an engine failure and was forced to make an emergency landing in an alfalfa field. The aircraft landed long and collided with a telephone pole and fence at the end of the field.…Sep 12, 1987 · N84352 · Substantial damageNTSB NYC87FA249Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Riverhead, NYThe Piper PA-28-180 experienced a power loss due to fuel exhaustion while flying over the long island sound. The pilot was unable to reach shore prior to ditching. The ditching was successful and both occupants exited the aircraft without injuries. After…Sep 11, 1987 · N15917 · DestroyedNTSB LAX87LA333Accident · Minor injuriesLimited investigationFinal reportAeronca Champ 7AC · Victorville, CAWhile climbing out over a ridge, the instructor, who was sitting in back, heard his student yell something. The instructor looked out the front windscreen just in time to see powerlines. Simultaneously, the student pushed the stick forward to go under the…Sep 11, 1987 · N85022 · Substantial damageNTSB ATL87FA255Accident · Serious injuriesField investigationFinal reportCessna 402C · Atlanta, GADuring climb to cruise at about 4,000 ft MSL, the plt heard a 'whistling' noise and noticed that the crew door adjacent to his seat was not completely secured. The door came open as he attempted to properly secure it, and yanked his left arm outside the acft.…Sep 11, 1987 · N4630N · Minor damageNTSB DEN87FA234Accident · 2 fatalField investigationFinal reportPiper PA-12-150 · Anaconda, MTBoth plts were reportedly avid big horn sheep hunters. On the morning of the accident, the 2nd plt picked up topographical charts of the area where the acft crashed. It was an area where the Montana department of fish, wildlife, and parks (fwp) had recently…Sep 8, 1987 · N7695H · DestroyedNTSB FTW87LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roby, TXAfter aprx 3.3 hrs of flt, the eng lost power from fuel exhaustion. The plt rprtd that when he made a forced landing in a field, the nose tire dug in the ground & the acft nosed over. Also, he stated that he did not top off the fuel tanks before departing on…Sep 7, 1987 · N4868B · Substantial damageNTSB DEN87FA231Accident · Serious injuriesField investigationFinal reportCessna 310J · Delta, UTPlt stated after the acc that he was not familiar with the fuel system on the Cessna 310. The main fuel tanks are on the wing tips and the aux tanks are in the wings. The plt thought the opposite. The plt departed and was burning fuel from the main tanks when…Sep 7, 1987 · N3037L · Substantial damageNTSB NYC87FA244Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Altoona, PAThe aircraft departed cleveland, oh at approx 0915 hours on an unauthorized flt to atlantic city, NJ. The plt was not authorized to operate the aircraft or conduct the flt due to his license having been revoked in 1977 for repeatedly violating FARS. Near…Sep 6, 1987 · N8692W · DestroyedNTSB FTW87LA211Accident · Minor injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe plt was on a x-country flt from addison to College Station, TX, but diverted to livingston, TX, due to 'time constraint.' The arpt at livingston was unattended. At aprx 1615 CDT, he took off & contd to College Station. However, during the flt, he became…Sep 6, 1987 · N48140 · Substantial damageNTSB ANC87FA146Accident · 2 fatalField investigationFinal reportCessna U206E · Harding Glacier, AKThe private pilot and his non-pilot adult male passenger were flying from modesto, CA, to soldotna, AK, for a hunting trip. The pilot, who had approximately 164 hours total flight time at the time of the accident, and who had no prior flying experience in…Sep 6, 1987 · N9407G · Substantial damageNTSB NYC87LA246Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Harrisburg, PAThe aircraft engine lost power while descending for a landing. The plt stated that when he advanced the throttle the engine quit completely. During lndg alongside a turnpike, the nose wheel collapsed and the prop was damaged. Investigation revealed that the…Sep 5, 1987 · N3023M · Substantial damageNTSB LAX87LA324Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lee Vining, CAWhile flying over mountainous terrain. The pilot inadvertently followed the wrong road & went into a box canyon area. He stated the visibility was about 5 miles & he did not see the upcoming rising elevation. Eventually, he got into a situation were the acft…Sep 5, 1987 · N6122G · DestroyedNTSB FTW87FA208Accident · Minor injuriesField investigationFinal reportCessna 208 · Bulverde, TXAfter leveling at 5500', the standby power annunciator light illuminated, followed by loss of oil pressure. The plt turned back toward the arpt, but there was a progressive loss of eng power & the prop went to a feathered psn. Drg an emerg landing at night,…Sep 5, 1987 · N807LA · Substantial damageNTSB CHI87LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · New Lenox, ILThe accident occurred on a local training flight. At 3500 ft MSL the eng failed. The student plt landed at a near-by arpt but bounced on touchdown, veered off the rnwy and nosed over. Eng exam disclosed broken primary venturi in carb.Sep 5, 1987 · N67447 · Substantial damageNTSB BFO87FA062Accident · 2 fatalField investigationFinal reportCessna 172P · Cabin, WVThe plt was on a VFR flight at 4500 ft MSL over a mountainous area when he encountered lowering clouds. The plt descended to stay below the clouds; however, he inadvertently entered the clouds. Afterwards he tried to turn around and as he did so, according to…Sep 5, 1987 · N65721 · DestroyedNTSB DEN87FA230Accident · 1 fatalField investigationFinal reportCessna 170B · Cedar City, UTWhile on a x-country flt the plt flew into a canyon where turbulence was encountered. The plt stated that he was unable to maintain alt and during the descent the acft collided with the terrain in a small side canyon.Sep 4, 1987 · N3541D · DestroyedNTSB DEN87DTE05Accident · No injuriesFinal reportPiper PA-25-235 · Center, COThe plt reported that the eng lost power while the acft was en route to spray a field. There was no suitable terrain for a forced landing and the plt landed the aircraft in a soft, cultivated field and nosed over. Examination of the eng revealed burned and…Sep 4, 1987 · N6796Z · DestroyedNTSB ATL87DEI12Accident · No injuriesFinal reportTomishin W-8 · Painesville, OHThe plt/owner of the homebuilt aircraft was making a local flight to determine the flt characteristics with a larger wing installed on the acft. The plt reported that while in flight an oil leak developed from the area of the propeller. The oil coated the…Sep 4, 1987 · N3992A · Substantial damageNTSB NYC87LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Montgomeryville, PAWhile climbing through about 1500' after takeoff, the engine began to lose power. The pilot turned back toward the airport, but subsequently all power was lost & the aircraft was damaged during a landing in a corn field. A post- accident examination revealed…Sep 3, 1987 · N596SP · Substantial damageNTSB LAX87LA323Accident · No injuriesLimited investigationFinal reportCessna 140 · Gorman, CAA Cessna 140 nosed over during the landing roll after a precautionary landing to a paved access road. The plt indicated that the oil pressure and oil temp began to drop for unknown reasons while in cruise flt. The plt stated he was unable to determine the…Sep 3, 1987 · N224MK · Substantial damageNTSB BFO87LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Tappahannock, VAThe acft was at 1500 MSL when a 300 RPM loss of power occurred. The plt sighted a private landing strip and he decided to make a precautionary landing on it. During the landing roll on the 62 ft wide grass strip the l wing struck corn stalks in an adjacent…Sep 3, 1987 · N78505 · Substantial damageNTSB ANC87LA135Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Glennallen, AKThe pilot related that he ran out of fuel enroute to his planned refueling stop and made an emergency landing on a highway, substantially damaging the airplane. He said that the enroute portion of his flight took much longer than anticipated due to strong…Sep 3, 1987 · N4451M · Substantial damageNTSB NYC87IA258Incident · Minor injuriesIncident investigationFinal reportBeech 99 · Portland, METhe acft was cruising at 2500 ft with no passengers on board. The co-pilot went into the cabin and noticed a loud hissing noise around the main cabin door. He checked the handle and locking pins and noticed the door was locked. He told the captain who…Sep 2, 1987 · N204BH · No damageNTSB MIA87IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 727-223 · Tampa, FLDuring descent the B727 crew noted the fire warning light illuminate on the #1 engine. They discharged 2 fire bottles into the engine but the warning light remained illuminated. They declared an emergency and landed at their destination. An emergency…Sep 2, 1987 · N844AA · Minor damageNTSB MIA87FA239Accident · 1 fatalField investigationFinal reportCessna 421 · Coral Springs, FLThe acft had been abandoned in the Bahamas for aprx 7 months. A plt, with no known flt time in a Cessna 421, flew it to ft lauderdale. Except to avoid clds, he made the flt at a low alt & airspeed. When asked why, he said he was trying to save the engs. The…Sep 2, 1987 · N421DT · DestroyedNTSB LAX87LA322Accident · No injuriesLimited investigationFinal reportGovernment Aircraft Fact Nomad 24A · Lanai, HIWhen the flt was aprx 15 mi west of Lanai on a cargo flt from honolulu to hilo, HI, the plt observed the fuel gauges oscillating erratically toward the low side. He diverted toward Lanai to refuel. However, when the flt was abt 9 mi westof Lanai, the left eng…Sep 2, 1987 · N37808 · Substantial damageNTSB CHI87LA200Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Appleton, WIThe plt rprtd that after the acft was at cruise flt, there was a rapid loss of hydraulic pressure. He returned to the dep arpt, but was unable to get the left main gear to lock down. Subsequently, the left main gear collapsed when the acft was landed. An…Sep 2, 1987 · N9168N · Substantial damageNTSB ATL87FA257Accident · 2 fatalField investigationFinal reportBeech V-35B · Hilton Head, SCPIC said he had wx brief. Noted tstms ovr atlantic & fog at arpt. Stated he would hold ovr ocean until arpt clr. Acft track on radar was into area of tstms ovr ocean followed by mode c altitude deviations and loss of radar contact. Acft recovered from ocean.…Sep 1, 1987 · N6591S · DestroyedNTSB LAX87LA320Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sonora, CADuring a pleasure flt the engine suddenly lost partial power. The plt made a forced landing in a parking lot where the aircraft touched down and collided with a fence that borders the lot. The engine was inspected and test run for approx 20 minutes at…Aug 31, 1987 · N737SL · Substantial damageNTSB ATL87LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Myrtle Beach, SCAfter about 45 mntes into the flight, the pilot noticed a drop in engine oil pressure when he decided to return to the airport. The cabin filled with smoke, and the engine continued to lose power. The pilot had no choice but to ditch. The wreckage…Aug 30, 1987 · N6094Z · Substantial damageNTSB ANC87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · High Lake, AKThe pilot and his passenger were on a fishing/sight-seeing flight when they encountered winds estimated at 35 knots blowing over a mountain ridge. The pilot attempted to fly over the ridge but turned away after experiencing a strong down draft. A second…Aug 30, 1987 · N9775D · Substantial damageNTSB NYC87FA240Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Kings Point, NYN3025W departed on a ferry flight with an unsecured, temporarily installed fuselage fuel tank. A computed c.g. at takeoff showed the aircraft about .9 inches aft of the aft limit. The aircraft had climbed to 7000 feet when the controller saw the aircraft…Aug 28, 1987 · N3025W · DestroyedNTSB MKC87LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hot Springs, ARThe pilot fueled the aircraft with 20 gallons of 100LL for his flight to Hot Springs, AR. Forty miles from Hot Springs the left fuel tank indicated empty and the pilot switched to the right tank. Approximately 10 miles from Hot Springs, the engine quit and…Aug 26, 1987 · N5683U · Substantial damageNTSB MIA87LA233Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Leland, MSWhile in cruise flight en route to a field for aerial application the engine lost power when the number one cylinder cracked between the spark plug holes. While maneuvering to land at a sod airstrip altitude could not be maintained and the left spray boom…Aug 26, 1987 · N4002K · Substantial damageNTSB ATL87LA241Accident · No injuriesLimited investigationFinal reportCessna 172 · Baxley, GADuring a supervised solo flight, the student pilot experienced a partial power loss. The student applied carburetor heat, but the engine continued to run rough. The student turned towards the airstrip and attempted an emgcy lndg. The acft touched down at…Aug 25, 1987 · N4275F · Substantial damageNTSB DEN87FA226Accident · 1 fatalField investigationFinal reportCessna 172RG · Cubero, NMThe plt rcvd a wx briefing prior to departure. VFR flt was not recommended by the briefer. N5247V departed at 2005 hrs and at 2200 hrs the plt radioed abq ARTCC that he was descending from 9000 ft to 7500 ft to avoid wx. ARTCC radar track was lost shortly…Aug 24, 1987 · N5247V · DestroyedNTSB ANC87LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Merrill Pass, AKThe aircraft engine failed in cruise flight. During the landing roll the airplane struck a ditch and nosed over. Examination of the aircraft and the statements from the pilot, revealed the aircraft ran out of fuel during the return trip to the airport.Aug 24, 1987 · N8288Z · Substantial damageNTSB MIA87LA230Accident · No injuriesLimited investigationFinal reportGrumman American AA-5 · Vega Baja, PRThe plt stated that he had descended from 4500 ft to get out of the clouds & at 1300 ft, the eng became rough. He stated the RPM dropped from 2300 to 1000. He also stated that he did not use carb heat prior to or during the descent. The plt stated that when…Aug 23, 1987 · N100UA · Substantial damageNTSB FTW87FA206Accident · 3 fatalField investigationFinal reportCessna U206G · Lissie, TXThe Piper aircraft, N1038U, departed from runway 32 at the municipal airport, wharton, Texas, on a northbound flight, about two minutes after the Cessna aircraft, N4745U. About 10 minutes later the two aircraft experienced a mid-air collision about 16…Aug 23, 1987 · N4745U · 2 aircraft · DestroyedNTSB ATL87LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Lewisburg, KYStudent PIC flew solo x-country. About 30 minutes after dpting enroute stop engine quit. He rptd checking fuel prior to departure. Flt school policy was to refuel at enroute stop which was not done. Acft was landed in a field and hit a fence during landing…Aug 23, 1987 · N5270B · Substantial damageNTSB MIA87LA228Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6D · Panama City, FLThe plt stated that he was inbound to sandy creek airport when he heard a loud bang and lost power. On landing rollout in a field the aircraft hit some sod, flipped over & came to rest inverted. Post crash examination of the engine revealed an internal blower…Aug 22, 1987 · N3771M · Substantial damageNTSB SEA87LA173Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Burns, ORA loss of power occurred during descent for landing. During forced landing the aircraft struck an irrigation ditch, collapsing the nose gear. The reason for the engine failure was a complete loss of oil coming from worn threads and a worn o ring to the oil…Aug 21, 1987 · N2007Y · Substantial damageNTSB MIA87LA227Accident · No injuriesLimited investigationFinal reportCessna 182P · Highland Beach, FLThe plt stated that they were at 1000 ft aprx 2 miles off shore en route to palm Beach international when the engine lost power & they ditched the acft in the ocean about 40 ft off the Beach. The salvage personnel stated that the left wing contained aprx 10…Aug 20, 1987 · N1591M · Substantial damageNTSB FTW87LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, TXThe engine quit during cruise flight at 5500 feet MSL but restarted when the pilot switched fuel tanks. He then headed for the nearest airport which was at Bridgeport, TX. While on final approach for landing the engine stopped again and would not restart. A…Aug 20, 1987 · N6895J · Substantial damage