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 MKC84LA098Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Olathe, KSAt FL240, a fire broke out in the rgt eng compartment. The plt indicated that the eng turbo-charger was malfunctioning. The plt shut down the eng & asked for radar vectors to johnson county executive arpt. The fire went out at 21,000 ft & the acft landed…Mar 9, 1984 · N3TB · Substantial damageNTSB MKC84FA097Accident · 1 fatalField investigationFinal reportTeratorn Acft Tierra II · Lexington, NEThe plt had flown from callaway to Lexington, NE, earlier in the day. After a short visit, he departed on a return flt. A search was initiated when the acft did not return. About 5 hrs after the estimated time of the accident, the acft was found where it had…Mar 9, 1984 · UNK · Substantial damageNTSB MIA84FA099Accident · Serious injuriesField investigationFinal reportCessna 182J · Everglades City, FLThe plt stated that when the flt originated in Everglades City the left fuel tank was empty & the right fuel tank indicated 1/2 full. The flt to naples took 15 minutes. He initiated the return flt at 1047 & the eng quit at 1100. A forced landing was made in a…Mar 9, 1984 · N2830F · DestroyedNTSB DEN84FA307Accident · 4 fatalField investigationFinal reportRockwell 112TCA · Missoula, MTThe pilot had filed an IFR clearance. While taxiing to takeoff, he requested and received a clearance to climb VFR on course, via victor airway 2, with instructions to report when reaching 10,000' MSL. This was the last communication received from the pilot.…Mar 9, 1984 · N4699W · DestroyedNTSB NYC84FA104Accident · 1 fatalField investigationFinal reportCessna 172Q · Meadville, PAPlts were briefed on snowstorm advancing toward destination, departed in hope of arriving ahead of wx. Encounting IMC conditions (snow) enroute, plt filed IFR and continued. Communications transcript indicates that when eng began to lose power, plt used carb…Mar 8, 1984 · N96286 · DestroyedNTSB MIA84LA098Accident · No injuriesLimited investigationFinal reportCessna 206 · Guayama, PRThe plt had purchased the acft about 2 wks prior to the accident. After climbing on top for a x-country flt, he lost radio communication. He elected to continue on the flt & make position reports in the blind. The plt reported that he encountered headwinds.…Mar 8, 1984 · N2610X · DestroyedNTSB MIA84FU002Accident · 1 fatalFinal reportSigers Ritz Model A · Macclenny, FLThe ultralight nosed down and dove into the ground from cruise flt. Engine sound increased during the dive. From 200 ft AGL to the ground impact. No malfunctions in equipment were found during the investigation. The plt had a history of dizziness from a head…Mar 8, 1984 · UNREG · No damageNTSB DEN84FA108Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Saratoga, WYDuring a night x-country after a 16 hour day the airline captain flying his own acft home collided with a mountain at the 10000 ft level. The weather was VMC but the winds aloft were strong and would have blown the acft towardthe mountain had no wind…Mar 8, 1984 · N400SB · Substantial damageNTSB ATL84FA119Accident · No injuriesField investigationFinal reportPiper PA-31T · Benson, NCA Piper PA-31T, N9162Y, and a Beech 200C, N390AC, were involved in a midair collision while both were cruising at 17,500 ft in unlimited visibility. The Piper was tracking inbound on the 210 deg radial of the richmond VOR. The Beech was tracking inbound on…Mar 7, 1984 · N9162Y · 2 aircraft · Substantial damageNTSB NYC84LA103Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A-8 · Tobyhanna, PAThe acft made a precautionary landing on a highway after both engines lost oil pressure. The plt feathered the right propeller because it gave abnormal indications before the left engine. The left engine was still operating at touchdown post accident…Mar 6, 1984 · N19WA · Substantial damageNTSB ANC84LA040Accident · No injuriesLimited investigationFinal reportCessna 170B · Iliamna, AKThe acft cowling came unfastened during cruise and the plt elected to make a precautionary landing. During the landing, the plt lost directional control and collided with a snowbank.Mar 6, 1984 · N2715D · Substantial damageNTSB NYC84LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Elmira, NYThe acft was descending to land when the engine quit. The pilot attempted to restart the engine with negative results and made a forced landing into a plowed field. The weather conditions were conducive to carburetor ice.Mar 4, 1984 · N9617J · Substantial damageNTSB MKC84FA091Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Harrison, ARThe plt encountered a thunderstorm during a night x-country. The plt was being vectored by the controller to avoid the worst of the storm. After about 2 minutes memphis center heard the acfts call sign shouted over the radio. Further attempts at radio…Mar 4, 1984 · N5857F · DestroyedNTSB FTW84FA153Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Lampasas, TXThe captain received a company briefing prior to the flt. A convective SIGMET was in effect & turbulence was forcast for the area. During flt, the acft was manuevered to avoid turbulence. The acft was clear of clouds & in a thin haze layer when the crew felt…Mar 4, 1984 · N471BN · Minor damageNTSB ANC84LA039Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-100 · Glennallen, AKThe plt experienced a downdraft, while approaching a glacier at 5500 ft MSL. In turning downgrade to try to affect a descent of the acft, control was lost and the helicopter collided with the ground. The acft rolled inverted after ground contact.Mar 4, 1984 · N5051F · Substantial damageNTSB SEA84FA065Accident · 5 fatalField investigationFinal reportPiper PA-28-181 · Lewiston, IDThe acft crashed in mountainous terrain while the non-instrument rated plt was on a flt in marginal wx conditions. An investigation revealed that the acft had impacted in a steep nose down, high speed descent. No preimpact/mechanical problem was found. About…Mar 3, 1984 · N2868D · DestroyedNTSB NYC84LA329Accident · 2 fatalLimited investigationFinal reportCessna U206A · North Hudson, NYAn inflight collision with trees in an area of high terrain. Factors related to the accident were: the pilot's decision to takeoff after he received a briefing advising, 'VFR flight not recommended', the dark night conditions, and snow showers.Mar 3, 1984 · CFUQW · DestroyedNTSB MKC84FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Oconto, NEAfter attending a business conference at muncie, IN, the plt received a wx briefing & took off at 2026 CST on a flt to des moines, IA, where he refueled. In a phone call to his wife at their home in north platte, NE, he indicated the wx was such that he would…Mar 3, 1984 · N8054E · DestroyedNTSB ATL84LLT05Accident · Minor injuriesFinal reportCessna C-172F · Pascagoula, MSThe plt ditched the acft after a complete loss of power. The acft fuel system was damaged during the recovery process and a complete evaluation could not be made.Mar 3, 1984 · N8662U · Substantial damageNTSB ATL84LA112Accident · No injuriesLimited investigationFinal reportCessna P210N · Kennesaw, GAThe acft crashed during a forced landing after a power loss. The plt stated during a post accident interview that he didnot switch tanks during the power loss sequence. Investigation revealed that the right fuel tank was empty. About 1/2 oz of fuel was…Mar 3, 1984 · N6320W · Substantial damageNTSB ATL84FA111Accident · 2 fatalField investigationFinal reportPiper PA-32RT-301T · Goodway, ALPlt received two weather briefings prior to departure. He was told of an approaching cold front but the fss briefer stated 'if you go now, it'll be fine.' The plt departed on the VFR flt to hickory, NC, and did not file a flt plan. Radar info obtained during…Mar 3, 1984 · N8427A · DestroyedNTSB SEA84FA064Accident · 2 fatalField investigationFinal reportCessna U206 · Stevenson, WAThe plt initiated a flt in weather with low visibility, rain and fog. The plt had reportedly checked the weather but decided to fly anyway. About 30 minutes after takeoff while the plt was maneuvering at low alt, the acft crashed in a river. The acft sank in…Mar 1, 1984 · N735KE · DestroyedNTSB ATL84FLT06Accident · Serious injuriesFinal reportCessna 182 · Maryville, TNThe acft crashed during a forced landing after running out of fuel. The plt said he did not visually check the fuel prior to takeoff. After the accident the acft contained 2 gallons in each tank and had about an ounce of fuel in the carburetor which normally…Mar 1, 1984 · N6114B · Substantial damageNTSB SEA84FA063Accident · 2 fatalField investigationFinal reportEnstrom 280C · Middleton, IDThe acft collided with the terrain during a test flt. Witnesses observed the acft rotate about 180 degrees about its vertical axis go nose low and descend vertically to the ground. A noise change described as a 'sputter' or tone change' was heard during this…Feb 29, 1984 · N51715 · DestroyedNTSB DEN84LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Deming, NMThe plt took off with full fuel tanks & used fuel from the main tanks until they were aprx 1/2 full. He then switched to the tip tanks & used fuel from them until they emptied. Judging from a previous flt, he knew the l tip tank would empty aprx 8 min before…Feb 27, 1984 · N3253P · Substantial damageNTSB MIA84FA095Accident · Serious injuriesField investigationFinal reportMonnett Moni · Indiantown, FLThe acft crashed in pieces after the airframe failed while the plt was performing aerobatics. The plt used his parachutewhile still belted to the tail section of the acft which was lowered by the chute. The wreckage consisted or six main pieces of separated…Feb 26, 1984 · N87RB · DestroyedNTSB FTW84LA150Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Amarillo, TXPlt was advised by fss that Amarillo had snow flurries, visibility 4 miles and wind from 350 degs at 28 KTS gusting to 34 KTS, tucumcari, NM was reporting 2 miles visibility with light snow and areas further west were clearing. The plt departed Amarillo under…Feb 26, 1984 · N31213 · Substantial damageNTSB MKC84LA083Accident · No injuriesLimited investigationFinal reportCessna C-150K · Hot Springs, ARThe acft collided with trees during the forced landing 1/4 mile from the rwy. The plt had landed only 19 miles from the accident, and finding no fuel available at the unattended arpt decided to continue his flt. Just short of destination the acft, ran out of…Feb 25, 1984 · N6063G · Substantial damageNTSB ATL84FA107Accident · 2 fatalField investigationFinal reportPiper PA-23 · Bluefield, WVWhile cruising on an IFR flt at 10,000 ft, the plt informed atlanta center that he had an eng problem & was declaring an emergency. He was provided a heading to the Bluefield arpt which was nearby. When asked about the problem, he said the left eng was…Feb 25, 1984 · N2160P · DestroyedNTSB LAX84LA197Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1A · Chandler, AZThe plt had just completed a power-off spiral to about 200 ft AGL. Power was applied & the acft climbed to about 500 ft AGL when the eng quit. Subsequently, the acft was damaged during a forced landing. All fuel lines & the fuel boost pump were found dry.…Feb 24, 1984 · N9452L · DestroyedNTSB DEN84LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, NMThe student plt made a forced landing and the acft nosed over on soft terrain after the engine quit during the last leg of a x-country. The plt said he had not visually checked the fuel tanks during pre-flight. An examination of the acft after the accident…Feb 24, 1984 · N46723 · Substantial damageNTSB DEN84LA098Accident · No injuriesLimited investigationFinal reportCessna 185C · Spanish Fork, UTThe acft nosed over during a forced landing in snow after the engine quit. The plt said that he ran out of fuel. The pltsaid he departed on the 90 mile x-country with about 15 gallons of fuel aboard the acft. The acft was landed just short of the destination…Feb 23, 1984 · N2691Z · Substantial damageNTSB ATL84FA106Accident · 2 fatalField investigationFinal reportBeech A36 · Hamilton, ALThe acft collided with trees aprx 6 miles east of marion cty arpt and aprx 17 NM sw of the flt depat pt and also the plt's home arpt. The plt had earlier that day told the haleyville arpt mgr that he would return to haleyville the same day as dept. The acc…Feb 23, 1984 · N1034W · DestroyedNTSB LAX84FA193Accident · 2 fatalField investigationFinal reportRobinson R22 · Thousand Oaks, CAThe helicopter collided with 2 cables supported by 150 ft tall twin towers. It then went out of control & crashed into a 15 ft deep drainage ditch & burned. The plt had been cited on 2/20/84 for 'careless & reckless operation of an acft.' Another person who…Feb 22, 1984 · N8404S · DestroyedNTSB CHI84LA116Accident · Minor injuriesLimited investigationFinal reportNavion A · Newport, MNThe acft engine failed when the plt applied carburator heat to try to 'cure' a rough running engine. Post accident investigation revealed a hole in the left muffler and shroud allowing burnt exhaust gases to enter the carburetor when carburetor heat was…Feb 22, 1984 · N4893K · Substantial damageNTSB FTW84LA143Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Monroe, LAThe aircraft suffered a loss of power while returning from an ag flight and made an emergency landing in a ditch next toa rice field. The engine was test run with no discrepancies noted. It was determined that the loss of power was due to fuel exhaustion.Feb 21, 1984 · N3159C · Substantial damageNTSB NYC84FFA02Accident · Serious injuriesFinal reportPiper PA-28-180 · Lexington, NYWeather briefing forecast low ceilings, mountains obscured and lgt to mod turbulence. VFR not recommended. Plt filed no flt plan. Plt reported that an encounter with turbulence caused a loss of control and collision with terrain during the recovery. Witness…Feb 20, 1984 · N9335J · Substantial damageNTSB MIA84LA088Accident · No injuriesLimited investigationFinal reportMooney M-20F · Defuniak Spring, FLWhile flying at 3000 ft, the eng sputtered & quit running. The plt stated that he tried all emergency procedures, which included changing the fuel selector position. He extended the gear to land on an interstate highway, but saw an overpass ahead, so he…Feb 20, 1984 · N3455X · Substantial damageNTSB LAX84LA187Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Lucerne, CAUpon reaching his destination, the plt was unable to see the arpt because of the presence of a solid lower layer of clouds. While looking for a break in the cloud layer for a VFR descent, the plt 'inadvertently flew into IFR conditions,' & impacted trees.…Feb 20, 1984 · N34849 · DestroyedNTSB LAX84FA189Accident · 1 fatalField investigationFinal reportCessna 182P · Livermore, CAWhile on a night x-country flt, the acft collided with the ground near the top of hilly terrain at an elevation of about 1840 ft. the time of the accident was not known, but the acft had departed groveland, CA at sometime between 1900 & 1930 PST. Witnesses in…Feb 20, 1984 · N91227 · DestroyedNTSB FTW84LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bastrop, TXThe engine lost power and the plt noticed smoke coming from the defrost vent. An emergency landing was made on a local highway. Examination revealed that the exhaust pipe was disconnected from the muffler and the hot gases melted a rocker box oil drain line.…Feb 20, 1984 · N15043 · Substantial damageNTSB ATL84FLT04Accident · Serious injuriesFinal reportAero Commander 680F · Charleston, TNThe acft crashed during a ferry flight and the plt could not recall the circumstances of the flight. Investigation revealed that the acft had been parked on the service ramp for nearly two years without being used. The last annual inspection was recorded on…Feb 20, 1984 · N6000F · Substantial damageNTSB LAX84LA184Accident · No injuriesLimited investigationFinal reportBeech M35 · Santa Ana, CAThe plt reported that he had an electrical failure after takeoff. He remained in the traffic pattern & lowered the landing gear on the downwind leg. During the landing roll, all three gear collapsed. The plt did not manually crank the landing gear down. The…Feb 19, 1984 · N280AA · Substantial damageNTSB FTW84FU003Accident · 1 fatalFinal reportUltraclassics Bearcat 150 · Abita Springs, LAThe airman tookoff for a personal flt, and after circling, made a desending high speed pass over the arpt. He then pulled the vehicle into a climb and began a roll. About 2/3 through the roll, the vehicle's nose dropped and it dove into the ground. The nose…Feb 19, 1984 · UNREG · Substantial damageNTSB CHI84LA113Accident · No injuriesLimited investigationFinal reportCessna 150 · Menominee, MIThe acft landed in a swamp and nosed over after the engine lost power. Weather conditions were conducive to carburetor icing. The plt reported that he experienced carburetor icing and a power loss two miles short of the arpt of intended landing.Feb 18, 1984 · N5828E · Substantial damageNTSB CHI84FA112Accident · 2 fatalField investigationFinal reportBeech A23A · Oaktown, INAcft stalled & crashed after a pwr loss during night x-country flt. Plt radioed a 'mayday' call after reporting 3 mins earlier he had 30-45 mins of fuel remaining. Indianapolis ARTCC was giving flt assistance to N3639Q & advised the flt ofan arpt at 'your two…Feb 18, 1984 · N3639Q · DestroyedNTSB SEA84LA054Accident · No injuriesLimited investigationFinal reportAerospatiale AS-341G · Alma, ORThe plt stated he lost partial power on a x-country flt, during cruise, and initiated an autorotation. At about 200 to 300 ft AGL he reduced the throttle to idle. During flare the rotor RPM decayed and the acft landed hard and rolled over. The pilot stated…Feb 17, 1984 · N633B · Substantial damageNTSB LAX84LA171Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Folsom Lake, CAAbout 10 min after departure a total power loss was experienced due to fuel exhaustion. Due to rough unsuitable terrain the plt elected to ditch in a nearby lake. Upon recovery of the acft about 1 gal of fuel and 5 gals of water were found in each fuel tank.…Feb 17, 1984 · N8242S · Substantial damageNTSB LAX84IA195Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Santa Ana, CAShortly after takeoff a ttl pwr loss was experienced on the number 1 engine. Examination of the engine revealed substantial damage occurred in the compressor section from stage 6 rearward. 40 stage 8 compressor blades were forced completely out of their disk…Feb 17, 1984 · N203AA · No damageNTSB NYC84LA087Accident · No injuriesLimited investigationFinal reportMooney M20J · Bristol, PAThe acft encountered weather and head winds on a x-country flt. Nearing his destination after a long flt the plt was trying to let down VFR through breaks on the clouds when he realized the critical nature of his fuel level. A search foran arpt produced the…Feb 16, 1984 · N201LU · Substantial damage