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 NYC06LA223Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Hastings, NEThe airplane's in flight encounter with thunderstorm related turbulence.Sep 17, 2006 · N793SA · No damageNTSB ANC06LA140Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's failure to refuel the airplane before departure, which resulted in fuel exhaustion, and a total loss of engine power during cruise flight. Factors contributing to the accident were an inaccurate fuel tank indication on one of the two fuel tanks,…Sep 17, 2006 · N593V · Substantial damageNTSB LAX06CA294Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5 · Watsonville, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight planning, en route fuel consumption calculations, and in-flight decision to continue to the destination instead of stopping en route for fuel.Sep 16, 2006 · N6532L · DestroyedNTSB ANC06FA131Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. A factor associated with the accident was a low cloud ceiling.Sep 16, 2006 · N836KA · DestroyedNTSB DEN06FA132Accident · 4 fatalField investigationFinal reportBeech 35-C33 · Telluride, COThe pilot's inadvertent flight into mountain wave turbulence resulting in the airplane's loss of control and subsequent impact into mountainous terrain. Factors contributing to the accident were the mountain wave turbulence and high winds.Sep 15, 2006 · N5893J · DestroyedNTSB DEN06FA131Accident · 2 fatalField investigationFinal reportCirrus Design SR20 · Maybell, COThe pilot's improper in-flight planning and decision making resulting in an inadvertent encounter with severe icing conditions during cruise flight and subsequent loss of aircraft control. Contributing factors include the pilot's failure to obtain a weather…Sep 15, 2006 · N787SL · DestroyedNTSB CHI06CA267Accident · No injuriesData collectionFinal reportColumbia 350 · Bloomington, INThe pilot did not comply with the pilot operating handbook warning when he intentionally opened the cabin door during flight.Sep 15, 2006 · N6500V · Substantial damageNTSB CHI06LA260Accident · No injuriesLimited investigationFinal reportEndless Skies L164 · Durand, MIThe kit builder's improper installation of the aileron bracket leading to the aileron flutter during cruise that resulted in the wing spars' failure.Sep 11, 2006 · N2627J · Substantial damageNTSB NYC06LA219Accident · Minor injuriesLimited investigationFinal reportBeech F33A · South Windsor, CTA loosening of the fuel injector lines from the fuel manifold valve, which resulted in a partial loss of engine power.Sep 7, 2006 · N3708B · Substantial damageNTSB LAX06LA288Accident · 2 fatalLimited investigationFinal reportHughes 369D · Somis, CAThe pilot's inadequate visual lookout, which resulted in a collision with wires.Sep 6, 2006 · N812CE · Substantial damageNTSB CHI06CA276Accident · No injuriesData collectionFinal reportCessna T206H · Cedar Rapids, IAAn in-flight collision with a bird during climb to cruise altitude.Sep 6, 2006 · N2430A · Substantial damageNTSB CHI06FA256Accident · 1 fatalField investigationFinal reportMooney M20J · Smithville, OHThe altitude/ clearance not maintained by the pilot during cruise flight.Sep 5, 2006 · N1172U · Substantial damageNTSB NYC06FA215Accident · 2 fatalField investigationFinal reportCessna 150G · Penhook, VAThe pilot's failure to maintain aircraft control during climb, which resulted in exceeding the design stress limits of the airplane, and an in-flight breakup. Factors associated with the accident were the pilot's continued visual flight rules flight into…Sep 4, 2006 · N2932J · DestroyedNTSB MIA06LA136Accident · No injuriesLimited investigationFinal reportNoakes B J Corby CJ-1 · Edgewater, FLPartial loss of engine power for undetermined reasons.Sep 4, 2006 · N79860 · Substantial damageNTSB ATL06CA125Accident · No injuriesData collectionFinal reportBrown Floyd L Christen Eagle II · Topsail Beach, NCThe in-flight separation of the engine and propeller from the airframe for undetermined reasons, which resulted in the airplane's uncontrolled impact with water.Sep 3, 2006 · N225FL · Substantial damageNTSB NYC06LA214Accident · 1 fatalLimited investigationFinal reportCessna 150K · Shelby Gap, KYThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.Sep 2, 2006 · N6401G · DestroyedNTSB DEN06MA119Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Argyle, FLthe pilot's inadvertent flight into thunderstorm activity that resulted in the loss of control, design limits of the airplane being exceeded and subsequent in-flight breakup. A contributing factor was the failure of air traffic control to use available radar…Sep 1, 2006 · N6569L · DestroyedNTSB ANC06LA129Accident · No injuriesLimited investigationFinal reportPiper J5A · North Pole, AKThe pilot's inadequate in-flight planning, which resulted in a loss of engine power due to fuel starvation during cruise flight, and an emergency landing.Aug 30, 2006 · N35395 · Substantial damageNTSB LAX06FA277Accident · Minor injuriesField investigationFinal reportRaytheon Hawker 800XP · Smith, NVThe failure of the glider pilot to utilize his transponder and the high closure rate of the two aircraft, which limited each pilot's opportunity to see and avoid the other aircraft.Aug 28, 2006 · N879QS · 2 aircraft · Substantial damageNTSB DFW06CA204Accident · No injuriesData collectionFinal reportRon Burleigh Air Cam · Post, TXThe pilot's failure to maintain clearance with power lines while making a precautionary landing.Aug 28, 2006 · N9254F · Substantial damageNTSB CHI06FA245Accident · 1 fatalField investigationFinal reportCirrus SR22 · Indianapolis, INThe pilot's failure to maintain sufficient airspeed, which resulted in a stall and subsequent spin. Contributing to the accident were the pilot's inadequate preflight planning, the overloaded condition of the airplane, and the CG aft of the CG limit.Aug 28, 2006 · N91MB · DestroyedNTSB LAX06LA280Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Paramount, CAthe loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the landing.Aug 26, 2006 · N111VA · Substantial damageNTSB NYC06MA208Accident · 2 fatalMajor investigationFinal reportMitsubishi MU-2B-40 · Bunnell, FLThe pilot's inadvertent encounter with thunderstorms.Aug 25, 2006 · N171MA · DestroyedNTSB CHI06FA275Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kulm, NDThe non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.Aug 24, 2006 · N9714W · DestroyedNTSB CHI06LA243Accident · 1 fatalLimited investigationFinal reportFrick Questair Q20 · Big Rapids, MIThe pilot's failure to ensure an adequate fuel supply, which resulted in the exhaustion of the fuel supply and the subsequent loss of engine power. The trees that the airplane struck during the forced landing were a factor.Aug 23, 2006 · N2QV · Substantial damageNTSB SEA06LA167Accident · Minor injuriesLimited investigationFinal reportKinnson Lancair IV-P Turbine · Helena, MTThe total loss of engine power as a result of turbine over temperature due to the pilot's failure to follow proper procedures for engine operation. A contributing factor was the lack of suitable terrain for the ensuing forced landing.Aug 22, 2006 · N514PT · Substantial damageNTSB ANC06GA121Accident · 1 fatalFinal reportEurocopter France AS350 B2 · Nuiqsut, AKThe pilot's failure to maintain clearance from the sling load during cruise flight, which resulted in the load becoming entangled in the tail rotor, and an in-flight loss of control.Aug 22, 2006 · C-FYUN · DestroyedNTSB ATL06LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22-GTS · Mc Rae, GAThe pilot's failure to use supplemental oxygen where required, and his failure to maintain sufficient airspeed to avoid a stall.Aug 21, 2006 · N518SR · Substantial damageNTSB NYC06LA204Accident · Minor injuriesLimited investigationFinal reportButterhof Ginny B · Shiloh, NJA loss of engine power due to overheating, for undetermined reasons.Aug 19, 2006 · N349E · Substantial damageNTSB DFW06LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Houston, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 19, 2006 · N82078 · Substantial damageNTSB CHI06GA241Accident · No injuriesFinal reportMcDonnell Douglas Helicopters 369E · Columbus, OHThe uncontained engine failure due to the fatigue failure of the gas producer turbine tie bolt.Aug 19, 2006 · N554CP · Substantial damageNTSB ANC06LA119Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Whittier, AKThe pilot's continued VFR flight into instrument meteorological conditions, which resulted in a collision with terrain while maneuvering to reverse direction in a pass. A factor contributing to the accident was clouds in the pass.Aug 19, 2006 · N4975U · Substantial damageNTSB ATL06LA121Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Rans S-6 · Roseboro, NCThe pilot's failure to maintain ground clearance while maneuvering for a forced landing following loss of engine power.Aug 17, 2006 · N227AL · Substantial damageNTSB DEN06FA114Accident · Serious injuriesField investigationFinal reportCirrus Design SR20 · Kremmling, COThe pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…Aug 16, 2006 · N8127J · DestroyedNTSB ATL06CA120Accident · No injuriesData collectionFinal reportCessna 150L · Bunn, NCThe pilot's improper preflight inspection resulting in a total loss of engine power due to water ingestion, a forced landing to none suitable soft ground, and a nose over.Aug 13, 2006 · N6882G · Substantial damageNTSB DEN06LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Harrisburg, NEThe loss of engine power resulting from mechanical failure of a connecting rod for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 10, 2006 · N8741P · Substantial damageNTSB ATL06LA119Accident · No injuriesLimited investigationFinal reportAyres S2R · Doerun, GAThe loss of engine power for an underdetermined reason, resulting in a forced landing, an on ground collision with trees, and a post crash fire.Aug 10, 2006 · N61224 · DestroyedNTSB ANC06CA122Accident · No injuriesData collectionFinal reportBell 206B · Orlando, FLThe pilot's failure to refuel the helicopter prior to the accident flight, which resulted in a loss of engine power during cruise flight, and a hard landing.Aug 9, 2006 · N121RH · Substantial damageNTSB ANC06LA112Accident · No injuriesLimited investigationFinal reportBeech BE-18 · Culebra, PRA loss of engine power due to fuel starvation/exhaustion in all engines for an undetermined reason during cruise flight, which resulted in a forced landing and ditching.Aug 8, 2006 · N498BH · Substantial damageNTSB NYC06CA195Accident · Minor injuriesData collectionFinal reportChampion 7KCAB · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.Aug 5, 2006 · N7533F · Substantial damageNTSB CHI06CA216Accident · No injuriesData collectionFinal reportPiper PA-25 · Minot, NDThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel calculations and the low airspeed which resulted in the pilot stalling the airplane. A factor was the car on the road which prevented the pilot from landing on the road.Aug 5, 2006 · N7587Z · Substantial damageNTSB LAX06FA256Accident · 2 fatalField investigationFinal reportCessna 182P · Whitethorn, CAThe pilot's loss of situational awareness with regard to the airplane's proximity to mountainous terrain, and her failure to maintain an adequate terrain clearance altitude or flight path, which resulted in an in-flight collision with the terrain.Aug 4, 2006 · N9904E · Substantial damageNTSB SEA06TA153Accident · No injuriesFinal reportBell 206L-1 · Busby, MTThe improper overhaul of the turbine assembly by maintenance personnel, which resulted in failure of the turbine and a total loss of engine power. A contributing factor was the pilot's misjudgment of the landing flare at the termination of the autorotation.Aug 3, 2006 · N5746N · Substantial damageNTSB DEN06FA109Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Mosca, COa non-mechanical partial loss of engine power due to carburetor ice, and the pilot's failure to maintain clearance from terrain. Contributing factors in this accident were weather conditions conducive to carburetor icing and the pilot inadvertently flying…Aug 3, 2006 · N5416P · DestroyedNTSB NYC06CA188Accident · No injuriesData collectionFinal reportCessna 120 · Ashland, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and a subsequent loss of engine power. A factor in the accident was the trees.Jul 30, 2006 · N1981V · Substantial damageNTSB CHI06FA224Accident · 1 fatalField investigationFinal reportAmerican Legend AL11C · Chicago, ILThe failure of both pilots to assure that the fuel cap was securely in place prior to takeoff which resulted in fuel siphoning and untimately fuel exhaustion. An additional cause was the decision to fly over the lake outside of gliding distance to shore along…Jul 30, 2006 · N848LC · Substantial damageNTSB LAX06LA249Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Independence, CAthe pilot's inadequate preflight and in-flight planning regarding the selection of the altitude and route of flight, which resulted in a collision with terrain in a box canyon after encountering mountain wave.Jul 28, 2006 · N346D · Substantial damageNTSB LAX06LA247Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Flagstaff, AZthe pilot's inadequate preflight planning decision to take off under a low ceiling into an area of mountainous terrain that resulted in an encounter with lowering clouds and forced the pilot to land in unfavorable terrain.Jul 28, 2006 · N74780 · Substantial damageNTSB LAX06LA246Accident · 2 fatalLimited investigationFinal reportCessna 177B · Kalaupapa, HILoss of aircraft control during cruise flight for undetermined reasons. Clouds, rain, and dark night conditions were factors.Jul 28, 2006 · N30652 · DestroyedNTSB DFW06FA193Accident · 2 fatalField investigationFinal reportMooney M20J · Newellton, LAThe pilot's continued flight into adverse weather conditions. Contributing factors were the prevailing thunderstorms, the dark night conditions, and Air Traffic Control's failure to issue hazardous weather information to the pilot.Jul 27, 2006 · N577RS · Destroyed