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 ATL84LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waverly, KYAbout 8 mi from his destination the plt encountered freezing rain. He decided to retrieve a flashlight from his briefcase in the back seat to use in checking for ice on the wings & in consulting his charts. While leaning over the back seat, the plt lost his…Dec 21, 1983 · N2767M · Substantial damageNTSB MKC84LA042Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Schuyler, NEWhile descending toward the planned destination, the eng began running rough & the plt attempted to improve the eng's performance by using carburetor heat. He made a localizer-only apch, but was unable to see the rwy at the min descent alt. A missed apch was…Dec 20, 1983 · N43302 · Substantial damageNTSB MKC84LA041Accident · No injuriesLimited investigationFinal reportCessna 310 · Olathe, KSThe plt was returning to Kansas city, MO with no cargo on board after delivering cancelled checks to tulsa, OK. While en route, the plt noticed a slight drop in oil pressure. About 75 mi from his destination, he noticed that the oil gage indicated below the…Dec 20, 1983 · N809AA · Substantial damageNTSB CHI84LA072Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Covington, INThe acft made a forced landing on a highway when the engine quit after less than an hour of flight time following departure. The wings were damaged during the landing. After the accident an FAA maintenance inspector opened both main tank drains and drained…Dec 20, 1983 · N3706W · Substantial damageNTSB SEA84LA027Accident · No injuriesLimited investigationFinal reportCessna 150F · Prosser, WAAccording to the pilot shortly after departure the engine began running rough for the second time. The pilot elected to make a precautionary landing on a gravel road he was familiar with. During the landing flare, with a gusty crosswind, directional control…Dec 17, 1983 · N6841F · Substantial damageNTSB CHI84FA063Accident · 1 fatalField investigationFinal reportCessna 150M · Stockwell, INThe plt had been wx briefed & filed a flight plan at the lafayette fss. About 1 hr later he returned to the fss & asked if the fss had heard him calling on 119.6. He was advised that he had not been heard. The plt stated he would try to call when airborne. On…Dec 17, 1983 · N63398 · DestroyedNTSB MKC84LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sikeston, MOThe acft nose gear collapsed during a forced landing after engine failure. During a x-country flt the engine popped and quit. The plt approached a road to land but saw a vehicle during approach and veered off into a field. Post accident investigation revealed…Dec 16, 1983 · N321HF · Substantial damageNTSB FTW84LA099Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Imperial, TXThe plt reported that when he was in cruise flt at 300 ft AGL, a sudden violent shudder went thru the whole helicopter, then the shudder stopped. He noted no change in the flit characteristics or eng power. The plt elected to make a precautionary landing by…Dec 16, 1983 · N63MC · Substantial damageNTSB ANC84LA025Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe plt reported that during flt, he encountered freezing rain. Although he applied carburetor heat, the eng ceased operating. During a forced landing, the right main gear collapsed & the right outboard wing panel was damaged. The plt reported that freezing…Dec 16, 1983 · N2894Z · Substantial damageNTSB MKC84LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Garnett, KSWhile enroute pilot was running the acft using the right main fuel tank. He switched to the left to balance the load and the engine quit about 10 seconds after being switched. The pilot could not restart the engine and a forced landing was made in a field.…Dec 15, 1983 · N4026R · Substantial damageNTSB DEN84FA225Accident · 3 fatalField investigationFinal reportPiper PA-32 · Alma, COThe plt, his brother & his sister-in-law were on a flt to attend his mother's funeral. Before taking off, the pilot received a wx briefing & was advised that VFR flt was not recommended. The plt then asked for wx reports for a southerly route & he was advised…Dec 14, 1983 · N47403 · DestroyedNTSB FTW84LA097Accident · No injuriesLimited investigationFinal reportBeech A-36 · Harrison, ARThe acft entered an area of icing and did not notify the ATC center of the icing problem. Although an emergency was not declared the plt did say he could not climb to an assigned alt after descending to try and lose ice accumulation. During the landing the…Dec 13, 1983 · N2149L · Substantial damageNTSB ATL84FA064Accident · 1 fatalField investigationFinal reportPiper PA-24-260B · Mcdonald, TNThe plt received 2 wx briefings before takeoff & was provided flt precautions of IMC to continue beyond 0900 EST. Also, he was advised that the mountains would be occasionally obscured & icing could be expected to the west below 6000 ft. during both…Dec 13, 1983 · N8981P · DestroyedNTSB ANC84LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Barrow, AKThe plt stated that shortly after reaching cruise altitude the eng failed. A forced landing was made on tundra covered by encrusted snow & ice nad the gear collapsed. During the on-scene investigation the fuel injector was found to allow only a small amount…Dec 12, 1983 · N3575A · Substantial damageNTSB NYC84LA050Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC Citabria · Nantucket, MAThe acft experienced a power loss and crashed during a low pass to observe an object on the ground. The flt had departednantucket and flown over to tuckernuck isl where a descent was made to observe an unusual object on a shoal. Carburetor heat was applied…Dec 10, 1983 · N5041N · Substantial damageNTSB MIA84FA042Accident · 2 fatalField investigationFinal reportPiper PA-22 · Port Richie, FLThe acft crashed into trees during a night forced landing after the engine quit. The surviving passenger said he had metthe two plts in a bar where they drank beer. They later went to the arpt and flew x-country about 70 miles to eat & have more beer. They…Dec 10, 1983 · N3719 · DestroyedNTSB FTW84LA092Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Washington, OKAbout 15 min after tkof the plt became aware that the ground below was covered with fog. The plt found a hold in the obscured ceiling, descended and established visual contact with a field. After circling the plt landed in the field. About halfway down the…Dec 10, 1983 · N7666M · DestroyedNTSB FTW84LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Winslow, ARDuring a wx briefing before takeoff, the plt was advised that VFR flt was not recommended. About 12 to 15 min after takeoff, he was forced to descend to maintain visual contact. He deviated south to avoid a rain shower. Subsequently, the plt realized he had…Dec 10, 1983 · N67863 · DestroyedNTSB CHI84FA058Accident · 4 fatalField investigationFinal reportCessna 207 · Put-In-Bay, OHThe plt & 3 passengers took off at night on an over water flt to an island in lake erie to provide help to a heart patient. No flt plan was filed & no record of a wx briefing was found. Reportedly, after takeoff, the acft disappeared in a cloud or haze. Also…Dec 10, 1983 · N208JP · Substantial damageNTSB SEA84FA101Accident · 1 fatalField investigationFinal reportCessna T210M · East Sound, WAThe acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in…Dec 8, 1983 · N761PW · DestroyedNTSB LAX84FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, CAThe acft collided with rising terrain at the 1600 ft level on a dark night. The plt was on a night cross-country and hadmade a radio call saying he was unsure of his position. He then reported his alt as 2000 ft. the buchanan tower gave him a heading to fly…Dec 8, 1983 · N2862C · DestroyedNTSB CHI84LA055Accident · Minor injuriesLimited investigationFinal reportCessna 310L · West Lafayette, INThe plt was unable to start the eng with the batteries & made a start by using an APU. About 10 min after taking off, he noticed an off flag on the HSI. A further check was made & he discovered the left alternator was not functioning. He then checked the…Dec 8, 1983 · N2222F · Substantial damageNTSB MKC84FA034Accident · Serious injuriesField investigationFinal reportCessna 21ON · Wentzville, MOThe acft was landed with the landing gear partially extended during a forced landing after an engine failure. The plt delayed the extension of the gear because of the condition of the landing area. Examination of the engine showed a failure of the #2…Dec 6, 1983 · N5209C · Substantial damageNTSB NYC84LA045Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Somersworth, NHThe acft was damaged in a forced landing after the engine quit during a descent. The plt had been cruising at 2500 ft. upon descending to 800 ft in the skyhaven area the plt applied power but the engine did not respond. An airstart attemptwas unsuccessful and…Dec 4, 1983 · N62042 · Substantial damageNTSB FTW84FA084Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Pawnee, OKThe acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…Dec 4, 1983 · N4579Z · DestroyedNTSB CHI84FA054Accident · 1 fatalField investigationFinal reportBeech 77 · Sidney, OHThe aircrew took off on an IFR flt from dayton to piqua & Sidney, OH to practice apch's, then they intended to return to dayton. The copilot stated that they entered the clouds at 700 to 800 ft AGL & he did not see the ground again on this flt. He reported…Dec 4, 1983 · N37253 · DestroyedNTSB LAX84LA092Accident · No injuriesLimited investigationFinal reportSchweizer I-26D · Black Canyon, AZThe glider collided with a tree during a forced landing. The glider was being towed on a ferry x-country when they overflew an undercast. The tow plane started descent to penetrate the clouds expecting the glider to maintain tow and contact on the 200 ft…Dec 3, 1983 · N7740S · Substantial damageNTSB FTW84FA083Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Hebbronville, TXThe flt proceeded without incident until the plt contacted houston ARTCC. The plt requested the destination wx & was told that the entire area was IFR. The closest arpt reporting VFR conditions was at mcallen, TX, aprx 80 mi southeast. The plt then advised…Dec 3, 1983 · N4097B · DestroyedNTSB DEN84FA038Accident · Serious injuriesField investigationFinal reportBell 206B · Ft. Morgan, COThe helicopter was owned & operated by a tv station & was being used for transportation to a news event. While en route, clouds & reduced visibility due to fog were encountered. The plt elected to land in a field covered with powdered snow. During the…Dec 3, 1983 · N1078V · Substantial damageNTSB LAX84FA087Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Holtville, CAThe plt had departed mazatlan, Mexico at 0632 PST & had landed at los mochis & mexicali, Mexico & at calexico, CA, where he cleared U.S. Customs. Before departing calexico, he telephoned his family & told them the wx had been poor all day. The estimated time…Dec 2, 1983 · N3206W · DestroyedNTSB FTW84LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Ardmore, OKThe plt stated that before he took off from Oklahoma city, OK, he called the Oklahoma city fss & obtained a wx briefing. The briefing called for light rain showers, minimum ceiling of 1800 ft, visibility of 3 to 5 miles & no chance of fog, except in low lying…Dec 2, 1983 · N2005A · Substantial damageNTSB DEN84LA036Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Cokeville, WYThe plt reported that snow had been falling regularily for the previous few days before the flt. He departed the staging area with 12 drill crew members. At that time, the visibility was 2 to 3 mi & a ceiling of 800 to 1000 ft. the plt flew 9 of the…Dec 2, 1983 · N1084N · Substantial damageNTSB DEN84FA031Accident · 1 fatalField investigationFinal reportChampion 7GC · Douglas, WYThe plt took off on an aerial observation flt to spot cattle in a mountainous area. When he failed to return, a search was initiated. The plane was found in a valley between 2 mountain ranges. An investigation revealed that the acft had crashed while in a…Nov 29, 1983 · N7697E · DestroyedNTSB MIA84FA036Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Kathleen, FLThe acft impacted in a swampy area in a fast dive which separated about 6 ft of the left wing. The acft was being vectored on radar when it suddenly began to steer erratically and go off the radar scope. The plt had radioed that he 'must have gone over some…Nov 28, 1983 · N9094P · DestroyedNTSB NYC84FA038Accident · 4 fatalField investigationFinal reportCessna 172P · Silver Greek, NYThe two acft were involved in a midair collision near Silver creek, NY. The plt of N4089P was flying in the left seat & using an instrument hood with a safety plt in the right seat. The plt of the other acft was on a pleasure flt with his daughter. Both acft…Nov 27, 1983 · N96268 · 2 aircraft · DestroyedNTSB FTW84FA077Accident · 4 fatalField investigationFinal reportCessna 172L · Simpson, LAThe acft collided with the ground in a steep nose down altitude at a high rate of speed after the plt encounterd low ceiling and rain during a x-country flt. In attempting to fly IFR and follow radar vectors the non-instrument rated plt lost countrol of his…Nov 27, 1983 · N2899G · DestroyedNTSB FTW83LA078Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Albuquerque, NMAfter transporting a patient & 2 crewmembers, the plt took off from a medical center helipad to obtain fuel at a nearby arpt. Shortly after departing, a partial loss of power was encountered. The plt started to land on a road, but saw a car & turned to avoid…Nov 27, 1983 · N2070Z · Substantial damageNTSB ATL84FA054Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lexington, TNThe acft collided with the ground in a vertical descent during IMC weather on a x-country flt. The plt had filed an IFR flt plan but he was a student with limited experience and was not instrument rated. Also he was carrying a passenger. The controller who…Nov 27, 1983 · N5396L · DestroyedNTSB LAX84LA082Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Scottsdale, AZThe acft collided with a sign during a forced landing on a street. There was some damage to the right wing. The plt stated that he thought he had ample fuel for the flt. He also stated that the fueling facility was closed at the arpt at time of his departure.…Nov 26, 1983 · N200CF · Substantial damageNTSB ATL84LA051Accident · No injuriesLimited investigationFinal reportCessna 172P · Jackson, MSThe acft ditched in a reservoir at night after a power loss. The plt was descending to land, in preparation for the landing the plt switched fuel tanks on the selector valve to what he thought was both tanks position. Shortly after thisthe engine quit. The…Nov 26, 1983 · N64791 · Substantial damageNTSB NYC84FA037Accident · 2 fatalField investigationFinal reportBeech H18 · Allentown, PAWhile en route, the plt encountered icing conditions, then reported he was unable to maintain alt & was having eng problems. He diverted toward Allentown, PA, then advised he had lost power in the left eng. Apch control began issuing vectors for a VOR apch;…Nov 25, 1983 · N105PE · DestroyedNTSB LAX84LA072Accident · No injuriesLimited investigationFinal reportBensen B8M · Rocklin, CAThe plt was operating his home built, non-registered gyrocopter as an ultralight vehicle. Reportedly, the eng lost power during flt, and subsequently, the gyrocopter was damaged during a forced landing. According to the plt, he encountered carburetor icing…Nov 25, 1983 · UNREG · Substantial damageNTSB LAX84FA073Accident · Minor injuriesField investigationFinal reportBeech J-35 · Ontario, CAThe acft forced landed in a vineyard where the nose gear dug in and the acft nosed over. The flt stated that climbing through 5000 ft MSL the power went to idle and then to zero. All fuel tanks were filled prior to departure & the left main tank was selected…Nov 25, 1983 · N8337D · DestroyedNTSB LAX84FA071Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Oceanside, CABefore takeoff, the plt received a wx briefing & was advised to expect IFR conditions in the vicinity of Oceanside, CA & that moderate turbulence existed below 20,000 ft. after takeoff, he obtained an IFR clearance to climb & cruise at 6000 ft. at about 2005…Nov 25, 1983 · N6295T · DestroyedNTSB DCA84AA008Accident · Serious injuriesFinal reportLockheed L-1011 · Charleston, SCDuring flt at FL350, the fltcrew noted some thunderstorms in the vicinity of their route of flt & advised the ATC controller that they might have to detour. After turning & climbing to FL370, they noted 'moderate chop to light turbulence' & saw a flash of…Nov 25, 1983 · CFTNJ · Minor damageNTSB CHI84LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Zanesville, OHAfter departing Zanesville, OH, the acft was at 2500 ft MSL when the eng began to 'knock'. The cockpit filed with smoke & the eng began to lose oil. The plt turned back to land at the arpt. He reported that the eng continued to run until the acft was about…Nov 25, 1983 · N41873 · Substantial damageNTSB ATL84FA058Accident · 2 fatalField investigationFinal reportCessna 414A · Waynesville, NCAfter departure at 1417 CST, radar track showed the acft climbing to & maintaining 7,600 ft until about 1733 EST & 28-30 mi north of the knoxville VOR. The acft then descended & crossed the snowbird VOR at about 6,700 ft. there were several up & down altitude…Nov 24, 1983 · N6623C · DestroyedNTSB NYC84LA036Accident · No injuriesLimited investigationFinal reportCessna 172 · Ft. Plain, NYThe flt departed bedford, ma at about 1300. Upon arriving in the area of the destination arpt, the plt had difficulty inlocating the arpt. After seeing what he thought was a wind sock, he landed in a farmer's field. He was told that this was the original…Nov 22, 1983 · N734YA · Substantial damageNTSB FTW84MA069Accident · 4 fatalMajor investigationFinal reportCessna 210N · El Paso, TXN4742P departed El Paso, TX, on an IFR flight plan with a clearance to climb to 10,000 feet. No climb restrictions were included in the clearance. Departure control service was provided by albuquerque ARTCC since El Paso tower had shut downfor the night. The…Nov 22, 1983 · N4742P · DestroyedNTSB FTW84FA068Accident · 1 fatalField investigationFinal reportMooney M20J · El Paso, TXThe acft collided with the ground at 4380 ft MSL. The plt had called the control tower in El Paso and advised that he was at 8500 ft and would have to start descending due to weather in the area. The plt was VFR and no flt plan had been filed. He was advised…Nov 22, 1983 · N201TH · Destroyed