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 NYC88IA112Incident · No injuriesIncident investigationFinal reportBoeing 757 · Providence, RIThe Boeing 757 was climbing through 20000 ft with the first officer on the flight controls when the 55 year old captain became incapacitated. The first officer delcared an emergency and made a normal landing. When clear of the runway, the aircraft was stopped…Mar 22, 1988 · N628DL · No damageNTSB SEA88IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Portland, ORCrew was unable to lower the left main lndg gear. Crew then executed an emergency landing on the right main and nose gear with minor damage to the acft. The investigation revealed that the left main gear door attach fitting had a fatigue fracture.Mar 21, 1988 · N515DA · Minor damageNTSB BFO88FA026Accident · 3 fatalField investigationFinal reportCessna 210N · Quantico, VAThe acft was abt 25 mi south & inbound to dca when the plt rprtd an enctr with snowshwrs which were part of a cold front. He asked & was clrd to dscnd to 2500 ft so he could maint VMC. Radar data showed, the acft dscndd past 2500 ft to 1300 ft. abt 16 mi…Mar 20, 1988 · N6401N · DestroyedNTSB SEA88LA062Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Umpqua, ORWhile flying low over a river the aircraft struck unmarked telephone wires. An off-airport landing was made onto a cow pasture. During the landing the aircraft struck the ground nose first. Post acc inspection revealed telephone wire insulation wedged near…Mar 19, 1988 · N81788 · DestroyedNTSB NYC88IA109Incident · No injuriesIncident investigationFinal reportBoeing 737 · Morristown, NJBoeing 737 (N69348) was depg newark intl arpt as a lear jet 24 (N500NH) was depg fm teterboro. Both were being ctld by new york TRACON (newark sector). The strip for the 737 was mismarked as a north departure rather than an east departure. The instructor/full…Mar 19, 1988 · N69348 · 2 aircraft · No damageNTSB SEA88LA059Accident · No injuriesLimited investigationFinal reportBeech A24R · Las Vegas, NVDuring climb to cruise the aircraft's door opened. The pilot then diverted to a nearby airport for a precautionary landing. During landing the pilot had difficulty maintaining directional control. The aircraft struck a runway edge light during landing roll…Mar 18, 1988 · N8307R · Substantial damageNTSB CHI88DEE03Accident · No injuriesFinal reportPiper PA-22-150 · West Chicago, ILThe plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…Mar 18, 1988 · N2758P · Substantial damageNTSB LAX88FA129Accident · 1 fatalField investigationFinal reportBeech V35B · Oildale, CAImproper maintenance given by the fixed based operator.Mar 17, 1988 · N4103A · DestroyedNTSB DEN88IA083Incident · No injuriesIncident investigationFinal reportCessna 210 · Billings, MTMar 17, 1988 · N2180S · Minor damageNTSB MKC88LA062Accident · No injuriesLimited investigationFinal reportGrumman G-164B · West Point, ARThe pilot said, shortly after takeoff, enroute to an aerial application operation, the engine began to lose pwr and began backfiring. He dumped a portion of his load, and made an emergency ldg in a soft, unplanted bean field. After rolling about 200 feet, the…Mar 15, 1988 · N6750Q · Substantial damageNTSB LAX88LA128Accident · No injuriesLimited investigationFinal reportCessna 150M · Lodi, CAOn the day of the accident, the pilot departed lancaster, California, flew to fresno to pick up a passenger and then continued on to Lodi, the ultimate destination. While being vectored toward the airport at Lodi, the engine quit and the aircraft collided…Mar 15, 1988 · N714FJ · Substantial damageNTSB MIA88LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Dorado, PRWhile on a personal flt in normal cruise at an alt of 1000 ft aprx 2 miles southeast of the arpt, the eng began to misfire and the cabin filled with smoke. The plt elected to land in a clearing. The plt also stated that the eng was losing pwr and tht a/c…Mar 14, 1988 · N5611Z · Substantial damageNTSB LAX88DVA02Accident · Minor injuriesFinal reportBell UH-1B · Arvin, CAMar 14, 1988 · N59368 · DestroyedNTSB LAX88LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-201T · Bullhead City, AZShortly after takeoff, the engine failed. During the forced landing the aircraft ran into a rock quarry. Inspection of the engine revealed that the fuel injector lines were loose and that one line had separated.Mar 13, 1988 · N694ME · Substantial damageNTSB DEN88DQA03Accident · 2 fatalFinal reportSurline Sidewinder · Moriarty, NMWitnesses heard the acft eng sound increase dramatically as the acft passed over a gen aviation airport. The acft was seen by another witness at low atl, estimated to be about 200 ft, as the nose pitched up. The acft then entered a spin and impacted the…Mar 12, 1988 · N185SA · DestroyedNTSB ATL88FA110Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Rock Hill, SCThe plt and a certificated pilot/pax departed the Rock Hill apt for a local maint test flt following an engine overhaul and installation. About 10 minutes into the flt, the engine oil pressure dropped to zero and a complete loss of power followed. The plt…Mar 12, 1988 · N8727E · DestroyedNTSB ATL88FA109Accident · 2 fatalField investigationFinal reportCessna 150 · Sylva, NCThe pilot was conducting a local pleasure flight when the airplane was seen in the boxed canyon maneuvering. The witness said that the pilot was getting lower on each pass, until the airplane was about 300 feet above the ground when the airplane went into a…Mar 11, 1988 · N1258Q · DestroyedNTSB LAX88LA123Accident · No injuriesLimited investigationFinal reportHelio HT-295 · Oracle, AZEngine failure for undetermined reasons.Mar 10, 1988 · N68871 · DestroyedNTSB ANC88FA037Accident · 1 fatalField investigationFinal reportBeech B35 · Nome, AKThe aircraft sustained an in-flight breakup during the enroute phase of the flight. The left fitting that secures the front spars of the stabilizers to the fuselage revealed the presence of pre-existing fatigue cracking. The initial separation of the left…Mar 10, 1988 · N5115C · DestroyedNTSB DEN88LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COThe private plt was performing a night solo training flight in the local area. After several stop and go landings, the plt was returning to her home airport. At 6300FT MSL, in cruise flight, the plt reported that the engine quit. Attempts to restart were not…Mar 9, 1988 · N47567 · Substantial damageNTSB NYC88DGT01Accident · 1 fatalFinal reportNorth American F-51D · State College, PAN51WE, a North American F-51D took off as the second ship of a two ship flight with N6341T, another F-51D. They were observed climbing in formation into the clouds. N6341T assumed communications and said they were a flight of 2 and ok, after ATC was unable to…Mar 7, 1988 · N51WE · DestroyedNTSB ATL88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Orangeburg, SCThe engine lost pwr as the airplane was returning from a fire-patrol flt. The plt made a forced ldg in a field where the airplane ran into soft dirt and nosed over. Post-crash exam of the acft revealed no evidence of any fuel ramaining in the fuel system. The…Mar 7, 1988 · N8994Y · Substantial damageNTSB MKC88LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mound City, MOThe PIC, after an earlier lndg at tarkio, Missouri and an unsuccessful attempt to reach his fishing partner, flew his acft to and landed at st. joseph rosecrans arpt. After contacting his friend, and catching a few hours of sleep, the PIC made an early…Mar 6, 1988 · N7703J · Substantial damageNTSB FTW88FA077Accident · Minor injuriesField investigationFinal reportFairchild M-62C · Arlington, TXFailure of the number six cylinder and piston.Mar 6, 1988 · N63739 · Substantial damageNTSB ATL88FA104Accident · 2 fatalField investigationFinal reportBeech A36 · Bow, KYThe pilot had received two weather briefings. In both, he was advised of forecast and known icing conditions. The pilot reported ice build-up to ATC. Afterward he requested no further assistance from ATC to locate a suitable landing area. Wreckage examination…Mar 5, 1988 · N2929R · DestroyedNTSB MKC88FA059Accident · 2 fatalField investigationFinal reportBeech E18S · Vienna, MOThe plt rcvd a wx briefing bfr starting a ngt cargo opn in known icing conds. Bfr the flt, a line serviceman noticed ice on the acft's wings & suggested its removal, but the plt declined. Aprx 45 min after tkof, the plt rprtd to ARTCC that a de-ice boot had…Mar 4, 1988 · N45A · DestroyedNTSB LAX88LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Hesperia, CAMar 4, 1988 · N2184U · Substantial damageNTSB ATL88LA100Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Norwalk, OHThe plt rptd that he was cruising at 9,000 ft when he observed the EGT gauge indication dropping. The engine began to run rough and he noticed a fuel odor in the cabin. The carb air temp gauge was indicating 'well out of' the icing range. He selected carb…Mar 4, 1988 · N84118 · Substantial damageNTSB FTW88LA076Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Midland, TXEncounter with severe turbulence within tops of convective clouds. Leading to this was the pilot's failure to properly evaluate the potential danger of the convective activity, which he chose to penetrate.Mar 3, 1988 · N8496P · Substantial damageNTSB ATL88IA102Incident · No injuriesIncident investigationFinal reportGovernment Aircraft Fact Nomad N22B · Birmingham, ALMar 3, 1988 · N422NE · Minor damageNTSB ANC88LA034Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Mcgrath, AKThe pilot had begun his descent for his destination airport 20 miles away when the engine lost all power. He was unable to restart the engine, and made a forced landing in deep snow. The pilot reported that he had been airborne for approximately two hours…Mar 3, 1988 · N1954U · Substantial damageNTSB SEA88FA054Accident · Minor injuriesField investigationFinal reportCessna T210N · Burns, ORThe aircraft engine quit during cruise flt on a bright moonlit night cross country flt at 8000 ft AGL, 28 NM west of Burns, OR. The pilot reversed course in an emergency descent and followed a straight 50 ft wide hwy toward Burns. At approx 500 ft. AGL the…Mar 2, 1988 · N5427A · DestroyedNTSB NYC88LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Maybrook, NYThe Piper PA-28 took off for a local pleasure flight. After takeoff the pilot noticed that the engine was running rough and he had lost his oil pressure. The engine seized and an off-airport landing was made in a snow covered field. Post-crash examination of…Mar 1, 1988 · N16255 · Substantial damageNTSB ATL88DMG03Accident · Minor injuriesFinal reportThorp T-18 · Advance, NCMar 1, 1988 · N1369 · Substantial damageNTSB FTW88IA078Incident · No injuriesIncident investigationFinal reportCessna T210M · Grosebeck, TXThe pilot made a forced landing following engine failure. Teardown examination showed the no. 4 exhaust valve head had separated from the stem. Metal debris was found in the oil sump. The no. 1 connecting rod was separated from the crankshaft. There was…Feb 28, 1988 · N761RP · Minor damageNTSB FTW88FA072Accident · Minor injuriesField investigationFinal reportCessna P206D · Eagle Lake, TXAn inflight fire erupted following the separation of the number 4 cylinder. A metallurgist determined that studs failed in fatigue. The aircraft continued to burn after the emergency landing and was completely destroyed. The acft had an annual inspection…Feb 28, 1988 · N8721Z · DestroyedNTSB LAX88FA118Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Frazier Park, CAImproper maintenance performed previous to the accident flight which failed to identify a fault which rendered the airplane nonairworthy. Contributing to this accident was the pilot's exercise of poor judgement in disregarding weather forecasts indicating…Feb 27, 1988 · N74236 · DestroyedNTSB LAX88DVA01Accident · Minor injuriesFinal reportEagle DW-1 · Modesto, CAWhile enroute for the purpose of spraying a field, the engine seemed to overspeed then lose power. The aircraft was landed on a soft field where during the landing roll, the aircraft nosed over. The propeller dome was found to have separated from the aircraft…Feb 27, 1988 · N8801Y · DestroyedNTSB FTW88DRG07Accident · No injuriesFinal reportGrumman G-164A · Alamo, TXThe pilot experienced a total loss of engine power during climb when he made his initial power reduction. The power loss was accompanied by a loud bang. A severe postaccident ground fire melted a large portion of the engine. A partial engine teardown was…Feb 26, 1988 · N4647 · DestroyedNTSB MKC88LA055Accident · No injuriesLimited investigationFinal reportCarter Quickee 2 · Springfield, MOWhile flying a homebuilt aircraft, under experimental category, the pilot experienced an engine failure. An emergency ldg was made on a highway, and during the ldg roll the acft struck some marker barrels, suffering substantial damage. The pilot said the…Feb 25, 1988 · N587TC · Substantial damageNTSB LAX88LA116Accident · No injuriesLimited investigationFinal reportBeech F35 · Pacoima, CAThe plt rprtd that he had initially psnd the fuel selector (sel) to the left main tank. He said that after abt 1 hr of flt (near palmdale, CA), he psnd the sel to the rgt main tank for a short time, then (near Pacoima), he moved it back to the left main tank.…Feb 25, 1988 · N5041B · Substantial damageNTSB CHI88DEM01Accident · Minor injuriesFinal reportNorth American T-28A · Schoolcraft, MIWhile the pilot was climbing through 7800 MSL he noticed a vapor trail coming from the right exhaust area. The pilot notified approach control that he was returning to the departure airport and they supplied radar vectors. The pilot started a descent and…Feb 24, 1988 · N14142 · Substantial damageNTSB FTW88LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Fabens, TXThe plt reported that the eng ran rough on a previous flt and he removed, cleaned, and replaced the spark plugs. He then took off and at a point seven miles from the departure arpt, the eng again began to run rough and intermittently. An emergency landing…Feb 23, 1988 · N5542Z · Substantial damageNTSB DEN88LA075Accident · No injuriesLimited investigationFinal reportCessna 206G · Loveland, COA commercial plt was flying a group of parachutists for a skydiving club. The aircraft encountered turbulence during a climb to 4,500 feet AGL. As the second jumper was exiting, the aircraft dropped and the parachutist struck the horizontal stabilizer. The…Feb 22, 1988 · N756EY · Substantial damageNTSB FTW88LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Worth, TXThe flt was cruising at 2,000 ft MSL when the eng lost pwr. The student plt changed fuel tanks and the engine regained pwr for about 20 sec then again lost pwr. During the forced landing the acft collided with a fence and nosed over. Examination of the eng by…Feb 21, 1988 · N3524P · Substantial damageNTSB BFO88FA024Accident · 2 fatalField investigationFinal reportCessna 177RG · Ellamore, WVAprx 3 hrs and 26 minutes after takeoff from republic airport, the plt reported having engine problems. Unable to make it to an airport, the plt radioed that he was going to attempt to land on a road. The airplane struck trees and crashed in a wooded area…Feb 21, 1988 · N2109Q · DestroyedNTSB DEN88LA080Accident · Minor injuriesLimited investigationFinal reportCessna TU-206 · Durango, COWhile on a cross country flight the plt ran short of fuel and altered course to another airport. The pilot said the acft engine failed short of the new destination due to fuel exhaustion. The plt performed an emergency landing in an open field and the acft…Feb 20, 1988 · N9848M · Substantial damageNTSB ATL88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, ALThe pilot had just purchased the aircraft and it had less than one hour on the overhauled engine. The pilot was at 1500 feet when the engine quit. On final approach to the emergency landing area, the aircraft collided with trees. The engine examination…Feb 20, 1988 · N1703R · Substantial damageNTSB SEA88IA051Incident · Minor injuriesIncident investigationFinal reportPiper PA-31T · Las Vegas, NVWhile cruising at FL270, right side cockpit window failed, resulting in decompression. Acft diverted to normal landing. Examination revealed lower bolts overtorqued and plexiglas compromised by excess primer, initiating cracking. Evidence indicated window not…Feb 19, 1988 · N2645Z · Minor damageNTSB MIA88LA109Accident · 3 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLBfr depg at ngt with no flt plan, non-inst rated plt was adzd of psbl clds forming at a low lvl. En route, he got radar flt flwg. Apchg his destn, he got vctrs & alt chgs to avoid wx & otr acft. At 2001:04, radar svc was trmtd with palm bchapch ctl to cont…Feb 19, 1988 · N43253 · Destroyed