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 WPR14FA316Accident · 1 fatalField investigationFinal reportMeyer Legacy · Lolo Pass, IDThe fatigue fracture of an engine connecting rod, which resulted in a catastrophic engine failure and a forced landing in unsuitable terrain.Jul 28, 2014 · N29MM · Substantial damageNTSB WPR14LA315Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 C · Susanville, CAThe pilot’s failure to follow the checklist while starting the engine and to lock the engine primer plunger, which resulted in the partial loss of engine power during cruise flight in high density altitude conditions.Jul 27, 2014 · N2013H · Substantial damageNTSB ERA14LA362Accident · 2 fatalLimited investigationFinal reportPiper PA28 · Venice, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the accident was the pilot’s…Jul 27, 2014 · N8826C · Substantial damageNTSB WPR14LA312Accident · Minor injuriesLimited investigationFinal reportRoscher Frederick Thunder Mustang · Spanish Springs, NVA complete loss of engine power during climb for reasons that could not be determined due to the severity of postcrash fire damage to the airplane.Jul 26, 2014 · N695HR · DestroyedNTSB ERA14LA368Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer A/C G-164B · Bonifay, FLA partial blockage of the No. 2 bearing oil nozzle jet by bearing material, which resulted in oil starvation and the subsequent failure of the No. 2 bearing and total loss of engine power.Jul 25, 2014 · N425LS · Substantial damageNTSB DCA14RA129Accident · No injuriesForeign investigationMcdonnell Douglas MD80 - 80 · Gossi, MaliThe Mali Commission d'Enquete Accident et Incident d'Aviation Civile (CEAIAC) has notified the NTSB of an accident involving a McDonald Douglas DC-9-83 that occurred on July 24, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the…Jul 24, 2014 · EC-LTV · DestroyedNTSB CEN14LA417Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Bruno, MNThe total loss of engine power due to an anomaly with the carburetor system that could not be determined during postaccident examination.Jul 18, 2014 · N9034K · Substantial damageNTSB CEN14LA376Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 401B · Ellis, KSThe noninstrument-rated pilot’s inadequate preflight weather planning and subsequent inadvertent encounter with instrument meteorological conditions, which resulted in spatial disorientation and the loss of airplane control. Contributing to the accident was…Jul 18, 2014 · N4223F · Substantial damageNTSB CEN14LA375Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Fairview, KSThe backfire of the engine and its loss of power for reasons that could not be determined based on the available evidence.Jul 18, 2014 · N6743Q · Substantial damageNTSB WPR14IA297Incident · No injuriesIncident investigationFinal reportBeech B100 · Bakersfield, CAThe failure of the 2nd-stage turbine wheel due to an improper repair of the 2nd-stage stator assembly, which the manufacturer does not consider a repairable item. Contributing to the incident was the designated engineering representative's approval of the…Jul 17, 2014 · N6756P · Minor damageNTSB DCA14RA127Accident · 298 fatalForeign investigationBoeing 777 - 206 · Hrabove, UkraineimportJul 17, 2014 · 9M-MRD · DestroyedNTSB CEN14LA373Accident · Serious injuriesLimited investigationFinal reportGarramone Mike A Vixen · Columbus, NMA total loss of engine power during initial climb for reasons that could not be determined because postaccident engine examination did not reveal any preimpact failures or malfunctions that would have precluded normal operation.Jul 17, 2014 · N153PR · Substantial damageNTSB CEN14FA369Accident · 3 fatalField investigationFinal reportAgusta A109E · Newkirk, NMThe pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.Jul 17, 2014 · N507CF · DestroyedNTSB CEN14WA394Accident · No injuriesForeign investigationMD Helicopter 600N · Kungsangen, SwedenOn July 14, 2014, at 1333 coordinated universal time, an MD Helicopters MD600N, SE-JKJ, was substantially damaged following an autorotation near Kungsängen, Stockholm, Sweden. The pilot was not injured. Visual meteorological conditions prevailed for the…Jul 14, 2014 · SE-JKJ · Substantial damageNTSB CEN14LA372Accident · 1 fatalLimited investigationFinal reportJonker Sailplanes JS1-C · Wallis, TXThe pilot’s loss of glider control and its subsequent impact with terrain for reasons that could not be determined due to a lack of available information.Jul 13, 2014 · N60XJ · Substantial damageNTSB CEN14WA363Accident · 3 fatalForeign investigationPiper PA 28R-201T · Urtaca, FranceJul 12, 2014 · N717ND · DestroyedNTSB ERA14LA344Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Melbourne, FLA total loss of engine power during cruise flight for reasons that could not be determined based on the available information.Jul 10, 2014 · N128LS · Substantial damageNTSB ERA14LA336Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Titusville, FLThe pilot's failure to secure the fuel strainer drain during the preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.Jul 10, 2014 · N6222Q · Substantial damageNTSB CEN14LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Mt. Vernon, TXThe pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.Jul 10, 2014 · N9469N · Substantial damageNTSB ANC14LA052Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Palmer, AKThe pilot’s failure to ensure adequate fuel was onboard to complete the flight, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the improperly calibrated fuel quantity indication system.Jul 9, 2014 · N68593 · Substantial damageNTSB WPR14FA283Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Landmark, IDThe failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.Jul 7, 2014 · N162CG · 2 aircraft · Substantial damageNTSB ERA14LA332Accident · Minor injuriesLimited investigationFinal reportAeronca 7CCM · Prentiss, MSA total loss of engine power for reasons that could not be determined because postaccident engine examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Jul 5, 2014 · N82442 · Substantial damageNTSB CEN14LA351Accident · No injuriesLimited investigationFinal reportCessna 152 · Denton, TXThe in-flight failure of the right wing’s rear spar.Jul 5, 2014 · N49785 · Substantial damageNTSB CEN14FA328Accident · 3 fatalField investigationFinal reportPiper PA 28-235 · Georgetown, COThe pilot’s inability to maintain a climb while maneuvering the airplane in high-density altitude conditions that degraded the airplane’s climb performance and his exceedance of the airplane’s critical angle-of-attack, which led to an aerodynamic stall and…Jun 30, 2014 · N8814W · DestroyedNTSB WPR14LA272Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350B2 · Dietrich, IDThe pilot’s sudden incapacitation from a previously undiagnosed medical condition while in cruise flight, which resulted in his inability to maintain helicopter control.Jun 29, 2014 · N350CR · Substantial damageNTSB ERA14RA318Accident · 4 fatalClass 5 · ForeignRobinson R66 · Krasnodar Krai, RussiaOn June 28, 2014, at 1518 Coordinated Universal Time (UTC), a Robinson R66, Russian registration RA-15880, impacted terrain, in Krasnodar Krai, Russia. The pilot and three passengers were fatally injured. The investigation is under the jurisdiction of the…Jun 28, 2014 · RA-15880 · Substantial damageNTSB DCA14WA176Accident · Serious injuriesForeign investigationBoeing Boeing 737-8AS · Tarragona, SpainThe CIAIAC of Spain has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on June 23, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC's investigation under the provisions of ICAO Annex 13 as…Jun 23, 2014 · EI-ENB · No damageNTSB CEN14LA312Accident · No injuriesLimited investigationFinal reportAirbus Helicopters AS-350B2 · Texarkana, TXThe failure of the two fuel control unit drive bearings for reasons that could not be determined based on the available evidence, which resulted in an uncommanded engine acceleration and subsequent overspeed condition. Contributing to the accident was the…Jun 23, 2014 · N407EM · Substantial damageNTSB WPR14CA400Accident · No injuriesData collectionFinal reportMazurek Keith P Zodiac 601XL · Hurricane, UTLoss of engine power due to fuel exhaustion. Contributing to the accident was an incorrectly calibrated fuel totalizer.Jun 22, 2014 · N599KM · Substantial damageNTSB WPR14CA276Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Moses Lake, WAThe airplane impacted a bird during low level flight.Jun 22, 2014 · N2914Q · Substantial damageNTSB CEN14LA309Accident · No injuriesLimited investigationFinal reportSchumacher Challenger II · St. Joesph, ILThe total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…Jun 21, 2014 · N441MS · Substantial damageNTSB CEN14FA306Accident · 2 fatalField investigationFinal reportBrumwell RV-6 · Sauk Rapids, MNThe pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.Jun 21, 2014 · N135BB · DestroyedNTSB ERA14WA304Accident · 3 fatalForeign investigationCessna U206E · Cerro Militar, Municipio de Calima, ColombiaJun 19, 2014 · N4258 · Substantial damageNTSB WPR14FA252Accident · 1 fatalField investigationFinal reportCessna 175 · Moab, UTThe pilot’s decision to approach rising mountainous terrain at too low an altitude to clear it and his subsequent attempt to climb, which exceeded the airplane’s critical angle-of-attack and resulted in a stall/spin.Jun 18, 2014 · N7043M · DestroyedNTSB CEN14FA300Accident · 3 fatalField investigationFinal reportPiper PA 46-310P · Lehman, TXThe pilot's improper decision to enter an area of known adverse weather, which resulted in the loss of airplane control. Contributing to the accident was the air traffic controller's failure to provide critical weather information to the pilot to help him…Jun 18, 2014 · N2428Q · Substantial damageNTSB WPR14LA251Accident · No injuriesLimited investigationFinal reportAirbus AS 350 BA FX1 · Wailuku, HIThe failure of the engine’s pneumatic fuel control line fitting, resulting in a loss of engine power. Contributing to the failure was the repeated loosening and re-torqueing of the fitting during required maintenance and inspection.Jun 17, 2014 · N6094H · Substantial damageNTSB DCA14CA124Accident · Serious injuriesData collectionFinal reportBoeing 767 424ER · Newark, NJA hot liquid splashed from a meal box onto the flight attendant's hand, resulting in a 2nd degree burn.Jun 17, 2014 · N77066 · No damageNTSB DCA14CA120Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Dallas, TXA buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking handle was raised, which resulted in 2nd and 3rd degree burns.Jun 17, 2014 · N968WN · No damageNTSB CEN14LA293Accident · No injuriesLimited investigationFinal reportKnauf RV-7 · Rockwall, TXThe pilot's failure to verify the airplane's actual fuel quantity before departure, which resulted in a total loss of engine power due to fuel exhaustion and the subsequent forced landing.Jun 16, 2014 · N707HK · Substantial damageNTSB ERA14CA310Accident · No injuriesData collectionFinal reportJackson Fred M Clipper · Altamont, NYThe pilot's failure to apply carburetor heat prior to descending in atmospheric conditions conducive to serious icing at all power settings, which resulted in a total loss of engine power.Jun 14, 2014 · N2754A · Substantial damageNTSB CEN14WA294Accident · No injuriesForeign investigationPiper J3C 65 · Rolleville, FranceJun 11, 2014 · N61903 · Substantial damageNTSB ERA14WA287Accident · 3 fatalForeign investigationCessna 172N · Premana Lecco, ItalyJun 9, 2014 · I-SIPI · DestroyedNTSB ANC14LA040Accident · No injuriesLimited investigationFinal reportCessna U206C · Chitina, AKThe failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue, which resulted in a total loss of engine power during cruise flight.Jun 9, 2014 · N29137 · Substantial damageNTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…Jun 8, 2014 · N504MP · Substantial damageNTSB WPR14LA237Accident · No injuriesLimited investigationFinal reportCraig W Sherman Super Glasair TT · Madera, CAThe loosening of a B-nut in the fuel system which resulted in a rapid, undetected fuel leak and subsequent fuel exhaustion.Jun 8, 2014 · N400MC · Substantial damageNTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…Jun 7, 2014 · N86NW · Substantial damageNTSB ANC14LA038Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Talkeetna, AKMaintenance personnel’s failure to perform required fuel system tests to ensure that the airplane met its original type certification basis after modifying the fuel system and the Federal Aviation Administration’s improper approval of the fuel tank…Jun 6, 2014 · N1301H · Substantial damageNTSB WPR14CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…Jun 4, 2014 · N223G · Substantial damageNTSB CEN14LA276Accident · No injuriesLimited investigationFinal reportCessna 172N · Padre Island, TXThe loss of engine power for reasons that could not be determined based on the available evidence.Jun 3, 2014 · N734BY · Substantial damageNTSB DCA14WA103Incident · No injuriesForeign investigationAirbus A300 · Mexico City, MexicoThe Mexican Directorate General of Civil Aviation (DGAC) has notified the NTSB of an incident involving an Airbus A300 operated by United Parcel Service (UPS), that occurred on June 1, 2014. The NTSB has appointed a U.S. Accredited Representative to assist…Jun 1, 2014 · N137UP · No damage