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 ATL82DA126Accident · Serious injuriesFinal reportPiper PA-28R-180 · Front Royal, VADuring flight the aircraft engine developed a noise which the pilot described as a hissing. The pilot declared an emergency, was vectored to the nearest airport, and proceeded to shut off the engine at 5000 feet when over the airport. During the forced…May 6, 1982 · N4903J · Substantial damageNTSB FTW82AA167Accident · 7 fatalFinal reportBeech B90 · Charlotte, TXThe plt & 6 pax were returning home after fishing in Mexico. After clrg customs at laredo, TX, they departed on the next leg of the flt. The plt was clrd to 11000 ft, but got off course. He commented that an instrument had popped, he then requested 7000 ft,…May 5, 1982 · N98949 · DestroyedNTSB FTW82DPG10Accident · Serious injuriesFinal reportCessna 188B · Glenwood, ARThe pilot became disoriented while on a ferry flight. He spotted a water tower in the town of Glenwood, AR and determined that he was about 35 miles southeast of his destination. He reported that the fuel gauge indicated between 1/4 and 1/2 full after he…May 4, 1982 · N4458Q · Substantial damageNTSB FTW82DA161Accident · Minor injuriesFinal reportBoeing E75 · Sterling City, TXThe pilot stated that he was flying the aircraft from devine, TX to Montana for the owner. He received about a half-hour of dual instruction in the aircraft and then departed. Several en route stops were made. The pilot stated that he checked the fuel…May 3, 1982 · N5374N · Substantial damageNTSB NYC82DA087Accident · No injuriesFinal reportHiller UH-12A · New Paltz, NYWhile cruising at 400 ft AGL, the pilot noticed a decay in the main rotor RPM; however, the engine RPM was reported to have remained constant. The pilot suspected a mechanical failure and elected to make a precautionary landing in an apple orchard. During the…May 2, 1982 · N116S · Substantial damageNTSB MKC82IA070Incident · No injuriesIncident investigationFinal reportBeech M35 · Ava, MODuring a night cross-country from pryor, ok to Ava, MO, the aircraft experienced a total electrical failure as a result of a loose alternator belt and a depleted battery. On arrival at his destination, the pilot selected gear down with the normal extension…May 2, 1982 · N9783R · Minor damageNTSB MKC82DA068Accident · Minor injuriesFinal reportBeech M35 · Ottumwa, IADuring flight, the engine RPM exceeded its maximum limit. The pilot attempted to reduce the RPM by using the propeller control, but this had no effect. The pilot was in the process of shutting down the engine when engine oil sprayed out the cowling and onto…May 2, 1982 · N313Z · Substantial damageNTSB MIA82FA115Accident · No injuriesField investigationFinal reportRobinson R-22 · Ft. Pierce, FLThe student pilot was performing autorotations with 180 degree turns terminating with power recoveries. At about 200 feet, after completion of the turn, the instructor heard a rattling noise followed by a medium frequency vibration. The instructor took the…May 1, 1982 · N90249 · Substantial damageNTSB LAX82DA154Accident · Minor injuriesFinal reportHughes 269B · North Las Vegas, NVThe pilot ran out of fuel and autorotated to a hard landing. He stated the low fuel warning light never came on. He was going to use this as a signal to refuel. This would give about 15 minutes of cruise flight. The low level warning switch wiring was found…May 1, 1982 · N9336F · DestroyedNTSB CHI82DA148Accident · No injuriesFinal reportBeech C35 · Dillsboro, INThe aircraft operated normally during taxi, run-up, takeoff, and climb to 3500 ft MSL. About 17 miles from the departureairport, the engine stopped running. During a forced landing in a dirt field, one of the main gear failed. The propellerseparated and the…May 1, 1982 · N8940A · Substantial damageNTSB LAX82DA152Accident · Serious injuriesFinal reportCessna 175A · Lathrop Wells, NVThe aircraft's engine quit while on approach to Lathrop Wells. During the emergency landing the aircraft stalled and dropped from about 15 feet AGL and came to rest inverted. Fuel was present at the accident site and the fuel selector was found midway between…Apr 30, 1982 · N7058E · Substantial damageNTSB LAX82DA151Accident · No injuriesFinal reportBeech V35B · Terminal Island, CAThe pilot and a mechanic were on a flight to test the aircraft after changing the magnetos, spark plugs, and ignition harness. During the flight, the engine began running rough, but smoothed out after the boost pump was switched on. A short time later, the…Apr 30, 1982 · N1573W · Substantial damageNTSB FTW82DA159Accident · Minor injuriesFinal reportPiper PA-18 · Victoria, TXThe pilot tookoff at about 1535 to fly in the local area and then to proceed to his home at edna, TX. He flew to a ball field to observe some friends playing ball. After circling the field 3 times, he applied power and began a climb. He stated that about 30…Apr 30, 1982 · N186T · Substantial damageNTSB DEN82DA076Accident · No injuriesFinal reportFunk B75L · Laramie, WYAccording to the pilot, when the aircraft was in a mountain pass about 10 mi from the departure point, it was caught by a downdraft. Reportedly, he was forced to land on a dirt trail. During the landing, the aircraft was substantially damaged.Apr 30, 1982 · N24166 · Substantial damageNTSB ATL82DA117Accident · Minor injuriesFinal reportCessna 152 · White Sulphur S, WVThe pilot took off on runway 26 with a full load of fuel, one passenger, and luggage. The aircraft was at or near its maximum gross weight limit. The temperature was 60 degrees. The airport elevation was 1801 ft MSL and two ridge lines ran parallel to the…Apr 30, 1982 · N49924 · DestroyedNTSB NYC82FA083Accident · No injuriesField investigationFinal reportBell 206L · New York City, NYThe flt departed the 34th street heliport on a local sightseeing flt to the statue of liberty & return. As the flt crossed lower manhattan, about 1/4 mi from the east river, the plt heard the low RPM audio signal. He lowered the collective & rotor RPM…Apr 29, 1982 · N16959 · Substantial damageNTSB FTW82FA156Accident · Minor injuriesField investigationFinal reportSmith Aerostar 600 · Portland, TXWhile descending near the destination, the left engine stopped running. The pilot attempted 2 airstarts which were unsuccessful. He feathered and secured the left engine and requested radar vectors to the nearest airport. A visual approach was made to the…Apr 29, 1982 · N133TS · DestroyedNTSB DEN82FA074Accident · 2 fatalField investigationFinal reportBeech E18S · Hakalau, HIThe aircraft departed hilo on the last leg of a 3 flight. A few minutes after takeoff, the pilot called the tower to askfor return and indicated he had a difficulty. No further transmission was made. Witnesses heard intermittent engine sputtering and then the…Apr 29, 1982 · N6911 · DestroyedNTSB NYC82FA080Accident · 4 fatalField investigationFinal reportMBB BO-105C · New Ringgold, PAThe helicopter was leased by the allentown sacred heart hospital. At 2236 EDT, the pilot, who was standing by for duty, obtained a weather briefing. Later, at 2312, there was a request for a med-evac helicopter to respond to a car accident. The helicopter…Apr 28, 1982 · N1022H · DestroyedNTSB LAX82FUJ40Accident · Serious injuriesFinal reportHughes 369D · Teec Nos Pos, AZThe acft lost eng power & crashed while attempting an autorotation. Eng teardown revealed that the #2 bearing failed as a result of some of the ball retainers being broken & cracked between the ball pockets. This condition allowed the impeller assembly to…Apr 28, 1982 · N1089S · Substantial damageNTSB CHI82DA140Accident · No injuriesFinal reportBeech BE-19 · Ridgeville, WIThe student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the…Apr 28, 1982 · N5204M · Substantial damageNTSB SEA82DYE06Accident · 1 fatalFinal reportBeech 23 · Greenwater, WAAt about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…Apr 25, 1982 · N6079N · DestroyedNTSB ATL82DA115Accident · No injuriesFinal reportPiper PA-23 · Louisville, KYThe pilot stated that during level flight at 9000 ft, he noticed smoke coming from under the instrument panel, followed by a vibration for 15 to 20 seconds. He diverted and landed at Louisville, KY without further incident. An examination revealed that the…Apr 25, 1982 · N1227P · Substantial damageNTSB ATL82DA114Accident · No injuriesFinal reportCessna 172E · Society Hill, SCThe engine quit at 4000 feet and the pilot elected to land in trees rather than a road with traffic. The aircraft ended up on small gravel road with the gear collapsed. No fuel was found in the aircraft.Apr 25, 1982 · N3971S · Substantial damageNTSB FTW82FQD10Accident · 4 fatalFinal reportMooney M20K · Van Horn, TXN99996 departed riverside, CA on a flight to nacogdoches, TX the aircraft made a refueling stop in deming, NM, the last known en route position. The left seat pilot held a pvt certificate, the right seat pilot was a former FAA designated pilot examiner.…Apr 23, 1982 · N99996 · DestroyedNTSB FTW82DA143Accident · No injuriesFinal reportBeech A60 · Garland, TXThe plane had been involved in a bankrupcy settlement and had not been flown for about 3 1/2 mths. The pilot had been sent to ferry the plane. During a run-up before takeoff, the propellers moved toward a feather position without pilot input. The pilot had a…Apr 23, 1982 · N7RA · Substantial damageNTSB CHI82DA130Accident · No injuriesFinal reportCessna 150 · Gary, INThe aircraft engine quit on final approach to landing at Gary municipal. A forced landing was made on a street and the aircraft collided with a street sign before nosing over into a ditch. The aircraft operator examined the aircraft at thescene and said the…Apr 23, 1982 · N50759 · Substantial damageNTSB MIA82DA106Accident · No injuriesFinal reportPiper J5A · Tampa, FLThe pilot reported that the engine malfunctioned while he was on a VFR flight. He stated that he applied carburetor heat as well as other measures to restore power. The malfunction persisted, and the plane was substantially damaged during a forced landing…Apr 22, 1982 · N41141 · Substantial damageNTSB FTW82FA145Accident · 2 fatalField investigationFinal reportBell 212 · Intracoastal Ci, LAThe helicopter was in cruise flight when a sudden and severe right yaw occurred. Subsequently, it was autorotated to a ditching in rough water. Touchdown was made on top of a wave, then the helicopter rolled over. The survivors did not get the raft out.…Apr 22, 1982 · N5752W · DestroyedNTSB FTW82DA144Accident · No injuriesFinal reportBell 206L-1 · Cameron, LAN2138Y departed Cameron, LA after refueling en route to an offshore rig. Shortly after departure, while over water, the aircraft began to yaw and vibrate severely. The pilot stated that the tail rotor pedals "kicked" hard when additional power was applied.…Apr 22, 1982 · N2138Y · Substantial damageNTSB MKC82FA057Accident · 2 fatalField investigationFinal reportCessna 177RG · Ste. Genevieve, MODuring the day of the accident, the pilot received 7 weather briefings which described marginal VFR conditions for his route of flight. At about 1730 CST, he departed Kansas city on a VFR flight plan to farmington, MO. During the flight, he encountered…Apr 20, 1982 · N1929Q · DestroyedNTSB LAX82DA144Accident · No injuriesFinal reportCessna 150K · 9 Sw Santa Barb, CAThe engine lost power while the pilot was spotting fish at night. He was unable to restart the engine or glide back to the shore. The plane was ditched about 3 1/2 miles from the shore and was not recovered.Apr 20, 1982 · N5847G · DestroyedNTSB ATL82FA110Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-30 · Lafayette, GADrg the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & poor visibility. The plt responded he had to go to ft. payne VFR because they have no instrument approach. A jeppesen us (lo)29 low alt enroute chart was found at…Apr 20, 1982 · N165MA · DestroyedNTSB MIA82DA111Accident · 3 fatalFinal reportCessna 172N · Near Westbay, FLDuring the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & visbilities just east of panama city & along the gulf coast. At 2015, approximately 28 mi se of destin, the plt contacted eglin approach control(a/c) & was…Apr 18, 1982 · N5186D · DestroyedNTSB LAX82DA140Accident · 3 fatalFinal reportHughes 369HS · 8 S. Of Page, AZThe aircraft was number two in a trail of three helicopters flying up the Colorado river at marble canyon to page, AZ when it struck an aerial cableway stretching across the river, 22 ft above the water. Witnesses stated that after the collision the…Apr 18, 1982 · N4EE · DestroyedNTSB FTW82DA136Accident · Minor injuriesFinal reportCessna 182P · Kendalia, TXThe pilot stated that the weather conditions along his route of flight deteriorated rapidly. He decided to make a precautionary landing on a short plowed field. During final approach, the aircraft struck a tree top and crashed.Apr 18, 1982 · N79885 · DestroyedNTSB SEA82FYP07Accident · Serious injuriesFinal reportBeech 77 · Richland, WAWhile flying over a government reservation at night, the aircraft struck the side of a mountain about 1000 ft below the mountain top. A seat belt "d-ring" failed and the pilot went through the windshield when the aircraft struck a slope of about 60 degrees.…Apr 17, 1982 · N1814B · Substantial damageNTSB LAX82DA139Accident · No injuriesFinal reportCessna 210D · N. South Lake T, CAAfter takeoff, the pilot made a normal climb to about 8500 ft. he then noticed indications of higher than normal EGT and fuel pressure and a lower than normal fuel flow. The pilot reported that he had leveled off and throttled back when the engine began to…Apr 17, 1982 · N3972Y · DestroyedNTSB ATL82DA105Accident · Minor injuriesFinal reportAyres S2R-600 · Evergreen, ALThe pilot stated that about 5 minutes after takeoff the engine skipped once, popped, then quit completely with no other warning. The aircraft was over a wooded area and was forced to land in the trees. It was determined that the aircraft was approximately 740…Apr 17, 1982 · N4008H · DestroyedNTSB FTW82FA132Accident · 3 fatalField investigationFinal reportBell 222 · Hinton, OKHelicopter broke up in flight and fell in pieces in an open field. Weather was VMC and it was daylight. All 3 occupants were fatally injured. The breakup occurred while aircraft was in cruise flight.Apr 16, 1982 · N2152J · DestroyedNTSB CHI82FA123Accident · 3 fatalField investigationFinal reportMooney M20J · Bird Island, MNThe aircraft departed thief rivers, MN and proceeded en route to new ulm, MN. One witness near the accident site heard a noise that sounded to him like an explosion. He and other witnesses in the vicinity saw the aircraft descending out of control in a roll…Apr 16, 1982 · N3201P · DestroyedNTSB LAX82FA136Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Tulare, CAThe glider pilot entered a thermal with three other sailplanes and began to climb. Two of the sailplanes were about 1000 ft below him and the other plane was about 500 ft above. As the pilot was climbing to about 4000 ft MSL, he lost sight to the sailplane…Apr 15, 1982 · N6KS · 2 aircraft · Substantial damageNTSB LAX82DA159Accident · No injuriesFinal reportGrumman AA-5B · Paulden, AZDuring a simulated forced landing after following the prescribed restart procedures the student, under the supervision of the instructor, executed her securing procedures. It was the instructor's policy to let the student actually move the proper control then…Apr 15, 1982 · N34ER · Substantial damageNTSB DEN82DA068Accident · No injuriesFinal reportCessna 182A · 20mn Of Jackson, WYThe pilot reported that he became involved in a deteriorating weather condition while maneuvering in a mountainous area. He attempted to return to the departure airport, but the weather conditions (snowshowers) became worse. He elected to make a precautionary…Apr 15, 1982 · N3748D · Substantial damageNTSB DEN82DA060Accident · No injuriesFinal reportCessna 170B · Worden, MTThe pilot reported that the carburetor heat control became inoperative while on a cross-country flight. The weather conditions were conducive to the formation of carburetor ice. A decision was made to land in an alfalfa field while the engine was still…Apr 15, 1982 · N3415D · Substantial damageNTSB ANC82FA035Accident · 2 fatalField investigationFinal reportSud SA 318C · Near Savoonga, AKAt 0746 LCL time, the plt activated his VFR flt plan for a round robin flt from nome, AK to Savoonga, NE cape, Savoonga, se cape, Savoonga & back to nome. After arriving at Savoonga, the helicopter was refueled. According to svrl villagers, the wx at that…Apr 15, 1982 · N9367 · Substantial damageNTSB FTW82DA130Accident · No injuriesFinal reportGoodyear FGID(F4U) · Forney, TXFollowing the last aerobatic manuever, a loop, and while in straight and level flight, the low oil pressure light illuminated. The oil pressure decreased to zero and shortly thereafter propeller control was lost. Due to a rough running engine an emergency…Apr 14, 1982 · N9964Z · Substantial damageNTSB NYC82FHM05Accident · Minor injuriesFinal reportPiper Aerostar 602P · Tetersboro, NJWhile approaching the teterboro airport, the pilot encountered a bird strike which broke the windscreen. The pilot reported that he was partially blinded with blood and feathers. He regained his sight and landed the aircraft at teterboro.Apr 13, 1982 · N6896T · Substantial damageNTSB MIA82DA096Accident · Minor injuriesFinal reportHughes 269B · Near Kissimmee, FLThe engine lost power while the pilot was on a low altitude aerial observation flight over trees. He attempted to land on a nearby road. While approaching the road at 10 to 15 ft AGL, he ran out of RPM. He hit the ground flat, but did not roll over.Apr 12, 1982 · N9393F · Substantial damageNTSB MKC82FCA08Accident · Serious injuriesFinal reportBell 47G-4 · St Genevieve, MOThe pilot reported that about 40 minutes after takeoff, there was a drop in oil pressure followed almost immediately by an engine failure. The engine failure occurred over a wooded area. The pilot attempted an emergency landing in a small clearing, but the…Apr 11, 1982 · N87623 · Substantial damage