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 FTW88FA006Accident · 3 fatalField investigationFinal reportCessna 172RG · Refugio, TXThe plt continued VFR flt into wx that was IMC. The acft impacted the terrain in an extremely nose low attitude. There was no record of the pilot receiving any pre-flt or in flight weather briefings or forecasts for this flight. A witness reported normal…Oct 16, 1987 · N9693B · DestroyedNTSB NYC88LA007Accident · 1 fatalLimited investigationFinal reportPiper J3 · Island Falls, METhe Piper J-3 cub experienced a power loss while cruising at an altitude described by witnesses as just above the trees. The aircraft was destroyed and the pilot was fatally injured. Examination of the engine disclosed that that fuel drain valve on the fuel…Oct 14, 1987 · N92440 · DestroyedNTSB NYC88DHD01Accident · No injuriesFinal reportBell 206L · Trenton, NJThe loss of engine power due to fuel starvation, and the pilot's poor aircraft handling during the autorotation.Oct 14, 1987 · N16736 · Substantial damageNTSB MIA88FA009Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · St. ThomasAfter departure, aprx 3 miles west of the arpt at St. Thomas, the plt reported to the tower that the flt was returning to land due to a loss of power from the left eng. He secured it, returned to land, & on short final, positioned the landing gear selector…Oct 12, 1987 · N6475Y · Substantial damageNTSB LAX88LA013Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Guam (Pacific Ocean)The pilot experienced a loss of engine power at 1500 feet MSL while on a flight in the marianas islands from saipan to Guam. The aircraft was ditched in ocean waters about 2 miles north of Guam and was not recovered. The occupants were rescued by a U.S. Navy…Oct 12, 1987 · N11939 · DestroyedNTSB DEN88LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lordsburg, NMThe pilot said that he reduced the throttle during the descent to traffic pattern alt at the dusty acres arpt and when he pushed the throttle in, the throttle cable broke. The eng went to idle power and quit. The pilot executed an emergency landing on a…Oct 12, 1987 · N530FL · Substantial damageNTSB ATL88FA010Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, SCThe plts trip home had been delayed one day due to wx enrt. He had called the fss early for a briefing and had been advised that there should be no trouble for a noon depart time. He deptd clemson about 1000 and activated his VFR flt plan. He then contacted…Oct 12, 1987 · N84430 · DestroyedNTSB NYC88LA008Accident · 1 fatalLimited investigationFinal reportBeech F-33A · Concord, NHThe plt obtained a telephone wx briefing then filed an IFR flt plan for a 1030 EDT departure fm Concord municipal airport. The plt rptd off Concord at 800 ft and climbing at 1047. Manchester departure control acknowledged, assigned a transponder code, and…Oct 11, 1987 · N17985 · DestroyedNTSB LAX88LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Porterville, CADuring a normal descent, the engine lost all power. The pilot executed an emergency descent and force landed in a field. An examination of the aircraft wreckage revealed that there was no fuel in the fuel tanks. During a telephone interview, the pilot stated…Oct 11, 1987 · N4120F · Substantial damageNTSB LAX88FA014Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Mount Baldy, CABfr tkof, the plt filed a VFR flt plan & rcvd a wx briefing which included an AIRMET. The AIRMET contained precautionaryinfo abt instrument conds (IMC), icing & mtn obscuration in calif. When the plt opened his flt plan with the fss, he wasagain briefed on…Oct 11, 1987 · N47529 · DestroyedNTSB LAX88LA011Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Luis Obispo, CAThe non-instrument rated pilot became disoriented when he inadvertently flew into a layer of fog while making an enroute descent for landing at his destination. The aircraft collided with trees while the pilot was attempting to execute a climbing course…Oct 10, 1987 · N4342B · Substantial damageNTSB BFO88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dares Beach, MDThe plt stated that after climbing about 2000' & proceeding aprx 3 to 4 mi out over the chesapeake bay, the oil temp began to rise & the oil pressure decreased. He turned toward land, but the eng lost power. Subsequently, he was forced to land in a swampy…Oct 10, 1987 · N55936 · Substantial damageNTSB LAX88IA009Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Ontario, CAFailure of the general aviation aircraft to visually identify the transport aircraft. Factures contributing to the incident were: failure of the general aviaiton aircraft to establish communications with ATC prior to entering the arsa and maintaining a poor…Oct 9, 1987 · N413AA · No damageNTSB FTW88LA002Accident · No injuriesLimited investigationFinal reportMooney M-20-J · Kerrville, TXAcft was substantially damaged when it collided with a road sign and the grnd during an off arpt emergency lndg following a complete eng failure during descent. Plt stated that about 20 mins out from his dest, the oil press decreased into the yellow arc, but…Oct 9, 1987 · N57257 · Substantial damageNTSB ATL88LA004Accident · No injuriesLimited investigationFinal reportCessna 150L · Cordesville, SCThe airplane nosed over during a forced ldg on soft terrain, after experiencing a loss of engine power during descent from cruise. The plt reported that the acft ran out of fuel. He had made an unplanned stop earlier to take on additional fuel, after…Oct 6, 1987 · N11838 · Substantial damageNTSB DEN88LA010Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMTwo balloons, a rally and a firefly, collided in flight during the Albuquerque international Balloon fiesta. The pilot of the firely was climbing at approximately 300 feet per minute when his envelope contacted the basket of the rally. The pilot of the rally…Oct 5, 1987 · N36988 · 2 aircraft · Substantial damageNTSB MIA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Church Hill, MSWhile in cruise flight at 1,000 ft, the eng lost power. The plt performed a forced landing in a soft field and during the landing roll, the acft hit a dirt bank, nosed over, and came to rest inverted. Post crash examination of the fuel system revealed that…Oct 4, 1987 · N9202T · Substantial damageNTSB LAX88LA002Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Carefree, AZDuring the first takeoff attempt, a small portion of the balloon envelope caught fire and was quickly extinguished. The second takeoff attempt was successful. One passenger on the balloon said that the flight was very erratic ranging in altitude from 10 feet…Oct 3, 1987 · N1600P · Substantial damageNTSB ANC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · 45 Nw Anchorage, AKThe pilot stated that he believed he ran out of fuel during the IFR flight.Oct 3, 1987 · N3128L · Substantial damageNTSB MIA88FA001Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Everglades City, FLThe non-instrument rated plt attempted a VFR flt over the Everglades during the hrs of darkness. The acft crashed into a swampy area at a high rate of speed while in a 90 degree left bank. The acft disintegrated on impact. A convective SIGMET was issued about…Oct 2, 1987 · N3RP · DestroyedNTSB MKC87LA183Accident · No injuriesLimited investigationFinal reportCessna 401 · Ames, IAThe unsked pax flt was climbing to cruise altitude having just deptd Ames, IA, when the PIC noticed a fire in the left eng. The PIC aborted the climb and returned to Ames. The left eng was secured before lndg which was uneventful. A post-fire insp of the eng…Sep 30, 1987 · N2UE · Substantial damageNTSB MKC87LA182Accident · No injuriesLimited investigationFinal reportCessna 150K · Dubuque, IANearing completion of a personal xc flt, acft experienced a total loss of power. An emergency ldg was made approximately 3 miles short of destination apt. Acft struck terrain and nosed over. Post flt investigation revealed usable fuel supply exhausted.Sep 30, 1987 · N6206G · Substantial damageNTSB MIA87LA266Accident · Serious injuriesLimited investigationFinal reportAero Commander 720 · 50 Nw San Juan, PRFifteen minutes after a northwest departure from san juan international arpt the plt reported that the flt was returning to land after securing the rt eng due to reported problems. Unable to maintain altitude the acft was ditched aprx 50 miles northwest of…Sep 30, 1987 · N4100S · Substantial damageNTSB NYC87LA263Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Kingston, NHDuring flight, the pilot noticed the engine RPM was high. He was unable to control the RPM with the prop control. He reduced the throttle setting, but soon thereafter, the engine began running rough with a severe vibration. The pilot selected a field for an…Sep 29, 1987 · N7388S · DestroyedNTSB MIA87IA264Incident · No injuriesIncident investigationFinal reportBoeing 727-225 · Hampton, NYA full performance level controller (fpl ctlr) at sector 31 of boston ARTCC was giving familiarization training to another fpl ctlr to familiarize the trainee with a new area that had been transferred from new york ARTCC to boston ARTCC. Sector 31 was…Sep 29, 1987 · N8864E · 2 aircraft · No damageNTSB NYC87FA264Accident · Serious injuriesField investigationFinal reportLockheed L-1011 · Bermuda, BermudaEncounter with undetectable clear air turbulence.Sep 28, 1987 · N317EA · Minor damageNTSB DEN87LA246Accident · No injuriesLimited investigationFinal reportCessna 150K · Aurora, COThe student plt was flying a long cross country instructional flight. The pilot stated he became disoriented at the first check point and followed highways for the remainder of the four hour flight. The engine quit and the pilot landed in a weed filled field.…Sep 28, 1987 · N2554Q · Substantial damageNTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.Sep 27, 1987 · N8751S · Substantial damageNTSB SEA87FA194Accident · Minor injuriesField investigationFinal reportHughes 369D · Seattle, WAThe plt rprtd that while he was in cruise flight at about 1000', the eng lost power. He initiated an autorotation to an athletic field in a city park. Drg his apch, he changed his planned touchdown point svrl times due to personnel on the field. He said that…Sep 27, 1987 · N8613F · Substantial damageNTSB NYC87LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Plymouth, VTWhile cruising at about 5500', the eng lost power & the prop contd to windmill, but the plt was unable to restart the eng. Subsequently, he landed the acft in a rough field. During the landing roll, the prop dug into a mound of dirt & the aircraft flipped…Sep 27, 1987 · N302RB · DestroyedNTSB MKC87LA179Accident · No injuriesLimited investigationFinal reportJenkins Pitts S-1 · Orleans, NEThe pilot stated that the aircraft was cruising at 2,000 ft (AGL) when the engine lost power. He turned toward the nearest suitable emergency airfield but the aircraft's rate of descent precluded this option. The pilot selected a road as alternate, but…Sep 26, 1987 · N4365 · Substantial damageNTSB LAX87LA347Accident · No injuriesLimited investigationFinal reportCessna 182D · San Ramon, CAAfter telling the lineman at calexico, CA to fill the tanks, the plt walked away from the acft to clear customs. When he returned, he loaded his passengers into the acft and departed the arpt. After flying 3 and 1/2 hours the engine stopped and the acft was…Sep 26, 1987 · N8711X · Substantial damageNTSB DEN87LA245Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · Bountiful, UTWhile on a local low level pleasure flt the plt failed to see power lines and an in flight collision with the lines occurred severing the right skid and 90 degree gear box from the acft. A semi-autorotative crash occurred on the bank of a irrigation reservoir.Sep 26, 1987 · N5692D · DestroyedNTSB DEN87LA244Accident · No injuriesLimited investigationFinal reportCessna 140 · San Ysidro, NMThe plt and pax were on a LCL sightseeing flt. The plt stated that he had been flying low and slow at a nose high attitude. The engine began to overheat and did not cool off and the pilot executed a precautionary landing on a dirt road. The acft ballooned and…Sep 26, 1987 · N76907 · Substantial damageNTSB SEA87LA193Accident · No injuriesLimited investigationFinal reportCessna 340A · Tecopa, CAA dual engine failure occurred after the first reduction in power at about 200 feet AGL. The aircraft then descended to the ground. No mechanical reason for the loss of power could be determined.Sep 24, 1987 · N2699S · Substantial damageNTSB MIA87LA252Accident · No injuriesLimited investigationFinal reportCessna 150M · Belle Glade, FLThe student plt stated he was en route along the hillsborough canal when he enctrd a rain shower & retarded the power to 2000 RPM to dscnd. He stated that carb ice formed & the eng lost power. He made a forced landing on a dike. However, as the acft was…Sep 23, 1987 · N704HB · Substantial damageNTSB MIA87FA257Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Geneva, FLFlt experienced engine failure when the number six connecting rod separated from the crankshaft after failure of the connecting rod bearing. During an attempted forced landing during darkness the acft collided with trees and then crashed to the ground.…Sep 23, 1987 · N4010R · DestroyedNTSB SEA87FA190Accident · 3 fatalField investigationFinal reportCessna T210L · Hailey, IDAfter dark night takeoff, acft was observed to execute an immediate left turn up a canyon into rising terrain. During climb, acft lights were seen to perform maneuver characteristic of stall/spin. Investigation showed acft struck terrain slightly nose low. No…Sep 22, 1987 · N2545S · DestroyedNTSB MIA87LA253Accident · No injuriesLimited investigationFinal reportCessna TU206F · Tavernier, FLThe acft ditched in the atlantic about 40 mi e of Tavernier, FL during an extended overwater flt to georgetown, Bahamas. The acft sank after the accident & the plt & his pax were rescued by the USCG unharmed. The fixed base operator where the acft departed,…Sep 22, 1987 · N8741Q · DestroyedNTSB CHI87LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Hillsdale, MITkof and climb to 7000 ft were made on the left fuel tank. Shortly after lvl-off, the plt switched to the rt tank and stayed on it during the initial cruise. The plt then switched back to left tank and abt 10 min later the eng began to lose pwr. Readings were…Sep 22, 1987 · N8799E · DestroyedNTSB SEA87LA191Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Las Vegas, NVThe aircraft was on descent for landing at 6500 feet MSL about 5 miles from the airport when a total loss of power occurred due to fuel exhaustion. At 5000 feet AGL the pilot lowered the landing gear and at about 2000 feet AGL landing flaps were added. The…Sep 21, 1987 · N4500K · Substantial damageNTSB MIA87LA254Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Bristol, FLThe eng began losing power as the plt was en route to spray a field. He was unable to maintain altitude, dumped the load of chemicals & prepared for an emerg landing. While he was attempting to reach an open field, the acft collided with 100 foot trees, then…Sep 21, 1987 · N6647Q · Substantial damageNTSB ANC87FA165Accident · 5 fatalField investigationFinal reportPiper PA-31-310 · Eldred Rock, AKThe flt was clrd on an IFR flt fm whitehorse to juneau, via V-428 to chill intxn, then drct to juneau. Chill intxn was located on V-428, 36 mi south of haines NDB on a bearing of 146 deg. On reaching haines NDB, the plt cancelled his IFR clnc & contd under…Sep 21, 1987 · CGPAC · DestroyedNTSB ANC87LA162Accident · No injuriesLimited investigationFinal reportCessna 206G · 100mi S.Kng Slm, AKThe aircraft experienced an engine power loss while in cruise flight and subsequently undershot a lake during the emergency landing. Examination of the engine revealed the number 2 bearing was found completely disintegrated and missing from its seat. Evidence…Sep 19, 1987 · N756TT · Substantial damageNTSB NYC87FA260Accident · Serious injuriesField investigationFinal reportBoeing 737 · Philadelphia, PAThe acft was in a holding pattern at 11,000' in an area of thunderstorms & turbulence. Although the seat belt sign was on, two passengers (pax) went to the aft lavatory. As one of the pax was waiting & the other was exiting the lavatory, the acft encountered…Sep 18, 1987 · N318AU · No damageNTSB MIA87LA251Accident · No injuriesLimited investigationFinal reportCessna 152 · Plant City, FLThe student plt stated the acft was cruising at 3000 ft, when the eng lost pwr. She selected a fld & made an emerg lndg. Drg the lndg roll, the acft went thru a barbed wire fence, hit a ditch, nosed over & came to rest inverted. The acft had flown a total of…Sep 18, 1987 · N67896 · Substantial damageNTSB NYC87FA257Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Pittsburgh, PAWhile descending out of flt lvl 270 for lndg, usair flight 10 encountered light to moderate turbulence. Prior to this this encounter, the capt advised all passengers and cabin crew to remain seated and to engage their seatbelts. A similar announcement was…Sep 17, 1987 · N774AL · No damageNTSB MIA87LA249Accident · No injuriesLimited investigationFinal reportMooney M20J · Macclenny, FLWhile en route at 8000', the eng lost power & the plt obtained vectors for an emerg landing at an arpt with a grass strip. Drg the roll-out, the left wing tip hit a hay wagon near the end of the rwy, then the acft veered & struck a hangar. An exam of the…Sep 16, 1987 · N201UX · Substantial damageNTSB DEN87LA241Accident · No injuriesLimited investigationFinal reportCessna TU206G · Spanish Fork, UTWhile cruising at 10,500 ft with the power set at 28 inches map & 2350 RPM, the eng suddenly lost pwr & began knocking. The plt noted a rapid drop in oil pressure & saw a 3-inch hole in the top of the eng cowling. He attempted to land on a highway, but was…Sep 16, 1987 · N756HD · DestroyedNTSB NYC87LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Emmaus, PADrg flt, the eng lost power over a residential area & the plt selected a small fenced-in opening for an emergency lndg. He said he crashed nosewheel 1st, then skidded into a cyclone fence. After the acdnt, the fuel selector was fnd positioned to the rgt tank…Sep 15, 1987 · N15793 · Substantial damage