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 ANC96LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Nome, AKthe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain adequate altitude/clearance from terrain. Low ceilings and snow covered terrain were factors in the accident.Mar 2, 1996 · N8374T · Substantial damageNTSB MIA96LA088Accident · No injuriesLimited investigationFinal reportBell 206L4 · Chiefland, FLImproper cyclic and collective input by the pilot-in-command resulting in the hard landing during the autorotative landing. Contributing to the accident was the total loss of engine power due to undetermined reasons.Mar 1, 1996 · N6248X · Substantial damageNTSB LAX96FA121Accident · 3 fatalField investigationFinal reportCessna 172D · Julian, CAthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inadvertent stall/spin. The pilot's inadequate preflight/preparation, low clouds, fog, and mountain obscuration were factors in the accident.Feb 26, 1996 · N2598U · DestroyedNTSB FTW96FA130Accident · 4 fatalField investigationFinal reportCessna 182R · Proctor, ARfailure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).Feb 24, 1996 · N9303E · 2 aircraft · DestroyedNTSB CHI96LA096Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Bourbon, INWater contamination in the fuel, and an inadequate preflight by the pilot. Factors relating to the accident were: soft terrain in the emergency landing area, and an improper soft field landing procedure used by the pilot.Feb 24, 1996 · N6939B · Substantial damageNTSB IAD96LA046Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Hazard, KYfailure of the engine crankshaft, which resulted in loss of engine power, a forced landing, and subsequent damage to the airplane. A factor relating to the accident was: lack of suitable terrain for a forced landing.Feb 23, 1996 · N90AD · Substantial damageNTSB FTW96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Austin, TXthe partial loss of engine power due to the failure of the #3 connecting rod. A factor was the lack of suitable terrain for the forced landing.Feb 23, 1996 · N6601D · Substantial damageNTSB MIA96IA084Incident · No injuriesIncident investigationFinal reportBoeing 707-323C · Miami, FLfailure of the flight engineer to follow the appropriate emergency procedure to manually extend the nose landing gear. Factors relating to the incident were: fatigue failure of the utility hydraulic system relief valve, which resulted in an inoperative normal…Feb 22, 1996 · N751MA · Minor damageNTSB LAX96FA120Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Elk Grove, CAthe pilot's failure to see and avoid the obstruction.Feb 22, 1996 · N75772 · DestroyedNTSB FTW96LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Andrews, TXthe mechanic's improper overhaul of the engine. Factors were: the pilot in command's inability to maintain visual lookout due to oil on the windscreen and unsuitable terrain for the forced landing.Feb 22, 1996 · N57828 · Substantial damageNTSB ATL96LA132Accident · No injuriesLimited investigationFinal reportBeech 35 · Griffin, GAfailure of maintenance personnel to properly balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.Feb 22, 1996 · N3134V · Substantial damageNTSB MIA96LA080Accident · No injuriesLimited investigationFinal reportBerkshire Concept 70 · Boynton Beach, FLan engine loss of power and fire for undetermined reasons.Feb 20, 1996 · N29BW · DestroyedNTSB LAX96FA115Accident · 3 fatalField investigationFinal reportCessna 172N · Julian, CAthe pilot's delay in requesting assistance to avoid high terrain. Factors were: the downdrafts, mountainous terrain, and the pilot's improper in-flight planning.Feb 20, 1996 · N738ED · DestroyedNTSB ATL96IA053Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Raleigh, NCThe operator's inadequate progressive inspection program that did not require periodic analysis of airplane hydraulic system fluid; and the failure of the operator to comply with the airplane manufacturer's maintenance manual resulting in contamination of the…Feb 20, 1996 · N129AM · No damageNTSB LAX96FA119Accident · 1 fatalField investigationFinal reportBeech C35 · Lee Vining, CAFuel starvation due to the pilot's failure to adequate monitor the aircraft's fuel system and select a tank containing fuel in a timely manner. The pilot's failure to monitor the fuel system was due to the effects of hypoxia. Factors in the accident were the…Feb 19, 1996 · N2PA · DestroyedNTSB CHI96FA094Accident · 2 fatalField investigationFinal reportCessna 182 · Odell, ILVFR flight by the pilot into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, probably due to spatial disorientation of the pilot. Factors relating to the accident were: darkness, reduced visibility due to the weather…Feb 19, 1996 · N3243Y · DestroyedNTSB CHI96LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Worthington, MNProgressive failure of the engine, beginning with failure of the left magneto, which resulted in preignition or detonation, a burned hole in the #3 piston, subsequent oil exhaustion, and failure of the #1 and #2 connecting rods.Feb 18, 1996 · N758CQ · Substantial damageNTSB LAX96LA117Accident · No injuriesLimited investigationFinal reportCessna 172P · Raymond, CAThe pilot's failure to verify the quantity of fuel onboard the aircraft prior to departure, which resulted in fuel exhaustion.Feb 17, 1996 · N53115 · Substantial damageNTSB IAD96LA043Accident · No injuriesLimited investigationFinal reportCessna 177A · Sidney, OHfuel contamination, and the pilot's inadequate preflight inspection, which resulted in subsequent loss of engine power during cruise flight. A factor relating to the accident was: rough terrain in the emergency landing area.Feb 17, 1996 · N30422 · Substantial damageNTSB SEA96FA061Accident · 1 fatalField investigationFinal reportCessna 402B · Estacada, ORloss of aircraft control for undetermined reason(s).Feb 16, 1996 · N5198J · DestroyedNTSB FTW96LA139Accident · No injuriesLimited investigationFinal reportRockwell 500U · Hampton, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.Feb 16, 1996 · N197K · Substantial damageNTSB CHI96FA090Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Brookston, INthe pilot's disregard for the forecast adverse weather conditions, his inadvertent flight into adverse weather conditions, and his disorientation. Factors relating to this accident were the pilot's lack of experience in instrument conditions, the snow and fog.Feb 15, 1996 · N4612F · DestroyedNTSB ATL96TA047Accident · Minor injuriesFinal reportPiper PA-32-300 · Windermere, FLthe use of improper connecting rod bolts, failure of the overhaul facility to record the correct overhaul date on the work orders for the stored connecting rod assemblies, and subsequent failure of the connecting rod bolts.Feb 13, 1996 · N8951N · Substantial damageNTSB FTW96LA116Accident · No injuriesLimited investigationFinal reportCessna 172K · Hedley, TXthe failure of maintenance personnel to properly torque the connecting rod bolts. A factor was the lack of suitable terrain for the forced landing.Feb 11, 1996 · N7358G · Substantial damageNTSB NYC96FA061Accident · 1 fatalField investigationFinal reportCessna P206A · Forks Township, PAThe pilot's failure to maintain a proper altitude, and insufficient obstruction lighting requirements established by the Federal Aviation Administration and the Federal Communications Commission.Feb 10, 1996 · N4655F · DestroyedNTSB CHI96FA088Accident · 1 fatalField investigationFinal reportBell 206B-III · Pellston, MIflight into known adverse weather conditions (fog) at too low an altitude by the pilot. Factors associated with this accident were inadequate preflight planning and an improper inflight decision by the pilot when he chose to continue flight into the fog…Feb 10, 1996 · N2157J · DestroyedNTSB FTW96LA115Accident · No injuriesLimited investigationFinal reportCessna 172G · Gunnison, COLoss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.Feb 9, 1996 · N4262L · Substantial damageNTSB MIA96LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Boca Raton, FLthe partial loss of engine power due to the fatigue failure of the number 3 cylinder hold down studs and nut. A factor was the pilot'e evasive maneuver to avoid golphers on a golf course.Feb 8, 1996 · N55329 · Substantial damageNTSB LAX96FA108Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Ramona, CAinadequate visual lookout by the pilots of both airplanes, which resulted in their failure to see and avoid each other.Feb 8, 1996 · N791CR · 2 aircraft · Substantial damageNTSB ATL96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32-RT-300 · Blountville, TNInadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.Feb 7, 1996 · N2200J · Substantial damageNTSB SEA96LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Mcleary, WAfailure of the pilot to maintain sufficient altitude/clearance from mountainous/wooded terrain. Factors relating to the accident were: the terrain and downdraft conditions.Feb 4, 1996 · N6750H · Substantial damageNTSB FTW96LA110Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cushing, OKThe inadvertent deployment of the passenger's parachute as a result of his failure to follow proper procedures and deactivate the automatic opening device on the parachute.Feb 3, 1996 · N2184Z · No damageNTSB ATL96LA044Accident · Minor injuriesLimited investigationFinal reportBeech C-45G · Blountville, TNthe pilot's improper use of carburetor heat which resulted in a continuing loss of engine power, and the right landing gear's failure to extend during a single engine approach. A factor was the insufficient time available to extend the landing gear via the…Feb 2, 1996 · N204AA · Substantial damageNTSB LAX96LA104Accident · No injuriesLimited investigationFinal reportBell 206BIII · Kamuela, HIfailure of the nose case (No.1) bearing resulting in oil starvation.Feb 1, 1996 · N90194 · Substantial damageNTSB FTW96FA145Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Estes Park, CODescent into mountainous terrain for reasons undetermined.Feb 1, 1996 · N83809 · DestroyedNTSB LAX96LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Oroville, CAthe failure of the pilot to use carburetor heat, which resulted in loss of engine power due to carburetor ice. The carburetor icing (weather) condition was a related factor.Jan 28, 1996 · N992PK · Substantial damageNTSB FTW96LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Grand Prairie, TXa loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 28, 1996 · N6706C · Substantial damageNTSB FTW96LA107Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Bernal, NMthe pilot's improper planning/decision, including his failure to maintain sufficient altitude/clearance from mountainous terrain to compensate for altitude deviations that resulted from mountain wave/wind conditions. Factors relating to the accident were: the…Jan 28, 1996 · N69808 · Substantial damageNTSB FTW96FA108Accident · Serious injuriesField investigationFinal reportCessna 152 · Conway, ARloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall at low altitude. The gusty wind condition was a related factor.Jan 28, 1996 · N757UK · DestroyedNTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jan 28, 1996 · N2315U · Substantial damageNTSB LAX96LA101Accident · No injuriesLimited investigationFinal reportBoeing A75 · Barstow, CAa loss of engine power for an undetermined reason(s).Jan 27, 1996 · N1359N · Substantial damageNTSB BFO96LA040Accident · Serious injuriesLimited investigationFinal reportAerostar 601 · Mount Storm, WVloss of power in the right engine for undetermined reason(s), and the accumulation of structural ice on the airplane, which resulted in an increased rate of descent and a subsequent forced landing before the pilot could reach an alternate airport. Factors…Jan 27, 1996 · N162GA · DestroyedNTSB BFO96FA039Accident · 2 fatalField investigationFinal reportCessna R172K · Highland Hills, OHthe pilot's continued VFR flight into instrument meteorological conditions at a low altitude with known obstacles in the area.Jan 23, 1996 · N3107V · DestroyedNTSB LAX96FA098Accident · 2 fatalField investigationFinal reportCessna T-210N · Gorman, CAThe loss of control of the aircraft in cruise flight for undetermined reasons and subsequent in-flight structural failure of the aircraft.Jan 22, 1996 · N6452N · DestroyedNTSB CHI96FA083Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Carlyle, ILspatial disorientation of the pilot, and his failure to maintain control of the airplane, which resulted in his exceeding the design stress limits of the airframe. A factor relating to the accident was: turbulence in clouds.Jan 22, 1996 · N800CE · DestroyedNTSB FTW96FA100Accident · 4 fatalField investigationFinal reportBeech 58 · Atkins, ARContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above mountainous/hilly terrain. Factors relating to the accident were: low ceiling, fog, and high terrain in the area of the…Jan 21, 1996 · N3010W · DestroyedNTSB LAX96FA097Accident · Minor injuriesField investigationFinal reportPiper PA-28-236 · Seal Beach, CAa total loss of engine power from an improperly installed magneto that separated from the engine housing due to fatigue from vibration.Jan 20, 1996 · N2476Y · Substantial damageNTSB LAX96FA096Accident · 2 fatalField investigationFinal reportBeech 55 · Cedarville, CAthe pilot's poor preflight planning by not obtaining a weather briefing and his inadvertent encounter with a mountain wave condition. The moonless dark night was a factor in this accident.Jan 20, 1996 · N4088A · DestroyedNTSB MIA96LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Smithville, TNThe pilot's improper in-flight planning/decision, which resulted in a heavy load of airframe ice, an inability to maintain altitude, and a subsequent emergency landing. Factors relating to the accident were: the adverse weather (icing) condition, which was…Jan 19, 1996 · N4457X · Substantial damageNTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.Jan 19, 1996 · N598Z · Substantial damage