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 ANC02FA029Accident · No injuriesField investigationFinal reportEurocopter AS-350-B2 · Valdez, AKThe pilot's failure to disengage the hydraulic system, and maintain forward airspeed during landing as delineated in the emergency procedures section of the helicopter's operations manual, which resulted in a loss of control while hovering. Factors…Apr 11, 2002 · N917JT · Substantial damageNTSB LAX02LA132Accident · Serious injuriesLimited investigationFinal reportCox Aeros Ltd Skyranger · Gila Bend, AZThe failure of the engine for undetermined reasons.Apr 10, 2002 · UNREG · Substantial damageNTSB ATL02IA079Incident · No injuriesIncident investigationFinal reportRockwell International 500-S · Jackson, ALThe pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, loss of engine power in both engines, and subsequent forced landing in a field.Apr 8, 2002 · N8536 · No damageNTSB CHI02LA100Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Hastings, MNThe engine failure due to oil starvation as a result of the fatigue fracture of the number 6 piston. Additional factors were the unsuitable terrain for landing encountered by the pilot, and the inadequate piston design by the manufacturer.Apr 7, 2002 · N9184F · Substantial damageNTSB ATL02LA075Accident · No injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GACompany maintenance personnel inadequate maintenance inspection that resulted in the in-flight separation of the APU inspection doors.Apr 5, 2002 · N1608 · Substantial damageNTSB MIA02LA078Accident · Serious injuriesLimited investigationFinal reportUltravia Aero Int' Pelican Club PL · Crystal River, FLThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot-in-command misjudging the proper glidepath resulting in the in-flight collision with a tree and subsequent uncontrolled in-flight collision with the ground.Apr 4, 2002 · N60980 · Substantial damageNTSB LAX02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lake Elsinore, CAThe pilot lost awareness of his location and collided with trees. Factors in the accident were the mountainous terrain and night conditions.Apr 4, 2002 · N69000 · Substantial damageNTSB MIA02FA079Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Palm Bay, FLThe in-flight loss of control for undetermined reasons resulting in the in-flight collision with terrain.Apr 2, 2002 · N91FK · DestroyedNTSB IAD02LA039Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Atlantic Ocean (Atlantic Ocean)The airplane's encounter with turbulence, while climbing to an assigned altitude.Apr 2, 2002 · G-BNLS · No damageNTSB MIA02FA075Accident · Serious injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Charlotte, NCThe failure of the aircraft operator to comply with, in a timely manner, on the No. 2 engine, Boeing Alert Service Bulletin MD11-71A086, resulting in the integrated drive generator feeder cable chaffing through a fire warning loop and failure of the fire…Apr 1, 2002 · N809DE · Minor damageNTSB CHI02LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Fulton, INA loss of engine power due to excessive clearance of the connecting rod bearing resulting in engine seizure. A related factor was the muddy field.Mar 31, 2002 · N9060W · Substantial damageNTSB CHI02LA099Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · South St. Paul, MNA loss of engine power due to an electrical short of the P-lead, and loose fuel line connection as a result of improper maintenance.Mar 31, 2002 · N9103Q · Substantial damageNTSB FTW02LA108Accident · No injuriesLimited investigationFinal reportMooney M20F · Grapeland, TXThe loss of engine power due to the #2 connecting rod cap separating from the connecting rod. A contributing factor was the limited forward visibility due to oil on the windscreen.Mar 30, 2002 · N9530M · Substantial damageNTSB LAX02TA118Accident · No injuriesFinal reportBell OH-58A · Chico, CAthe loss of engine power for an undetermined reason. Factors in the accident were the pilot's misjudged flare resulting in a hard landing and the lack of recent experience in emergency procedures by the pilot.Mar 29, 2002 · N487BC · Substantial damageNTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.Mar 29, 2002 · N2966B · Substantial damageNTSB ANC02LA026Accident · No injuriesLimited investigationFinal reportInterstate S-1B1 · Big Lake, AKThe separation of the exhaust system stack from the heat exchanger. A factor associated with the accident was an engine compartment fire.Mar 29, 2002 · N48027 · Substantial damageNTSB NYC02LA078Accident · No injuriesLimited investigationFinal reportCessna 150M · Salisbury Ctr, NYThe pilot's delayed decision to ask for help which led to a power loss due to fuel starvation.Mar 28, 2002 · N3006V · Substantial damageNTSB NYC02IA076Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Jefferson, NYAn in-flight encounter with lightning, which severed two of the four elevator cables.Mar 27, 2002 · N290SK · Minor damageNTSB FTW02LA129Accident · No injuriesLimited investigationFinal reportBeech F35 · Amarillo, TXFlutter due to the improper balance of the ruddervator, which resulted in structural damage to the aft fuselage.Mar 25, 2002 · N4257B · Substantial damageNTSB FTW02LA101Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Lamar, COthe pilot's delay in taking immediate remedial action after the flight encountered icing conditions, which resulted in a collision with terrain. A contributing factor to the accident was the icing condition.Mar 24, 2002 · N9265L · Substantial damageNTSB ANC02FA025Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Manokotak, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent collision with terrain during cruise flight. Factors in the accident were low ceilings, snow, and mountainous snow-covered terrain.Mar 23, 2002 · N1220R · Substantial damageNTSB DCA02MA029Accident · Serious injuriesMajor investigationFinal reportMcDonnell Douglas DC-10-30 · int'l watersThe flight attendant's injuries were a result of her unsecured lap belt and shoulder harness for undetermined reasons, and the oscillations of the airplane, which were caused by turbulence and large control column inputs by the first officer. Contributing to…Mar 22, 2002 · N234NW · Minor damageNTSB LAX02FA114Accident · 1 fatalField investigationFinal reportEurocopter AS-350B · Susanville, CAFailure of the pilot to maintain sufficient altitude/clearance above the water while performing a low altitude flight. Factors relating to the accident were the glassy water condition, and a lack of visual cues concerning perception of altitude.Mar 21, 2002 · N1184H · Substantial damageNTSB DEN02LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172Q · Fruitland, UTthe pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.Mar 16, 2002 · N66076 · DestroyedNTSB LAX02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Clarita, CAThe pilot performed inadequate planning and inaccurate fuel computations, and intiated flight without refueling. This resulted in a forced landing on a road at night due to fuel exhaustion.Mar 15, 2002 · N11487 · Substantial damageNTSB MIA02FA067Accident · 1 fatalField investigationFinal reportPiper PA32R-300 · Broadway, NCThe pilot's inadequate visual lookout and his failure to maintain obstacle clearance.Mar 14, 2002 · N4451X · DestroyedNTSB CHI02LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Christopher, ILThe in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.Mar 14, 2002 · N5111H · Substantial damageNTSB FTW02FA095Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Marianna, ARThe pilot's continued flight into adverse weather conditions and his failure to maintain clearance with terrain while maneuvering. Factors were, the low cloud and mist weather conditions, and the dark night light conditions.Mar 13, 2002 · N84719 · Substantial damageNTSB CHI02LA091Accident · Minor injuriesLimited investigationFinal reportAviat Pitts S-2B · Milwaukee, WIThe loss of engine power for undetermined reasons. A factor in the accident was the telephone pole.Mar 13, 2002 · N29RG · Substantial damageNTSB DEN02LA031Accident · No injuriesLimited investigationFinal reportDoyle Kitfox III · Windsor, COloss of engine power due to restricted fuel flow for reasons undetermined. A contributing factor was the unsuitable terrain on which to make a forced landing.Mar 10, 2002 · N8SD · Substantial damageNTSB SEA02LA051Accident · No injuriesLimited investigationFinal reportBell/Garlick UH-1H · Dayton, WAA loss of power for undetermined reason(s). Contributing factors were the pilot's delayed decision to jettison the empty bucket and the trees impacted during the auto-rotation landing.Mar 8, 2002 · N116DR · Substantial damageNTSB CHI02LA087Accident · No injuriesLimited investigationFinal reportCessna 182H · West Plains, MOThe engine failure due to the fatigue fracture of the crankshaft which resulted from the installation of improper pistons during an STC'd engine conversion by other maintenance personnel. Additional factors included the unsuitable terrain encountered by the…Mar 8, 2002 · N64AE · Substantial damageNTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.Mar 8, 2002 · N5246T · DestroyedNTSB LAX02FA101Accident · 3 fatalField investigationFinal reportCessna 425 · San Jose, CAthe pilot's loss of control and resulting exceedence of the design stress limits of the aircraft, which led to an in-flight structural failure. The pilot's loss of control was due in part to the loss of primary airspeed reference resulting from pitot tube…Mar 6, 2002 · N444JV · DestroyedNTSB CHI02IA085Incident · No injuriesIncident investigationFinal reportBeech BE-55 · Springfield, MOThe inadequate visual lookout by the flightcrew of the other airplane.Mar 4, 2002 · N66X · 2 aircraft · Minor damageNTSB SEA02IA044Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-401 · Boise, IDThe partial failure of one of the number two hydraulic system elevator hydraulic lines, leading to the loss of fluid and pressure in that system during cruise flight. This loss resulted in reliance upon the sole remaining activation system (number one…Mar 2, 2002 · N410QX · No damageNTSB ATL02FA057Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Hamilton, GAThe loss of engine power for undetermined reasons.Feb 28, 2002 · N33584 · Substantial damageNTSB CHI02IA083Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Appleton, WIThe separation of the low pressure turbine module due to coke resulting in the blockage of the oil system.Feb 27, 2002 · N991CA · Minor damageNTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…Feb 25, 2002 · N6420M · Substantial damageNTSB DEN02LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Ferron, UTa loss of engine power due to the ingestion of foreign object(s) into the meshing of the gears, causing a malfunction of the magneto idler gear and failure of maintenance personnel to detect the signs of imminent failure during a mandatory oil filter…Feb 24, 2002 · N47465 · DestroyedNTSB ATL02FA051Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Vero Beach, FLThe flight's encounter with isolated severe to extreme turbulence that resulted in an in-flight breakup of the airplane and subsequent impact with terrain.Feb 23, 2002 · N7345W · DestroyedNTSB FTW02LA083Accident · No injuriesLimited investigationFinal reportNorth American T28C · Fredericksburg, TXthe failure of the pilot to refuel the airplane resulting in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Feb 21, 2002 · N71546 · Substantial damageNTSB NYC02LA065Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Beaumont, TXAn inadvertent encounter with convective induced turbulence, which injured a flight attendant. Factors were the failure of the airline to supply direction to the flight crew to indicate when the flight attendants could begin cabin service, and the convective…Feb 20, 2002 · N24736 · No damageNTSB CHI02LA081Accident · No injuriesLimited investigationFinal reportCessna 172F · Lynxville, WIThe pilots delayed use of carburetor heat during carburetor icing conditions, and the unsuitable terrain encountered for the forced landing. The carburetor icing conditions, the powerline, the brush, and the nose gear collapse were contributing factors.Feb 18, 2002 · N5527R · Substantial damageNTSB NYC02LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newbolds Corner, NJImproper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.Feb 17, 2002 · N56885 · Substantial damageNTSB ATL02FA048Accident · 2 fatalField investigationFinal reportBell 206L-1 · New Smyrna Bch., FLThe pilot continued visual flight into instrument conditions that resulted in the in-flight collision with trees. Factor were the pilot's alcohol impaired condition, and low cloud conditions.Feb 16, 2002 · N23PJ · DestroyedNTSB ATL02LA046Accident · Serious injuriesLimited investigationFinal reportAero Commander 500U · Copperhill, TNThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with trees during emergency landing on unsuitable terrainFeb 12, 2002 · N441WW · Substantial damageNTSB FTW02LA079Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMthe loss of engine power as result of the failure of the dual magneto. A contributing factor was the lack of suitable terrain for the precautionary landing.Feb 8, 2002 · N75616 · Substantial damageNTSB DEN02LA029Accident · Serious injuriesLimited investigationFinal reportGulfstream Aerospace G-IV · Broomfield, COthe flight attendant's failure to fasten his seatbelt when warned of possible turbulence. A contributing factor was the severe turbulence.Feb 8, 2002 · N434QS · No damageNTSB ATL02FA043Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Atlanta, GAThe pilot experienced spatial disorientation that resulted in the loss of control.Feb 6, 2002 · N4105W · Destroyed