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 ANC00LA004Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Soldotna, AKAn in-flight collision with a bird.Oct 11, 1999 · N74923 · Substantial damageNTSB FTW00LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150G · El Reno, OKThe total loss of engine power resulting from a fatigue failure of the intake rocker arm for the #4 cylinder. A factor was the soft terrain encountered during the forced landing.Oct 9, 1999 · N3603J · Substantial damageNTSB CHI00FA006Accident · Serious injuriesField investigationFinal reportDassault DA-900B · Holland, MIThe copilot's improper use of the autopilot system while leveling the flight from descent, resulting in an inadvertent pilot-induced pitch oscillation of the airplane. A factor was the flight attendant not wearing a seat belt at the time of the occurrence.Oct 9, 1999 · N523AC · Minor damageNTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.Oct 8, 1999 · N56094 · Substantial damageNTSB NYC00LA007Accident · No injuriesLimited investigationFinal reportBoeing - Canada DHC-8-102 · Philadelphia, PAAn in flight collision with birds.Oct 7, 1999 · N818EX · Substantial damageNTSB LAX00LA055Accident · No injuriesLimited investigationFinal reportBell 206B · Apache Junction, AZOil starvation and seizure of the engines Nos. 6 and 7 bearings due to a clogged oil jet, which resulted in a total loss of engine power.Oct 7, 1999 · N6624N · Substantial damageNTSB NYC00FA006Accident · 2 fatalField investigationFinal reportRaytheon Corporate Jets BE-200 · Williamstown, MAThe pilot-in-command's failure comply with an air traffic control clearance which resulted in a collision with terrain. A factor in this accident was clouds.Oct 5, 1999 · N208MS · DestroyedNTSB CHI00LA004Accident · 2 fatalLimited investigationFinal reportDraper Rans S-10 · Benton, KSthe pilot inadvertently stalled the airplane. Factors relating to the accident was the undetermined loss of power and the pilot's lack of recent experience in the airplane.Oct 4, 1999 · N7868G · DestroyedNTSB SEA00FA001Accident · Minor injuriesField investigationFinal reportde Havilland DHC-2 Mark 1 · Port Blakely, WAThe pilot-in-command's failure to maintain adequate clearance from trees/terrain. Contributing factors were rising terrain and trees.Oct 1, 1999 · N9766Z · Substantial damageNTSB FTW99LA272Accident · 1 fatalLimited investigationFinal reportCessna 150F · Poteau, OKThe instructor pilot's inadequate in-flight decision making, which resulted in the continued flight with a disabled generator and subsequent total failure of the electrical system. Factors were the installation of the inadequate generator fuse by unknown…Oct 1, 1999 · N8092S · Substantial damageNTSB NYC99LA240Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie 319-131 · Sparta, NJThe airplane's encounter with clear air turbulence.Sep 30, 1999 · N821UA · No damageNTSB FTW99LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Slaton, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. Factors were the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.Sep 30, 1999 · N5399B · Substantial damageNTSB CHI99LA355Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hermosa, SDthe pilot's improper fuel management, improper in-flight decision and the precautionary landing. Factors relating to this accident were the pilot's inadequate preflight planning and the fence post.Sep 30, 1999 · N3889F · Substantial damageNTSB FTW99LA271Accident · No injuriesLimited investigationFinal reportStinson L-5 · Woodward, OKThe in-flight separation of the tip of a wood propeller blade. Contributing factors were the soft terrain and ditch encountered during the precautionary landing.Sep 29, 1999 · N68591 · Substantial damageNTSB CHI99FA356Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clinton, IAthe pilot's continued flight into known adverse weather conditions and not maintaining altitude/clearance. Factors were the low clouds, rain, and dark night conditions.Sep 28, 1999 · N5747U · DestroyedNTSB CHI99LA348Accident · No injuriesLimited investigationFinal reportCessna 172N · Des Moines, IAthe pilot's improper in-flight planning and decisions which led to fuel exhaustion. A factor relating to this accident was the telephone pole.Sep 27, 1999 · N738FA · Substantial damageNTSB SEA99LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Vaughn, WAThe separation of a propeller blade tip due to fatigue, and the improper maintenance procedure.Sep 26, 1999 · N9395J · Substantial damageNTSB NYC99IA239Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Nantucket, MAA fractured turbine wheel.Sep 26, 1999 · N666K · Minor damageNTSB DCA99MA088Accident · 10 fatalMajor investigationFinal reportPiper PA-31-350 · Volcano, HIthe pilot's decision to continue visual flight into instrument meteorological conditions (IMC) in an area of cloud-covered mountainous terrain. Contributing to the accident were the pilot's failure to properly navigate and his disregard for standard operating…Sep 26, 1999 · N411WL · DestroyedNTSB NYC99FA236Accident · 2 fatalField investigationFinal reportPiper PA 22-150 · Goshen, KYA loss of engine power for undetermined reasons which resulted in a forced landing and subsequent collision with terrain. A factor in this accident was the down-sloping terrain.Sep 25, 1999 · N2381P · DestroyedNTSB MIA99LA274Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · St. Augustine, FLThe inadvertent inflight collision with a bird resulting in substantial damage to the right wing outboard leading edge.Sep 25, 1999 · N9123P · Substantial damageNTSB MIA99LA268Accident · No injuriesLimited investigationFinal reportBanting Glasair II · River Ranch, FLA total loss of engine power for undetermined reasons, which resulted in a forced landing to non-suitable terrain.Sep 25, 1999 · N55BP · Substantial damageNTSB LAX99FA317Accident · 2 fatalField investigationFinal reportKaman HH-43F · Phoenix, AZFailure of the horizontal stabilizer left outboard forward attach point because of a previously existing crack that resulted from inadequate maintenance inspection by the operator. A factor was the use of automotive parts.Sep 25, 1999 · N100PL · DestroyedNTSB FTW99FA265Accident · 2 fatalField investigationFinal reportCarter Spacewalker II · Conroe, TXThe in-flight separation of the left wing due to the failure of the wing spars resulting from the builder's improper design change utilizing basswood for the spars instead of the specified spruce.Sep 25, 1999 · N235FC · DestroyedNTSB CHI99LA347Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Henrietta, MOThe engine failure due to mismanagement of the fuel system and aircraft control not maintained by the pilot.Sep 25, 1999 · N3047W · Substantial damageNTSB MIA99LA270Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLthe pilot's failure to ensure that the landing gear was down and locked following loss of electrical power for undetermined reasons, resulting in substantial damage to the airplane when the right main landing gear collapsed upon landing.Sep 24, 1999 · N9536B · Substantial damageNTSB LAX99LA318Accident · No injuriesLimited investigationFinal reportCiernia Glasair III · Snelling, CAThe pilot's inadequate preflight inspection, which failed to ensure that the left fuel filler cap was secure, and his decision to continue flight with a known malfunction in the electric fuel pump. Also causal was the pilot's improper positioning of the fuel…Sep 24, 1999 · N153JC · Substantial damageNTSB ANC99LA151Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Galena, AKThe pilot's failure to refuel, and the resulting fuel exhaustion. A factor was the dark night which hampered location of a nearby closed, and unlit, airstrip.Sep 24, 1999 · N5309R · Substantial damageNTSB MIA99LA271Accident · No injuriesLimited investigationFinal reportCessna 177 · St Petersburg, FLA loose throttle control cable clamp which resulted in a lose of power.Sep 23, 1999 · N3342T · Substantial damageNTSB DEN99LA168Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Tremonton, UTThe pilot's failure to maintain rotor rpm while attempting a precautionary autorotation landing. A factor was the loss of engine power for undetermined reasons.Sep 23, 1999 · N83246 · Substantial damageNTSB LAX99FA315Accident · Serious injuriesField investigationFinal reportBoeing 757-2S7 · Agua Caliente, AZthe systemic failure of the airline's maintenance department to identify and correct the long standing history of intermittent faults, nuisance warnings, and erratic behavior in this airplane's GPWS system. Also causal is the airline's failure to perform the…Sep 20, 1999 · N904AW · No damageNTSB MIA99LA258Accident · 2 fatalLimited investigationFinal reportBeech BE-200 · Atlantic Ocean (Atlantic Ocean)undetermined.Sep 19, 1999 · YV385 · DestroyedNTSB FTW99FA262Accident · 4 fatalField investigationFinal reportBeech A36TC · Franklinton, LAThe pilot's inadvertent stall while attempting to clear trees during a go-around. Factors were the pilot's misjudgment of the airplane's distance and speed during the precautionary landing and the partial loss of engine power due to a perforated piston.Sep 19, 1999 · N206WJ · DestroyedNTSB ATL99FA134Accident · 2 fatalField investigationFinal reportBeech BE-35-J35 · Bartow, FLThe pilot's inadequate fuel management that resulted in the complete loss of engine power.Sep 19, 1999 · N648T · DestroyedNTSB NYC99IA231Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Covington, KYDeteriorated wire insulation and shorting at a short radius bend to the electrical wiring in the right side alternate static port heater, which resulted in electrical arcing and a fire sustained by overlaying thermal acoustic insulation.Sep 18, 1999 · N947DL · Minor damageNTSB LAX99FA316Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · June Lake, CAThe pilot's continued VFR flight into known instrument meteorological conditions, including icing, which resulted in an in-flight collision with mountainous terrain.Sep 18, 1999 · N5673P · DestroyedNTSB DEN99LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Murray, UTA forced landing on unsuitable terrain. Factors were fuel exhaustion and inaccurate preflight planning by the flight instructor.Sep 18, 1999 · N65602 · Substantial damageNTSB LAX99LA323Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Beatty, NVthe failure of the injured passengers to remain seated with their seat belts fastened as directed by the captain.Sep 17, 1999 · N628AW · No damageNTSB ATL99LA130Accident · No injuriesLimited investigationFinal reportCessna 182P · Summerville, GAThe missing throttle linkage bolt from the carburetor due to an improper engine installation by maintenance personnel. Factors were the tailwind present during the landing roll and the trees.Sep 14, 1999 · N6863M · Substantial damageNTSB NYC99FA222Accident · 2 fatalField investigationFinal reportCessna 337C · North Adams, MAthe failure of the pilot of the Cessna 305 to follow the instructions issued, and maintain a low altitude. A factor was the delay in evasive action by the pilot of the Cessna 337 after he was first advised that the Cessna 305 was climbing.Sep 12, 1999 · N973FS · 2 aircraft · DestroyedNTSB MIA99FA252Accident · No injuriesField investigationFinal reportBoeing B737-300 · West Palm Beach, FLThe fatigue fracture and separation of the high pressure turbine forward rotating air seal due to a manufacturing defect in a bolt hole that was not detected by the engine manufacturer due to inadequate and ineffective inspection techniques. Contributing to…Sep 12, 1999 · N17356 · Substantial damageNTSB ANC99LA141Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, snow-covered terrain, and self-induced pressure to continue the search.Sep 11, 1999 · N6099Y · Substantial damageNTSB SEA99LA161Accident · No injuriesLimited investigationFinal reportWild Goose A1 · Keizer, ORA loose fuel line fitting resulted in a loss of engine power. An intentional wheels down landing was a factor.Sep 10, 1999 · N3451 · Substantial damageNTSB ANC99FA139Accident · Serious injuriesField investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's continued flight into instrument meteorological conditions (IMC), and inadequate altitude/clearance. Factors associated with the accident were flat light and whiteout conditions, snow, and snow-covered terrain. An additional factor was the FAA's…Sep 10, 1999 · N6007S · DestroyedNTSB LAX99FA301Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Strathmore, CAThe failure of the pilot to maintain an adequate terrain and obstacle clearance altitude, which resulted in a collision with power transmission wires.Sep 9, 1999 · N1775P · DestroyedNTSB FTW99LA267Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Van Horn, TXA restriction within the auxiliary fuel supply system and the rough terrain during the subsequent precautionary landing resulting on main gear collapse.Sep 9, 1999 · N9044E · Substantial damageNTSB FTW99LA254Accident · No injuriesLimited investigationFinal reportMooney M20D · Edna, TXFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.Sep 9, 1999 · N5586Q · Substantial damageNTSB CHI99LA340Accident · No injuriesLimited investigationFinal reportNavion A · Utica, NEthe failure of the fuel pump and the misjudged touchdown point by the pilot. A factor was the high vegetation.Sep 9, 1999 · N4527K · Substantial damageNTSB CHI99LA333Accident · No injuriesLimited investigationFinal reportCessna 172K · Pickrell, NEthe loose oil dipstick guide tube resulting in loss of oil and the engine failure. The night condition was a contributing factor.Sep 9, 1999 · N84385 · Substantial damageNTSB MIA99LA265Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Naples, FLThe pilot's failure to perform manual gear extension procedures with a suspected unsafe landing gear indication which resulted in a collapse of the main landing gear on landing rollout. A factor in the accident was the pilot's lack of total experience in kind…Sep 8, 1999 · N980AC · Substantial damage