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 MIA99LA137Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Courtland, ALThe failure of maintenance personnel from Signature Flight Support to assure that a cotter pin was installed at the air throttle assembly lever following installation of the overhauled fuel control valve onto the overhauled engine. This resulted in the…Apr 21, 1999 · N769LW · Substantial damageNTSB LAX99LA159Accident · No injuriesLimited investigationFinal reportCessna R182 · San Luis Obispo, CAThe inadequate preflight inspection of the aircraft by the pilot-in-command which resulted in a loss of engine power due to water contamination in the fuel system. A factor in the accident was an improper maintenance alteration which disabled a fuel sump…Apr 21, 1999 · N7317X · Substantial damageNTSB MIA99LA135Accident · Serious injuriesLimited investigationFinal reportCessna 150M · S. Rockledge, FLA total loss of engine power while in cruise flight due to the pilot's failure to use carburetor heat during carburetor icing conditions and the subsequent emergency landing to unsuitable terrain and collision with a tree.Apr 20, 1999 · N66560 · Substantial damageNTSB LAX99LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Yuba City, CAA total loss of engine power resulting from the fatigue failure of a cylinder's exhaust valve. A contributing factor was the uneven terrain at the forced landing site. The reason for the fatigue could not be determined.Apr 18, 1999 · N22710 · Substantial damageNTSB NYC99LA093Accident · 1 fatalLimited investigationFinal reportMooney M20E · Brooksville, KYContaminated fuel which resulted in the forced landing, and a heart attack from an adrenaline rush that interacted with preexisting coronary disease which resulted in the pilot's death.Apr 17, 1999 · N1987Y · Substantial damageNTSB MIA99LA131Accident · 1 fatalLimited investigationFinal reportPiper J-3C · Jackson, MSThe failure of the airshow aerial performer to maintain a grip on the airplane's externally mounted rope ladder for unknown reasons and his failure to install and use a safety line resulting in his fall to earth. A factor in the accident was the sudden…Apr 17, 1999 · N38272 · No damageNTSB LAX99LA181Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · La Verne, CAThe in-flight separation of the right engine cowling due to the operator's inadequate maintenance quality control procedures and the pilot's inadequate preflight inspection.Apr 15, 1999 · N57AS · Substantial damageNTSB LAX99LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Pacific Ocean (Pacific Ocean)An undetermined system malfunction in the right engine, which led to an increase in fuel usage beyond the pilot's planned fuel consumption rate and eventual fuel supply exhaustion.Apr 15, 1999 · N141CM · DestroyedNTSB MIA99LA130Accident · Minor injuriesLimited investigationFinal reportZemp Avid Catalina · Sebring, FLThe in-flight separation of one of the propeller blade's and one of the engine's exhaust pipes causing the engine to vibrate until it stopped running. A related factor was the unsuitable terrain for the forced landing.Apr 14, 1999 · N9224T · Substantial damageNTSB ANC99LA046Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Kenai, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was high winds.Apr 14, 1999 · N221C · Substantial damageNTSB ANC99FA047Accident · 1 fatalField investigationFinal reportCessna 207A · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions, spatial disorientation, and an inadvertent stall. Factors in the accident were weather conditions consisting of snow and mist, and flat lighting conditions.Apr 14, 1999 · N73188 · DestroyedNTSB CHI99LA128Accident · No injuriesLimited investigationFinal reportCessna T-188C · Dalton, NEthe improper adjustment of the fuel pump by maintenance personnel. Factors to the accident were the excessive output of the fuel pump, trees, residential structure, fence, and propane tank.Apr 13, 1999 · N2173J · Substantial damageNTSB NYC99LA089Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Stiefler Corner, PAThe pilot diverting his attention inside the cockpit, and allowing the airplane to enter instrument meteorological conditions, resulting in an in-flight collision with a tree.Apr 12, 1999 · N8764J · Substantial damageNTSB MIA99LA124Accident · Minor injuriesLimited investigationFinal reportBean Whitman W-10 · Wimauma, FLThe pilot's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with a ditch and subsequent nose over.Apr 12, 1999 · N173RS · Substantial damageNTSB MIA99FA125Accident · 2 fatalField investigationFinal reportPiper PA-16 · Hardeeville, SCAn inflight loss of control for undetermined reasons while in a descent and the subsequent collision with the terrain.Apr 12, 1999 · N5796H · DestroyedNTSB LAX99LA165Accident · No injuriesLimited investigationFinal reportParker Vans RV-4 · Red Bluff, CAA crack which developed in the automotive-type oil cooler of the experimental, amateur built aircraft and permitted the engine oil supply to flow overboard.Apr 12, 1999 · N6420E · Substantial damageNTSB IAD99FA038Accident · 4 fatalField investigationFinal reportBeech BE-95A · Shawsville, VAthe pilot's inadequate preflight planning which resulted in intentional flight into known severe turbulence and the subsequent loss of control. Factors in the accident were the turbulence in instrument meteorological conditions and an airplane loaded over the…Apr 12, 1999 · N3113K · DestroyedNTSB MIA99LA122Accident · Serious injuriesLimited investigationFinal reportHarris VARI-EZE · Eufaula, ALThe loss of engine power for undetermined reasons.Apr 11, 1999 · N250GH · DestroyedNTSB SEA99LA059Accident · No injuriesLimited investigationFinal reportCessna 172D · Glenns Ferry, IDThe failure of both pilots to see-and-avoid wires crossing the river. Factors included: transmission wires; inattention of both pilots to the aircraft's flight path; and the pilots' low-altitude flight.Apr 10, 1999 · N2650U · Substantial damageNTSB CHI99LA130Accident · No injuriesLimited investigationFinal reportBell 206B · Cloquet, MNThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pole and dusk light conditions.Apr 10, 1999 · N119SP · Substantial damageNTSB CHI99IA136Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Dubuque, IAthe frozen elevator control. Factors to the incident were the rain and the low temperature.Apr 9, 1999 · N205ME · No damageNTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…Apr 8, 1999 · N96212 · Substantial damageNTSB MIA99LA118Accident · No injuriesLimited investigationFinal reportSteve Hill Staudacher S600 · Bunnell, FLThe pilot's improper fuel consumption calculations which resulted in fuel exhaustion.Apr 7, 1999 · N600SH · Substantial damageNTSB CHI99LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Vienna, ILThe worn ignition points/cam follower assembly, and uneven landing terrain.Apr 7, 1999 · N9969X · DestroyedNTSB FTW99LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Cleburne, TXThe pilot's failure to maintain adequate altitude/ clearance from the wires.Apr 6, 1999 · N734SV · Substantial damageNTSB LAX99LA140Accident · Minor injuriesLimited investigationFinal reportCessna 210D · El Monte, CAA loss of engine power due to the fatigue failure of the mixture control cable, which was due to the improper installation and adjustment of the cable 99 hours prior to the accident.Apr 5, 1999 · N2340F · Substantial damageNTSB FTW99LA105Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shawnee, OKThe improper flare during an autorotation by the pilot-in-command. A factor was the loss of engine power for an undetermined reason.Apr 5, 1999 · N255AL · Substantial damageNTSB LAX99FA138Accident · 4 fatalField investigationFinal reportPiper PA-32R-301 · Warner Springs, CAThe pilot disregarded his weather briefing and attempted flight into areas of forecast and reported icing and moderate to severe turbulence. The airplane encountered mountain wave activity resulting in an overload condition and in-flight separation of the…Apr 4, 1999 · N9254Q · DestroyedNTSB FTW99FA104Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Waldron, ARThe pilot's encounter with adverse weather and loss of aircraft control, which resulted in exceeding the aircraft's design stress limits. Factors were the pilot's lack of total experience in the make and model of airplane, and the icing and thunderstorm…Apr 4, 1999 · N497CA · DestroyedNTSB NYC99LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Ramapo, NYFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor in the accident was the flight instructor's inadequate supervision of the solo cross-country flight.Apr 3, 1999 · N2743V · Substantial damageNTSB SEA99LA046Accident · Minor injuriesLimited investigationFinal reportCessna 205 · Edison, WAA total loss of engine power due to fatigue of the number six crankcheek resulting in crankshaft separation, and the lack of suitable terrain. Contributing factors were the sign and the ditch.Apr 2, 1999 · N8464K · Substantial damageNTSB DEN99LA062Accident · No injuriesLimited investigationFinal reportSly RV-6A · Payson, UTThe development of carburetor ice resulting in a loss of engine power, and the inadequate carburetor heat shroud. Factors were the carburetor icing weather conditions, the kit manufacturer's inadequate carburetor heat shroud design, the FAA's inadequate…Apr 2, 1999 · N80287 · Substantial damageNTSB SEA99IA045Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 4000 · Spokane, WAA chafed hydraulic line.Apr 1, 1999 · N477AU · No damageNTSB LAX99FA136Accident · 1 fatalField investigationFinal reportBell 206B · Grand Canyon, AZThe failure of the flight crew to properly preflight the helicopter and to detect and remove accumulated snow from the engine inlets and plenum chamber. Factors in the accident were the clouded plenum chamber inspection window and the failure of preceding…Apr 1, 1999 · N992UC · DestroyedNTSB CHI99FA227Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · St. Clair Shore, MIUndetermined as the aircraft was not recovered.Apr 1, 1999 · N441CB · DestroyedNTSB ATL99LA061Accident · No injuriesLimited investigationFinal reportCessna 150J · Pembroke Pines, FLThe pilot's inadequate in-flight/planning decision and his mismanagement of the fuel supply.Mar 29, 1999 · N60476 · Substantial damageNTSB NYC99LA081Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pottstown, PAThe failure of maintenance personnel to properly inspect and torque the crankcase bolts.Mar 28, 1999 · N177AR · Substantial damageNTSB MIA99LA115Accident · No injuriesLimited investigationFinal reportBeech A23 · Homestead, FLThe pilots improper decision not to land straight ahead after sustaining a reported loss of engine power on initial take off climb with sufficient runway remaining, and improper recovery from a bounced landing resulting in a subsequent in-flight collision…Mar 28, 1999 · N8883M · Substantial damageNTSB DEN99LA061Accident · No injuriesLimited investigationFinal reportMooney M20K · Medicine Bow, WYA fluctuating turbine inlet temperature and resulting loss of engine power for undetermined reasons. Factors were the rough, unsuitable terrain on which to make a forced landing.Mar 28, 1999 · N12HW · Substantial damageNTSB DEN99LA060Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Coyote, NMThe pilot-in-command's inadvertent flight into adverse weather, and his continued flight into instrument meteorological conditions. Factors were his failure to obtain an updated recorded weather briefing, the existing weather conditions which included snow,…Mar 27, 1999 · N528SS · DestroyedNTSB DEN99FA064Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Pagosa Springs, COThe pilot's continued VFR flight into IMC conditions. Related factors were flight into known adverse weather, the adverse weather, mountain obscuration, snow, icing, and high density altitude.Mar 27, 1999 · N56306 · DestroyedNTSB ATL99LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Florala, ALThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel system contamination with water.Mar 26, 1999 · N8968B · Substantial damageNTSB MIA99LA113Accident · No injuriesLimited investigationFinal reportDryer Fisher 404 · Homestead, FLThe pilots improper in-flight planning/decision of an available forced landing area. This resulted in a subsequent in-flight collision with trees. Contributing to the accident was a total loss of engine power due to an inoperative generator coil.Mar 25, 1999 · N82435 · Substantial damageNTSB MIA99FA114Accident · 1 fatalField investigationFinal reportGrumman G-21A · Lauderdale Lake, FLThe pilots failure to correctly identify an in-flight emergency (fluctuating manifold pressure and rpm due to a disconnected spark plug lead / unscrewed ignition lead shroud) and failure to complete the engine shutdown procedure once it was initiated…Mar 25, 1999 · N5548A · DestroyedNTSB MIA99LA112Accident · No injuriesLimited investigationFinal reportCessna 15OF · Columbia, SCThe pilots failure to maintain a visual lookout during a forced landing to a highway. This resulted in the left main landing gear colliding with a rain grate separating the left main landing gear. Contributing to the accident was a total loss of engine power…Mar 24, 1999 · N8397G · Substantial damageNTSB LAX99FA129Accident · 1 fatalField investigationFinal reportCessna 152 · Rancho Cucamong, CAthe pilot's failure to maintain altitude/clearance from mountainous terrain for unknown reasons.Mar 22, 1999 · N67821 · DestroyedNTSB IAD99LA035Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Irving, NYwas the pilot's intentional flight into known icing conditions.Mar 22, 1999 · N5878Q · Substantial damageNTSB CHI99IA115Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-14 · Grand Rapids, MIthe frozen elevator control. Factors were the rain and the low temperatures.Mar 22, 1999 · N600ME · No damageNTSB NYC99FA078Accident · 1 fatalField investigationFinal reportDeleeuw Sprint 1000 · Lakewood, NJThe pilot's loss of control, which resulted in an unintentional stall/spin after an engine failure. A factor in the accident was the engine failure, which occurred when the magneto piston seized within the cylinder sleeve during an overtemp event.Mar 20, 1999 · UNREG · DestroyedNTSB MIA99FA108Accident · 1 fatalField investigationFinal reportPushkar Hornet · Fort Lauderdale, FLthe pilot's (owner/builder) inadvertent aerodynamic stall of the airplane after a total loss of engine power. Factors were the pilot's improper maintenance action and his lack of total experience in the airplane type.Mar 20, 1999 · N4376N · Destroyed