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 CHI83LA154Accident · No injuriesLimited investigationFinal reportCessna 182RG · North Canton, OHThe plt reported that he had filed an IFR flt plan to youngstown, OH, with a cruise alt of 9000 ft. after passing appleton, OH, he changed his destination to the akron muni arpt. During the apch, icing conditions were encountered. The plt reported that ice on…Mar 29, 1983 · N2260T · Substantial damageNTSB LAX83LA165Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gorman, CAEncountering clouds enroute the plt descended to fly through the teton pass. After confirming a VFR check point, he commenced a climb. Shortly thereafter the acft struck a powerline.Mar 28, 1983 · N4235R · Substantial damageNTSB LAX83FVA02Accident · Serious injuriesFinal reportCessna 150F · Coulterville, CAThe pilot made two telephone calls to the fss requesting wx briefings for a VFR flt to medford, OR. He was provided with a summary of the current and forecast wx for his route and destination. He was advised that VFR flt was not recommended for that day. The…Mar 28, 1983 · N8463G · Substantial damageNTSB DEN83LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Worland, WYThe acft collided with a ditch and collapsed the landing gear during a forced landing after the engine quit during a ferry flight. The plt refueled the empty right fuel tank and topped-off the left tank with 3 gallons of fuel before the initial takeoff on the…Mar 28, 1983 · N8977D · Substantial damageNTSB MKC83FA081Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Salem, MOThe student plt departed dexter, MO at aprx dusk on a VFR, no-flt-plan flt to houston, MO. Time required for the flt would have been aprx 30 min (estimated). At 1900 CST, the bunker, MO city marshal reported that an acft flew over bunker so low that he…Mar 27, 1983 · N8611P · DestroyedNTSB LAX83LA162Accident · No injuriesLimited investigationFinal reportCessna 150G · Glendale, AZThe instructor plt (CFI) reported that while the student was practicing a full power climb, the eng began a smooth, but relatively rapid, decrease in power to about idle RPM or less. All attempts to restore power were to no avail. An emergency landing was…Mar 26, 1983 · N6319S · Substantial damageNTSB LAX83FUM05Accident · Serious injuriesFinal reportWare Teenie TWO · Escondido, CAThe eng lost power while cruising at 3000 feet. The pilot determined that the engine power loss was due to a restricted fuel line just ahead of the gascolator. A restriction of the inlet port of the gasocalator resulted from electrolytic corrosion of a steel…Mar 26, 1983 · N68127 · DestroyedNTSB LAX83FA160Accident · 1 fatalField investigationFinal reportMooney M20E · Cobb, CAThe plt had left his acft at lakeport, CA for maintenance to be performed & barrowed Mooney M20E, N2571W. Before the plt took off, the owner heard him talking to someone about the wx, but no record of a wx briefing was found. While en route to palo alto, CA,…Mar 26, 1983 · N2571W · DestroyedNTSB DEN83FA087Accident · 3 fatalField investigationFinal reportCessna T210M · Salt Lake City, UTBefore departing phoenix, AZ, the plt obtained a wx briefing, was advised of forcasted icing conditions & was informed that the Salt Lake City (slc) VORTAC was out of service. While en route, at 0931, he received a wx update. The slc wx at that time was, in…Mar 26, 1983 · N6140B · DestroyedNTSB ANC83FA059Accident · Minor injuriesField investigationFinal reportCessna T-41B (R-172E) · Healy, AKThe plt reported that while cruising at 4000 ft MSL, the eng power began to fluctuate, then this was followed by a banging noise, rough eng operation & a decline in power output. He had turned to land into the wind when the eng power increased & stabilized.…Mar 26, 1983 · N65104 · Substantial damageNTSB LAX83LA157Accident · No injuriesLimited investigationFinal reportCessna 401 · Near Globe, AZThe pilot was cruising at 13000 feet MSL on a cross country when the engines lost power. The pilot had been using fuel from the main tanks for about 10 minutes after being on the aux. Tanks for the previous hour. The pilot restarted both engines on the aux.…Mar 24, 1983 · N401G · Substantial damageNTSB LAX83FA166Accident · 3 fatalField investigationFinal reportBeech A36TC · Sedona, AZDuring preflt briefings, the plt was briefed to expect deteriorating wx conditions with associated flt precautions for mountain obscurement, icing & moderate turbulence. The wx briefings were complete, except due to an inoperative circuit, the 0654 prescott &…Mar 24, 1983 · N3863U · DestroyedNTSB DEN83FA084Accident · Serious injuriesField investigationFinal reportCessna 182 · Huntsville, UTThe afct collided with a tree and crashed during a go-around. The weather was IMC and the pilot and passenger were seriously injured. The pilot received a weather briefing and was told that VFR flt, on his intended route, was not recommended due to low…Mar 24, 1983 · N9377X · Substantial damageNTSB DCA83AA022Accident · 4 fatalFinal reportMitsubishi MU-2B-60 · Jeffersonville, GAThe acft was on the return portion of a round trip flt, hauling canceled bank checks. When they boarded before takeoff, the plt's wife, who was not a plt, occupied the r front seat & his 2 daughter's, ages 4 & 6, were in the passenger seats. Previous legs of…Mar 24, 1983 · N72B · DestroyedNTSB FTW83LA165Accident · No injuriesLimited investigationFinal reportBeech 200 · High IslandThe pilot stated that he was being vectored around thunderstorms when severe turbulence was encountered. The pilot was attempting to penetrate a line of thunderstorms about four mile wide when the turbulence was encountered. The course of penetration was…Mar 23, 1983 · N417EM · Substantial damageNTSB FTW83FA164Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Salt Flat, TXBefore departing tucson, the plt was advised of 2 marginal wx systems along his route. He took off at 1038 MST. At 1130,he contacted ATC & reported at 13,800'. From then until 1214, his alt varied between 10,000' & 16,000'. Radar contact was lost at 1228…Mar 23, 1983 · N8652P · DestroyedNTSB LAX83FA154Accident · 1 fatalField investigationFinal reportBell 206 B III · Salinas, CAPurpose of flt was to transport a technician & his equipment to a mountain top to service a microwave antenna site. Cloud coverage precluded a landing at the site, but the plt was able to land in a clearing on the eastern ridge line about 100 yds below the…Mar 22, 1983 · N8163J · DestroyedNTSB CHI83LA150Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee 28-5ACF · Neilsville, WIThe aircraft was crash landed in an open field after it had a power loss on #1 engine during cruise flight. The aircraft was on a geodetic survey flight which called for flight at 500 feet AGL. The pilot elected to land because the aircraft could not maintain…Mar 22, 1983 · N4760C · Substantial damageNTSB NYC83IA080Incident · Minor injuriesIncident investigationFinal reportBritten-Norman BN-2 Mark III · Blue Bell, PAA deicer boot on a right propeller blade separated. It struck & broke a window. A tie strap was missing. There was no evidence of improper or inadequate bonding.Mar 21, 1983 · N420WA · Minor damageNTSB LAX83FA153Accident · 2 fatalField investigationFinal reportCessna 170B · Near Pala, CAAccording to a friend of the plt, he (the plt) had watched wx infor on tv, on 3/20/83. To the friend's knowledge, the plt had never telephoned the FAA fss for a wx briefing or to file a flt plan. After the friend took the plt & his wife (who was also a plt)…Mar 21, 1983 · N2462D · DestroyedNTSB LAX83LA151Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Marana, AZThe acft nosed over during an emergency landing in an open field. The weather was VMC and no flt plan was filed. The pilot reported that during the ferry flt he flew past his destination arpt by misreading his sectional chart. Shortly after this he reversed…Mar 20, 1983 · N59496 · Substantial damageNTSB ATL83FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Crossville, TNThe aircraft crashed into hinch mt at the 2700 foot level during cruise flt in IMC weather. The pilot was informed during the initial and subsequent briefings that VFR flt was not recommended for his route. The first leg of the flight from new orleans to…Mar 20, 1983 · N9600W · DestroyedNTSB MIA83LA097Accident · No injuriesLimited investigationFinal reportStinson 10A · Defuniak Spring, FLThe engine failed in cruise at 4500 ft MSL. The weather was clear and the pilot could see the airport but did not try for it because of the intervening town. During the landing over wires the landing gear and wings were damaged. The pilotreported that there…Mar 19, 1983 · N32260 · Substantial damageNTSB MIA83IA098Incident · No injuriesIncident investigationFinal reportCessna 402C · Near Taylor, FLA propeller blade separated due to a fatigue failure.Mar 19, 1983 · N65PB · Minor damageNTSB LAX83FA387Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Trinity Center, CAThe acft departed creswell, OR, sometime after 1800 PST on 3/19/83. At 2110 PST, the plt contacted portland flt watch by radio & stated that he was over roseburg, or at 9500 ft. he requested pireps of wx over the siskiyou mountains & into the san francisco…Mar 19, 1983 · N41576 · DestroyedNTSB SEA83FA065Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Longview, WASeveral persons saw the helicopter flying at a cruising altitude of about 200 to 300 ft, then enter a loop type of maneuver. They lost sight of the helicopter near the bottom of the maneuver before it crashed. The plt received serious head injuries & could…Mar 18, 1983 · N26631 · DestroyedNTSB FTW83LA162Accident · No injuriesLimited investigationFinal reportBeech D-18S · Dfw Airport, TXN80017 experienced engine trouble and shut down the left engine enroute from amarillo, TX. Later, because of electrical problems the pilot secured all electrical equipment except the no. 2 radio, transponder and rotating beacon after landing, the pilot taxied…Mar 18, 1983 · N80017 · 2 aircraft · Substantial damageNTSB FTW83LA160Accident · No injuriesLimited investigationFinal reportBeech K35 · Torreon, NMThe pilot, who was not certificated, stated that prior to departure he received a wx briefing by telephone from the fss. Enroute, after making several heading changes to avoid wx he found himself surrounded by low ceiling and precipitation. He decided to make…Mar 18, 1983 · N5395E · Substantial damageNTSB CHI83LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA24-260 · Mansfield, OHDuring cruise flt at 8000 ft MSL, the eng lost oil pressure. The plt stated that smoke entered the cockpit & sparks were seen in the cowling area. Shortly after that, the eng seized. Radar vectors were obtain to the closest arpt; however, the plt was unable…Mar 18, 1983 · CGQYP · Substantial damageNTSB LAX83IA147Incident · No injuriesIncident investigationFinal reportDouglas DC-9-10 · Salt Lake City, UTDuring climb to 28,000 ft at 20,000 ft the auto-pilot disengaged and the crew reported that they could not move the control column to control pitch. The acft was operating in icing conditions at the time. The crew landed the acft by utilizing the trim control.Mar 17, 1983 · N9356 · No damageNTSB MKC83IA078Incident · No injuriesIncident investigationFinal reportAero Commander 680W · Kansas City, KSThe number 2 engine failed in cruise flight. Durng descent the landing gear failed to extend. The pilot landed intentional gear up in the sod area adjacent to the runway.Mar 16, 1983 · N200DT · Minor damageNTSB CHI83LA140Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Princton, MNThe pilot said that at 6000 feet MSL the engine began to miss and got worse. He tried to correct the situation but could not. He requested and was given vectors to the princeton arpt. The arpt was closed at the time due to snow covered ruts on the rnwy and…Mar 16, 1983 · N10HR · Substantial damageNTSB MKC83FA076Accident · 2 fatalField investigationFinal reportRobinson R-22 · St. Louis, MOThe helicopter was observed by several witnesses flying at 200-300 feet above the Mississippi river. As it wobbled and buffeted and rolled to the right. It was spinning and the tail rotor separated shortly followed by an explosion with a blueish/white smoke…Mar 14, 1983 · N9024Z · DestroyedNTSB LAX83FA138Accident · 2 fatalField investigationFinal reportMooney M20J · Chatsworth, CAThe acft collided with powerlines 177 AGL during flt in adverse weather. About 2 miles from the site of the powerline collision the acft had collided with hilly terrain about 500 ft higher than the powerline. The pilot had received a weather briefing and…Mar 14, 1983 · N8201V · DestroyedNTSB LAX83FVD06Accident · Minor injuriesFinal reportBell 206B · Escalon, CAThe helicopter collided with a small tree about 8 ft high during a forced landing at night after a power loss. The collision broke the tail boom and a hard landing caused the failure of a landing skid and damaged the main rotor. The plt had taken two friends…Mar 13, 1983 · N90329 · Substantial damageNTSB DEN83LA079Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Coalville, UTThe acft nosed over during an precautionary landing due to deteriorating weather. The plt had received a weather briefing. The wx conditions deteriorated enroute due to a snow storm and the plt elected to land on a private strip to await improved weather. The…Mar 13, 1983 · N3743M · Substantial damageNTSB CHI83FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Danvers, ILThe aircraft crashed at night during IMC weather conditions on the return portion of a cross-country. The pilot had checked the weather outbound, but there was no record of a briefing for the return flight. The outbound flt was in early dusk. The return was…Mar 13, 1983 · N82026 · DestroyedNTSB ANC83FAG05Accident · Minor injuriesFinal reportPiper PA 28-140 · Chugiak, AKThe flt originated at anchorage, AK at aprx 1400 ast. While flying in the vicinity of knik glacier, some sheep were observed & the plt circled in the area 2 times. During the 2nd turn, the engine began running erratically. Reportedly, the plt applied…Mar 13, 1983 · N1642J · Substantial damageNTSB LAX83FA141Accident · 2 fatalField investigationFinal reportRyan Navion A · Fiddletown, CAThe acft crashed into hilly terrain while descending to enter the traffic pattern at the rancho murieta airport. The pilot had called sacramento fss to get assistance in locating this arpt which is about 11 NM from sacramento VOR on a bearing of about 65…Mar 12, 1983 · N444N · DestroyedNTSB MKC83LA079Accident · No injuriesLimited investigationFinal reportRotec Rally 3 · Ultsses, KSThis amateur-built aircraft was being flown at 200 feet AGL on a pleasure flight when the engine quit. The pilot made a forced landing in a soft field and the aircraft nosed over. The engine quit because the fuel cap was not vented. The capwas supplied with…Mar 11, 1983 · N110RE · Substantial damageNTSB LAX83IA140Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC 8-61 · Mina, NVWhile established in a normal climb to curising altitude the#1 engine failed due to a failure of the first stage compressor wheel. The acft then diverted to reno NV and landed without further incident.Mar 11, 1983 · N8076 · Minor damageNTSB LAX83LA132Accident · No injuriesLimited investigationFinal reportCessna 150G · Oakland, CAThe student plt was on a solo x-country flt from haymond, CA to sonoma & grass valley, CA, then return to hayward. She reported that the en route time on the 1st 2 legs of the flt were increased slightly due to the wx. The acft was not refueled at either of…Mar 10, 1983 · N4025J · Substantial damageNTSB LAX83LA131Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Palm Springs, CAThe pilot had departed riverside with an estimated 28 gallons of fuel, 23 gallons in the left tank and about 5 gals in the right. He flew to Palm Springs on the left tank and began to let down from 11,500 feet. At 7,000 ft the engine quit. The pilot called…Mar 10, 1983 · N1766U · Substantial damageNTSB FTW83LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Martinsville, TXReportedly, the plt took off with 36 gallons of fuel on board, of which, 10 gals was automobile low lead fuel. The automobile fuel had been purchased from an off airport gasoline station, was transported to the acft in 5 gal cans, then added to the fuel tanks…Mar 10, 1983 · N4944M · Substantial damageNTSB ATL83FA133Accident · Minor injuriesField investigationFinal reportGrumman American AA-1B · Chesapeake, VAThe plt took off on rwy 4 & made a climbing left turn for a downwind departure. At aprx 900 ft, there was a partial loss of power to about idle RPM. The plt stated that he switched fuel tanks, applied carburetor heat & pumped the throttle, all to no avail. He…Mar 10, 1983 · N6266L · Substantial damageNTSB MIA83LA090Accident · No injuriesLimited investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe acft was ditched in the atlantic ocean following engine failure. The pilot estamated fuel on board during pre-flightfrom the electronic fuel gauges. The acft flew 2 hrs and 16 minutes before the engines quit in a mode of fuel exhaustionwith surging prior…Mar 9, 1983 · N26506 · DestroyedNTSB LAX83LA129Accident · No injuriesLimited investigationFinal reportCessna 177B · Arvin, CAWhile descending to land, the eng sputtered & quit. According to the plt, the fuel gages indicated the left tank was 1/4 full & the right tank was 1/8 full when the eng lost power. During an emergency landing on a roadway, the acft collided with poles & wires…Mar 9, 1983 · N35105 · Substantial damageNTSB LAX83FA144Accident · 2 fatalField investigationFinal reportCessna U2061 · Pt Reyes, CAThe Cessna U2061, purchased that day by the occupants, collided with trees on a hillside 10 miles from pt. Reyes, CA. An eyewitness observed the aircraft flying into worsening weather at 500 AGL or lower under a thin cloud layer in the olema valley. During…Mar 9, 1983 · N1456M · DestroyedNTSB FTW83FA144Accident · 1 fatalField investigationFinal reportCessna 172N · Mayflower, ARThe acft collided with trees while flying in a westerly direction near Mayflower, AR. The acft was returning from a cross-country at night and was observed by a group of youths who said it was flying fast at low alt. As they watched, it descended to about…Mar 8, 1983 · N4505E · DestroyedNTSB SEA83FA113Accident · 2 fatalField investigationFinal reportCessna 182Q · Mccall, IDThe acft impacted a rocky slope of a box canyon at the 6300 foot level. The weather was reported to be IMC with thunderstorms, overcast skies and the mountain tops obscured. The wreckage location was on a direct line between departure point and destination.…Mar 7, 1983 · N735VD · Destroyed