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 NYC83FA052Accident · No injuriesField investigationFinal reportRobinson R22 · Milford, CTThe helicopter collided with a telephone pole during an autorotation forced landing after an engine malfunction. The aircraft was cruising at 500 feet when there was an audible decrease in main rotor and engine RPM. The rotor RPM was between 80-85 percent…Jan 8, 1983 · N9017Y · Substantial damageNTSB DEN83LA048Accident · No injuriesLimited investigationFinal reportCessna P210N · Glade Park, COThe acft landing gear collapsed during a forced landing after an engine failure. The pilot said he lost manifold and oilpressure and turned back toward grand junction when the engine began making loud noises. A landing was made on a slippery road and the acft…Jan 8, 1983 · N3886P · Substantial damageNTSB LAX83LXQ03Accident · No injuriesFinal reportCessna 152 · 2 Mi East Mina, NVThe aircraft made a forced landing on a dirt road, collided with some rocks and nosed over. The engine had failed because of fuel exhaustion. The pilot said he refueled the previous day but did not physically check the fuel the day of the accident. The…Jan 7, 1983 · N25334 · Substantial damageNTSB SEA83FA037Accident · 1 fatalField investigationFinal reportCessna T210N · Portland, ORThe acft collided with the side of a hill during a descent. The pilot had canceled his IFR clearance and radar services were terminated and a frequency change was approved. Shortly thereafter the acft was observed flying beneath the clouds toward the hill…Jan 6, 1983 · N5370Y · DestroyedNTSB NYC83FA049Accident · 2 fatalField investigationFinal reportPiper PA-30 · Atlantic City, NJThe plt had landed at Atlantic City, NJ at aprx 1545 while en route to oxford, CT. Before taking off, he contacted two fss's and both advised that VFR flt was not recommended. The non-instrument rated plt took off at aprx 1920 local time with no flt plan. At…Jan 6, 1983 · N7619Y · DestroyedNTSB DEN83FA045Accident · 1 fatalField investigationFinal reportBell 206B III · Sula, MTThe helicopter crashed tail low and rolled over in an open field during marginal weather. The pilot was flying on an expired student certificate and expired medical. According to a pilot who had worked with him the pilot had no helicopter rating. Witnesses…Jan 6, 1983 · N55LW · Substantial damageNTSB NYC83LA048Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6D · Granville, PAAircraft on cross-country flight ran out of fuel and made an emergency landing in a field and collided with a few scattered apple trees. Ironically there was an airport adjacent to the landing site. The pilot had encountered cloud cover at his destination and…Jan 5, 1983 · N29947 · DestroyedNTSB ATL83LA082Accident · No injuriesLimited investigationFinal reportCessna T210L · Horse Cave, KYThe pilot reported that he encountered turbulence, and at about the same time, the engine began running rough. He began troubleshooting and discovered that the roughness was directly proportional to throttle movement; when the throttle was advanced, the…Jan 5, 1983 · N1741X · Substantial damageNTSB SEA83FA038Accident · 5 fatalField investigationFinal reportCessna T303 · Willard, WABefore takeoff, the plt received a wx briefing & filed an IFR flt plan to Idaho falls, id at 1300 ft. he took off at 1804 PST. At 1814 PST, just prior to calling level at 13,000 ft, he reported he was encountering light turbulence & light rime ice. Aprx 4 min…Jan 4, 1983 · N6087C · DestroyedNTSB LAX83FXQ02Accident · No injuriesFinal reportPiper PA-28-235 · Mammoth Lakes, CAAfter departure from the Mammoth Lakes arpt (elev 7128 ft), the acft was slow to climb & eng power began to deteriorate. It was dark & the plt was unable to reach the departure arpt, so he began an emergency landing on the northbound lanes of highway 395. All…Jan 4, 1983 · N1931T · Substantial damageNTSB FTW83LA075Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Orla, TXOn the 2nd leg of his daily check run from dallas to el paso the pilot reported to ft worth ARTCC that he had an engine failure and was going to land on a road. He did not make the road and landed in open terrain with the landing gear up. Fuel system…Jan 3, 1983 · N5289Y · Substantial damageNTSB CHI83LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenburg, INThe pilot reported that the engine RPM began dropping while he was crusing at 2500 ft. when carburetor heat was applied, the engine stopped running. The pilot was able to restart the engine and get it to 1200 prm, but it stopped again. A forced landing was…Jan 2, 1983 · N7230G · Substantial damageNTSB ATL83LA080Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Laurel, MSAt 11,000 ft MSL during cruise a prop separated from the left eng. The eng was feathered & the plt observed the eng displaced inboard & downward. An emergency landing was made & upon landing the left main gear was found to be retracted. The acft slid to a…Jan 2, 1983 · N5291M · Substantial damageNTSB ATL83FA081Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Beaufort, SCWhile en route in IMC, the ATC controller noted that the acft began to reverse course & asked the plt if he was having a problem. The plt responded that the acft was in clouds, he was having problem with his artificial horizon & that he didn't realize he was…Jan 2, 1983 · N8066P · DestroyedNTSB CHI83LA067Accident · No injuriesLimited investigationFinal reportCessna T210N · Cassville, WIThe pilot stated that he refueled at mobile but did not visually check the fuel tanks. The pilot thought he had 15 gallons of fuel remaining at the time the engine loss power. Fuel tanks were switched from left to right and held on "hi" boost (auxiliary boost…Jan 1, 1983 · N6594N · DestroyedNTSB FTW83LA074Accident · No injuriesLimited investigationFinal reportCessna 210N · Houston, TXEnroute in IMC the acft had a complete electrical failure. The plt descended to VFR conditions & elected to land at weiser arpt. The plt lowered the gear electrically but did not receive a green down & locked indication. He then pumped the emergency extension…Dec 31, 1982 · N6610Y · Substantial damageNTSB LAX83LA031Accident · No injuriesLimited investigationFinal reportCessna 150M · Coalinga, CAThe pilot stated that due to visibility restrictions caused by haze, he was flying by reference to interstate highway I-5 at low altitude. He estimated that the visibility was between 3 and 5 miles. At the intersection of I-5 and panoche road, the aircraft…Dec 30, 1982 · N6066K · Substantial damageNTSB FTW83IA072Incident · Minor injuriesIncident investigationFinal reportMcdonnell-Douglas DC-10-30 · Thermal, CAAt about 1458 PST, the aircraft encountered moderate to severe clear air turbulence for a period of 8 to 10 seconds while climbing through 35,500 ft. seven passengers and seven flight attendants received minor injuries. The seat belt sign had been turned on…Dec 30, 1982 · N137AA · No damageNTSB CHI83LA066Accident · No injuriesLimited investigationFinal reportCessna 182N · Jeffersonville, INThe aircraft engine quit at 2500 feet after takeoff. The pilot could not restart engine. A forced landing was made in anopen field and the aircraft nosed over during the rollout. No reason for the engine power loss was determined.Dec 30, 1982 · N9180G · Substantial damageNTSB ATL83LA077Accident · No injuriesLimited investigationFinal reportBeech 58P · Charleston, SCAbout 40 mi from destination in heavy rain, both alternators failed. Electrical load was reduced & a radar monitored ILS apch was made. After descent through the clouds into VMC an attempt was made to lower the landing gear electrically. At that time all…Dec 30, 1982 · N2038P · Substantial damageNTSB ATL83FKG07Accident · Serious injuriesFinal reportPiper PA-28R-200 · Lumber City, GADuring flight, the oil pressure began dropping rapidly just after the engine RPM abruptly increased. Minutes later, the RPM decreased and the engine failed. While the pilot was making a forced landing in darkness, the aircraft struck an object just before…Dec 30, 1982 · N2805R · DestroyedNTSB DEN83FA041Accident · 1 fatalField investigationFinal reportCessna T210M · Robertson, WYThe acft collided with gently rolling snow covered terrain. A small empty plastic medicine bottle labeled nadalol was found at the wreckage. Nadalol is used to control dizziness, fatigue & mental depression, & is basically a beta blocker. According to the…Dec 28, 1982 · N6252B · DestroyedNTSB FTW83LA069Accident · No injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe eng quit while the amphibious acft was over the city. The acft had insufficient altitude to reach the Mississippi river & the plt made a forced landing on a residential street. The left main tank contained 14 gals of fuel & no usable fuel was in the right…Dec 27, 1982 · N121BJ · Substantial damageNTSB FTW83LA067Accident · No injuriesLimited investigationFinal reportBeech C23 · Childress, TXDuring flight, freezing rain was encountered which began to accumulate on the windshield and wings. The pilot reported that he checked and found that the clouds had closed in behind. He diverted to Childress, TX. While en route, additional ice accumulated on…Dec 26, 1982 · N9256S · Substantial damageNTSB FTW83FRD01Accident · 3 fatalFinal reportPiper PA-28R-200 · Henderson, LAThe pilot and two passengers were on a flight from beaumont, TX to covington, LA. The non-instrument rated pilot departed on a special VFR clearance. At that time, the weather at beaumont was 300 ft overcast, visibility 12 mi. When the aircraft was about 10…Dec 26, 1982 · N5369T · DestroyedNTSB FTW83FA087Accident · 7 fatalField investigationFinal reportPiper PA-32-300 · Animas, NMThe acft departed ague prieta, sonora, Mexico with no flt plan on a flt to janos, chihuahua, Mexico. Drg departure, the plt's son observed a dark threatening cloud bank in the direction of flt near a mtn range. When the acft did not arrive at the destination,…Dec 26, 1982 · XAHIJ · DestroyedNTSB CHI83LA065Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot took off with an estimate 4 hrs of fuel on board. While en route, he encountered headwinds that were stronger than expected. After about 3 hrs and 48 min of flight, he was still about 27 to 28 mi from his destination and diverted to the Dayton…Dec 25, 1982 · N3136T · Substantial damageNTSB ANC83LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hope, AKThe aircraft lost power during descent and crashed into trees. The weather was VMC and no flight plan was filed. The pilot said he was descending with reduced power and when he turned carburetor heat on the engine began to miss so he turned carburetor heat…Dec 25, 1982 · N8653Y · Substantial damageNTSB FTW83FA066Accident · 3 fatalField investigationFinal reportBell 206B · San Antonio, TXThe acft departed brackettville at 0715 & at 0740 contacted uvalde UNICOM for their wx. When informed that uvalde was "zero-zero" the flt continued east. The acft was later observed & heard flying above the low indefinite ceiling shortly before impacting the…Dec 23, 1982 · N206H · DestroyedNTSB FTW83LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Nash, OKPilot encountered fog and decided to land in a wheat field looked frozen but was soft and aircraft nosed over. There were 3 local airports within 20 miles.Dec 22, 1982 · N14084 · Substantial damageNTSB MKC83FA041Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Bancroft, IAThe acft impacted the ground in a near wings level, 20 deg nose down attitude at a high rate of speed. Witnesses statedthat the weather was clear & visibility good but it was a very dark night with only a very small portion of the moon showing. The only…Dec 20, 1982 · N2838V · DestroyedNTSB NYC83FA045Accident · 1 fatalField investigationFinal reportCessna 182N · Ringwood, NJThe plt declared an emergency due to power loss & the acft crashed into a reservoir. Engine examination disclosed numerous pieces of the induction air filter throughout the engine. Filter paper was found lodged between the intake valve & valve seat of the #5…Dec 18, 1982 · N92612 · Substantial damageNTSB CHI83LA061Accident · No injuriesLimited investigationFinal reportCessna 310R · Gaylord, MIPrior to a flight from charleston, WV to sault ste marie, MI, the pilot was briefed to expect icing conditions. During the flight, mixed and rime icing conditions were encountered; however, the deicing equipment removed it satisfactorily. An update weather…Dec 18, 1982 · N1777E · Substantial damageNTSB SEA83FYM02Accident · 2 fatalFinal reportEnstrom 280C · North Plains, ORAt about 0530 PST, the pilot departed from his home at ridge field, WA on a flight to hillsboro, OR. According to the pilot's instructor, the normal route used for this trip would been to proceed on a southerly heading to cornelius pass, go through the pass,…Dec 17, 1982 · N5686Z · DestroyedNTSB MKC83FA038Accident · No injuriesField investigationFinal reportPiper PA-32R-300 · Dewitt, NEAs the flt approached destination the alternator began to malfunction. Plt continued to destination which was IMC, and as the gear was lowered during an instrument approach the nose gear indicated unsafe. The approach was discontinued and the plt climbed back…Dec 17, 1982 · N6855F · Substantial damageNTSB MIA83LA051Accident · No injuriesLimited investigationFinal reportCessna 172 · Near Ramey, PRDuring cross-country VFR day flight pilot became lost and was receiving radio help in orientation when fuel was exhausted and aircraft ditched about 68 nmi north of Ramey, PR.Dec 17, 1982 · N4481L · DestroyedNTSB FTW83FA060Accident · 4 fatalField investigationFinal reportBeech A36 · Carlsbad, TXThe pilot and passengers had departed the san angelo airport at about 1800 CST on the day of the accident. They stopped at midland, TX where they borrowed a courtesy car and drove to a restaurant. Later, the aircraft departed on a return flight. At about 2320…Dec 17, 1982 · N6662Y · DestroyedNTSB DEN83LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cut Bank, MTThe aircraft experienced a total electrical failure while enroute. On arrival, the pilot selected gear down, however it would not lower. He misidentified the operation of the emergency gear down switch and pushed it up instead of down. The pilot stated that…Dec 17, 1982 · CGKBJ · Substantial damageNTSB DEN83LA034Accident · No injuriesLimited investigationFinal reportCessna TR182 · Billings, MTAfter power failure pilot landed on a highway and collided with an auto. No evidence of fuel was found in the aircraft.Dec 17, 1982 · N756AX · Substantial damageNTSB SEA83LA032Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Chemult, ORThe flt encountered heavy snow enroute & the eng quit. During the autorotation the plt maneuvered to avoid hitting a railroad signal trestle but struck several railroad signal cables & crashed. The acft was not equipped with a particle separator, nor was the…Dec 15, 1982 · N90876 · Substantial damageNTSB LAX83FUJ08Accident · Minor injuriesFinal reportCessna T210M · Phoenix, AZAircraft landed gear up short of destination in open field when fuel was exhausted. Pilot did not visually check tanks because a ladder was not available at the last stop before accident.Dec 15, 1982 · N761CH · Substantial damageNTSB MKC83IA035Incident · No injuriesIncident investigationFinal reportBeech 100 · Wichita, KSPilot reported that while cruising at 18000 feet, the pressurized portion of the second window blew out. The inside window remained intact and the cabin slowly depressurized. The pilot made an uneventful landing. The window was replaced by a later production…Dec 13, 1982 · N85BH · Minor damageNTSB ATL83LA062Accident · No injuriesLimited investigationFinal reportCessna 182 · Phenix City, ALAircraft had power loss during cruise and during the off airport landing a soft spot was hit and aircraft nosed over. Contaminates were found in fuel. Tank caps did not seal properly. Visual inspection of the fuel cell bladder disclosed permanent 1/2 to 3/4…Dec 13, 1982 · N52742 · Substantial damageNTSB ANC83LA021Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Gambell, AKOn 12/12/82, the aircraft departed on a flight from savoonga to nome, AK. After departure, the pilot noted a problem with the left engine and diverted to Gambell, AK. While en route to Gambell, there was a gradual loss of oil pressure. After landing, the…Dec 13, 1982 · N8225Y · Substantial damageNTSB NYC83FA041Accident · 1 fatalField investigationFinal reportCessna 177B · Starrucca, PADuring a weather briefing before takeoff, the student pilot was advised of icing conditions, turbulence, snowshowers and snow squalls along ridges north of the wilkes-barre/scranton, PA area. The weather briefer indicated that VFR flight was not recommended.…Dec 12, 1982 · N34595 · DestroyedNTSB ATL83FA060Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Summerville, WVOn 12/10/82, the student plt departed on a supervised solo x-country from moundsville, WV to huntington, WV, white sulpher springs, WV and back to moundsville. Wx conds deteriorated drg the 1st 2 legs of the flt and the student's flt instructor (CFI) told him…Dec 11, 1982 · N1621R · Substantial damageNTSB CHI83IA054Incident · No injuriesIncident investigationFinal reportGates Lear Jet 35A · Over Fargo, NDWhile level at FL370 Over Fargo, ND, the crew heard a loud bang in the engine area and the aircraft experienced a sudden loss of cabin pressure. At the same time, the crew noticed that they had lost power on the #2 engine. After securing the engine and…Dec 10, 1982 · N1500E · Minor damageNTSB ATL83LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heflin, ALWhile on a pleasure flight the pilot experienced a fluctuation in his alternator indicator. Soon afterwards the alternator panel warning light came on. The pilot assumed his battery had gone dead after his radio lights also ceased to operate. At that point…Dec 10, 1982 · N22199 · Substantial damageNTSB LAX83IA056Incident · No injuriesIncident investigationFinal reportCessna 551 · Near Palm Sprin, CAShortly after takeoff and climbout, the autopilot malfunctioned after the aircraft entered an overcast and encountered rain and turbulence. The pilot returned to bermuda dunes, CA. After landing he had the electrical, avionics and auto pilot systems checked.…Dec 9, 1982 · N1218V · Minor damageNTSB LAX83FA055Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · 500 Nm E, Honolulu, HIThe acft departed oakland, CA at 1733 PST on a night flight to honolulu, HI. The flt proceeded without incident until aprx 0050 PST when the plt advised that the left eng was slowly losing oil pressure. At that time, the acft was at an alt of 6000 ft. at…Dec 9, 1982 · N74957 · Destroyed