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 MIA83FA146Accident · Serious injuriesField investigationFinal reportCessna 210N · Avon Park, FLAbout 40 min after takeoff the plt reported he was having eng problems & requested radar vectors to the nearest arpt. He was given a 215 deg vector to Avon Park arpt, located about 11 mi sw. The plt stated he had the arpt in sight. Duringthe approach the acft…May 26, 1983 · N6190N · DestroyedNTSB CHI83IA228Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Clarion, PADuring descent in turbulence the crew noted all 3 engines were overtempting and experiencing compressor stalls. Attemptsto reduce throttles did not reduce the temperatures. No 183 engines were shut down. During diversion to a close airport the engines were…May 26, 1983 · N154US · No damageNTSB SEA83LA107Accident · No injuriesLimited investigationFinal reportBeech V35-TC · Wendling, ORThe acft collided with trees and dense brush during an off airport forced landing in IMC weather. According to the pilothe was about 10 minutes into a cross country flight at 4000 feet MSL when fuel pressure dropped and he lost engine power. The pilot…May 25, 1983 · N7980M · DestroyedNTSB LAX83LA248Accident · Minor injuriesLimited investigationFinal reportEnstrom 280C · Goshen, CAAbout 5 min after taking off, the plt noticed a sudden loss of power to the tail rotor. He made an emergency landing in an alfalfa field. He reported that during an autorotative landing, he had insufficient collective to flare properly. Subsequently, the main…May 24, 1983 · N51763 · Substantial damageNTSB LAX83FA242Accident · 1 fatalField investigationFinal reportSchempp-Hirth Standard Cirrus · Bridgeport, CATwo Schempp-Hirth gliders, N184N & N6482, were being flown in a x-country contest along a triangular course. The course started at minden, NV & went to schurz, NV & Bridgeport, CA, then back to minden. The plts of both gliders had participated in contests for…May 22, 1983 · N184N · 2 aircraft · Substantial damageNTSB DEN83FA116Accident · 2 fatalField investigationFinal reportCessna 172P · Lander, WYAt noon on 5/21/83, the plt departed riverton, WY on a flt to ogden, ut to transport a minister back to riverton for a wedding. After arriving at ogden, he obtained a wx briefing for the return flt. He was warned of possible thunderstormactivity, turbulence,…May 22, 1983 · N54609 · DestroyedNTSB ATL83FA198Accident · 4 fatalField investigationFinal reportBeech V35B · Chesson, ALWhile the acft was on a x-country flt at 4000 ft MSL, radio & radar contact were lost soon after a turn was initiated. Wreckage of the aircraft was found scattered over a distance of 2193 ft. an exam of the wreckage revealed that the stabilizers/ruddervators,…May 22, 1983 · N313ZM · DestroyedNTSB ANC83FA080Accident · No injuriesField investigationFinal reportCurtiss-Wright C-46F · King Salmon, AKThe coplt reported that the acft had been in level cruise flt aprx 1 min when they felt a vibration, followed by a loud bang. The aircrew saw fire & smoke coming from the left eng, so they shut down the eng & feathered the propeller. The plt also activated…May 21, 1983 · N1822M · Substantial damageNTSB NYC83LA123Accident · No injuriesLimited investigationFinal reportCessna 180H · Greenville, METhe wx was estimated at 2,000 to 2,500 ft overcast when the flt departed Greenville at 1820. Horseshoe pond is 1,500 ft MSL & surrounded by 2,700 ft mountains. As the acft approached the pass the pond was visible. However a south wind prevailed & fog had…May 20, 1983 · N9052M · Substantial damageNTSB NYC83FA122Accident · Serious injuriesField investigationFinal reportCessna 172N · N. Stonington, CTThe acft collided with a tree during a go-around at night following a downwind precautionary landing. During the flt the plt had noted the fuel gauges at low readings and said he suspected a 'fuel leak'. He made radio calls to try to go to an arpt before fuel…May 20, 1983 · N4980G · DestroyedNTSB NYC83FA121Accident · 1 fatalField investigationFinal reportMooney M-20K · Old Lyme, CTThe acft collided with the ground in IMC after the plt reported he lost his vacuum instruments. The flt originated at mattituck, NY with a destination of lebanon, NH. After departure the plt was cleared to climb to 7000 ft. the instrumentrated pilot was on an…May 20, 1983 · N231HT · DestroyedNTSB FTW83LA242Accident · No injuriesLimited investigationFinal reportCessna 150 · Covington, TXAt about 400 ft AGL after takeoff the eng quit. The acft collided with the ground avoiding power lines. The plt attributed the eng failure to water in fuel.May 19, 1983 · N10069 · Substantial damageNTSB FTW83FA238Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Venice, LAThe acft crashed into a swamp with low rotor RPM after a failure of the accessory gearbox power output gear. The pilot radioed an emergency call saying he was experiencing severe vibrations and was landing. A few seconds later, he radioed that he was…May 18, 1983 · N36062 · DestroyedNTSB CHI83LA221Accident · No injuriesLimited investigationFinal reportCessna 152 · Detroit, MIThe acft made a forced landing off airport and collapsed the rt main landing gear during a landing on a street after theengine quit. Investigation revealed that the acft was filled with fuel for 2 afternoon flights and not refueled afterwards. During the…May 18, 1983 · N67880 · Substantial damageNTSB MIA83FA143Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Near South Bay, FLThe plt had recently purchased the acft & was using it to commute on a weekly basis between his residence in hialeah & la belle where he worked as an acft mechanic. The wreckage was found completely submerged in a canal after a Florida fish & game official…May 17, 1983 · N8235N · DestroyedNTSB DEN83FA114Accident · 1 fatalField investigationFinal reportPiper PA-28R · Burns, WYBefore departing, the plt received a wx briefing & was advised that VFR flt was not recommended thru western Nebraska & eastern Wyoming. A frontal wx sys was forcasted to produce thunderstorm activity with associated turbulence & rain. Reportedly, the plt was…May 17, 1983 · N33066 · DestroyedNTSB NYC83FA115Accident · No injuriesField investigationFinal reportBeech BE60 · Robbinsville, NJThe acft was structurally damaged during recovery from a descending right spiral that occurred as the flt passed thru flt level 190. As the plt recvd from the descending spiral the inboard and outboard aileron hinge rivets were sheared. The altitude deviation…May 16, 1983 · N821BE · Substantial damageNTSB LAX83LJA07Accident · No injuriesFinal reportGrumman AA-1C · Kauai, HIThe acft descended at a flat angle under power into trees after the engine lost power. The pilot took off at 1010 for a sightseeing flight. The temperature was 78 and the dew point was 65 degrees f. after about 30 minutes of flight the pilot turned to avoid…May 15, 1983 · N39019 · DestroyedNTSB LAX83FU004Accident · Serious injuriesFinal reportEipper Quicksilver MX · Lakeside, CAAfter takeoff, the plt encountered clouds in a mountainous area. She elected to fly above the clouds, but had difficulty finding an opening for a descent. After eventually finding an opening, she descended below the clouds, but found she was in an unfamiliar…May 15, 1983 · UNREG · DestroyedNTSB SEA83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-25-235B · La Grande, ORThe acft stalled about 30 feet AGL during a forced landing after the engine quit from fuel exhaustion. The pilot took the acft for a ferry flight without refueling. It had been flown about 1 hour & 15 minutes. It holds about 36 gallons and burns about 14…May 14, 1983 · N7757Z · DestroyedNTSB NYC83IA113Incident · No injuriesIncident investigationFinal reportCessna 402C · Boston, MAWhile in level flight a Cessna 402 passed behind an Airbus A-300 in descent for landing. The Cessna 402 rolled inverted. The pilot regained control and landed without further incident at his destination. Both acft were on instrument flight plans, in…May 14, 1983 · N6791Y · No damageNTSB LAX83LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Duckwater, NVThe acft collided with the terrain after descending to 600 ft AGL and encountering a weather phenomenon which prompted an airspeed decay and uncommanded loss of altitude. Two other acft in the flt of 3 experienced the same phenomenon to a lesser degree…May 14, 1983 · N9951H · Substantial damageNTSB FTW83LA234Accident · No injuriesLimited investigationFinal reportBeech TC-45G · Abilene, TXAbout 30 mi east of Abilene there was a partial loss of power on the left eng. The plt feathered the prop & made an emergency approach into Abilene. Unable to hold initial approach altitude, the plt restarted the left eng, but could obtain only partial power.…May 14, 1983 · N63310 · Substantial damageNTSB NYC83FA110Accident · Serious injuriesField investigationFinal reportGrumman American AA5B · Bedminster, NJThe acft crashed into trees during a forced landing after a loss of power while enroute from white plains. The engine started to shake and the rpms decreased. The plt initiated emergency procedures but the engine continued to run roughly.a decision was made…May 13, 1983 · N28426 · Substantial damageNTSB DEN83FA111Accident · No injuriesField investigationFinal reportPiper PA28R-201T · Aurora, COThe plt received a jump start because the battery failed to start the eng. After departure & leveling of at 10,000 ft, he was concerned with the 1 inch of rime ice he had picked up & got an updated wx briefing from flt watch. He asked for & received a…May 13, 1983 · N2943Z · Substantial damageNTSB CHI83FA213Accident · 1 fatalField investigationFinal reportMooney M-20-J-201 · Bloomington, ILPrior to the accident, a witness heard the acft, then saw it for a short time thru an opening in the clouds. In his opinion, it was heading directly into a thunderstorm, which concerned him. He said that rain was falling, and about 10 min later, the…May 13, 1983 · N201GG · DestroyedNTSB MKC83IA109Incident · No injuriesIncident investigationFinal reportCessna 441 · Arkansas City, KSThe pilot experienced elevator control problems and made an emergency landing on an abandoned airstrip. The elevator trim cable had come off of the electric trim servo drum and was tangled in the auto pilot. An unrelated fire destroyed the aircraft. Post fire…May 12, 1983 · N36962 · Minor damageNTSB ATL83AA184Accident · 3 fatalFinal reportAero Commander 680 · Titusville, FLWitnesses saw the acft briefly before it crashed. One witness saw the acft flying toward a dark cloud at an unknown alt, but too high to fly under it. Shortly thereafter, he heard the eng noise increase & decrease, then increase until it was loud. He then…May 12, 1983 · N6880S · DestroyedNTSB NYC83FNA02Accident · No injuriesFinal reportRogers Long EZ · Fall River, MAThe plt reported that during flt, the eng lost power. He moved the carburetor heat control to apply carb heat & tried to start the eng, but was unable. He then tried to land on a road, but crashed in a wooded area before reaching the roadway. An investigation…May 11, 1983 · N245R · Substantial damageNTSB FTW83FU001Accident · 1 fatalFinal reportRotec Rally 2B · Manvel, TXThe plt had flown the ultralight vehicle to his employer's house & landed in the back yard. During the landing, the vehicle sustained damage which included a bent main landing gear axle, a sheared kingpin bolt & a cracked tail boom to tailmount sleeve. A…May 8, 1983 · UNREG · DestroyedNTSB ATL83FA179Accident · 2 fatalField investigationFinal reportCessna C-150H · Fort Valley, GAAfter a touch-and-go landing, the aircraft was observed to turn after takeoff, enter a steep climp, then go into a steep nose down descent & crash. Witnesses reported hearing the eng operating until just prior to impact. An exam of the acft & eng revealed no…May 7, 1983 · N7146S · DestroyedNTSB LAX83LA221Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mohave County, AZAfter flying at an altitude of 300-500 feet for about 45 minutes the pilot intentional landed on a dirt road and inquired about directions to their intended destination. The person the pilot spoke to said she saw the acft become airborne but it was flying…May 6, 1983 · N714VK · Substantial damageNTSB LAX83LA220Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Parker, AZThe acft collided with a tree during an off arpt precautionary landing after the engine 'started running rough.' The pilot described a surging condition and utilized the term 'sputtering' to characterize the engine sound. During the investigation about 1 1/2…May 6, 1983 · N94762 · DestroyedNTSB DEN83LA109Accident · Minor injuriesLimited investigationFinal reportBeech C-50 · Nephi, UTThe acft collided with rocks and sagebrush during a forced landing after the engine lost power. The acft encountered induction and airframe icing during cruise. The pilots weather briefing forecast the icing which he encountered. The briefing took place about…May 6, 1983 · N322V · Substantial damageNTSB CHI83IA209Incident · No injuriesIncident investigationFinal reportAero Commander 500B · Youngstown, OHWhile cruising at 5000 ft MSL, the plt heard a 'very loud bang' & noted 'very much vibration from the left eng.' He shut down & feathered the left eng & prop. When the eng stopped turning, he noted 1 prop blade was missing. The acft was landed without further…May 6, 1983 · N6178X · Minor damageNTSB ATL83LA180Accident · No injuriesLimited investigationFinal reportEippen MX-2 · Raleigh, NCThe acft nosed over during a forced landing after the engine failed. Examination of the engine after the accident revealed that the #2 cyl piston was badly scored. The cyl. Head temperature gauge read 100 deg lower than the actual temperature. Epoxy sealant…May 6, 1983 · N242KH · Substantial damageNTSB MIA83AA136Incident · No injuriesFinal reportLockheed L-1011 · Miami, FLThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-84/04. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm…May 5, 1983 · N334EA · No damageNTSB CHI83LA196Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Logansport, INThe plt had recently purchased the amphibious acft, had received 6.7 hrs dual instruction & was indorsed for solo flt. During a x-country from elizabethton, TN, he landed at richmond, KY & purchased 23. 8 gal of fuel. On the next leg to lafayette, IN, he made…May 5, 1983 · N533H · DestroyedNTSB MKC83LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Cape Girardeau, MOThe pilots were participating in a grand prix air race. After a normal preflight, they took off & crossed over the arpt for race timing purposes. A climb was begun on course, and a short time later, the engine began loosing power. The aircrew turned back…May 4, 1983 · N1996E · Substantial damageNTSB LAX83LA217Accident · Minor injuriesLimited investigationFinal reportMaule M4-210 · Hesperia, CAThe acft made a hard landing off the runway on an airport during a forced landing. According to the pilot the acft had just come out of annual inspection and it was noted that the fuel selector valve handle was broken. A new valve was ordered and a temporary…May 4, 1983 · N4624T · Substantial damageNTSB LAX83LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Milpitas, CAWhile descending thru 4300 ft, the eng lost power. The plt made an emergency landing on a gulf course, but during the landing roll, the right wing of the acft impacted a pole & was damaged. An exam revealed that the 5/16 inch bolt, pn STD-847, that secured…May 3, 1983 · N40755 · Substantial damageNTSB DEN83FA108Accident · 1 fatalField investigationFinal reportPiper 28-180 · Alpine, WYThe acft collided with mountainous terrain in IMC weather. The pilot had been briefed on the weather. Part of the observation called for mountain obscuration by clouds or precipitation. A person who resides in Alpine, WY said the mountain tops were obscured…May 3, 1983 · N7295W · DestroyedNTSB FTW83LA215Accident · 2 fatalLimited investigationFinal reportCessna 177B · Port Aransas, TXDuring a wx briefing, the non-instrument rated plt was told to expect no significant en route wx, but was advised of lower ceilings along the coastline, later that night. There were no records of en route wx briefings. When the acft was about 40 mi northwest…May 2, 1983 · N34581 · DestroyedNTSB ATL83FA174Accident · 2 fatalField investigationFinal reportPiper PA 32RT-300T · Murfreesboro, TNThe acft crashed in an open field after an in-flt fire. The fire started while the acft was cruising. No emergency callswere made and the engine which was the fire source was not shut down. A rear seat passenger said he tried to open a reardoor to let out…May 2, 1983 · N22011 · DestroyedNTSB MKC83FA098Accident · 4 fatalField investigationFinal reportPiper PA-34-200T · Stover, MOThe acft crashed into a wooded area in a high speed descent on a dark and stormy night. The pilot had telephoned the st. louis fss on 04/30/83 and requested Kansas city weather. The weather briefer advised the pilot that the area was in a tornado watch. The…May 1, 1983 · N1091X · DestroyedNTSB LAX83LA210Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Linden, CAThe pilot was cruising at 3000 feet beneath an overcast sky with intermittent rain. The carb heat was off. After about 20 minutes of flight the RPM began to slowly decrease. The pilot briefly applied carb heat but as the RPM only fluctuated and power was not…May 1, 1983 · N36986 · DestroyedNTSB FTW83LA227Accident · No injuriesLimited investigationFinal reportCessna 182P · Lonoke, ARThe eng quit after takeoff. The acft crashed in a wheat field while returning to the arpt. The carb was found full of water. The acft salvage operator reported finding a large quantity of water in the bladder-type fuel cells.May 1, 1983 · N7044Q · Substantial damageNTSB NYC83FFJ02Accident · No injuriesFinal reportGrumman G-164A · Clarkson, NYThe pilot was diverting from the arpt of departure to an alternate arpt because of the severe weather. The turbulence encountered was so severe, according to the pilot's statement, that he lost control of the acft. Partial control was regained but too late to…Apr 30, 1983 · N5309 · Substantial damageNTSB LAX83FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Redlands, CABefore flying, the plt told the FBO that he would stay in the local Redlands/riverside, CA area. However, after taking off, he flew to las vegas, NV. He departed las vegas at 1636 PDT. When he did not return to Redlands, a search was initiated. The wreckage…Apr 30, 1983 · N9233K · DestroyedNTSB ATL83LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140C · Lynchburg, VAShortly after midnight on the morning of 4/30/83, the flt originated at blacksburg, VA. Neither the time en route nor the arrival time at gaithersburg, MD was reported. According to the plt, he departed from gaithersburg at 1050 EDT. The flt was normal until…Apr 30, 1983 · N5286S · Substantial damage