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 DEN93LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Haswell, COFailure of the student pilot to maintain control of the aircraft during landing roll. Factors were: alternator failure, failure of the student pilot to follow procedures and directives, and failure of the student pilot to perform fuel consumption calculations.Jul 1, 1993 · N704QR · Substantial damageNTSB BFO93FA129Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · California, MDThe pilot initiating VFR flight in instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, his lack of sleep, and the existing weather conditions.Jul 1, 1993 · N5291L · DestroyedNTSB ATL93FA120Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clayton, ALInadequate maintenance and inspection of the carburetor by maintenance personnel.Jul 1, 1993 · N5473S · Substantial damageNTSB FTW93LA201Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Spring, TXThe pilot's improperly planned approach and the resultant overshoot of the intended landing area. Factors were the partial power loss due to internal corrosion, and the inadvertent stall.Jun 30, 1993 · N3740H · Substantial damageNTSB ATL93LA119Accident · Minor injuriesLimited investigationFinal reportWaco ATO · Alma, GAThe failure of the aircraft engine master rod bearing.Jun 30, 1993 · N13918 · Substantial damageNTSB FTW93LA198Accident · No injuriesLimited investigationFinal reportCessna 172G · Fort Worth, TXThe power loss for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the inadvertent stall.Jun 29, 1993 · N3987L · Substantial damageNTSB NYC93LA128Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ironton, OHThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Jun 27, 1993 · N9555 · Substantial damageNTSB LAX93LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Danville, CAThe pilot's poor fuel consumption calculations. Contributing to this accident was the downsloping terrain.Jun 27, 1993 · N2791U · Substantial damageNTSB LAX93LA267Accident · No injuriesLimited investigationFinal reportRyan ST-A · Fresno, CAThe pilot's failure to maintain directional control. Contributing to this accident was the partial loss of power for undetermined reasons, the high runway vegetation, and the left quartering tailwind.Jun 26, 1993 · N14987 · Substantial damageNTSB CHI93LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172C · West Chicago, ILthe pilot's improper use of carburetor heat. Conditions conducive to the formation of carburetor ice was a factor.Jun 26, 1993 · N1441Y · Substantial damageNTSB DEN93LA069Accident · 1 fatalLimited investigationFinal reportIrving Siewert Osprey GP-4 · Canon City, COFailure by the pilot/builder to follow construction specifications and the use of improper materials during construction of the aircraft.Jun 25, 1993 · N85Z · DestroyedNTSB ATL93LA116Accident · No injuriesLimited investigationFinal reportGrumman G164A · Brundidge, ALThe broken carburetor accelerator pump piston rivet which lodged under the needle valve, allowed the float chamber to flood with fuel, and the engine to quit. The lack of suitable terrain for a forced landing was a factor.Jun 25, 1993 · N48584 · Substantial damageNTSB CHI93LA224Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Baraboo, WIan encounter with moderate turbulence in the clouds.Jun 24, 1993 · N579UA · No damageNTSB ATL93LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Statesville, NCThe improper use of carburetor heat by the pilot. A factor in the accident was the carburetor icing conditions.Jun 24, 1993 · N7817X · Substantial damageNTSB ANC93LA101Accident · No injuriesLimited investigationFinal reportGrumman American AA5A · Comet Mine, AKLoss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain on which an emergency landing could be made successfully.Jun 24, 1993 · N9765U · Substantial damageNTSB CHI93LA219Accident · No injuriesLimited investigationFinal reportBeech B19 · Victoria, MNThe loss of engine power due to a jammed carburetor float and the inability of the pilot to maintain clearance during the emergency landing.Jun 23, 1993 · N2157W · Substantial damageNTSB LAX93LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Camarillo, CAFuel exhaustion due to the inadequate preflight fuel consumption planning, the inadequate en route fuel consumption calculations, and the failure of the pilot to stop en route for fuel.Jun 21, 1993 · N9539T · Substantial damageNTSB LAX93LA263Accident · Minor injuriesLimited investigationFinal reportSill/Thomas Long EZ · Lone Pine, CAthe failure of the number four cylinder exhaust valve due to excessive heat exposure and lack of maintenance.Jun 20, 1993 · N977ST · Substantial damageNTSB CHI93LA217Accident · No injuriesLimited investigationFinal reportCessna P210 · Pulaski, ILthe pilot's improper fuel tank selection resulting in fuel starvation. A factor in the accident is the soft emergency landing surface.Jun 20, 1993 · N4813P · Substantial damageNTSB CHI93LA215Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilton, NDFailure of the engine-driven fuel pump. A factor was the pilot's failure to select the auxiliary fuel pump.Jun 20, 1993 · N60454 · Substantial damageNTSB NYC93LA120Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Palmer, MAThe loss of engine power for undetermined reasons. A factor was lack of suitable terrain for the forced landing.Jun 19, 1993 · N8664Q · Substantial damageNTSB CHI93LA216Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Malden, MOA broken mixture control cable resulting in fuel starvation.Jun 19, 1993 · N9941U · Substantial damageNTSB ANC93LA100Accident · No injuriesLimited investigationFinal reportCessna 180 · Merrill Pass, AKThe pilot-in-command's inadequate fuel calculations.Jun 19, 1993 · N7627A · Substantial damageNTSB NYC93LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Holbrook, NYThe engine failure as the result of a fractured crankshaft due to metal fatigue.Jun 18, 1993 · N735CA · DestroyedNTSB ANC93LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Juneau, AKThe pilot continuing VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the mountainous terrain, the cloudy weather conditions in the pass, the pilot becoming disoriented, his lack of familiarity with the…Jun 18, 1993 · N30505 · Substantial damageNTSB NYC93FA115Accident · 1 fatalField investigationFinal reportEnstrom F28C · Gordon, KYThe pilot's failure to see and avoid the wire.Jun 17, 1993 · N200NH · DestroyedNTSB FTW93LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Navasota, TXPartial power loss due to left magneto fluctuating due to loose coil. A factor was the lack of suitable terrain for the forced landingJun 16, 1993 · N11069 · Substantial damageNTSB MIA93LA143Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Orlando, FLUnsuitable terrain encountered during the autorotative forced landing. Contributing to the accident was total loss of engine power due to seizure of the compressor impeller following failure of the no.2 bearing for undetermined reasons.Jun 15, 1993 · N500RT · Substantial damageNTSB ATL93IA111Incident · No injuriesIncident investigationFinal reportSikorsky S-76A · Cullman, ALThe failure of company maintenance personnel to properly inspect the tail rotor control cable at the last 750 hour inspection, and the subsequent total failure of the cable due to wear.Jun 15, 1993 · N110AL · No damageNTSB NYC93IA113Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60-200 · Atlantic City, NJA malfunction of the cargo fire warning system which resulted in a false alarm.Jun 14, 1993 · N711HJ · No damageNTSB CHI93LA212Accident · Serious injuriesLimited investigationFinal reportEnstrom F-28C · Buckner, MOThe nut backing off the connecting rod bolt resulting in rod failure. A factor involved in this accident was the lack of suitable terrain for the pilot in command to make a run on landing.Jun 14, 1993 · N51717 · Substantial damageNTSB SEA93LA129Accident · Minor injuriesLimited investigationFinal reportCessna T210K · Forest Grove, ORLoss of engine power due to fuel exhaustion, resulting from inadequate preflight planning/preparation by the PIC.Jun 13, 1993 · N8120G · Substantial damageNTSB LAX93LA247Accident · 2 fatalLimited investigationFinal reportTucker Thorp T18C · So. Lake Tahoe, CAA total loss of engine power for undetermined reasons, and the failure of the pilot to maintain control of the aircraft while maneuvering at a low altitude.Jun 13, 1993 · N794PT · DestroyedNTSB FTW93LA188Accident · No injuriesLimited investigationFinal reportReims Cessna FA 150K · Willis, TXLoss of partial engine power due to stuck exhaust valve and exhaust and intake valve binding with carbon buildup. A factor was the lack of suitable terrainJun 13, 1993 · N922SZ · Substantial damageNTSB ANC93IA093Incident · No injuriesIncident investigationFinal reportCessna 206 · Portage, AKThe failure of the number two cylinder connecting rod bearing due to the shifting of the bearing within its journal race which produced an oil starvation/thermal distress event.Jun 13, 1993 · N4672U · Minor damageNTSB LAX93LA254Accident · No injuriesLimited investigationFinal reportCessna 150L · Yucaipa, CAthe flight instructor's selection of unsuitable terrain for the forced landing demonstration. A factor in the accident was the high density altitude existing at the time of the mishap.Jun 12, 1993 · N19507 · Substantial damageNTSB DEN93LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Livermore, COA partial power loss when the rocker box for one cylinder disengaged. A factor was: unsuitable terrain for a forced landing.Jun 11, 1993 · N4829E · Substantial damageNTSB FTW93FA185Accident · No injuriesField investigationFinal reportConvair 440 · Greenville, TXThe pilot-in-command's failure to follow the published emergency procedures. Factors were engine fire warning system activating for undetermined reasons, and the resultant ac power loss when that engine was secured. The lack of recent expereince in type…Jun 9, 1993 · N580HH · Substantial damageNTSB CHI93FA200Accident · 2 fatalField investigationFinal reportBeech A-36 · Tony, WIthe pilot's decision to continue flight into known adverse weather and exceeded the design strees limits of the airplane. Factors associated with the accident were inadequate preflight planning/preparation, clouds, turbulence, icing conditions, and the lack…Jun 9, 1993 · N236A · DestroyedNTSB LAX93IA245Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Los Angeles, CAthe inadvertent deployment of an overwing emergency excape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel. A factor in the accident was the inadequate door closing procedure specified by the…Jun 8, 1993 · N540UA · Minor damageNTSB NYC93LA104Accident · No injuriesLimited investigationFinal reportCessna 150J · West Caldwell, NJThe complete loss of engine power as a result of carburetor icing, the subsequent forced landing and impact with the terrain.Jun 7, 1993 · N60186 · Substantial damageNTSB LAX93LA244Accident · 1 fatalLimited investigationFinal reportBeech K-35 · Eureka, NVThe pilot disregarding the advice that visual flight rules were not recommended; the pilot's inadequate weather evaluation along his route of flight; the pilot attempting flight into known adverse weather conditions; the pilot's loss of aircraft control due…Jun 6, 1993 · N672T · DestroyedNTSB LAX93FA242Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Diablo, CAThe pilot in command's continued flight into instrument meteorological conditions, and the improper in flight planning and decision making by the pilot.Jun 6, 1993 · N522T · DestroyedNTSB CHI93LA197Accident · No injuriesLimited investigationFinal reportCessna 210L · Indianola, IAA fatigue fracture of the crankshaft.Jun 6, 1993 · N2267S · Substantial damageNTSB ATL93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Ridgeland, SCThe pilot's improper use of carburetor heat, which resulted in a partial loss of engine power. Factors were the carburetor icing conditions, and the soft terrain at the forced landing site.Jun 6, 1993 · N50000 · Substantial damageNTSB CHI93DEE01Accident · No injuriesFinal reportMark Streitz Skybolt · Joliet, ILthe failure of the number two connecting rod bolt.Jun 5, 1993 · N94MS · Substantial damageNTSB NYC93LA099Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Leesport, PAThe loss of engine power for undetermined reasons, which resulted in forced landing and collision with trees.Jun 4, 1993 · N73SM · DestroyedNTSB LAX93FA246Accident · 4 fatalField investigationFinal reportBeech S35 · Lovelock, NVThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the adverse weather conditions and mountainous terrain.Jun 4, 1993 · N5865J · DestroyedNTSB FTW93FA176Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Texhoma, TXThe pilot's flight into known adverse weather conditions. Factors were the weather, the dark night, the airplane's lack of flight and navigational equipment, and the pilot's lack of instrument training and experience.Jun 4, 1993 · N57592 · DestroyedNTSB CHI93LA192Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Chicago, ILThe pilot in command's improper in-flight planning/decision.Jun 4, 1993 · N345AT · No damage