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 NYC83FA102Accident · 2 fatalField investigationFinal reportHiller FH-1100 · Gettysburg, PAThe plt took off on a flt to york, PA to refuel the helicopter & to demonstrate it to a prospective buyer while en route. Witnesses observed the helicopter shortly after departure. Two of 4 witnesses heard a change in the sound of the helicopter, 2 witnesses…Apr 26, 1983 · N4034K · DestroyedNTSB FTW83LA205Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Anahuac, TXThe acft groundlooped in ruts during a forced landing after the engine quit. A ground fire destroyed the acft. The acft had approached the field to be sprayed and a witness on the ground said the engine sounded like it was being throttled back. When the pilot…Apr 25, 1983 · N4564 · DestroyedNTSB DEN83LA102Accident · No injuriesLimited investigationFinal reportCessna 180 · Ft. Smith, MTAfter taking off from ft Smith, the plt leveled at 500 ft AGL & followed a river to look at some property aprx 5 mi away. While en route, the engine began to sputter & run irregularily. He performed a successful precautionary landing in a field where he made…Apr 24, 1983 · N9171T · Substantial damageNTSB CHI83LA186Accident · No injuriesLimited investigationFinal reportAerosport Scamp · Edwardsville, ILThe plt was on a test flt in a homebuilt acft with only 3.7 hrs total flt time. While in a full power climb from 1000 to 2000 ft AGL, he noticed black smoke coming from the left exhaust stacks. The power was reduced to a cruise setting, and reportedly, there…Apr 24, 1983 · N15RV · Substantial damageNTSB FTW83LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Anthony, NMThe acft was damaged in a forced landing after a power loss in cruise flt. The plt said the engine began to run rough & then lost power completely. His attempts to restart were unsuccessful and he made a forced landing on a dirt road. Theroad had 3 ft high…Apr 23, 1983 · N8728P · Substantial damageNTSB ANC83IA074Incident · No injuriesIncident investigationFinal reportCessna 185 · Anchorage, AKLoss of power caused by rags stuffed into the engine air induction intake duct forced the pilot to make an emergency landing on a frozen lake.Apr 23, 1983 · N9824X · Minor damageNTSB ATL83LA169Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Prestonburg, KYThe acft had been fueled to its capacity of 72 gal. Aprx 3 1/2 hrs after takeoff, the eng quit while fuel was being used from the left main tank. At that time, the plt knew that the aux tanks were empty, but he thought there was 5 gal remaining in the left…Apr 22, 1983 · N199V · Substantial damageNTSB SEA83FA087Accident · 3 fatalField investigationFinal reportCessna 172P · 2nm E. Of Blyn, WAThe plts had received a wx briefing from seattle fss earlier in the day for a flt from seattle to port angeles. Due to the time span between arrival & departure at port angeles, the wx briefing was not valid for the return flt. The acft impacted the west…Apr 21, 1983 · N52363 · DestroyedNTSB MKC83LA092Accident · No injuriesLimited investigationFinal reportMooney M20K · Trenton, NEThe acft was climbing through 11500 to 12000 ft MSL when the engine made a loud noise followed by a lurch. The oil pressure dropped to zero and the engine developed a roughness. The plt said he shut the engine down at this time, the plt advised denver ARTCC…Apr 20, 1983 · N231KV · Substantial damageNTSB SEA83LA084Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Near Almira, WAThe acft made an emergency landing after an engine failure and fire in flt. The pilot stated that he was enroute to spray wheat when the engine lost power and oil sprayed on the windshield. The pilot smelled smoke, dumped his load and made a landing. When he…Apr 19, 1983 · N9219W · DestroyedNTSB ANC83FA071Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Bettles, AKAccording to witnesses, the acft was seen flying along the trans Alaska pipeline at an estimated alt of 200 ft AGL. As the acft entered a pass, where the pipeline crossed rising terrain, a witness heard the acft's eng power increase, then the plane…Apr 17, 1983 · N4060W · Substantial damageNTSB FTW83LA206Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Prague, OKAfter purchasing the acft, the new owner (a student plt) had asked his uncle (reportedly an experienced plt) to fly his acft home. During the flt, the eng lost power shortly after the plt leveled off at 4000 ft MSL (aprx 3000 ft AGL). There was no suitable…Apr 16, 1983 · N87131 · Substantial damageNTSB CHI83LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Alexandria, MNThe pilot decided to make a precautionary landing after he heard a noise or bang which he thought was the muffler. The pilot made a decision to land on a runway which had an unfavorable wind. Control was lost when a gust of wind raised the left wing. The…Apr 16, 1983 · N8034D · Substantial damageNTSB SEA83LA081Accident · No injuriesLimited investigationFinal reportSmith Miniplane · Near Rainier, ORAprx 20 min after takeoff, the engine lost power. Several restarts were initiated; however, the engine would not continue running. During an emergency landing on sandy terrain, the nose gear dug in & the acft nosed over the plt described the loss of power as…Apr 15, 1983 · N94R · Substantial damageNTSB FTW83FPJ02Accident · Serious injuriesFinal reportCessna R172E · Little, OKThe acft had been landed twice to check for leaking fluid on the windshield. When the fuel pressure went to zero and theengine quit the leak was confirmed to be acft fuel. During a forced landing the acft struck a fence and the nose gear collapsed. The…Apr 15, 1983 · N70HP · Substantial damageNTSB MIA83FU002Accident · 1 fatalFinal reportRotec Rally 2B Ultralight · Palm Bay, FLThe Rotec rally 2B was an unregistered ultralight vehicle that had been assembled from a kit. The plts of two other ultralight vehicles stated that they were in a very loose formation with the one that had crashed. According to them, they were flying at about…Apr 13, 1983 · UNREG · DestroyedNTSB MIA83LA120Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Perry, FLThe acft made a forced landing in a swamp with the gear down and nosed over after both engines quit. The pilot said the acft was full of fuel at takeoff and yet it was empty less than an hour later. The pilot also did not know the quantity of fuel on board…Apr 11, 1983 · N852H · DestroyedNTSB MIA83LA114Accident · 1 fatalLimited investigationFinal reportCessna 310R · Gulf Of MexicoThe plt flew from mobile, al to pensacola, FL, where a passenger enplaned for a flt to columbus, MS. After the passenger disembarked at columbus, the plt took off on an IFR flt plan back to mobile at an altutude of 7000 ft. reportedly, the flt progressed…Apr 11, 1983 · N87498 · DestroyedNTSB LAX83LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150J · San Jose, CAThe acft was rented for a x-country flt form San Jose, CA to san luis obispo & grover city, CA, then return to San Jose. The plt departed San Jose with full fuel tanks. At san luis obispo, 5.3 gal was purchased; however, no fuel was obtained at grover city.…Apr 11, 1983 · N61327 · Substantial damageNTSB LAX83FA188Accident · 2 fatalField investigationFinal reportCessna 182RII · Casa Grande, AZThe acft collided with a lone mountain while in straight & level flight.Apr 11, 1983 · N5541N · DestroyedNTSB ATL83LA159Accident · No injuriesLimited investigationFinal reportCessna 210F · Brunswick, GAThe acft was intentionally landed wheels up after the landing gear extension systems failed to operate. The rt aileron control cable had chaffed a hole in the main landing gear hydraulic line causing a hydraulic leak that depleted the gearextension system of…Apr 11, 1983 · N210AE · Substantial damageNTSB NYC83FA088Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Hawthorne, NYThe flt departed cleveland at 1539. The flt enroute was conducted at 6,000 ft. about 45 mi w of destination the fuel gages indicated 5 gals of fuel in each of the two tanks. At about 5 mi w of the arpt the eng quit. The plt made a forcedlanding on the…Apr 10, 1983 · N8302T · Substantial damageNTSB MIA83FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Gainesville, FLThe acft crashed about 8 miles from the intended destination during weather on a dark night. The plt had gone outbound that afternoon with two passengers who did not return with him because of motion sickness. According to the one of his former instructors…Apr 10, 1983 · N6418V · DestroyedNTSB FTW83LA183Accident · No injuriesLimited investigationFinal reportCessna 175 · Cresson, TXThe acft collided with a ditch during a forced landing after the engine failed in flt. After takeoff, at 3500 ft, the engine began making noises. The plt began a descent toward the arpt a short distance away. The engine maintained some power but failed…Apr 10, 1983 · N753OM · Substantial damageNTSB ANC83FU003Accident · 1 fatalFinal reportPteradactyl Ascender · Girdwood, AKAccording to a witness, the ultralight vehicle had just taken off, had turned to a downwind heading & was climbing, when it began to oscillate longitudinally. After a few oscillations, the vehicle nosed over, the wings folded & the ultralight crashed to the…Apr 10, 1983 · UNREG · Substantial damageNTSB CHI83FA161Accident · 2 fatalField investigationFinal reportCessna 182 · Coulterville, ILDuring a wx briefing before takeoff, the non-instrument rated plt was advised that VFR flt was not recommended. However, he departed sheboygan, WI at aprx 1500 CST with no flt plan. At dusk, witnesses (near the crash site) heard the acft maneuvering. One…Apr 9, 1983 · N92734 · DestroyedNTSB NYC83FA087Accident · 6 fatalField investigationFinal reportPiper PA-32RT-300 · Wellsville, NYJust prior to this flt, the plt had flown from hornell, NY to Wellsville, NY. Before departing hornell, he radioed that the vacuum annunciator light was on, & during a run-up, the suction gauge read zero. Ground personnel advised that with this problem, the…Apr 8, 1983 · N3515M · DestroyedNTSB NYC83FA086Accident · No injuriesField investigationFinal reportCessna 210L · Avon, CTThe acft collided with a tree and broke the nose landing gear during an emergency landing after electrical failure. After the failure, using matches and a flashlight, the plt tried to land but could not find the arpt. The weather was deteriorating so when a…Apr 8, 1983 · N59123 · Substantial damageNTSB FTW83LA184Accident · No injuriesLimited investigationFinal reportBell 206B · Hempstead, TXAcording to the pilot the aircraft was in level flight at 800 feet AGL when the pilot experienced severe yaws in rapid rapid succession. He noticed he torque fluctuating between 30 and 100 pounds, went into autorotation and selected a landing spot heading…Apr 8, 1983 · N3898P · Substantial damageNTSB LAX83LA181Accident · No injuriesLimited investigationFinal reportHiller UH12-E · Kettleman City, CAThe pilot reported that he began flying about 0725 with 23 gallons of fuel on board. He applied a herbicide for about an hour and came back to reload. After reloading he began a return to the area to be sprayed. About 10 minutes later all power was lost.…Apr 7, 1983 · N68024 · Substantial damageNTSB ANC83FA068Accident · 2 fatalField investigationFinal reportBritten-Norman BN-2A-8 · Selawik, AKAccording to the FAA specialist on duty at the nome flight service station the plt of munz northern flt 601 requested only the ambler wx at 0030 gmt. The only surviving passenger stated that the flt deptd nome, AK at 1330 bst and as the flt continued north…Apr 7, 1983 · N37MN · Substantial damageNTSB MIA83LA118Accident · No injuriesLimited investigationFinal reportErcoupe G · Pempbroke Pines, FLThe acft collided with a tree during a forced landing after the engine lost power. Post accident investigation revealed that the fuel strainer was full of water and that the carburetor bowl contained one or two ounces of water. Draining of this water allowed…Apr 5, 1983 · N2175H · Substantial damageNTSB MIA83IA117Incident · No injuriesIncident investigationFinal reportGates Learjet 35A · Near Orlando, FLDuring descent the pilot in command maintained red line airspeed. The aircraft then encountered clear air turbulence, followed by a loss of control. The pilot extended the landing gear to slow the aircraft and regain control.Apr 5, 1983 · N369XL · Minor damageNTSB FTW83LA179Accident · No injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXAccording to the pilot he departed on a trip with an ete of 3.5 hours with an estimated 4.5 hours of fuel on board. After aprx 3.8 hours of flight the engine lost power and the pilot landed the acft on a service road. On rollout the left wing struck a highway…Apr 5, 1983 · N73192 · Substantial damageNTSB ATL83FA155Accident · 1 fatalField investigationFinal reportCessna 182 · Rocky Face, GADuring two wx briefings the plt was advised that wx enroute would be marginal VMC to IMC. He was given a convective SIGMET covering tenessee & north carolina. There was a possibility of thunderstorm activity, low ceiling & visibility, high surface winds,…Apr 5, 1983 · N7439N · DestroyedNTSB SEA83LA079Accident · No injuriesLimited investigationFinal reportErco 415C · Boring, ORThe aircraft collided with a fence and collapsed the nose gear during a forced landing after the engine lost power in cruise flight. The pilot had departed Oregon city earlier to fly to evergreen airport to fuel the aircraft and then to return to Oregon city.…Apr 4, 1983 · N87110 · Substantial damageNTSB NYC83FA091Accident · Serious injuriesField investigationFinal reportCessna 172H · Liberty Corner, NJInvestigation revealed that the plt and passenger arrived at the airport at approximately 1820 EST, requested a special VFR clearance and when that clearance could not be approved requested an IFR flight plan. Attempts to activate the IFR flight plan were…Apr 4, 1983 · N2574L · DestroyedNTSB LAX83LA183Accident · No injuriesLimited investigationFinal reportCessna T310R · Hilmar, CAThe acft lost power on the engines. Power was restored on only one engine and a precautionary landing was made off arpt in a field of alfalfa. The gear was not extended prior to ground contact. The pilot said he switched the fuel selector for power…Apr 4, 1983 · N4060C · Substantial damageNTSB MKC83LA085Accident · No injuriesLimited investigationFinal reportCessna 182F · Concordia, MOThe acft was forced to land in a wheatfield when the engine quit. The student pilot was on a solo cross-country flight cruising at 2000 feet when the engine lost power. The flt. Had started about 30 minutes before the accident. The dew point was 32 and the…Apr 3, 1983 · N3102U · Substantial damageNTSB ATL83FA328Accident · Serious injuriesField investigationFinal reportBoeing 707-323C · Baltimore, MDThe flt encountered turbulence about 20-25 min prior to landing. The flt attendants were retrieving cups & trash at the conclusion of a hot meal service. An attendant was thrown upward striking the ceiling, then fell to the floor causing a lower back injury.…Apr 3, 1983 · N8415 · No damageNTSB LAX83IA174Incident · No injuriesIncident investigationFinal reportDouglas DC-9-82 · 20n Bryce, UTWhile cruising at FL 350 the flt experienced a flame-out of both engines. The crew declared an emergency to salt lake artc center & the flt was vectored toward page,AZ for a possible emergency landing. At 12,200 ft the captain restarted both engines by…Apr 2, 1983 · N1004F · No damageNTSB ANC83LA065Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Palmer, AKAccording to the plt's accident report, he had climbed to 3200 ft, pulled the throttle full back to descend, then the eng stopped. He stated that he tried to start the eng, but was unable, so he landed straight ahead in trees. The acft was destroyed during…Apr 2, 1983 · N2345C · DestroyedNTSB ANC83FA064Accident · 2 fatalField investigationFinal reportPiper PA-12 · Glennallen, AKWitnesses reported that after takeoff, the plt flew by a cabin at approximately 200 ft, signaled by rocking the acft's wings, then began a gradual climb. The climb increased in steepness until 1 witness could see the entire top of the acft. It then nosed…Apr 2, 1983 · N2826M · Substantial damageNTSB DEN83FA089Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Castle Rock, COThe pilot made two enroute stops at places other than planned because he was confused and disoriented. When he could notget a sectional chart he wanted he tookoff without it after one of these landings. After the second landing he took off ignoring a red…Apr 1, 1983 · N4005W · Substantial damageNTSB MKC83FA084Accident · No injuriesField investigationFinal reportCassutt III M Sport · Hiawatha, KSWhile en route at 5500 ft MSL, the plt noticed an oil film start to cover the windshield of the home built acft. At that time, he was approaching hiawath, KS, so he diverted to the Hiawatha arpt. By the time he entered the traffic pattern to land, the oil…Mar 31, 1983 · N1790 · Substantial damageNTSB MIA83LA108Accident · Minor injuriesLimited investigationFinal reportCessna 182 RG · Palm Beach, FLThe acft ditched in the atlantic ocean 5 miles east of Palm Beach FL after an electrical fire and engine failure. The pilot said he departed boca raton at 1950 EST. A few minutes later he experienced an electrical fire and electrical failure. About 2 minutes…Mar 31, 1983 · N55AG · DestroyedNTSB LAX83FVG10Accident · 1 fatalFinal reportChampion 7ECA · Georgetown, CAThe acft collided with a mountainside at the 3500 ft level in a 45 degree nose down attitude after colliding with a 30 ft tree during IMC weather on a dark night. There is no record that the plt received a weather briefing. The pilot was not instrument rated…Mar 31, 1983 · N9548S · DestroyedNTSB DEN83FA090Accident · 2 fatalField investigationFinal reportCessna 150M · Kanab, UTThe acft departed page at about 1150. At about 1238 the acft struck the south slope of a 6,280-FT canyon wall at about 6,000 ft MSL. The canyon is one of a series of about five 'finger' canyons forming the vermilion cliffs group. Sigment lima 15 in effect…Mar 31, 1983 · N714ML · DestroyedNTSB CHI83FA156Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Miltona, MNPrior to separting, the plt was advised of low ceilings & poor visibility over the entire proposed route & was advised that VFR flt was not recommended. In a discussion with persons at fergus falls, MN, he stated that he was going to follow the highway. About…Mar 31, 1983 · N4186R · DestroyedNTSB FTW83FA170Accident · 2 fatalField investigationFinal reportBeech A36 · Enid, OKDuring the early morning hours, the acft crashed at the edge of a wheat field on relatively level terrain. The main wreckage then crossed a road & came to rest in another field. There were no known witnesses. A passing farmer discovered the wreckage at about…Mar 30, 1983 · N18314 · Destroyed