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 ATL98LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boynton Beach, FLThe pilot's inadequate preflight planning that resulted in a loss of engine power due to fuel exhaustion.Jun 13, 1998 · N46129 · Substantial damageNTSB ANC98LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe total loss of engine power for undetermined reasons.Jun 13, 1998 · N70195 · Substantial damageNTSB IAD98FA068Accident · 2 fatalField investigationFinal reportBeech F33A · Delaplane, VAThe pilot's inadequate in-flight decision which led to VFR flight into instrument meteorological conditions. Also causal was the pilot's failure to maintain adequate terrain clearance resulting in collision with mountainous terrain. Contributing factors were…Jun 10, 1998 · N6033U · DestroyedNTSB SEA98LA091Accident · 1 fatalLimited investigationFinal reportStephens Vortex · Chinook, MTThe pilot's failure to maintain aircraft control for an undetermined reason.Jun 9, 1998 · N9261N · DestroyedNTSB ANC98FA069Accident · No injuriesField investigationFinal reportCessna 207A · Juneau, AKThe failure of company maintenance personnel to properly install a wire bundle clamp; chafing, electrical arcing, and subsequent leaking of a fuel line, which resulted in an in-flight fire. A factor associated with the accident was company maintenance…Jun 9, 1998 · N96AK · Substantial damageNTSB LAX98FA189Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Lytle Creek, CAthe pilot's intentional VFR descent into instrument meteorological conditions, resulting in a collision with mountainous terrain.Jun 8, 1998 · N16344 · DestroyedNTSB LAX98FA188Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Bangor, CAThe pilot's attempted flight into instrument meteorological conditions, loss of spatial orientation, and the resultant loss of airplane control. Contributing factors were his improper preflight and in-flight decisions, overconfidence in his personal ability,…Jun 8, 1998 · N9703C · DestroyedNTSB LAX98LA192Accident · No injuriesLimited investigationFinal reportArner Challenger II S · Pleasant Valley, AZLoss of engine power due to a loose spark plug wire cap caused by a broken spark plug retainer spring.Jun 7, 1998 · N2NX · Substantial damageNTSB MIA98FA182Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Statesville, NCThe pilot's attempted flight into adverse weather, resulting in a loss of control in flight. Contributing factors were the pilot's failure to obtain updated weather information, rain, and fog.Jun 6, 1998 · TGHUH · DestroyedNTSB LAX98LA184Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Burbank, CAThe separation of the tail rotor pitch link due to a fatigue fracture, which resulted in the separation of the tailboom.Jun 6, 1998 · N31621 · Substantial damageNTSB LAX98LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mariposa, CAFuel exhaustion due to the pilot's inadequate preflight planning, and improper in-flight decision not to make a precautionary landing for additional fuel.Jun 5, 1998 · N2573L · Substantial damageNTSB FTW98FA256Accident · 3 fatalField investigationFinal reportEurocopter AS350BA · La Gloria, TXthe pilot's continued flight into adverse weather conditions resulting in a loss of control due to spatial disorientation. Contributing factors were the dark night illumination, the lack of visual cues, the pilot's lack of total instrument time, and the…Jun 5, 1998 · N911VA · DestroyedNTSB ANC98LA064Accident · No injuriesLimited investigationFinal reportCessna 185F · Iliamna, AKThe loss of engine power for undetermined reasons. A factor was the hilly terrain.Jun 5, 1998 · N32663 · Substantial damageNTSB MIA98FA177Accident · 3 fatalField investigationFinal reportCessna 182R · Bradenton, FLThe failure of the pilot to maintain airspeed during climb after a low level observation flight resulting in the aircraft entering into a stall and descending uncontrolled until it crashed into trees and a river.Jun 4, 1998 · N9846H · DestroyedNTSB LAX98LA182Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Livermore, CAThe missing nut/cotter pin on the throttle attachment assembly which resulted in the pilot's inability to control engine power, and the hidden obstruction (hole) in the landing area. A factor was the high vegetation.Jun 4, 1998 · N704ZA · Substantial damageNTSB CHI98LA190Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Lexington, NEAn improper autorotation by the pilot in command. Factors contributing to this accident were the accumulation of ice in the carburetor resulting in a total loss of engine power, and the soft terrain.Jun 4, 1998 · N132RS · Substantial damageNTSB NYC98FA124Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Dalton, MAThe pilot's decision to continue the flight into instrument meteorological conditions, resulting in a loss of control, and airplane stress limits to be exceeded. Factors in the accident, the pilot's decision to disregard the preflight weather briefing, and…Jun 3, 1998 · N75137 · DestroyedNTSB MIA98FA176Accident · 2 fatalField investigationFinal reportMooney M-20E · Winston-Salem, NCThe pilot's improper decision to conduct a maintenance test flight with a known unairworthy mechanical condition (unserviceable servo fuel injector), resulting in a partial loss of engine power on climb out, subsequent forced landing, and in-flight collision…Jun 3, 1998 · N9365V · DestroyedNTSB LAX98LA180Accident · 1 fatalLimited investigationFinal reportVickers MK XVI · Blue Canyon, CAthe pilot's failure to maintain adequate terrain clearance and his VFR flight into instrument meteorological condition. Mountainous terran and obscurations are contributing factos. inadvertent flight into instrument meteorological conditions in mountainous…Jun 3, 1998 · N382RW · DestroyedNTSB FTW98LA204Accident · No injuriesLimited investigationFinal reportCessna 150 · Mentone, TXa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain directional control during landing.Jun 2, 1998 · N6486T · Substantial damageNTSB NYC98LA121Accident · Serious injuriesLimited investigationFinal reportCawood Fisher Classic · Abingdon, VAThe pilot's inadequate preflight of the airplane which resulted in water contamination of the fuel system. A factor was the location of the fuel tank's sump.Jun 1, 1998 · N485AJ · DestroyedNTSB IAD98LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Floyd, VAThe pilot's improper selection of fuel tank position resulting in fuel starvation of both engines.Jun 1, 1998 · N7794Y · DestroyedNTSB CHI98LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSthe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pilot became disoriented and a dark night.Jun 1, 1998 · N714FB · Substantial damageNTSB ANC98FA061Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-B2 · Juneau, AKThe failure of both command pilots to maintain an adequate lookout to see and avoid each other's aircraft. Factors associated with the accident were the pilot's failure to follow published advisory procedures to monitor/issue position reports on the…May 31, 1998 · N187EH · 2 aircraft · Substantial damageNTSB CHI98LA184Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Waterloo, IAThe pilot's failure to maintain clearance with the power lines during climb. A factor was the power lines.May 30, 1998 · N25491 · Substantial damageNTSB CHI98LA180Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Orleans, NEthe pilot selected a field with unsuitable terrain and stalled the airplane. Additional factors were the tower in the field, and engine failure due to the improper torque applied to camshaft bolts by other maintenance personnel.May 29, 1998 · N1AG · DestroyedNTSB ANC98LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe throttle arm disconnecting from the throttle linkage to the engine as a result of inadequate inspection by company maintenance personnel. Factors associated with this accident were the company maintenance personnel not following the repetitive Service…May 29, 1998 · N9956M · Substantial damageNTSB CHI98LA176Accident · Minor injuriesLimited investigationFinal reportWaters Vortex · Monroe, WIthe pilot's failure to maintain rotor RPM. A factor associated with the accident was the soft terrain on which the gyrocopter touched down.May 27, 1998 · N1025Y · Substantial damageNTSB ANC98LA058Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Paxson, AKA loss of engine power due to a failure of the engine's number 3 intake valve. A factor in the accident was the unsuitable terrain for a forced landing.May 27, 1998 · N1322B · Substantial damageNTSB ANC98LA057Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Tyonek, AKThe pilot's continued flight into adverse weather conditions, and his inadequate in-flight planning/decision. Factors in the accident were weather conditions consisting of a mountain wave, and downdrafts.May 27, 1998 · N5297U · Substantial damageNTSB NYC98FA112Accident · 2 fatalField investigationFinal reportBeech A36 · Middletown, RIThe shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…May 25, 1998 · N4507S · DestroyedNTSB IAD98LA063Accident · No injuriesLimited investigationFinal reportCessna 175 · Pemberton, NJThe pilot's inadequate fuel consumption calculations and his improper in-flight decision to continue flying with an inadequate fuel supply.May 25, 1998 · N6577E · Substantial damageNTSB FTW98LA243Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2B7 · Wichita, KSThe severe turbulence encountered as a result of the flightcrew's inadvertent flight into a rapidly developing thunderstorm.May 25, 1998 · N619AU · No damageNTSB ATL98FA080Accident · 5 fatalField investigationFinal reportBell 206L-3 · Indian Trail, NCThe pilot's failure to maintain altitude while operating in adverse weather. A contributing factor was the incoming fog and high tension static wire.May 25, 1998 · N96CW · DestroyedNTSB NYC98LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Blakeslee, PAThe pilot's inadequate preflight resulting in fuel exhaustion. A factor was the pilot's failure to refuel the aircraft prior to departing.May 24, 1998 · N6562G · Substantial damageNTSB LAX98FA171Accident · 2 fatalField investigationFinal reportVans RV-8 · Ripley, CAthe intentional or unintentional sudden application of aft elevator control by an undetermined aircraft occupant that exceeded the design stress limits of the aircraft. The aircraft gross weight, which exceeded the maximum allowable for aerobatics, and…May 24, 1998 · N58RV · DestroyedNTSB FTW98FA238Accident · 1 fatalField investigationFinal reportBell 47G · Bixby, OKThe pilot's failure to maintain clearance from the power lines.May 24, 1998 · N9954F · Substantial damageNTSB LAX98LA172Accident · 4 fatalLimited investigationFinal reportPiper PA-28-161 · Half Moon Bay, CAThe non-instrument rated pilot's loss of aircraft control due to spatial disorientation in dark night conditions.May 23, 1998 · N2480Q · DestroyedNTSB FTW98LA244Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Briggs, TXThe pilot's misjudgment of the distance and altitude. Factors were the lack of thermal lift and his diverted attention while on downwind.May 23, 1998 · N427BG · Substantial damageNTSB ANC98LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe pilot's inadequate preflight of the airplane's fuel system, and presence of water in the fuel system.May 23, 1998 · N8578D · Substantial damageNTSB ATL98LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Holt, FLLoss of engine power for undetermined reasons. A factor was the unsuitable terrain.May 22, 1998 · N2102N · Substantial damageNTSB LAX98FA169Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas DC-10-10 · Los Angeles, CAThe contaminated strain gage, which resulted in shorting of the strain gage's terminal lugs which lead to excessive autopilot initiated elevator movement, and excessive elevator actuation during recovery by the captain. Contributing factors were the failure…May 21, 1998 · N68043 · No damageNTSB LAX98LA166Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 520N · Lanai City,Maui, HIAn oil starvation failure of the number 5 bearing for undetermined reasons.May 20, 1998 · N112HD · DestroyedNTSB FTW98LA234Accident · Minor injuriesLimited investigationFinal reportHarding Revolution MINI-500B · Grove, OKThe improper alignment of the main drive belt by the owner/pilot/mechanic, which resulted in the failure of the main drive belt. A factor was the lack of suitable terrain for the forced landing.May 20, 1998 · N6144S · DestroyedNTSB CHI98LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Independence, MOA loss of engine power due to the separation of the induction system balance tube coupling from the intake manifold tube assembly. A related factor was the soft field.May 20, 1998 · N507SD · Substantial damageNTSB FTW98LA232Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eunice, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 19, 1998 · N8308K · DestroyedNTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.May 19, 1998 · N97MT · Substantial damageNTSB MIA98LA166Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Sumter, SCThe partial failure of the oil cooler bypass valve which resulted in the over-temperature and loss of oil pressure.May 18, 1998 · N9884U · Substantial damageNTSB CHI98LA162Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Crookston, MNthe pilot inadvertently stalled the airplane. Factors included the loss of engine power due to fuel exhaustion when the pilot failed to refuel the airplane. Another factor was fatigue.May 18, 1998 · N4962Q · Substantial damageNTSB CHI98IA164Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Minneapolis, MNthe open shielding on the #2 VHF transceiver coax connector which resulted in electromagnetic interference with the yaw damper system.May 18, 1998 · N675UP · No damage