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 ATL94LA077Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-30 · Memphis, TNNot Determined.Apr 7, 1994 · N306FE · Minor damageNTSB ATL94FA076Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Elizabethton, TNThe pilot's attempted VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the clouds and obscuration at the accident site.Apr 7, 1994 · N64LB · DestroyedNTSB ATL94FA075Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Smithville, TNThe pilot's failure to obtain recent weather information to avoid flight into icing conditions. Factors in the accident were: management-induced pressure and the icing conditions.Apr 7, 1994 · N9710C · DestroyedNTSB LAX94LA182Accident · 1 fatalLimited investigationFinal reportCessna 152 · Avalon, CAthe failure of the pilot to apply carburetor heat as appropriate while conducting flight in conditions conducive for carburetor icing. A factor in the accident was the unsuitable steep mountainous terrain for a forced landing.Apr 6, 1994 · N93508 · DestroyedNTSB LAX94LA178Accident · Minor injuriesLimited investigationFinal reportNorth American P-51D · Chino, CAthe pilot's decision to fly an unairworthy and uncertificated airplane, his failure to perform an adequate preflight, and the improper installation of the oil cooler lines.Apr 5, 1994 · N1451D · DestroyedNTSB LAX94IA181Incident · Minor injuriesIncident investigationFinal reportFairchild SA-227AC · Ontario, CAthe failure of maintenance personnel to detect a crack in the windscreen which exceeded the operational limits for pressurized flight. A factor in the accident was the inadequacy of the inspection method published by the manufacturer.Apr 5, 1994 · N174SW · Minor damageNTSB ATL94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Winston-Salem, NCThe pilot's failure to place the aircraft fuel selector to the tank with fuel remaining.Apr 2, 1994 · N4298Y · Substantial damageNTSB FTW94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Roswell, NMThe loss of control due to clear air turbulence.Apr 1, 1994 · N8961P · Substantial damageNTSB MIA94LA108Accident · No injuriesLimited investigationFinal reportCessna 170 · Olive Branch, MSFailure of the pilot-in-command to apply carburetor heat before reducing engine power to descend resulting in the partial loss of engine power due to carburetor ice. Contributing to the accident was the unsuitable terrain encountered during the forced landing…Mar 29, 1994 · N2509V · Substantial damageNTSB ANC94IA049Incident · Minor injuriesIncident investigationFinal reportCessna 207 · Anchorage, AKThe partial failure of the no. 4 piston from over temperature (detonation).Mar 28, 1994 · N29CF · Minor damageNTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.Mar 27, 1994 · N2779B · Substantial damageNTSB LAX94LA173Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Santa Maria, CAAn engine failure due to the improper installation and service of an incorrect model magneto by maintenance personnel, and the failure of the pilot-in-command to follow published airplane emergency procedures.Mar 23, 1994 · N13620 · DestroyedNTSB ATL94LA067Accident · 1 fatalLimited investigationFinal reportCessna 140 · Celina, TNThe pilot's failure to maintain a proper altitude, and his failure to maintain clearance from the transmission wire.Mar 23, 1994 · N76342 · DestroyedNTSB CHI94LA121Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Ellsworth, NEthe jammed impulse coupling on the left magneto which caused the crankshaft drive gear to shear from the crankshaft.Mar 21, 1994 · N5251S · Substantial damageNTSB ANC94GA041Accident · Minor injuriesFinal reportGrumman G21A · Mt. Fairweather, CanadaThe pilot's improper decision in attempting to outclimb the rising terrain with the existing airplane climb performance. Factors which contributed to the accident were: the pilot's inadequate preflight of the airplane, the over maximum gross weight of the…Mar 21, 1994 · N741 · Substantial damageNTSB NYC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power as the result of a fractured cylinder head.Mar 20, 1994 · N1152X · Substantial damageNTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.Mar 20, 1994 · N5222U · DestroyedNTSB FTW94LA109Accident · No injuriesLimited investigationFinal reportCessna 175 · Leesville, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Mar 20, 1994 · N6537E · Substantial damageNTSB CHI94FA116Accident · Serious injuriesField investigationFinal reportCanadair CL=601-3A · Bassett, NEthe pilot in command's inadequate planning/decision making and inadequate preflight inspection after receiving a load of contaminated fuel. Related factors are the contaminated fuel, improper refueling by FBO personnel, and the dark night light conditions.Mar 20, 1994 · N88HA · Substantial damageNTSB NYC94GA066Accident · 1 fatalFinal reportHughes 369A · Northford, CTThe loss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM during the forced landing autorotation, resulting in a loss of aircraft control and collision with trees. Also causal to the accident was the pilot's lack of…Mar 19, 1994 · N97LC · DestroyedNTSB LAX94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Currie, NVthe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The snow, mountain obscuration, and icing conditions were factors in this accident.Mar 19, 1994 · N6727E · Substantial damageNTSB FTW94LA105Accident · No injuriesLimited investigationFinal reportCessna 150M · Steamboat Sprgs, COThe pilot's selection of too low an altitude in high mountainous terrain.Mar 19, 1994 · N233DB · Substantial damageNTSB LAX94LA167Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Stallion Spring, CAThe pilot's continued VFR flight into instrument meteorological conditions. His failure to obtain a weather briefing, the low clouds, and the mountainous terrain were factors in the accident.Mar 17, 1994 · N99520 · DestroyedNTSB LAX94LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Selma, CAThe pilot's improper use of the fuel supply which allowed the engine to sustain fuel starvation, and his failure to follow the emergency checklist by not using the electrical fuel boost pump. The engine fuel starvation was a factor in this accident.Mar 16, 1994 · N7541P · Substantial damageNTSB LAX94FA165Accident · 2 fatalField investigationFinal reportAyres S-2R · Reno, NVAn undetermined problem with the engine oil system, a decision to fly the airplane with a known deficiency, and progressive (partial) failure of the engine master rod and bearing.Mar 16, 1994 · N40237 · DestroyedNTSB FTW94FA101Accident · 4 fatalField investigationFinal reportCessna 172RG · Dulce, NMFailure by the pilot in command to properly plan the flight and calculate performance data.Mar 16, 1994 · N4663V · DestroyedNTSB CHI94IA111Incident · No injuriesIncident investigationFinal reportBeech BE200 · Rochester, INthe airplane painter/refinishers' failure to follow appropriate procedures/directives pertinent to the masking, stripping, painting and cleaning of the airplane cabin windows, which resulted in the in-flight failure of the right aft cabin window. A related…Mar 16, 1994 · N210SU · Minor damageNTSB NYC94LA062Accident · Serious injuriesLimited investigationFinal reportDouglas DC-8-61 · Covington, KYThe captain's improper decision to conduct flight at high altitude in an unpressurized airplane, which resulted in his incapacition from depressurization sickness. A factor related to the accident was: maintenance personnel failed to properly secure the…Mar 15, 1994 · N817CK · No damageNTSB NYC94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Warfordsburg, PAThe engine failure as a result of a main bearing shift and restricted lubrication, and the lack of suitable terrain for a forced landing.Mar 15, 1994 · N8335X · Substantial damageNTSB FTW94FA104Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Battlement Mesa, COImpaired judgement and performance of the pilot by flying while under the influence of alcohol that resulted in his failure to maintain clearance (or altitude) from terrain, while flying at night.Mar 15, 1994 · N9HC · DestroyedNTSB ATL94FA062Accident · 1 fatalField investigationFinal reportCessna 152 · Allendale, SCThe pilot's failure to maintain a proper altitude while in the VFR traffic pattern, resulting in a collision with trees. Factors were; his failure to comply with school directives by not obtaining a weather briefing prior to the accident flight, and the rain,…Mar 14, 1994 · N67581 · DestroyedNTSB CHI94LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Harbor Springs, MIThe pilot's improper decision to continue flight into icing conditions after the conditions were first encountered. A factor related to the accident was the trees contacted during the landing roll.Mar 13, 1994 · N83JF · DestroyedNTSB LAX94LA162Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9-118 · Sedona, AZthe failure of the pilot lights and burners to relight in flight once extinguished due to the installation of an incorrect gas pressure regulator.Mar 12, 1994 · N45289 · Substantial damageNTSB CHI94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Lebanon, INInadequate preflight preparation by the pilot-in-command. Factors were fuel system contamination and an unsuitable terrain encountered by the pilot-in-command during a forced landing.Mar 12, 1994 · N5135Z · Substantial damageNTSB ATL94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Columbia, SCThe poor inspection of the aircraft during the annual inspection by maintenance personnel. A factor in the accident was the foreign object found in the carburetor bowl.Mar 12, 1994 · N8647D · Substantial damageNTSB NYC94LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Beckley, WVA loss of engine power due to fuel contamination, while operating over unsuitable terrain, after the pilot failed to remove all the water from the tank prior to departure. A factor was the pilot's decision to operate the airplane with a known leaking fuel cap.Mar 11, 1994 · N3817W · Substantial damageNTSB LAX94LA158Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Tacna, AZa catastrophic internal engine failure for undetermined reasons. A factor in the accident was the dark nighttime lighting conditions.Mar 11, 1994 · N4977X · Substantial damageNTSB LAX94FA157Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Napa, CAthe pilot's selection of an en route descent altitude profile inadequate to clear all terrain along his intended flight path, and, his inadvertent VFR flight into IMC conditions. Factors in the accident were the dark night lighting conditions and the obscured…Mar 11, 1994 · N3562C · DestroyedNTSB CHI94LA110Accident · No injuriesLimited investigationFinal reportBeech C23 · Aurora, NEan inadequate fuel supply for the flight and the pilot's failure to refuel while en route. A factor related to the accident was the soft terrain on which the airplane was landed.Mar 11, 1994 · N5258M · Substantial damageNTSB CHI94LA101Accident · No injuriesLimited investigationFinal reportMooney M20C · Richland Center, WIimproper use of carburetor heat. Factors related to the accident were carburetor icing conditions, and the sign and fence poles.Mar 10, 1994 · N6811N · Substantial damageNTSB CHI94LA100Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eugene, MOimproper use of carbureter heat and a poorly planned precautionary landing approach. Factors related to the accident were carburetor icing conditions, the pilot's lack of total experience, trees and anxiety/apprehension.Mar 10, 1994 · N93679 · Substantial damageNTSB MIA94LA090Accident · No injuriesLimited investigationFinal reportCessna TU206F · Crystal River, FLThe failure of the no 1 piston connecting rod for undetermined causes. The lack of suitable terrain for a forced landing was a factor.Mar 8, 1994 · N8319Q · Substantial damageNTSB MIA94FA089Accident · 1 fatalField investigationFinal reportPiper J3C · Pembroke Pines, FLThe pilot's failure to maintain airspeed during a climbing turn after banner pickup and her use of excessive aircraft nose up trim which resulted in an inadvertent stall and spin.Mar 8, 1994 · N35112 · DestroyedNTSB FTW94LA092Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayden, COFailure by the pilot to maintain proper altitude. A factor was dark night conditions.Mar 8, 1994 · N5938K · Substantial damageNTSB ANC94LA039Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe pilot-in-command's improper inflight decision making. Factors contributing to the accident were the mountainous terrain and the downdraft weather conditions.Mar 7, 1994 · N4310B · Substantial damageNTSB NYC94LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Mt. Sterling, KYInadequate maintenance which resulted in the disconnection of the throttle cable from the carburetor and the subsequent loss of engine power. Factors were the annual inspection not performed, and complacency.Mar 6, 1994 · N19679 · Substantial damageNTSB NYC94LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Parrfield, OHThe pilot's mismanagment of the fuel supply by the improper positioning of the fuel selector valves, which resulted in fuel starvation and the total loss of engine power.Mar 6, 1994 · N99BR · Substantial damageNTSB ATL94LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · St. Matthews, SCA loss of engine power for undetermined reasons. A factor was the electric transmission wire located at the forced landing site.Mar 5, 1994 · N43571 · Substantial damageNTSB ATL94LA058Accident · Minor injuriesLimited investigationFinal reportRutan Rutan Long EZ · Kill Devil Hill, NCWas the pilot's failure to adequately sump the fuel system during the preflight inspection.Mar 5, 1994 · N7169L · Substantial damageNTSB LAX94FA149Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Frazier Park, CAthe pilot's failure to select a cruise altitude which would ensure adequate terrain clearance. Contributing factors related to the dark, nighttime condition and to the pilot's lack of attentiveness.Mar 4, 1994 · N78DE · Destroyed