NTSB investigations

35,883 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 WPR16FA041Accident · 5 fatalField investigationFinal reportPiper PA 32RT-300T · Bakersfield, CAThe noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…Dec 19, 2015 · N36402 · DestroyedNTSB ERA16LA076Accident · No injuriesLimited investigationFinal reportPorrata Luis G Rans S 12XL · Guanica, PRThe pilot/owner's failure to maintain the engine in accordance with manufacturer guidance, which resulted in the undetected corrosion of the power takeoff bearing, subsequent bearing failure, and a total loss of engine power.Dec 19, 2015 · N124LP · Substantial damageNTSB ERA16FA074Accident · 2 fatalField investigationFinal reportHinton Paul M RV 4 · Greenville, FLThe pilot's decision to initiate the flight into known adverse weather conditions, in an airplane that was not approved for instrument flight, which resulted in an encounter with instrument meteorological conditions and his subsequent spatial disorientation…Dec 18, 2015 · N77BP · DestroyedNTSB DCA16WA236Accident · No injuriesForeign investigationCessna 182 · Plettenberg, Western Cape Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna 182@ airplane that occurred on December 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…Dec 16, 2015 · ZS-SLS · DestroyedNTSB ERA16LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Brunswick, GAMaintenance personnel's failure to properly torque a No. 4 cylinder hold-down nut during engine overhaul, which resulted in the loosening of the nut and the subsequent failure of the studs and through bolts and separation of the cylinder.Dec 15, 2015 · N8675N · Substantial damageNTSB ERA16WA069Accident · 4 fatalForeign investigationHawker Beech A36TC · Suvorovskaya, RussiaOn December 13, 2015, about 0826 Universal Time Coordinated (UTC), a Beech A36TC, Russian registration RA-2587G, registered to and operated by a private individual, experienced an in-flight loss of control and collided with terrain near Suvorovskaya Village,…Dec 13, 2015 · RA-2587G · DestroyedNTSB ERA16LA066Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Fayetteville, NCMaintenance personnel's application of an unapproved sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in lubrication restriction due to a bearing shift and the subsequent internal failure of the…Dec 12, 2015 · N3241N · Substantial damageNTSB DCA16CA050Accident · Serious injuriesData collectionFinal reportBoeing 777 223 · Buenos Aires, Argentinaan inadvertant encounter with convective turbulence.Dec 12, 2015 · N784AN · No damageNTSB WPR16FA037Accident · 4 fatalField investigationFinal reportBell 407 · McFarland, CAThe pilot's loss of control and collision with terrain while attempting a course reversal after inadvertently entering an area of reduced visibility weather conditions. Contributing to the accident was the pilot's lack of recent experience with night time…Dec 11, 2015 · N408FC · DestroyedNTSB ENG16WA006Incident · No injuriesForeign investigationAirbus A319 · Bogota, ColombiaOn December 11, 2015, an Avianca Airbus A318-111, N593EL, equipped with CFMI CFM56-5 engines, experienced a loss of power from the No. 1 (left) engine. The airplane was operating as Avianca flight AV9398 from Bogota, Colombia to Pasto, Colombia when the…Dec 11, 2015 · N593FL · No damageNTSB DCA16CA030Accident · Serious injuriesData collectionFinal reportAirbus A319 115 · Great Falls, MTan encounter with turbulence during initial descent.Dec 10, 2015 · N3014R · No damageNTSB CEN16WA065Accident · No injuriesForeign investigationEnstrom 280 · Salinas Victoria, MexicoOn December 10, 2015, about 1710 universal coordinated time, an Enstrom 280FX helicopter, XB-GRG, sustained substantial damage on impact with terrain near Salenas Victoria, Mexico. The pilot sustained a serious injury and the two passengers were uninjured.…Dec 10, 2015 · XB-GRG · Substantial damageNTSB WPR16IA044Incident · No injuriesIncident investigationFinal reportCessna LC41-550FG · Seal Beach, CAImproper maintenance performed on the left magneto which led to a loss of engine power. Contributing to the incident was the pilot's failure to check the magnetos in flight in compliance with manufacturers guidance regarding rough running engine. The pilot's…Dec 8, 2015 · N932AC · Minor damageNTSB DCA16WA031Accident · 1 fatalForeign investigationEclipse 500 · Swellendam, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation…Dec 7, 2015 · ZS-DKS · DestroyedNTSB DCA16CA026Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · St Louis, MOan inadvertent encounter with clear air turbulence.Nov 29, 2015 · N467WN · No damageNTSB GAA16CA072Accident · No injuriesData collectionFinal reportSkaggs Ronnie Lynn Rans S6S · Oldtown, MDThe pilot's failure to visually inspect the fuel level during the preflight inspection, which resulted in fuel starvation and a subsequent off-field landing and impacted terrain.Nov 27, 2015 · N531VS · Substantial damageNTSB WPR16LA032Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlisle, WAA total loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge.Nov 24, 2015 · N50713 · Substantial damageNTSB DCA16CA023Accident · Serious injuriesData collectionFinal reportAirbus Industrie A319 112 · Philadelphia, PAan inadvertent encounter with clear air turbulence.Nov 23, 2015 · N725UW · No damageNTSB CEN16WA048Accident · No injuriesForeign investigationBell 407 · Justo Romero, NicaraguaOn November 21, 2015, at 1000 central standard time (cst), a Bell model 407 helicopter, Honduran registration HR-AWI, serial number 53978, sustained substantial damage during a forced landing following a total loss of engine power near Justo Romero,…Nov 21, 2015 · HR-AWI · Substantial damageNTSB CEN16LA047Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Goshen, INThe failure of the Thomas coupling at the interface with the main gear box tail rotor output shaft, which resulted in the helicopter's loss of tail rotor control.Nov 16, 2015 · N88HA · Substantial damageNTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Nov 16, 2015 · N2440R · DestroyedNTSB CEN16WA046Accident · Serious injuriesForeign investigationCessna 172N · Gorliz, SpainOn November 14, 2015, at 1157 UTC, a Cessna 172, Spanish registration EC-HKH, collided with the water in the Astondo Bay off the coast of Gorliz, Spain, following a loss of engine power. The pilot and one passenger received minor injuries and a second…Nov 14, 2015 · EC-HKH · Substantial damageNTSB ERA16LA040Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Jefferson, NCA total loss of engine power for reasons that could not be determined during a postaccident test run of the engine.Nov 13, 2015 · N334CM · Substantial damageNTSB CEN16FA037Accident · 1 fatalField investigationFinal reportCessna 182Q · Richmond, MOThe airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did…Nov 11, 2015 · N96381 · Substantial damageNTSB ERA16WA037Accident · 4 fatalForeign investigationCessna 650 · Guarda-Mor, BrazilOn November 10, 2015, at 2030 Universal Coordinated Time (UTC), a Cessna 650 Citation VII, Brazilian registration PT-WQH, operated by a private owner, was destroyed following an in-flight loss of control and collision with terrain near Guarda-mor…Nov 10, 2015 · PT-WQH · DestroyedNTSB DCA16CA021Accident · Serious injuriesData collectionFinal reportBoeing 787 · Beaumont, TXAn inadvertent encounter with convective turbulence resulting in serious injury to a flight attendant.Nov 7, 2015 · N27958 · No damageNTSB GAA16CA078Accident · No injuriesData collectionFinal reportCessna 525 · Monroeville, ALAn inadvertent collision with a bird during takeoff enroute climb, which resulted in substantial damage to the right wing.Nov 6, 2015 · N525DY · Substantial damageNTSB ERA16FA033Accident · 1 fatalField investigationFinal reportZenith CH701 · Okeechobee, FLAn in-flight structural failure due to a severely corroded wing strut, which resulted in a loss of airplane control.Nov 6, 2015 · N56553 · DestroyedNTSB ERA16FA032Accident · 3 fatalField investigationFinal reportPiper PA 28-180 · Cornelia, GAThe pilot's decision to initiate the flight into known adverse weather conditions, which resulted in his spatial disorientation and loss of airplane control.Nov 5, 2015 · N57WV · DestroyedNTSB ANC16LA005Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Haines, AKA loss of engine power due to fuel exhaustion for reasons that could not be determined based on available evidence and the pilot’s decision to continue the flight after realizing the remaining fuel quantity was near 0.Nov 4, 2015 · N4611U · Substantial damageNTSB CEN16LA026Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · Fayetteville, ARThe fatigue failure of the oil cooler cross fitting, which resulted in engine oil starvation and a total loss of engine power.Nov 3, 2015 · N857SW · Substantial damageNTSB DCA16WA015Accident · 224 fatalForeign investigationAirbus A321 · Sinai Peninsula, EgyptThe Egyptian Ministry of Civil Aviation has notified the NTSB of an accident involving a AIRBUS A321 airplane, with IAE V2533 engines, that occurred on October 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Egyptian's…Oct 31, 2015 · EI-ETJ · DestroyedNTSB ERA16LA030Accident · No injuriesLimited investigationFinal reportHughes 369D · Marion, SCA momentary jam in the tail rotor control system from an undetermined source, resulting in a torsional fracture of the tail rotor control torque tube and a loss of helicopter control.Oct 30, 2015 · N920JP · Substantial damageNTSB ANC16WA002Accident · 1 fatalForeign investigationBell 206B · Asquinth, CanadaOn October 27, 2015, about 2043 central daylight time, a Bell 206B helicopter, C-GIFY, impacted terrain near Asquinth, Saskatchewan, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of Canada is…Oct 28, 2015 · C-GIFYNTSB ERA16LA028Accident · 3 fatalLimited investigationFinal reportSchumacher Lancair Super ES · Pascagoula, MSThe pilot's failure to maintain airplane control after encountering convective shower activity. Contributing to the accident was the pilot's decision to continue flight into an area of known adverse weather.Oct 26, 2015 · N817PR · DestroyedNTSB ERA16LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Key Biscayne, FLThe fatigue failure of the No. 1 cylinder intake valve, which resulted in the partial loss of engine power.Oct 26, 2015 · N171RD · Substantial damageNTSB DCA16CA010Accident · Serious injuriesData collectionFinal reportBoeing 737-924ER · Plevna, KSAn inadvertent encounter with clear air turbulence resulting in a serious injury to a flight attendant.Oct 24, 2015 · N69838 · No damageNTSB ERA16LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Bluemont, VAA total loss of engine power as a result of the separation of the No. 5 connecting rod for reasons that could not be determined based on the available information.Oct 23, 2015 · N43249 · Substantial damageNTSB CEN16WA020Accident · 4 fatalForeign investigationLearjet 31 · La Tinaja, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 31A, XB-GYB, that occurred on October 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…Oct 22, 2015 · XB-GYB · DestroyedNTSB ERA16LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Campobello, SCThe pilot's inadequate preflight inspection of the fuel system, which resulted in a total loss of engine power due to water contamination.Oct 18, 2015 · N6636A · Substantial damageNTSB WPR16FA014Accident · 2 fatalField investigationFinal reportPiper PA 28R-180 · Morongo Valley, CAThe non-instrument rated pilot's improper inflight decision-making to attempt to outclimb clouds along his planned route rather than reverse course, which resulted in his inadvertent entry into instrument meteorological conditions, spatial disorientation, and…Oct 17, 2015 · N4972J · DestroyedNTSB WPR16FA013Accident · 1 fatalField investigationFinal reportAviat A-1C-200 · Swan Valley, IDThe pilot's failure to maintain airspeed while maneuvering in high density altitude conditions over mountainous terrain, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Oct 15, 2015 · N280TB · Substantial damageNTSB ERA16LA016Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado · Mitchells, VAA total loss of engine power due to fatigue cracking and separation of the No. 3 cylinder exhaust valve stem.Oct 15, 2015 · N4070F · Substantial damageNTSB GAA16CA016Accident · No injuriesData collectionFinal reportCentral Missouri State Univ HP 14 · Jackson, NHThe glider pilot's decision to descend into a broken to overcast cloud layer, which resulted in encountering instrument meteorological conditions and the pilot parachuting from the glider. Contributing to the accident was the pilot's lack of planning for an…Oct 14, 2015 · N102MW · Substantial damageNTSB WPR16LA008Accident · No injuriesLimited investigationFinal reportCessna T210K · Boise, IDThe pilot’s improper in-flight fuel management due to distraction and self-induced pressure, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to conduct the descent checklist, which…Oct 13, 2015 · N8273M · Substantial damageNTSB CEN16LA018Accident · No injuriesLimited investigationFinal reportDiamond DA20-C1 · Waskom, TXThe pilot's decision to operate the airplane without the owner’s permission and his lack of preflight planning, which resulted a total loss of engine power due fuel exhaustion.Oct 12, 2015 · N165DC · Substantial damageNTSB WPR16FA007Accident · 2 fatalField investigationFinal reportBeech G35 · South Lake Tahoe, CAThe pilot's inability to maintain airplane control due to an encounter with a downdraft that exceeded the airplane’s climb performance capabilities and resulted in an aerodynamic stall. Contributing to the accident was the pilot’s decision to depart without…Oct 11, 2015 · N4485D · DestroyedNTSB ERA16LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami Beach, FLA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean after the ditching.Oct 11, 2015 · N733VB · Substantial damageNTSB ERA16FA006Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · Erwin, TNThe pilot's decision to fly into a known area of adverse weather, which resulted in the airplane entering a severe thunderstorm and a subsequent loss of control.Oct 9, 2015 · N1058S · DestroyedNTSB DCA16CA008Accident · Serious injuriesData collectionFinal reportBoeing 737 3H4 · Pound Ridge, NYhot water spilled from a cup onto the flight attendant's arm resulting in a 2nd degree burn.Oct 9, 2015 · N383SW · No damage