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 NYC82FFJ15Accident · Serious injuriesFinal reportNa 64 · Cambria, NYThe pilot reported that after he made a photo fly-by, he began to climb. At about 400 ft AGL, the engine failed and he began a forced landing. During the approach, the tail wheel caught on two electrical wires and the aircraft pancaked onto a paved road, then…Jun 13, 1982 · N64BT · DestroyedNTSB LAX82FA219Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Yorba Linda, CAWitnesses observed the acft flying low over the riverside freeway with a high RPM eng sound & in a right turn. The acft continued to roll & turn to the right & crashed.Jun 13, 1982 · N8311Z · DestroyedNTSB ATL82DA162Accident · Serious injuriesFinal reportPiper PA-28-181 · Savannah, GAThe pilot obtained a weather briefing and filed a VFR flight plan before takeoff. He was advised that the weather was 6000 ft scattered, 6 miles visibility, possible storms gathering at palatka, FL. After takeoff, he was unable to contact the flight service…Jun 13, 1982 · N80SA · DestroyedNTSB ANC82DA046Accident · Minor injuriesFinal reportCessna 180 · Seldovia, AKDuring flight, the pilot noted that oil began to collect on the windscreen. He continued the flight to the destination and landed on runway 16 with an oil covered windscreen and in what he described as "squirrelly winds." The wind was estimated to be from 150…Jun 13, 1982 · N2949C · Substantial damageNTSB NYC82DA123Accident · Minor injuriesFinal reportCessna 172N · Schellsburg, PADuring a cross-country flight the pilot encountered lowering ceilings and rain. The pilot descended to 2200 feet; however, the weather continued to deteriorate and the pilot elected to climb. The aircraft collided with trees and was destroyed.Jun 12, 1982 · N5017E · DestroyedNTSB LAX82DA217Accident · Serious injuriesFinal reportLuscombe 8A · Delano, CAThe pilot and his daughter were on a cross-country flight when the engine lost power. During a forced landing approach to a highway, the pilot noticed some powerlines which he went under. He avoided the powerlines, but hit a truck. The crash site was located…Jun 12, 1982 · N2013B · DestroyedNTSB NYC82DA122Accident · No injuriesFinal reportCessna 172 · Monongahela, PAThe pilot was on a flight from rostraver, PA to deerfield, oh and return. Before taking off from rostraver, he estimated there was 25 gal of fuel on board. At deerfield, he estimated there was 15 gallons remaining (12 gal usable). But that he would need only…Jun 11, 1982 · N608DL · Substantial damageNTSB FTW82DA221Accident · No injuriesFinal reportCessna 206-5 · Somerville, TXDuring a cross country flight the pilot switched fuel tanks and the engine quit. The pilot switched back to original setting but could not restart the engine. During the forced landing the aircraft collided with a steel fence. Maintenance personnel stated the…Jun 11, 1982 · N40416 · DestroyedNTSB ANC82FAG30Accident · 2 fatalFinal reportPiper PA-18 · Near Dillingham, AKThe acft impacted a side of a mountain Near horseshoe pass at an elevation of 250 ft above sea level. The accident occurred during the hours of daylight with VMC prevailing.Jun 8, 1982 · N278T · DestroyedNTSB SEA82FYM18Accident · 2 fatalFinal reportMccall KR-2 · Union, ORReportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it…Jun 6, 1982 · N54622 · DestroyedNTSB CHI82FA211Accident · No injuriesField investigationFinal reportPiper PA-30 · Vandalia, OHDuring descent at 215 mph the acft entered violent buffeting. Recovery was initiated by reducing power & the acft landed without any further incident. Examination revealed the horizontal stabilator was permanently bent downward on both sides. The acft was…Jun 6, 1982 · N7254Y · Substantial damageNTSB FTW82DA212Accident · Minor injuriesFinal reportCessna 210L · Wichita Falls, TXAfter climbing to 2500 ft the engine suddenly lost power and quit. The pilot lowered the landing gear and shut down all switches but did not extend the flaps. During the ensuing emergency landing the aircraft nosed over in a wheat field. Engine examination…Jun 5, 1982 · N5280V · Substantial damageNTSB CHI82DA199Accident · Serious injuriesFinal reportEnstrom 280 · Rayland, OHAbout three minutes after takeoff, the engine lost power and the helicopter crashed in a wooded area. No preimpact failures of the aircraft or engine were found.Jun 5, 1982 · N239Q · DestroyedNTSB LAX82FA208Accident · 3 fatalField investigationFinal reportCessna T210N · Humphreys Peak, AZTe acft impacted Humphreys Peak at 10,200 ft MSL. The last wx observation at grand canyon was at 1745. The reported wwx was a clear sky & 50 mi visibility.Jun 4, 1982 · N4777Y · DestroyedNTSB ATL82DA152Accident · Minor injuriesFinal reportCessna 150 · Red Oak, VAThe pilot reported that he was on a local flight when the weather began to deteriorate. He decided to make a precautionary landing in a large bean field. While on a landing approach, the aircraft struck a utility line, wrapping the wire around the propeller…Jun 4, 1982 · N9373U · Substantial damageNTSB NYC82FFA06Accident · No injuriesFinal reportCessna A188B · White Lake, NYWhile returning from a spraying operation, the engine began running rough, and within seconds, it lost power. The pilot was unable to restart the engine, and subsequently, ditched the aircraft in a reservior. An engine teardown revealed that the crankshaft…Jun 3, 1982 · N731BG · Substantial damageNTSB MIA82DA131Accident · No injuriesFinal reportCessna 182K · Arecibo, PRThe pilot stated that he had 8 gallons of fuel on board before takeoff. At 0700, he departed on a flight from san juan to aguadilla, PR with an intermediate stop at Arecibo, PR for refueling. At about 0725, the aircraft ran out of fuel, about 3 miles from…Jun 3, 1982 · N2575Q · Substantial damageNTSB FTW82DA211Accident · No injuriesFinal reportBeech D18S · Beeville, TXThe pilot and three passengers departed on a pleasure flight. The pilot stated that after climbing several hundred feet and while at 110 mph, the right propeller went into high pitch following a propeller governor failure. This resulted in a loss of engine…Jun 3, 1982 · N7510 · Substantial damageNTSB ATL82IA159Incident · No injuriesIncident investigationFinal reportPiper PA-31-325 · Asheboro, NCDuring cruise at 5000 ft the pilot smelled electrical fumes and noticed smoke filling the flap indicator gauge. He pulled the wing flap circuit breaker but moments later volumes of smoke arose from under the instrument panel, with flames observed behind the…Jun 2, 1982 · N59749 · Minor damageNTSB FTW82DA207Accident · No injuriesFinal reportCessna 152 · Clarksville, ARThe pilot reported that after landing at ozark, AR, no fuel was available. Therefore, he proceeded to obtain fuel at Clarksville, AR, a distance of about 15 miles. After takeoff, he encountered moderate turbulence, leveled at about 600 ft, and reduced power…Jun 1, 1982 · N67650 · Substantial damageNTSB CHI82DA198Accident · Minor injuriesFinal reportBell 47G-5A · New Philadelphi, OHWhile patrolling a powerline, the pilot heard a loud noise, similar to a gunshot, which seemed to come from directly behind the firewall. Immediately after that, the helicopter started to pitch up and roll to the right. He reported that the helicopter reached…Jun 1, 1982 · N2988W · DestroyedNTSB FTW82FA204Accident · 2 fatalField investigationFinal reportBell 206B · Fairfield, TXWitnesses observed the helicopter flying northbound while traveling parallel and just east of a north-south highway. Reportedly, it enter an autorotative landing approach, crossed over the highway and impacted in an open field on a westerly heading after…May 31, 1982 · N1482W · DestroyedNTSB ANC82DAG29Accident · Serious injuriesFinal reportStinson 181 · Talkeetna, AKThe pilot made a forced landing after a spark plug blew out of the engine. During the landing the aircraft collided with a tree.May 31, 1982 · N108TM · Substantial damageNTSB ATL82DA148Accident · No injuriesFinal reportPiper PA-22-150 · Williamston, NCThe pilot stated that while cruising at 11,000 ft the engine started missing and losing power. After repeated attempts to restore power the pilot landed in a field. During roll out the nose wheel became lodged in soft sand and the aircraft turned over. Engine…May 30, 1982 · N1615P · DestroyedNTSB NYC82FA110Accident · Serious injuriesField investigationFinal reportDouglas DC8-52 · Atlantic Ocean (Atlantic Ocean)The flt had been airborne about 25 min with the seat belt sign on because of the possibility of turbulence. Two flight attendants were preparing the beverage cart when turbulence was encountered. The acft suddenly dropped downward causing the two attendants…May 29, 1982 · N801EV · No damageNTSB LAX82FA202Accident · No injuriesField investigationFinal reportKaman K600-3 · Lodi, CAThe helicopter started vibrating in flight, and when the pilot was unable to control the aircraft for a normal approach to the airport, he elected to land in a cornfield. The aircraft rolled to the right at touchdown. The right blade flap assembly had…May 29, 1982 · N87842 · DestroyedNTSB ATL82DA150Accident · No injuriesFinal reportBell 47D1 · Blountville, TNThe aircraft lost power at 100 feet above ground level. An autorotation was attempted to a highway. The hard landing resulted in the main rotor severing the tail.May 29, 1982 · N10065 · Substantial damageNTSB ATL82DA146Accident · No injuriesFinal reportPiper PA-38 · Pell City, ALThe aircraft was being used to return with another pilot after the other pilot had ferried his aircraft from bessember, AL to knoxville,TN. The pilot estimated that he had sufficient fuel to return, and since the FBO was busy, he elected to depart without…May 29, 1982 · N9956T · Substantial damageNTSB LAX82DA198Accident · No injuriesFinal reportPiper PA-24-250 · Apple Valley, CADuring a flight from saint george, ut to imperial, GA, the pilot encountered fog as he approached el cajon pass, south of Apple Valley, CA. He attempted to go under the fog but was unable. He reversed course and headed back toward Apple Valley. As he was…May 28, 1982 · N6503P · Substantial damageNTSB FTW82IA209Incident · No injuriesIncident investigationFinal reportPiper PA-31P-135 · Lake Charles, LAWhile cruising at FL200 in VMC conditions, the pilot smelled and then observed smoke coming from the windshield defrosters and under the instrument panel. He advised houston center of his situation, then turned off all electrical equipment and made an…May 28, 1982 · N222SA · Minor damageNTSB CHI82DA189Accident · No injuriesFinal reportCessna 172 · Evansville, INThe pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to…May 28, 1982 · N2986U · 2 aircraft · Substantial damageNTSB FTW82DA194Accident · No injuriesFinal reportPiper PA-28-236 · Clayton, NMThe pilot reported that during flight, the engine lost power. He tried to land on a nearby airport. However, unexpectedly strong winds were encountered and he made a forced landing in a pastured when he saw he could not reach the airport. During the landing,…May 27, 1982 · N8088T · Substantial damageNTSB DEN82IA098Incident · Minor injuriesIncident investigationFinal reportDouglas DC-8-61 · Near Goshen, INThis aircraft encountered unforecast severe clear air turbulance (cat) while in cruise flight at FL350 Near Goshen, IN. As a result of the encounter, the aircraft entered an uncontrolled descent which was arrested at 31,500 feet. A total of seventeen…May 27, 1982 · N8088U · No damageNTSB ATL82FIG07Accident · 1 fatalFinal reportGrumman G-164A · Frederick, MDThe pilot reported that 1 to 2 ounces of water was drained from the low point fuel sump, but no water was detected from the other sumps. He stated that he drained the sump until no water was detected. During the flight, the engine surged twice, then lost…May 27, 1982 · N6620Q · Substantial damageNTSB ATL82FA144Accident · 3 fatalField investigationFinal reportBell 206B · Oakwood, VAThe plt was flying railroad officials to inspect rail lines that had been covered by mud slides caused by recent heavy rains. A witness heard the helicopter coming up the valley & then heard two popping sounds. He saw the helicopter falling to the ground near…May 27, 1982 · N9986K · DestroyedNTSB FTW82DA193Accident · No injuriesFinal reportPitts Special S-1S · Huntsville, TXThe pilot reported that during flight at 1500 ft AGL, there was a violent explosive failure of the engine and black smoke entered the cockpit. He elected to land between cars on an interstate highway. He cleared over one car, but the driver of the next car…May 26, 1982 · N166S · DestroyedNTSB CHI82DA187Accident · No injuriesFinal reportCessna 182 · Cedarville, OHThe pilot stated that the engine failed while enroute and an emergency landing was made in a corn field. He also reported that the loss of power was due to carburetor icing. The aircraft was substantially damaged and there were no injuries.May 26, 1982 · N2414G · Substantial damageNTSB CHI82DA185Accident · No injuriesFinal reportHughes 369D · Fairbury, ILDuring flight, the N2 and nr suddenly accelerated to 110 percent. The pilot eventually shut down the engine and made an autorotation. An open field was selected for a landing site; however, it was muddy with standing water. The pilot decided on a full stop…May 26, 1982 · N8348F · Substantial damageNTSB SEA82DA078Accident · Minor injuriesFinal reportCessna 140 · Buena Vista, ORThe pilot stated that while looking out the left side window something impacted the windshield causing broken plexiglass to enter the cabin and injure both the pilot and the passenger. He then noticed that the airspeed was low and proceeded to lower the nose…May 23, 1982 · N73056 · Substantial damageNTSB MIA82DA121Accident · No injuriesFinal reportPiper PA-22-108 · Tampa, FLWhile circling over the area where the pilot resided, a complete loss of power occurred. During the emergency landing the pilot stalled the aircraft while attempting to avoid a collision with an autombile. Both the aircraft and the automobile were…May 23, 1982 · N4607Z · Substantial damageNTSB NYC82FA103Accident · 2 fatalField investigationFinal reportCessna 150F · Delano, PAThe plt received wx briefings at 1111 & 1530 from the detroit, mi fss for a flt to new jersey. The plt was advised during the 1530 briefing that VFR flt was not recommended. The plt departed gross ile, mi at approximately 1700 & landedat williamsport, PA at…May 22, 1982 · N8244S · DestroyedNTSB FTW82FQG18Accident · 1 fatalFinal reportCessna T337B · San Angelo, TXAt apprx 2015 CDT, the plt called the San Angelo tower and expressed concern that his acft might be damaged by hail from the wx that was bldg in the area, tower psnl relayed available wx info & provided phone numbers for the wx bureau & a local fss. A tornado…May 22, 1982 · N2349S · DestroyedNTSB FTW82DRD12Accident · Serious injuriesFinal reportGrumman 164 · Reeves, LAThe aircraft was returning to base after an aerial application of liquid chemical. He stated that there was an odor of chemical and he looked down to check the hopper. When he looked up he was descending into the trees.May 22, 1982 · N8548H · DestroyedNTSB FTW82DA190Accident · No injuriesFinal reportBellanca 7GCBC · Mt. Pleasant, TXAfter takeoff from runway 17, the pilot departed the traffic pattern and was about 1.5 miles north of the airport when the engine coughed. He immediately turned back toward the airport, but shortly thereafter, the engine lost all power. He decided to land on…May 22, 1982 · N5045G · Substantial damageNTSB CHI82FA181Accident · 3 fatalField investigationFinal reportBeech A23 · Northville, MIAt 1701 EDT on 5/21/82, the non-instrument rated pilot called a flight service station and requested an IFR weather briefing. The briefing was for a flight from lapeer, Michigan to frankfort, Kentucky. The plane departed the next day at about 1200 EDT with no…May 22, 1982 · N1405L · DestroyedNTSB ATL82DA142Accident · Serious injuriesFinal reportDouglas DC-9-15F · Memphis, TNBefore takeoff, the aircrew received weather data that included a forecast for a severe thunderstorm watch. While en route, the captain elected to leave the seat belt sign on for the entire flight. The flight was routine until a descent was started into the…May 22, 1982 · N9356 · No damageNTSB LAX82DA190Accident · Minor injuriesFinal reportCessna 172XP · Hilo, HIThe pilot stated that he requested 30 gallons of fuel for an estimated flight time of 3.5 hours. During the flight the engine ran rough and the right tank went to empty. The pilot then switched tanks and about 2 minutes later the pilot stated that the left…May 21, 1982 · N7320K · Substantial damageNTSB CHI82DA180Accident · No injuriesFinal reportPiper PA-28 · Harrisburg, ILDuring a weather briefing, the pilot was advised that there were thunderstorms in the area of his destination at about 1415 CDT, he departed for a two hour flight. After flying over weather most of the way and overflying an airport (hulman regional), he…May 21, 1982 · N2314F · Substantial damageNTSB ATL82FA140Accident · 2 fatalField investigationFinal reportCessna T210M · Holly Springs, SCPrior to departing new bern at 1837 the plt called his office & stated he had received a wx report for scattered thunderstorms along his route of flt. At 2020 & 2052 he contacted atl flt watch for wx advisories. He was advised that the wx radar was out of…May 21, 1982 · N761UR · DestroyedNTSB CHI82DA177Accident · Minor injuriesFinal reportBlanik L-13 · Warren, MNThe pilot was having difficulty controlling the glider during the tow and released prematurely. The destination was 12 to 14 miles away with 10-15 kt headwinds. When the pilot decided the destination could not be made a road was selected for a forced landing…May 20, 1982 · N99805 · Substantial damage