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 NYC92LA109Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAThe student pilot's delayed action in applying carburetor heat during cruise, which resulted in a loss of engine power due to carburetor ice. Factors in this accident were: weather conditions conducive for carburetor icing, the pilot's lack of total flying…Jun 25, 1992 · N1793Q · Substantial damageNTSB FTW92FA169Accident · 1 fatalField investigationFinal reportRockwell 690B · Konawa, OKThe pilot's failure to maintain control of the airplane which resulted in an inadvertent spiral and subsequent rapid descent. The design stress limits of the airframe were exceeded resulting in an overload failure of the empennage. Factors related to the…Jun 25, 1992 · N690JC · DestroyedNTSB DEN92FA064Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-30 · Alamagordo, NMThe failure of the pilot to exercise adequate VFR departure terrain avoidance procedures, and the failure of the controller to issue a safety alert to the pilot. Factors which contributed to the accident were: the pilot's lack of familiarity with the…Jun 25, 1992 · N108SC · DestroyedNTSB CHI92FA188Accident · Minor injuriesField investigationFinal reportBeech 24R · Oak Creek, WIA result of inadequate aircraft maintenance inspection on behalf of the company maintenance personnel.Jun 25, 1992 · N2195W · DestroyedNTSB LAX92LA258Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Georgetown, CAThe under torque of the crankcase through bolts during overhaul causing; 1) the number 2 main bearing to spin, 2) the resultant blockage of the internal oil passage, and 3) the oil starvation induced failure of the number 2 connecting rod and cap. A factor in…Jun 24, 1992 · N9933N · Substantial damageNTSB LAX92FA260Accident · 3 fatalField investigationFinal reportCessna 421B · Monterey, CAThe owner/pilot's poor judgement in attempting an operation beyond his experience and ability, which resulted in his failure to attain an adequate climb profile necessary for terrain clearance. Also, the owner/pilot lacked instrument experience, and was…Jun 24, 1992 · N628RJ · DestroyedNTSB LAX92FA257Accident · 2 fatalField investigationFinal reportWaco UPF-7 · Sedona, AZFuel exhaustion due to the pilots inadequate preflight planning and his failure to refuel the airplane prior to departure. Factors in the accident were: 1) the unreliable fuel sight gauges which were contaminated with a tar like residue which may have…Jun 23, 1992 · N29926 · DestroyedNTSB SEA92IA136Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 1000 · Portland, ORThe partial failure of the horizontal stabilizer trim drive system, the restricted movement of the stabilizer, and the overtorque of a system component.Jun 22, 1992 · CGTAH · No damageNTSB NYC92LA124Accident · No injuriesLimited investigationFinal reportCessna 421B · Columbus, OHThe electrical fire which started in a component that was part of a door seal modification. Also causal to the accident was the installation of this unapproved airplane modification.Jun 22, 1992 · N39PW · Substantial damageNTSB CHI92LA185Accident · No injuriesLimited investigationFinal reportCessna 150H · Three Rivers, MIThe pilot-in-command's selection of a rough and uneven terrain. A factor related to the accident was the pilot-in-command's poor inflight decision making.Jun 21, 1992 · N22120 · Substantial damageNTSB DEN92LA062Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Rocky Ford, COThe pilots failure to maintain altitude due to spatial disorientation. Factors were: low overcast skies and ground fog.Jun 20, 1992 · N3649D · DestroyedNTSB NYC92DGM02Accident · No injuriesFinal reportPeres 5151 · Erie, PASeizure of the #2 piston which resulted in the lost of engine power and subsequent collision with trees during a forced landing.Jun 19, 1992 · N5151M · Substantial damageNTSB FTW92LA164Accident · No injuriesLimited investigationFinal reportCessna 320D · Aztec, NMFailure of the right propeller to feather and inoperative gear retraction system. Factors were the high density altitude and the power loss due to connecting rod failure.Jun 18, 1992 · N3307Q · Substantial damageNTSB MIA92LA139Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau 300 · Titusville, FLSeparation of the propeller governor cover from the body for undetermined reasons and visual restriction of the pilot due to leaking oil which covered the windscreen.Jun 17, 1992 · N300XL · Substantial damageNTSB NYC92LA119Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Felton, PAA precautionary landing in unsuitable terrain. An additional cause was the failure of the mechanic to tighten the oil return line on the number three cylinder. A factor related to the accident was the pressure the mechanic felt to complete the job in a timely…Jun 16, 1992 · N21RE · Substantial damageNTSB NYC92FA117Accident · 3 fatalField investigationFinal reportBell 47-G4A · Shelburne Falls, MAThe pilot's failure to maintain adequate obstacle clearance. Contributing was inadequate altitude.Jun 16, 1992 · N1041B · DestroyedNTSB LAX92LA251Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Big Bear Lake, CAThe lose of engine power for undetermined reasons. The mountainous road on which the pilot attempted to land and the two motor vehicles that were on the road were factors in the accident.Jun 16, 1992 · N7133E · Substantial damageNTSB ATL92FA126Accident · No injuriesField investigationFinal reportAerospatiale AS-355-F · Fort Bragg, NCThe total blockage of the oil supply line for the rear main bearing in engine module three which resulted in the failure of the bearing, and the subsequent leak from the engine start drain valve.Jun 15, 1992 · N365DU · Substantial damageNTSB SEA92LA126Accident · No injuriesLimited investigationFinal reportBeech K35 · Sula, MTPoor inflight planning/decision. Factors to the accident were: delayed remedial action, a white out weather condition and inadequate clearance.Jun 14, 1992 · N212M · Substantial damageNTSB FTW92LA155Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Morgan City, LAThe second pilot's failure to maintain aircraft control.Jun 14, 1992 · N2620 · Substantial damageNTSB DEN92LA059Accident · No injuriesLimited investigationFinal reportCessna 177RG · Gunnison, COThe pilot's failure to maintain directional control. Factor(s) included: fuel exhaustion and the misjudging of fuel consumption calculations.Jun 14, 1992 · N52658 · Substantial damageNTSB MIA92LA137Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Atlantic Ocean (Atlantic Ocean)For undetermined reason(s), the right engine failed and the right propeller would not feather.Jun 13, 1992 · N402PB · Substantial damageNTSB LAX92LA243Accident · No injuriesLimited investigationFinal reportCessna 150 · Tucson, AZThe pilot's failure to follow v.f.r. procedures; inadequate preflight planning/preperation; and improper fuel consumption calculations which resulted in fuel exhaustion.Jun 12, 1992 · N6972G · Substantial damageNTSB LAX92FA242Accident · 3 fatalField investigationFinal reportCessna 172I · Chino Hills, CAThe pilot's poor weather evaluation and inflight decision to continue flight into instrument meteorological conditions in mountainous terrain.Jun 11, 1992 · N225EB · DestroyedNTSB NYC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Denton, MDThe failure of the pilot to detect the automobile gasoline in the tanks prior to departure, and intentional refueling with improper fuel by the pilot's brother which resulted in a lose of engine power due to detonation and loss of oil pressure.Jun 10, 1992 · N4552X · Substantial damageNTSB MIA92LA135Accident · Minor injuriesLimited investigationFinal reportHiller UH12C · Punta Gorda, FLThe pilot in command's failure to monitor fuel consumption and flight time resulting in exhaustion of fuel and engine failure. Contributing to the accident was the pilot in command's improper autorotation following engine failure which resulted in a hard…Jun 9, 1992 · N46937 · Substantial damageNTSB MIA92LA133Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Panama City, FLThe pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.Jun 9, 1992 · N5123Q · Substantial damageNTSB LAX92FA241Accident · 3 fatalField investigationFinal reportCessna 172P · Big Sur, CAPilot incapacition.Jun 9, 1992 · N5449K · DestroyedNTSB CHI92LA167Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Wyatt, MOAn improper decision during flight when the pilot in command overflew two suitable landing areas after a partial power loss in one engine. The mechanical deficiencies in the engines were factors in the engine.Jun 9, 1992 · N1050X · Substantial damageNTSB SEA92LA121Accident · No injuriesLimited investigationFinal reportMooney M20E · Freeland, WABlockage of the fuel injector servo system. Factors contributing to the accident were: fuel injection system corroded and animals in the landing area.Jun 7, 1992 · N5887Q · Substantial damageNTSB NYC92LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Danville, NYThe decision by the pilot to land during a heavy rain shower, which resulted in a long landing, and his attempted takeoff with insufficient available runway and subsequent loss of airplane control.Jun 7, 1992 · N98276 · Substantial damageNTSB FTW92FA152Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260B · Decatur, TXThe loss of engine power as the result of the failure of the engine oil pump. Factors were non compliance with a service bulletin, the lack of suitable terrain, and inadvertent stall.Jun 7, 1992 · N22FD · DestroyedNTSB ATL92GA121Accident · 2 fatalFinal reportEnstrom 280FX · Summerville, SCThe pilot's inadvertent flight into IMC, which resulted in an in flight collision with trees. Factors were the obscured sky and foggy weather conditions, and the night lighting conditions at the time of the accident.Jun 7, 1992 · N86262 · DestroyedNTSB MIA92LA130Accident · No injuriesLimited investigationFinal reportCessna 310-R · Summerfield, FLThe failure of the pilot-in-command to switch the fuel selectors in flight which caused both engines to fail due to fuel starvation. Contributing to the accident was the complacency of the pilot-in-command.Jun 6, 1992 · N69HS · Substantial damageNTSB CHI92LA163Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, MNThe pilot's improper preflight inspection.Jun 6, 1992 · N76028 · Substantial damageNTSB NYC92LA100Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Malvern, PAThe pilot abruptly moved the cyclic rearward which resulted in the main rotor blades striking and separating the tail boom. A factor in this accident was the soft muddy field.Jun 5, 1992 · N296Q · Substantial damageNTSB FTW92LA147Accident · No injuriesLimited investigationFinal reportCessna 182 · Coweta, OKThe total loss of engine power for undetermined reasons. Factors were the darkness of the night and the lack of suitable terrain available to the pilot for the forced landing.Jun 5, 1992 · N5381B · Substantial damageNTSB FTW92LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Henrietta, TXLoss of engine power from fuel exhaustion and the pilot's failure to refuel the airplane.Jun 4, 1992 · N68735 · Substantial damageNTSB LAX92LA232Accident · Serious injuriesLimited investigationFinal reportWayne K. Giles Glasair Garg · Valencia, CAThe loss of engine power because of an undetermined interruption in the flow of fuel to the engine. Factors which contributed to the power loss were related to fuel line or fitting leaks and to inadequate maintenance of the fuel system.Jun 3, 1992 · N555HV · Substantial damageNTSB ATL92IA113Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-1 · Atlanta, GAThe overheating of the number 2 air cycle machine which resulted in an emergency evacuation via slides; the failure of the flight attendants to secure the slide girt bars.Jun 2, 1992 · N718DA · No damageNTSB CHI92LA160Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Round Lake, ILThe pilot-in-command's failure to follow emergency procedures, and the fire in the electrical system for reasons undetermined.Jun 1, 1992 · N812PC · DestroyedNTSB ATL92FA111Accident · 1 fatalField investigationFinal reportCessna 152 · Lake Waccamaw, NCThe failure of the pilot to follow proper procedures while operating the aircraft in weather conditions favorable to carburetor icing. A factor in the accident was the weather condition, which was favorable for the formation of carburetor ice.Jun 1, 1992 · N757VN · Substantial damageNTSB LAX92LA228Accident · 1 fatalLimited investigationFinal reportCessna 172RG · Strawberry, AZThe pilot committed suicide due to the pilot's emotional state from interpersonal relations.May 31, 1992 · N9645B · DestroyedNTSB LAX92LA225Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus A/16.6 · Tucson, AZThe inflight disconnection of the right aileron 'otellier coupler fitting due to lubricants on the coupler slide lock plate, and the failure of the glider manufacturer to include appropriate precautionary information in the maintenance and/or flight manual.…May 31, 1992 · N8KS · DestroyedNTSB FTW94LA288Accident · 1 fatalLimited investigationFinal reportBeech 35-C33 · Lake City, COFlight by the pilot into adverse weather conditions, and his subsequent loss of aircraft control due to spatial disorientation. Factors related to the accident were: the adverse weather conditions, and the pilot's lack of instrument experience.May 31, 1992 · N2742T · DestroyedNTSB LAX92LA224Accident · No injuriesLimited investigationFinal reportHughes 369D · Volcanoes Ntl P, HIThe total loss of engine power due to a failure of the number 8 bearing. The bearing failure was caused by a lack of engine oil supply and inadequate maintenance.May 30, 1992 · N1100A · Substantial damageNTSB SEA92LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Monarch, MTThe pilot in command's disregard of the weather forecast and failure to maintain clearance with trees/terrain. Factors contributing to the accident were: hilly/mountainous terrain, weather conditions: rain, low ceilings and downdrafts, trees and the pilot in…May 29, 1992 · N6434R · DestroyedNTSB ATL92FA109Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Winnsboro, SCThe inadvertent flight into instrument meteorological conditions by the pilot. The dark night and fog were factors in the accident.May 29, 1992 · N5806K · DestroyedNTSB MIA92LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Miami, FLTotal loss of engine power due to improper placement of the fuel selector by the pilot-in-command following partial loss of engine power due to partial blockage of a fuel line. Contributing to the accident was the dark night condition and improper maintenance…May 28, 1992 · N5830U · Substantial damageNTSB ATL92LA112Accident · No injuriesLimited investigationFinal reportCessna 210F · Manteo, NCThe pilot's inadequate emergency procedures, in that he failed to note the discharge of electrical power on the ammeter, and his loss of directional control during the off airport landing. Factors were the disabled alternator and a low cloud ceiling.May 26, 1992 · N5811F · Substantial damage