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 DEN84FA016Accident · No injuriesField investigationFinal reportCessna TU-206A · Loveland, COThe acft lost part of one blade of the propeller during the climb to cruise phase of operation. The passengers were skydivers so they used their parachutes in an exit of the acft as the airframe started to vibrate. The plt made a successful landing on the…Oct 23, 1983 · N4831F · Substantial damageNTSB DEN84FA012Accident · Serious injuriesField investigationFinal reportCessna T210G · Bountiful, UTDuring flt at 11,000 ft, the plt noted that the fuel flow gage was 'wiggling' & the eng 'didn't sound real healthy.' He increased the mixture slightly & turned the aux fuel pump to 'low boost.' The fuel flow then stabilized 'pretty good.' The plt said that a…Oct 23, 1983 · N6906R · Substantial damageNTSB LAX84FA025Accident · 1 fatalField investigationFinal reportDeley Starduster SA-100 · Wrightwood, CAThe acft crashed in mountainous terrain in VMC weather. There is no record of radio communications with the acft on the day of the accident. The acft impacted a 30 degree upslope in a 25 degree nose down wings level attitude. Two witnesses said they observed…Oct 22, 1983 · N717MD · Substantial damageNTSB FTW84LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Truth Or Cons, NMThe plt reported that while the acft was cruising at 10,500 ft MSL, the eng lost power & he was unable to restart it. During an emergency landing, the nose gear hit a rock & collapsed. The acft was checked, but the eng could not be started, when 1st…Oct 22, 1983 · N7400E · Substantial damageNTSB ATL84FA026Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Lake Hills, TNWhile en route, the acft's radio transmitter became inop; however, the plt could receive transmissions & was provided vectors toward the destination arpt. After starting a descent near the destination, the eng lost power. Subsequently, the acft was ditched in…Oct 22, 1983 · N5763P · Substantial damageNTSB MIA84LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ocala, FLWhile the plt was descending near his destination, the eng lost power. Subsequently, the acft hit trees, a power line & a fence during a forced landing. A teardown of the eng & an exam of the fuel sys revealed no evidence of a preimpact, mechanical…Oct 20, 1983 · N1441U · Substantial damageNTSB LAX84IA023Incident · No injuriesIncident investigationFinal reportCessna 414 · Van Nuys, CADuring climb to cruise the pilot stated the nose of the abruptly pitched up. He physically overpowered the forces and landed the acft. Examination of the acft & systems revealed no failures that would account for the pitch up.Oct 20, 1983 · N414JC · No damageNTSB DEN84FA010Accident · 2 fatalField investigationFinal reportCessna 182F · Burke, SDPrior to the flt, the plt obtained a wx briefing & was advised that VFR flt was not recommended. At the end of the briefing, he indicated he would 'be getting back with' the fss specialist. The plt then told the arpt manager that he would 'go up & take a look…Oct 20, 1983 · N3375U · DestroyedNTSB DEN84IA007Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Pueblo, COThe acft experienced an uncontrolled altitude deviation as a result of encountering cat at 27000 ft. it climbed at 6000 fpm to 3200 ft. the acft was 40 to 50 miles north & slightlybelow the jet core. No turbulence was forecast.Oct 19, 1983 · N70634 · No damageNTSB NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…Oct 18, 1983 · N5011N · DestroyedNTSB ATL84LA022Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Greensboro, NCThe acft lost power during the climb to cruise. The plt made a forced landing and collided with trees. The fuel selectorwas on the empty left tank. The right tank contained 20 gallons of fuel. The plt did not check the fuel selector prior to takeoff and did…Oct 17, 1983 · N38234 · Substantial damageNTSB MKC84LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Carlisle, IAThe pilot said the fuel gauges read full on the ground but as he leveled off in cruise they dropped to a reading of much less than full. The acft ran out of fuel short of destination. The pilot blamed the flu and fatigue for his oversight.Oct 16, 1983 · N2825T · Substantial damageNTSB MKC84LA008Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Lawrence, KSThe plt reported that prior to flt, the fuel gages indicated both tanks were full; however, he did not visually verify the quantity of fuel. During flt, in the vicinity of emporia, KS, the eng lost power while using fuel from the left tank. The plt changed…Oct 16, 1983 · N731HP · Substantial damageNTSB LAX84LA015Accident · No injuriesLimited investigationFinal reportBeech S35 · Laton, CAWhile in lvl flt and cruise flt configuration the plt stated that the eng suddenly began to get rough he noted that when pwr was partially reduced the roughness terminated. When the mixture was leaned the eng died momentarily. He rptd that the eng RPM was…Oct 16, 1983 · N7916K · Substantial damageNTSB FTW84FA023Accident · 3 fatalField investigationFinal reportCessna 172M · Redfield, ARAt aprx 1331 CDT, the plt entered the pine bluff fss station & requested a briefing for a VFR flt to springfield, MO. He was advised that VFR flt was not recommended. The plt returned again between 1335 & 1350 & was seen examining the wx charts. At aprx 1420,…Oct 16, 1983 · N321HR · DestroyedNTSB SEA84LA010Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mccall, IDWhile en route, the plt entered a drainage area in mountainous terrain with the intent of crossing a ridge at the lowest point. As he continued in a canyon, he had a 500 ft/min climb rate & he believed he could easily clear the ridge. However, as he…Oct 15, 1983 · N738RD · Substantial damageNTSB FTW84LA025Accident · No injuriesLimited investigationFinal reportBeech C24R · Prairie Grove, ARThe plt stated that about 15 min after takeoff, the radio & navigation equpment quit working. He decided to return to the arpt to land. However, when he tried to extend the gear, he could not get a safe gear down indication. There was heavy traffic, so he…Oct 15, 1983 · N23PS · Substantial damageNTSB LAX84LA013Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Victorville, CAThe plt stated that the flt was proceeding smoothly until he veered off course to go around a restricted area & became slightly lost. When he was 5-1/2 mi se of george afb & 36 mi sw of his destination he noticed that the fuel gage was reading empty. Moments…Oct 14, 1983 · N7113O · Substantial damageNTSB LAX84FA012Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Schurz, NVThe acft was on a crosscountry flight in VFR conditions. The non-instrument rated pilot encountered instrument conditions at night and lost control of the acft in flight. The post crash investigation revealed evidence of an inflight structural failure due to…Oct 14, 1983 · N8370Z · DestroyedNTSB DEN84FA011Accident · 2 fatalField investigationFinal reportCessna 182 · Hanksville, UTThere were two pilots aboard this acft which impacted in a steep nose down attitude on a plateau at 5000 ft MSL. Flight control continuity was established. The pilot was recently certificated & his class iii medical had expired. The second pilot held a…Oct 14, 1983 · N3254Y · DestroyedNTSB NYC84IA007Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Atlantic Ocean (Atlantic Ocean)The acft encountered moderate to severe turbulence as it seemed to pass through a cumulus cloud. Radar showed no buildups & there were no sigmets or airmets in effect.Oct 12, 1983 · N123AA · No damageNTSB DCA84AA002Accident · 10 fatalFinal reportHawker Siddeley HS-748-2A · Pinckneyville, ILAbout 1.5 min after departing springfield, IL, the fltcrew reported a slight electrical problem, but they continued on course. About 33 min later & a few min before the acft should have reached its destination, the acft crashed. Impact occurred while the acft…Oct 12, 1983 · N748LL · DestroyedNTSB SEA84IA008Incident · No injuriesIncident investigationFinal reportS.N.I.A.S. AS350D · Seattle, WAThe acft sustained a complete failure of the tail rotor drine shaft due to fatigue from stress corrosion precipitated byprevious damage at which time no logbook entry was recorded to indicate that the shaft had been inspected.Oct 11, 1983 · N350GT · No damageNTSB NYC84FHM01Accident · Minor injuriesFinal reportPiper PA-28-181 · Poughkeepsie, NYThe acft collided with trees during a forced landing after the engine quit. The plt had let down through clouds during a descent for a vor-dme approach. The acft broke out of the clouds at 2500 ft, seeing the arpt the plt cancelled IFR. After getting rwy…Oct 11, 1983 · N30460 · DestroyedNTSB MKC84FA005Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Sullivan, MOThe acft collided with trees during an attempted go-around from a precautionary/forced landing. There were no radio calls from the pilot but evidence discovered in the engine tear down revealed internal problems. The magneto had broken and the oil pan…Oct 9, 1983 · N55008 · DestroyedNTSB LAX84LA008Accident · 1 fatalLimited investigationFinal reportJohnson Varieze · Pacifica, CADuring flt, the eng lost power. Witnesses observed the plt make a forced landing on a shoreline. The acft touched down on beach sand, the main gear separated, then the fuselage skipped along the sand/surf for about 250 yds. Before stopping, it impacted a…Oct 8, 1983 · N555EZ · Substantial damageNTSB FTW84FA014Accident · 1 fatalField investigationFinal reportCessna 195B · Alanreed, TXA recovered flt log indicated a route of flt via tulsa, OK; klahoma city,OK; sayre,OK; amarillo, TX; then tucumcari,NM. While taxiing for takeoff at the departure arpt, the plt received a wx briefing along the route to Oklahoma city. The accident site was 44…Oct 8, 1983 · N3048B · DestroyedNTSB DEN84FA019Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Kim, COThe acft collided with the ground in a wing down nose low attitude. The plt had been advised that VFR flt was not recommended for his route of flt. The non-instrument rated plt went anyway and encountered weather. In maneuvering to get below or out of the…Oct 8, 1983 · N2174M · DestroyedNTSB MIA84FA004Accident · Serious injuriesField investigationFinal reportSikorsky S-61N · West Palm Beach, FLWhile descending for a landing there was a separation of an outboard section of the main red rotor blade. An old crack was noted & the fracture was attributed to high stress low cycle fatigue damage initiating from corrosion pitting.Oct 7, 1983 · YV323 · DestroyedNTSB FTW84LA018Accident · No injuriesLimited investigationFinal reportCessna 182M · Aline, OKBefore departing norman, OK, the plt obtained a wx briefing from the Oklahoma city fss. During that briefing, he was advised that VFR flt was not recommended. He then took off for dodge city, KS without filling a flt plan. However, en route, he encountered wx…Oct 7, 1983 · N91620 · Substantial damageNTSB CHI84LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Waupaca, WIPlt had made missed approaches at wausau & mosinee. Plt informed artc that he had a fuel problem. While receiving vectors to Waupaca arpt the eng quit & the acft crashed into trees. Total time of flt was 4+33. The right tank fuel filler cap was loose & the…Oct 7, 1983 · N7695J · Substantial damageNTSB CHI84LA012Accident · No injuriesLimited investigationFinal reportCessna 172E · Cincinnati, OHThe acft collided wih a pole and mail boxes during a forced landing after fuel exhaustion. The pilot was unalbe to find blur ash arpt and asked for assistance from Cincinnati approach. When the arpt was located after over 6 hours of flt time,the acrt ran out…Oct 7, 1983 · N5728T · Substantial damageNTSB ATL84LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Vicksburg, MSThe acft landed short of the rwy during a forced landing after the engine lost power during cruise flt. The plt reportedthat power was lost at 2000 ft 10 miles north of Vicksburg. He applied the fuel boost pump and successfully restarted the eng but it quit…Oct 6, 1983 · N7691P · Substantial damageNTSB SEA84LA003Accident · No injuriesLimited investigationFinal reportCessna T210M · Seattle, WAAfter takeoff while on a right turnout from rwy 31L, & at about 1000 ft AGL, the eng quit. The plt returned to the arpt & elected to lower the gear when he knew rwy 13L could be reached. However the left main gear failed to lock prior to touchdown & the…Oct 5, 1983 · N1817M · Substantial damageNTSB SEA84FA005Accident · Serious injuriesField investigationFinal reportHordemann RV-4 · Kootenai, IDAccording to the plt he was cruising at 11500 MSL when smoke started coming from the lower forward section of the cockpit and a fire developed around his feet. The engine was shut down and the fire subsided or went out. During the glide for landing the engine…Oct 5, 1983 · N488RV · DestroyedNTSB LAX84FA005Accident · 1 fatalField investigationFinal reportCessna 175B · Burbank, CARelatives expected the plt to return home on the evening of 10/4/83. When he did not return, relatives report the acft was overdue. The acft was found where it collided with a mountain at an elevation of about 3580 ft, 10 mi north of the destination arpt.…Oct 5, 1983 · N8146T · DestroyedNTSB MIA84FA003Accident · 1 fatalField investigationFinal reportKimbal Dyke Delta JD2 · Punta Gorda, FLThe homebuilt acft was observed flying northeast ovr the east side of charlotte county arpt at abt 1000 ft. witnesses stated that the acft pitched downward and entered a spin into the ground. Wreckage examination revealed that the wing bonding material…Oct 4, 1983 · N55AK · DestroyedNTSB DEN84LA003Accident · No injuriesLimited investigationFinal reportBell 206B · Fort Bridger, WYThe acft was enroute from a powder magazine to a staging area about 2 mi away during a seismic exploration operation. The plt stated that while 100-200 ft AGL he initiated a right turn of 60 deg of bank towards a bowl formed by low lying hills to observe a…Oct 4, 1983 · N57556 · Substantial damageNTSB ATL84LA015Accident · No injuriesLimited investigationFinal reportCessna 310 · Madisonville, KYAccording to the plt, the acft was being flown on a return flt after being refueled at trenton, NJ. He reported that the acft held 100 gal of usable fuel & had consumed 70 gals on the initial flt on the same route. He reported that the ground speed & fuel…Oct 4, 1983 · N4880B · Substantial damageNTSB MIA84LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Miami, FLWhile in a descending spiral the plt stated that the cockpit filled with smoke. He proceeded to turn off the electrical master switch. Shortly aft the eng failed and the acft was ditched in 480 ft of water.Oct 3, 1983 · N4860F · DestroyedNTSB SEA84LA001Accident · No injuriesLimited investigationFinal reportBeech A23 · Burley, IDThe plt was participating in an open course air race to jackpot, NV. He planned to make an en route stop at arco, ID to refuel. The wx forcast called for marginal conditions. The plt made a telephone call to arco & confirmed that the wx (at that time) was…Oct 2, 1983 · N4773J · Substantial damageNTSB LAX84FA002Accident · 2 fatalField investigationFinal reportCessna 182M · Snow Water Lake, NVThe acft collided with the terrain in a high speed wings level descent at night after encountering weather and icing at flt level of 13000 ft. the plt was in contact with salt lake center until 5 minutes before radar contact was lost and gave no indication of…Oct 2, 1983 · N92019 · DestroyedNTSB FTW84LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Smithville, TXDuring cruise at 8,500 ft MSL the eng quit. A night emergency landing was made at an arpt that the acft had just flown over. On final approach the plt could not see thru the windshield very well due to oil building up on the windshield. The plt held the gear…Oct 2, 1983 · N2541Q · Substantial damageNTSB FTW83LA447Accident · No injuriesLimited investigationFinal reportCessna 172M · Little Rock, ARBefore takeoff, the plt visually checked the fuel. He believed there was sufficient fuel on board for the flt & reported that the fuel quantity gages agreed with his estimate. According to him, there was 25 to 30 gal of fuel on board when he took off & no…Oct 1, 1983 · N9865Q · Substantial damageNTSB CHI84LA001Accident · No injuriesLimited investigationFinal reportCessna 150 · Iron River, MIThe plt reported that the eng lost power during flt due to carburetor ice. He applied carburetor heat, but the eng would not restart. During a forced landing, the acft encounter rough/uneven terrain & subsequently nosed over.Oct 1, 1983 · N8340M · Substantial damageNTSB CHI83LA448Accident · No injuriesLimited investigationFinal reportHughes 369D · Indianapolis, INWhile the helicopter was cruising at about 500 ft AGL, the eng lost power. The plt turned into the wind & made an autorotative landing in a corn field. During the landing, the tail boom was severed by the main rotor blades. An exam revealed that the housing…Sep 30, 1983 · N5127X · Substantial damageNTSB MKC83FA225Accident · No injuriesField investigationFinal reportBeech 60 · Wichita, KSShortly after takeoff, the left eng began to progressively lose power & was shut down. The aircrew notified Beech tower of the problem & reported they would like to return & land. The acft was observed on final apch to rwy 18 with the gear extended & the left…Sep 29, 1983 · N7277R · DestroyedNTSB LAX83LA463Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Tulelake, CAThe plt reported that he made a low pass over the medicine lake area, then after circling for a few minutes, he climbed back to 7500 ft, established 2000 RPM & 70 KTS, & continued the flt. Appx 5 min later, he noticed that the trees appeared to be getting…Sep 29, 1983 · N6089F · Substantial damageNTSB CHI83LA447Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Conneaut, OHThe plt reported that while descending near his destination, the eng stopped & started 3 or 4 times, then would not restart. Just prior to that, he noted the right fuel gage indicated 8 gal & the left gage indicated 2 gal. He then landed 'in the rough' on a…Sep 29, 1983 · N4511T · Substantial damageNTSB ATL83LA384Accident · No injuriesLimited investigationFinal reportCessna 172K · Brundidge, ALWhile cruising at 2,000 ft the plt smelled fuel fumes & elected to make a precautionary landing. When within gliding distance of the arpt, he secured the eng with the mixture control & made an uneventful deadstick landing. After exiting the acft he noticed…Sep 29, 1983 · N79025 · Destroyed