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 SEA88FA176Accident · 2 fatalField investigationFinal reportBell 204B · Entiat, WAThe acft was on contract to state of WA and working to suppress a forest fire using a water bucket suspended on a long line. The acft had refueled at a temporary heliport at Entiat, WA and was enroute to the work area 15 NM sw of Entiat but did not arrive at…Sep 10, 1988 · CFAHY · DestroyedNTSB LAX88LA316Accident · No injuriesLimited investigationFinal reportCessna 182M · Crescent City, CAFailure of the number 2 piston due to preexisting fatigue cracks in the piston.Sep 10, 1988 · N4834P · Substantial damageNTSB MIA88FA267Accident · 4 fatalField investigationFinal reportBeech K35 · Morriston, FLThe student pilot was about 47 miles from home and nearing completion of a x-c flt with his wife, father, and mother. The plt had reqsted VFR flight following & had been cruising at 6500 ft. the plt advised ATC they were down to 6250 ft & needed to descend…Sep 7, 1988 · N9525R · DestroyedNTSB ANC88LA128Accident · No injuriesLimited investigationFinal reportCessna 180H · Figure 8 Lake, AKThe private pilot and his passenger were uninjured following a forced landing on a survey trail. The pilot related that the airplane ran out of fuel, and nosed-over during the landing roll on the soft soil. He said that he did not visually inspect the…Sep 7, 1988 · N2483F · Substantial damageNTSB ATL88LA248Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Calera, ALThe plt reported that the engine lost power during descent. The airplane subsequently crashed into a cornfield after clearing a row of trees, as the plt was attempting to make a forced landing. Post-crash exam of the airplane revealed that both the main & aux…Sep 6, 1988 · N24487 · Substantial damageNTSB MIA88LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Waynesboro, MSWhile cruising at 5500 ft, the plt smelled burning oil. Moments later, oil press was lost, the prop went into high RPM & the tach zoomed over redline. A loud report was heard & all power was lost. A forced ldg was attempted in the rolling country but the acft…Sep 5, 1988 · N43046 · Substantial damageNTSB ANC88LA126Accident · No injuriesLimited investigationFinal reportStinson 108 · Mt Spur, AKAt 1500 feet m.s.l. a complete engine failure occurred. An emergency landing was made on a gravel bar. During the rollout the airplane collided with a gravel bank. An on site examination of the engine revealed a hole in the case next to the left exhaust…Sep 5, 1988 · N97326 · Substantial damageNTSB LAX88FA309Accident · 2 fatalField investigationFinal reportCessna 150J · Hemet, CAPilot's failure to maintain an airspeed at which the aircraft is controllable. Gusty winds, high density altitudes and the failure of the pilot to obtain a preflight weather briefing and to conduct an evaluation were factors in the accident.Sep 4, 1988 · N60547 · DestroyedNTSB ATL88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, TNThe pilot reported that while in cruise flight he had a partial then total electrical failure. During the off- airport emergency landing on a wet, grassy field, the pilot was unable to stop before sliding into a culvert. Examination of the airplane revealed…Sep 4, 1988 · N1281T · Substantial damageNTSB NYC88LA233Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Parker City, PAThe purpose of the flt was to perform landings at some nearby apts to prepare the student for an upcoming check flt. Landings were completed at two apts and the PIC, an atp/cfi, requested radar vectors to another apt. Approach control was unable to find the…Sep 3, 1988 · N2568N · Substantial damageNTSB ATL88LA244Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Berkeley, KYThe plt reported that he departed with 6 hrs of fuel on board. He encountered low ceilings while en route, and flew at 3-500 ft AGL to maintain VFR. About 3 hrs & 15 minutes after departure, the engine sputtered and lost power. The plt made a forced ldg in…Sep 3, 1988 · N52655 · Substantial damageNTSB LAX88LA305Accident · No injuriesLimited investigationFinal reportCessna 150J · Santa Ynez, CAThe pilot stated that while en route, the airplane's engine began to run rough. He turned on the carburetor heat. The engine returned to normal operation. The pilot turned off the carburetor heat. The engine again ran rough then lost all power. The pilot…Sep 2, 1988 · N60117 · Substantial damageNTSB NYC88LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mansfield, MAThe acft, with a CFI and student on board, had just made a touch and go landing and was about one mile fm the arpt, climbing to cruise, when the eng lost power. It was dark and the pilot attempted a landing on a state highway. The acft collided with a traffic…Sep 1, 1988 · N9087D · Substantial damageNTSB MKC88LA167Accident · Serious injuriesLimited investigationFinal reportSwearingen SA-226 · Emporia, KSWhile cruising at 17,000 ft, the 1st officer's rgt window panel failed & blew outward. A cabin decompression occurred & the copilot was seriously injured. The captain immediately descended to 10,000 ft & continued to their destination where an otherwise…Sep 1, 1988 · N257AM · Minor damageNTSB LAX88LA304Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Barrett Junct., CAWhile descending into a canyon, the aircraft struck powerlines, went into an uncontrolled descent and collided with the terrain. The pilot stated that he could not see the powerlines and that his visibility was restricted by the sun. All four passengers…Aug 31, 1988 · N74WH · Substantial damageNTSB ATL88IA241Incident · Minor injuriesIncident investigationFinal reportBoeing 737-387 · Savannah, GAWhile cruising at FL 310, usair flight 333 encountered severe turbulence. The pilot reported observing the thunderstorm activity on the airborne radar. The flight was within 20 miles of the cell before action was taken to avoid the encounter. The recommended…Aug 30, 1988 · N353AU · No damageNTSB NYC88FA229Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Pomfret, CTThe Piper arrow PA-28R-201, had asked ATC for vectors to windam airport. After being vectored the pilot requested his distance from the airport. He was told that he was 12 miles from the airport, the pilot then decided to descend. ATC advised the pilot to…Aug 28, 1988 · N3478M · DestroyedNTSB LAX88LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Lower Lake, CAThe pilot departed NOVAT0, CA with the fuel selector in the right tip tank position. She did not switch the selector to the main tank position. Four miles from Lower Lake, CA the engine lost all power. After the accident, only the right tip tank was found…Aug 28, 1988 · N9429W · Substantial damageNTSB ATL88LA240Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Fairhope, ALThe plt rprtd the eng lost pwr 'without warning' as he & his pax were flying over water near the shore at aprx 500'. He performed emerg procedures & regained partial pwr, but not enough to cont flt. He maneuvered toward the shore, then elected to ditch the…Aug 28, 1988 · N9392L · Substantial damageNTSB DEN88FA193Accident · 2 fatalField investigationFinal reportMooney M20F · Jackson Hole, WYThe pvt plt obtained his instrument rating 14 days prior to the accident. 12 hrs of actual instrument flt time was logged in March of 1987. The remaining instrument flt time was simulated. Visibility in the Jackson Hole area was reduced by smoke. The plt…Aug 27, 1988 · N9528M · DestroyedNTSB CHI88LA220Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Gary, INFailure of the powerplant due to an oil leak and subsequent forced landing into unsuitable terrain.Aug 27, 1988 · N5140S · DestroyedNTSB ATL88FA239Accident · Serious injuriesField investigationFinal reportBoeing 767 · Charleston, SCAug 27, 1988 · N120DL · No damageNTSB LAX88LA303Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227-AC · Sacramento, CAMechanics failure to properly secure the right engine cowling after maintenance.Aug 26, 1988 · N2683B · Substantial damageNTSB FTW88LA155Accident · No injuriesLimited investigationFinal reportHelio H-250 · Tyler, TXDuring flight, the engine stopped developing power. The fuel was feeding from the main tanks and the pilot attempted to transfer some fuel from the auxiliary tanks to the mains but was not able to get a restart. During the forced landing, the airplane…Aug 26, 1988 · N444FF · DestroyedNTSB SEA88LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Cascade Locks, ORThe student pilot reported that during cruise while on a solo cross country training flight the engine began to surge. He called ATC and was directed to the nearest available airport. The student pilot landed long and fast and departed theend of the runway.…Aug 25, 1988 · N94649 · Substantial damageNTSB BFO88LA075Accident · No injuriesLimited investigationFinal reportCessna 172N · Port Royal, VAThe pilot departed fredericksburg, VA, for a power line patrol flight in Port Royal, VA. After intersecting the power lines at the substation, the patrol was initiated flying 10 ft above and 20 ft to the left of the lines. The plt stated he was looking…Aug 25, 1988 · N213JA · Substantial damageNTSB ATL88IA238Incident · No injuriesIncident investigationFinal reportBell 47G · N Myrtle Beach, SCAug 25, 1988 · N902Z · Minor damageNTSB ANC88LA117Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Rainy Pass, AKThe plt attempted to fly thru Rainy Pass, AK, but said he flew up the wrong valley. As he contd, the acft got into a situation where the plt was unable to turn around or outclimb rising terrain. Subsequently, the acft crash landed on the mountain side at an…Aug 25, 1988 · N95165 · Substantial damageNTSB LAX88FA297Accident · 1 fatalField investigationFinal reportMooney M20J · Inyokern, CAPilots inflight loss of control after encountering a level four thunderstorm on a night VFR cross country. Contributing to the accident was the pilot's failure to obtain a preflight weather briefing.Aug 24, 1988 · N5769Y · DestroyedNTSB FTW88FA151Accident · 2 fatalField investigationFinal reportCessna 152 · Bushland, TXThere were no witnesses to this accident. The airplane impacted the terrain at high speed, in a near wings level, 75 degree nose down attitude. No preimpact problems were found with the airplane or powerplant. Airplane was over weight and had an aft CG at…Aug 24, 1988 · N5351M · DestroyedNTSB SEA88LA161Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Shelton, WAThe pilot reported a complete loss of power in cruise flight while ferrying an aircraft to its home base after an annual inspection. The pilot landed in a small field of rye crop. The pilot stated that the size of the field precluded a normal approach. The…Aug 23, 1988 · N8370H · Substantial damageNTSB LAX88IA311Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · San Francisco, CADuring cruise flight, approximately one hour after departure, the captain complained of possible indigestion. A few hours later, the captain complained of tingling in his fingers and numbness in his shoulder. Another captain was on board and was asked to sit…Aug 23, 1988 · N1738D · No damageNTSB ATL88LA236Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bamberg, SCWhile at cruise, the pilot reported hearing a ticking sound coming from the engine. Shortly afterward the eng quit. During the emergency landing, the airplane nosed over. Engine examination disclosed that teeth from the crankshaft and camshaft gears were…Aug 23, 1988 · N5797B · Substantial damageNTSB LAX88FA294Accident · Serious injuriesField investigationFinal reportBeech A36TC · Paradise, CAAn undetermined loss of engine power and the pilot in command's apprehension in undertaking the appropriate emergency actions to attempt an aerial restart. Contributing to this accident was the pilot's lack of experience and inadequate training.Aug 22, 1988 · N1830R · DestroyedNTSB ATL88LA234Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Ridgeland, SCThe pilot experienced a complete power loss about four hours after departing pompano beach. The pilot had varied his altitude throughout the flight. The flight manual indicates that the acft could fly about 3.8 hours, at 2500 feet altitude, on 48 gallons of…Aug 22, 1988 · N30335 · Substantial damageNTSB NYC88LA224Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Wall Township, NJIncapacitation of the pilot due to a heart attack and an emergency landing in trees by a non-pilot passenger.Aug 21, 1988 · N5474W · Substantial damageNTSB LAX88LA293Accident · Minor injuriesLimited investigationFinal reportAeronca 0-58B · Grass Valley, CAWhile enroute, the engine sputtered then quit. The pilot initiated a forced landing to a plateau directly below. While on final approach the airplane flew through a downdraft. The pilot was unable to land the airplane on the plateau, instead it collided with…Aug 21, 1988 · N56740 · Substantial damageNTSB FTW88DPJ10Accident · No injuriesFinal reportCessna A188B · Holdenville, OKThe aircraft was in cruise flight at 500 ft AGL when a total loss of power occurred. The pilot jettisoned the load and executed an emergency descent to land at the nearest available clearing. The aircraft collided with the terrain with high rate of descent…Aug 21, 1988 · N731CT · DestroyedNTSB CHI88LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Elkhart, INWhile enroute on the second leg of a solo student cross country, the aircraft experienced a total loss of engine power due to fuel exhaustion. The student pilot executed a forced landing in a bean field and the aircraft nosed over during the landing roll,…Aug 21, 1988 · N9234U · Substantial damageNTSB CHI88FA214Accident · 3 fatalField investigationFinal reportHughes 269B · Hampton, ILAug 21, 1988 · N9499F · DestroyedNTSB CHI88DER09Accident · Serious injuriesFinal reportSmith Miniplane · Superior, WIWhile in normal cruise the aircraft experienced a total loss of engine power. The pilot executed an emergency descent to a forced landing. The aircraft encountered unsuitable terrain which resulted in a hard landing and substantial damage to the aircraft. The…Aug 21, 1988 · N39F · Substantial damageNTSB ATL88FA233Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Pittsboro, NCThe plt had an instrument plt accompany him on the flight to myrtle beach in the event the wx required IFR for the return flt. When they arrived at myrtle beach, the plt decided that they would remain overnight. After visiting some night spots and doing some…Aug 21, 1988 · N4169W · DestroyedNTSB SEA88LA158Accident · No injuriesLimited investigationFinal reportCessna 185 · Hillsboro, ORThe pilot reported that the engine lost power during a fuel tank switchover. The aircraft collided with a telephone pole guy wire on the road during the forced landing. The investigation revealed a fuel leak induced when the fuel boost pump was in operation.…Aug 20, 1988 · N14407 · Substantial damageNTSB MKC88LA161Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARWhile en route to engage in an aerial application operation, the plt said the engine began to misfire and cut out. Unable to correct the malfunction, the plt dumped his chemical load and began returning to the departure airstrip. En route, he felt he would…Aug 20, 1988 · N6567 · Substantial damageNTSB FTW88LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Ada, OKAfter a loss of engine power, the airplane landed in a soft, plowed field, 50 feet short of a runway at the destination airport. After touchdown, it nosed over to the inverted position. According to the operator, the pilot said he might have run out of fuel.…Aug 20, 1988 · N89271 · Substantial damageNTSB ATL88LA232Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Paducah, KYAfter departure the eng quit & PIC made an autorotative landing in a wooded area. Initial exam of eng revealed water in the carb float bowl. Investigation showed helo had 100 hr inspection recorded in the log, but may have been returned to service by mechanic…Aug 20, 1988 · N4828E · Substantial damageNTSB NYC88LA222Accident · No injuriesLimited investigationFinal reportCessna 152 II · Coatesville, PAThe student plt was returning to the airport following a 1 hr local flight. He stated that the engine sputtered and lost power. The plt selected a field for a forced landing and approached it from west to east. The plane struck a road short of the field and…Aug 19, 1988 · N49142 · Substantial damageNTSB MIA88LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300E · San Juan, PRWhile on a business flt shortly after departure while climbing to cruise, the plt reported that the eng quit. The acft was ditched & has not been recovered therefore no determination could be made as to the reason for the reported loss of eng power. The plt…Aug 19, 1988 · N8671N · Substantial damageNTSB MIA88FA260Accident · 6 fatalField investigationFinal reportPartenavia P-68C · Duncan Town, BahamasThe acft crashed in the ocean nr Duncan Town, Bahamas. The wx according to witnesses was VMC. The flt had been airborne enroute from nassau for about 1 hr and 20 minutes. Witnesses on a nearby boat said the acft was flying in a slight left bank when the left…Aug 19, 1988 · N39272 · DestroyedNTSB MIA88FA257Accident · Serious injuriesField investigationFinal reportHughes 500 · Riviera Beach, FLThe traffic watch helicopter was cruising northbound along the interstate at 450 ft AGL & 85 KTS airspeed. A grinding noise was heard & the tail rotor separated from the acft. The acft began an uncommanded right turn which was arrested in about 1/4 turn. The…Aug 19, 1988 · N3766Z · Substantial damage