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 CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.Jul 30, 1993 · N8163A · Substantial damageNTSB ATL93LA137Accident · 1 fatalLimited investigationFinal reportWard Long EZE · Murfreesboro, TNThe pilot's failure to properly use the carburetor heat control which resulted in the formation of carburetor ice.Jul 29, 1993 · N850JW · Substantial damageNTSB FTW93LA219Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Vidor, TXControl cable separation due to the throttle power lever linkage not being secured by retainer resultant from improper installation. A factor was a lack of suitable terrain for the forced landing.Jul 27, 1993 · N4134X · Substantial damageNTSB DEN93FA089Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Durango, COThe pilot's entry into a box canyon at an altitude insufficient to clear mountainous terrain.Jul 27, 1993 · N3783K · DestroyedNTSB CHI93LA288Accident · No injuriesLimited investigationFinal reportMurphy Rebel · Pickett, WIThe pilot's inadequate preflight planning which resulted in fuel exhaustion. The lack of suitable terrain for a forced landing was a factor in the accident.Jul 27, 1993 · CFNVM · Substantial damageNTSB LAX93FA377Accident · 3 fatalField investigationFinal reportBeech F33A · Baker, CAA loss of control for undetermined reason(s).Jul 26, 1993 · N3022W · DestroyedNTSB MIA93LA164Accident · Serious injuriesLimited investigationFinal reportMaxair AVR-582 · Wimauma, FLThe pilot-in-commands failure to maintain airspeed while making a forced landing following loss of engine power resulting in the aircraft stalling and descending uncontrolled to the ground.Jul 25, 1993 · UNREG · Substantial damageNTSB FTW93LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Purcell, OKThe lack of suitable terrain onto which to execute the forced landing which was neccesitated by the partial power loss. The power loss was a result of the fatigue failure of the exhaust valve rocker arm attachment stud. A factor was the night conditions.Jul 25, 1993 · N4884G · Substantial damageNTSB SEA93LA160Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Jerome, IDThe pilot's improper fuel management procedures which resulted in fuel starvation. Factors include the pilot's lack of familiarity with this type aircraft, and rough/uneven terrain in the landing area.Jul 24, 1993 · N2269X · Substantial damageNTSB MIA93LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLA reported partial loss of engine power for undetermined reasons, resulting in a forced landing and subsequent ditching in the ocean.Jul 24, 1993 · N6091M · Substantial damageNTSB CHI93IA280Incident · No injuriesIncident investigationFinal reportCanadair CL600-2B19 · Danville, ILa lightning strike and associated engine flameout.Jul 24, 1993 · N915CA · Minor damageNTSB ATL93LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Pelion, SCThe pilot's improper weather evaluation prior to commencing the flight. Factors were the fog and low ceiling weather conditions, and the rough, uneven terrain at the landing siteJul 24, 1993 · N6197T · Substantial damageNTSB CHI93FA272Accident · Serious injuriesField investigationFinal reportCessna 172N · Long Grove, ILThe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. Related factors to the accident were: inadequate certification/approval of the STC by the FAA, inadequate performance data, and unavailable fuel consumption information.Jul 23, 1993 · N733XS · Substantial damageNTSB ATL93LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Atmore, ALThe total failure of the engine supercharger, which resulted in engine stoppage. A factor was the rough terrain at the forced landing site.Jul 23, 1993 · N4824 · Substantial damageNTSB LAX93LA295Accident · Minor injuriesLimited investigationFinal reportCurry Varieze · Bisbee, AZThe pilot's improper use of the carburetor heat. The carburetor icing conditions were a factor.Jul 22, 1993 · N183RC · Substantial damageNTSB CHI93LA268Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Elderon, WIThe pilot's failure to refuel the helicopter.Jul 22, 1993 · N9010C · Substantial damageNTSB ATL93LA131Accident · Minor injuriesLimited investigationFinal reportAero Commander 112 · Broadway, NCWater and contaminants in the aircraft fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the rough terrain at the forced landing site.Jul 21, 1993 · N1035J · Substantial damageNTSB ANC93FA123Accident · Serious injuriesField investigationFinal reportCessna A185F · Denali Nat'L Pk, AKFuel exaustion due to the the pilot-in-command's failure to refuel. Factors in the accident were: pressure by management personnel and lack of suitable terrain during the forced landing.Jul 21, 1993 · N124KT · DestroyedNTSB BFO93FA131Accident · 1 fatalField investigationFinal reportBeech C33A · Paintsville, KY1) Fatigue failure of the engine crankshaft at the number 2 main journal due to undetermined reason (s) which resulted in the total loss of engine power, and 2) the pilot not maintaining an adequate airspeed which resulted in an inadvertent stall/spin. A…Jul 20, 1993 · N3722Q · DestroyedNTSB MIA93LA158Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Atlantic Ocean (Atlantic Ocean)Total loss of engine power due to fuel exhaustion. Contributing to the accident was inaccurate fuel comsumption calculations by the pilot-in-command.Jul 19, 1993 · N99BW · DestroyedNTSB FTW93LA262Accident · No injuriesLimited investigationFinal reportZbacnick Challenger II · Alamogordo, NMThe seizure of the propeller shaft bearing and the resultant propeller blade separation. Factors were the unfavorable winds and the lack of suitable terrain available for the forced landing.Jul 18, 1993 · N851BZ · Substantial damageNTSB BFO93LA126Accident · Serious injuriesLimited investigationFinal reportCessna 172D · New Milford, PALoss of engine engine power due to water contamination of the fuel. Factors related to the accident were the mice, which partially blocked fuel and air flow to the carburetor, and the lack of suitable terrain in the emergency landing area.Jul 17, 1993 · N2494U · Substantial damageNTSB MIA93LA157Accident · Serious injuriesLimited investigationFinal reportBoeing 767-322ER · Caribbean SeaTurbulence encountered during cruise flight after entering Cirrus clouds.Jul 16, 1993 · N645UA · No damageNTSB BFO93LA125Accident · Serious injuriesLimited investigationFinal reportHancock- Harris Pitts Special · Independent Hil, VAThe pilot's inadequate preflight planning/preparation which resulted in fuel exhaustion and subsequent loss of engine power.Jul 16, 1993 · N3186 · Substantial damageNTSB CHI93LA256Accident · Minor injuriesLimited investigationFinal reportQuad City Challenger II Specia · Ottawa, ILThe pilot in command's failure to maintain proper clearance. Factors to the accident include an oil fouled spark plug and a power ground cable.Jul 13, 1993 · N415JR · Substantial damageNTSB SEA93LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Arlington, WYFuel contamination, directives not followed by the pilot in command, and his premature flare.Jul 12, 1993 · N3774W · Substantial damageNTSB LAX93LA288Accident · 2 fatalLimited investigationFinal reportRobinson R22B · Weimar, CAThe failure of both pilots to see and avoid the charted power line. Factors which contributed to the accident were: the failure of the utility companies to adequately review the hazard posed by the wires following a previous collision at the same location,…Jul 12, 1993 · N531JD · DestroyedNTSB CHI93LA250Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Harvel, ILThe pilot-in-command's inadequate preflight planning.Jul 12, 1993 · N4201Y · DestroyedNTSB BFO93LA121Accident · No injuriesLimited investigationFinal reportCessna 404 · Cincinnati, OHThe failure of a number three engine cylinder hold down bolt due to fatigue.Jul 12, 1993 · N37167 · Substantial damageNTSB MIA93LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Atlantic Ocean (Atlantic Ocean)Total loss of engine power from both engines due to fuel exhaustion after the pilot became lost/disoriented. Contributing to the accident was the delay by the pilot-in-command to execute the emergency procedure by resetting the alternators and voltage…Jul 10, 1993 · N36L · DestroyedNTSB CHI93LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Senter, MIThe pilot-in-command's inadequate pre-flight planning. Factors relating to this accident are fuel exhaustion, unsuitable terrain on which to make an emergency landing, as well as an inadvertent stall.Jul 10, 1993 · N1630H · Substantial damageNTSB CHI93IA248Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Detroit, MIthe failure of a navigation system (#1 INS) for reason or reasons undetermined.Jul 10, 1993 · N158US · No damageNTSB CHI93LA253Accident · Minor injuriesLimited investigationFinal reportCessna 210 · West Bend, WIThe inadequate preflight by pilot-in-command. A factor was the rough terrain.Jul 9, 1993 · N50RD · Substantial damageNTSB ANC93IA115Incident · No injuriesIncident investigationFinal reportCessna 207 · Nome, AKThe chafed fuel line and chafed electrical wire and the improper maintenance procedure used to secure the electrical wire with a tie wrap.Jul 9, 1993 · N9984M · Minor damageNTSB ANC93FA114Accident · 4 fatalField investigationFinal reportPiper PA-16 · Fairbanks, AKFailure of the pilots of both airplanes to see and avoid each other, and the alcohol impairment of the pilot-in-command of the PA-16, N5960H. A factor which contributed to the accident was the sunglare.Jul 9, 1993 · N5960H · 2 aircraft · Substantial damageNTSB SEA93LA150Accident · No injuriesLimited investigationFinal reportHoopes Hummelbird · Salt Lake City, UTA fractured crankshaft.Jul 8, 1993 · N2227S · Substantial damageNTSB MIA93LA151Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Magee, MSInstallation of an incorrect oil filter adapter plate stud which secures the plate to the accessory case.Jul 8, 1993 · N3896H · Substantial damageNTSB DEN93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Grand Junction, COFailure of the pilot in command to follow manual gear extension procedures. A factor was a total electrical failure.Jul 8, 1993 · N8967P · Substantial damageNTSB SEA93LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Friday Harbor, WAFuel starvation and poor in-flight planning/decision.Jul 7, 1993 · N4084S · Substantial damageNTSB BFO93FA113Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Madison Heights, VAEngine failure due to oil starvation as a result of inadequate maintenance and inspection of the oil cooler lines.Jul 7, 1993 · N7443P · DestroyedNTSB CHI93LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bloom, KSimproper refueling by a person or persons unknown. A factor was deteriorated fuel.Jul 6, 1993 · N8633W · Substantial damageNTSB BFO93LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Normalville, PAThe presence of carburetor icing conditions, which caused a total loss of engine power. A factor related to the accident was the pilot's delayed use of carburetor heat and rough terrain.Jul 6, 1993 · N7954U · Substantial damageNTSB LAX93LA276Accident · 1 fatalLimited investigationFinal reportCurtis Rans S-12 · Samoa, CAThe inadvertent stall of the airplane. Factors related to this accident were: the emergency parachute system that was deployed by the pilot, the partial failure of the parachute survival equipment to deploy properly, and the insufficient information provided…Jul 4, 1993 · N410ZE · Substantial damageNTSB LAX93LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Moccasin, CAFuel exhaustion due to the pilot's failure to perform fuel consumption calculations. Factors related to this accident were: the pilot's inadequate preflight or inflight planning and preparation.Jul 4, 1993 · N7875T · Substantial damageNTSB FTW93LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lancaster, TXFuel exhaustion engine power loss due to the inadequate fuel supply for the flight. A factor was the lack of suitable terrain for the forced landingJul 4, 1993 · N54003 · Substantial damageNTSB BFO93FA107Accident · Serious injuriesField investigationFinal reportUS/Lta 138S Airship · New York, NYInadequate design of, and design standards for, the airship which resulted in an envelope failure following separation of a portion of the night sign equipment.Jul 4, 1993 · N832US · DestroyedNTSB MIA93LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tampa, FLthe improper welding/repair by maintenence personnel of the exhaust system, which eventually failed allowing hot exhaust gasses and flame to burn a fuel line and start a fire.Jul 2, 1993 · N4106M · DestroyedNTSB LAX93LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Malibu, CAthe inadequate annual inspection by other maintenance personnel and the worn fuel selector valve shaft. Contributing to this accident was the loss of power due to fuel starvation.Jul 2, 1993 · N8058P · Substantial damageNTSB LAX93FA272Accident · 1 fatalField investigationFinal reportBell 47G2-M · S. Sn Francisco, CAThe pilot's inadequate preflight planning/preparation which resulted in flight into high winds, turbulence and windshear.Jul 2, 1993 · N2473B · DestroyedNTSB FTW93LA202Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Lampasas, TXFuel exhaustion engine power loss due to an inadequate preflight preparation. A factor was the lack of suitable terrain for the forced landingJul 2, 1993 · N2446U · Substantial damage