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 SEA91FA060Accident · 3 fatalField investigationFinal reportCessna 172N · Bellingham, WAVFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude and/or clearance from the mountainous terrain. Factors related to the accident were: darkness and the adverse weather and…Mar 6, 1991 · CGIXI · DestroyedNTSB BFO91LA028Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Garrisonville, VAThe pilot's failure to maintain adequate clearance with the terrain. Contributing to the accident was VFR flight into IMC.Mar 4, 1991 · N2632Z · DestroyedNTSB MIA91IA091Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-200 · Jacksonville, FLInadequate engine performance in the designed airplane flight envelopes.Mar 2, 1991 · CGRNU · Minor damageNTSB LAX91FA117Accident · 1 fatalField investigationFinal reportBeech 58P · Green Valley, CAThe pilot's loss of aircraft control due to his disregard for and poor evaluation of significant weather advisories forecasting adverse weather conditions along the route of flight and the pilot's decision to initiate the flight.Mar 2, 1991 · N6666Q · DestroyedNTSB MIA91LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Jensen Beach, FLImproper in-flight planning decision by the pilot resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the unreliable fuel quantity indicators.Mar 1, 1991 · N5282H · Substantial damageNTSB FTW91FA045Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Fort Chaffee, ARThe pilot's operation of the aircraft with known deficiencies in equipment. Factors were the improper overhaul of the engines by other maintenance personnel resulting in oil loss, deteriorated engine performance, and unsuitable terrain.Mar 1, 1991 · N7488S · DestroyedNTSB ATL91LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Suches, GAThe pilot's failure to maintain altitude during cruise flight after loss of electrical power for an undetermined reason.Mar 1, 1991 · N6546Y · DestroyedNTSB LAX91LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fullerton, CAThe pilot's improper preflight inspection. Contributing to this accident was water in the fuel tank.Feb 27, 1991 · N3724P · Substantial damageNTSB CHI91LA101Accident · No injuriesLimited investigationFinal reportCessna T210N · Elwood, INThe pilot's improper use of the fuel selector which resulted in fuel starvation. A related factor was: soft terrain in the emergency landing area.Feb 27, 1991 · N210MS · Substantial damageNTSB LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.Feb 26, 1991 · N8290R · Substantial damageNTSB LAX91LA121Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Mesa, AZ1) The failure of the airplane's engine upper crankcase oil breather line; 2) total loss of engine power caused by a lack of lubricating oil. A factor in this accident was the pilot inadvertantly stalling the aircraft to avoid a collision with a wire.Feb 25, 1991 · N138WW · Substantial damageNTSB FTW91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Davant, LAThe power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Feb 25, 1991 · N7388J · Substantial damageNTSB DEN91IA047Incident · No injuriesIncident investigationFinal reportCessna 421C · Fort Morgan, COThe total failure of the flight compartment windshield (copilot's side) for undetermined reasons.Feb 25, 1991 · N125KS · Minor damageNTSB MIA91LA086Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Everglades City, FLInadequate supervision by the flight instructor. Factors were: dark night condition, penetration of a cloud, and spatial disorientation resulting in a spiral.Feb 24, 1991 · N1469Q · Substantial damageNTSB MIA91FA085Accident · 1 fatalField investigationFinal reportParker Warren Whittman Formula VEE · Pompano Beach, FLThe pilot-in-command's in flight loss of control due to incapacitation resulting from underlying severe heart disease. Contributing to the accident was the pilot-in-command's not reporting the history of hypertension and heart problems during his FAA medical…Feb 23, 1991 · N24PW · DestroyedNTSB LAX91FA111Accident · 2 fatalField investigationFinal reportCessna 150L · Carlsbad, CAThe cfi/pic's inadequate in-flight planning/decision and the continued VFR flight into an area of IMC conditions. The pilot's impairment due to high levels of antihistamine and the low ceiling were factors in the accident.Feb 23, 1991 · N18526 · DestroyedNTSB MIA91LA084Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Ldl-By-The-Sea, FLTail rotor blade failure due to undetermined reasons and unsuitable terrain during a precautionary landing.Feb 22, 1991 · N210FH · Substantial damageNTSB SEA91LA053Accident · No injuriesLimited investigationFinal reportBeech 95 · Roundup, MTPartial loss of power for undetermined reasons.Feb 18, 1991 · N2772Y · Substantial damageNTSB MIA91LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, FLFailure of the pilot to plan the flight and failure to obtain proper assistance from ATC after becoming lost, which resulted in total loss of engine power due to fuel exhaustion.Feb 18, 1991 · N24913 · Substantial damageNTSB FTW91FA042Accident · 1 fatalField investigationFinal reportCessna 172N · Thornton, TXThe pilot's decision to fly into known adverse weather and the wet microburst. A factor was his disregard for the forecast.Feb 18, 1991 · N5112K · DestroyedNTSB DEN91IA046Incident · No injuriesIncident investigationFinal reportAvions Marcel Dassault Mistert Falcon 900 · Eagle, COImproper engine maintenance by maintenance personnel, improper assembly of the combustion assembly transition liner, and the rupture of the first stage lp turbine wheel.Feb 18, 1991 · N90EW · Minor damageNTSB ATL91FA054Accident · 1 fatalField investigationFinal reportCessna 172 · Crossville, TNThe improper flight planning by the noninstrument rated pilot which resulted in his inadvertent flight into instrument meteorological conditions in mountainous terrain.Feb 14, 1991 · N8641B · DestroyedNTSB SEA91LA050Accident · 4 fatalLimited investigationFinal reportBeech F33A · Ogden, UTThe pilot elected to fly into known adverse weather and encountered icing conditions. Contributing to the accident was the pilot's inadequate evaluation of the weather and a loss of engine power for undetermined reasons.Feb 13, 1991 · N66841 · DestroyedNTSB LAX91LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA22-160 · Bagdad, AZThat the pilot misjudged the landing flare altitude. Contributing to this accident was the failure of the exhaust valve and the pilot's anxiety during the emergency.Feb 11, 1991 · N3064Z · Substantial damageNTSB FTW91FA036Accident · Minor injuriesField investigationFinal reportCessna 182K · Mansfield, TXThe failure of the number two cylinder piston due to inadequate maintenance.Feb 11, 1991 · N2486Q · DestroyedNTSB LAX91LA123Accident · No injuriesLimited investigationFinal reportBeech B95 · Riverside, CAFailure of the pilot to follow the emergency gear extension procedure to fully extend the landing gear. Contributing to the accident was the failure of the pilot to monitor the condition of the electrical power system, leading to the complete loss of…Feb 10, 1991 · N2712Y · Substantial damageNTSB DEN91LA041Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Durango, COEngine failure due to oil starvation caused by turbocharger oil feed line failure and subsequent loss of lubricating oil to the engine.Feb 10, 1991 · N9653Y · Substantial damageNTSB CHI91LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Osseo, WIFuel exhaustion which occurred when the pilot became lost/disoriented. Factors related to the accident were: the pilot's lack of total experience, the terrain condition, and a fence.Feb 10, 1991 · N49288 · Substantial damageNTSB CHI91LA094Accident · No injuriesLimited investigationFinal reportCessna R172K · Herington, KSLoss of engine power due to failure of a connecting rod bolt. A factor related to the accident was: the soft, unsuitable terrain.Feb 9, 1991 · N758ML · Substantial damageNTSB DEN91FA039Accident · 2 fatalField investigationFinal reportPiper PA-24-400 · Snowmass, COThe pilot's failure to maintain a proper altitude in mountainous terrain.Feb 8, 1991 · N8510P · DestroyedNTSB ATL91FA052Accident · 4 fatalField investigationFinal reportPiper PA-31-350 · Munford, ALThe pilot attempting visual flight in instrument meteorological conditions below the minimum safe altitude for terrain clearance. Contributing factors were the low ceiling and mountainous terrain.Feb 7, 1991 · N27818 · DestroyedNTSB CHI91LA089Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Browning, MOFuel starvation due to a blocked fuel vent. A factor related to the accident was unsuitable terrain.Feb 3, 1991 · N5516M · Substantial damageNTSB CHI91DEX02Accident · No injuriesFinal reportHagg Starduster TOO · Shelbyville, INThe pilot's inadequate preflight planning/preparation, not refueling the aircraft before taking off on this flight, and inaccurate fuel consumption calculations. A factor related to the accident is the unsuitable terrain selected by the pilot for a forced…Feb 3, 1991 · N224JH · Substantial damageNTSB NYC91LA071Accident · No injuriesLimited investigationFinal reportRobinson R-22 Alpha · Coram, NYThe pilot-in-command's failure to maintain rotor RPM and misjudging the height of the flare during a precautionary autorotative landing, resulting in a roll over during the landing flare touchdown.Feb 2, 1991 · N8555K · Substantial damageNTSB DEN91LA040Accident · No injuriesLimited investigationFinal reportAerostar RX7 · Durango, COThe pilot's failure to maintain obstacle clearance. Factors were: the unfavorable winds and the high obstructions in the flight path.Feb 2, 1991 · N35773 · Substantial damageNTSB BFO91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wise, VAThe loss of engine power brought on by a failure of the number three clyinder exhaust valve. Contributing to the accident was unsuitable terrain on the emergency landing field.Feb 2, 1991 · N7816D · Substantial damageNTSB ANC91FA023Accident · No injuriesField investigationFinal reportChampion 7EC · Eagle River, AKThe pilot-in-command's failure to maintain clearance from the terrain.Feb 2, 1991 · N8988R · Substantial damageNTSB LAX91LA090Accident · Serious injuriesLimited investigationFinal reportRiddell Lancair 235 · Agua Caliente, CAThe failure of the propeller blades due to a weakening of the wood structure due to acid hydrolysis. A factor in the accident was the inadequate maintenance of the propeller assembly by allowing exposure to excessive moisture and heat.Feb 1, 1991 · N17S · Substantial damageNTSB CHI91LA086Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INSeparation of the aft, upper, accessory case cowl assembly from the airplane, and inadequate airframe equipment provided by the manufacturer.Feb 1, 1991 · N5584M · Substantial damageNTSB DCA91MA019Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Beckley, WVFlight into known adverse weather conditions by the pilot, which resulted in ice accumulation on the aircraft and subsequent loss of aircraft control (tail plane stall) as the flaps were fully extended. Factors related to the accident were: the pilot's…Jan 31, 1991 · N167PC · DestroyedNTSB NYC91FA067Accident · 4 fatalField investigationFinal reportMBB BK 117 B-1 · Sonestown, PAThe pilot's inadequate preflight planning to assure that the intended course and altitude provided adequate terrain clearance. Contributing factor(s) was: the dark night, snow and mountainous terrain.Jan 27, 1991 · N891GM · DestroyedNTSB FTW91FA035Accident · 2 fatalField investigationFinal reportBell 206L-1 · S Tim Blk 198For undetermined reason(s), the helicoper crashed at sea (gulf of Mexico) in an area with a low ceiling, rain, and thunderstorms.Jan 27, 1991 · N39HC · DestroyedNTSB CHI91LA085Accident · No injuriesLimited investigationFinal reportMooney M2OE · Rush Hill, MOThe pilot's failure to refuel the airplane. A factor related to the accident was unsuitable terrain.Jan 27, 1991 · N1314W · Substantial damageNTSB ATL91FA043Accident · 1 fatalField investigationFinal reportCessna 337C · Bryson City, NCThe inadvertent flight into instrument meteorological conditions in mountainous terrain by the noninstrument rated pilot.Jan 27, 1991 · N2589S · DestroyedNTSB LAX91LA082Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Show Low, AZEngine failure due to fuel exhaustion. A factor was inoperative fuel gauges.Jan 26, 1991 · N8900X · DestroyedNTSB DEN91FA037Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Olton, TXThe pilot exceeded the design stress limits of the airframe and the performance of aerobatics at an altitude insufficient for recovery.Jan 26, 1991 · N4035B · DestroyedNTSB LAX91LA099Accident · Minor injuriesLimited investigationFinal reportWalter Chandler Phoenix · Cayucos, CAThe pilot's selection of unsuitable terrain and his misjudgment of the proper touch down point following the pilot's decision to make a precautionary landing. Contributing to the accident was an in-flight separation of the trim tab rod from the trim tab,…Jan 25, 1991 · N2027C · Substantial damageNTSB LAX91LA079Accident · No injuriesLimited investigationFinal reportRobinson R-22 HP · Scottsdale, AZThe failure of the drive belts due to excessive wear of the clutch assembly upper sheave and the pilot's inaccurate flare during the termination of the autorotation. A factor in the accident was the inadequate design of the clutch assembly upper sheave.Jan 25, 1991 · N21439 · Substantial damageNTSB LAX91LA078Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Sacramento, CAThe flight's inadvertant encounter with wake turbulence.Jan 22, 1991 · N96306 · DestroyedNTSB LAX91LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-300 · Anaheim, CAMaintenance personnel in that they improperly adjusted the left magneto which resulted in the complete erosion of the electrodes from six of the twelve installed spark plugs. The installation of spark plugs with colder heat ranges than specified by the…Jan 21, 1991 · N1885H · Substantial damage