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 ANC88LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pilot Point, AKThe non-certificated Pilot reported that he had just purchased the accident airplane the preceding day, and had only flown it for a period of two hours or so. On the accident flight, he had been airborne less than 10 minutes when the engine reportedly began…Jul 30, 1988 · N2212F · Substantial damageNTSB MKC88LA142Accident · No injuriesLimited investigationFinal reportShirlan Dickey E-RACER · Dubuque, IAAt a fuel stop in Dubuque, IA the PIC purchased fuel for the final leg of his flt to oshkosh. After a pre-flt chk and subsequent eng runup, the PIC took the active rwy and commenced a takeoff roll. The lift off and initial climb went without difficulty until…Jul 29, 1988 · N131RD · Substantial damageNTSB LAX88FA273Accident · Minor injuriesField investigationFinal reportRearwin 8500 · Glendale, CASeperation of an engine cylinder that moved into the plane of the wooden propeller blades. The propeller blades were sheared by the dislodged cylinder. The rough landing surface contributed to the accident.Jul 29, 1988 · N15855 · Substantial damageNTSB ATL88LA221Accident · No injuriesLimited investigationFinal reportCessna 182A · Elberta, ALThe plt was on a x-country flt from Elberta, AL, to destin, FL & return. The flt included 4 en route stops to pick up & drop off pax. During an en route stop, the plt checked the fuel by using a home made dip stick & he thought there was sufficient fuel to…Jul 28, 1988 · N4090D · Substantial damageNTSB MKC88LA137Accident · No injuriesLimited investigationFinal reportGrumman G164B · Knobel, ARThe plt said he had just completed an aerial application operation and was returning to his base airfield to re-load. While in a low level cruise, the engine quit abruptly, and an emergency ldg was attempted in a soft, muddy soy bean field. During the ldg…Jul 26, 1988 · N2500W · Substantial damageNTSB MIA88LA237Accident · No injuriesLimited investigationFinal reportMooney M-20E · Punta Gorda, FLThe plt stated he kept his acft outdoors & he had not flown it for 7 days. He stated he had not refueled the acft after the last flt & had parked it with 1/2 tanks. Fss personnel stated there had been rain showers in the area during that time. The plt stated…Jul 26, 1988 · N9369M · Substantial damageNTSB FTW88IA141Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Kenton, DEA flameout of the #1 engine occurred due to water ingestion when the aircraft penetrated a vip level 5 thunderstorm and encountered heavy rain while descending with the throttles a flight idle. The engine suffered overtemperature damage to the turbine section…Jul 26, 1988 · N14336 · Minor damageNTSB MIA88LA236Accident · 1 fatalLimited investigationFinal reportPiper PA-60-700P · Cocoa Beach, FLFlt entered near vertical descent while flying in area of level 1 and 2 thunderstorms just after plt had called requesting permission to deviate around rain showers. A level 5 thunderstorm was present 8 miles west. The acft descended at rates up to 13,800…Jul 25, 1988 · N69RB · DestroyedNTSB ATL88FA220Accident · No injuriesField investigationFinal reportPiper PA-28-151 · La Grange, GAThe PIC stated he had a hardover in the single axis autopilot which resulted in the acft constantly turning right. Therefore due to the continous bank he elected to make a precautionary landing in a lake versus on land. The acft impacted in a lake left of the…Jul 25, 1988 · N4506F · Substantial damageNTSB MKC88LA135Accident · No injuriesLimited investigationFinal reportMooney M20-F · Lawrence, KSThe pilot said the engine quit due to fuel exhaustion during a personal cross country flight. He said he tried to glide to his final destination airport, but made an emergency ldg in a farm field about 2 miles short of the airport.Jul 24, 1988 · N6347Q · Substantial damageNTSB MIA88LA233Accident · No injuriesLimited investigationFinal reportCessna 310 · Homestead, FLWhile on a personal flt during normal cruise both engs quit due to fuel exhaustion. The plt attempted to land the acft on a road, after which it departed the road surface, and collided with trees. The plt did not file an acc report.Jul 24, 1988 · N638E · Substantial damageNTSB MIA88FA234Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Daytona Beach, FLThe acft departed spruce creek arpt and aprx 2 minutes later lost power and crashed into trees just west of the volusia county landfill aprx 4 miles northeast of the Daytona Beach regional arpt. Postcrash examination of the engine revealed the drain line on…Jul 24, 1988 · N28140 · DestroyedNTSB BFO88FA068Accident · 2 fatalField investigationFinal reportCessna R182RG · Stevensville, MDThe acft departed bay bridge arpt at aprx 0415 EDT. The passenger, also a plt, was reading back an IFR clearance to ATC when communication ended in the middle of a sentence without any sign of distress. Comparison of ATC and radar tapes indicates that N9997C…Jul 24, 1988 · N9997C · DestroyedNTSB SEA88LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Coeur D'Alene, IDAfter low pass over intended landing area, acft would not outclimb rising terrain in canyon. Plt mushed into brushy clearcut area rather than collide with rough terrain. Plt report stated finding of low compression on 3 cyls. Density altitude estimated at…Jul 23, 1988 · N8109B · Substantial damageNTSB FTW88DPA04Accident · No injuriesFinal reportAtkins ACRO-SPORT · Fort Worth, TXDuring a personal flight, the engine failed and the pilot made a forced landing into an open field. During the landing, the airplane flipped to the inverted position. Investigation revealed no fuel in the tank or fuel system and no fuel spilled on the ground.Jul 22, 1988 · N5897 · Substantial damageNTSB CHI88LA171Accident · No injuriesLimited investigationFinal reportCessna 182E · Cedar Springs, MIDuring cruise flight the pilot reported that a total power loss occurred. The pilot executed a forced landing in an open field. On rollout the aircraft struck a stump and then a small shed. The post accident investigation revealed loosefuel caps and no fuel…Jul 22, 1988 · N2859Y · Substantial damageNTSB CHI88DEP07Accident · No injuriesFinal reportCessna 182B · Burlington, WIDrg a normal dscnt, in preparation to land, the eng lost all power. The plt made an emerg landing, but drg the landing roll-out, the nosewheel enctrd soft, uneven terrain & the acft nosed over. No fuel was found in the fuel tanks or carburetor float bowl, but…Jul 22, 1988 · N2486G · Substantial damageNTSB LAX88LA267Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chico, CADuring a cross country flight, the pilot noted a loss of oil pressure. Shortly after, the pilot heard a loud bang and the engine lost power. A forced landing was made short of the airport where the airplane collided with the terrain during the landing roll.…Jul 21, 1988 · N6441P · Substantial damageNTSB LAX88DUJ05Accident · Minor injuriesFinal reportGrumman G-164B · Parker, AZDuring an aerial application flight, the pilot dispensed the load and was returning to the airstrip due to an approaching thunderstorm. Enroute, the visibility was reduced to near zero from blowing dust. The pilot lost control of the airplane and collided…Jul 21, 1988 · N6747Q · DestroyedNTSB FTW88FA136Accident · 3 fatalField investigationFinal reportDouglas DC-6A · Golden Meadow, LAAfter abt 4.3 hrs on an overwater flt, the crew rprtd they had 15 min of fuel remaining. Subsequently, 3 of 4 engs lost pwr fm fuel exhaustion. Drg an emerg lndg, the acft hit a levee & was extensively dmgd. Most of the wreckage came to rest in a dainage…Jul 21, 1988 · N33VX · DestroyedNTSB LAX88LA265Accident · No injuriesLimited investigationFinal reportCessna 152 · Dixon, CAThe plts stated that while they were cruising in close formation, the rgt wing of one acft (Cessna 152, N6469M) raised up & collided with the left main lndg gear of the other acft (Cessna 152, N6239H). N6469M received substantial damage to the wing & N6239H…Jul 20, 1988 · N6469M · 2 aircraft · Substantial damageNTSB FTW88DPJ08Accident · Minor injuriesFinal reportCessna 152 · Heavener, OKDuring a cross country training flight, the non-instrument rated pilot flew into IMC conditions while descending. The pilot attempted to climb into VFR conditions but when that was not successful a descent was begun in an effort to breakout into VFR…Jul 20, 1988 · N68700 · Substantial damageNTSB CHI88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chicago, ILDuring climbout after takeoff, the pilot experienced an engine fire and diverted to Chicago's midway airport for an emergency landing. The pilot executed emergency procedures, shut down the engine, the fuel supply, and all electrical load. When the pilot knew…Jul 20, 1988 · N8069S · Substantial damageNTSB NYC88LA189Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Saltsburg, PAThe plt launched on a local Balloon sight-seeing flight at 1850 local time with the forecast of thunderstorm activity to commence in the area after midnight. After 40 mins of smooth flt, the temp dropped sharply and shortly thereafter turbulence was…Jul 18, 1988 · N1534W · Substantial damageNTSB MIA88LA227Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St. Petersburg, FLThe 27 yr old plt purchased the acft about 2 weeks before the accident & had received his multi-eng rating about 3 weeks before. His total multi eng time was about 35 hrs. Nearing his destination, 1 eng quit. A few moments later, the other quit & the plt…Jul 18, 1988 · N11RJ · DestroyedNTSB LAX88LA266Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Springerville, AZShortly after takeoff, the engine experienced a loss of power. The pilot made a forced landing where during the landing roll, the airplane collided with the terrain. During the engine inspection, it was found that the left magneto fired only one sparkplug.…Jul 18, 1988 · N14683 · Substantial damageNTSB MKC88LA128Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Holdrege, NEThe plt said that after completing a spraying operation and depleting his chemical load, he flew to a near-by farm field to check it over. Enroute, the engine quit, and attempts to restart it were unsuccessful. An emergency ldg was attempted in a plowed farm…Jul 17, 1988 · N8806B · Substantial damageNTSB LAX88LA262Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Dana Point, CADuring a fish spotting operation over the ocean, the engine began to run rough and vibrate. The engine quit completely shortly thereafter and the airplane was ditched in the ocean. The airplane was not recovered. The plt stated that the eng lost power then…Jul 17, 1988 · N6226G · DestroyedNTSB CHI88LA167Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Mankato, MNAs the pilot leveled off at his intended cruise altitude, he noted a loss of oil pressure, then saw oil spread up over the windshield, restricting his visibility. The pilot performed emergency procedures, and began descending to the nearest airport. During…Jul 17, 1988 · N2059Q · Substantial damageNTSB CHI88DEE06Accident · No injuriesFinal reportPiper PA-25 · Chebanse, ILThe acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup.Jul 17, 1988 · N8807L · Substantial damageNTSB NYC88LA188Accident · Serious injuriesLimited investigationFinal reportFantasy Sky Promotions AX-7 · Wellsville, NYAbout 35 hot air balloons were entered in the great Wellsville balloon rally. At 0625 EDT, the plt (of c-gdgk) attended a wx briefing that was given to the plts by the balloonmeister. The plt said the balloonmeister indicated that there would be suitable…Jul 16, 1988 · CGDGK · Minor damageNTSB MIA88FA223Accident · Serious injuriesField investigationFinal reportRockwell 100-180 · Paxton, FLPlt's license was suspended at time of accident and his medical certificate was expired. Plt failed to get weather briefing prior to departure. Plt continued flt into deteriorating weather conditions and while attempting to land at a private airport due to…Jul 16, 1988 · N3603X · Substantial damageNTSB CHI88DEM07Accident · No injuriesFinal reportSilliman Hatz CB-1 · Battlecreek, MIWhile attempting to execute a forced landing due to an engine failure, the pilot misjudged his emergency procedure and collided with trees then the gnd during the descent to the fairway he had selected for landing. The engine failure was due to fuel…Jul 16, 1988 · N24DS · Substantial damageNTSB SEA88LA132Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Wrangell, AKPlt attempted flight through a mountain pass in the presence of low clouds and fog. Visual ground reference was lost and the acft collided with a snow bank. Plt cited personal and company-induced pressures as factors. Operator completed accident report.Jul 15, 1988 · N55CX · Substantial damageNTSB MKC88LA127Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Lowell, ARAbout one hour after takeoff, the plt noted that the eng began to run rough. He reduced the power to 2000 RPM & enriched the mixture. He continued flying for about another hour, then the eng lost power. The plt attempted an emergency landing on a frontage…Jul 15, 1988 · N3738X · Substantial damageNTSB LAX88LA268Accident · No injuriesLimited investigationFinal reportRaven S-60A · Bakersfield, CADuring a sightseeing flight, while on final approach, the balloon collided with power lines. The wires arced starting a fire which damaged the balloon envelope. The plt did not file an acc report. The plts last medical exam was on 7/3/79.Jul 15, 1988 · N2789Z · Substantial damageNTSB LAX88LA257Accident · No injuriesLimited investigationFinal reportCessna 172K · Palmdale, CAWhile cruising at 9500 feet, the pilot noted that the oil pressure was low. Shortly after, the engine quit. The pilot turned toward an airport, however, the airplane was landed short of the runway and nosed over in soft sand during the landing roll.…Jul 15, 1988 · N46373 · Substantial damageNTSB NYC88FA181Accident · 1 fatalField investigationFinal reportCessna 421 · Taunton, MABfr rchg his destn, the plt adzd apch ctl that his rgt eng was 'blowing some smoke' & losing oil pressure. Vectors were provided for a visual apch, but there were low clouds in the area & vis was restricted due to haze. After reaching the vcnty of the arpt,…Jul 14, 1988 · N825DW · DestroyedNTSB LAX88FA256Accident · Serious injuriesField investigationFinal reportCessna T210M · Carson, CAThe pilot failed to follow the emergency procedures as outlined in the pilot operating handbook by switching the fuel selector to the fullest tank. Contributing to this accident was fuel exhaustion of the right wing tank as a result of fuel siphoning.Jul 14, 1988 · N732QZ · DestroyedNTSB DEN88LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallup, NMPrior to takeoff from the 6469 ft MSL airport, the pilot leaned the mixture at 2000 RPM. Density altitude was aprx 9100 ft MSL. The 10-DEG flap takeoff and climbout to 300 ft AGL was said to be normal initially; then the aircraft began losing altitude…Jul 14, 1988 · N48055 · Substantial damageNTSB SEA88LA126Accident · Minor injuriesLimited investigationFinal reportBeech C23 · The Dalles, ORCFI underestimated fuel consumption on multi-stop cross country and did not visually check fuel remaining prior to last departure. Fuel exhaustion occurred 18 minutes into flight. Acft flipped inverted on forced landing.Jul 13, 1988 · N18823 · Substantial damageNTSB MKC88FA124Accident · 1 fatalField investigationFinal reportCessna 172G · Sarcoxie, MOWitnesses at the acdnt site characterized the wx as having a low ceiling with fog. They rprtd they saw the acft 'appear out of clouds' in a steep descent. The acft then began to 'pull up;' however, during recovery from the dive, the acft struck trees &…Jul 13, 1988 · N4288L · DestroyedNTSB MIA88LA221Accident · No injuriesLimited investigationFinal reportHahn RV-4 · Zellwood, FLFlt experienced rough running engine and loss of power. As acft was turned toward agricultural strip for an emergency landing the engine failed completely. The plt touched down short of the runway and bogged down in tall grass and muck causing collapse of the…Jul 13, 1988 · N144TH · Substantial damageNTSB NYC88LA178Accident · No injuriesLimited investigationFinal reportChampion 7GBC · Staten Island, NYThe pilot stated that after flying into a thunderstorm he encountered strong turbulence, heavy downdrafts and rain, which forced him into the water. When he realized that he was going down he dropped the banner he was towing 'but the airplane didn't want to…Jul 10, 1988 · N7523F · DestroyedNTSB MKC88LA121Accident · No injuriesLimited investigationFinal reportBeech A-60 · Lexington, MOThe pilot failed to provide the aircraft with a fuel supply adequate to complete the proposed flight and the pilots failure to maintain directional control of the aircraft during the landing roll on the active runway.Jul 9, 1988 · N7578D · Substantial damageNTSB LAX88LA250Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Palo Alto, CADuring a local flight, the pilot noted that the oil pressure was low. En route to the airport, the engine quit. A forced landing was made on a road where during the landing the airplane collided with telephone wires and subsequently the terrain. Inspection of…Jul 9, 1988 · N6106U · Substantial damageNTSB MKC88FA119Accident · 4 fatalField investigationFinal reportCessna 320 · Atwood, KSThe PIC had deptd the denver metro area carrying pax to vacation in Indiana. No flt plan was filed and there was no record of a preflt wx brief. The flt progrsd without any known difficulty until reaching the colorodo/kansas border. The PIC rqstd and rcvd wx…Jul 7, 1988 · N320DB · DestroyedNTSB DEN88LA148Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Craig, COWhile on final after a 4.6 hr x-cnty flight, the pilot reported that the engine quit. The plt said that the engine probably failed due to fuel exhaustion. Personnel at the wreckage site reported no fuel was found in the fuel tanks. After the engine failed,…Jul 7, 1988 · N6051M · Substantial damageNTSB CHI88IA157Incident · No injuriesIncident investigationFinal reportBeech C99 · Indianapolis, INComponent failure due to improper lubrication by the operators maintenance personnel.Jul 7, 1988 · N3063W · Minor damageNTSB ATL88FA211Accident · Serious injuriesField investigationFinal reportCessna 175 · Ninety Six, SCThe pilot was cruising the airplane at 2,000 feet AGL when he noted a loss of oil pressure and increase in oil temperature. He also noted a loss in engine power. He elected to make a landing off airport and set up a pattern for the selected field. The…Jul 7, 1988 · N6509E · Destroyed