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 NYC99FA033Accident · 1 fatalField investigationFinal reportGulfstream American AA-1 · Brooklyn, CTThe student pilot's failure to maintain control of the airplane, resulting in an inadvertent stall/spin.Dec 4, 1998 · N6166L · DestroyedNTSB DEN99FA024Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta II · Deming, NMThe pilot's failure to maintain clearance of the transmission wire. Factors were the transmission wire, and the glaring sunlight condition.Dec 4, 1998 · N8340J · DestroyedNTSB CHI99LA048Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Burlington, WICarburetor ice, the pilot's inadequate pre-flight planning/preparation resulting in his flight into poor weather conditions, and the pilot's improper use of carburetor heat. Factors contributing to this accident were the carburetor icing conditions, the…Dec 4, 1998 · N395AC · Substantial damageNTSB ANC99LA015Accident · No injuriesLimited investigationFinal reportStinson 10A · Nondalton, AKThe pilot's continued operation of the airplane with known deficiencies, a failure of company maintenance personnel to replace an inoperative fuel gauge, and subsequent fuel exhaustion. Factors in the accident were siphoning of fuel from the right wing fuel…Dec 4, 1998 · N36755 · Substantial damageNTSB NYC99FA032Accident · Minor injuriesField investigationFinal reportEurocopter EC-135-P1 · Newark, NJthe pilot's failure to maintain proper rotor rpm and his improper in flight decision to enter autorotation due to his lack of knowledge of the power plant controls. Factors in the accident were the night conditions and the pilot's improper decision to fly…Dec 3, 1998 · N44NY · DestroyedNTSB ATL99LA027Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, NCThe failure of the #2 exhaust valve that resulted in the total loss of engine power. A factor is the lack of suitable emergency landing terrain.Dec 3, 1998 · N18022 · Substantial damageNTSB FTW99FA041Accident · 1 fatalField investigationFinal reportCessna 501 · Umpire, ARThe pilot's in flight loss of control for undetermined reasons.Dec 2, 1998 · N501EZ · DestroyedNTSB MIA99LA039Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Fort Lauderdale, FLan abrupt maneuver in response to a traffic avoidance system alert, resulting in a flight attendant falling and breaking a leg.Dec 1, 1998 · N414WF · No damageNTSB SEA99LA016Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-900 · Idaho City, IDThe pilot-in-command's not obtaining/maintaining clearance with the unmarked transmission lines. Contributing factors were environmental (dusk) conditions, the transmission lines, and both the pilot-in-command and the ground personnel not identifying the…Nov 30, 1998 · N977LF · Substantial damageNTSB MIA99LA045Accident · Minor injuriesLimited investigationFinal reportQuicksilver MXL-2 · Humacao, PRThe pilot's use of a synthetic oil that is not recommended by the engine manufacturer when premixing his two cycle gasoline/oil fuel mixture, resulting is a total loss of engine power due to decreased lubricating properties, and the subsequent forced landing…Nov 29, 1998 · N6153E · Substantial damageNTSB IAD99FA023Accident · 1 fatalField investigationFinal reportArmbruster MINI-500 · Midland, VAthe improper repair of the engine following a previous engine seizure which resulted in the loss of engine power over unsuitable terrain.Nov 29, 1998 · N500GH · DestroyedNTSB ATL99LA026Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · La Tortue, HaitiInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor was the terrain ( water).Nov 29, 1998 · N171TE · DestroyedNTSB FTW99FA038Accident · 1 fatalField investigationFinal reportBlanton RAF 2000 · The Colony, TXThe pilot's failure to maintain control of the gyroplane during cruise flight. A factor was the gusty wind condition.Nov 28, 1998 · N14GR · DestroyedNTSB ATL99LA024Accident · Serious injuriesLimited investigationFinal reportBeech 33-F33A · Fernandina Bch, FLThe Pilot's failure to maintain flying airspeed that resulted in a loss of control and an inadvertent stall. Factors were several electrical system component malfunction.Nov 28, 1998 · N69FL · Substantial damageNTSB NYC99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Reno, OHThe pilot's disregard of the information provided by the fuel gauges, which resulted in fuel exhaustion. Factors in the accident included leaks in the fuel system, and the pilot's reliance on using timing alone to determine fuel consumption.Nov 25, 1998 · N7177W · Substantial damageNTSB LAX99LA040Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164C · Oroville, CAThe pilot's decision to attempt readjustment of the rudder pedal in-flight.Nov 25, 1998 · N6596K · Substantial damageNTSB ATL99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Aiken, SCThe pilot's failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.Nov 25, 1998 · N3350T · Substantial damageNTSB ATL99LA023Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Locust Grove, GALoss of engine power due to a gear train failure in the accessory gearbox for undetermined reasons. A factor was the rough and uneven terrain.Nov 25, 1998 · N565ML · Substantial damageNTSB FTW99FA033Accident · 2 fatalField investigationFinal reportCessna 172N · Bacliff, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions and his inability to maintain adequate altitude/clearance from the wire. Contributing to the accident were the fog, low ceilings and his lack of instrument time.Nov 24, 1998 · N4908D · Substantial damageNTSB LAX99LA039Accident · No injuriesLimited investigationFinal reportVarga 2150A · Chandler, AZFuel exhaustion due to the pilot's failure to perform an adequate preflight of the aircraft to ensure that adequate fuel was available for the flight.Nov 22, 1998 · N78114 · Substantial damageNTSB CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.Nov 22, 1998 · N92585 · Substantial damageNTSB CHI99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Iowa Falls, IAthe pilot's improper preflight planning and preparation, and his not refueling the airplane. Factors were fuel exhaustion and the fence.Nov 22, 1998 · N2691T · Substantial damageNTSB LAX99LA054Accident · No injuriesLimited investigationFinal reportWilliams Hurrican HP · Corona, CAThe seizure of the engine due to a cylinder/piston overheat condition for undetermined reasons.Nov 21, 1998 · N323DW · Substantial damageNTSB LAX99FA038Accident · 1 fatalField investigationFinal reportCessna T210L · Oakland, CAThe pilot-in-command's inadequate fuel management which led to fuel starvation and subsequent loss of engine power. Also causal was the pilot's failure to maintain adequate altitude and his ostentatious display.Nov 21, 1998 · N9222T · DestroyedNTSB NYC99FA026Accident · 1 fatalField investigationFinal reportCessna 414A · Mattapoisett, MAThe pilot's failure to maintain control of the airplane after an undetermined failure of the airplane's attitude indicator. A factor in this accident was fog.Nov 20, 1998 · N6820J · DestroyedNTSB FTW99LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA32-300 · New Iberia, LAThe mechanic's failure to properly torque the connecting rod's bolt and nut during engine overhaul. A factor was the lack of suitable terrain for the forced landing.Nov 20, 1998 · N2881U · Substantial damageNTSB LAX99LA034Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orinda, CAA loss of engine power due to water contamination of the fuel. A factor was the pilot's inadequate preflight, during which he neglected to note the contamination, and the dark night which made it difficult to select a landing spot.Nov 19, 1998 · N48201 · DestroyedNTSB FTW99LA027Accident · Minor injuriesLimited investigationFinal reportMooney M20J · San Angelo, TXThe total loss of engine power due to the magneto failure resulting from oil contamination when the bearing plate retainer screw fractured due to improper manufacturing. Factors were the lack of suitable terrain for the forced landing, and the dark night…Nov 17, 1998 · N201QK · Substantial damageNTSB SEA99FA015Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Ferndale, WAThe pilot's improper decision to attempt to reach his final destination after a partial loss of engine power, instead of making a precautionary landing at one of the airports he overflew along his route. Factors include an inadequate preflight, a fuel filter…Nov 16, 1998 · CFJXG · Substantial damageNTSB ATL99FA019Accident · 1 fatalField investigationFinal reportCessna 182P · Santee, SCThe pilot continued VFR flight into IMC conditions and lost control of the airplane due to spatial disorientation. Factors were foggy weather conditions and self-induced stress.Nov 16, 1998 · N6522M · DestroyedNTSB MIA99FA034Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Olive Branch, MSThe pilot's failure to follow IFR procedures when he descended below the published minimum descent altitude.Nov 15, 1998 · N83396 · DestroyedNTSB CHI99FA029Accident · 1 fatalField investigationFinal reportCessna 182F · Wichita, KSThe pilot's inadequate preflight inspection and contaminated fuel supply.Nov 14, 1998 · N3240U · Substantial damageNTSB ATL99FA016Accident · 1 fatalField investigationFinal reportCessna 152 · Daytona Beach, FLAn interior cabin fire of undetermined origin. A factor was the power lines impacted during the emergency descent.Nov 14, 1998 · N48882 · Substantial damageNTSB MIA99LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power due to a connecting rod failure for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Nov 12, 1998 · N48013 · Substantial damageNTSB LAX99LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Gila Bend, AZThe crankshaft gear attach bolt loosening and backing out of its crankshaft bore, which led to the fatigue failure of the crankshaft gear dowel pin due to excessive working of the gear. The sequence of failures was the result of the engine overhaul shop's…Nov 12, 1998 · N991PK · Substantial damageNTSB IAD99LA015Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Louisville, KYA loose 'B' nut on the aircraft's PC Air line which resulted in fuel starvation, and the pilot's abrupt application of aft cyclic to prevent a nose over. Contributing factors were soft terrain and dark night conditions.Nov 12, 1998 · N32KY · Substantial damageNTSB DEN99LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Erie, COThe shorting of the aluminum battery wire and the subsequent failure of the fuel line. Factors were the weak/deteriorated battery, the insufficient information in the airplane's POH about charging an airplane's battery, and the fire in the crew compartment.Nov 11, 1998 · N8236Z · DestroyedNTSB SEA99FA013Accident · 1 fatalField investigationFinal reportHiller UH-12E · Marshall, WAThe loss of the bolt that connects the lateral cyclic linkage push rod to the lower end of the upper firewall-mounted lateral cyclic linkage bellcrank, resulting in an uncontrolled descent into the terrain.Nov 10, 1998 · N752GB · DestroyedNTSB FTW99LA023Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Tulsa, OKThe loss of engine power due to detonation for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Nov 10, 1998 · N24TH · Substantial damageNTSB FTW99FA020Accident · 2 fatalField investigationFinal reportBeech B19 · Hobart, OKThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain terrain clearance. Factors were the low ceiling, fog, dark night conditions, and the pilot's failure to obtain a weather briefing prior to the flight.Nov 8, 1998 · N9740L · DestroyedNTSB ATL99LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lima, SCThe flight instructor's intentional flight into Instrument Meteorological Conditions. Factors were trees and mountainous terrain.Nov 8, 1998 · N4696G · DestroyedNTSB MIA99FA031Accident · Minor injuriesField investigationFinal reportPiper PA-28-151 · Chattanooga, TNThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.Nov 7, 1998 · N44240 · Substantial damageNTSB ATL99LA012Accident · No injuriesLimited investigationFinal reportAeroSport WS-15-2 · Parkton, NCThe collapse of the carburetor heat box hose which starved the carburetor of air resulting in a partial loss of power, forced landing and nose over. Factors were the weeds and stocky stubble in the forced landing zone.Nov 7, 1998 · N88760 · Substantial damageNTSB SEA99TA010Accident · 2 fatalFinal reportCessna TR182 · Desert Aire, WAThe pilot's failure to maintain adequate altitude and/or clearance over a power line crossing the river, resulting in collision with a static wire at the top of the crossing structure. Factors included the static wire, and inadequate marking of the static…Nov 6, 1998 · N756YE · Substantial damageNTSB LAX99FA028Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Bishop, CAThe failure of the pilot-in-command, after encountering a downdraft, to maneuver and maintain clearance from mountainous terrain. Physical impairment due to hypoxia was a factor in the accident.Nov 6, 1998 · N2737R · DestroyedNTSB CHI99LA026Accident · No injuriesLimited investigationFinal reportTomschin Mini 500 · Clinton, MNthe non-pilot's failure to maintain clearance from the power lines. Factors contributing to this accident were the non-pilot's lack of total experience and the power lines.Nov 6, 1998 · N316AZ · Substantial damageNTSB CHI99FA023Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rock, KSthe pilot failed to maintain control of the aircraft and made an improper evaluation of the weather. Additional factors were flying a test flight at night with the icing conditions in the clouds.Nov 5, 1998 · N5LN · DestroyedNTSB LAX99LA024Accident · 1 fatalLimited investigationFinal reportCessna T210L · Lodi, CAFuel exhaustion due to a leaking engine driven fuel pump nose seal, which increased the engine fuel consumption rate above the published performance chart values.Nov 4, 1998 · N29058 · DestroyedNTSB IAD99GA013Accident · 1 fatalFinal reportSchweizer 269C · Baltimore, MDinadequate assembly instructions from the engine manufacturer which resulted in improper engine assembly, and subsequent power loss over unsuitable terrain, with insufficient altitude for a successful autorotation.Nov 4, 1998 · N2100B · DestroyedNTSB ATL99FA136Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Robbinsville, NC"This case was changed from ATL05FA014." The pilot's improper in-flight decision to continue VFR flight into IMC, which resulted in an in-flight encounter with weather and controlled flight into terrain. Factors were the pilot's inadequate preflight planning…Nov 4, 1998 · N2820T · Destroyed