OpenAirDocs.org

NTSB investigations

35,889 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 MKC82DA173Accident · Minor injuriesFinal reportCessna U206F · Baton Rouge, LAThe pilot changed the fuel selector from right to left while descending through 2200 ft MSL. The engine failed immediately after the fuel selector was moved. Repeated attempts to restart the engine by changing fuel selector position was unsuccessful. The…Sep 20, 1982 · N9530G · Substantial damageNTSB MIA82FLD20Accident · Serious injuriesFinal reportCessna 152 · Ft. Myers, FLThe aircraft crashed after the engine lost power. The pilot stated he did not visually check the fuel on the day of the flight. The aircraft was checked after the accident and it contained a negligible amount of fuel. The wings and fuel tanks were not damaged…Sep 20, 1982 · N49863 · DestroyedNTSB ATL82DA280Accident · No injuriesFinal reportGrumman G-164 · Greenville, KYAccording to the caretaker of muhlenburg airport, N143W was having carburetor problems when it arrived to refuel prior to the accident flight. The caretaker stated that the pilot left the engine running while he refueled because the pilot said it wouldn't…Sep 20, 1982 · N143W · DestroyedNTSB LAX82FA346Accident · 4 fatalField investigationFinal reportCessna 182P · Beldon, CAPortions of the acft's right wing were located north of highway 70 in remote rugged mountainous terrain near belden, CA.the remainder of the wreckage was located about 2 mi south of the highway on the east side of fern creek canyon at an elevation of about…Sep 18, 1982 · N20726 · DestroyedNTSB CHI82DA356Accident · Minor injuriesFinal reportCessna 172M · Brimfield, ILThe pilot reported that about 30 minutes after takeoff, a partial loss of power was experienced and was accompanied by the sounds of metal-to-metal contact. He headed toward an airport about 12 miles away, but shortly thereafter, total engine failure…Sep 18, 1982 · N9871Q · Substantial damageNTSB SEA82DA166Accident · No injuriesFinal reportBeech C23 · Yakima, WAThe aircraft was on the last leg of a flight from California to Yakima, Washington. It had not been refueled during a stop at goldendale, Washington. While descending toward Yakima, the pilot reported to the tower that he was out of fuel. During a forced…Sep 17, 1982 · N9218S · Substantial damageNTSB LAX82FA345Accident · 2 fatalField investigationFinal reportBeech 200 · Huntington Beac, CAN9FQ, a Beech 200, had taken off from rwy 19R at john wayne arpt at santa ana, departed the traffic pattern on a right crosswind leg, & proceeded nw toward burbank. N732BP, a C-210L, was on a local training flt out of santa ana & had just completed practice…Sep 17, 1982 · N9FQ · 2 aircraft · Substantial damageNTSB LAX82DUJ47Accident · No injuriesFinal reportCessna 150 · Carrizo, AZThe student pilot was on his "long" cross-country flight. He reported that the first leg of the flight was from libby air field, AZ to silver city, NM with an en route time of about 1.3 hrs. On the next leg of the flight to globe, AZ, he became disoriented…Sep 17, 1982 · N45540 · Substantial damageNTSB FTW82FA382Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Paris, TXThe PA-24 had departed rwy 17 at cox field & was climbing at the time of the collision. The plt had reported his intended departure on UNICOM. The AA5B had reported 5 mi sw of the arpt descending through 5,000 ft. for landing. The head-on collision occurred…Sep 16, 1982 · N300AH · 2 aircraft · DestroyedNTSB ATL82DA275Accident · Minor injuriesFinal reportCessna 172F · Millry, ALThe pilot experienced a partial loss of power during a ferry flight and was forced to make an emergency landing in a field. He stated that he noted 4 vibrations followed by a missing in the engine. The RPM dropped to 1200 and he could not maintain altitude.…Sep 15, 1982 · N8423U · Substantial damageNTSB LAX82FA344Accident · Serious injuriesField investigationFinal reportCessna 402 · Grand Canyon, AZThis was the 3rd flt of the day. The plt completed a service order for 32 gals of fuel & laid it on top of a bench located just inside open hangar doors. The acft was not refueled & the order was later found on the hangar floor away from the bench. While over…Sep 14, 1982 · N59SA · Substantial damageNTSB DEN82DA190Accident · Minor injuriesFinal reportCessna 310P · Wendover, UTThe pilot stated he became disoriented while flying from salt lake city to Wendover. He descended to 8000 ft to keep clear of ice and hail and could not receive a navigational signal from the Wendover or bonneville navigational facility. While attempting to…Sep 13, 1982 · N5836M · Substantial damageNTSB ATL82DA273Accident · No injuriesFinal reportPiper PA-25 · Red Level, ALWhile returning to the airport after spraying crops, the pilot noted a change in the engine sound and noticed a loss of oil pressure. Anticipating an imminent engine failure, the pilot landed on a portion of an old highway that was clear of motor vehicles.…Sep 13, 1982 · N9728P · Substantial damageNTSB ATL82DA272Accident · No injuriesFinal reportCessna 172RG · Prospect, KYThe plt was returning to his departure point due to encountering rough wx. While descending to 4,000 ft for an ILS approach the plt experienced a total electrical failure. The plt elected to descend to VFR conditions & broke out about 100 ft AGL. The plt…Sep 13, 1982 · N5115U · Substantial damageNTSB FTW82DA377Accident · No injuriesFinal reportCessna P210N · Gage, NMWhile on a VFR cross-country flight from tucson, AZ to roswell, NM, the engine failed and the pilot made an emergency landing in the desert. The engine teardown revealed that the oil passage which feeds the number 2 and 3 main bearing journals had not been…Sep 12, 1982 · N5237W · Substantial damageNTSB ATL82FA267Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Itta Bena, MSAt 2329 while enroute the plt was advised of wx conditions along his route. He was advised of previous low VFR conditions in the greenwood area. The fss specialist stated that there had been "low conditions right around greenwood for about a hour and a half…Sep 11, 1982 · N3833T · DestroyedNTSB ATL82DA268Accident · No injuriesFinal reportCessna 188 · Nashville, GAThe engine failed while the acft was enroute to spray a soybean crop. Deposits of dirt & sediment were found in the fuel control assembly body screen.Sep 11, 1982 · N9184R · Substantial damageNTSB LAX82FVG33Accident · 1 fatalFinal reportSchweizer 232 · Calistoga, CAThe acft crashed approximately 3 mi sw of the Calistoga arpt while returning from a local flt. The plt stated to a calif hwy patrol officer at the scene that he lost rudder control & had gone into a spin as a result in air change. The rudder cables were found…Sep 10, 1982 · N2450W · DestroyedNTSB ATL82FA278Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Alma, GADuring his wx briefing at 0731 the plt was advised that VFR flt was not recommended. The acft crashed in a cornfield after an inflight separation of the stabilators & wings. Local residents recalled that the rain showers were rather heavy at times on the day…Sep 10, 1982 · N39685 · DestroyedNTSB MIA82DA179Accident · Minor injuriesFinal reportCessna T210N · Near St. Peters, FLThe pilot reported that the flight was uneventful until it was about 5 miles northwest of st petersburg, FL. At about that point, the pilot contacted the tower for landing and advised that the plane was low on fuel. Shortly thereafter, the engine lost power.…Sep 9, 1982 · N9421Y · DestroyedNTSB DEN82DA199Accident · No injuriesFinal reportCessna 175 · Hulett, WYThe pilot reported that during flight the engine began to run rough. He diverted toward a nearby airstrip, but while en route, there was a "bang" and smoke began entering the cabin. At that point, he shut off the fuel, magnetos and master switch, then lost…Sep 9, 1982 · N9410B · Substantial damageNTSB CHI82DA349Accident · No injuriesFinal reportBensen BM8 · Zilwauker, MIDuring flight at about 1500 ft AGL, the aircraft engine lost power. The pilot made a steep approach to land in a small field surrounded by power lines. He stated that during an extreme flare to stop the forward flight, the main rotor blades hit the ground and…Sep 9, 1982 · N9463A · DestroyedNTSB CHI82DA348Accident · No injuriesFinal reportCessna 172M · Cheboygan, MIThe flight was being conducted over the waters of lake huron when engine stoppage occurred. Unable to glide to the airport the pilot ditched the aircraft on the shoreline in the water. The post-accident investigation revealed that the foam rubber from the air…Sep 9, 1982 · N2AZ · Substantial damageNTSB NYC82DA219Accident · No injuriesFinal reportBeech 35 · Topsham, VTEngine quit and pilot made forced landing in open field. Fuel selector was found on right tank which was empty. Left tank was full. Fuel lines were dry.Sep 8, 1982 · N4454S · Substantial damageNTSB MKC82IA169Incident · No injuriesIncident investigationFinal reportCessna 421C · St. Louis, MOPilot reported, the flight encountered icing conditions near St. Louis and the propeller de-ice system was activated. When de-ice system was turned on, flames shot out from the lower right corner of the pilot's instument panel where the de-ice ammeter is…Sep 7, 1982 · N6868D · Minor damageNTSB MKC82FCD10Accident · 2 fatalFinal reportPiper 28-236 · Liscomb, IAN2157A departed on a VFR flight to marshalltown, IA. There is no record of a pilot weather briefing prior to departure. The reported weather at waterloo airport at the approximate time of the accident was: measured ceiling 600 foot overcast, visibility one…Sep 7, 1982 · N2157A · Substantial damageNTSB SEA82AA155Accident · 2 fatalFinal reportPiper PA-32-300 · 23 Mi Ene Toutl, WAWhile on a sightseeing flt in the Mt. St.helens national volcanic monument area the acft crashed on the mud flats of the north fork of the toutle river in a relatively flat & open area. There were indications of a massive oil leak from the eng area in flight.…Sep 6, 1982 · N48915 · DestroyedNTSB MKC82FCQ14Accident · 2 fatalFinal reportCessna TRI82 · Bunker Hill, KSThe non-instrument rated pilot departed great bend, KS sometime after 2000 CDT on 9/6/83 on a flight to lucas, KS. On 9/9/83, the aircraft was found where it had crashed between great bend and lucas. No preimpact, mechanical failures were evident. The 2256…Sep 6, 1982 · N756KD · DestroyedNTSB FTW82DA367Accident · No injuriesFinal reportCessna 172M · Houston, TXAfter making a cruise descent from 1800 to 1500 ft AGL, the pilot adjusted his throttle to maintain his airspeed and altitude. However, there was no response. The throttle could be pushed in and pulled out with no increase in power. A crosswind landing was…Sep 6, 1982 · N73562 · Substantial damageNTSB CHI82DA341Accident · No injuriesFinal reportAero Commander 681 · Pontiac, MIDuring cruise flight the pilot observed the hydraulic system pressure fluctuating. The pilot immediately went into a hold pattern and attempted to ascertain the problem. After repeated attempts the pilot was able to lower the nose gear and the right main…Sep 6, 1982 · N10TN · Substantial damageNTSB MKC82DA165Accident · No injuriesFinal reportCessna 172M · Warrensburg, MOThe pilot was on a flight from tulsa, ok to gravois mills, MO. At gravois mills, he made two approaches to the wulff harbor airport, but it was dark and he was not familiar with the airfield. So he diverted to Kansas city, MO. While en route to Kansas city,…Sep 5, 1982 · N13592 · Substantial damageNTSB ANC82DAG53Accident · 2 fatalFinal reportPiper PA-20 · Kenai, AKAt 0837 the plt called Kenai tower & reported 8 mi west inbound for landing. At 0845 he reported that he would be landing on the beach. At 0847 he reported that he would not make the beach & would be going into the water. The acft & occupants were not…Sep 5, 1982 · N6957K · DestroyedNTSB ANC82DA083Accident · No injuriesFinal reportCessna 207A · Near Kipnuk, AKThe pilot reported that the aircraft lost oil pressure while he was in normal cruise. Shortly thereafter, the engine began running rough. The engine failed completely while he was on an approach for a forced landing. Shortly after touching down on uneven,…Sep 5, 1982 · N76078 · Substantial damageNTSB FTW82DA364Accident · No injuriesFinal reportCessna 182A · Farmington, NMThe aircraft collided with trees during a forced landing off airport. The pilot declared an emergency after the engine stopped. He was able to restart the engine once. It ran for about 2 minutes and stopped again. Examination of the aircraft revealed the fuel…Sep 4, 1982 · N6088B · Substantial damageNTSB DEN82FA182Accident · 1 fatalField investigationFinal reportBell 206B · Billings, MTThe acft departed laramie at approximately 1600 with a full load of fuel. At 1840 the plt contacted Billings tower & stated he had a low fuel warning light. Several minutes later he radioed that he was going down. A witness observed the acft coming down "real…Sep 4, 1982 · N49593 · DestroyedNTSB DEN82DA184Accident · Minor injuriesFinal reportCessna 177 · Castlerock, CODuring a flight to englewood, CO, the aircraft's engine stopped running and the pilot made a forced landing on the northbound lane of interstate 25 at castle rock. Investigation revealed there was no fuel in the aircraft's fuel tanks.Sep 4, 1982 · N3286T · Substantial damageNTSB CHI82DA343Accident · No injuriesFinal reportCessna 310A · Wheeling, ILThe pilot could not get the gear down green light to come on. Several checks made including a fly-by and a advisory that the gear appeared down. During the landing roll the right gear collapsed. Examination of the landing gear system revealed a bent righthand…Sep 4, 1982 · N301DG · Substantial damageNTSB ATL82FA263Accident · 3 fatalField investigationFinal reportCessna 170A · Brunswick, GAThe non-instrument rated pilot was on a flight from ironton, oh to daytona beach, FL with an en route stop at columbia, SC. He obtained a weather briefing prior to departing ironton, but did not update it after landing at columbia. The aircraft crashed on the…Sep 4, 1982 · N9263A · DestroyedNTSB DCA82IA031Incident · Serious injuriesIncident investigationFinal reportBoeing 727 · Washington, DCThe announcement of the possibility of turbulence during the descent and approach was made. During the lulls in the turbulence the cabin attendants were attending their duties and were hurt when intermittent jolts of rough air were encountered while two of…Sep 3, 1982 · N288WA · No damageNTSB ATL82DA264Accident · No injuriesFinal reportPiper PA-28R · Sewanee, TNEnroute the oil pressure dropped to zero & shortly thereafter the prop seized due to oil starvation. Post exam revealed a crack in the prop governor oil line, P/N76157, at the bend about 1 inch away from the "b" nut attaching the line to the elbow fitting at…Sep 3, 1982 · N4976S · Substantial damageNTSB SEA82DA153Accident · Minor injuriesFinal reportAmerican AA-1A · Paulsbo, WAAfter demonstrating a practice forced landing approach, a climb was started. Short thereafter, the engine lost power and an actual forced landing was made in a wooded area. The aircraft was damaged beyond economical repair when it struck trees during the…Sep 2, 1982 · N9410L · DestroyedNTSB ATL82FA261Accident · 1 fatalField investigationFinal reportCessna 170B · Lawrenceville, GADuring the return flt to stone mountain arpt, the plt contacted approach control & requested vectors to the gwinnett county arpt at Lawrenceville, GA. The plt reported that he had been going around thunderstorms & it was turning dark. Several minutes later…Sep 2, 1982 · N3247A · DestroyedNTSB MKC82DA163Accident · No injuriesFinal reportCessna 140 · Eldora, IAThe oil pressure dropped to zero & the plt shut down the engine, & the acft landed in a bean field. All of the oil had blown out of the oil filler opening via a loose fitting oil filter cap. The plt stated he had changed the oil prior to flt.Sep 1, 1982 · N72470 · Substantial damageNTSB ATL82DA258Accident · Minor injuriesFinal reportHughes 269C · Louisville, KYThe pilot received a weather briefing before taking off on an aerial traffic patrol for a local radio station. He was issued a special VFR clearance to follow a pre-established route. However, after departing, he encountered thunderstorm activity. He returned…Sep 1, 1982 · N8982F · Substantial damageNTSB ANC82FA081Accident · No injuriesField investigationFinal reportde Havilland DHC-3 · Near Skwentna, AKThe acft experienced a power loss & a forced landing was made on a sandbar. During the landing roll the acft struck a log, folding the main gear. Eng teardown revealed a failed no.4 articulating rod. The rod separated just above the knuckle pin area.Sep 1, 1982 · N41755 · Substantial damageNTSB MIA82DA176Accident · No injuriesFinal reportBoeing A75N1 · Madison, FLWhile returning to the airport, the engine lost power. The pilot landed long in a pasture to avoid cows, and then was unable to stop before hitting a fence. The pilot reported that the mixture linkage became disconnected. After the accident, the linkage was…Aug 31, 1982 · N59998 · Substantial damageNTSB MKC82FA161Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Mediapolis, IADuring the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.…Aug 30, 1982 · N56373 · DestroyedNTSB ATL82FLG14Accident · Serious injuriesFinal reportCessna 182B · Charleston, SCThe flight departed conway, Arkansas for a non-stop flt to Charleston. Approximately 4 to 5 miles from the airport at Charleston, with the runway in sight, the engine quit. The acft struck trees drg a forced landing on a power line right-of-way 2 miles short…Aug 29, 1982 · N99CB · DestroyedNTSB ATL82FA251Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · State Road, NCThe plt reported his engine had quit. ARTCC advised the plt that the nearest arpt was elking at 12 mi. Several minutes later he reported that he didn't think he could make the arpt & was going to look for a field. Witnesses observed the landing gear down…Aug 29, 1982 · N38231 · DestroyedNTSB MKC82DA159Accident · No injuriesFinal reportBell 47G-2 · Palo, IAThe pilot reported that during flight at about 300 ft AGL, the engine sputtered and lost power. He entered an autorotation, turned into the wind, and landed in a bean field. As the aircraft descended into the beans, the spray boom became entangled in the…Aug 27, 1982 · N12412 · Substantial damage