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 LAX00FA130Accident · 1 fatalField investigationFinal reportBell 212 · Snelling, CAthe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.Mar 19, 2000 · N415B · DestroyedNTSB CHI00FA090Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Dighton, KSthe inadvertent stall. Factors relating to this accident were the pilot's inadvertent flight into known adverse weather conditions, the icing conditions, and improper in-flight planning by the pilot.Mar 18, 2000 · N4494X · DestroyedNTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.Mar 17, 2000 · N5304V · Substantial damageNTSB LAX00GA114Accident · Minor injuriesFinal reportBell OH-58C · Compton, CAAn undetermined electrical system voltage surge.Mar 15, 2000 · N911JN · DestroyedNTSB FTW00LA096Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Rayville, LAThe loss of engine power for an undetermined reason, which resulted in a forced landing. A factor was the dark night light condition.Mar 14, 2000 · N2832W · Substantial damageNTSB FTW00LA097Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Gillett, ARThe cracked #8 cylinder resulting in failure of the cylinder. A factor was the plowed/furrowed terrain.Mar 13, 2000 · N9785 · Substantial damageNTSB FTW00LA092Accident · No injuriesLimited investigationFinal reportCessna 150K · Davis, OKFuel exhaustion due to the student pilot becoming lost/disoriented. A factor was the lack of suitable terrain for the forced landing.Mar 11, 2000 · N8435M · Substantial damageNTSB MIA00LA108Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Athens, GAThe flight attendant's failure to seat and belt herself during an inflight encounter with turbulence in clouds resulting in her losing foothold and falling against a passenger seat, sustaining a fractured ankle.Mar 10, 2000 · N636AS · No damageNTSB LAX00FA123Accident · Serious injuriesField investigationFinal reportBoeing 369D · Rough And Ready, CAa loss of engine power due to oil starvation. The oil starvation was due to the seizure and failure of the turbine element oil pump shaft, which was caused by debris from a failed bearing seizing the pump. A factor in the accident was the lack of a suitable…Mar 10, 2000 · N8351F · Substantial damageNTSB ANC00LA035Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Delta Junction, AKThe disintegration of the number two piston. A factor in this accident was the subsequent metal fouling of the spark plugs, which resulted in total loss of engine power.Mar 10, 2000 · N75703 · Substantial damageNTSB NYC00LA091Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Pawling, NYLoss of engine power for undetermined reasons.Mar 7, 2000 · N474HH · Substantial damageNTSB NYC00LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Conesus, NYThe contamination of the aircraft's fuel. Contributing factors were the pilot's failure to maintain adequate altitude and his diversion of attention during the base turn, dark night conditions, and the tree.Mar 7, 2000 · N9040D · DestroyedNTSB LAX00LA116Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Wasco, CAThe pilot's failure to use carburetor heat, which resulted in a loss of engine power. Factors included the ambient carburetor icing conditions and the lack of suitable terrain for the forced landing.Mar 7, 2000 · N1354X · Substantial damageNTSB LAX00FA122Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cima, CAIn-flight collision with terrain for undetermined reasons.Mar 7, 2000 · N7586H · DestroyedNTSB ATL00LA037Accident · Minor injuriesLimited investigationFinal reportTitan Tornado · Springfield, TNThe loss of engine power for undetermined reasons, and the unqualified person attempted to fly the airplane.Mar 7, 2000 · NONE · DestroyedNTSB ATL00LA033Accident · Serious injuriesLimited investigationFinal reportAero Comp COMP-AIR-6 · Indiantown, FLThe maintenance personnel inadequate inspection of the fuel system that resulted in loss of engine power due to fuel filter contamination.Mar 5, 2000 · N61520 · Substantial damageNTSB ANC00LA033Accident · No injuriesLimited investigationFinal reportCessna 208B · Holy Cross, AKAn in-flight separation of a main landing gear tire mud flap, and subsequent impact with the horizontal stabilizer.Mar 4, 2000 · N407GV · Substantial damageNTSB LAX00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Coalinga, CAThe failure of the landing gear for undetermined reasons to go into the locked position after the pilot conducted a manual and emergency gear extension. A factor in the accident was the undetermined failure of the electrical system.Mar 2, 2000 · N8170S · Substantial damageNTSB DEN00LA055Accident · No injuriesLimited investigationFinal reportCessna P210N · Gillette, WYThe pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.Mar 2, 2000 · N6489W · Substantial damageNTSB CHI00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Macomb, ILthe inadequate maintenance inspection prior to the ferry flight by the pilot/mechanic rated passenger who endorsed the airplane as airworthy, the shift in the number two main bearing left half, and the fractured crankshaft. A factor was the rough/uneven…Mar 2, 2000 · N9552T · Substantial damageNTSB ATL00LA030Accident · Minor injuriesLimited investigationFinal reportBurak Stanley A XF4 · Brooksville, FLThe owner/builder's failure to build the airplane within the design stress limits of the drive shaft assembly, that resulted in the failure of the Flex Coupling Retention Bolts.Feb 29, 2000 · N9VY · Substantial damageNTSB NYC00LA085Accident · Serious injuriesLimited investigationFinal reportBoeing 747-236 · Providence, RIMaintenance personnel's failure to reconnect the pitot connections to the elevator feel computer which resulted in an elevator control surface deflection which was outside of the normal autopilot elevator authority. The uncommanded autopilot input to the…Feb 28, 2000 · GBDXL · No damageNTSB IAD00FA024Accident · 1 fatalField investigationFinal reportCessna 337 · Prnce Frederick, MDwas the pilot's failure to maintain control of the airplane after a loss of engine power on one engine. Factors in the accident were the pilot/owner's failure to follow the published emergency procedure, his inadequate fuel management, and his intentional…Feb 28, 2000 · N53HS · DestroyedNTSB LAX00LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · San Bernardino, CAthe total failure of the engine number 1 cylinder exhaust valve.Feb 27, 2000 · N99590 · Substantial damageNTSB CHI00LA079Accident · Serious injuriesLimited investigationFinal reportBeech BE-35V · Bloomington, INthe improper major overhaul of the engine by company maintenance personnel. The tree was a contributing factor.Feb 27, 2000 · N6FN · DestroyedNTSB DEN00FA053Accident · 1 fatalField investigationFinal reportCessna 182E · El Prado, NMThe pilot's improper preflight planning/preparation in that he initiated flight into known adverse weather, and continued VFR flight into IMC to the point where remedial action was not possible. Factors were the weather conditions that included snow, low…Feb 25, 2000 · N2988Y · DestroyedNTSB MIA00LA094Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Clearwater, FLA total loss of engine power due to fuel starvation for und etermined reasons. This resulted in a forced landing to none suitable terrain, and a subsequent in-flight collision with trees and terrain.Feb 24, 2000 · N64WP · Substantial damageNTSB LAX00LA108Accident · No injuriesLimited investigationFinal reportBeech 35 · Desert Center, CAThe pilot's inadequate fuel management, his inaccurate fuel consumption calculations, and his improper use of the fuel selector.Feb 24, 2000 · N5127C · Substantial damageNTSB LAX00IA106Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Fresno, CAMoisture contamination of the elevator trim actuator units resulting in their failure to operate at below freezing temperaturesFeb 21, 2000 · N566SW · No damageNTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…Feb 18, 2000 · N50348 · Substantial damageNTSB LAX00LA105Accident · Minor injuriesLimited investigationFinal reportAyres · Elko, NVthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the ensuing forced landing.Feb 18, 2000 · N4011Y · Substantial damageNTSB LAX00GA102Accident · No injuriesFinal reportCessna T210M · Elfrida, AZThe company mechanic's failure to correctly install one or more of the crankshaft counterweight pin retaining plate snap rings, specifically ensuring that the snap rings were fully seated in their grooves. This led to the complete separation of the No. 2…Feb 16, 2000 · N761KC · Substantial damageNTSB CHI00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Amery, WIthe pilots failure to maintain directional control. Factors to the accident were the icing conditions, the snow and ice covered runway and the snowbank.Feb 15, 2000 · N106RS · Substantial damageNTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.Feb 14, 2000 · N875JC · DestroyedNTSB LAX00LA103Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)An unknown mechanical malfunction that resulted in a precautionary landing at sea and the subsequent sinking of the helicopter by an ocean swell.Feb 14, 2000 · N717ST · DestroyedNTSB LAX00LA098Accident · Serious injuriesLimited investigationFinal reportFokker FK-28-4000 · Red Bluff, CAthe failure of the passenger to fasten his seat belt without the necessity of being instructed by the flight attendant.Feb 14, 2000 · N493US · No damageNTSB LAX00FA099Accident · 2 fatalField investigationFinal reportCessna 182L · Coulterville, CAThe pilot's attempted flight into known adverse weather after receiving hazardous weather advisories, which resulted in inadvertent flight into instrument meteorological conditions while attempting to maintain VFR conditions on top. The subsequent…Feb 14, 2000 · N3324R · DestroyedNTSB MIA00FA090Accident · 1 fatalField investigationFinal reportBeech 35-P35 · Dayton, TNthe non-instrumented rated pilot elected to takeoff into known adverse weather conditions, which resulted in impact with rising terrain. Factors in this accident were, clouds and low ceilings.Feb 13, 2000 · N9796Y · DestroyedNTSB IAD00LA021Accident · 2 fatalLimited investigationFinal reportWood Seawind 3000 · Cumberland Gap, VAThe pilot's continued flight from visual flight rules into instrument meteorological conditions.Feb 11, 2000 · N94WB · Substantial damageNTSB CHI00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Alma, MIthe pilot's inadequate fuel consumption calculation. Factors were the rough terrain, the fence and the exhaustion of the fuel supply.Feb 8, 2000 · N4276E · Substantial damageNTSB LAX00FA090Accident · 1 fatalField investigationFinal reportCessna 150J · Redwood City, CAThe pilot's inadequate weather evaluation and continued visual flight into instrument meteorological conditions. Factors were the pilot's improper remedial action and his self-induced pressure.Feb 7, 2000 · N63YZ · DestroyedNTSB MIA00GA083Accident · Serious injuriesFinal reportRockwell OV-10D · Larandia, ColombiaA loss of power in the right engine due to undetermined reasons and the pilot's failure to maintain control of the airplane. Factors in this accident were; the pilot did not perform a weight and balance calculation, (airplane overweight at takeoff); the…Feb 6, 2000 · N474AW · DestroyedNTSB LAX00LA091Accident · Serious injuriesLimited investigationFinal reportIzatt Mitchell U2 · Jean, NVThe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall and spin.Feb 5, 2000 · N3249Z · Substantial damageNTSB ANC00FA024Accident · 6 fatalField investigationFinal reportCessna U206G · Iliamna, AKThe pilot's attempted flight into adverse weather, and his failure to maintain altitude/clearance above the snow-covered tundra. Factors associated with the accident were snow, rain, and whiteout conditions.Feb 5, 2000 · N756HG · DestroyedNTSB NYC00LA097Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Boston, MAIn flight encounter with turbulence.Feb 3, 2000 · N397US · No damageNTSB ANC00LA023Accident · No injuriesLimited investigationFinal reportStirling AIR CAM · Fairbanks, AKThe pilot's improper compensation for wind conditions during the single-engine landing. Factors associated with this accident were the pilot's intentional shut down of the left engine, the right crosswind, the icy runway, and the snow berms on the edge of the…Feb 2, 2000 · N6381V · Substantial damageNTSB DCA00MA023Accident · 88 fatalClass 1 · MajorFinal reportDouglas MD-83 · Port Hueneme, CAA loss of airplane pitch control resulting from the in-flight failure of the horizontal stabilizer trim system jackscrew assembly's acme nut threads. The thread failure was caused by excessive wear resulting from Alaska Airlines' insufficient lubrication of…Feb 1, 2000 · N963AS · DestroyedNTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…Jan 30, 2000 · N25573 · Substantial damageNTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.Jan 29, 2000 · N94999 · Substantial damageNTSB LAX00LA081Accident · No injuriesLimited investigationFinal reportCessna 150F · Windsor, CAThe pilot's inadequate preflight planning in that he did not perform a fuel calculation, and his failure to verify the fuel quantity on board the airplane, which resulted in fuel exhaustion and subsequent collision with the ground.Jan 29, 2000 · N8281F · Substantial damage