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 ATL03LA059Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Gordo, ALFatigue failure of the crankshaft.Mar 7, 2003 · N1648E · Substantial damageNTSB FTW03LA106Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Venice, LAThe pilot's inability to maintain directional control following a loss of tail rotor drive. A contributing factor was the fog.Mar 6, 2003 · N945PT · DestroyedNTSB FTW03LA104Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Kingsland, TXThe loss of tail rotor drive as a result of a blanket coming in contract with the tailrotor blades, after the aft cargo door was left unsecured. Contributing factors were the lack of suitable terrain for the forced landing, and the failure of the medical…Mar 6, 2003 · N793CA · Substantial damageNTSB CHI03FA078Accident · 2 fatalField investigationFinal reportBeech A36 · Sparta, ILThe pilot's inadequate in-flight planning/decision by his flight into known icing conditions which resulted in airframe icing and degraded aircraft performance until the onset of a stall.Mar 6, 2003 · N7253Z · Substantial damageNTSB MIA03FA071Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Cedar Key, FLThe pilot's inadequate in-flight planning/decision by his continued VFR flight into instrument meteorological condition after receiving an in-flight weather advisory. Also causal was his failure to maintain aircraft control, which resulted in flight that…Mar 4, 2003 · N6369C · DestroyedNTSB NYC03FA061Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Monterey, MAThe pilot's improper decision to attempt a visual flight rules (VFR) flight in marginal VFR weather conditions over mountainous terrain, which resulted in an in-flight collision with trees. Factors in this accident were clouds and night light conditions.Mar 3, 2003 · N4072R · Substantial damageNTSB LAX03LA104Accident · No injuriesLimited investigationFinal reportTowner Kit Fox 4 · Glendale, AZthe propeller's separation in-flight as a result of a bird strike.Mar 3, 2003 · N95FT · Substantial damageNTSB ATL03LA051Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Atlanta, GAThe flight's encounter with severe turbulence that resulted in serious injury to a flight attendant.Mar 1, 2003 · N642AS · No damageNTSB ATL03LA050Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenwood, SCThe pilot's continued visual flight into instrument meteorological conditions and loss of aircraft control, which resulted in an in-flight collision with the ground.Mar 1, 2003 · N67524 · Substantial damageNTSB NYC03FA058Accident · 1 fatalField investigationFinal reportCessna 182G · Renfrew, PAThe pilot's failure to maintain control of the airplane while maneuvering to land. Factors in the accident were the pilot's decision to fly into forecasted\known icing conditions, and the accumulation of structural ice.Feb 28, 2003 · N3404S · Substantial damageNTSB LAX03LA101Accident · No injuriesLimited investigationFinal reportCreitz, Robert D RV-3 · Deer Valley, AZThe pilot's improper use of carburetor heat, which resulted in carburetor icing and loss of engine power.Feb 28, 2003 · N87BC · Substantial damageNTSB ATL03FA049Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Sylvania, GAThe pilot's decision to conduct VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Related factors were the guy wire and the fog.Feb 26, 2003 · N54406 · DestroyedNTSB MIA03LA067Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLThe flight crew's inadvertent encounter with turbulence while attempting to maneuver through an area of convective activity during descent.Feb 25, 2003 · N790AN · No damageNTSB MIA03FA066Accident · 1 fatalField investigationFinal reportCessna 172P · Osteen, FLThe intentional suicidal act by the pilot-in-command resulting in the in-flight collision with trees then the ground.Feb 25, 2003 · N97890 · DestroyedNTSB LAX03LA096Accident · No injuriesLimited investigationFinal reportCessna 310 · Palmdale, CAThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude. Factors in the accident were the low ceilings and the dusk light illumination.Feb 24, 2003 · N5202A · Substantial damageNTSB LAX03LA092Accident · 1 fatalLimited investigationFinal reportEverett BD-10 · Dana Point, CAin-flight breakup of the experimental airplane for undetermined reasons.Feb 22, 2003 · N7FF · DestroyedNTSB MIA03LA069Accident · No injuriesLimited investigationFinal reportBeech A45 · Merritt Island, FLThe separation of both propeller blades in-flight for undetermined reasons and the failure of the pilot to attain the proper touchdown during the forced landing resulting in overrun during landing and subsequent collapse of the nose landing gear. A…Feb 21, 2003 · N34MR · Substantial damageNTSB MIA03LA064Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Marathon, FLThe loss of engine power to both engines for undetermined reasons.Feb 20, 2003 · N554AE · Substantial damageNTSB NYC03LA048Accident · No injuriesLimited investigationFinal reportCessna 172SP · Flemington, NJThe manufacturer's improper assembly of the accessory drive section of the engine.Feb 19, 2003 · N197ME · Substantial damageNTSB FTW03LA099Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta II · Kent, TXThe loss of main rotor drive due to a drive belt separation resulting in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.Feb 18, 2003 · N54TR · Substantial damageNTSB MIA03LA061Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · Miami, FLThe non instrument-rated pilot-in-command's improper inflight planning/decision, and continued VFR flight into instrument meteorological conditions, which resulted in a loss of control during descent, and impact with water.Feb 17, 2003 · N54835 · DestroyedNTSB FTW03FA097Accident · 2 fatalField investigationFinal reportBell 407 · Mi 700The catastrophic failure of the engine resulting from 1st stage turbine wheel blade failure due to type 1 hot corrosion (sulfidation). Contributing factors were the pilot's failure to brief the passengers on emergency safety equipment (life raft), the pilot's…Feb 16, 2003 · N407HH · DestroyedNTSB CHI03FA071Accident · 1 fatalField investigationFinal reportCessna 172N · Wellington, KSSpatial disorientation experienced by the pilot and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing prior to the return flight, his attempted flight into…Feb 15, 2003 · N5898E · DestroyedNTSB CHI03IA069Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Goodland, KSThe partial loss of engine power to both engines for undetermined reasons, and the pilot's improper in-flight decision to not land at the nearest available airport.Feb 13, 2003 · N9247L · Minor damageNTSB ATL03LA045Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Bolivar, TNThe loss of engine power for undetermined reasons. A factor was trees.Feb 13, 2003 · N6ZZ · DestroyedNTSB LAX03LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182A · The Gap, AZA total loss of engine power for undetermined reasons.Feb 10, 2003 · N5029D · Substantial damageNTSB MIA03FA054Accident · Serious injuriesField investigationFinal reportCessna 170A · Davie, FLThe pilot's improper preflight planning and his inadequate in-flight planning decision which resulted in loss of engine power due to fuel exhaustion and collision with wires and a road during the subsequent forced landing.Feb 9, 2003 · N9701A · Substantial damageNTSB SEA03FA038Accident · No injuriesField investigationFinal reportBeech A23 · Fort Klamath, ORThe separation of the rod end cap from the connecting rod for an undetermined reason during the descent for landing. The ditch was a factor.Feb 8, 2003 · N2392W · Substantial damageNTSB FTW03FA093Accident · 3 fatalField investigationFinal reportCessna T210N · Mission, TXThe pilot's failure to maintain aircraft control, which resulted in his exceeding the airplane's design limitation. Contributing factors were the pilot's decision to fly the airplane with known deficiencies with the attitude indicator, and the failure of the…Feb 5, 2003 · N4945Y · DestroyedNTSB CHI03IA066Incident · No injuriesIncident investigationFinal reportBombardier BD 100-1A10 · Wichita, KSThe uninterrupted current overload of the cabin outlet system static inverter leading to ignition and sustained fire. The cause of the initiating overload condition could not be determined. Contributing factors were the lack of adequate current overload…Feb 5, 2003 · C-GJCV · No damageNTSB FTW03LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · New Orleans, LAThe loss of engine power as a result of the separation of the magneto assembly due to inadequate maintenance by unknown personnel. A contributing factor was the lack of suitable terrain for the forced landing.Feb 3, 2003 · N658FT · Substantial damageNTSB FTW03LA091Accident · No injuriesLimited investigationFinal reportGilbertson Zodiac CH601HDS · Grandfield, OKThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the unfavorable wind.Feb 1, 2003 · N474BG · Substantial damageNTSB CHI03LA063Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot's failure to maintain aircraft control which resulted in the overload of the aircraft. Spatial disorientation, an inoperative turn coordinator, and the pilot's misinterpretation of the flight instruments were contributing factors.Feb 1, 2003 · N5677X · Substantial damageNTSB ATL03LA038Accident · No injuriesLimited investigationFinal reportBeech 200 · Jackson, MSThe failure of the landing gear system for undetermined reasons.Jan 31, 2003 · N208F · Substantial damageNTSB NYC03LA044Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Newport, METhe fatigue failure of a the cylinder wall.Jan 26, 2003 · N1484B · Substantial damageNTSB NYC03FA043Accident · 2 fatalField investigationFinal reportBeech V35B · Delaware City, DEThe mechanic's improper engine overhaul. A factor was the night condition.Jan 26, 2003 · N6432X · Substantial damageNTSB LAX03LA075Accident · No injuriesLimited investigationFinal reportCessna T210L · El Monte, CAthe alternator switch contact failure, which resulted in a complete electrical failure.Jan 25, 2003 · N732DK · Substantial damageNTSB LAX03FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Kalaupapa, HIthe student pilot's inadvertent VFR flight into IMC, which resulted in his in-flight collision with mountainous terrain while maneuvering. A contributing factor was the low ceiling weather condition.Jan 25, 2003 · N911FC · DestroyedNTSB LAX03FA074Accident · 1 fatalField investigationFinal reportBeech 95 · Rancho Cucamong, CAThe fracture and separation of a propeller blade during cruise flight due to fatigue and corrosion pits in the blade pilot bore, and an improper overhaul of the separated propeller by repair station personnel. Factors contributing to the accident were the…Jan 25, 2003 · N2733Y · DestroyedNTSB DEN03MA035Accident · 5 fatalMajor investigationFinal reportPiper PA-31T · Denver, COBoth pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.Jan 25, 2003 · N360LL · 2 aircraft · DestroyedNTSB MIA03LA047Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Fort Myers, FLThe pilot's inadequate preflight/preparation and his in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.Jan 24, 2003 · N543FH · Substantial damageNTSB DEN03FA038Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · La Sal, UTthe loss of engine power (total) due to fuel starvation, the pilot not following procedures/directives (fuel management procedures), and the pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the pilot's inadequately…Jan 24, 2003 · N106AW · DestroyedNTSB CHI03LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Clarence, IAA failure of the crankshaft for undetermined reasons. Factors associated with the accident were the rough terrain on which the forced landing was made and the night conditions.Jan 24, 2003 · N6572X · Substantial damageNTSB FTW03LA088Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Oak Grove, LAThe pilot's continued flight into adverse weather conditions, and his improper landing flare resulting in a hard landing. A contributing factors was the fog.Jan 21, 2003 · N5740L · Substantial damageNTSB FTW03TA087Accident · Serious injuriesFinal reportBeech T-34B · Hammond, LAThe pilot's inadequate inflight planning/decision resulting in fuel exhaustion and the loss of engine power. A contributing factor was the night light conditions.Jan 19, 2003 · N20684 · DestroyedNTSB CHI03LA058Accident · No injuriesLimited investigationFinal reportCessna 175 · Grand Island, NEThe loss of engine power due to fuel contamination and the pilot's inadequate preflight inspection.Jan 19, 2003 · N6663E · Substantial damageNTSB ATL03LA036Accident · No injuriesLimited investigationFinal reportBeech 65 · Fitzgerald, GAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the loss of engine power in both engines. A factor was a tree.Jan 18, 2003 · N115HF · Substantial damageNTSB SEA03LA029Accident · Serious injuriesLimited investigationFinal reportDassault Falcon 900EX · (Pacific Ocean)The aircraft's encounter with moderate turbulence in cruise.Jan 16, 2003 · N11WM · No damageNTSB SEA03FA026Accident · No injuriesField investigationFinal reportCessna 172K · Gig Harbor, WAThe loss of engine power in the climb due to the fracture of the number seven engine crankshaft cheek due to the propagation of a fatigue crack initiation point. Factors include a vehicle pulling onto the road that the pilot selected for his forced emergency…Jan 14, 2003 · N1909V · Substantial damageNTSB NYC03IA042Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11-C · Jamaica, NYA leak of potable water onto the lateral (aileron) flight control cables, and flap extension cables, which subsequently froze them in place. An additional cause was the improper procedures used by mechanics for floorboard removal which stretched the rubber…Jan 14, 2003 · I-DUPA · No damage