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 MIA03LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Powells Point, NCa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.Nov 28, 2002 · N10905 · Substantial damageNTSB NYC03LA026Accident · No injuriesLimited investigationFinal reportCessna TR182 · Willoughby, OHThe pilot's failure to select the alternator to the "ON" position before initiating the flight. A factor in the accident was the tailwind which resulted in the overrun.Nov 27, 2002 · N4929S · Substantial damageNTSB LAX03LA041Accident · Serious injuriesLimited investigationFinal reportClyde K Carrier Team 1400Z · Woodland, CAthe builder/pilot's improper modification of wing fuel caps resulting in the failure of the vent system to adequately compensate for the pressure differential between the fuel tank and the external low pressure area of the wing. This led to the partial loss…Nov 27, 2002 · N9190U · Substantial damageNTSB FTW03FA051Accident · 5 fatalField investigationFinal reportPiper PA-34-220T · McAlester, OKThe pilot's failure to maintain the airplane's minimum controllable airspeed during a single-engine go-around which resulted in his loss of control. Contributing factors to the accident included the loss of power from the left engine as a result of…Nov 27, 2002 · N699WG · DestroyedNTSB DEN03LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Vernal, UTthe pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.Nov 27, 2002 · N9020J · Substantial damageNTSB SEA03FA013Accident · 2 fatalField investigationFinal reportCessna 172P · Malaga, WAThe pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…Nov 26, 2002 · N65564 · DestroyedNTSB FTW03FA048Accident · 2 fatalField investigationFinal reportBeech A36 · Salem, UTThe pilot's inadequate inflight planning/decision to continue flight from visual to instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain while in cruise flight. A low ceiling, obscuration, mountainous terrain…Nov 25, 2002 · N367T · DestroyedNTSB SEA03LA011Accident · Serious injuriesLimited investigationFinal reportPeterson Dragonfly · Mulino, ORFuel starvation of the engine while in cruise flight due to the owner/builder's alteration of the fuel system from that shown in the aircrafts plans. Factors include very rough terrain in the area where the pilot found it necessary to make his forced landing.Nov 23, 2002 · N2448 · Substantial damageNTSB NYC03LA023Accident · No injuriesLimited investigationFinal reportCessna 172K · Prestonsburg, KYThe loss of oil pressure for undetermined reasons, which resulted in a failure of connecting rod end bolts, due to an over temperature condition.Nov 23, 2002 · N7192G · Substantial damageNTSB CHI03LA029Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stalwart, MIThe pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced…Nov 23, 2002 · N5985Y · Substantial damageNTSB CHI03LA028Accident · No injuriesLimited investigationFinal reportWoods Velocity · Claflin, KSThe total loss of engine power while in cruise flight due to vapor lock of the fuel line as a result of the fractured exhaust manifold. A factor was the unsuitable terrain encountered during the forced landing.Nov 23, 2002 · N241KW · Substantial damageNTSB LAX03LA036Accident · No injuriesLimited investigationFinal reportAsmus Exec 162F · Monterey, CAThe loss of engine power for undetermined reasons. A factor in the accident was the pilot's failure to maintain aircraft control during the forced landing.Nov 21, 2002 · N162LC · Substantial damageNTSB NYC03FA024Accident · 1 fatalField investigationFinal reportSocata TB-20 · Massena, NYThe pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.Nov 20, 2002 · N57TB · Substantial damageNTSB LAX03LA034Accident · Minor injuriesLimited investigationFinal reportCessna T210 L · Williams, AZAn in-flight fire for undetermined reasons.Nov 20, 2002 · N59132 · DestroyedNTSB FTW03FA044Accident · 1 fatalField investigationFinal reportCessna 210L · Kentwood, LAThe failure of the #1 and #2 connecting rods during climb to cruise due to overheating, resulting from oil starvation. A contributing factor was the low cloud conditions limiting the pilot's visibility during the ensuing emergency landing.Nov 20, 2002 · N93770 · DestroyedNTSB CHI03FA025Accident · No injuriesField investigationFinal reportRobinson R22 · St. Jacob, ILFatigue fracture of the clutch assembly fan shaft and the resulting complete loss of power to the rotor drive system. A contributing factor was the loss of tail rotor authority due to the secondary failure of the control tube assembly.Nov 20, 2002 · N559DD · Substantial damageNTSB MIA03LA019Accident · 3 fatalLimited investigationFinal reportJohn H. Heiring Express · Moncks Corner, SCThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water.Nov 19, 2002 · N297JH · DestroyedNTSB NYC03IA027Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Rockville, VAThe PIC's inadvertent encounter with turbulence while operating in an area of forecast occasional severe turbulence.Nov 17, 2002 · N868CA · No damageNTSB NYC03FA022Accident · 2 fatalField investigationFinal reportCessna 182D · NewPhiladelphia, OHThe pilot's improper decision to disregard the weather briefing, and to conduct an intentional flight into known icing conditions, with an airplane not equipped for that flight, and his failure to maintain airspeed. Factors were the clouds and icing…Nov 17, 2002 · N9964T · DestroyedNTSB FTW03LA041Accident · 1 fatalLimited investigationFinal reportCessna 152 · Houston, TXThe dual student's intentional suicide by exiting from the airplane during descent. A contributing factor was the psychological condition of the dual student.Nov 17, 2002 · N4794P · No damageNTSB LAX03LA032Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Napa, CAthe pilot's inadequate management of the fuel system, which led to fuel starvation and a water ditching.Nov 16, 2002 · N501A · Substantial damageNTSB ANC03LA015Accident · 1 fatalLimited investigationFinal reportBell 206B · Kingman, AZThe pilot's failure to maintain altitude/clearance from obstacles during cruise flight, which resulted in the helicopter striking a transmission line, and subsequently the ground.Nov 15, 2002 · N16962 · Substantial damageNTSB ATL03LA016Accident · 1 fatalLimited investigationFinal reportChance Vought F4U-4 · Columbia, SCAn in-flight engine fire for undetermined reasonsNov 10, 2002 · N713JT · DestroyedNTSB IAD03LA012Accident · 1 fatalLimited investigationFinal reportWestland Helicopters Gazelle AH-MK1 · East Hampton, NYThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with water. Factors included the pilot's decision to fly over water on a moonless night, his lack of experience in that environment, and the dark night lighting…Nov 9, 2002 · N911XW · DestroyedNTSB LAX03FA025Accident · 1 fatalField investigationFinal reportCessna 150E · Anaheim Hills, CAthe pilot's continued VFR flight into instrument meteorological conditions and his subsequent failure to maintain clearance from power lines. A contributing factor was the pilot's impairment by medication.Nov 8, 2002 · N6236T · DestroyedNTSB DEN03FA012Accident · 4 fatalField investigationFinal reportCessna 208B · Parks, AZthe pilot's improper in flight planning/decision making, his flight into known icing conditions, and his failure to maintain adequate airspeed which resulted in the inadvertent stall/spin and impact with terrain. Factors contributing to the accident were the…Nov 8, 2002 · N514DB · DestroyedNTSB FTW03LA046Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kerrville, TXThe propeller shaft seal leak resulting in an in-flight fire.Nov 6, 2002 · N698VW · Substantial damageNTSB DEN03LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28RT · Grand Junction, COthe collapse of the left main landing gear during landing roll resulting in loss of control/ground loop/swerve and subsequent impact with a sign. Contributing factors include, the airplane's total loss of electrical power due to an alternator failure and the…Nov 6, 2002 · N2904C · Substantial damageNTSB ATL03LA014Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Orlando, FLThe airplane's inflight encounter with turbulence that resulted in injuries to the number two flight attendant.Nov 6, 2002 · N479AA · No damageNTSB FTW03LA034Accident · No injuriesLimited investigationFinal reportRockwell 690B · New Braunfels, TXThe in-flight separation of the top of the rudder assembly for undetermined reasons.Nov 1, 2002 · N77UA · Substantial damageNTSB FTW03LA030Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Fort Stockton, TXThe pilot's decision to conduct VFR flight into IMC and his failure to maintain terrain clearance. Contributing factors were the dark night, clouds, fog, and the lack of suitable terrain.Nov 1, 2002 · N6072R · Substantial damageNTSB FTW03FA028Accident · 1 fatalField investigationFinal reportHughes 269A · Fort Gibson, OKThe in-flight separation of the tail boom resulting from the failure of the fuselage to tail boom attachment fitting lugs, due to fatigue.Nov 1, 2002 · N8885F · DestroyedNTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.Oct 31, 2002 · N7099L · Substantial damageNTSB FTW03LA026Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Marshall, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Oct 31, 2002 · N35866 · Substantial damageNTSB ATL03LA012Accident · 1 fatalLimited investigationFinal reportBeech F33A · Fernandina Bch, FLWater contamination in the fuel system which resulted in the loss of engine power and the subsequent collision with trees.Oct 31, 2002 · N3122K · DestroyedNTSB ATL03LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Laurel Bloomery, TNThe pilot's failure to maintain clearance with terrain, which resulted in an inflight collision with mountainous terrain. Factors were the pilot's inadequate preflight planning and failure to obtain weather information, which resulted in an inflight encounter…Oct 31, 2002 · N15704 · DestroyedNTSB ANC03LA007Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Marshall, AKThe pilot's failure to maintain clearance from terrain, which resulted in an in-flight collision with a ridgeline. Factors contributing to the accident were the high terrain, the pilot's inadequate preflight planning, and the dark night light conditions.Oct 29, 2002 · N91090 · Substantial damageNTSB MIA03FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Coral Springs, FLThe failure of the dual students and flight instructors on both N9840V and N6101F to see and avoid each other, which resulted in a midair collision.Oct 27, 2002 · N9840V · 2 aircraft · DestroyedNTSB IAD03LA010Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Springfield, OHInadequate installation of the number 3 cylinder.Oct 27, 2002 · N49422 · Substantial damageNTSB NYC03LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.Oct 24, 2002 · N40059 · Substantial damageNTSB ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.Oct 24, 2002 · N73CR · DestroyedNTSB ATL03FA008Accident · 1 fatalField investigationFinal reportCessna 208B · Spanish Fort, ALthe pilot's spatial disorientation, which resulted in loss of airplane control. Contributing to the accident was the night instrument meteorological conditions with variable cloud layers.Oct 24, 2002 · N76U · DestroyedNTSB FTW03LA018Accident · No injuriesLimited investigationFinal reportCarriere RW-152 Scorpion II · Opelousas, LAThe pilot's inadequate compensation for wind resulting in a loss of control. A contributing factor was the gusting wind conditions.Oct 19, 2002 · N838MC · Substantial damageNTSB ATL03LA007Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Highfalls, GAThe pilots inadequate fuel management, and subsequent loss of engine power due to fuel exhaustion, and a in-flight collision with trees during an autorotation. A factor was the pilot's failure to insure that the required equipment (fuel gauge) was installed…Oct 19, 2002 · N4002G · Substantial damageNTSB NYC03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Hartwood, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.Oct 18, 2002 · N2718G · Substantial damageNTSB NYC03IA011Incident · No injuriesIncident investigationFinal reportPiper PA-28-236 · Altoona, PAA failure of the fuel selector for an undetermined reason.Oct 18, 2002 · N4295R · Minor damageNTSB DEN03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Salt Lake City, UTfuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.Oct 18, 2002 · N33170 · Substantial damageNTSB FTW03LA013Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · San Antonio, TXthe flight instructor's failure to refuel at an available airport when a low fuel status was identified. Factors were the flight instructor's inadequate preflight flight planning, which included improper fuel consumption calculations, the night light…Oct 16, 2002 · N61463 · Substantial damageNTSB NYC03LA004Accident · No injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Albany, NYAn in-flight collision with birds. A factor was the night conditions.Oct 15, 2002 · N847EX · Substantial damageNTSB NYC03LA005Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Block Island, RIThe pilot's misjudgment of speed and distance as a result of physical impairment due to smoke.Oct 14, 2002 · N5675V · Substantial damage