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 ANC03LA044Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kotzebue, AKThe pilot's failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with terrain during cruise flight. Factors associated with the accident were flat light conditions, and snow-covered terrain.Apr 16, 2003 · N2863T · Substantial damageNTSB FTW03LA129Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Fort Worth, TXA loss of engine power due to corrosion and contamination of the fuel system, and the partially blocked fuel lines and nozzles.Apr 14, 2003 · N390BC · Substantial damageNTSB ANC03LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cantwell, AKThe pilot's selection of an unsuitable landing area in deep snow, which resulted in the nose over of the airplane on touchdown. A factor associated with the accident was a snow-covered airstrip.Apr 14, 2003 · N339T · Substantial damageNTSB LAX03FA134Accident · 2 fatalField investigationFinal reportHughes 269B · Auburn, CAthe misjudged flare maneuver by an unknown crewmember during a likely practice autorotation that resulted in an in-flight collision with terrain.Apr 11, 2003 · N16133 · DestroyedNTSB LAX03IA137Incident · No injuriesIncident investigationFinal reportAirbus Industrie A300F4-605R · Oakland, CAthe failure of the 1R evacuation slide to inflate because the transport-locking pin had not been removed from the regulator during the slide's installation on the 1R door. The cause of the cabin/cockpit smoke was contamination of the air conditioning packs.Apr 10, 2003 · N676FE · No damageNTSB CHI03LA101Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Richmond, INThe pilot misjudged the fuel supply during the aircraft preflight which resulted in fuel exhaustion. A factor associated with the accident was the wires.Apr 10, 2003 · N614Q · Substantial damageNTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.Apr 10, 2003 · N822DB · DestroyedNTSB ATL03FA075Accident · 2 fatalField investigationFinal reportCessna 180 · Oxford, ALThe pilot's continued VFR flight into IMC conditions and his failure to maintain obstacle clearance. A factor was low ceilings.Apr 10, 2003 · N3166D · DestroyedNTSB SEA03FA059Accident · 2 fatalField investigationFinal reportCessna T207 A · Merlin, ORThe pilot's failure to maintain clearance from mountainous terrain while in cruise flight. Factors include low ceilings and mountainous terrain.Apr 9, 2003 · N9785M · DestroyedNTSB CHI03LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Rose Hill, KSThe loss of engine power due to the failure of the left magneto and the pilot's failure to identify the malfunctioning magneto. A factor to the accident was the soft terrain condition encountered during the forced landing.Apr 9, 2003 · N4860Z · Substantial damageNTSB LAX03LA132Accident · Minor injuriesLimited investigationFinal reportDeer/Reffalt BD · Greenfield, CAThe loss of engine power during cruise flight for undetermined reasons.Apr 7, 2003 · N4365K · Substantial damageNTSB LAX03LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Baker, CAthe separation of a propeller blade tip due to fatigue cracking that resulted from improper maintenance repair procedures.Apr 6, 2003 · N8465R · Substantial damageNTSB LAX03FA131Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Big Bear Lake, CAthe pilot's inadequate decision regarding a departure route and his failure to maintain clearance with rapidly rising mountainous terrain. A factor in the accident was the pilot's impairment by the effects of exposure to marijuana within the 10-hour period…Apr 6, 2003 · N8719N · DestroyedNTSB FTW03LA121Accident · Serious injuriesLimited investigationFinal reportBoeing 737-924 · Palestine, TXThe airplane's encounter with unforecasted clear air turbulence during cruise flight.Apr 6, 2003 · N71411 · No damageNTSB DEN03LA063Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A319-111 · Pueblo, COin-flight encounter with turbulence.Apr 6, 2003 · N917FR · No damageNTSB LAX03LA128Accident · No injuriesLimited investigationFinal reportCessna 172N · Anaheim, CAFailure of company maintenance personnel to correctly install and safety wire the oil drain plug, which led to a loss of engine oil and a catastrophic internal failure of the engine.Apr 5, 2003 · N6272D · Substantial damageNTSB LAX03LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Santa Maria, CAThe pilot's inadequate in-flight planning/decision resulting in fuel exhaustion which resulted in a total loss of engine power during cruise flight, and a subsequent on-ground collision with a pole and a fence during the ensuing emergency landing.Apr 5, 2003 · N21175 · Substantial damageNTSB ANC03LA039Accident · No injuriesLimited investigationFinal reportCessna 207 · Aniak, AKThe pilot's improper fuel management, and subsequent fuel starvation during cruise flight. A factor contributing to the accident was unsuitable terrain for a forced landing.Apr 5, 2003 · N207SE · Substantial damageNTSB LAX03LA123Accident · No injuriesLimited investigationFinal reportRobinson R-44 II · Willcox, AZThe failure of the alternator belt which resulted in the failure of the main drive belt.Apr 2, 2003 · N233TR · Substantial damageNTSB MIA03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Sarasota, FLA loss of engine power due to the crankshaft bolt losing torque, the gear disengaging, and the engine ceasing to operate as a result of inadequate maintenance installation.Apr 1, 2003 · N4952J · Substantial damageNTSB CHI03IA097Incident · No injuriesIncident investigationFinal reportBoeing 747-422 · Chicago, ILFailure of company maintenance personnel to fully comply with published maintenance/inspection procedures, as well as the resulting inoperative drain heaters and restricted movement of the aileron control cables. Contributing factors were the impeded waste…Apr 1, 2003 · N175UA · No damageNTSB ATL03IA073Incident · No injuriesIncident investigationFinal reportCessna 182P · Eufaula, ALFatigue failure of end rib for the left canard flap.Apr 1, 2003 · N696SP · Minor damageNTSB NYC03LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Shenandoah, VAThe pilot's inadvertent encounter with snow showers. Factors were the snow and the unsuitable landing area.Mar 31, 2003 · CGIKO · Substantial damageNTSB NYC03LA075Accident · Serious injuriesLimited investigationFinal reportBeech B-60 · Bradford, PAThe pilot's improper decision to maneuver for a landing in a configuration that exceeded the capability of the airplane to maintain altitude, after he lost power on one engine for undetermined reason(s).Mar 31, 2003 · N215CQ · DestroyedNTSB FTW03FA120Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Broken Arrow, OKFailure of the engine due to the blow-by condition in the number six cylinder for undetermined reasons, which resulted in oil starvation and eventual failure of the associated connecting rod end cap. Also causal was the pilot's failure to maintain airspeed…Mar 31, 2003 · N70NZ · DestroyedNTSB CHI03LA095Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401 · Knox, INA loss of engine power due to oil starvation as a result of the failure of the master rod bearing. Contributing factors were the tree line at the edge of the field, and the unsuitable terrain.Mar 31, 2003 · N45297 · Substantial damageNTSB CHI03FA094Accident · 3 fatalField investigationFinal reportBeech A36 · New Vienna, IAThe improper planning/decision by the pilot to fly into forecast icing conditions with an airplane not equipped with a certified deice system. The continued flight in known icing conditions and the flight to an alternate destination not performed by the pilot…Mar 28, 2003 · N1636W · DestroyedNTSB ATL03FA070Accident · 1 fatalField investigationFinal reportCessna 172R · Cherokee, NCThe pilot's failure to maintain adequate terrain clearance, which resulted in an in-flight collision with mountainous terrain.Mar 28, 2003 · N35255 · DestroyedNTSB IAD03LA041Accident · Serious injuriesLimited investigationFinal reportAeronca CH-7A · Cumberland, MDThe pilot/mechanic's failure to ensure the proper installation of the left wing's aft strut-to-spar attachment bolt, which resulted in a loss of control and a subsequent impact with terrain.Mar 27, 2003 · N83519 · Substantial damageNTSB ATL03LA072Accident · No injuriesLimited investigationFinal reportRotorway 162F · Greensboro, NCThe pilot's inadequate preflight planning of fuel required for flight which resulted in fuel exhaustion, and a complete loss of engine power followed by a forced landing, and a dynamic rollover during the autorotative touchdown.Mar 27, 2003 · N92AL · Substantial damageNTSB ATL03FA068Accident · 2 fatalField investigationFinal reportRockwell 690B · Homerville, GAAn in-flight encounter with unforecasted severe turbulence in cruise flight resulting in the design limits of the airplane being exceeded due to an overload failure of the airframe, and collision with a swampy area.Mar 27, 2003 · N53LG · DestroyedNTSB FTW03FA117Accident · No injuriesField investigationFinal reportBell 407 · Houma, LAThe loss of tail rotor drive and anti-torque control resulting from the fracture and separation of the #5 tail rotor drive segment due to the overtemperature and subsequent failure of the #5 hangar bearing.Mar 24, 2003 · N501PH · Substantial damageNTSB DEN03LA055Accident · No injuriesLimited investigationFinal reportMohr Starduster Too · Espanola, NMthe pilot's improper inflight planning in that he failed to consult the airplane flight manual, his use of incorrect fuel consumption figures, and fuel exhaustion. Contributing factors were the loss of the en route chart, the unavailability of a nav/comm…Mar 23, 2003 · N3696 · Substantial damageNTSB MIA03LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Potts Camp, MSThe pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.Mar 21, 2003 · N89811 · Substantial damageNTSB CHI03IA096Incident · Minor injuriesIncident investigationFinal reportCessna 208B · Saginaw, MIFailure of the engine bleed air pressure regulator. A contributing factor was the anti-chaffing tape on the air supply line.Mar 19, 2003 · N1114N · Minor damageNTSB ANC03LA032Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Chickaloon, AKThe improper installation of an engine fuel line fitting by contracted maintenance personnel resulting in an in-flight engine fire. Contributing factors in the accident were an inadequate annual inspection by company maintenance personnel, and the lack of…Mar 19, 2003 · N903AK · Substantial damageNTSB DEN03LA051Accident · Minor injuriesLimited investigationFinal reportPanzl PAN · Vernal, UTthe pilot's inadequate preflight preparation and his lack of familiarity with the airplane, which subsequently resulted in fuel starvation to the engine. Contributing factors were unfavorable wind conditions and the downdraft weather condition.Mar 18, 2003 · N11ZL · Substantial damageNTSB CHI03FA086Accident · 3 fatalField investigationFinal reportCessna 172N · Foley, MNThe pilot's continued visual flight into instrument meteorological conditions which led to spatial disorientation and subsequent impact with the ground. Contributing factors was the pilot's lack of instrument rating, the pilot's disregard of the preflight…Mar 16, 2003 · N5315D · DestroyedNTSB SEA03FA045Accident · 3 fatalField investigationFinal reportCessna 501 · Carey, IDPilot incapacitation for unknown reasons.Mar 15, 2003 · N70FJ · DestroyedNTSB FTW03LA109Accident · No injuriesLimited investigationFinal reportCessna 150G · Hope, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Mar 15, 2003 · N493RA · Substantial damageNTSB FTW03FA111Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Prattsville, ARThe pilot's execution of VFR flight into IMC and his failure to maintain obstacle clearance. Fog conditions and the pilot's lack of an instrument rating are contributing factors.Mar 15, 2003 · N91594 · DestroyedNTSB FTW03LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bonham, TXThe loss of engine power due to fuel starvation as result of the unapproved fuel selector valve handle installed on the aircraft by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.Mar 14, 2003 · N5264L · Substantial damageNTSB DEN03LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Belen, NMthe pilot's improper preflight/in-flight decision making which resulted in the loss of engine power due to fuel starvation. Contributing factors include, the partial fuel selector valve failure, the pilot's intentional operation with known deficiencies in…Mar 14, 2003 · N6960P · Substantial damageNTSB ATL03FA061Accident · 3 fatalField investigationFinal reportCessna 177 · Old Fort, NCThe pilot's decision to continue VFR flight into IMC and his failure to maintain terrain clearance which resulted in an in-flight collision with mountainous terrain.Mar 14, 2003 · N3275T · DestroyedNTSB NYC03IA066Incident · No injuriesIncident investigationFinal reportDornier 328-300 · Wellman, OHAn in-flight encounter with lightning.Mar 13, 2003 · N419FJ · Minor damageNTSB DEN03LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Delta, COthe loss of engine power due to company maintenance personnel's inadequate major engine overhaul (an oil pressure fitting in the engine accessory drive case had not been capped). Contributing factors were the loss of engine oil, and lack of suitable terrain…Mar 13, 2003 · N16438 · Substantial damageNTSB CHI03FA080Accident · 2 fatalField investigationFinal reportMooney M20J · Tower, MIThe pilot's failure to maintain aircraft control during cruise flight. A factor to the accident was the clouds and night conditions.Mar 10, 2003 · N201ZM · DestroyedNTSB LAX03LA110Accident · No injuriesLimited investigationFinal reportKolb Firestar · San Diego, CApropeller delamination due to the pilot's failure to properly secure the rear seat shoulder harness prior to flight. A contributing factor was the soft ground in which the airplane landed.Mar 8, 2003 · N670JW · Substantial damageNTSB ATL03LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Camden, SCThe pilot's inadequate preflight planning which resulted in fuel exhaustion, subsequent loss of engine power and an in-flight collision with terrain.Mar 8, 2003 · N3287L · Substantial damageNTSB LAX03FA108Accident · Minor injuriesField investigationFinal reportStinson 108-1 · Eloy, AZa loss of engine power caused by the fatigue failure of the number 4 cylinder exhaust valve.Mar 7, 2003 · N8344K · Substantial damage