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 SEA93FA179Accident · 1 fatalField investigationFinal reportCessna 172N · Lake Fork, IDPoor judgment of the pilot by flying while under the influence of alcohol and a drug, his continued flight into an area of adverse weather, and his failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors related to the accident…Aug 21, 1993 · N75644 · DestroyedNTSB CHI93DEP04Accident · No injuriesFinal reportJordi, Ronald H. Challenger II · Plymouth, WIthe loss of engine power for undetermined reason(s).Aug 21, 1993 · N771RH · Substantial damageNTSB ATL93LA146Accident · No injuriesLimited investigationFinal reportCessna 150H · Monroe, NCWas the pilot's failure to determine actual fuel consumption enroute. A factor was inadequate supervision by the instructor pilot.Aug 21, 1993 · N6933S · Substantial damageNTSB ATL93LA145Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Hilton Head Is, SCA loss of engine power for undetermined reasons.Aug 21, 1993 · N104CB · Substantial damageNTSB NYC93LA164Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Westerly, RIThe loss of engine power for undetermined reasons, and the subsequent forced landing and collision with soft terrain.Aug 20, 1993 · N1547R · DestroyedNTSB NYC93LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Hope Valley, RIThe engine failure as the result of ingestion of pieces of carburetor into the cylinders, and the subsequent forced landing and nose over during the landing roll after encountering soft terrain.Aug 19, 1993 · N9845J · Substantial damageNTSB LAX93LA330Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Showlow, AZA total loss of engine power due to a separation of the mixture control balljoint assembly at the carburetor mixture arm and subsequent forced landing.Aug 19, 1993 · N9533J · Substantial damageNTSB LAX93LA329Accident · No injuriesLimited investigationFinal reportPiper PA-34-220 · Pacific Ocean (Pacific Ocean)The loss of oil pressure to both engines for undetermined reasons.Aug 19, 1993 · N1232H · DestroyedNTSB ANC93FA152Accident · Minor injuriesField investigationFinal reportDe Havilland DHC-3 · Nikabuna Lake, AKFluid, fuel starvation as a result of the pilot-in-command's improper in-flight planning/decision. A factor in the accident was the operator's inadequate flight time and fuel upload record keeping.Aug 19, 1993 · N321KA · DestroyedNTSB SEA93FA178Accident · No injuriesField investigationFinal reportEnstrom F-28C · Seattle, WAShorted magneto condensers. Factors include a hidden obstruction in the landing area, and a reduction in rotor RPM from attempting to avoid the obstruction.Aug 18, 1993 · N86198 · Substantial damageNTSB LAX93LA327Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Dos Palos, CAThe failure of the master rod which resulted in a complete loss of engine power and subsequent forced landing. The irrigation ditch was a factor in this accident.Aug 18, 1993 · N2330V · Substantial damageNTSB FTW93IA242Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B16 · San Antonio, TXThe fracture of the rudder quadrant due to stress corrosion. A factor was the manufacturer's improper selection of material.Aug 17, 1993 · N392PT · No damageNTSB MIA93LA175Accident · Serious injuriesLimited investigationFinal reportRotec Engineering Rotec Rally 3 · Jay, FLFailure of the pilot in command to maintain airspeed (vs), inadvertent stall/mush by the pilot in command, and altitude insufficient for recovery. Contributing to the accident was lack of total experience by the pilot in command and in flight encounter with…Aug 16, 1993 · N145RE · Substantial damageNTSB FTW93LA240Accident · No injuriesLimited investigationFinal reportCessna 177B · Houston, TXEngine power loss due to fuel exhaustion for undetermined reasons. Factors were the pilot's failure to monitor and recalculate fuel consumption en route and the lack of suitable terrain onto which the forced landing could have been executed.Aug 16, 1993 · N34689 · Substantial damageNTSB ANC93LA150Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Galena, AKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain on which to make a forced landing.Aug 16, 1993 · N86361 · Substantial damageNTSB NYC93LA156Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Lawrence, MAThe improper installation of the battery box cover by maintenance personnel.Aug 15, 1993 · N30393 · Substantial damageNTSB NYC93LA155Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Lyndonville, VTAn inadvertent stall of the airplane as a result of the pilot's failure to maintain adequate airspeed and improper use of the carburetor heat and flaps during takeoff which degraded aircraft performance.Aug 15, 1993 · N2807S · Substantial damageNTSB LAX93LA323Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Chico, CAthe observer's failure to properly secure stowed items in the rear compartment prior to takeoff and the resultant foreign object damage to the tail rotor system which precluded the pilot from maintaining directional control.Aug 15, 1993 · N8606F · Substantial damageNTSB ANC93LA147Accident · No injuriesLimited investigationFinal reportCessna 185 · Point Barrow, AKFuel exhaustion as a result of the pilot in command's not refueling. A factor in the accident was the operator/management inadequate flight following and operational control over the flight.Aug 14, 1993 · N20752 · Substantial damageNTSB ANC93LA146Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nome, AKFuel exhaustion due to the pilot in commands improper preflight planning/preparation.Aug 14, 1993 · N6SF · DestroyedNTSB LAX93FA318Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Honolulu, HIA divergence of the main rotor from its normal plane of rotation for an undetermined reason(s) which resulted in rotor contact with the airframe.Aug 11, 1993 · N4017J · DestroyedNTSB FTW93LA236Accident · No injuriesLimited investigationFinal reportBeech F35 · Mena, ARThe inflight separation of the ruddervator as result of improper balancing.Aug 11, 1993 · N5064B · Substantial damageNTSB LAX93LA317Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Julian, CAThe pilot's poor inflight decision in selecting an altitude insufficient to ensure adequate terrain clearance.Aug 10, 1993 · N45552 · DestroyedNTSB CHI93LA315Accident · No injuriesLimited investigationFinal reportCessna 152 · Montgomery, ILThe pilot became disoriented resulting in loss of engine power due to fuel exhaustion. The dark night light condition was a factor.Aug 10, 1993 · N102CF · Substantial damageNTSB FTW93LA234Accident · No injuriesLimited investigationFinal reportCessna 177B · Grand Prairie, TXLoss of engine power due to fuel starvation as a result of a leaking fuel line. The fuel line was not the correct part as a result of a misidentification by Cessna.Aug 9, 1993 · N34293 · Substantial damageNTSB FTW93FA235Accident · 1 fatalField investigationFinal reportMooney M20C · Big Lake, TXThe pilot's failure to maintain terrain clearance.Aug 9, 1993 · N5672Q · DestroyedNTSB DEN93FA101Accident · Serious injuriesField investigationFinal reportThunder and Colt 240A · Woody Creek, COAn inflight encounter with high winds which required a precautionary landing.Aug 8, 1993 · N748TC · Substantial damageNTSB DEN93FA100Accident · 6 fatalField investigationFinal reportCameron N-145 · Woody Creek, COFailure by the pilot in command to maintain proper altitude and visual lookout. A factor was high wind.Aug 8, 1993 · N4141D · Substantial damageNTSB SEA93LA174Accident · 2 fatalLimited investigationFinal reportBrauch Glasair · Blanding, UTThe loss of engine power resulting from inadequate maintenance inspection by the pilot, a leak from loose fuel system line fittings, and fuel exhaustion. A factor relating to the accident was the rough/uneven terrain.Aug 7, 1993 · N365WB · DestroyedNTSB NYC93FA145Accident · 2 fatalField investigationFinal reportCurtiss-Wright Travel AIR 4000 · Marlboro, NJThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and inflight collision with the terrain.Aug 7, 1993 · NC365M · DestroyedNTSB ATL93LA142Accident · 1 fatalLimited investigationFinal reportWM. D. Butterill Mustang M1 · Wadesboro, NCThe pilot's intentional flight into IMC without the proper instrumentation, which resulted in the pilot's loss of aircraft control, and in flight breakup of the airplane.Aug 7, 1993 · CFYSJ · Substantial damageNTSB DEN93FA099Accident · 6 fatalField investigationFinal reportPiper PA-32-300 · Delight, ARThe failure of the vacuum pump, and an inoperative turn coordinator. Factors which contributed to the accident were: the pilot's loss of control of the airplane as a result of spatial disorientation, the pilot exceeding the design stress limits of the…Aug 6, 1993 · N479KC · DestroyedNTSB CHI93LA313Accident · No injuriesLimited investigationFinal reportCessna 150M · Blue Rapids, KSthe loss of engine power for an undetermined reason.Aug 6, 1993 · N714LZ · Substantial damageNTSB MIA93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cape Canaveral, FLLoss of engine power for an undetermined reason.Aug 5, 1993 · N7540 · Substantial damageNTSB CHI93DEE04Accident · 1 fatalFinal reportDarst KR-1 · Oregon, ILthe partial separation of the elevator control cable.Aug 5, 1993 · N585D · DestroyedNTSB FTW93LA228Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXPilot's failure to maintain proper rotor RPM, the delayed flare, and improper touchdown. Factors were total failure of the power turbine due to oil starvation to the #8 bearing assembly.Aug 4, 1993 · N16814 · Substantial damageNTSB CHI93DEP03Accident · No injuriesFinal reportKit Fox IV · Green Bay, WIthe improper modification of the fuel system by the pilot-in-command. A factor was bockage of the fuel system screen.Aug 4, 1993 · N127RF · Substantial damageNTSB ANC93FA134Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Atigun Pass, AKThe pilot-in-command's intentional VFR flight into instrument meteorological conditions and his unfamiliarity with the geographical area. Factors were the rain and fog.Aug 4, 1993 · N477JC · DestroyedNTSB NYC93LA141Accident · Minor injuriesLimited investigationFinal reportGera Nieuport II · Somerville, NJThe loss of engine power for undetermined reasons.Aug 3, 1993 · N44030 · Substantial damageNTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…Aug 3, 1993 · N2093A · DestroyedNTSB FTW93LA226Accident · Serious injuriesLimited investigationFinal reportSukane KR-2 · Clines Corners, NMThe pilot's inadvertent VFR flight into IMC and failure to maintain proper altitude. Factors were fog, rain, and the pilot's failure to obtain a weather brief.Aug 3, 1993 · N88PS · DestroyedNTSB DEN93LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Timpson, TXThe pilot in command's failure to refuel resulting in fuel exhustion. Factors were: the lack of suitable terrain for the forced landing, and dark night light conditions.Aug 3, 1993 · N4816B · Substantial damageNTSB DEN93FA097Accident · 1 fatalField investigationFinal reportCessna 172M · Clines Corners, NMThe pilot's failure to maintain a safe and proper altitude. Factors were the pilot's failure to obtain a preflight weather briefing, dark night condition, and weather conditions that included obscuration, fog, and drizzle.Aug 3, 1993 · N23459 · DestroyedNTSB ATL93LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moncks Corner, SCFailure of the number one cylinder at the cylinder flange radius.Aug 2, 1993 · N7027P · Substantial damageNTSB FTW93LA224Accident · No injuriesLimited investigationFinal reportCessna 150M · Bald Knob, ARFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Aug 1, 1993 · N66081 · Substantial damageNTSB LAX93LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fresno, CAThe pilot's inadequate flare and his improper recovery from the resulting bounced landing. Factors related to this accident were the alternator failure and the night condition.Jul 31, 1993 · N3053N · Substantial damageNTSB LAX93LA310Accident · Minor injuriesLimited investigationFinal reportNall Varieze · Newark, CAImproper annual inspection performed by other maintenance personnel. Factors relating to this accident were the loose exhaust bolts.Jul 31, 1993 · N75PD · DestroyedNTSB DEN93LA092Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Galveston, TXThe disconnection of the throttle linkage and the resultant power loss. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1993 · N8161V · Substantial damageNTSB CHI93LA295Accident · Minor injuriesLimited investigationFinal reportGardner SEA RAY · Oshkosh, WIThe pilot in command's not maintaining proper climb rate. A factor was the abrupt control interference by the passenger.Jul 31, 1993 · N703SR · Substantial damageNTSB CHI93LA300Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Ortonville, MNthe pilot's failure to refuel prior to fuel exhaustion.Jul 30, 1993 · N8521E · Substantial damage