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 ATL96LA087Accident · Serious injuriesLimited investigationFinal reportSky Star Kitfox #1 · Bridgeport, ALloss of engine power for undetermined reason(s). Trees in the emergency landing area were a related factor.May 26, 1996 · N7030G · Substantial damageNTSB CHI96LA178Accident · Minor injuriesLimited investigationFinal reportDickinson Fisher Classic · Mooresville, INthe pilot failed to maintain adequate altitude and clearance from the trees, and had made an improper in-flight decision when he got to far from a suitable landing area. The reason for the loss of power failure was undetermined.May 25, 1996 · N6292B · Substantial damageNTSB FTW96LA226Accident · Serious injuriesLimited investigationFinal reportNavion NA1 · Los Lunas, NMThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 24, 1996 · N2530T · Substantial damageNTSB CHI96IA170Incident · No injuriesIncident investigationFinal reportBeech 1900D · Indianapolis, INfailure of a forward cabin ventilation blower motor bearing, which resulted in binding of the blower motor; and inadequate design of the electrical system, which allowed overheating of the electrical circuit and smoke in the cabin of the aircraft.May 24, 1996 · N148SK · Minor damageNTSB FTW96LA224Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Lunas, NMloss of total engine power due to fuel exhaustion for undetermined reason(s). The lack of suitable terrain for the forced landing was a related factor. The worn and leaking fuel system components and inadequate maintenance by unknown personnel were possible…May 22, 1996 · N1813H · Substantial damageNTSB ANC96LA076Accident · Minor injuriesLimited investigationFinal reportBeech 99C · Barrow, AKan in-flight collision with a bird.May 21, 1996 · N216CS · Substantial damageNTSB MIA96LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) while maneuvering during a go-around, resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's failure to achieve the proper touchdown point…May 20, 1996 · N9164B · Substantial damageNTSB IAD96LA079Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carrollton, OHThe pilot's inadequate fuel management. Factors in this accident were the pilot's reliance on a fuel data computer and his untimely reaction to a known fuel quantity discrepancy.May 20, 1996 · N731NC · Substantial damageNTSB CHI96FA171Accident · No injuriesField investigationFinal reportCessna 401 · Great Bend, KSthe failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.May 20, 1996 · N701CJ · Substantial damageNTSB NYC96LA111Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Bloomingburg, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall spin and collision with trees.May 19, 1996 · N65847 · Minor damageNTSB LAX96IA199Incident · No injuriesIncident investigationFinal reportBoeing 747-273C · Los Angeles, CAthe operator's failure to adopt a manufacturer's stipulated ultrasonic inspection procedure, which led to the in-flight separation of the wing panel.May 19, 1996 · N470EV · Minor damageNTSB LAX96FA200Accident · 1 fatalField investigationFinal reportCessna 414 · Kernville, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from rising/mountainous terrain. Factors relating to the accident were: the terrain and weather conditions.May 19, 1996 · N111AH · DestroyedNTSB NYC96LA109Accident · Minor injuriesLimited investigationFinal reportMcCall WATCHA-MCCALL-IT · Steamburg, NYthe pilot/owner's failure to ensure adequate maintenance/inspection of the airplane; and a loose fuel line fitting, which resulted in a subsequent fuel leak, fuel starvation, and loss of engine power. Factors relating to the accident were: the pilot's…May 18, 1996 · N111MC · Substantial damageNTSB LAX96LA197Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sylmar, CAfuel exhaustion due to the inexperienced student pilot's inadequately performed preflight inspection and her failure to refuel prior to takeoff.May 18, 1996 · N69180 · DestroyedNTSB IAD96LA081Accident · No injuriesLimited investigationFinal reportCessna 205A · Sommerville, VAthe loss of engine power for undetermined reasons during banner towing operations.May 18, 1996 · N5261G · Substantial damageNTSB CHI96LA163Accident · No injuriesLimited investigationFinal reportJohnson Avid Flyer · Rockford, MIengine overtemperature which occurred for an undetermined reason. A factor was the excessive descent rate.May 18, 1996 · N4274A · Substantial damageNTSB MIA96LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tallahassee, FLthe pilot's mismanagement of fuel, by failing to reposition the fuel selector to the left tank after fuel was used from the right tank, which resulted in fuel starvation, loss of engine power, and a forced landing. A factor relating to the accident was: the…May 16, 1996 · N9239B · Substantial damageNTSB SEA96FA094Accident · 2 fatalField investigationFinal reportCessna 320A · Provo, UTA fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…May 15, 1996 · N600JR · DestroyedNTSB CHI96IA157Incident · Minor injuriesIncident investigationFinal reportBoeing 727-290 · Indianapolis, INthe failure of the captain and flight engineer to utilize a checklist to troubleshoot a pressurization system problem, and the flight engineer's improper control of the pressurization system which resulted in an inadvertent opening of the outflow valve and…May 13, 1996 · N775AT · No damageNTSB IAD96LA083Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Woodbine, MDThe pilot's decision to fly with inadequate research of forecast weather.May 11, 1996 · N112LK · Substantial damageNTSB DCA96MA054Accident · 110 fatalClass 1 · MajorFinal reportDouglas DC-9-32 · Miami, FLwhich resulted from a fire in the airplane's class D cargo compartment that was initiated by the actuation of one or more oxygen generators being improperly carried as cargo, were (1) the failure of SabreTech to properly prepare, package, and identify…May 11, 1996 · N904VJ · DestroyedNTSB FTW96LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Claude, TXthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft terrain was a related factor concerning nose over in the emergency landing area.May 10, 1996 · N7426R · Substantial damageNTSB CHI96GA154Incident · No injuriesFinal reportBeech 200 · Peoria, ILthe pilot's intentional flight into known adverse weather conditions and the lightning strike.May 8, 1996 · N961LL · Minor damageNTSB IAD96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-600 · Syracuse, NYthe pilot's failure to ensure that his hand would remain clear of the propeller, while attempting to take remedial action to secure the clam shell door. The unlatching and separation of the clam shell door from the aircraft were related factors.May 7, 1996 · N222KD · Minor damageNTSB NYC96FA101Accident · 2 fatalField investigationFinal reportCessna P210N · Ridgefield, CTimproper planning/decision by the pilot, which led to flight into icing conditions; and his failure to use all anti-ice and deicing equipment, as specified by the airplane operator's manual for inadvertent flight into icing conditions. This resulted in loss…May 6, 1996 · N450T · DestroyedNTSB FTW96LA202Accident · No injuriesLimited investigationFinal reportStinson 108-2 · El Paso, TXthe pilot's improper inflight planning/decision, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: the unfavorable en route wind.May 6, 1996 · N427C · Substantial damageNTSB MIA96LA137Accident · No injuriesLimited investigationFinal reportCessna U206G · Gulf Of MexicoLoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.May 5, 1996 · N9702Z · Substantial damageNTSB ANC96LA069Accident · No injuriesLimited investigationFinal reportGillespie Challenger 2 · Talkeetna, AKThe pilot's failure to properly use the mixture control to enrich the fuel mixture, and the seizure of the piston in the cylinder.May 5, 1996 · N1591G · Substantial damageNTSB MIA96LA136Accident · No injuriesLimited investigationFinal reportBeech UC45J · Opa Locka, FLinadequate inspection of the fuel line connector by company maintenance personnel, and failure of a connector resulting in a fuel leak and fire.May 2, 1996 · N64819 · Substantial damageNTSB MIA96FA134Accident · 2 fatalField investigationFinal reportBeech V35 · Powelton, GAthe pilot's continued flight into known adverse weather conditions, resulting in an in-flight separation of the left wing and ruddervator. Factors in this accident were: level three and four thunderstorms, intense to extreme precipitation, and severe…Apr 29, 1996 · N102A · DestroyedNTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…Apr 29, 1996 · N341DA · DestroyedNTSB CHI96IA145Incident · Minor injuriesIncident investigationFinal reportBoeing 727-222A · Chicago, ILa passenger disturbance that required the flight attendant to leave her seat. A factor in this accident was the encounter with turbulence as the flight attendant was performing her assigned duties.Apr 28, 1996 · N7443U · No damageNTSB ANC96FA059Accident · 1 fatalField investigationFinal reportCessna 150 · Palmer, AKloss of engine power due to a malfunction of the airplane's magneto ignition system, and the pilot's failure to have an annual inspection performed. Factors relating to the accident were: the pilot's lack of recent experience and inadequate in-flight planning…Apr 28, 1996 · N8115U · DestroyedNTSB FTW96FA183Accident · 4 fatalField investigationFinal reportPiper PA-28-151 · Vera, OKimproper installation by unknown person(s) of incorrect exhaust system clamps, which led to an exhaust system disconnect and a subsequent engine compartment fire.Apr 27, 1996 · N7845C · DestroyedNTSB MIA96LA131Accident · No injuriesLimited investigationFinal reportCessna 210M · Meridian, MSprevious engine damage; failure of the pilot of the previous flight to report to the operator and/or mechanics that the engine had been operated with low (or no) oil pressure; inadequate maintenance/inspection after most of the oil had leaked from the engine…Apr 26, 1996 · N722PD · Substantial damageNTSB IAD96LA067Accident · No injuriesLimited investigationFinal reportBell 206B · Logan, WVthe pilot's failure to maintain an adequate fuel supply for the flight which resulted in a loss of engine power due to fuel exhaustion, and the loss of rotor rpm during the autorotation. The downhill sloping terrain was a related factor.Apr 26, 1996 · N111PM · Substantial damageNTSB FTW96LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Columbus, TXthe pilot's improper inflight planning/decision to continue the flight instead of returning to the takeoff airport after encountering adverse weather. Factors were: the inaccurate weather forecast, the low ceiling and the lack of suitable terrain for the…Apr 26, 1996 · N2194Y · Substantial damageNTSB SEA96LA082Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Salt Lake City, UTthe student pilot's inadequate preflight planning/preparation, by failuring to properly calculate the fuel consumption of the airplane, which led to fuel exhaustion and loss of power during cruise flight, due to an inadequate supply of fuel. A factor relating…Apr 21, 1996 · N8873S · Substantial damageNTSB ANC96LA053Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Grayling, AKdisintegration of the alternator drive coupling, jamming of the accessory drive gear, shearing of the oil pump drive, oil starvation, and failure of the number 6 cylinder connecting rod. Non-compliance with a manufacturer's service bulletin and soft snow were…Apr 21, 1996 · N9704N · DestroyedNTSB MIA96LA123Accident · Serious injuriesLimited investigationFinal reportVernon L. Cox COX-HAWK · Mebane, NCThe pilot's inadvertent flight into instrument meteorological conditions in an airplane not equipped with appropriate instrumentation which led to the pilot's inability to maintain control and spatial disorientation. In addition, during an attemped recovery…Apr 20, 1996 · N7VC · DestroyedNTSB CHI96FA139Accident · 1 fatalField investigationFinal reportCessna 150F · Mackinac Island, MIthe student pilot iniating VFR flight into instrument meteorological conditions which led to a loss of aircraft control. A factor was the fog.Apr 19, 1996 · N6824F · DestroyedNTSB NYC96FA085Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Granville, OHthe pilot's intentional flight into known icing conditions and his overconfidence in his ability, which led to a partial loss of engine power as a result of induction system ice. Also causal was ATC's excessive vectoring of the airplane in icing conditions,…Apr 16, 1996 · N8276Y · DestroyedNTSB IAD96LA063Accident · 2 fatalLimited investigationFinal reportGlasair GL20 · Rocky Mount, VAthe pilot's continued flight into adverse weather conditions which led to airframe ice and a loss of control. Related factors were: the failure of the FSS briefer to advise the pilot of a valid AIRMET regarding icing conditions, the icing conditions, and…Apr 16, 1996 · N518EC · DestroyedNTSB LAX96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Santa Paula, CAfuel starvation due to the pilot's failure to monitor fuel tank quantities and to assure that the fuel tank selector was positioned to a tank containing adequate fuel.Apr 14, 1996 · N6415P · Substantial damageNTSB LAX96LA168Accident · No injuriesLimited investigationFinal reportHughes 369D · Yerington, NVthe partial loss of engine power and the pilot's misjudged flare during an autorotation landing in soft dirt with excessive forward speed. The power loss resulted from flight operations in an environment which debris contaminated the engine's nozzle port and…Apr 14, 1996 · N519BH · Substantial damageNTSB LAX96LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Lake Havasu Cty, AZthe pilot-owner's inadequate engine maintenance which resulted in a progressive ignition failure. Factors which contributed to the accident were the dark nighttime light condition and the presence of hidden obstructions in the forced landing area.Apr 14, 1996 · N9177E · Substantial damageNTSB CHI96LA132Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Anoka, MNA loose exhaust system that had become disconnected and blocked, which resulted in partial loss of engine power.Apr 13, 1996 · N954W · Substantial damageNTSB MIA96IA114Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2G-30 · Columbia, SCfailure of the nose landing gear bearing due to improper assembly and staking (inadequate quality control) by the manufacturer; which prevented the nose gear from retracting and the main gear from extending, and resulted in a subsequent landing on the nose…Apr 12, 1996 · N920S · Minor damageNTSB CHI96LA129Accident · Minor injuriesLimited investigationFinal reportCessna T310Q · Minneapolis, MNthe inadequate fuel supply for the intended flight which resulted in fuel exhaustion. Factors related to the accident were the pilot operating the airplane with an inoperative fuel gauge and the embankment which the airplane traveled down during the forced…Apr 10, 1996 · N7713Q · Substantial damageNTSB IAD96LA058Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Atlantic Ocean (Atlantic Ocean)the in-flight encounter with unforecast, unexpected turbulence.Apr 8, 1996 · N653A · No damage