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 NYC96FA084Accident · 1 fatalField investigationFinal reportPitts S-2B · Freehold Twsp, NJthe pilot's improper fuel management which resulted in a power loss due to fuel exhaustion, and his failure to maintain airspeed during a forced landing which resulted in an inadvertent stall.Apr 6, 1996 · N917JD · DestroyedNTSB LAX96FA155Accident · Serious injuriesField investigationFinal reportCessna 182RG · Beaver Dam, AZan engine failure due to oil starvation resulting from the pilot's improper aircraft preflight. A factor relating to the accident was: failure of the operator to ascertain that proper maintenance was performed after the airplane's high oil consumption rate…Apr 6, 1996 · N600CT · DestroyedNTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…Apr 6, 1996 · N6234E · DestroyedNTSB ANC96LA045Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas H-369 · Delta Junction, AKloss of engine power for an undetermined reason.Apr 6, 1996 · N58268 · Substantial damageNTSB NYC96GA083Accident · 2 fatalFinal reportBell 206L-1 · Charleston, WVthe helicopter manufacturer's inadequate maintenance service bulletin inspection interval which failed to provide timely detection of preexisting fatigue cracks in the tail boom. Factors were: the manufacturer's failure to develop a modification of the failed…Apr 4, 1996 · N79SP · DestroyedNTSB IAD96LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Roanoke, VAthe pilot's misjudged estimation of the airplane's fuel supply for the flight. Related factors are the inadequate preflight inspection, the pilot's expectation that the airplane had been topped off, and the soft terrain encountered during the forced landing.Apr 4, 1996 · N5730T · DestroyedNTSB LAX96LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Chandler, AZThe failure of both the engine driven and hand wobble fuel pumps, which resulted in fuel starvation to the engine.Apr 3, 1996 · N45043 · Substantial damageNTSB NYC96LA080Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Old Bridge, NJfuel contamination, due to improper servicing of the aircraft, which resulted in fuel starvation, loss of engine power, a forced landing, and collision with a tree. The strong surface wind was a related factor.Apr 2, 1996 · N9625R · Substantial damageNTSB LAX96LA152Accident · 1 fatalLimited investigationFinal reportPowell Glasair · Groveland, CAthe pilot's decision to fly the aircraft with a known mechanical discrepancy in the throttle linkage, which resulted in a partial loss of engine power; and his failure to maintain an adequate airspeed while maneuvering for an emergency landing, which resulted…Apr 2, 1996 · N59LP · DestroyedNTSB ATL96FA074Accident · 2 fatalField investigationFinal reportCessna P210N · Marathon, FLfailure of the pilot to maintain sufficient altitude during an over-water approach at night. Factors relating to the accident were darkness and pilot fatigue.Apr 1, 1996 · N6427W · Substantial damageNTSB SEA96IA074Incident · No injuriesIncident investigationFinal reportDornier DO 328-100 · Eugene, ORdelamination of the wing de-icing boot, due to the boot reaching its life limit.Mar 31, 1996 · N334PH · Minor damageNTSB LAX96LA151Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Sacramento, CAA loss of engine power due to carburetor ice and the student's failure to use carburetor heat. The carburetor icing (weather) condition was a related factor.Mar 31, 1996 · N5266Q · Substantial damageNTSB CHI96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Thief Rvr Falls, MNA ruptured oil line, which resulted in oil exhaustion and subsequent loss of engine power.Mar 31, 1996 · N5932U · Substantial damageNTSB LAX96LA164Accident · Minor injuriesLimited investigationFinal reportRussman Avid Flyer · Searchlight, NVan engine failure from oil exhaustion due to a leak in the oil line.Mar 30, 1996 · N5439V · Substantial damageNTSB IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.Mar 30, 1996 · N57012 · DestroyedNTSB LAX96LA147Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Torrance, CAinadequate maintenance and inspection of the airplane; rust and water contamination in the aircraft fuel system; a worn shaft and cracked coupling in the left engine's left magneto, a malfunctioning left magneto on the right engine, and contamination (oil and…Mar 29, 1996 · N14260 · Substantial damageNTSB CHI96LA127Accident · No injuriesLimited investigationFinal reportSocata TBM-700 · Eau Claire, WIfatigue fracture and subsequent failure of the gear door hinge bracket.Mar 29, 1996 · N292RG · Substantial damageNTSB CHI96FA120Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lincoln, KSthe pilot became spatially disoriented and failed to maintain control of the airplane. The factors involved were the pilot encountered VFR flight into IMC, pressure induced by conditions/events, low ceilings, and the dark light conditions.Mar 29, 1996 · N8214W · DestroyedNTSB MIA96LA106Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Defuniak Spring, FLThe pilot's inadvertent flight into instrument meteorological conditions, and inadvertent descent, due to spatial disorientation, which resulted in a collision with trees. Factors relating to the accident were: the adverse weather conditions and the pilot's…Mar 26, 1996 · N56874 · DestroyedNTSB LAX96LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAinadequate preflight by the pilot, and subsequent fuel exhaustion, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related factors.Mar 25, 1996 · N24963 · Substantial damageNTSB FTW96LA155Accident · 1 fatalLimited investigationFinal reportDomaille Rans S-12 · Albuquerque, NMthe student pilot's failure to maintain control of the aircraft after initiating a flight into adverse weather conditions. The strong, gusting wind was a factor.Mar 24, 1996 · N4017S · Substantial damageNTSB LAX96LA144Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Hollister, CAthe pilot's improper in-flight decision to take a longer than necessary route back to the airport during a period of marginal lift.Mar 23, 1996 · N4HT · Substantial damageNTSB LAX96LA142Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DC-65 · Fremont, CAthe in-flight separation of a portion of one wooden propeller blade due to undetected dry rot in the wood fibers.Mar 23, 1996 · N36354 · Substantial damageNTSB LAX96LA141Accident · Minor injuriesLimited investigationFinal reportScheperle Mustang II MOD · Merced, CAa loss of engine power due to a malfunctioning thermostat valve in the liquid cooling system.Mar 23, 1996 · N8180T · Substantial damageNTSB IAD96LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Roanoke, VAloss of engine power for undetermined reason(s). Darkness and the pilot's improper emergency procedures were related factors.Mar 23, 1996 · N108RV · Substantial damageNTSB FTW96LA157Accident · Serious injuriesLimited investigationFinal reportBoeing B-757-222 · Taos, NMan encounter with unforecasted clear air turbulence.Mar 23, 1996 · N503UA · No damageNTSB LAX96FA140Accident · 2 fatalField investigationFinal reportSchweizer 269C · Ontario, CAThe pilot's decision to attempt a VFR descent into instrument meteorological conditions resulting in spatial disorientation.Mar 22, 1996 · N155T · DestroyedNTSB LAX96FA139Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Moreno Valley, CAVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC). The terrain and adverse weather conditions were related factors.Mar 22, 1996 · N17D · DestroyedNTSB CHI96FA133Accident · 1 fatalField investigationFinal reportBeech F-33A · Prairie City, SDthe pilot's failure to maintain control of the airplane. A factor was pilot fatigue.Mar 22, 1996 · N5563X · DestroyedNTSB SEA96FA071Accident · Minor injuriesField investigationFinal reportCessna U206E · Renton, WAthe pilot's initiation of a flight with a known disqualifying heart condition, and his subsequent inflight incapacitation from a heart attack. A factor relating to the accident was: the inability of the non-rated passenger (unqualified person) to attain a…Mar 20, 1996 · N1460M · Substantial damageNTSB CHI96IA109Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Detroit, MIa defective diode in the number two stabilizer actuator that produced an intermittent loss of electrical motor power during transient, closed loop control of the actuator. A factor was the intermittent open circuit in the elevator servo controller…Mar 18, 1996 · N340NW · No damageNTSB MIA96LA101Accident · No injuriesLimited investigationFinal reportSummerfeldt Thorp T-18 · Hampton, SCThe pilot's improper planning/decision and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: the pilot's failure to use a preflight briefing service, the adverse weather conditions, and soft terrain in the…Mar 17, 1996 · CFPVE · Substantial damageNTSB CHI96LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Howard, KSthe student pilot's failure to obtain timely assistance after encountering adverse weather during a cross-country flight which led to fuel exhaustion.Mar 17, 1996 · N1532Q · Substantial damageNTSB ATL96LA067Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Kingston, TNThe pilot's inadequate pre-flight inspection, which resulted in fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Mar 17, 1996 · N78896 · Substantial damageNTSB CHI96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Paul, MNthe pilot's failure to assure an adequate fuel supply for the flight which resulted in fuel exhaustion. A factor associated with the accident was the signs contacted by the airplane during the forced landing.Mar 15, 1996 · N2503B · Substantial damageNTSB ATL96FA066Accident · 1 fatalField investigationFinal reportCessna 310R · Winder, GAThe pilot's failure to maintain visual flight conditions which resulted in the loss of control and subsequent inflight breakup of the airplane when he exceeded the design stress limits of the airframe.Mar 15, 1996 · N447T · DestroyedNTSB SEA96LA068Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Point Of Rocks, WYthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control due to spatial disorientation. Factors relating to the accident were: the low ceiling and snow.Mar 13, 1996 · N3632T · DestroyedNTSB LAX96LA133Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Grass Valley, CAfuel starvation for an undetermined reason.Mar 13, 1996 · N8683M · DestroyedNTSB ATL96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Flamingo, FLThe student pilot's selection of unsuitable terrain for a precautionary landing. Failure of the #3 exhaust tube was a related factor.Mar 13, 1996 · N6174Q · Substantial damageNTSB SEA96LA067Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Darrington, WAa ditching of the airplane for undetermined reason(s).Mar 12, 1996 · N41MG · Substantial damageNTSB NYC96LA074Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Shirley, MEthe pilot's fuel mismanagement and improper use of the fuel selector valve which resulted in fuel starvation.Mar 11, 1996 · N712MY · Substantial damageNTSB FTW96LA144Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Clinton, LAthe pilot's improper positioning of the fuel selector which resulted in fuel starvation. Factors were the dark night light condition and the worn spark plugs.Mar 10, 1996 · N8323N · Substantial damageNTSB FTW96FA143Accident · 1 fatalField investigationFinal reportCessna 150 · Muleshoe, TXimproper planning/decision by the student pilot, and his failure to take adequate remedial action after becoming lost and encountering a low fuel situation, which subsequently resulted in fuel exhaustion, loss of engine power, and a forced landing at night.…Mar 10, 1996 · N66362 · DestroyedNTSB LAX96FA130Accident · No injuriesField investigationFinal reportBellanca 7GCAA · Los Alamitos, CAthe failure of both pilots to see and avoid each other. Factors were the pilots' failure to use available radar services.Mar 9, 1996 · N5052Y · 2 aircraft · Substantial damageNTSB NYC96LA071Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Philadelphia, PAthe pilot's improper planning/decision, and his resultant flight into known icing conditions, which resulted in ice accumulation, loss of engine power, a forced landing, and subsequent collision with a residence and a vehicle. A factor relating to the…Mar 7, 1996 · N6625P · DestroyedNTSB MIA96FA096Accident · 6 fatalField investigationFinal reportPiper PA-28-180 · Flagler Beach, FLinadequate visual lookout by the pilots in both airplanes, which resulted in their failure to see-and-avoid conflicting traffic.Mar 7, 1996 · N4258T · 2 aircraft · DestroyedNTSB ATL96LA058Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Livingston, TNFailure of the pilot to see-and-avoid obstructions (electrical lines), while on final approach to land after encountering icing conditions and diverting to a new destination (alternate airport).Mar 7, 1996 · N7913P · Substantial damageNTSB CHI96LA103Accident · No injuriesLimited investigationFinal reportCessna 172 · Valparaiso, INthe pilot's continued flight into adverse weather. Factors were the low ceilings, icing conditions, airframe ice, and the muddy field.Mar 5, 1996 · N21662 · Substantial damageNTSB FTW96LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Sulphur Springs, TXthe pilot's failure to maintain terrain clearance. A factor was his diverted attention to the performance of the manual gear extension procedure.Mar 4, 1996 · N40273 · Substantial damageNTSB CHI96LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pittsburg, KSan inadequate annual inspection by maintenance personnel, a deteriorated muffler, and pilot incapacitation due to carbon monoxide.Mar 2, 1996 · N95394 · Substantial damage