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 LAX97LA116Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Morristown, AZfailure of the crankshaft due to improper inspection/overhaul procedures.Mar 3, 1997 · N39W · DestroyedNTSB CHI97LA078Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2Q8 · Chicago, ILClear air turbulence.Mar 2, 1997 · N755AT · No damageNTSB CHI97LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · West Chicago, ILfuel starvation due to the pilot's improper fuel tank selection.Mar 2, 1997 · N9420W · Substantial damageNTSB FTW97LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Plaquemine, LAThe pilot's failure to maintain proper altitude and clearance from transmission wires. Factors were, the dark night, low cloud ceiling, and fog.Feb 28, 1997 · N49205 · DestroyedNTSB FTW97FA109Accident · 1 fatalField investigationFinal reportKeating Quickie II · Houston, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. Factors were the pilot's lack of familiarity with the airplane, the dark night, the lack of cockpit lights, and the lack of suitable terrain for the pilot to…Feb 28, 1997 · N89WL · DestroyedNTSB MIA97LA087Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Calhoun, GAThe pilot-in-command's improper fuel management and improper positioning of the fuel selector valve to the empty fuel tank. Factors in the accident were: the PIC's improper in-flight planning and decision, his failure to list an alternate airport, and his…Feb 27, 1997 · N72GL · DestroyedNTSB LAX97LA112Accident · Serious injuriesLimited investigationFinal reportBoeing 767-300 · San Francisco, CAan encounter with unforecasted moderate clear air turbulence, while descending over mountainous terrain.Feb 25, 1997 · N661UA · No damageNTSB ANC97LA029Accident · No injuriesLimited investigationFinal reportCessna 337C · Golovin, AKthe pilot's continued flight into adverse weather conditions, and failure to maintain sufficient distance/altitude from terrain. Low ceiling, flat light condition, and the ice pressure ridge were related factors.Feb 25, 1997 · N2615S · Substantial damageNTSB IAD97LA051Accident · No injuriesLimited investigationFinal reportHughes 369HS · Marion, OHUncovering of the fuel tanks outlet, which resulted in fuel starvation and subsequent loss of engine power. A related factor was the unsuitable terrain.Feb 24, 1997 · N340EM · Substantial damageNTSB CHI97IA074Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Rapid City, SDa missing 'C' clip, which resulted in the master link coming apart, allowing the electric elevator trim chain and cable to become entangled in the elevator trim cables.Feb 24, 1997 · N430AW · No damageNTSB ATL97LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Raleigh, NCa loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.Feb 23, 1997 · N714JY · Substantial damageNTSB SEA97LA061Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Morgan, UTDisconnection of the mixture control wire wound cable sheath. A factor was the abrupt, elevated edge of the highway pavement.Feb 22, 1997 · N77947 · Substantial damageNTSB SEA97LA063Accident · No injuriesLimited investigationFinal reportMaule M-5-180 · Jordan Valley, ORfailure of the pilot to maintain directional control of the aircraft, while landing. Factors relating to the accident included: the pilot's improper inflight decision to attempt a descent through what appeared to be a hole in the clouds, his inadvertent…Feb 21, 1997 · N5652W · Substantial damageNTSB LAX97FA107Accident · Serious injuriesField investigationFinal reportHughes 369D · Milolii, HIfailure of the tail rotor for undetermined reason(s), resulting in tail rotor imbalance, separation of the tail rotor, and an autorotative landing on rough terrain with high vegetation. The lack of suitable terrain for a forced landing was a related factor.Feb 21, 1997 · N505RM · Substantial damageNTSB CHI97IA073Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Romulus, MIa fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…Feb 20, 1997 · N828MA · No damageNTSB CHI97IA072Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-15 · Des Moines, IAthe cross tie relay shorted resulting in a fire in the left main electrical equipment rack.Feb 20, 1997 · N93S · Minor damageNTSB CHI97FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna T210N · Chicago, ILUndetermined.Feb 20, 1997 · N7134J · DestroyedNTSB FTW97LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Rogers, ARthe pilot's improper fuel consumption calculations, which resulted in the loss of engine power, due to fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for a forced landing.Feb 15, 1997 · N1419Y · Substantial damageNTSB LAX97LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · San Pablo Bay, CAtotal loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.Feb 14, 1997 · N3757F · Substantial damageNTSB LAX97LA102Accident · No injuriesLimited investigationFinal reportGreen Cozy III · San Martin, CAA loss of engine power due to fuel contamination. A factor in the accident is the aircraft design, which routes hydraulic lines through the fuel tank.Feb 11, 1997 · N34PC · Substantial damageNTSB MIA97LA083Accident · No injuriesLimited investigationFinal reportCessna 210L · Weston, FLa loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.Feb 10, 1997 · N115WL · Substantial damageNTSB NYC97LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-44-180T · Caldwell, NJThe pilot's incapacitation due to a heart attack.Feb 9, 1997 · N8457H · No damageNTSB MIA97FA082Accident · 2 fatalField investigationFinal reportCessna 402C · St. ThomasThe failure of the pilot to maintain altitude while making a visual approach at night over water in black hole conditions resulting in the aircraft descending and crashing into the sea. Contributing to the accident was the failure of the pilot and operator to…Feb 8, 1997 · N318AB · DestroyedNTSB ATL97LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Gulfport, MSthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.Feb 7, 1997 · N93873 · Substantial damageNTSB ATL97LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Key West, FLA loss of engine power for undetermined reasons, and the abrupt maneuver that resulted in an aerodynamic stall. A factor was the pilot's failure to maintain clearance from the power lines.Feb 6, 1997 · N67544 · Substantial damageNTSB ANC97LA025Accident · 3 fatalLimited investigationFinal reportPiper PA-22 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent failure to maintain control of the airplane. Factors associated with the accident are the pilot's inadequate weather evaluation, his becoming lost/disoriented, and…Feb 1, 1997 · N7235D · DestroyedNTSB ATL97IA035Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAfailure of the Stage 1 High Pressure Turbine due to a fatigue fracture in a disk blade retention lug.Jan 31, 1997 · N611DL · Minor damageNTSB FTW97LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Boswell, OKThe student pilot's improper inflight planning and decision, after becoming lost/disoriented, which resulted in fuel exhaustion, before landing in a suitable landing area. Factors relating to the accident were: the pilot of another aircraft did not accurately…Jan 30, 1997 · N2493A · Substantial damageNTSB ANC97FA024Accident · 1 fatalField investigationFinal reportde Havilland DHC-4A · Sparrevohn, AKloss of the right engine propeller control oil, which led to an overspeed of the right engine and propeller, and necessitated a shut-down of the right engine; and failure of the pilot to maintain adequate altitude/distance from terrain during visual approach…Jan 30, 1997 · N702SC · DestroyedNTSB FTW97FA092Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Mayhill, NMThe pilot's failure to maintain clearance with trees and terrain. Factors were the mountainous terrain, the snow obscuring the visibility, the dark night illumination, and the pilot's fatigue.Jan 28, 1997 · N47SM · DestroyedNTSB CHI97LA060Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-51 · Cape Girardeau, MOclear air turbulence encountered by the flight.Jan 28, 1997 · N414EA · No damageNTSB NYC97FA048Accident · 1 fatalField investigationFinal reportCessna 172F · Conrad, PAVFR flight by the pilot into instrument meteorological conditions (IMC), and spatial disorientation of the pilot, which led to loss of aircraft control, an uncontrolled descent, and subsequent collision with wooded terrain. Factors relating to the accident…Jan 25, 1997 · N8835U · DestroyedNTSB MIA97LA075Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Whiteville, NCThe pilot's intentional operation of the helicopter with known deficiencies in equipment and a false indication of the fuel gauge, resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was inadequate maintenance of…Jan 25, 1997 · N707EX · Substantial damageNTSB FTW97LA088Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Longmont, COFailure of the pilot to refuel the airplane, resulting in fuel exhaustion. Factors were the pilot's reference to similar but different aircraft performance charts, and the operator's failure to provide the pilot with the proper performance charts.Jan 24, 1997 · N76GM · DestroyedNTSB MIA97FA070Accident · 4 fatalField investigationFinal reportBell 206-B3 · Fort Lauderdale, FLThe pilot's incapacitation by carbon monoxide from undetermined sources which led to his diminished ability to see and avoid a radio tower.Jan 23, 1997 · N2047R · DestroyedNTSB LAX97FA093Accident · 1 fatalField investigationFinal reportCessna R172K · Bagdad, AZcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from terrain. Factors relating to the accident were: the high/mountainous terrain and adverse weather conditions.Jan 22, 1997 · N736WZ · DestroyedNTSB FTW97IA084Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Oklahoma City, OKexistence of fumes from the cargo compartment and activation of the cargo smoke detector for undetermined reasons.Jan 22, 1997 · N198FE · No damageNTSB CHI97FA056Accident · 2 fatalField investigationFinal reportCessna 210N · Highland, MIin-flight breakup of the airplane for undetermined reason(s).Jan 21, 1997 · N29WW · DestroyedNTSB MIA97LA068Accident · No injuriesLimited investigationFinal reportStinson 108 · Winter Haven, FLFailure of the pilot to use carburetor heat for descent resulting in engine failure due to carburetor induction icing.Jan 20, 1997 · N97108 · Substantial damageNTSB MIA97LA066Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fort Lauderdale, FLFailure of other maintenance personnel to properly torque a connecting rod bolt and nut for the No. 3 cylinder during engine overhaul.Jan 19, 1997 · N136FR · Substantial damageNTSB NYC97LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thorndale, PAInadequate overhaul of the crankshaft that failed to detect fatigue cracks, which resulted in a total loss of engine power when the crankshaft separated in two.Jan 18, 1997 · N57010 · Substantial damageNTSB MIA97LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Boca Raton, FLImproper overhaul of the left magneto which resulted in a defect in the left magneto rotating magnet to go undetected which caused the magneto to stop rotating and break several teeth from engine crankshaft gears and disconnect the crankshaft drive gear.Jan 17, 1997 · N2816M · Substantial damageNTSB IAD97FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Alton, NHAn exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, and incapacitation of the pilot.Jan 17, 1997 · N8263Y · DestroyedNTSB FTW97LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Steamboat Spgs, COFailure of the flight instructor and the dual student to maintain an adequate visual lookout. Factors were the flight instructor's inadequate supervision of the flight, inadequate altitude in which to clear obstacles, and the dual student's lack of…Jan 17, 1997 · N739QE · DestroyedNTSB ANC97LA022Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Tununak, AKthe pilot's decision to continue VFR flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from rising terrain. Factors associated with the accident were: low ceiling, fog, rising terrain, and the pilot's inadequate…Jan 17, 1997 · N9603M · Substantial damageNTSB MIA97LA062Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Sanibel, FLA partial loss of engine power (rough running engine) for undetermined reason.Jan 14, 1997 · N29986 · Substantial damageNTSB LAX97FA089Accident · 2 fatalField investigationFinal reportBeech F33A · Mt San Jacinto, CAcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude or clearance from mountainous terrain. Factors relating to the accident were: the high/mountainous terrain, and the adverse weather…Jan 13, 1997 · N31706 · DestroyedNTSB CHI97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Franklin, MNThe pilot's inadequate inflight planning and his fuel mismanagement, which resulted in fuel exhaustion and the loss of engine power. A contributing factor with this accident was a frost blocked cockpit windshield.Jan 13, 1997 · N6495P · Substantial damageNTSB SEA97LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Sun River, ORinadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude/clearance above moutainous/wooded terrain. Factors relating to the accident were: darkness, adverse weather conditions, and the proximity…Jan 12, 1997 · N8414B · Substantial damageNTSB LAX97FA086Accident · 2 fatalField investigationFinal reportEnstrom F28A · Saipan Island, Sarkloss of engine power due to fuel exhaustion, resulting from improper planning/decision; and the pilot's abrupt handling of the flight controls, while maneuvering to avoid swimmers, which resulted in main rotor blade contact with the tail boom. A related…Jan 12, 1997 · N9087 · Destroyed