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 FTW94FA091Accident · 4 fatalField investigationFinal reportCessna 310K · Wichita Falls, TXWas the loss of control due to the pilot's spatial disorientation following a complete electrical system failure. Factors were the dark night and the electrical failure as result of burned out wiring terminal.Mar 4, 1994 · N474AR · DestroyedNTSB SEA94LA072Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Walla Walla, WAUnsuitable terrain for a forced landing after a loss of power due to a failed engine cylinder. Factors include a partial magneto failure.Mar 2, 1994 · N6612Q · Substantial damageNTSB CHI94LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lindsborg, KSwas the pilot-in-command's failure to refuel the airplane during the flight. Factors were fuel exhaustion, the sign, and the pilot-in-command's lack of total experience in type of airplane.Mar 2, 1994 · N3592R · Substantial damageNTSB SEA94LA088Accident · No injuriesLimited investigationFinal reportMikoyan MiG MIG-17T · Aurora, ORFailure of a metal fuel line, resulting in an explosion.Mar 1, 1994 · N306DM · Substantial damageNTSB LAX94LA187Accident · 2 fatalLimited investigationFinal reportBell 206A · Pacific Ocean (Pacific Ocean)undetermined.Mar 1, 1994 · N4712R · DestroyedNTSB ATL94FA056Accident · 4 fatalField investigationFinal reportCessna P210R · Bay Minette, ALThe pilot's failure to maintain control of the aircraft due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: the pilot's flight into known adverse weather conditions, overconfidence in…Mar 1, 1994 · N55MM · DestroyedNTSB LAX94IA145Incident · No injuriesIncident investigationFinal reportAerospatiale AS-350D · Huelo, HIThe operator maintenance personnel's inadequate 100-hour inspection. The loose fuel control line fitting, the tree stump, and the unsuitable terrain were factors in this accident.Feb 28, 1994 · N5771L · Minor damageNTSB SEA94LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarkston, WAThe pilot in command's inadequate use of carburetor heat. Factor(s) were: carburetor icing weather conditions and rough terrain.Feb 27, 1994 · N50765 · Substantial damageNTSB SEA94LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Nampa, IDThe pilot in command's failure to refuel the aircraft. Factor(s) contributing to the accident were: fuel exhaustion, lack of total experience in type aircraft, and terrain condition (ditch).Feb 27, 1994 · N2153G · Substantial damageNTSB CHI94IA095Incident · Minor injuriesIncident investigationFinal reportBritish Aerospace ATP · Mosinee, WIthe inadequate design of the PBSI electrical switch(es), and the operator's failure to expeditiously implement corrective Service Bulletins.Feb 26, 1994 · N854AW · Minor damageNTSB ATL94LA054Accident · No injuriesLimited investigationFinal reportHelio HE391B · Saluda, SCThe pilot's and mechanic's failure to adequately inspect the aircraft fuel system which resulted in fuel starvation.Feb 26, 1994 · N9050R · Substantial damageNTSB LAX94LA134Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350-B · Humuula, HIThe pilot's poor in-flight decision by failing to attain the best rate of climb speed and exceeding the helicopter's hover performance capability. The clouds and downdraft were factors in this accident.Feb 24, 1994 · N766MP · Substantial damageNTSB FTW94LA089Accident · No injuriesLimited investigationFinal reportMooney M20J · Gallup, NMThe loss of engine power due to the failure of the number 3 exhaust valve. A factor was the lack of suitable terrain available to execute the forced landing.Feb 24, 1994 · N201SX · Substantial damageNTSB SEA94LA064Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy H-23D · Seaside, ORThe pilot's improper use of flight controls resulting in settling with power.Feb 23, 1994 · N62413 · DestroyedNTSB MIA94FA078Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Inverness, FLThe pilot-in-command's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with terrain. Contributing to the accident was the…Feb 23, 1994 · N44899 · DestroyedNTSB LAX94LA133Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Clarksburg, CAThe total failure of the no. 1 cylinder due to fatigue resulting from an improperly adjusted mixture causing detonation. The soft, wet plowed field was a factor in this accident.Feb 23, 1994 · N36265 · Substantial damageNTSB LAX94LA132Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Etna, CAThe faituge of the gear tooth which caused the failure of the 42-degree gear box.Feb 23, 1994 · N204AP · Substantial damageNTSB ATL94LA053Accident · No injuriesLimited investigationFinal reportCessna T210R · Baxley, GADamage to the crankshaft internal oil tube by other maintenance persons during the engine overhaul that resulted in oil starvation.Feb 23, 1994 · N7793U · Substantial damageNTSB LAX94FA130Accident · 3 fatalField investigationFinal reportSikorsky S-58T · Walnut Creek, CAInadequate fuel quality control procedures by the helicopter operator resulting in fuel contamination and a loss of engine power. The pilot's decision to extend the autorotative glide to avoid striking residential homes, which resulted in low main rotor rpm…Feb 21, 1994 · N581BG · DestroyedNTSB BFO94LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · East Newport, MEImproper engine maintenance by the operator resulting in oil exhaustion and subsequent internal engine damage.Feb 20, 1994 · N100DF · Substantial damageNTSB BFO94LA048Accident · No injuriesLimited investigationFinal reportJenks Skybolt · Brockport, NYA loss of engine power due to undetermined reason (s). A factor in this accident was the snow covered, rough/uneven terrain which caused the airplane to nose over during landing roll.Feb 19, 1994 · N14DJ · Substantial damageNTSB BFO94FA043Accident · Serious injuriesField investigationFinal reportBeech C35 · Rockville, MDThe pilot's inadequate aircraft preflight inspection which resulted in a loss of engine power due to fuel contamination.Feb 19, 1994 · N5962C · DestroyedNTSB SEA94FA062Accident · 1 fatalField investigationFinal reportCessna T210N II · Emmett, IDAn inadvertent stall. Factors contributing to the accident were fuel exhaustion and the tailwind.Feb 16, 1994 · N5182Y · DestroyedNTSB MIA94LA075Accident · Minor injuriesLimited investigationFinal reportBeech G18S · Fort Lauderdale, FLThe pilot-in-command's improper approach planning and premature extension of the landing gear, resulting in the flight being unable to maintain sufficient altitude and airspeed to reach the runway. The loss of engine power on one engine was a factor.Feb 16, 1994 · N49K · DestroyedNTSB FTW94LA083Accident · No injuriesLimited investigationFinal reportCessna 172N · Georgetown, ARA carburetor icing induced power loss due to the pilot's improper use of carburetor heat in conditions conducive to carburetor icing. A factor was the lack of suitable terrain onto which a forced landing could be executed.Feb 16, 1994 · N737ZY · Substantial damageNTSB BFO94LA040Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Farmville, VAthe pilot's failure to refuel the helicopter with the correct fuel. Factors in the accident were the unclear information given by the passenger and airport line service personnel, the insufficient information regarding the labeling of the airport's fuel…Feb 14, 1994 · N4495M · Substantial damageNTSB LAX94FA125Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Lake Tahoe, CAThe pilot's impairment of judgment and performance due to drugs, which led to his failure to follow the recommended departure procedure, and his failure to maintain sufficient altitude/clearance from rising mountainous terrain. Factors related to the accident…Feb 13, 1994 · N3775T · DestroyedNTSB MIA94LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Port St. Lucie, FLThe failure of the pilot-in-command to properly preflight the airplane and ensure there was adequate fuel on board, and his improper in-flight planning/decision to continue the flight.Feb 12, 1994 · N89254 · Substantial damageNTSB LAX94LA141Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Pacific Ocean (Pacific Ocean)the failure of the chief steward to verify that all flight attendants had been informed, and were complying with the captain's instructions to remain seated with their seatbelts fastened.Feb 12, 1994 · N186UA · No damageNTSB LAX94LA121Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Bishop, CAfuel exhaustion due to the pilot's inadequate preflight planning and en route fuel consumption monitoring.Feb 12, 1994 · N9614U · Substantial damageNTSB SEA94FA060Accident · 1 fatalField investigationFinal reportMooney M20K · Applegate, ORPoor in-flight planning/decision and icing conditions. Factors to the accident were: selected flight into known adverse weather, dark night, and mountainous terrain.Feb 11, 1994 · N1093M · Substantial damageNTSB CHI94LA085Accident · No injuriesLimited investigationFinal reportCessna 182P · Glen Ullin, NDThe delayed application of the carburetor heat by the pilot-in-command. The carburetor icing weather condition was a factor.Feb 11, 1994 · N1794M · Substantial damageNTSB SEA94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cheyenne, WYThe pilot's improper use of the carburetor heat. A factor to the accident was carburetor icing conditions.Feb 10, 1994 · N5639P · Substantial damageNTSB LAX94FA116Accident · 1 fatalField investigationFinal reportCessna 310R · La Jolla, CAthe pilot's failure to maintain control of the airplane. Factors in the accident were the dark night lighting conditions, moderate to severe turbulence, and heavy rain.Feb 8, 1994 · N1976Y · DestroyedNTSB ATL94FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Murphy, NCThe failure of the pilot to maintain clearance from the terrain. Factors in the accident were the dark night, and the mountainous terrain.Feb 8, 1994 · N9637J · Substantial damageNTSB BFO94LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Norfolk, VAFatigue failure of the engine mounting bolt which resulted in loss of engine power and subsequent on ground collision with the terrain.Feb 7, 1994 · N38780 · Substantial damageNTSB MIA94FA067Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Sugarloaf Key, FLWas the failure of the pilot-in-command to perform a visual lookout and maintain his altitude. Contributing to the accident was the dark night, over water, visual descent.Feb 6, 1994 · N626CN · DestroyedNTSB MIA94GA099Incident · No injuriesFinal reportCessna 172N · Opa-Locka, FLInadequate maintenance inspection and lubrication of the flap rollers which resulted in the left flap inboard roller becoming jammed in the track during flap retraction.Feb 4, 1994 · N9003E · Minor damageNTSB LAX94LA112Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Arcata, CAfuel starvation resulting from the pilot's improper in-flight planning and his failure to correctly monitor the aircraft's fuel system and to position the selector valve on a tank containing fuel.Feb 4, 1994 · N93159 · Substantial damageNTSB BFO94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Taunton, MAA total loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to enable the successful completion of the forced landing.Feb 4, 1994 · N1877Q · Substantial damageNTSB MIA94LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tamarac, FLThe loss of engine power for undetermined causes.Feb 3, 1994 · N15635 · Substantial damageNTSB MIA94FA064Accident · 2 fatalField investigationFinal reportCessna T210M · Prentiss, MSA total loss of engine power due to the number five piston crown structure sustaining detonation/pre-ignition damage for undetermined reasons. The number two connecting rod and rod bolts failed due to an oil distress event. This resulted in a subsequent…Feb 3, 1994 · N6572M · DestroyedNTSB DCA94MA033Accident · Minor injuriesClass 1 · MajorFinal reportSaab-Scania 340B · New Roads, LAThe captain's movement of the power levers below flight idle in flight, the inadequate certification requirements and consequent design of the airplane's power levers that permitted them to be moved below the flight idle position into the beta range, either…Feb 2, 1994 · N349SB · Substantial damageNTSB SEA94LA053Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ORFuel exhaustion, and the pilot's poor inflight decision. Factors include the pilot's poor pre-flight planning, and a sign in the path of the landing roll.Jan 30, 1994 · N7741E · Substantial damageNTSB MIA94LA061Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 B4-203 · Ormond Beach, FLThe failure of the passenger to follow the visual and oral instructions of the crew to be seated and fasten seat belts.Jan 28, 1994 · VRBNK · No damageNTSB BFO94FA032Accident · 1 fatalField investigationFinal reportBeech BE-58 · Newtown, OHFailure of the pilot to maintain control of the aircraft after becoming spatially disorientated in night instrument meteorological conditions (IMC). Factors related to the accident were: the pilot's lack of experience in the type of operation, his lack of…Jan 27, 1994 · N555AC · DestroyedNTSB CHI94MA072Accident · 2 fatalMajor investigationFinal reportCessna 421C · Mccook, NEImproper in-flight planning/decision by the pilot, and the accumulation of airframe ice, which resulted in an inadvertent stall. Factors associated with the accident were: partial failure of both alternators, which resulted in a subsequent electrical system…Jan 26, 1994 · N5468G · DestroyedNTSB LAX94LA104Accident · No injuriesLimited investigationFinal reportBeech 58 · Modesto, CAThe pilot's failure to perform the emergency landing gear extension and other maintenance personnel's inadequate 100-hour inspection. The partial electrical failure and the pilot apprehension/anxiety due to a possible electrical fire were factors in this…Jan 25, 1994 · N1082W · Substantial damageNTSB BFO94FA034Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bethel, PAthe pilot attempting visual flight rules (VFR) flight into instrument meteorological conditions and the pilot not maintaining clearance from objects/terrain.Jan 25, 1994 · N28767 · DestroyedNTSB CHI94LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Waubay, SDthe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the false indications on the fuel gauges.Jan 23, 1994 · N10449 · Substantial damage