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 ATL02LA134Accident · Serious injuriesLimited investigationFinal reportFay Velocity Elite · Theodore, ALThe pilot's inadequate inflight planning for required fuel resulted in fuel exhaustion and the subsequent loss of engine power. A factor was unsuitable terrain.Jun 27, 2002 · N2214W · Substantial damageNTSB DEN02LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucumcari, NMthe pilot's failure to position the fuel selector to the proper tank resulting in fuel starvation and the subsequent loss of engine power. Factors contributing to the accident were the pilot's failure to use the checklist and the lack of suitable terrain for…Jun 26, 2002 · N2443C · Substantial damageNTSB CHI02FA177Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Steward, ILA loss of engine power due to the fatigue failure of several number three cylinder through bolts and case studs, which resulted in the separation of the number three engine cylinder. A factor contributing to the accident was the rough terrain.Jun 26, 2002 · N76SA · Substantial damageNTSB ANC02LA069Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Kake, AKThe in-flight separation of the upper engine cowling from the airplane. A factor contributing to the accident was the soft, sandy terrain of the landing area.Jun 25, 2002 · N2947N · Substantial damageNTSB NYC02LA122Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellington, CTThe pilot's misjudged distance/altitude during an emergency landing, which resulted in an undershoot and subsequent forced landing to a cornfield. A factor was the pilot's inadequate preflight planning, which resulted in fuel starvation.Jun 24, 2002 · N2516G · Substantial damageNTSB ANC02LA058Accident · Serious injuriesLimited investigationFinal reportCessna 150 · South Naknek, AKThe pilot's failure to refuel the airplane resulting in fuel exhaustion in cruise flight, and his inadvertently stalling the airplane during the ensuing emergency landing.Jun 24, 2002 · N3025X · Substantial damageNTSB IAD02LA063Accident · No injuriesLimited investigationFinal reportMurawski Pulsar · Bentleyville, PAFailure of the MAG cylinder rod bearing, which resulted in a loss of engine power. A factor in the damage to the airplane was the terrain condition of the forced landing field.Jun 23, 2002 · N5123B · Substantial damageNTSB FTW02LA187Accident · 1 fatalLimited investigationFinal reportLidster Wittman Tailwind W-8 · Mesquite, TXThe in-flight separation of the outboard portion of the left wing due to the failure of the wing spar resulting from the builder's improper installation of a wing that did not meet the drawing specifications.Jun 23, 2002 · N14VK · DestroyedNTSB FTW02LA190Accident · No injuriesLimited investigationFinal reportBeech BE-300 · Tulsa, OKThe pilot's inadequate preflight of the airplane resulting in the in-flight separation of the left engine inboard access door.Jun 22, 2002 · N224CR · Substantial damageNTSB ATL02LA129Accident · Minor injuriesLimited investigationFinal reportEames Acro Sport · Burlington, NCA total loss of engine power due to fuel starvation. This resulted in a forced landing and subsequent hard landing while maneuvering around trees.Jun 22, 2002 · N16SE · Substantial damageNTSB SEA02LA116Accident · No injuriesLimited investigationFinal reportBeech G35 · Yakima, WAEmpennage flutter which resulted in structural damage during descent for landing. Turbulence was a factor.Jun 21, 2002 · N4647D · Substantial damageNTSB SEA02FA108Accident · 1 fatalField investigationFinal reportGarlick UH-1H · Clark Fork, IDA failure of unknown origin in the tail rotor drive assembly. Factors include mountainous terrain unsuitable for an emergency landing.Jun 21, 2002 · N114DR · Substantial damageNTSB CHI02FA174Accident · 3 fatalField investigationFinal reportEurocopter France AS-350-B2 · Norfolk, NEA loss of tail rotor effectiveness and the pilot's failure to maintain control of the helicopter. Factors associated with the accident were the binding of the tail rotor pitch changed rod, the gusty wind conditions, and the pilot’s lack of total experience in…Jun 21, 2002 · N852HW · Substantial damageNTSB SEA02LA095Accident · No injuriesLimited investigationFinal reportCessna 441 · Medford, ORThe overstress failure, for undetermined reasons, of the right main landing gear pivot pin roll pin, leading to the misalignment of the gear trunnion and the collapse of the right main gear during the landing roll.Jun 19, 2002 · N564AC · Substantial damageNTSB FTW02LA185Accident · Minor injuriesLimited investigationFinal reportQuinn RV-6A · El Paso, TXA loss of engine power for undetermined reasons.Jun 19, 2002 · N799RQ · Substantial damageNTSB ANC02IA093Incident · Serious injuriesIncident investigationFinal reportPiper PA-31-350 · Talkeetna, AKThe passenger's incapacitation during a high altitude flight due to a loss of consciousness as the result of a pre-existing cardiovascular condition. A contributing factor in the incident was the operator's improper use of disposable oxygen masks without a…Jun 18, 2002 · N828KT · No damageNTSB FTW02LA183Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Leslie, ARThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Jun 17, 2002 · N800MD · Substantial damageNTSB CHI02LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Butler, MOThe fuel exhaustion, the inadequate fuel consumption calculations by the pilot, and the inadequate in-flight planning/decision by the pilot. The unsuitable terrain encountered during the forced landing is a contributing factor.Jun 17, 2002 · N5953R · Substantial damageNTSB DEN02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Salt Lake City, UTtotal mechanical loss of engine power for reasons undetermined. Contributing factors were the lack of an annual inspection and the (forced landing in) salt water.Jun 16, 2002 · N7338M · DestroyedNTSB MIA02FA111Accident · 3 fatalField investigationFinal reportPiper PA-46-310P · Osteen, FLthe pilot's inadequate weather evaluation and his failure to maintain control of the airplane after entering an area of thunderstorms resulting in an in-flight separation of the right wing and right horizontal stabilizer and impact with the ground during an…Jun 15, 2002 · N9143B · DestroyedNTSB CHI02LA165Accident · No injuriesLimited investigationFinal reportFirm Kit Fox 4-1200 · Virginia, MNAn in-flight collision with a bird that resulted in severed fuel lines and the subsequent in-flight fire and loss of engine power. A factor in the accident was the soft terrain condition.Jun 15, 2002 · N598HL · DestroyedNTSB MIA02LA110Accident · 1 fatalLimited investigationFinal reportHarrison Pietenpol Air Camper · Bainbridge, GAa loss of power due to the passenger's inadvertent deactivation and restricting the movement of the throttle, which resulted in a forced landing and subsequent impact with trees.Jun 13, 2002 · N7224X · DestroyedNTSB MIA02TA109Accident · No injuriesFinal reportAgusta A119 · Okeechobee, FLthe fracture of one of the tail rotor blades as a result of fatigue cracking in the blade spar, and subsquent impact of the main rotor with the tailboom.Jun 12, 2002 · N911SL · Substantial damageNTSB DEN02LA053Accident · No injuriesLimited investigationFinal reportCessna 172F · Salt Lake City, UTthe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A factor contributing to the accident was the lack of suitable terrain for the forced landing.Jun 12, 2002 · N7873U · Substantial damageNTSB NYC02LA112Accident · No injuriesLimited investigationFinal reportCessna 182RG · Worcester, MAThe failure of the nose wheel actuator o-ring.Jun 11, 2002 · N4652T · Substantial damageNTSB DEN02TA052Accident · No injuriesFinal reportBeech 58P · Grand Junction, COthe pilot's inadvertent flight into adverse weather conditions. A factor contributing to the accident was the terrain-induced turbulence.Jun 10, 2002 · N123Z · Substantial damageNTSB CHI02FA233Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.Jun 9, 2002 · N56136 · Substantial damageNTSB LAX02FA191Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Rio Rico, AZa loss of engine power in the left engine for undetermined reasons, and the failure of the flying pilot to maintain an adequate single engine minimum control airspeed and aircraft control. Also causal was the decision of all three of the pilots to continue…Jun 8, 2002 · N4302P · DestroyedNTSB LAX02FA188Accident · 2 fatalField investigationFinal reportFisher Celebrity · Chandler, AZfailure of the wing spars and the in-flight separation of the aircraft wing due to the builder's inadequate manufacture of this experimental aircraft. Also causal was the current owner/pilot's continued flight with known mechanical discrepancies.Jun 8, 2002 · N8205H · DestroyedNTSB FTW02LA177Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Nederland, COthe pilot's inadvertent in-flight encounter with severe turbulence, which resulted in main rotor-tailboom contact and the separation of the tailrotor drive shaft.Jun 8, 2002 · N999DW · Substantial damageNTSB LAX02FA200Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · Santa Paula, CAthe pilot's attempted VFR flight into instrument conditions and failure to maintain clearance with the terrain.Jun 7, 2002 · N13GT · DestroyedNTSB DEN02FA050Accident · 1 fatalField investigationFinal reportBeech M35 · Briggsdale, COcontrolled descent into terrain for reasons undetermined.Jun 7, 2002 · N9775R · DestroyedNTSB CHI02LA161Accident · No injuriesLimited investigationFinal reportCessna R182 · Harvard, ILThe pilot's failure to verify the extension of the landing gear. Factors were the alternator failure, and the main landing gear down locks not engaged.Jun 7, 2002 · N756TK · Substantial damageNTSB MIA02LA107Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Manteo, NCa total loss of engine power due to the failure of a connecting rod bolt because of fatigue, resulting in damage to the airplane during the subsequent ditching.Jun 6, 2002 · N2594X · Substantial damageNTSB IAD02IA057Incident · No injuriesIncident investigationFinal reportFairchild Dornier DO-328-300 · Cinncinnati, OHThe partial loss of flight displays for undetermined reasons.Jun 6, 2002 · N413FJ · No damageNTSB MIA02FA106Accident · Minor injuriesField investigationFinal reportHelicopters & Exec 162F · Tampa, FLThe pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.Jun 4, 2002 · N268MA · Substantial damageNTSB MIA02FA104Accident · 1 fatalField investigationFinal reportCessna 172S · Lutz, FLThe suicidal act by the pilot resulting in the in-flight collision with trees then the ground. A contributing factor in the accident was the pilot's depression. Findings in the investigation were the pilot's overdose of zolpidem and citalopram before the…Jun 4, 2002 · N942SP · DestroyedNTSB LAX02LA182Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Mountain Ranch, CAthe pilot's inadequate preflight planning/preparation and his in-flight planning/decision resulting in fuel exhaustion and loss of engine power.Jun 4, 2002 · N61569 · Substantial damageNTSB CHI02IA151Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Wichita, KSThe flightcrew's failure to verify the engine instrument indications and powerplant controls while on autopilot with the autothrottles engaged, and their failure to recognize the drop in airspeed which led to an aerodynamic stall associated with the reduction…Jun 4, 2002 · N823NK · No damageNTSB LAX02LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Alhambra, CAthe pilot's miscalculated fuel consumption, failure to verify the fuel supply on board, and his failure to refuel the airplane prior to takeoff, which resulted in fuel exhaustion.Jun 3, 2002 · N6629E · Substantial damageNTSB DCA02MA039Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Subic Bay, PhilippinesThe momentary operation of the airplane outside of the airplane's aerodynamic design stall buffet boundary that resulted from the captain's initiation of a Ground Proximity Warning System (GPWS) escape maneuver. Factor's contributing to the accident were the…Jun 3, 2002 · N588FE · Substantial damageNTSB NYC02LA110Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Fairfield, ILThe first officer's abrupt level off.Jun 2, 2002 · N694DL · No damageNTSB DEN02LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Beaver, UTthe pilot's selection of unsuitable terrain on which to make a forced landing. Contributing factors were mountain waves (wind shear) and crosswind.Jun 1, 2002 · N171M · Substantial damageNTSB ANC02FA042Accident · No injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's selection of a fuel tank that did not contain a usable quantity of fuel. Factors associated with the accident are the dirt berm, meteorological conditions conducive to carburetor icing, and carburetor ice.Jun 1, 2002 · N6969H · Substantial damageNTSB CHI02LA150Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Sparta, ILThe total loss of engine power due to a separated cylinder and the failure of the pilot to perform a precautionary landing at the nearest suitable airport when the engine had a partial loss of engine power. The failure of the aircraft owners to perform an…May 31, 2002 · N5360P · Substantial damageNTSB SEA02FA091Accident · Minor injuriesField investigationFinal reportSikorsky CH-19E · Plains, MTPower loss for undetermined reasons.May 30, 2002 · N94475 · Substantial damageNTSB NYC02FA106Accident · 2 fatalField investigationFinal reportCessna A185F · Pleasant Mount, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.May 30, 2002 · N1577B · DestroyedNTSB LAX02LA181Accident · No injuriesLimited investigationFinal reportCessna 182P · Roosevelt, AZFailure of the pilot to maintain aircraft control during the landing rollout after making a precautionary landing precipitated by an electrical system failure.May 30, 2002 · N79107 · Substantial damageNTSB MIA02FA102Accident · 1 fatalField investigationFinal reportBeech F33A · Conway, SCThe failure of the pilot to request in-flight weather avoidance assistance and his poor in-flight planning/decision for flying into a Level 5 thunderstorm resulting in an in-flight loss of control, uncontrolled descent, and subsequent in-flight collision with…May 29, 2002 · N858KS · DestroyedNTSB IAD02LA053Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Martinsburg, WVInadequate torque of the crankcase through bolts.May 29, 2002 · N45RG · Substantial damage