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 SEA97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sweet Home, ORThe pilot's inadequate preflight preparation and his inadequate inflight planning which resulted in fuel exhaustion. A factor was lack of suitable terrain for a forced landing.Jun 20, 1997 · N6599S · Substantial damageNTSB FTW97LA230Accident · No injuriesLimited investigationFinal reportPiper PA-32-300T · Del Norte, COThe pilot's failure to attain proper runway alignment. Factors were his attention being diverted by a rough running engine because the fuel injectors were partially blocked.Jun 18, 1997 · N8056Y · Substantial damageNTSB NYC97LA114Accident · No injuriesLimited investigationFinal reportLuscombe 8F · New Town, PAThe pilot's improper fuel management, which resulted in an intermittent fuel supply, and a loss of engine power.Jun 15, 1997 · N1894B · Substantial damageNTSB IAD97LA090Accident · No injuriesLimited investigationFinal reportCessna 150 · Punxsutawney, PAPilot in command became disoriented and continued flight until fuel exhaustion. A factor to this accident is the pilot's inadequate in-flight planning/decision by over flying several airports during his disorientation.Jun 15, 1997 · N8080S · Substantial damageNTSB FTW97IA222Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-12 · Dallas, TXthe engine fire during descent resulting from a loose, leaking fuel transfer tube due to improper installation and alignment of the transfer tube's retaining clip. Contributing factors were the inadequate design of the clamp, the failure of the operator to…Jun 14, 1997 · N438AT · Minor damageNTSB MIA97LA182Accident · Minor injuriesLimited investigationFinal reportCessna 210F · Waycross, GAthe private pilot's failure to maintain airspeed, while maneuvering in an attempt to reverse direction, which resulted in an inadvertent stall, and subsequent in-flight collision with terrain.Jun 13, 1997 · N1817F · Substantial damageNTSB LAX97FA210Accident · 1 fatalField investigationFinal reportCessna 210K · Topanga, CAThe pilot's failure to maintain proper VFR altitude over mountainous terrain obscured by clouds, and his intentional descent into instrument meteorological weather conditions.Jun 12, 1997 · N8276M · DestroyedNTSB FTW97LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Jun 12, 1997 · N6182U · Substantial damageNTSB FTW97LA215Accident · Serious injuriesLimited investigationFinal reportBoeing 737-291A · Albuquerque, NMthe sudden encounter with clear air turbulence.Jun 11, 1997 · N980UA · No damageNTSB SEA97FA133Accident · 3 fatalField investigationFinal reportCessna U206E · Red Lodge, MTThe pilot-in-command's flight into known adverse weather and the subsequent overload and separation of the right wing-strut fuselage-to-strut attach point. Factors contributing were clouds and obscuration.Jun 9, 1997 · N206EC · DestroyedNTSB ATL97LA083Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Orangeburg, SCThe pilot experienced a partial loss of engine power for undetermined reason. The pilot failed to maintain flying airspeed which resulted in a stall and then subsequent collision with the ground. A factor was, conditions were favorable for the formation of…Jun 9, 1997 · N2551V · Substantial damageNTSB NYC97LA111Accident · No injuriesLimited investigationFinal reportCessna 150K · Jay, MEthe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.Jun 8, 1997 · N6218G · Substantial damageNTSB CHI97LA162Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Valparaiso, INa delay by the pilot of the other aircraft in turning on his mode C transponder.Jun 8, 1997 · N321UA · No damageNTSB NYC97LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Easton, PAA failed aileron pulley which resulted in loss of tension and subsequent loss of aileron control. A factor was the failure of the mechanic to detect the failed aileron pulley during the annual inspection.Jun 7, 1997 · N4173H · Substantial damageNTSB CHI97LA159Accident · 1 fatalLimited investigationFinal reportPiper PA-25 · Sullivan, MOthe pilot's continued VFR flight into instrument meteorological conditions in an airplane not equipped for flight into IMC. Factors were: the pilot's inadequate preflight preparation, his inadequate evaluation of the weather, and fog.Jun 7, 1997 · N6339Z · Substantial damageNTSB ATL97LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbus, MSinadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…Jun 5, 1997 · N7581W · Substantial damageNTSB ATL97LA081Accident · No injuriesLimited investigationFinal reportCessna 172I · N. Myrtle Beach, SCThe pilot's inadequate pre-flight inspection which resulted in fuel exhaustion and total loss of engine power. A factor was the soft terrain at the emergency landing site.Jun 5, 1997 · N5124G · Substantial damageNTSB ANC97LA084Accident · No injuriesLimited investigationFinal reportAnderson Kitfox IV-1200 · Fairbanks, AKa seized crankshaft connecting rod bearing. A factor relating to the acciden was: the lack of suitable terrain for an emergency landing.Jun 5, 1997 · N85TA · Substantial damageNTSB SEA97LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Lake Powell, UTA loss of engine power for undetermined reasons.Jun 4, 1997 · N34680 · Substantial damageNTSB MIA97FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Asheboro, NCfailure of the pilots in both airplanes to see and/or avoid a collision with each other.Jun 4, 1997 · N804DA · 2 aircraft · Substantial damageNTSB IAD97GA081Accident · Minor injuriesFinal reportPiper PA-18-150 · Harrisonburg, VAThe pilot's preoccupation which led to fuel starvation of the selected tank and the subsequent forced landing.Jun 4, 1997 · N4310Z · Substantial damageNTSB FTW97LA210Accident · No injuriesLimited investigationFinal reportBeech 60 · Pueblo, COloss of power in the right engine and failure of the right propeller to feather for undetermined reasons. A factor relating to the accident was: the pilot's failure or inability to align the airplane with the runway during the forced landing.Jun 4, 1997 · N7396D · Substantial damageNTSB LAX97GA198Accident · 2 fatalFinal reportBeech 95-B55 · San Carlos, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which led to an inadvertent stall/spin.Jun 3, 1997 · N8KB · DestroyedNTSB FTW97FA208Accident · 1 fatalField investigationFinal reportBell 206B · Intracoastl Cty, LAThe failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…Jun 1, 1997 · N115AL · 2 aircraft · Substantial damageNTSB LAX97LA197Accident · 1 fatalLimited investigationFinal reportRotorway 162F · Phoenix, AZthe owner/builder incorrectly installed the tail rotor drive pulley mounting scissors, overtorqued the pivot belts, did not perform the required maintenance lubrication of the pivot belts, and failed to perform adequate visual maintenance checks of these…May 31, 1997 · N176BT · DestroyedNTSB NYC97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Preston, MDThe pilot's improper flare during a precautionary landing, which resulted in a hard landing. A factor in the accident was the failure of the left magneto, which resulted in a partial loss of engine power.May 29, 1997 · N4497Y · Substantial damageNTSB NYC97LA101Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Granby, NYfailure of the pilot/owner to replace the torsional clutch as specified by the manufacturer, and subsequent failure of the helicopter's clutch, which resulted in a forced landing (autorotation). A related factor was: the encounter with trees in the emergency…May 29, 1997 · N4029S · Substantial damageNTSB ANC97LA079Accident · No injuriesLimited investigationFinal reportPiper J-5 · Wasilla, AKThe loss of engine power for an undetermined reason, and the noncertificated pilot's decision to perform a go-around after a suitable landing site had been attained. A factor associated with the accident was the rough and uneven terrain.May 29, 1997 · N31164 · Substantial damageNTSB FTW97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Greeley, COunlatching of the left outboard engine cowling latches for undetermined reason(s), which allowed the left engine cowling to separate inflight and strike the vertical stabilizer.May 28, 1997 · N491SC · Substantial damageNTSB FTW97LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ward, ARThe loss of engine power resulting from fuel starvation due to the pilot's mismanagement of available fuel. A factor was the lack of suitable terrain for a forced landing.May 26, 1997 · N7967P · Substantial damageNTSB CHI97FA146Accident · 2 fatalField investigationFinal reportHenry Barracuda · Antonia, MOinadvertent flight by the pilot into instrument meteorological conditions (IMC), spatial disorientation of the pilot, which led to his loss of aircraft control, and the pilot exceeding the design stress limits of the airplane, which led to an in-flight…May 26, 1997 · N5926 · DestroyedNTSB ATL97LA075Accident · Serious injuriesLimited investigationFinal reportLockheed L-1011-385-3 · Atlantic Ocean (Atlantic Ocean)The failure of the flight attendants to maintain control of loose cabin service equipment, a salt shaker, that resulted in an uncorrected tripping hazard.May 26, 1997 · N768DL · No damageNTSB LAX97LA193Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Rota, Sarkthe unauthorized use of automobile gasoline which led to the loss of engine power due to fuel vapor generation.May 25, 1997 · N53079 · DestroyedNTSB FTW97LA201Accident · No injuriesLimited investigationFinal reportCentrair 101C · Santa Fe, NMthe pilot's improper planning/decison. Factors relating to the accident were: lack of thermal lift, which resulted in an off-airport landing, and the lack of suitable terrain for the landing.May 25, 1997 · N991JB · Substantial damageNTSB SEA97FA120Accident · 2 fatalField investigationFinal reportPiper PA-32-301T · Bend, OROverload of the airframe structure. Thunderstorms and turbulence were factors.May 24, 1997 · N83211 · DestroyedNTSB CHI97LA145Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-G · Colusa, ILimproper installation of the rocker arm assembly by maintenance personnel which led to the failure of the rocker arm. A factor was the soft terrain.May 24, 1997 · N94415 · Substantial damageNTSB FTW97FA199Accident · 3 fatalField investigationFinal reportBeech V35 · Shawnee, OKThe pilot's inadvertent entry into a spin. A factor was the pilot's initiated flight into adverse weather.May 23, 1997 · N5459U · DestroyedNTSB MIA97LA174Accident · No injuriesLimited investigationFinal reportConvair CV-240 · San Juan, PRfailure of the aft master rod in the right engine, and failure of the front master rod bearing in the left engine, which resulted in a forced landing on a beach and a subsequent encounter with ocean water.May 22, 1997 · N355T · DestroyedNTSB LAX97LA190Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lamont, CAthe pilot's failure to maintain adequate fuel for the flight.May 22, 1997 · N6495A · Substantial damageNTSB ATL97LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sophia, NCimproper maintenance performed by an unknown person, which resulted in the reduction of airflow through the engine induction system and subsequent loss of engine power. A factor related to the accident was: failure of the pilot to attain a proper touchdown…May 22, 1997 · N8392C · Substantial damageNTSB SEA97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hysham, MTA failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.May 20, 1997 · N32142 · Substantial damageNTSB CHI97LA142Accident · No injuriesLimited investigationFinal reportMooney M20F · Wheeling, ILbinding of the number four exhaust valve, which resulted in a partial power loss. A factor was the ravine.May 20, 1997 · N6950V · Substantial damageNTSB CHI97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas the pilot not maintaining sufficient altitude to clear obstructions. A factor associated with the accident was the pilot was inattentive to the airplane's altitude.May 20, 1997 · N8811Z · Substantial damageNTSB ATL97LA078Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Sparta, TNA fire in the left engine started by a leak in the fuel pump.May 20, 1997 · N4105Q · Substantial damageNTSB LAX97LA184Accident · No injuriesLimited investigationFinal reportCessna 182G · Corona, CAfuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.May 19, 1997 · N3165S · Substantial damageNTSB LAX97LA185Accident · 1 fatalLimited investigationFinal reportBell 206B · Hilo, HIthe noninstrument-rated pilot flew into instrument conditions and failed to maintain adequate terrain clearance, while attempting to descend through an overcast. The adverse weather conditions and mountainous terrain were related factors.May 18, 1997 · N98AW · DestroyedNTSB LAX97LA183Accident · No injuriesLimited investigationFinal reportNorth American Navion NA-1 · Morristown, AZfailure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.May 18, 1997 · N8551H · Substantial damageNTSB MIA97LA168Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Orlando, FLThe pilot misjudging the distance of the intended touchdown point resulting in his intentional decrease in the main rotor rpm to clear obstacles below. Contributing to the accident was the total loss of engine power due to undetermined reasons.May 17, 1997 · N30SG · Substantial damageNTSB NYC97FA092Accident · 1 fatalField investigationFinal reportCessna T337G · North Dansville, NYthe pilot's improper decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance from rising/wooded terrain. The adverse weather conditions and rising wooded terrain were related factors.May 16, 1997 · N1ZP · DestroyedNTSB FTW97LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28R-210T · Fort Collins, COthe pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…May 15, 1997 · N43761 · Substantial damage