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 CHI05LA037Accident · No injuriesLimited investigationFinal reportCessna 172H · Belle Plaine, MNA loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.Nov 28, 2004 · N2663L · Substantial damageNTSB SEA05FA019Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Arlington, WAThe divergence of the main rotor from its normal plane of rotation for an undetermined reason, resulting in rotor contact with the aircraft's left windscreen. The failure of the door pins to be installed was a factor.Nov 27, 2004 · N4029Q · DestroyedNTSB IAD05LA017Accident · No injuriesLimited investigationFinal reportChumsae Kitfox Speedster · Sterling, MAThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and a total loss of engine power.Nov 27, 2004 · N124KF · Substantial damageNTSB IAD05FA023Accident · 6 fatalClass 1 · FieldFinal reportCASA 212-200-CC · Bamiyan, Afghanistanthe captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…Nov 27, 2004 · N960BW · DestroyedNTSB DFW05LA025Accident · Minor injuriesLimited investigationFinal reportWingo Long-Ez · Huntsville, TXLoss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.Nov 25, 2004 · N234BW · Substantial damageNTSB CHI05CA036Accident · No injuriesData collectionFinal reportSpaulding Tailwind W-8 · Davey, NEThe loss of engine power due to the loss of oil pressure as a result of the pilot's failure to properly install the oil line to the oil cooler. A factor was the rough terrain.Nov 24, 2004 · N191AS · Substantial damageNTSB IAD05LA013Accident · No injuriesLimited investigationFinal reportCessna 172E · Rupert, WVThe pilot’s delayed application of carburetor heat, which resulted in a rough running engine. A factor was the bulldozer on the logging road where the pilot performed a precautionary landing.Nov 21, 2004 · N3750S · Substantial damageNTSB CHI05CA032Accident · Serious injuriesData collectionFinal reportOlson Sonex · Oconomowoc, WIThe loss of engine power due to a fatigue fracture of the crankshaft. An additional cause to the accident was the pilot/builder's failure to verify the dimensions of the shrink-fit crankshaft components prior reassembling the engine. A factor to the accident…Nov 21, 2004 · N478SX · Substantial damageNTSB MIA05CA030Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Panama City Bch, FLThe pilot's improper refueling of the helicopter resulting in loss of engine power do to fuel exhaustion and damage to the helicopter during the subsequent hard forced landing.Nov 17, 2004 · N595H · Substantial damageNTSB MIA05FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Dubbs, MSThe pilot's inadvertent flight into instrument meteorological conditions and his in-flight loss of control, resulting in overstress of the airframe and subsequent structural failure.Nov 14, 2004 · N56960 · Substantial damageNTSB LAX05FA034Accident · 2 fatalField investigationFinal reportBeech A36 · Lake Havasu, CAthe pilot's continued visual flight into instrument meteorological conditions leading to spatial disorientation and an in-flight loss of control.Nov 14, 2004 · N6111C · DestroyedNTSB DEN05LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Lyons, COthe pilot's inadequate in-flight planning/decision by his intentional VFR flight into IMC, and his failure to maintain obstacle clearance.Nov 14, 2004 · N48943 · DestroyedNTSB ATL05CA024Accident · No injuriesData collectionFinal reportCessna 172N · Wilmington, NCThe student pilot's failure to recognize the proper emergency procedure, which resulted in a precautionary landing in a field and subsequent collision with a ditch. Factors were the undetermined electrical malfunction, smoke in the cockpit, and the student…Nov 14, 2004 · N75776 · Substantial damageNTSB IAD05FA012Accident · 1 fatalField investigationFinal reportCessna P210 · Paint Lick, KYImproper alignment of a turbocharger oil line, which resulted in wear damage through the hose wall and a subsequent loss of engine oil. Contributing to the accident was the low cloud ceiling.Nov 12, 2004 · N6539P · DestroyedNTSB LAX05FA032Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Santa Barbara, CAThe pilot's failure to select and maintain an adequate terrain avoidance cruise altitude. Contributing factors were the dark nighttime conditions, the rising mountainous terrain, and the Federal Aviation Administration controller's failure to issue a…Nov 11, 2004 · N803ZG · DestroyedNTSB LAX05CA030Accident · No injuriesData collectionFinal reportCessna P210N · Rancho Cordova, CAThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power. Contributing factors were the pilot's improper in-flight decision to continue the flight at night after experiencing the total failure of the…Nov 11, 2004 · N6416W · Substantial damageNTSB LAX05LA020Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350-BA · Oxnard, CAThe inadvertent in-flight engagement of the collective down lock, which resulted in an uncontrolled descent and ground impact. The collective down lock engagement was likely due to a combination of the reduced clearance between the lock plate and the…Nov 9, 2004 · N655TV · Substantial damageNTSB DFW05LA019Accident · Minor injuriesLimited investigationFinal reportBell 206L1 · Sapulpa, OKThe loss of tail rotor drive as a result of a blanket coming in contact with the tail rotor blades, after the baggage compartment door unlatched during flight. A contributing factor was the "dusk" light condition that prevailed at the time of the accident.Nov 9, 2004 · N1075P · Substantial damageNTSB DFW05LA023Accident · No injuriesLimited investigationFinal reportCessna 150M · Longview, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Nov 6, 2004 · N704KX · Substantial damageNTSB CHI05CA025Accident · No injuriesData collectionFinal reportJabat Avid Flyer · Cleveland, MOThe separation of the wing skin from the wing structure and the pilot's subsequent inablility to maintain aircraft control. A factor associated with the accident was the tree that the airplane contacted.Nov 6, 2004 · N90JW · Substantial damageNTSB MIA05FA024Accident · 2 fatalField investigationFinal reportSocata TB 20 · Key West, FLThe pilot's failure to maintain aircraft control as a result of spatial disorientation. A related factor was the dark, night conditions.Nov 5, 2004 · N1905S · DestroyedNTSB DFW05LA017Accident · Serious injuriesLimited investigationFinal reportBell 206B · S.Timbelier 187The loss of engine power for undetermined reasons.Nov 5, 2004 · N496RL · DestroyedNTSB DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.Nov 5, 2004 · N2695W · Substantial damageNTSB ATL05LA020Accident · Serious injuriesLimited investigationFinal reportFranzreb Loehle 5151 Mustang · Athens, TNThe loss of engine power due to the electrical fuel pump failure, and fuel starvation.Nov 5, 2004 · N711AH · Substantial damageNTSB LAX05FA023Accident · 4 fatalField investigationFinal reportCessna 182Q · Lebec, CAthe pilot's inadequate in-flight planning/decision by his VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were mountainous terrain, low ceilings, and turbulence.Oct 31, 2004 · N95902 · DestroyedNTSB DEN05LA017Accident · Serious injuriesLimited investigationFinal reportMiller Vans RV4 · Dotsero, COthe pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.Oct 31, 2004 · N25HM · DestroyedNTSB CHI05FA020Accident · 3 fatalField investigationFinal reportBeech A36 · Downing, MOThe pilot not maintaing airplane control during cruise flight. Factors present were night and thunderstorm conditions.Oct 30, 2004 · N55448 · DestroyedNTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.Oct 30, 2004 · N57388 · Substantial damageNTSB ATL05CA016Accident · No injuriesData collectionFinal reportCessna 172 · Mobile, ALThe pilot's inadequate preflight planning and his inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent collision with the ground.Oct 29, 2004 · N2845Q · Substantial damageNTSB MIA05LA019Accident · No injuriesLimited investigationFinal reportScottish Bulldog 120/121 · Jacksonville, FLThe pilot's failure to maintain altitude/clearance with trees resulting in the in-flight collision with a tree, damage to the right main landing gear, and subsequent collapse of the right main landing gear during the emergency landing.Oct 28, 2004 · N556WH · Substantial damageNTSB MIA05LA016Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Raymond, MSThe total loss of engine power which was initiated by fretting of the crankcase halves for undetermined reasons, causing rotation of several of the main bearings, oil starvation, and subsequent failure of several of the connecting rods. A contributing factor…Oct 27, 2004 · N6108Y · DestroyedNTSB DFW05CA024Accident · No injuriesData collectionFinal reportMcCulloch J2 · Camden, ARThe separation of the engine exhaust stack for undetermined reasons.Oct 27, 2004 · N62SJ · Substantial damageNTSB CHI05FA016Accident · 2 fatalField investigationFinal reportCessna P210N · Wautoma, WIThe pilot not maintaining airplane control during cruise flight in instrument meteorological conditions after reporting a loss of gyros leading to his exceeding the design load limits of the wings. Factors were the clouds, the deteriorated vacuum manifold…Oct 26, 2004 · N5485W · DestroyedNTSB DEN05CA015Accident · Minor injuriesData collectionFinal reportCessna 310I · Draper, UTthe pilot's inadequate in-flight planning and decision making, and his failure to maintain adequate airspeed resulting in a stall.Oct 25, 2004 · N8175M · Substantial damageNTSB CHI05LA014Accident · 1 fatalLimited investigationFinal reportCessna P206B · Taylorville, ILAircraft control not possible by the pilot following a premature deployment of a parachute as a parachutist exited the jump airplane during cruise flight. The inverted spin encountered by the pilot was an additional cause.Oct 24, 2004 · N8619Z · DestroyedNTSB ATL05LA009Accident · 2 fatalLimited investigationFinal reportNorth American Harvard II T-6 · Leesville, SCLoss of engine power due to fuel system contamination which blocked the flow of fuel which resulted in fuel starvation.Oct 23, 2004 · N92871 · Substantial damageNTSB LAX05LA012Accident · No injuriesLimited investigationFinal reportBeech C24R · Cloverdale, CAthe loss of engine power due to fuel starvation from the pilot's inadequate fuel system management and his delay in selecting the fullest fuel tank.Oct 22, 2004 · N18942 · Substantial damageNTSB MIA05LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pompano Beach, FLThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power in one engine. Contributing factors were the pilot's inadequate handling of the aircraft following failure of the right engine for his failure…Oct 21, 2004 · N61518 · DestroyedNTSB DEN05FA012Accident · 2 fatalField investigationFinal reportBeech F35 · Chester, ARthe pilot's inadequate planning/decision which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were the pilot's failure to follow the briefing recommendation, fog, mist, and observation.Oct 21, 2004 · N3889B · DestroyedNTSB CHI05MA011Accident · No injuriesMajor investigationFinal reportBoeing 747-132 · Lake MichiganThe number one engine separated from the airplane during climb due to the uncontained separation of a portion of the second stage turbine disk rim after the second stage turbine vanes contacted the disk. The second stage turbine vanes contacted the second…Oct 21, 2004 · N709CK · Substantial damageNTSB CHI05LA012Accident · 1 fatalLimited investigationFinal reportCessna 150M · Ashley, NDThe non-instrument rated pilot's continued flight into known adverse weather conditions and his not maintaining aircraft control during cruise flight. Factors present were the night condition and low ceilings.Oct 21, 2004 · N63439 · DestroyedNTSB ATL05LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Guntersville, ALTotal loss of engine power due to engine oil contamination, engine oil starvation, and multiple connecting rod bearing failures.Oct 21, 2004 · N19TL · Substantial damageNTSB MIA05FA008Accident · 3 fatalField investigationFinal reportEurocopter Deutschland BO-105 CBS5 · Santa Rosa Bch, FLThe pilot's spatial disorientation and in-flight loss of control of the helicopter after encountering night instrument meteorological conditions resulting in collision with water during the resultant uncontrolled descent. A factor in the accident was the…Oct 20, 2004 · N916SH · DestroyedNTSB SEA05LA133Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hyak, WAThe loss of aircraft control during climb to cruise due to an undetermined flight control malfunction.Oct 19, 2004 · N39TJ · DestroyedNTSB ATL05FA010Accident · 2 fatalField investigationFinal reportBeech B-55 · Atlanta, GAThe pilot initiated flight into known adverse weather conditions (thunderstorms), which resulted in a loss of control, and subsequent in-flight collision with the ground.Oct 19, 2004 · N322WW · Substantial damageNTSB LAX05FA011Accident · 1 fatalField investigationFinal reportCessna 310K · Kula, HIThe failure of the pilot to maintain adequate clearance from mountainous terrain during cruise flight. A factor in the accident was the dark night lighting conditions.Oct 18, 2004 · N7049L · DestroyedNTSB CHI05CA006Accident · No injuriesData collectionFinal reportPiper PA-28-160 · Altoona, WIThe pilot's inadequate fuel management leading to the fuel starvation in the left tank during the flight's descent. A factor was the impacted power line.Oct 18, 2004 · N5520W · Substantial damageNTSB DFW05LA007Accident · No injuriesLimited investigationFinal reportCessna T210N · Seven Points, TXThe loss of engine power due to the failure of the number one connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.Oct 16, 2004 · N11FB · Substantial damageNTSB IAD05IA004Incident · Minor injuriesIncident investigationFinal reportRaven Industries S-60A · Auburn, METhe pilot's maneuver into a tree, which resulted in an inadvertent contact between a branch and a passenger.Oct 14, 2004 · C-GGAX · No damageNTSB DCA05MA003Accident · 2 fatalClass 1 · MajorFinal reportCanadair CL-600 · Jefferson City, MO(1) the pilots’ unprofessional behavior, deviation from standard operating procedures, and poor airmanship, which resulted in an in-flight emergency from which they were unable to recover, in part because of the pilots’ inadequate training; (2) the pilots’…Oct 14, 2004 · N8396A · Destroyed