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 SEA85LA194Accident · No injuriesLimited investigationFinal reportCessna 150F · Pocatello, IDUpon arrival in the vicinity of his destination the plt commenced a reduced pwr descent while in conditions which were conducive to carburetor iceing. During the descent the plt applied carburetor heat with a resultant drop in RPM and, apprehensive of this…Aug 11, 1985 · N8339G · Substantial damageNTSB NYC85LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lakewood, NJWhile returning to Lakewood airport,, power was lost suddenly. The pilot elected to land in a stand of pine and oak trees instead of landing on a busy highway. The pilot decided that the distance was too great for a glide to the airport. A post crash…Aug 11, 1985 · N6317J · Substantial damageNTSB FTW85LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Falfurrias, TXThe plt experienced in-flt directional gyro problems (exessive precessing) which resulted in large deviations on either side of his planning flt path. After realizing it was inaccurate he continued using it for some of his heading info. The acft continued to…Aug 11, 1985 · N1020D · Substantial damageNTSB CHI85LA348Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNPilot had dept with minimum fuel for the 60 mi x-country flt. He overflew dest by 25 mi and after correcting course ran out of fuel 2 mi short of the aprt. While landing on a country road acft veered into a ditch.Aug 11, 1985 · N53264 · Substantial damageNTSB BFO85IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Richmond, VAThe flt was in cruise at FL 350 when the cabin crew reported a cabin fire in the vicinity of seat 28A. Shortly after, a lower aft body overheat warning was recvd. The flt diverted to Richmond, VA. During descent, the flt crew performed the appropriate…Aug 11, 1985 · N8856E · Minor damageNTSB NYC85LA181Accident · 1 fatalLimited investigationFinal reportHughes 269C · Altoona, PAThe helicopter with cfi/owner and student who was flying from the left side over high terrain at about 70 mph reported a gradual loss of power. The CFI took control and attempted to effect an airstart. This was without success. The plt then attempted to…Aug 10, 1985 · N8615E · Substantial damageNTSB MKC85FA180Accident · 1 fatalField investigationFinal reportRyan ST-A · Versailles, MOThe plt of another (accompanying) acft, had briefed the plt of N17351, on wx that could be expected en route. Instead of following the other acft as he had been briefed, the plt of N17351 got in the lead. While en route, he was observed to fly under the edge…Aug 10, 1985 · N17351 · DestroyedNTSB DEN85LA215Accident · No injuriesLimited investigationFinal reportCessna U-206 · Bullfrog Basin, UTThe plt was flying on a VFR x-county flt when he allowed the rt fuel tank to run dry which resulted in eng stoppage. After switching fuel an attempted eng restarted was unsuccesfull. The subsequent forced lng resulted in substantial damage to the acft.Aug 10, 1985 · N2187F · DestroyedNTSB NYC85FA205Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Cape May, NJCrew members of a coast guard helicopter, observed an acft flying at about 1500 ft above the water. According to them, the acft pitched down into a 60 to 70 deg nose low attitude & collided with the water. The helicopter was immediately flown to the acdnt…Aug 9, 1985 · N3462M · DestroyedNTSB FTW85LA315Accident · Minor injuriesLimited investigationFinal reportBell 206B · Damon, TXThe plt experienced an eng deceleration to flt idle while cruising 1000 MSL. He autorotated into trees in a heavily wooded area. A subsequent eng disassembly and examination revealed the pwr control line, p/n 6848471-B, was broken at its attaching 'b' nut…Aug 9, 1985 · N22952 · DestroyedNTSB DEN85FTE07Accident · 2 fatalFinal reportRichard A. White Glasair SH-2 · Rawlins, WYThe acft crashed in a slightly nose low high velocity impact with the eng operating at low pwr by the signatures on the prop. The radar plot shows that the flight descended from aprx 15000 ft to about 10000 ft in aprx 1 minute. The acft continued to descend…Aug 9, 1985 · N39RW · DestroyedNTSB CHI85IA339Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Detroit, MIOn August 7,1985 at 2000 EDT, a Mcdonnell Douglas DC-10-10 N111AA registered to American airlines, inc., had a piece of the engine exit the engine case and cowling. On climb to cruise at Detroit airport, Detroit, Michigan, while on a passenger flight. Visual…Aug 8, 1985 · N111AA · Minor damageNTSB MIA85LA225Accident · No injuriesLimited investigationFinal reportCessna 210L · Longwood, FLThe acft was 12 miles out & cleared for a visual apch when the plt reported total loss of eng power. Examination of the wreckage disclosed about four fluid ounces of fuel remaining in fuel tanks. Entry on maintenance discrepancy sheet read 'fuel gauges are…Aug 6, 1985 · N1752X · DestroyedNTSB DEN85LA210Accident · No injuriesLimited investigationFinal reportHughes 369D · Cheyenne, WYThe flt was a pipeline patrol operation. While in flt, smoke was observed in the cabin. The plt made an unsuccessful autorotation resulting in substantial damage to the helicopter. Investigation revealed the smoke was from an inflight eng compartment fire.…Aug 6, 1985 · N8662F · Substantial damageNTSB DEN85FQA04Accident · Serious injuriesFinal reportStar Duster Too SA-300 · Grants, NMThe pilot-in-command of N65010, a starduster ii on 8/6/85 took off from Grants, NM at about 1100 MDT, south bound to intercept winslow, AZ VOR, radial 255. When trying to gain altitude the pilot stated the aircraft felt the effects of density altitude making…Aug 6, 1985 · N65010 · Substantial damageNTSB CHI85LA336Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Red Lake Falls, MNThe acft contacted wires during an aerial application flt. The plt stated he was maintaining extra alt to avoid tall weeds and the clearance below the wires was misjudged. The wires severed the vertical fin and rudder.Aug 6, 1985 · N2350Y · Substantial damageNTSB DEN85LA209Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Superior, MTThe plt was flying with his wife on a pleasure flight to Idaho when smoke started coming into the cabin. Engine oil pressure went to zero. The plt secured the engine and made a forced landing to a farmer's field. The acft was substantially damaged; however,…Aug 5, 1985 · N8976K · Substantial damageNTSB CHI85FA334Accident · 1 fatalField investigationFinal reportCessna 182Q · Walworth, WIThe pilot took off with weather conditions of 100 ft ceiling & visibility of 1/4 mile. Theflight tookd off to the south & crashed in a corn field south of the airstrip tracking 058. The engine was heard at a high power setting just prior to impact.Aug 5, 1985 · N11VS · DestroyedNTSB CHI85LA335Accident · No injuriesLimited investigationFinal reportBeech A23A · Griffith, INThe preflight and takeoff were uneventful. Shortly after takeoff the plt experienced a partial pwr loss and discovered that he could not maintain level flt. He then performed a forced landing in a fld. Following the accident an FAA airworthiness inspector…Aug 4, 1985 · N6937Q · Substantial damageNTSB ATL85FA234Accident · Serious injuriesField investigationFinal reportAerospatiale AS-355F · Chamblee, GAReportedly, the plt & passengers had gone to a local establishment, where the entire party had consumed an unspecified amount of alcoholic beverages. One passenger reported that after arriving at the arpt, the plt made a walk-around inspection of the…Aug 4, 1985 · N299FE · DestroyedNTSB FTW85LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Katy, TXThe plt stated he had his destination arpt in sight and then lost sight of it. While attempting to locate the arpt the eng lost pwr. He attempted a emergency landing on an interstate hwy 10 west of houston, TX. After touchdown and during rollout the right…Aug 3, 1985 · N93980 · Substantial damageNTSB ATL85LA238Accident · No injuriesLimited investigationFinal reportEipper MX-2 · Greenville, SCWhile climbing altitude the parachute , which was secured to the right seat, was inadvertently deployed and became tangled in the propeller. The acft descended to the ground while inverted at a slow rate.Aug 3, 1985 · N3986K · Substantial damageNTSB ATL85LA231Accident · No injuriesLimited investigationFinal reportCessna 152 · Hilton Head Is., SCThe commercial/cfi plt and a passenger were flying just off shore at about 700 ft when the engine quit. He could not clear trees along the shore and the beach was unusable due to fallen trees. The plt landed in the ocean and both occupants swam to shore. The…Aug 3, 1985 · N67998 · DestroyedNTSB ATL85LA229Accident · No injuriesLimited investigationFinal reportCessna 150K · Orchard Hill, GAThe acft suffered a loss of pwr due to fuel exhaustion and the plt made an emergency landing in a fld. During landing roll the acft collided with trees at the end of the fld. Post accident exam of the acft revealed one gallon of fuel in the right fuel tank…Aug 2, 1985 · N5773G · Substantial damageNTSB FTW85LA303Accident · No injuriesLimited investigationFinal reportCessna 150M · Horntown, OKThe acft experienced an intermittent power loss in cruise flt. The plt's attempts to remedy the problem were not successful and he elected to execute a precautionary landing on a road. During the landing, the acft struck a wire and veered into trees along the…Aug 1, 1985 · N187AR · DestroyedNTSB DEN85LTM05Accident · Serious injuriesFinal reportInterstate S-1A · Rock Springs, WYWhile on a x-country flt, the acft encountered turbulence & downdrafts. The plt stated that at 1st, he was not concerned, but then it became apparent that the acft may impact the ground. The acft had limited power (75 HP) & the terrain elevation in that area…Aug 1, 1985 · N37438 · Substantial damageNTSB DEN85LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Clovis, NMWhile in level cruise flight at 17,000 ft, pilot noticed sound change in cabin. All instrument readings were normal with the exception of manifold pressure drop from 32 to 25 inches. Engine began to sputter and run rough. Oil pressure warning light blinked…Aug 1, 1985 · N2232R · DestroyedNTSB NYC85LA200Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Duanesburg, NYAccordidng to the pilot, he was making a low pass over Duanesburg airport to observe the area before landing. While over the airport, the engine quit and he had to make an emergency landing on route 20. The pass was made at about 300 to 400 feet above the…Jul 31, 1985 · N5197U · DestroyedNTSB NYC85FA201Accident · 1 fatalField investigationFinal reportCessna C-177B · Macungie, PAWitnesses saw the acft descend in a near nose dive attitude during a severe thunderstorm. The plt was not in radio communication with gnd facilities. Examination of the acft did not disclose evidence of malfunction. There was no evidence of plt impairment or…Jul 31, 1985 · N34672 · DestroyedNTSB CHI85FA325Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Eureka, WIPrior to takeoff the pilot calculated that with 48 gallons of fuel he could make the four hour flight to oshkosh with one hour of fuel to spare. Upon arriving at a point 25 mi sw of oshkosh he received a request to descend 1200 ft, a request to climb 1200 ft…Jul 31, 1985 · N8503E · Substantial damageNTSB ATL85LA228Accident · No injuriesLimited investigationFinal reportCessna A188B · Clanton, ALThe acft collided with a fence & a ditch during a precautionary off-arpt landing in a pasture. The plt reported that following the completion of aerial application operations, thunderstorms were blocking his return to the arpt. He had elected to land to await…Jul 31, 1985 · N9381G · Substantial damageNTSB MIA85LA222Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Colquitt, GAThe aircraft was substantially damaged and the pilot uninjured when the aircraft flipped upside down in a field during a forced landing in an open field following engine failure. A post accident examination of the engine revealed the number seven cylinder…Jul 30, 1985 · N3647X · Substantial damageNTSB CHI85LA324Accident · No injuriesLimited investigationFinal reportBoeing E75 · Delavan, WIThe acft nosed over during a forced lndg after the eng quit. The plt said he ran out of fuel.Jul 30, 1985 · N5191N · Substantial damageNTSB ATL85LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Camden, SCWhile the acft was flying over wooded terrain, the eng lost power. The plt saw a plowed field aprx 3 mi away & began an emerg apch to the field. The acft struck the tops of trees on final apch, but continued flying until the plt made a gear up landing. An…Jul 30, 1985 · N6707V · Substantial damageNTSB SEA85FYM03Accident · 2 fatalFinal reportCessna 170B · Manzanita, ORAircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport.Jul 29, 1985 · N8011A · Substantial damageNTSB SEA85FA181Accident · 2 fatalField investigationFinal reportPiper PA-22 · Ketchum, IDStudent pilot on cross country flt, route thru mountain pass and mountains. Attempted emergency landing on highway. During approach and while turning toward selected landing site, plt inadvertantly set full nose down trim with half flaps. As acft completed…Jul 29, 1985 · N4445A · DestroyedNTSB DEN85FA202Accident · 1 fatalField investigationFinal reportCessna 172RG · Wilsall, MTThe plt obtained a wx briefing that forecast IMC. He filed a VFR flt plan and departed polson, Montana at 0830 en route to powell, Wyoming. The plt said he encountered low ceilings, low visibilities, and drizzle just past helena, Montana but he continued. The…Jul 29, 1985 · N6156R · DestroyedNTSB SEA85LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jarbridge, NVShortly after departure the left wing was raised by a gust of wind. During correction the aircraft then yawed right. Almost full aileron was used to maintain level flight. The aircraft then descended to the ground. Inspection of the aircraft revealed no…Jul 28, 1985 · N7AT · DestroyedNTSB MKC85LA171Accident · Minor injuriesLimited investigationFinal reportBellanca 17-31A · Cozad, NEThe plt reported that during a descent to land at kearney, NE, the eng lost power & oil oozed out of the cowling & covered most of the windshield. During a forced landing apch, he released his seat belt so he could see thru a small section of the windshield.…Jul 28, 1985 · N6598V · Substantial damageNTSB CHI85LA319Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Madelia, MNDuring cruise engine power was lost. The pilot was unable to restart the engine. During landing in an oats field the acft nosed over.Jul 28, 1985 · N7619K · Substantial damageNTSB CHI85LA318Accident · No injuriesLimited investigationFinal reportBeech C33-A · Hobart, INThe eng lost complete pwr during cruise. The plt landed on a road and the acft collided with a pile of gravel. Fuel was found in both tanks, however, the bladder fuel tanks were found partially collapsed. The fuel cap 'o' rings were to be replaced but were…Jul 28, 1985 · N1CK · Substantial damageNTSB MKC85FA168Accident · 1 fatalField investigationFinal reportSchubert Cassutt Sport · Admire, KSAt 0847 CDT, July 27, 1985 N1115G radioed a nearby fss. The station that was called was closed but another fss heard thecall. During the transmission the plt reported that he had an eng problem, was pumping oil overboard and could not see outside because the…Jul 27, 1985 · N1115G · DestroyedNTSB CHI85LA329Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student plt originally planned a x-country flt from janesville, WI, to champaign, IL, to galesburg, IL & back to janesville. The total route of flt was aprx 390 mi. The plt had calculated that he needed 3-3/4 hrs of fuel. At champaign, he purchased an…Jul 27, 1985 · N67455 · Substantial damageNTSB CHI85LA321Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Delaware, OHTotal loss of engine power occurred in the descent. The flight was vectored toweard the nearest airport but was unable to reach the runway. The aircraft was landed in a rough field. The left magneto was found seized during engine examination.Jul 27, 1985 · N110CF · Substantial damageNTSB MIA85LA220Accident · No injuriesLimited investigationFinal reportCessna 150F · Apalachicola, FLThe plt stated that he elected to land at Apalachicola due to wx in the area, but on final apch, the eng started to run rough, then quit. He landed short of the rwy in a swampy area & upon touchdown, the acft flipped over on its back. Exam of the acft after…Jul 26, 1985 · N8665G · Substantial damageNTSB MIA85LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · South Bay, FLThe eng lost pwr during a sightseeing flt at 1200 ft MSL and the plt selected a divided hwy for an emergency landing to the west. Because he was overtaking a truck on the westbound lanes, the plt tried to land on the median strip. The acft was caught in the…Jul 26, 1985 · N32576 · Substantial damageNTSB DEN85FA200Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Rosa, NMThe plt departed dalhart, TX on a night x-country to quemedo, NM. En route he stopped and picked up a friend at hereford, TX. He did not file a flt plan. He was lost off of radar just west of Santa Rosa, NM, where the wreckage was later found. The acft was…Jul 26, 1985 · N130T · DestroyedNTSB CHI85FA314Accident · 4 fatalField investigationFinal reportBeech J35 · Eden Prairie, MNThe plt's windscreen became covered with oil shortly after takeoff. The plt returned to the arpt attempting to set up a pattern for landing. The acft was observed in a descent and turn to final apch. The acft collided with the ground in a descending left…Jul 26, 1985 · N687B · DestroyedNTSB ATL85IA225Incident · No injuriesIncident investigationFinal reportBeech 95-B55 · Gilbertsville, KYThe acft made a precautionary lndg after the plt feathered the left eng because of vibration. Post accident exam showed a failed cylinder in the engJul 26, 1985 · UNK · Minor damageNTSB MIA85LA218Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawtey, FLThe acft had not been flown for two years. During the preflt inspecton, the fuel sumps were drained repeatedly & each time, a quantity of water was observed in the collected fuel sample. Aprx 30 mins after takeoff, the eng failed & a forced landing was…Jul 25, 1985 · N8151X · Destroyed