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 LAX06FA104Accident · 1 fatalField investigationFinal reportRobinson R44 II · Minden, NVThe divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in main rotor/tail boom contact and loss of control.Feb 7, 2006 · N447SH · Substantial damageNTSB SEA06LA052Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Helena, MTThe pilot's intentional suicide. The unauthorized use of a helicopter and impairment by alcohol were factors.Feb 6, 2006 · N7085U · DestroyedNTSB CHI06LA078Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Wagner, SDThe pilot not maintaining airplane control and the inadvertent stall encountered during the climb. A factor was the instrument meteorological conditions.Feb 6, 2006 · N751CD · Substantial damageNTSB DFW06CA064Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawaokecie PZL-104 Wilga 80 · Comstock, TXThe pilot's inadequate preflight planning and preparation leading to him becoming lost. Contributing factors were the unfavorable winds and the lack of suitable terrain for a precautionary landing.Feb 2, 2006 · N192D · Substantial damageNTSB LAX06FA099Accident · 1 fatalField investigationFinal reportBeechcraft F33A · Buckeye, AZThe student pilot's failure to maintain aircraft control for undetermined reasons.Feb 1, 2006 · N1563A · DestroyedNTSB ATL06CA042Accident · No injuriesData collectionFinal reportCessna T210N · Rome, GAThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.Feb 1, 2006 · N2134U · Substantial damageNTSB LAX06LA098Accident · No injuriesLimited investigationFinal reportEurocopter AS350D · Kahului, HIA total loss of engine power due to the internal effects on the bearings consistent with an operating event of insufficient oil supply. Contributing to the accident was the pilot’s improper flare during the autorotative descent.Jan 29, 2006 · N90Q · Substantial damageNTSB NYC06LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Smoketown, PAThe pilot's improper pre-flight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.Jan 28, 2006 · N9183Y · Substantial damageNTSB ATL06FA038Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Camden, ALThe pilots failure to maintain altitude and clearance during a visual descent which resulting in an in-flight collision with trees and the ground for undetermined reasons.Jan 28, 2006 · N38510 · DestroyedNTSB MIA06LA049Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · West Palm Beach, FLA loss of engine power during descent due to an undetermined reason, which resulted in an off-airport forced landing and collision with a culvert.Jan 26, 2006 · N3292K · Substantial damageNTSB DEN06LA036Accident · No injuriesLimited investigationFinal reportCessna 172C · Pagosa Springs, COthe pilot initiating flight into known adverse weather, and his delay in not taking remedial action sooner by not making a precautionary landing. Contributing factors include the pilot's failure to obtain preflight and in-flight weather briefings, his…Jan 25, 2006 · N1407Y · Substantial damageNTSB LAX06LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Mariposa, CAThe failure of the maintenance personnel to follow the procedures in the TCM maintenance manual and adequately torque the engine through-bolts, which led to the separation of the No. 6 cylinder and the catastrophic failure of the engine.Jan 24, 2006 · N4791C · Substantial damageNTSB CHI06LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Jackson, MIthe blocked induction air filter due to ice accumulation which resulted in a loss of engine power. The pilot's improper weather evaluation, trees, snow, fog, and icing conditions were factors.Jan 24, 2006 · N3946W · DestroyedNTSB CHI06LA071Accident · 1 fatalLimited investigationFinal reportVillarubia RV-6 · Decatur, NEAn inflight collision with the terrain for undetermined reasons.Jan 23, 2006 · N242EV · Substantial damageNTSB CHI06LA070Accident · 1 fatalLimited investigationFinal reportCessna 172 · Harrison, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor associated with the accident was the pilot's impairment due to drugs.Jan 22, 2006 · N8540B · Substantial damageNTSB NYC06CA056Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · East Killingly, CTThe flight instructor's delayed decision to discontinue the simulated forced landing, which resulted in a collision with trees.Jan 21, 2006 · N32729 · Substantial damageNTSB LAX06LA092Accident · No injuriesLimited investigationFinal reportCroman SH-3H · Ely, NVthe loss of power in both engines due to the ingestion of ice and snow. Also causal was the pilot's preflight and in-flight decisions to fly into areas of known and forecast moderate icing conditions in contravention to the prohibitions contained in the…Jan 18, 2006 · N612CK · Substantial damageNTSB LAX06FA091Accident · 1 fatalField investigationFinal reportCessna 182P · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition.Jan 18, 2006 · N6034J · DestroyedNTSB CHI06LA069Accident · No injuriesLimited investigationFinal reportZilz Zenith CH801 · Moscow Mills, MOA loss of engine power due to inadequate design of the engine compartment which resulted in inadequate engine cooling and fuel starvation due to vapor lock. Factors associated with the accident were the utility pole and trees which were contacted during the…Jan 18, 2006 · N143ZT · Substantial damageNTSB SEA06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brookings, ORThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Trees and no suitable terrain for the landing were factors.Jan 13, 2006 · N35681 · Substantial damageNTSB ATL06LA035Accident · No injuriesLimited investigationFinal reportCirrus SR22 · Childersburg, ALThe pilot's inadequate preflight planning, failure to obtain a current weather briefing, and his decision to operate the airplane into a known area of icing outside the airplanes certification standards resulting in the aircraft accumulating ice, a loss of…Jan 13, 2006 · N87HK · Substantial damageNTSB NYC06LA054Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Lexington, KYFailure of the throttle cable. Contributing to the accident was unsuitable terrain for a forced landing.Jan 12, 2006 · N308M · Substantial damageNTSB LAX06LA072Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350BA · Hana, HIThe total loss of engine power due to a fatigue failure of a turbine blade. A factor in the accident was the lack of a suitable forced landing site.Jan 10, 2006 · N3607P · DestroyedNTSB DFW06CA051Accident · Minor injuriesData collectionFinal reportCessna 177 · Antlers, OKThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight planning. A contributing factor was the encounter with windshear during the forced landing.Jan 10, 2006 · N2233Y · Substantial damageNTSB CHI06LA060Accident · No injuriesLimited investigationFinal reportCessna 310R · St. Charles, MOThe in-flight collision with a duck during cruise flight resulting in a ruptured fuel tank and the strobe/light assembly electrical short resulting in a fire to the right wing tip tank. Contributing factors were the dusk light conditions.Jan 9, 2006 · N310CK · Substantial damageNTSB SEA06LA040Accident · No injuriesLimited investigationFinal reportHolscher KR II · McNeil Island, WAFuel exhaustion while in cruise flight due to inaccurate fuel quantity indications. Factors included the pilot's failure to positively determine the quantity of fuel onboard the aircraft during preflight, and rough, uneven grassy terrain at the location where…Jan 8, 2006 · N395JT · Substantial damageNTSB LAX06FA080Accident · No injuriesField investigationFinal reportEurocopter EC 130B4 · Lahaina, HIAn intermittent electrical continuity failure and short of the DECU-XPC wiring harness, which resulted in an uncommanded and an initially undetected engine deceleration and a resulting loss of main rotor rpm. Also causal was the manufacturer's inadequate…Jan 5, 2006 · N11QD · Substantial damageNTSB DFW06CA050Accident · No injuriesData collectionFinal reportCessna T210 · Midland, TXThe loss of engine power due to a connecting rod failure. Contributing factors were the dark night conditions and the lack of suitable terrain for the forced landing.Jan 5, 2006 · N5279A · Substantial damageNTSB SEA06FA036Accident · 1 fatalField investigationFinal reportBeech 35-A33 · Heber City, UTThe pilot's continued VFR flight into IMC and his subsequent failure to maintain terrain clearance while maneuvering resulting in an in-flight collision with terrain. Contributing factors were low ceilings, snow, and mountainous terrain.Jan 2, 2006 · N1254Z · Substantial damageNTSB NYC06LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Yonkers, NYA loss of engine power for undetermined reasons, which resulted in a ditching.Jan 2, 2006 · N2759M · Substantial damageNTSB MIA06FA039Accident · 3 fatalField investigationFinal reportRobinson R44 · Grand Ridge, FLThe pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.Jan 2, 2006 · N442DH · DestroyedNTSB LAX06IA076Incident · No injuriesIncident investigationFinal reportSaab-Scania SF340B+ · Santa Maria, CAAn in-flight loss of control due to ice accreted in supercooled liquid droplets (SLD) conditions, and the flight crew's failure to maintain the specified minimum airspeed in icing conditions. Contributing to the accident was the flight crew's decision to…Jan 2, 2006 · N390AE · No damageNTSB ATL06CA031Accident · Serious injuriesData collectionFinal reportPiper PA-23-160 · Phenix City, ALThe pilot's inadequate decision to continue VFR flight into IMC conditions, which resulted in a loss of engine power due to fuel exhaustion.Jan 2, 2006 · N4370P · Substantial damageNTSB ANC06LA015Accident · 1 fatalLimited investigationFinal reportCessna 180 · Seward, AKThe pilot's inadequate weather evaluation, which resulted in an in-flight encounter with low ceilings, turbulence, and downdrafts in cruise flight, and the pilot's failure to maintain altitude/clearance while maneuvering, which resulted in an in-flight…Jan 2, 2006 · N212RF · Substantial damageNTSB DEN06FA028Accident · 1 fatalField investigationFinal reportCessna 182D · Heber, AZthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors included the pilot's lack of night flying experience and the dark night.Jan 1, 2006 · N182GV · DestroyedNTSB DFW06CA048Accident · Minor injuriesData collectionFinal reportBell 206L-4 · Washington, LAThe in-flight collision with a bird and the pilot's physical impairment (vision), directional control was not possible.Dec 30, 2005 · N1811 · Substantial damageNTSB ATL06FA029Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Sylva, NCThe pilot's continued VFR flight into IMC conditions resulting in a collision with mountainous terrain.Dec 29, 2005 · N799TM · DestroyedNTSB SEA06LA033Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe ground personnel baggage handler failed to maintain clearance from the aircraft with cargo handling equipment during ground operations and inadvertently damaged the airplane's pressure bulkhead which subsequently decompressed during climb to cruise.Dec 27, 2005 · N979AS · Substantial damageNTSB ATL06LA028Accident · Serious injuriesLimited investigationFinal reportCessna 177-RG · Locust Grove, GAThe total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.Dec 27, 2005 · N53257 · Substantial damageNTSB ATL06LA027Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Maiden, NCThe total loss of engine power due to the failure of the No. 5 main bearing due to overheating for undetermined reasons.Dec 27, 2005 · N2887M · Substantial damageNTSB DFW06LA041Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 (PT17) · Fort Worth, TXThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. Contributing factors were the reported loss of engine power for undetermined reasons and the low altitude maneuver.Dec 26, 2005 · N67195 · Substantial damageNTSB SEA06CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Emmett, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.Dec 25, 2005 · N5695V · DestroyedNTSB LAX06LA068Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Hopland, CAThe non-instrument rated pilot's failure to maintain clearance with terrain, which resulted in a controlled flight into terrain. Contributing factors were the dark night conditions and the low clouds.Dec 25, 2005 · N3953R · DestroyedNTSB MIA06CA040Accident · No injuriesData collectionFinal reportBeech BE23 · Palatka, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.Dec 24, 2005 · N7657R · Substantial damageNTSB MIA06CA034Accident · No injuriesData collectionFinal reportCessna 182 · Haines City, FLThe pilot's improper preflight planning/preparation, and operation of equipment with known deficiencies, a right wing fuel cap leak, which resulted in fuel exhaustion and the loss of engine power.Dec 24, 2005 · N8304S · Substantial damageNTSB LAX06LA067Accident · Minor injuriesLimited investigationFinal reportForrest Haynes Lancair 320 · Ramona, CAThe loss of engine power for undetermined reasons.Dec 24, 2005 · N320WH · DestroyedNTSB LAX06LA064Accident · 4 fatalLimited investigationFinal reportCessna 172 · Gilroy, CAThe non-instrument rated pilot's poor judgment to fly in dark night instrument conditions, which resulted in his spatial disorientation and loss of aircraft control while maneuvering. Contributing factors were the dark night light condition and the low…Dec 22, 2005 · N7383A · DestroyedNTSB ATL06CA026Accident · Serious injuriesData collectionFinal reportEurocopter France AS-350-B2 · Jasper, ALThe pilot's failure to maintain a visual look out, and proper altitude clearance during a low level flight, resulting in an in-flight collision with a power line.Dec 22, 2005 · N350ET · Substantial damageNTSB DCA06MA010Accident · 20 fatalClass 1 · MajorFinal reportGrumman G-73T · Miami, FLThe in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…Dec 19, 2005 · N2969 · DestroyedNTSB MIA06LA041Accident · 3 fatalLimited investigationFinal reportCessna 195 · St. Augustine, FLThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching. Factors contributing to the survivability of the accident were the low ceilings and rough water.Dec 18, 2005 · N22L · Substantial damage