OpenAirDocs.org

NTSB investigations

35,885 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 DEN87LA065Accident · No injuriesLimited investigationFinal reportRaven S60A · Grand Lake, COThe balloon encountered turbulence during normal cruise at 100 to 150 feet AGL, while crossing a ridgeline. Gusts extinguished both burner plt lights and partially collapsed the envelope. The balloon began an uncontrolled descent. The plt re-ignited both…Mar 7, 1987 · N2803L · Substantial damageNTSB BFO87FA027Accident · 2 fatalField investigationFinal reportRockwell 112 · Edgewood, MDOn the day of the accident and before the accident flight, the inlet fuel hose to the fuel flow divider was replaced. The hose assembly was fabricated by maint personnel. An inspection flight afterwards revealed engine roughness during fuel mixture leaning.…Mar 7, 1987 · N112BB · DestroyedNTSB MKC87LA057Accident · No injuriesLimited investigationFinal reportEmbraer EMB-110 · Norfolk, NEThe crew stated they were descending for landing when they flew through a flock of geese that were traveling in the same direction. They received three or four bird stikes. The aircraft landed without further incident.Mar 6, 1987 · N890AC · Substantial damageNTSB MKC87LA055Accident · No injuriesLimited investigationFinal reportCessna 150 · Newton, KSThe stu was practicing simulated engine failures at his cfi's direction. As the stu simulated corrective action in the cockpit to restore pwr, he inadvertently turned the fuel selector off, and did not tell the CFI. Normally the CFI terminated the simulated…Mar 6, 1987 · N704QT · Substantial damageNTSB LAX87FA136Accident · 1 fatalField investigationFinal reportBellanca 7KCAB · Lebec, CAPrior to the flt, the plt rcvd 2 wx briefings & was adzd of low ceilings, restricted visibilities & mtn obscurement along the route. Also, he was adzd that VFR flt was not recommended. The surviving pax said that after entering the mtn area, they contd 'in…Mar 6, 1987 · N8713V · DestroyedNTSB DEN87LA062Accident · No injuriesLimited investigationFinal reportBeech 58 · Bismarck, NDThe plt, while at cruise, detected an odor he suspected to be overheated electrical wiring. He diverted to a nearby arpt for a precautionary landing. The plt shutdown all electrical pwr after communication with the twr. Prior to landing, the plt turned on…Mar 6, 1987 · N9025V · Substantial damageNTSB DEN87FA064Accident · 1 fatalField investigationFinal reportCessna P210N · Roswell, NMThe plt, who never flew at night and who told relatives that he was exhausted after all-day business meetings, nevertheless departed albuquerque, NM, at 1756, en route to Roswell, NM. He contacted Roswell twr at 1844 but never arrived. The wreckage was…Mar 6, 1987 · N6115W · DestroyedNTSB LAX87FA134Accident · 1 fatalField investigationFinal reportMooney M20J · Weed, CABefore takeoff, the plt was adzd that strong head winds, mod to svr turbc, mtn obscurement, multiple layers of icing & deteriorating wx were forecast along his route of flt. He filed an IFR clnc & took off at 1115 PST. While en route, he reqd the medford wx &…Mar 4, 1987 · N201LF · DestroyedNTSB MKC87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Carlisle, ARThe PIC was climbing enroute to a field to spread fertilizer. Abt 2 minutes into the climb the acft eng quit. The forced landing substantially damaged the acft. The PIC commented in his rpt that he should have checked fuel before departure even though he had…Mar 3, 1987 · N6540Z · Substantial damageNTSB FTW87DRA01Accident · Minor injuriesFinal reportStrissel Pitts S1S · Friendswood, TXThe prop separated during flt and the plt was forced to land the acft on rough terrain. Investigation revealed that the prop had separated as a result of a previously existing crack in the eng crankshaft. The eng had been rebuilt from components salvaged from…Mar 2, 1987 · N815DB · Substantial damageNTSB SEA87LA061Accident · Minor injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Haines, AKWhile at cruise a total loss of engine oil pressure occurred with the engine seizing shortly afterwards. The aircraft was force landed into trees in a remote area. The aircraft came to rest inverted. Due to the position of the aircraft, examination of the…Mar 1, 1987 · N200LK · DestroyedNTSB LAX87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Redlands, CADuring a pleasure cross-country flt, the plt reported that he was descending from 8500 ft MSL to 4000 ft MSL with power reduced to 2000 RPM. The plt stated that he did not use the carburetor heat while descending. When pwr was added, the eng did not respond.…Mar 1, 1987 · N5466W · Substantial damageNTSB LAX87FA128Accident · No injuriesField investigationFinal reportBritish Aerospace BA146-200A · Fresno, CAFailure of company maintenance personnel to adequately examine the engine lubrication system when contamination was detected.Feb 28, 1987 · N356PS · Substantial damageNTSB LAX87FA126Accident · Serious injuriesField investigationFinal reportBoeing 747-236B · Los Angeles, CAA Boeing 747-236B crew evacuated all occupants via escape slides after returning to Los Angeles after receiving a specific bomb threat. One passenger sustained serious injury during the evacuation. According to a witness, the 370 passengers evacuated the acft…Feb 27, 1987 · GBDXK · No damageNTSB NYC87FA098Accident · No injuriesField investigationFinal reportCessna 402 · Montgomery, NYBoth acft were operating under visual flight rules in the vicinity of active airports. The Cessna 402 was in a cruise descent. The decathlon was in level flight. Neither pilot in the 402 recalls seeing the decathlon, which was struck on the rt wing. The…Feb 26, 1987 · N36139 · 2 aircraft · Minor damageNTSB CHI87LA088Accident · No injuriesLimited investigationFinal reportBeech C-35 · Lake Station, INThe aircraft struck a guard rail during an emergency landing on interstate 80 after experiencing fuel exhaustion. The pilot had visually inspected his fuel supply prior to the first leg of the flight and thought there was enough fuel for the trip. Inspection…Feb 26, 1987 · N99QE · Substantial damageNTSB LAX87FA142Accident · 2 fatalField investigationFinal reportCessna P206B · Green Valley, CAA Cessna P206B collided with mountainous terrain. Instrument meteorological conditions prevailed at the time. An unoffical weather observation taken the day of occurrence 12 miles east of the accident site indicated an indefinite 100 foot ceiling, 1/4 mile…Feb 23, 1987 · N58RS · DestroyedNTSB LAX87FA121Accident · 4 fatalField investigationFinal reportBeech F33A · Anza, CAThe non-instrument rated plt & 3 pax planned a pleasure flt to mx. The weather was below VFR minimums however the plt elected to attempt the flt. Several minutes after departure the acft was observed to enter an area where it was snowing, the cloud base was…Feb 23, 1987 · N59AB · DestroyedNTSB LAX87LA120Accident · Serious injuriesLimited investigationFinal reportRaven S-55A · Tucson, AZDuring a pleasure flight, the pilot reported that upon take-off, the wind was calm. While in-flight the wind increased and the pilot prepared for a high wind landing. The balloon touched-down hard and hit a bush. The pilot and one passenger were ejected from…Feb 22, 1987 · N4261R · No damageNTSB ATL87FA074Accident · 2 fatalField investigationFinal reportCessna 182P · Crossville, TNThe rental acft collided with the top of a mountain at substantial airspeed in level flt. VFR flt was not recommended by fss due to low ceilings, rain and fog. No flt plan was filed. The plt had not logged a flt for a five month period prior to the accident.…Feb 21, 1987 · N5824J · DestroyedNTSB MIA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Smyrna Bch, FLWhile in cruise flt at an alt of aprx 800 feet the plt reported that the eng began to lose RPM. Unable to maintain alt a forced landing was made on a road. The acft then ground looped due to contact with scrub oak trees, which resulted in severing of the left…Feb 20, 1987 · N25459 · Substantial damageNTSB CHI87LA086Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Camp Douglas, WIThe passenger rprtd that about 5 min after takeoff, the plt became incapacitated & was no longer able to maintain control of the acft. The non-certificated passenger assumed control. With the assistance (instructions) from an airborne flt instructor & an…Feb 20, 1987 · N4601V · Substantial damageNTSB LAX87DVA05Accident · No injuriesFinal reportHiller OH23D · Coalinga, CAThe plt reported that before he began the agricultural aerial application flight he noted that the fuel gauge was inoperative. The plt completed two flights, returning to the loading area after each flight. After completing the third flight and while…Feb 19, 1987 · N46991 · Substantial damageNTSB ATL87LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Nashville, TNThe plt reported that he conducted an ILS appch behind mixed jet and turboprop traffic; the acft encountered an 'extreme downdraft' while on appch and the acft vertical speed went from about 500 fpm to about 1200 fpm. He attempted to recover by adding full…Feb 19, 1987 · N31590 · DestroyedNTSB DEN87IA058Incident · 1 fatalIncident investigationFinal reportBeech 58 · Colorado Spring, COThe PIC became unconscious while at the controls during cruise. The co-owner of the acft, a rated pilot who was in the right front seat, took control and diverted to a nearby apt. The PIC was transported to a hospital where he was pronounced doa. An autopsy…Feb 18, 1987 · N328WT · No damageNTSB DEN87LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Carrizozo, NMThe acft entered clouds over mountainous terrain. The plt's next visual contact was a mountain in his flt path. During maneuvering to avoid a crash the acft struck rough terrain and nosed over.Feb 16, 1987 · N1741F · Substantial damageNTSB MIA87FA084Accident · Serious injuriesField investigationFinal reportCessna 152 · Ochopee, FLThe student pilot while on a cross-country flight encountered poor weather conditions. During a turn and descent to maintain visual contact with terrain the aircraft collided with the ground.Feb 15, 1987 · N773WA · DestroyedNTSB LAX87FA117Accident · 1 fatalField investigationFinal reportCessna 180J · Newhall, CABased on available evidence, it is believed that the accident occurred between 0700 and 0830 hrs during a period of low ceilings and restricted visibilities in the area where the accd took place. The accd site is located in a mountain pass area between two…Feb 15, 1987 · N52184 · DestroyedNTSB CHI87LA082Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Oshkosh, WIAccording to the plt, at aprx 1800 feet 'the engine abruptly quit with no runon or sputter' following takeoff from rwy 18 at Oshkosh, WI. The plt stated that he banked the acft back to the airport, but the aileron controls became jammed or 'frozen'. According…Feb 12, 1987 · N9451W · Substantial damageNTSB BFO87FA022Accident · 2 fatalField investigationFinal reportRobinson R22 · Myersville, MDThe non-instrument rated commercial pilot departed hgr in a Robinson helicopter that was not equipped to fly in instrument conditions. The pilot had not logged any instrument time and elected to depart in IFR conditions under a special VFR clearance. ATC…Feb 12, 1987 · N9073Y · DestroyedNTSB DEN87LA052Accident · No injuriesLimited investigationFinal reportCessna 185C · Cedar City, UTDuring normal descent at seven-thousand ft MSL, acft struck a bird. The left wing tip leading edge incurred a dent twenty-four inches long and twelve inches deep. Directional control became difficult so plt made a precautionary landing on highway I-15, and…Feb 9, 1987 · N2691Z · Substantial damageNTSB NYC87FA138Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Lanesville, NYThe plt and his family dptd 2/8/87 on a ski trip to VT. The flt did not arrive. The acft was fnd on a mtn plateau on 5/2/87. Wx conditions rptdly deteriorated and darkness was apching at the estimated time of the acdt, shortly after sunset. The acft impacted…Feb 8, 1987 · N973E · DestroyedNTSB LAX87LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZDuring a local dual instructional flight, the pilot reported that the aircraft developed a vibration and a substantial power loss. The acft was forced to land off the arpt in the high vegetation. Examination of the aircraft revealed that the #3 cylinder was…Feb 8, 1987 · N24317 · Substantial damageNTSB BFO87FA020Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Mount Airy, MDThe instructor pilot simulated an engine out emergency by retarding the throttle. The student, who had not soloed, became engrossed in handling the emergency. The instructor kept his hand on the throttle throughout the practice maneuver. When he applied full…Feb 8, 1987 · N2459F · DestroyedNTSB NYC87LA078Accident · No injuriesLimited investigationFinal reportCessna 150C · Downingtown, PAA precautionary landing was made in a snow covered level field due to a loss of power for unknown reasons. The aircraft was substantially damaged.Feb 7, 1987 · N66270 · Substantial damageNTSB LAX87LA109Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Vacaville, CADuring a local sightseeing flight, the pilot was flying south approximately 300-500 ft above the ridge looking for lift. The pilot could not find sufficient lift in the area east of the ridge so he flew to the west side where the glider encountered a strong…Feb 7, 1987 · N17871 · Substantial damageNTSB FTW87FA064Accident · 2 fatalField investigationFinal reportCessna 210N · Diboll, TXAcft was destroyed when it impacted the ground in an uncontrolled attitude at high speed. The non-instrument rated pvt plt had filed IFR and departed into M80VC 5 l-f weather with tops above 8,000'. About 20 minutes after departure, the plt reported to the…Feb 7, 1987 · N6497N · DestroyedNTSB FTW87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Waxahachie, TXThe aircraft received substantial damage during an emergency landing. According to the pilot, the engine failed because of carburetor icing. Atmospheric conditions at the time of the accident were conducive to carburetor icing. No mechanical failure or…Feb 6, 1987 · N43542 · Substantial damageNTSB NYC87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Marienville, PAThe Cessna 172 experienced a total loss of power while cruising at 4000 ft on an IFR flight plan. The pilot made a landing on a road and clipped a road sign after touchdown, the aircraft swerved into a ditch and received susbtantial damage. The two occupants…Feb 5, 1987 · CGCGP · Substantial damageNTSB FTW87LA057Accident · 2 fatalLimited investigationFinal reportBell 206L-1 · Matagorda 665The plt took off fm an off-shore oil platform with 3 pax on board. Shortly after depg, he transmitted a 'mayday,' but did not state the nature of the emerg. A pax rprtd that the eng sound changed & the plt told him to 'get the raft out.' Subsequently, the…Feb 5, 1987 · N5012Z · Substantial damageNTSB FTW87FA059Accident · 2 fatalField investigationFinal reportSikorsky S-76A · Angleton, TXShortly after tkof, the plt contacted his company (opns) & said he had inadvertently enctrd IFR conds. He asked opns to relay info to him fm the apch plate for the ILS rwy 17 apch to brazoria county arpt. After rcvg the info, he contacted houston apch ctl &…Feb 5, 1987 · N767AL · DestroyedNTSB FTW87FA054Accident · Serious injuriesField investigationFinal reportPiper PA-22-135 · Floresville, TXThe pilot heard a sudden change in engine sounds during flight and realized his muffler had failed. He was flying about 1000 feet above ground level and initiated a descent to 250 feet. Heat and flames started entering the cockpit through the cabin heat inlet…Feb 3, 1987 · N3554A · DestroyedNTSB FTW87DRD03Accident · Serious injuriesFinal reportSikorsky S-55C · Kurthwood, LAThe engine surged and subsequently lost power during low altitude cruise flight above a dense forest. The pilot autorotated into the trees and then fell through onto the ground. Post accident examination revealed water contamination in the fuel system.Feb 3, 1987 · N418A · Substantial damageNTSB NYC87LA074Accident · No injuriesLimited investigationFinal reportCessna 152C · Washington, CTThe flight departed newport state airport, newport, rhode island on a student solo cross country enroute to waterbury, Connecticut. While over Washington, Connecticut, the aircraft began losing rpms and altitude. The acft was substantially damaged during the…Feb 2, 1987 · N757TZ · Substantial damageNTSB DEN87FA050Accident · 1 fatalField investigationFinal reportCessna TR-182 · Moran, WYThe pilot received several weather briefings prior to departure. Briefings included reports of icing conditions, low clouds and turbulence. VFR flight was not recommended. Plt departed VFR and filed IFR enroute to jackson. The pilot was issued instructions…Feb 2, 1987 · N6089T · DestroyedNTSB NYC87LA072Accident · No injuriesLimited investigationFinal reportCessna 172 · Lawrence, MADuring a simulated engine out, the aircraft collided with power lines, while climbing out after descending over a possible landing area. The aircraft was able to continue flight and land at bedford, Massachusetts without further incident.Feb 1, 1987 · N80116 · Substantial damageNTSB MIA87FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Venice, FLAircraft was seen maneuvering at between 200 and 300 feet in attempts to locate a lost radio controlled model airplane. As the aircraft completed 2 and one half turns it leveled out and began a climb to the north at which time it collided with a 504 foot…Feb 1, 1987 · N3655M · DestroyedNTSB LAX87FA102Accident · 2 fatalField investigationFinal reportCessna 172P · Cuyama, CAThe plt rcvd a preflt briefing before a morning dep fm monterey. At that time, the forecast was for 3000' to 5000' broken clouds with widely scattered rain showers by 1600 & with a gen outlook of VFR. The plt flew to santa barbara to attend a meeting & depd…Jan 31, 1987 · N62127 · DestroyedNTSB FTW87LA055Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Jacksonville, TXThe pilot stated that he had added oil to the engine prior to his departure on a sight seeing flight, but on scene investigation revealed that the engine froze from oil starvation. No evidence of leakage was found. The aircraft had been owner-maintained for…Jan 31, 1987 · N175RF · Substantial damageNTSB DEN87LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Taos, NMThe non-instrument rated plt inadvertently flew into IMC wx; snow, fog, freezing temperatures and low visibility, in mountainous terrain. He made a forced landing on a trail due to lowering visibility, 15 miles southwest of the destination arpt. The terrain…Jan 31, 1987 · N6913L · Substantial damage