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 MIA82FA079Accident · 1 fatalField investigationFinal reportBenson B-8M · Minneola, FLWitnesses heard an engine sputter and looked up to see the gyrocopter descending vertically into a nearby wooded area while the nose of the aircraft was pointed almost straight down. Investigation revealed that the pilot did not possess any aeronautical…Mar 20, 1982 · N25PH · DestroyedNTSB LAX82FVG17Accident · Serious injuriesFinal reportCessna 182 · Folsom, CAThe pilot visually checked the fuel before takeoff and was aware that the tanks were not full. He reported that he would only use 80/87 octane fuel because the engine was not equipped with valves that would accept 100 octane fuel. During the flight, he…Mar 20, 1982 · N3910D · DestroyedNTSB LAX82DVG16Accident · Minor injuriesFinal reportPiper PA-38 · Fall River Mill, CAThe pilot elected to return to his departure airport when the aircraft would not climb. The aircraft continued to loose altitude after a 180 degree turn, the aircraft crashed into trees. Examination of the aircraft engine did not reveal any preimpact failure…Mar 20, 1982 · N2374P · DestroyedNTSB FTW82DA099Accident · Minor injuriesFinal reportAirmate HP-10 · El Paso, TXOn the first flight since purchase of the aircraft, the pilot stated that he was released from the tow at 1700 ft AGL and climbed in a thermal to 2000 ft AGL where he allowed the aircraft to stall and spin. The pilot stated that he had difficulty in…Mar 20, 1982 · N6511D · Substantial damageNTSB ATL82FA080Accident · 1 fatalField investigationFinal reportCessna 172N · Francisco, NCThe non-instrument rated pilot received a partial weather briefing by telephone, but hung up when he obtained the information that he requested. FBO personnel stated that he looked and acted tired before taking off at 0022 EST. Subsequently, the plane was…Mar 20, 1982 · N738QS · DestroyedNTSB ATL82DA078Accident · Minor injuriesFinal reportMooney M20E · Alexandria, KYThe pilot reported that he had monitored the refueling operation, but did not actually uncap and check the fuel himself. He calculated that he had five hours of fuel on board. However, he ran out of fuel after using the right fuel tank for two hours and 30…Mar 20, 1982 · N5526Q · Substantial damageNTSB LAX82FA111Accident · 5 fatalField investigationFinal reportCessna 401 · Sunflower, AZAt 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route…Mar 18, 1982 · N499W · DestroyedNTSB LAX82FA110Accident · 1 fatalField investigationFinal reportMooney M20K · Alpine, CAAfter being cleared from 8000 feet down to 6000 feet the air traffic controller realized that the aircraft was in trouble when the mode c altitude indicated 3600 feet. He received no understandable response from the pilot when asked about altitude or heading.…Mar 18, 1982 · N231AM · DestroyedNTSB NYC82DA057Accident · No injuriesFinal reportPiper PA-28RT-201 · Avoca, PAThe pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…Mar 17, 1982 · N2962W · Substantial damageNTSB LAX82FA109Accident · 3 fatalField investigationFinal reportCessna 340A · 12 N.E. Burbank, CAAfter takeoff, the pilot was cleared to proceed on an IFR flight plan. After being cleared to 15,000 ft MSL, he reported having trouble maintaining his airspeed and subsequently declared an emergency. Shortly after that, radar contact was lost. The aircraft…Mar 17, 1982 · N98546 · DestroyedNTSB FTW82FPJ14Accident · 1 fatalFinal reportCessna 172N · Hulen, OKThe pilot departed lawton, Oklahoma at 0902 local time on a flight to inspect mineral property. At about 0931, the pilot contacted ft. sill approach control and requested vectors to lawton. He was instructed to fly a heading of 320 degrees. After flying that…Mar 17, 1982 · N5608J · DestroyedNTSB FTW82DA096Accident · Minor injuriesFinal reportPiper PA-38-112 · Farmington, NMThe aircraft lost power during a cross country flight. During the subsequent forced landing on a dirt road the aircraft collided with a ditch and nosed over.Mar 17, 1982 · N91317 · Substantial damageNTSB ATL82FA072Accident · 1 fatalField investigationFinal reportCessna 150 · Tilghman Island, MDThe student pilot/owner of the aircraft was endorsed to fly the plane and would fly it from his farm on Tilghman Island to easton, MD for dual instruction. Several days before the accident, he had asked his instructor (ip) to schedule some time for an early…Mar 17, 1982 · N10914 · DestroyedNTSB MIA82DA074Accident · No injuriesFinal reportCessna T210M · Miami, FLThe pilot experienced a loss of electrical power on a VFR flight. Upon arrival in the Miami area he was unable to extend the main gear and landed gear up.Mar 16, 1982 · N761NJ · Substantial damageNTSB LAX82FUJ32Accident · 1 fatalFinal reportBeech 58 · Tucson, AZThe plt departed phoenix at 0045 for the third leg of a six leg bank run between phoenix & Tucson intl arpt. He was in contact with the phoenix TRACON during departure & was released at the toltec intersection (V16) at 5,500 ft. there was no further radio…Mar 16, 1982 · N184VB · DestroyedNTSB ANC82DA027Accident · Minor injuriesFinal reportBell 206 L-1 · Delta Junction, AKWhile flying at approximately 300 feet AGL in windy turbulent conditions over snow covered terrain,the helicopter impacted the frozen river. At the time of the accident the pilot was changing radio frequencies when impact occurred.Mar 16, 1982 · N1069S · Substantial damageNTSB LAX82FXQ06Accident · 2 fatalFinal reportCessna 182 · Lake Tahoe, CAA pilot who landed prior to the departure of N5298N stated that his aircraft had accumulated 1/4 inch of airframe ice while over the lta VOR. An employee of Lake Tahoe aviation fueling service informed the pilot of N5298N of these weather conditions and ice…Mar 15, 1982 · N5298N · DestroyedNTSB FTW82DA093Accident · 1 fatalFinal reportBeech C-45H · Mcallen, TXAbout 18 minutes after takeoff, the pilot radioed that the no. 2 engine had lost power and that he was returning to land at Mcallen, TX. While approaching to land, the aircraft crashed in an open field about 400 yards short of the runway and 115 feet right of…Mar 15, 1982 · N9846Z · DestroyedNTSB DEN82DA044Accident · No injuriesFinal reportPiper PA-31P · Gunnison, COWhile enroute to addison, TX, the pilot noticed a fluctuation in the engine exhaust gas temperature gauge, followed by the tachometer dropping to zero. The pilot also observed smoke emanating from the engine nacelle and proceeded to secure the engine and…Mar 15, 1982 · N12JP · Substantial damageNTSB CHI82DA090Accident · No injuriesFinal reportCessna 182 · Bremen Township, MNDuring a VFR flight, the pilot encountered deteriorating weather and elected to make a precautionary landing on a snow covered, cultivated field. The pilot reported that during a soft field approach for landing, the aircraft flipped over when it contacted the…Mar 15, 1982 · N5643B · Substantial damageNTSB LAX82FXQ05Accident · Minor injuriesFinal reportPiper PA-28R-201 · Elko, NVThe pilot stated that the engine quit producing power and the plane crashed in mountainous terrain. A teardown of the engine revealed no preimpact failure. The initial impact occurred with a tree at an elevation of about 7000 ft MSL. A piece of the right wing…Mar 14, 1982 · N2105M · DestroyedNTSB ATL82DA070Accident · Minor injuriesFinal reportCessna 152 · Lusby, MDThe student was on a cross-country flight from leonardtown, MD to cumberland, MD to lancaster, pa and then return to leonardtown. Before takeoff, the student was instructed to refuel at cumberland or lancaster before continuing. The student stated that he had…Mar 14, 1982 · N159TC · Substantial damageNTSB MIA82FLD17Accident · Serious injuriesFinal reportCrook M-1 · Tarpon Springs, FLThe pilot reported that when he first tried to start the engine before takeoff, there was a lack of ignition and it would not start. He found moisture in the distributor cap, dried it out, cleaned the points, and then the engine started normally. Before…Mar 13, 1982 · N8534Y · DestroyedNTSB LAX82FUG08Accident · 2 fatalFinal reportCessna 210G · Etiwanda, CAThe aircraft struck a ridge at an elevation of about 2000 ft MSL. At the impact point, the terrain sloped upward at an angle of about 35 degrees. The aircraft impacted in a near level flight attitude. The weather at the crash site was not determined. However,…Mar 13, 1982 · N5870F · DestroyedNTSB LAX82FUG07Accident · Minor injuriesFinal reportCessna 182 · Blythe, CAThe engine lost power at night while the aircraft was en route at about 18,000 ft MSL. The pilot was unable to restart the engine. While trying to start the engine, he noted that the carburetor heat would not go full on or full off. The pilot asked for…Mar 13, 1982 · N21409 · Substantial damageNTSB CHI82DA084Accident · Serious injuriesFinal reportPiper PA-28 · Cambridge, MNThe pilot had expected that strong headwinds would decrease during flight; however, they continued. The pilot made an enroute stop for fuel, but after landing, he found that the airport was deserted. He stated that he recalculated the elapsed time, etc, and…Mar 13, 1982 · N9697J · Substantial damageNTSB ATL82DA068Accident · No injuriesFinal reportCessna 172N · Chamblee, GAThe engine lost power as the aircraft approached the destination airport. The pilot was unable to start the engine or glide to the airport. While attempting to land on a road, the pilot was able to avoid electrical wires; however, the right wing struck a pole…Mar 13, 1982 · N44ER · Substantial damageNTSB NYC82IA051Incident · No injuriesIncident investigationFinal reportNord 262A-12 · Flushing, NYWhile climbing through 7000 ft, the aircraft began to shake violently. The first officer confirmed that the source of vibration was the right engine. An unsuccessful attempt was made to feather the prop after the rt engine was shut down. The aircraft…Mar 11, 1982 · N26210 · Minor damageNTSB FTW82FPM11Accident · 2 fatalFinal reportCessna 172 · Heavener, OKThe aircraft crashed at night on rising terrain about 300 ft below the crest of a hill. The nearest weather reporting station was at mcalester, OK. The weather at mcalester was 1200 ft overcast, visibility 7 miles, ceiling ragged. The mcalester field…Mar 10, 1982 · N739MG · DestroyedNTSB CHI82DA080Accident · No injuriesFinal reportCessna 150 · Charlestown, INThe pilot reported that he ran out of fuel on a cross-country flight. He made an emergency landing in an open field at night. During the landing, the plane flipped over on its back.Mar 9, 1982 · N66252 · Substantial damageNTSB ATL82FKG09Accident · 1 fatalFinal reportCessna 210D · Near Commerce, GAThe owner had flown a PA-23 from charlotte to jackson county,FL with another plt following him in N3909Y. The owner stated the other plt was very meticulous & always drained fuel prior to flt. After the 1 hr flt to jackson county, they both looked over the…Mar 9, 1982 · N3909Y · Substantial damageNTSB NYC82DA046Accident · No injuriesFinal reportCessna T188C · Block Island, RIWhile on a ferry flight approaching the nantucket VOR the pilot stated that the engine began to run rough. The aircraft was turned back towards Block Island at which time the fuel pressure began to fluctuate and decrease along with the manifold pressure. The…Mar 8, 1982 · N9374J · DestroyedNTSB MIA82IA066Incident · No injuriesIncident investigationFinal reportPiper PA-28-140 · Near Melbourne, FLThe aircraft had been in the practice area southwest of Melbourne, FL doing commercial flight check maneuvers for about 1 hour. According to the pilot, after completing his maneuvers he circled a lake once at 1000' AGL and then headed toward Melbourne. As he…Mar 8, 1982 · N3505Q · Minor damageNTSB LAX82FUQ10Accident · Serious injuriesFinal reportPiper PA-28R-180 · Captinteria, CAThe pilot reported that he had some head congestion and had experienced ear discomfort on the first leg of the flight. He elected to fly the second leg of the flight in a canyon that he thought would allow passage through the mountains at low altitude.…Mar 8, 1982 · N7497J · DestroyedNTSB DEN82FTI11Accident · 1 fatalFinal reportCessna TR182 · Livingstone, MTThe plane crashed about six miles west of livingston, Montana. It was found to have struck about 50 ft below a 5300 ft ridge, while in a 20 degree climb attitude. The weather at livingston was: 900 ft broken, 2500 ft overcast, visibility 10 miles, wind…Mar 8, 1982 · N4681T · DestroyedNTSB LAX82DA099Accident · No injuriesFinal reportCessna 182 · Woodland, CAA climb was made to 10,000 ft on a skydiving flight. The pilot reported that after descending to 2000 ft, the engine began to lose power and run rough. He elected to make an off-airport landing in a field. Near the end of the landing roll, the nose gear sank…Mar 7, 1982 · N3427U · Substantial damageNTSB LAX82DA095Accident · No injuriesFinal reportCessna 172N · Mammoth, AZThe pilot was on a solo cross-country flight in preparation for his commercial pilot certificate. He had begun a descent from 10,500 ft for landing at his destination airport when the engine quit. Attempts to restart the engine were unsuccessful and a forced…Mar 7, 1982 · N734GH · Substantial damageNTSB DEN82FTE17Accident · Serious injuriesFinal reportCessna 172 · Boulder, COThe engine lost power while the aircraft was cruising at 7500 ft MSL at night. During a forced landing, the aircraft touched down on steep, rocky soil. The aircraft bounced and then nosed over after a second touchdown. During an interview about two hours…Mar 7, 1982 · N4899F · DestroyedNTSB ATL82FKW05Accident · Serious injuriesFinal reportCessna 177RG · Kingston, TNDuring cruise flight a gear tooth from the aluminum idler gear in the engine oil pump failed. This locked the oil pump causing failure of the main drive gear. The aircraft landed in rough terrain with gulleys.Mar 7, 1982 · N2150Q · Substantial damageNTSB FTW82FRJ09Accident · Serious injuriesFinal reportCessna 182L · Farmerville, LAThe pilot reported that his takeoff and climb to 2200 ft MSL were normal. After the plane was in cruise configuration, he heard an abnormal noise and decided to return to the airport. The noise level increased and the engine began to vibrate. The pilot…Mar 5, 1982 · N70541 · DestroyedNTSB DEN82FA038Accident · 3 fatalField investigationFinal reportCessna 172 · 3nm East Of Mar, UTWitnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately…Mar 5, 1982 · N3963F · DestroyedNTSB DEN82FA039Accident · 1 fatalField investigationFinal reportMooney M20E · Aspen, COThe aircraft collided with a tree on top of a 12,000 foot mountain after it had departed Aspen, en route to denver. The aircraft should have climbed over the mountain without problems. The pilot only remembers the airspeed decaying and lowering full flaps…Mar 4, 1982 · N5755Q · Substantial damageNTSB NYC82DFJ11Accident · No injuriesFinal reportHughes 500 · Little Valley, NYAbout 10 minutes after takeoff in heavy, wet, blowing snow, the engine lost power. At that time, the helicopter was at about 100 ft AGL. At the first indication of a power loss, the pilot initiated and completed an autorotative landing in an open field.…Mar 2, 1982 · N8690F · Substantial damageNTSB LAX82FUA12Accident · Minor injuriesFinal reportBeech 35-B33 · Corona Del Mar, CAWhile climbing through 4000 feet the pilot heard a grinding noise emanating from the engine. Almost immediately thereafter the windshield was covered with oil. The aircraft was force landed in a high school baseball field with the gear up. It slid across the…Mar 2, 1982 · N1418G · Substantial damageNTSB ATL82DA064Accident · No injuriesFinal reportMooney M20F · Belton, KYAfter leveling at 2500 ft, oil fumes were noted, but no abnormal indications were noted on the engine gauges. The pilot suspected oil had been spilled during a repair before takeoff. A short time later, the engine RPM began to increase & was adjusted by the…Mar 2, 1982 · N6318Q · Substantial damageNTSB LAX82FA088Accident · 6 fatalField investigationFinal reportCessna T21OL · Verdi, NVPrior to the acft's departure from truckee-tahoe arpt, an inbound plt recommended via radio that the flt not go because he had just flown thru the donner pass & the wx was terrible. He reported the wind 25-35K, gusting 40-45K. The flt received a wx briefing…Mar 1, 1982 · N93338 · DestroyedNTSB FTW82DA079Accident · No injuriesFinal reportCessna U206 · Noack, TXThe pilot stated that he was on a one hour flight for aerial survey to giddings, Texas and return. The right fuel tank ran dry and he switched to the left tank which indicated nearly 1/4 full. Approximately 20 minutes later, the engine stopped operating. A…Mar 1, 1982 · N5131U · Substantial damageNTSB DEN82DA037Accident · No injuriesFinal reportBell 206B III · Alma, COThe pilot reported that before the accident, the flight had been uneventful and all instruments were reading normal except the tot gauge. Reportedly, it was indicating 750 degrees, which was about 100 degrees higher than normal for his power setting of 70%…Mar 1, 1982 · N580P · Substantial damageNTSB MIA82DA061Accident · No injuriesFinal reportCessna 172L · Lake City, FLWhile enroute, the pilot encountered an area with restricted visibility and with an estimated ceiling of 300 ft. after reversing course, he saw a forest road and elected to land. He reported that during the landing roll, a gust of wind was encountered causing…Feb 28, 1982 · N1026M · Substantial damageNTSB MIA82DA058Accident · No injuriesFinal reportCessna 152 · Miami Beach, FLThe pilot stated that while flying approximately 10 miles southeast of the airport over the ocean the engine started to vibrate. The pilot elected to return to the airport however. A few minutes later the engine oil pressure dropped to zero and the aircraft…Feb 27, 1982 · N24542 · Destroyed