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 MIA88LA217Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Stringer, MSAccording to the pilot while on a ferry flight during normal cruise at an alt of aprx 2000 ft, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a tree.Jul 6, 1988 · N4351Y · Substantial damageNTSB CHI88IA159Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Indianapolis, INFailure to ensure proper alignment and closure of the auxillary power unit lower shroud with the fire seal upon completion of a maintenance action.Jul 6, 1988 · N409PE · No damageNTSB MIA88LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that while inbound to Vero Beach, he ran out of fuel in the left tank. The engine quit, and he was unable to restart the engine before he crashed into a grove of trees.Jul 5, 1988 · N2608F · DestroyedNTSB LAX88FA246Accident · 1 fatalField investigationFinal reportCessna 152 · Verdi, NVFailure of the pilot to gain sufficient altitude prior to negotiating mountainous terrain with forecast high winds. Contributing to this accident was the weather phenomena known as 'mountain wave' which created downdrafts that exceeded the aircraft's climb…Jul 4, 1988 · N49787 · DestroyedNTSB LAX88FA245Accident · 4 fatalField investigationFinal reportCessna 320D · Mammoth Lakes, CAThe pilot executed a left (south) crosswind departure towards higher terrain after departing runway 27; the plt was following a slower single engine airplane that had preceded his departure. Ground witnesses reported that as the airplane approached the higher…Jul 4, 1988 · N9HS · DestroyedNTSB DEN88LA152Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Fort Collins, COThis Balloon flt was part of a rally. The flt departed from a stadium, climbed to 500' and then made a controlled descent and landing. After the next takeoff and climb to about 125' when the burner was turned off the plt noticed that fuel was not flowing to…Jul 4, 1988 · N7420S · Substantial damageNTSB NYC88LA175Accident · No injuriesLimited investigationFinal reportCessna 150M · W. Seneca, NYThe instructor pilot stated that the student pilot conducted the preflight and reported the fuel 'down a little.' The instructor did not visually verify the amount of fuel on board. Investigation revealed that the acft ran out of fuel and was forced to land…Jul 3, 1988 · N63206 · Substantial damageNTSB DEN88LA146Accident · No injuriesLimited investigationFinal reportCessna 188 · Sentinel Butte, NDThe pilot took off from his private airstrip near Sentinel Butte, ND, en route to beach, ND. He said there was a narrow cloud ahead, approximately 5-8 miles long, and emitting lightning, but it did not appear to him to threaten flight safety. The pilot said…Jul 3, 1988 · N3546Q · DestroyedNTSB ATL88FA254Accident · 1 fatalField investigationFinal reportCessna T207 · Petros, TNJul 3, 1988 · N1724U · DestroyedNTSB MIA88LA211Accident · No injuriesLimited investigationFinal reportCessna 152 · Marathon, FLThe student plt was on his 1st solo x-c flt. A portion of the flt included a 30 mi stretch over the Florida bay section of the gulf of Mexico. The flt carried no flotation gear. 5.2 hrs into the flt, the eng quit & a ditching was performed near a pleasure…Jul 2, 1988 · N25057 · Substantial damageNTSB LAX88DVG07Accident · No injuriesFinal reportSnow AT-301 · Davis, CAAt the end of an aerial application flight, en route to home base, the engine quit. The pilot made an emergency landing in a field, where during the landing roll the airplane collided with a bale of hay and nosed over. Inspection of the engine revealed that…Jul 2, 1988 · N5224S · Substantial damageNTSB BFO88IA065Incident · No injuriesIncident investigationFinal reportCessna T210R · Washington, DCImproper maintenance resulting in the routing of wire which caused an electrical short and inflight smoke.Jul 2, 1988 · N6286U · Minor damageNTSB LAX88LA242Accident · No injuriesLimited investigationFinal reportPiper J3 · Rialto, CADuring a local flight, the engine quit while descending to the airport. A forced landing was made on a road where during the landing roll a gust of wind pushed the airplane off the road. The airplane ground looped, collided with the terrain and nosed over.…Jul 1, 1988 · N6868H · Substantial damageNTSB CHI88DEX06Accident · No injuriesFinal reportPiper J3 · Bedford, INAircraft was in cruise flight at 1000 feet AGL when the pilot heard a backfire from the engine followed by immediate and total loss of power. Forced landing was made in rugged, rocky terrain. Landing gear sheared off on rollout. Investigation revealed failure…Jul 1, 1988 · N42684 · Substantial damageNTSB ATL88LA208Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Thomson, GAThe plt reported that the engine lost pwr about 20 miles from the arpt where he had intended to refuel. The airplane subsequently collided with utility wires as he was attempting to land on a hwy. the plt attributed the pwr loss to fuel exhaustion. Postcrash…Jul 1, 1988 · N29238 · Substantial damageNTSB ATL88LA206Accident · No injuriesLimited investigationFinal reportCessna 172M · Spring Creek, NCThe plt reported that the engine began to run rough & lose power as the airplane climbed through 9,000 ft MSL. She then switched fuel tanks and moved the mixture to full rich, but the engine continued to lose power. Carb heat was not used at any time. A…Jul 1, 1988 · N1534V · Substantial damageNTSB ATL88FA207Accident · 1 fatalField investigationFinal reportPiper PA-32 · Uniontown, ALJul 1, 1988 · N8324V · DestroyedNTSB MIA88LA210Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic Ocean (Atlantic Ocean)The plt stated that the eng started running rough. He decided to divert to alt aprt 15 miles away. While enroute, the plt stated that he heard a 'clanking' noise and oil sprayed the windsheild. The eng lost all power. The a/c was ditched in the Atlantic Ocean…Jun 30, 1988 · N75033 · DestroyedNTSB LAX88FA241Accident · 1 fatalField investigationFinal reportHelio HST-550A · Perris, CAFailure of the electrical stabilizer trim control that resulted in an uncommanded full nose down elevator trim command.Jun 30, 1988 · N9991F · DestroyedNTSB CHI88LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lonsdale, MNThe pilot was executing a power-off glide and when an attempt was made to recover by adding power, the engine did not respond. The pilot was then forced to make an emergency landing in a field. During the forced landing the pilot was unable to maintain…Jun 30, 1988 · N63178 · Substantial damageNTSB ATL88LA205Accident · No injuriesLimited investigationFinal reportBeech K35 · Greensboro, NCThe flight was climbing to 11,000 feet with an instrument flight clearance when a propeller blade separated from the hub. The blade was subsequently recovered from the yard of a local resident. The fracture examination disclosed that the cracking originated…Jun 30, 1988 · N5335R · Substantial damageNTSB LAX88LA238Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Agua Caliente, CADuring a cross country flight, the right engine began to run rough. The pilot feathered the propeller and turned to land at the airport. En route, the left engine began to run rough. Unable to land at the airport, a forced landing was made on a road, where,…Jun 29, 1988 · N27332 · Substantial damageNTSB FTW88DRD11Accident · Minor injuriesFinal reportSchweizer G-164B · Cheneyville, LAThe ag airplane was returning after spraying chemical when the engine started to lose power. During the forced landing on a highway the left wing struck a road sign. No mechanical reason for the engine power loss was found. The acft had an annual inspection…Jun 29, 1988 · N48585 · DestroyedNTSB DEN88LA140Accident · No injuriesLimited investigationFinal reportBeech C35 · Brighton, COShortly after takeoff and while cruise flight, the eng lost pwr. The fuel pressure gauge indicated o PSI. The plt switched on the electric fuel pump. The eng did not respond. The plt activated the auxiliary (wobble) pump and switched fuel tanks. The eng still…Jun 29, 1988 · N8930A · Substantial damageNTSB SEA88LA119Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Elko, NVPlt had just purchased acft and was on initial leg of cross-country flight. Plt calculated 4.9 hrs endurance, verified by CFI as adequate for proposed flt. After 4.2 hours tach time, fuel exhaustion occurred and a forced landing was executed 21 miles short of…Jun 28, 1988 · N35181 · Substantial damageNTSB FTW88DRD10Accident · No injuriesFinal reportBell 206L-1 · Houma, LAShortly after liftoff, the helicopter experienced a power loss at 300 feet. During the emergency landing in a wet swampy area with very high vegetation, the helicopter landed hard, and the main rotor blades struck the tailboom. At a post accident inspection,…Jun 27, 1988 · N2611 · Substantial damageNTSB DEN88FA141Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Capitan, NMJun 27, 1988 · N29318 · DestroyedNTSB BFO88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Cambridge, MDThe pilot had departed ocean city, MD aprx 20 minutes after takeoff when nearing the chesapeake bay at an alt of 3000 ft MSL, a total loss of engine power was experienced. The plt attempted to restart the engine to no avail and a forced landing was made in a…Jun 27, 1988 · N21312 · Substantial damageNTSB ATL88IA195Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124A · Hebron, KYDuring en route climb, the left engine failed and the crew executed a safe single engine landing. Examination of the engine revealed an uncontained HP turbine failure in the engine. Metallurgical examination of the failed parts indicated improper steel alloy.…Jun 27, 1988 · N600J · Minor damageNTSB LAX88LA234Accident · No injuriesLimited investigationFinal reportCessna 172N · La Grange, CAJun 26, 1988 · N4833E · Substantial damageNTSB FTW88FA125Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Anson, TXInadequate weather evaluation-pic; flight into known adverse weather, inadvertent-pic; design stress limits exceeded by PIC; thunderstormJun 26, 1988 · N2889N · DestroyedNTSB DEN88LA137Accident · No injuriesLimited investigationFinal reportBell 206B3 · Missoula, MTA check airman and a commercial plt were performing an instructional flt. During climbout after a practice autorotation, the engine out audio and light warning activated. Both pilots verified an actual engine out and entered an autorotation. The helicopter…Jun 26, 1988 · N2754A · Substantial damageNTSB DEN88FA138Accident · 2 fatalField investigationFinal reportDouglas A-26C · Cimarron, NMThe plt rcvd a wx briefing before takeoff, but did not file a flt plan. Drg the flt, the acft (Douglas A-26C, N4813E) crashed in mountainous terrain at an elev of about 11,200' near baldy mountain. Scouting personnel, who were camped in the vicinity, rprtd…Jun 26, 1988 · N4813E · DestroyedNTSB BFO88LA061Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Salisbury, MDBefore the flt, the crew received a severe wx warning concerning wx along the route of flt. The captain informed the flight attendants to be prepared to have passenger service completed early and to be seated before the descent. Before encountering…Jun 26, 1988 · N9040U · No damageNTSB SEA88LA117Accident · Serious injuriesLimited investigationFinal reportCessna 210G · Bend, OROn arrival in area of planned fuel stop, pax did not feel well. Plt determined that adequate fuel remained to continue to final destination. However, exhaustion occurred 8 miles short of destination. Plt diverted from initial forced lndg site (road) due…Jun 25, 1988 · N5923F · DestroyedNTSB NYC88LA170Accident · Serious injuriesLimited investigationFinal reportBell 47J2 · Newburyport, MAThe helicopter departed runway 10 at plum island airport, turned left over the plum island river and shortly thereafter the engine quit. The pilot stated that no warning was noted and a check of the instruments indicated no problems. He further stated that…Jun 25, 1988 · N51711 · DestroyedNTSB LAX88LA233Accident · No injuriesLimited investigationFinal reportHughes 269B · Big Bear, CAWhile cruising, the plt perceived he was experiencing a loss of engine & rotor RPM. The plt stated that he attempted to regain RPM by autorotating. The RPM was regained in the autorotative descent. The plt elected to continue the descent to a landing. Upon…Jun 25, 1988 · N9350F · Substantial damageNTSB FTW88LA126Accident · No injuriesLimited investigationFinal reportCessna 150F · Temple, TXAfter the descent, the pilot applied power and the engine started running rough. The pilot was able to get the engine running at full power within several minutes but it quit completely approximately 3 to 4 miles from the airport. The airplane was landed in…Jun 25, 1988 · N8979S · Substantial damageNTSB DEN88LA135Accident · Serious injuriesLimited investigationFinal reportBell 47G · Terry, MTThe aircraft was on a ferry flight from alpine, WY. To belfield, ND. The plt departed alpine at approximately 0950 and made several enroute stops to refuel. The plt intended to land at miles city, MT to refuel but he got lost and flew to Terry, MT, located 38…Jun 25, 1988 · N2243W · Substantial damageNTSB CHI88LA142Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Kenosha, WIThe pilot was picking up the aircraft after being serviced when approximately 20 minutes after taking off the engine quit. The pilot was forced to make an emergency landing in a field. During the landing sequence the aircraft contacted some trees at the edge…Jun 25, 1988 · N84405 · Substantial damageNTSB MKC88LA115Accident · No injuriesLimited investigationFinal reportCessna 150 · Trousdale, KSDuring a cross country personal flight, the PIC noticed an excessively high oil temperature. He said he enriched the fuel mixture, and when that failed to cool the engine, he reversed his course back to his departure apt. Shortly after his reversal of course,…Jun 24, 1988 · N6525F · Substantial damageNTSB LAX88LA231Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Stonyford, CADuring a cross country flight, the pilot was flying 500 feet AGL over mountainous terrain when a strong downdraft was encountered. The airplane was unable to climb out of it and subsequently collided with the terrain.Jun 23, 1988 · N4792B · Substantial damageNTSB FTW88LA123Accident · No injuriesLimited investigationFinal reportBeech B-24R · Blanchard, OKAccording to the private pilot in the left front seat, this was a training flight set up by the commercial pilot flight instructor in one of the rear seats. The private pilot in the left front seat was to practice for his commercial flight test and the…Jun 23, 1988 · N9162S · Substantial damageNTSB CHI88DEX05Accident · No injuriesFinal reportBeech V35A · Seymour, INAircraft was in cruise flight at 6500 feet when engine began to run rough. Pilot navigated to nearest airport and made intentional gear-up landing with cruise power. Postcrash investigation revealed number 2 exhaust valve had failed and become wedged between…Jun 23, 1988 · N7892R · Substantial damageNTSB MIA88LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Bimini, BahamasLow engine oil pressure and subsequent engine seizure for undetermined reasons.Jun 22, 1988 · N3634C · DestroyedNTSB ATL88FA198Accident · 1 fatalField investigationFinal reportCessna 150 · Eastman, GAThe accident occurred after takeoff from a private sod airstrip. A witness saw the aircraft climb to about 500 feet. It then started losing altitude, dropped out of sight, and crashed. The aircraft impacted the ground in a nose low attitude and burned.…Jun 22, 1988 · N4282U · DestroyedNTSB MKC88LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Eldon, MOTotal failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command.Jun 21, 1988 · N4490T · Substantial damageNTSB DEN88LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDJun 21, 1988 · N96730 · Substantial damageNTSB LAX88LA227Accident · No injuriesLimited investigationFinal reportCessna 210M · Tres Pinos, CAJun 20, 1988 · N732KS · Substantial damageNTSB MKC88LA113Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Florence, MOWhile on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss.Jun 19, 1988 · N94045 · Substantial damage