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 LAX88LA189Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Anderson, CAAfter receiving information of existing unfavorable wind conditions and that fuel was not available at the planned refueling point the pilot elected to continue the flight without refueling. As he descended on approaching his destination the engine failed due…May 19, 1988 · N573HA · Substantial damageNTSB LAX88FA187Accident · 2 fatalField investigationFinal reportCessna 182A · Grand Canyon, AZPilots selection of an inappropriate cruise altitude which did not ensure adequte terrain clearance on the leg of the flight from page to Grand Canyon, Arizona. A factor in the accident was the pilot's flight schedule on the day of the accident which may have…May 18, 1988 · N4845D · DestroyedNTSB ANC88FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Skwentna, AKThe on-demand air taxi flight with the pilot and two passengers struck the rock face of a mountain at the 8600 foot level. According to witnesses at the time of the accident the weather conditions were poor and visibility was less than one-half mile. The…May 18, 1988 · N897P · DestroyedNTSB MKC88LA091Accident · No injuriesLimited investigationFinal reportCessna 170B · Bayard, NEThe pilot stated that he started the trip, from new Mexico to north dakota, the evening prior to the accident. Because of poor weather, the pilot re-routed the flight through several alternate fuel and oil stops. The flight was en route to a planned fuel stop…May 17, 1988 · N4510C · Substantial damageNTSB ANC88LA058Accident · No injuriesLimited investigationFinal reportCessna 185E · Tuntutuliak, AKThe private pilot-in-command of the Cessna 185 was performing business flying for the federal aviation administration. When he ran out of fuel during a cross country flight, he attempted an off-airport forced landing which resulted in a noseover accident. The…May 17, 1988 · N1592F · Substantial damageNTSB NYC88IA141Incident · No injuriesIncident investigationFinal reportCessna S550 · Allentown, PAWhile cruising at FL350 in light turbulence, the trailing half of the left hand outboard trailing edge flap separated from the acft. The pilot declared and emergency and landed at poughkeepsie, new york, without further incident. The portion of the damaged…May 16, 1988 · N81SH · Minor damageNTSB ATL88DKG07Accident · No injuriesFinal reportGrumman G164A · Clanton, ALMay 16, 1988 · N48438 · Substantial damageNTSB FTW88LA102Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Floresville, TXThe engine stopped producing full power and the pilot had to make a forced landing in a pasture. During the landing roll, the airplane impacted a fence. The pilot said he found fuel in both tanks but the right tank had collapsed due to the tank vent being…May 15, 1988 · N2RD · Substantial damageNTSB LAX88LA181Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A-3 · Chino, CADuring a sightseeing flight, the engine suddenly quit and an emergency off-field landing was made. During the landing roll, the aircraft collided with a fence. The pilot had been operating the aircraft off of the left fuel tank. The left fuel tank was found…May 14, 1988 · N46836 · Substantial damageNTSB DEN88FA107Accident · 2 fatalField investigationFinal reportStinson 108-2 · Mosca, COAfter purchasing acft, plt and plt-rated friend (both airline plts) were joined by plt's wife and departed falcon field, mesa, AZ, en route to MN. The trio stopped in alamosa, CO, for night. They departed alamosa (elevation 7608 ft MSL) the next morning and…May 13, 1988 · N354C · DestroyedNTSB ATL88IA171Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355-F · Reidsville, NCMay 13, 1988 · N101UC · Minor damageNTSB BFO88FA046Accident · Minor injuriesField investigationFinal reportPiper PA-28-180 · Arlington, VAThe acft had a total loss of eng power about 7 miles short of the destination necessitating a forced landing in a schoolyard. The acft had been flown about 4.4 hrs since it was last refueled. Examination of the acft revealed less than a gallon of fuel aboard.…May 12, 1988 · CGGNH · Substantial damageNTSB LAX88FA331Accident · 4 fatalField investigationFinal reportBeech B-35 · Ocotillo, CAInflight collision with terrain for undetermined reasons.May 11, 1988 · N8875A · DestroyedNTSB CHI88IA111Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Detroit, MIMay 11, 1988 · N9014U · No damageNTSB BFO88LA045Accident · No injuriesLimited investigationFinal reportMooney M-20J · Yorktown, VAThe plt was returning to the arpt after a 20 minute local flight. About 5 miles from the arpt he noticed the oil pres/temp gages indicated zero even after he checked the circuit breakers-shortly afterward the engine began to lose power and vibrate severely.…May 11, 1988 · N567MM · DestroyedNTSB FTW88LA098Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Sour Lake, TXThe acft struck trees and the grnd during a night cross country in marginal weather. The non-instrument rated pvt plt stated that he was flying in cruise flt at 1250' MSL when he hit trees. The closest wx station recorded 1200 overcast with 5 miles…May 9, 1988 · N3853V · DestroyedNTSB FTW88IA097Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · Detroit, MIThe PIC made an unscheduled landing following decompression at 30,000 feet. The aircraft had been written up by flightcrews numerous times between may 7 and may 9 for pressurization problems. Pressure bulkhead at station 940 in the right wheel well cracked 15…May 9, 1988 · N800AA · Minor damageNTSB LAX88FA192Accident · 2 fatalField investigationFinal reportBeech 35 · Santa Paula, CAPilot's failure to maintain an airspeed at which the aircraft is controllable and above the stall speed.May 7, 1988 · N3322V · DestroyedNTSB DEN88FA106Accident · 1 fatalField investigationFinal reportBell 47G-3B1 · Cortez, COThe plt said that he had just taken off and reached an alt of about 300 ft when his collective control went 'limp'. The helicopter entered a descent, partially controlled by the plt using throttle and cyclic control inputs. The helicopter touched down in soft…May 7, 1988 · N8455E · DestroyedNTSB MIA88LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Everglades City, FLThe plt stated when the flt departed, there was 33 gals of fuel aboard for the x-c daylight flight. Fuel burn for the acft was approx 8 gph. The flt to the dest required about 1.5 hrs. The plt stated that he intended to refuel at his destination, but the FBO…May 6, 1988 · N285DP · Substantial damageNTSB MKC88FA085Accident · Serious injuriesField investigationFinal reportCessna 182K · Neligh, NENone submittedMay 5, 1988 · N2872R · Substantial damageNTSB MIA88LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Freeport, BahamasThe pilot's inadvertent encounter with adverse weather.May 4, 1988 · N8068J · Substantial damageNTSB MIA88LA163Accident · No injuriesLimited investigationFinal reportBeech 58 · Centerville, MSThe pilot stated that he thought the aircraft had been refueled the previous evening. During preflight he did not observe any fuel in the aircraft fuel tanks. He further stated that the aircraft fuel quantity guages had been unreliable. In cruise flight both…May 2, 1988 · N7353R · Substantial damageNTSB DCA88IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Nr Tokyo, JapanUnited flt 97 experienced indications of uneven fuel flow from main tanks 2 and 3 at FL360 beginning about 4- hours after departure on an 11-hour transpacific flight. The fuel system had been set up for all engine feed from the nos 2 and 3 tanks. Although it…May 2, 1988 · N157UA · Minor damageNTSB MKC88FA082Accident · Serious injuriesField investigationFinal reportCessna 180 · Rolla, MOAs the pilot approached the Rolla, Missouri airport he stated that he switched the fuel tank selector from the right tank to both tanks in preparation for landing. The pilot stated that he did not know which direction he moved the fuel selector valve. Engine…May 1, 1988 · N9161C · Substantial damageNTSB BFO88LA042Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Mechanicsville, MDThe acft was flown with the engine cowling plugs installed. The engine overheated and it lost power. The plt said he forgot to remove the plugs during the preflight. During the forced landing roll the acft collided with a berm and the rt main lndg gear was…May 1, 1988 · N4022V · Substantial damageNTSB NYC88LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Jamestown, NYThe Piper PA-28-181 departed with two pilots onboard. About one hour after takeoff, the PIC got very sick and could not continue flying. She experienced a severe headache and vomitting. The non-instrument rated pilot continued the flight. The aircraft made…Apr 30, 1988 · N5688V · Substantial damageNTSB LAX88LA172Accident · No injuriesLimited investigationFinal reportCessna 150F · Westlake, CADuring a banner towing operation, the plt had just transferred fuel from the aux tank to the mains. Two minutes later the engine quit. A forced landing was made in a field where the acft collided with the terrain. The engine was inspected and ran for several…Apr 30, 1988 · N8008S · Substantial damageNTSB MKC88LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Dexter, MOShortly after takeoff, during an instructional night cross country training flt, the CFI said he began to lose engine RPM. He made a 180 degree turn to return to the departure apt, when he had a complete power failure. An emergency ldg was made on a freshly…Apr 29, 1988 · N25038 · Substantial damageNTSB CHI88LA104Accident · No injuriesLimited investigationFinal reportBeech K35 · Milaca, MNApr 29, 1988 · N6042E · Substantial damageNTSB ATL88LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · Sandy Ridge, NCThe aircraft engine began to vibrate excessively and lost power. The pilot landed the aircraft in a field. The aircraft nosed over in the soft ground. Examination of the engine revealed that the number one cylinder valve spring seat lock had failed allowing…Apr 29, 1988 · N60276 · Substantial damageNTSB DCA88MA054Accident · 1 fatalMajor investigationFinal reportBoeing 737-297 · Maui, HIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-89/03. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Flt…Apr 28, 1988 · N73711 · Substantial damageNTSB BFO88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkton, MDDuring cruise flt at an alt of 1500 ft, the engine suddenly stopped producing power. The acft was landed on railroad tracks in order to avoid trees. The acft nosed over during the landing. Plt stated that the right fuel tank gauge indicated 1/4 tank and the…Apr 28, 1988 · N4255F · Substantial damageNTSB ATL88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Danville, OHThe plt reported that the engine began to run rough about 2 hrs & 45 minutes into the low-level aerial photo flt. The engine subsequently lost power altogether and the plt made a forced ldg in a marsh. The airplane nosed over during the ldg. Post-crash exam…Apr 26, 1988 · N4835B · Substantial damageNTSB SEA88FA084Accident · 1 fatalField investigationFinal reportMaule M5-210C · Bend, ORPlt filed VFR after advised VFR not recommended. Witness observed acft on course for dest at low alt over hiway. Witness EST ceiling at 100 feet, visibility poor in mod snow. Acft observed to execute sharp left turn amd impact rising terrain. Corrective…Apr 25, 1988 · N312X · DestroyedNTSB MKC88LA079Accident · No injuriesLimited investigationFinal reportCessna 310P · Berryville, ARWhile trying out his friend's newly purchased twin, the pilot stated an emergency landing was made due to power loss because of fuel starvation. The PIC said he was negligent because he did not possess a multiengine rating and also did not study the fuel…Apr 25, 1988 · N5873M · Substantial damageNTSB ANC88LA049Accident · No injuriesLimited investigationFinal reportCessna 337D · Kenai, AKThe private pilot was practicing simulated instrument flight with his flight instructor in their mutually-owned airplane, when both engines quit within minutes of each other due to fuel exhaustion. The airplane struck trees in the ensuing emergency descent…Apr 23, 1988 · N86128 · Substantial damageNTSB ATL88LA153Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Memphis, TNThe pilot reported that the engine lost pwr in-flt due to fuel exhaustion. A forced ldg was made in a plowed field. The airplane nosed over during the ldg. The plt noted after the accident that he should have topped off the fuel tanks prior to departure. The…Apr 22, 1988 · N9603L · Substantial damageNTSB ATL88IA146Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-101/102 · Dothan, ALDuring cruise flight at 12,000 ft, the flight crew of the DHC-8 observed a low oil pressure warning light. About five seconds later, the right engine fire warning light illuminated. Fire was confirmed and the extinguisher discharged. The fire was extinguished…Apr 22, 1988 · N804MX · Minor damageNTSB MIA88LA156Accident · 1 fatalLimited investigationFinal reportMooney M-20J · Perry, FLJacksonville center reported a loss of radar contact with the acft at approx 2133 EDT after it descended from its last assigned altitude of 6000 feet. The sole occupant and debris from the acft were found shortly thereafter. The results of an autopsy on the…Apr 21, 1988 · N58110 · DestroyedNTSB DEN88FA100Accident · 2 fatalField investigationFinal reportCessna 182J · Rapid City, SDThe plt received a wx briefing prior to departure from miles city, MT. The briefing indicated wx conditions less than VFR with icing conditions. The plt departed and landed approximately 1 hour later to remove ice from his acft. The plt departed a second time…Apr 21, 1988 · N2720F · DestroyedNTSB CHI88LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Zeigler, ILUpon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over…Apr 21, 1988 · N9410U · Substantial damageNTSB DEN88FA099Accident · 2 fatalField investigationFinal reportBeech A23-19 · Gunnison, COOn a cross country flt, the plt attempted to climb through a pass which was above the effective service ceiling of the acft. At approximately the effective service ceiling of the acft the acft collided with terrain. The acft was destroyed by impact and post…Apr 20, 1988 · N7979L · DestroyedNTSB FTW88LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Azle, TXThe operator stated the night instrument training flight departed with 8.5 gallons of fuel. One hour and thirty minutes later, the airplane hit a tree during flare for a forced landing due to engine failure. The student stated the fuel gage indicated one…Apr 19, 1988 · N704MF · DestroyedNTSB FTW88IA092Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Henderson, TXThe pilot experienced total loss of power from the left engine and a partial loss of power from the right engine due to fuel starvation. The main fuel tanks on which the engines were operating were found empty but there was an adequate fuel supply in the…Apr 19, 1988 · N59981 · No damageNTSB MIA88LA155Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mcdavid, FLThe plt stated that the flt was 15 miles from the destination & had been diverted due to haze. While flying at an alt of aprox 2,000 ft, the eng quit due to non-mechanical reasons. He was unable to restart it. The plt landed the a/c on a road, during which…Apr 18, 1988 · N2322F · Substantial damageNTSB MIA88LA204Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLWhile en route, on a personal cross country flt, the alternator belt broke resulting in the loss of electrical power which the plt did not recognize before the battery had been drained. During the precautionary landing the acft landed hard resulting in…Apr 17, 1988 · N2032M · Substantial damageNTSB LAX88LA164Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Florence, AZDuring a cross country flight, the engine suddenly quit, restarted, then quit completely. A forced landing was made in a dry wash where the aircraft nosed over during the landing roll. Approximately 4 gallons of fuel was drained from the fuel system. There…Apr 17, 1988 · N5504S · Substantial damageNTSB LAX88FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Essex, CAFailure of the pilot to maintain sufficient altitude to ensure terrain clearance while mountain flying.Apr 17, 1988 · N1681J · DestroyedNTSB BFO88FIG01Accident · Minor injuriesFinal reportCessna 152 · Annapolis, MDThe stu & instr were returning to mitchellville after doing several touch & go landings at stevensville. The acft was level at 1700 ft when a power loss occurred. Attempts to restart the engine were unsuccessful. The instr took control of the acft and landed…Apr 17, 1988 · N5269H · Substantial damage