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 CHI83LA130Accident · No injuriesLimited investigationFinal reportCessna T-210L · Farmington, MNDuring an IFR flight, the engine lost power at 4000 ft MSL and the pilot was unable to restart the engine. He broke out of the clouds at a low altitude in the vicinity of a lake that was covered with ice. The pilot did not know the condition of the ice, so he…Mar 7, 1983 · N732CJ · Substantial damageNTSB DEN83FA072Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Evanston, WYWhen en route, the acft collided with power lines where they crossed over a highway about 39 ft AGL. Two witnesses near this location reported that the acft was flying low & was following the highway on a westerly heading when the acft struck the wires. The…Mar 6, 1983 · N8406F · Substantial damageNTSB DEN83FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Lake Powell, UTThe acft was seen to fly erratically before plunging into the lake during an landing attempt. Investigation revealed a history of pre-existing medical problems that could lead to 'a convulsive episode with accompanied loss of consciousness.' An examination of…Mar 6, 1983 · N96460 · DestroyedNTSB DEN83FA070Accident · 1 fatalField investigationFinal reportCessna 172 · Limon, COThe acft crashed in a snow covered field during IMC weather. Witnesses heard and saw an acft flying low in the area of the accident just before the crash. There are no known witnesses to the actual crash. The acft was discovered several hours later by a snow…Mar 6, 1983 · N84822 · DestroyedNTSB ATL83FA128Accident · 3 fatalField investigationFinal reportCessna 310 · Hopkinsville, KYThe plt obtained a wx briefing & filed a flt plan from lexington to paducah,KY with a 15 min en route stop at bowling green, KY. While inbound to bowling green, he reported that the cloud base was at aprx 6000 ft & that there was lightning to the west. After…Mar 6, 1983 · N923CA · DestroyedNTSB ANC83IA053Incident · No injuriesIncident investigationFinal reportCessna 401 · Bethel, AKThe acft right engine started emitting sparks from the cowling during normal cruise. The pilot noted a drop in manifold pressure so he reduced power on that engine and the sparks stopped. The acft was landed at Bethel. The fire dept. Used a fire extinguishing…Mar 6, 1983 · N7864F · Minor damageNTSB FTW83LA139Accident · Minor injuriesLimited investigationFinal reportBeckner FW-3 · Victoria, TXThe plt was on a test flt in his home built experimental acft. While he was returning to the airport about 45 min after takeoff, the engine lost power. A forced landing was made in a muddy field where the acft nosed over. After the accident, about 1/2 gal of…Mar 5, 1983 · N2762J · Substantial damageNTSB FTW83FA142Accident · 1 fatalField investigationFinal reportCessna 210-5 · Orange Grove, TXThe plt was believed to have departed hebbronville muni arpt at about 0500 CST. When the acft failed to arrive at its destination, a search was initiated. The wreckage was found where it crashed in an area of mesquite trees & brush, about halfway between the…Mar 4, 1983 · N8270Z · DestroyedNTSB SEA83FA058Accident · 1 fatalField investigationFinal reportCessna 140 · Moses Lake, WAThe flight originated at the pilots private farm strip. The pilot stated that during the flight the engine 'sputtered and died'. During a power off landing attempt the passenger grabbed the controls according to the pilot. The pilot said he fought for control…Mar 3, 1983 · N89050 · DestroyedNTSB MKC83LA074Accident · No injuriesLimited investigationFinal reportCessna 182G · Chadron, NEThe engine stopped when the acft was within 10 miles from the destination airport. The pilot stated that he had the fuel valve to the 'both position' when the engine sputtered and stopped. He says he pulled on carburetor heat, switched fuel tanks, then…Mar 3, 1983 · N2445R · Substantial damageNTSB FTW83LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Killeen, TXThe acft was on the return leg of an out-and-back, night, cross-country flt. The acft had 26 gal of fuel on board when it departed Killeen, TX. Reportedly, there was 18 gal on board when it took off from dallas, TX. The flt was initially conducted in VFR…Mar 3, 1983 · N6396Q · Substantial damageNTSB MIA83LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · San Juan, PRThe acft was ditched in a lake near San Juan following engine failure due to fuel exhaustion. The pilot had rented the acft for a round trip to st. thomas. The accident occurred on the return flt to San Juan. It was reported that only residual fuel was found…Mar 2, 1983 · N60913 · Substantial damageNTSB FTW83LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Shiro, TXWhile on a solo cross-country, the student plt became disoriented on the 3rd leg of the flt. He reoriented himself, but the eng lost power before he reached his intended destination. During an emergency landing, the acft encountered soft terrain & was damaged…Mar 2, 1983 · N2381K · Substantial damageNTSB FTW83LA136Accident · No injuriesLimited investigationFinal reportBellanca 7FC · Lake City, ARThe plt reported that during level flt, the eng lost power. He tried to land in an open field, but the acft struck a tree top aprx 35 to 40 ft AGL, then crashed on the ground, right wing first. The plt suspected possible carburetor ice. The temp & den point…Mar 2, 1983 · N7535B · Substantial damageNTSB MIA83FA082Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Brooksville, FLThe acft disappeared from radar during descent from 4000 ft MSL to 2000 ft MSL. Investigation revealed SIGMET bravo 3 in effect in the area of the accident at the time of the crash. The transcript of radio communications with the flt shows no in-flt weather…Feb 28, 1983 · N28216 · DestroyedNTSB LAX83FA320Accident · 2 fatalField investigationFinal reportBeech E55 · Bridgeport, CAThe recorded transcript between the plt and the reno fss specialist reveals that the plt was aware of moderate icing conditions below 18000 feet and reported moderate to severe turbulence along his proposed route of flt. The plt reported icing conditions and…Feb 28, 1983 · N17993 · DestroyedNTSB ANC83LA049Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Anchorage, AKThe two balloons collided in mid air. One (N4195L) suffered a rip in the envelope which negated its lift, with burner full on. It descended at 500 RPM and made a hard landing. The hole in the envelope extended across 5 gore panels. The 2 balloons departed the…Feb 28, 1983 · N4195L · 2 aircraft · Substantial damageNTSB ANC83IA056Incident · No injuriesIncident investigationFinal reportCessna 172M · Wasilla, AKAcft experienced failure of the left flap during climbout due to worn parts which were not observed on the preflight inspection.Feb 28, 1983 · N786JH · Minor damageNTSB DEN83LA067Accident · No injuriesLimited investigationFinal reportCessna 150M · Emerado, NDThe acft made a forced landing due to weather which included icing and low ceilings. According to the plt. The acft would no longer hold level flt due to icing and after the acft broke out at 300-350 ft AGL he landed and the gear collapsed. The plt had…Feb 27, 1983 · N704HP · Substantial damageNTSB CHI83LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Madeira, OHThe acft crashed into trees during a forced landing after the engine stopped operating while approaching an arpt. The acft was on a cross country flt from dayton to cincinnati in VMC weather. The acft was inspected at the scene and the engine was removed and…Feb 27, 1983 · N6809J · DestroyedNTSB MIA83LA083Accident · No injuriesLimited investigationFinal reportCessna 210H · Near Labelle, FLThe acft collided with a tree during a forced landing and cartwheeled about 150 feet into a palmetto grove. The pilot stated that during the descent to Labelle the engine backfired, lost power and the windshield became covered with oil. The pilot elected to…Feb 25, 1983 · N5980F · DestroyedNTSB CHI83LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Galesburg, ILThe plt stated that during cruise, the engine started to run rough. He applied carburetor heat & initiated emergency procedure, and then engine power was restored. However, a short time later, power was lost again. During a forced landing in an open field,…Feb 25, 1983 · N738HH · Substantial damageNTSB CHI83LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Ely, MNAbout 2 min after takeoff, at about 1,000 ft AGL, the eng siezed. The plt then glided onto a frozen lake. The acft did not have a current annual inspection. The last oil change recorded was during the annual on 7/15/81. Engine teardown revealed severe…Feb 25, 1983 · N38855 · Substantial damageNTSB ATL83FA121Accident · Minor injuriesField investigationFinal reportMooney M20F · Anniston, ALJust prior to departure, the fuel tanks were filled. The plt stated that he drained both tanks after refueling by using the strainer pull handle in the cockpit with the selector positioned to each tank. However, he did not drain the individual tank sumps.…Feb 25, 1983 · N43NC · DestroyedNTSB LAX83FUM04Accident · 1 fatalFinal reportCessna 180J · Descanso, CAThe non-instrument rated plt was on a flt from farmington, NM to el cajon, CA, but made a stop at borrego springs, CA where a passenger deplaned. Before departing farmington, he obtainend a wx briefing for the trip, but only filed a flt plan for the 1st leg…Feb 24, 1983 · N3687C · DestroyedNTSB ATL83LA119Accident · No injuriesLimited investigationFinal reportCessna 210 · Folkston, GAShortly after departure, the pilot observed fuel coming from the fuel tank vent and elected to make a precautionary landing. He touched down in the first 1/3 of runway 17 at a speed of about 80 mph. The pilot stated that the brakes failed during the roll-out…Feb 24, 1983 · N7379E · Substantial damageNTSB ATL83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Ahoskie, NCThe acft was struck by lightning while cruising at 9000 ft MSL. At that time, the plt observed a blue flash off the nose & heard a loud boom. All radios and navigational & electrical equipment became inop. The plt circled down thru a hole in the clouds &…Feb 23, 1983 · N6075H · Substantial damageNTSB ATL83LA115Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pulaski, VAThe aircraft collided with trees during a forced landing after fuel exhaustion on the final leg of a cross-country. The pilot made 5 enroute stops and no refueling was performed at any point during those stops. Departing the last stop the pilot estimated 45…Feb 22, 1983 · N9264J · Substantial damageNTSB ATL83FA117Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Hendersonville, NCAfter reporting level at 7,000 ft in rain, the plt reported that altitude could not be maintained due to a power loss. He stated that '...we're down to about fourteen inches and we just broke out and I got the lights.' At 1849, after a discussion with ATC…Feb 22, 1983 · N6313P · DestroyedNTSB ATL83FA116Accident · Serious injuriesField investigationFinal reportCessna 172P · Red Bank, TNAt aprx 2200 EST, the acft departed lansing, IL on a flt to columbus, GA. A passenger stated that a refueling stop had been planned for either bowling green or nashville. However, a stop was not made. The passenger indicated that the pilots were unsure of the…Feb 22, 1983 · N54498 · Substantial damageNTSB NYC83LA068Accident · No injuriesLimited investigationFinal reportCessna 177 · Reading, PAThe flt departed belfast at 1100. After passing Reading the plt noticed the right tank gauge rise from 1/2 to full. Approximately 3 mi from Reading a 180 deg turn was made to return to Reading. About 1 mi from the arpt the eng surged. A call was made to the…Feb 21, 1983 · N2227Y · Substantial damageNTSB MKC83FA069Accident · 1 fatalField investigationFinal reportCessna 150L · Ellsworth, KSThe pilot departed red cloud, NE for a VFR, no-flight-plan flight to kingman, KS. Witnesses reported an aircraft flying in flight conditions that appeared to deteriorate from a weather stand standpoint in the direction of flight. One witness stated that he…Feb 21, 1983 · N18204 · DestroyedNTSB MIA83LA079Accident · No injuriesLimited investigationFinal reportHughes 500-369HS · Boca Raton, FLThe plt reported the flt experienced a total eng power loss & the acft was ditched in the intracoastal waterway. All examinations & tests conducted during the investigation revealed no evidence of a preimpact failure or malfunction of the airframe or eng.Feb 21, 1983 · N2254X · Substantial damageNTSB LAX83FA350Accident · 5 fatalField investigationFinal reportBeech N35 · Mount Shasta, CAThe acft flew into mt reddy at about 9000 ft level. The clouds were as low as 5000 and the mountain tops were obscured. The plts in flt wx briefing contained the advice that VFR flt along his route was not recommended because the mt tops were obscured in…Feb 21, 1983 · N9350Y · DestroyedNTSB MIA83LA080Accident · No injuriesLimited investigationFinal reportCessna C-152 · Yeehaw Junction, FLAccording to the student pilot the aircraft was fueled to maximum capacity prior to departure on a cross country flight. Approximately 3.2 hours later the engine quit and the pilot was forced to make an emergency landing in a wooded area. Subsequent engine…Feb 19, 1983 · N49132 · Substantial damageNTSB MIA83FLD01Accident · Serious injuriesFinal reportPitts Special S-1C · St. Petersburg, FLThis was the plt's 2nd flt in his home built acft. During his preflight, he checked the sight gauge for fuel, but did not visually check the fuel tank. The gauge indicated that there was about 17 gal of fuel remaining. During flight, the engine lost power and…Feb 19, 1983 · N507LS · Substantial damageNTSB LAX83LA110Accident · No injuriesLimited investigationFinal reportCessna 172G · Antioch, CAAccording to the left seat pilot the engine sputtered at 2200 RPM and quit. There were wires obstructing the field selected for landing. The acft went under most of them but clipped one service electric line. The acft landed & rolled about 75 feet before…Feb 19, 1983 · N4611L · Substantial damageNTSB ATL83LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Stafford, VAThe acft collided with a ditch during a forced landing. The plt was cruising at 3000 ft MSL when he heard a 'loud pop'. The engine started running rough and missing. The plt shut the engine down by pulling the mixture control and throttle. When he shut down…Feb 19, 1983 · N3750P · Substantial damageNTSB ATL83LA110Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbus, MSThe acft collided with a tree during a forced landing. The acft was descending returning from a fire patrol when the engine quit. The right fuel gauge was on empty and the left tank showed 1/4 of a tank. Attempts to restart the engine were unsuccessful and…Feb 19, 1983 · N1327Q · Substantial damageNTSB MIA83LA077Accident · No injuriesLimited investigationFinal reportCessna C-182P · Bahia Honda, FLThe acrft was ditched in the bay of Florida after the engine failed at 1000 ft MSL. The pilot and passenger swam to shore without injury. Examination revealed that the #1 cyl exhaust valve rocker shaft housing failed. Lab exam of the housing showed high cycle…Feb 18, 1983 · N9912M · Substantial damageNTSB LAX83LA105Accident · No injuriesLimited investigationFinal reportCessna 170 · Pleasonton, CAThe acft collided with a street curb during an off airport forced landing. The pilot stated that during climb-out at 3000 feet the engine RPM began to decrease. He used carburetor heat as the engine lost power to 1000 RPM. He also switched tanks from both to…Feb 18, 1983 · N2565V · Substantial damageNTSB DEN83FA062Accident · 2 fatalField investigationFinal reportPiper PA-23F-250 · Moab, UTThe acft crashed into the top of a mesa at the 5500 ft level (MSL). The acft then cartwheeled about 300 ft on a heading of 360 degrees. Sheriffs deputies discovered at the accident site that the acft was loaded with marijuana weighing ABOUT798 lbs. An…Feb 16, 1983 · N63808 · DestroyedNTSB ATL83LA104Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Pickens, SCThe acft collided with two birds while cruising at 6000 ft MSL. The weather was VFR but the acft was on IFR flt plan. The acfts left wing was damaged but there were no injuries. The plt stated that although he heard a thud on the left side of the acft he was…Feb 16, 1983 · N8472E · Substantial damageNTSB DEN83FA059Accident · 4 fatalField investigationFinal reportCessna 340A · Aspen, COPrior to departure the flt was given an IFR clearance which began at herls intersection (16 mi nne) & to cross herls at or above 16,000 ft MSL. Departure arpt field elev is 7,793 ft. flts are required to proceed VFR to the initial fix of the IFR clearance.…Feb 15, 1983 · N33340 · DestroyedNTSB ATL83LA103Accident · No injuriesLimited investigationFinal reportHughes 369HS · Paducah, KYThe acft was damaged during an autorotation into an open field after a chip detector light illuminated. The chip light is used for detecting metal in the transmission, engine and tail rotor gear box. Examination of the transmission revealed metal particles on…Feb 15, 1983 · N3280K · Substantial damageNTSB LAX83FA099Accident · No injuriesField investigationFinal reportCessna 150J · Nogales, AZThe acft nosed over during a forced landing after the engine failed during an instruction flt. The landing was accomplished off arpt about 30 minutes after initial takeoff. The engine had begun to run rough followed by a loss of oil pressure. Then the engine…Feb 13, 1983 · N50586 · Substantial damageNTSB CHI83LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Jackson, MIComplete electrical failure occurred at 8,000 ft. the plt diverted to Jackson & the acft landed wheels-up. The plt laterstated that he thought he was familiar with the emergency gear extension procedures in the flt manual but that he might not have put the…Feb 13, 1983 · N47875 · Substantial damageNTSB SEA83LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Near Kent, WAThe instructor and student encountered extreme turbulence during a climb to 2000 feet so the took the controls and the retarded power to lower speed and lose altitude. Descent was made from 1800 feet to 1300 feet before the throttle was advanced and when it…Feb 12, 1983 · N25320 · Substantial damageNTSB FTW83LA112Accident · No injuriesLimited investigationFinal reportPratt-Read PRG-1 · Littlefield, TXThe glider was being operated by a boy scout explorer post. The 15 year-old scout was one of the first boys to solo the 40 year-old glider. While returning from a 50 min soaring flt, the glider spun to the ground after entering a strong thermal. According to…Feb 12, 1983 · N14Y · Substantial damageNTSB CHI83LA111Accident · No injuriesLimited investigationFinal reportCessna 150 · Worthington, MNThe plt reported that he was able to maintain visual ground contact after he left blue earth, MN. However, as he was following an interstate highway near Worthington, MN, the visibility decreased. He attempted to get to the arpt at Worthington, but saw a…Feb 12, 1983 · N50567 · Substantial damage