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 ATL94FA029Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Covington, GASpatial disorientation experienced by the pilot, resulting in his failure to maintain aircraft control. Factors were the total failure of the engine driven vacuum pump, and the night, cloud conditions prevailing at the time of the accident.Dec 10, 1993 · N8340Y · DestroyedNTSB NYC94LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Christianburg, VAThe pilot's improper use of carburetor heat which prevented the accumulation of carburetor ice and resulted in the loss of engine power. A factor was unsuitable terrain.Dec 9, 1993 · N49215 · Substantial damageNTSB CHI94LA047Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Ashley, INInadequate aircraft preflight by the pilot-in-command. A factor relating to this accident is the dark night.Dec 9, 1993 · N210MD · Substantial damageNTSB MIA94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tupelo, MSThe pilot-in-commands failure to monitor fuel consumption.Dec 5, 1993 · N2382T · Substantial damageNTSB FTW94FA044Accident · 1 fatalField investigationFinal reportUpton Mustang M-II · Guthrie, OKWas the in flight failure of the left aileron for reasons undetermined.Dec 5, 1993 · N4YP · DestroyedNTSB NYC94LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · North Haven, METhe pilot's use of excessive speed and altitude during the approach which resulted in a landing overrun of the runway. Factors were a precautionary landing and a ravine.Dec 4, 1993 · N55719 · Substantial damageNTSB LAX94LA063Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Santa Paula, CAwas the failure of the needle valve pin assembly in the airplane's carburetor. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.Dec 3, 1993 · N89014 · Substantial damageNTSB NYC94FA028Accident · 2 fatalField investigationFinal reportPiper PA-31T · Norwich, OHThe pilot's loss of aircraft control for an unknown reason, and subsequent flight that exceeded the design stress limits of the airplane, which resulted in an in-flight airframe breakup.Dec 2, 1993 · N515WB · DestroyedNTSB LAX94LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Fallon, NVthe pilot's intentional continued flight into known adverse weather conditions.Nov 30, 1993 · N4081W · DestroyedNTSB LAX94FA278Accident · 2 fatalField investigationFinal reportMooney M20K · June Lake, CAThe pilot allowed the airplane to exceed its design limits (airspeed and/or stress limits) after inadvertently entering a descent. Factors relating to the accident were: darkness (night or late dusk), the pilot's failure to assure adequate…Nov 30, 1993 · N5788U · DestroyedNTSB BFO94LA022Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Waynesburg, PAThe pilot's inadequate preflight and inflight preparations, planning and decisions. The lack of suitable terrain for the forced landing was a factor.Nov 30, 1993 · N1377W · Substantial damageNTSB SEA94FA038Accident · 1 fatalField investigationFinal reportPiper PA-24 · Ashland, ORVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: the adverse weatheer conditions, and the pilot's lack of…Nov 29, 1993 · N5764P · DestroyedNTSB BFO94LA019Accident · Serious injuriesLimited investigationFinal reportMartin Streak Shadow · Mannington, WVThe pilot's failure to maintain clearance from the surrounding terrain.Nov 26, 1993 · N106JM · DestroyedNTSB ATL94FA023Accident · 1 fatalField investigationFinal reportCessna 172 · Gadsden, ALThe pilot's inadequate pre-flight preparation and his continued visual flight into instrument meteorological conditions. Factors were fog, low ceiling, and hilly terrain.Nov 26, 1993 · N7702U · Substantial damageNTSB MIA94LA028Accident · No injuriesLimited investigationFinal reportCessna 172P · Jacksonville, FLThe improper positioning of the fuel selector by the pilot-in- command resulting in fuel starvation.Nov 25, 1993 · N89900 · Substantial damageNTSB FTW94LA039Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Mancos, COFuel exhaustion induced power loss and the pilot's inadequate preflight inspection, during which he failed to insure that the airplane had been refueled to capacity. A factor was the lack of suitable terrain for a forced landing.Nov 25, 1993 · N8833T · Substantial damageNTSB SEA94LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Brookings, ORThe pilot's inadequate preflight planning/preparation, and icing of the induction air filter/screen. Factors include weather conditions conducive to icing, and rough/uneven terrain in the area of attempted landing.Nov 22, 1993 · N8829J · Substantial damageNTSB SEA94FA034Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Mountain Home, IDThe pilot's intentional suicide and impairment from consumption of alcohol.Nov 22, 1993 · N84PM · DestroyedNTSB LAX94FA056Accident · 2 fatalField investigationFinal reportCessna 172M · Julian, CAThe pilot's failure to maintain aircraft control. Factors in this accident were: 1) the dark night and lack of ambient light which resulted in the pilot inadvertently flying from visual meteorological conditions into instrument meteorological conditions; 2)…Nov 22, 1993 · N5312R · DestroyedNTSB BFO94FA015Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Northampton, MAFailure of the air traffic control (ATC) facility to identify and provide the required traffic information to the jump aircraft before release of the jumper(s). A factor related to the accident was: inadequate visual lookout by the pilot of the jump aircraft.Nov 21, 1993 · N3011F · DestroyedNTSB BFO94FA013Accident · 3 fatalField investigationFinal reportBell 206L-1 · Portland, METhe pilot's continued VFR flight into instrument meteorological conditions, and his failure to assure that adequate fuel was available to complete the flight, resulting in a loss of engine power due to fuel exhaustion. Factors which contributed to the…Nov 20, 1993 · N911ME · DestroyedNTSB ATL94LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Maryville, TNThe pilot's inadequate inflight planning, which resulted in fuel exhaustion prior to reaching the planned destination.Nov 20, 1993 · N420FL · DestroyedNTSB MIA94LA024Accident · No injuriesLimited investigationFinal reportCessna U206F · Tampa, FLWas the improper overhaul and inspection of the engine by company maintenance personnel.Nov 19, 1993 · N8260Q · Substantial damageNTSB LAX94LA051Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-1B-2 · Las Vegas, NVWere the fuel injection line contamination resulting in fuel starvation; the pilot's inadequate 100-hour inspection; the pilot's improper decision to return to the airport at a low altitude; and his failure to maintain the proper airspeed which resulted in a…Nov 19, 1993 · N42597 · DestroyedNTSB BFO94LA012Accident · No injuriesLimited investigationFinal reportAngel Elbert S JR Quickie 200 · North Kingston, RILoss of engine power due to undetermined reasons.Nov 16, 1993 · N687EA · DestroyedNTSB LAX94LA045Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Florence, AZthe pilot's poor inflight planning and decision making by continuing the flight into adverse weather conditions. Factors contributing to this accident were: not obtaining a preflight weather briefing, not following the airplane flight manuals, and exceeding…Nov 15, 1993 · N9MP · DestroyedNTSB LAX94FA047Accident · 1 fatalField investigationFinal reportPiper PA-30 · Brea, CAThe pilot's choice of an inadequate cruise altitude over rolling hill terrain which resulted in an in-flight collision with helium balloons and an in-flight loss of control for undetermined reasons. A factor in the accident was the pilot's inadequate visual…Nov 15, 1993 · N8238Y · DestroyedNTSB LAX94LA046Accident · No injuriesLimited investigationFinal reportCessna 182 · Colusa, CAwas the poor major overhaul conducted by maintenance personnel by failing to properly service the cam shaft. The camshaft gears fatigue which led to its ultimate failure, the dark night conditions, and the power lines were factors in this accident.Nov 14, 1993 · N5723B · Substantial damageNTSB CHI94LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Arcadia, WIthe loss of engine power for an undetermined reason(s).Nov 14, 1993 · N9896L · Substantial damageNTSB CHI94FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cedar Lake, INthe failure of the pilot to maintain proper altitude. A factor related to the accident was flight into known adverse weather by the pilot.Nov 14, 1993 · N32303 · DestroyedNTSB BFO94LA010Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Sterling, MASeparation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.Nov 14, 1993 · N28215 · Substantial damageNTSB BFO94FA008Accident · 2 fatalField investigationFinal reportMooney MO-20J · Seekonk, MAThe pilot's inadequate in flight planning/decision to continue flight into known adverse weather conditions after the engine's dry air vacuum pump failed and the pilot's failure to maintain airplane control during approach. A factor in the accident was the…Nov 14, 1993 · N4224H · DestroyedNTSB BFO94LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverhead, NYThe pilot's preflight planning/preparation was inadequate which resulted in a loss of engine power due to fuel exhaustion.Nov 13, 1993 · N46897 · Substantial damageNTSB ATL94LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GAThe pilot's failure to use the carburetor heat system while maneuvering the airplane. A factor was conditions that were favorable for the formation of carburetor ice.Nov 12, 1993 · N6461G · Substantial damageNTSB FTW94FA028Accident · 3 fatalField investigationFinal reportCessna 182P · Marlow, OKAn inoperative vacuum system, an inoperative turn & bank indicator, and an inoperative directional gyro, which resulted in an inability of the pilot to control the airplane after it encountered instrument meteorological conditions (IMC). Factors related to…Nov 9, 1993 · N182JS · DestroyedNTSB FTW94LA026Accident · Minor injuriesLimited investigationFinal reportRockwell 114 · Magnolia, TXWas the owner's failure to perform corrective maintenance on the airplane's fuel system and the pilot's decision to operate it with known maintenance deficiencies. A factor was the lack of suitable terrain onto which a forced landing could be executed.Nov 8, 1993 · N1237W · Substantial damageNTSB MIA94LA017Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, FLTotal failure of the crankshaft due to fatigue resulting in a forced landing and subsequent hard landing.Nov 7, 1993 · N9000M · Substantial damageNTSB BFO94LA003Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morrisville, VTThe pilot's lack of experience in soaring which resulted in inadequate altitude to clear the ridge and subsequent collision with the terrain. A related factor was the high terrain.Nov 7, 1993 · N1178S · Substantial damageNTSB LAX94LA038Accident · No injuriesLimited investigationFinal reportAerospatiale SA-341G · Lake Berryessa, CAthe pilot's selection of an inadequate obstacle clearance cruise altitude.Nov 6, 1993 · N76WH · Substantial damageNTSB LAX94LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Palm Springs, CAfuel exhaustion due to the pilot's failure to adequately monitor the fuel consumption during the flight.Nov 4, 1993 · N7646M · Substantial damageNTSB ATL94FA012Accident · 2 fatalField investigationFinal reportMooney M20L · Hohenwald, TNThe pilot's impaired judgement and performance by flying while under the influence of drugs, that resulted in his continuation of VFR flight at night in instrument meteorological conditions (IMC) and his failure to maintain proper altitude (or clearance) from…Nov 4, 1993 · N132MP · DestroyedNTSB ATL94FA011Accident · 5 fatalField investigationFinal reportPiper PA-32RT-300T · Wrens, GAWas the fatique failure of the idler gear which resulted in the complete loss of engine power. A factor was the dark night.Nov 2, 1993 · N964ST · DestroyedNTSB MIA94LA014Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Fort Lauderdale, FLAn engine failure for undetermined causes over terrain unsuitable for a forced landing.Nov 1, 1993 · N210TK · DestroyedNTSB BFO94LA001Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe 415E · Willis, VAthe failure of the airplane's throttle cable fitting due to undetermined reasons, which prevented the pilot from applying power above engine idle. A factor in this accident was the lack of suitable terrain for the pilot to complete a forced landing without…Nov 1, 1993 · N94440 · Substantial damageNTSB LAX94LA034Accident · Minor injuriesLimited investigationFinal reportSilver KR2 · Fontana, CAthe separation of an engine coolant hose which resulted in a complete loss of engine power.Oct 31, 1993 · N8SJ · Substantial damageNTSB NYC94IA023Incident · No injuriesIncident investigationFinal reportBell 206L · New York, NYInadequate maintenance which resulted in the improper alignment of the 'O' ring on the spur adapter gear drive which caused lack of lubrication and wear of the gear drive and the disengagement of the compressor and turbine.Oct 29, 1993 · N16696 · No damageNTSB LAX94FA028Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Simon, AZThe pilot's improper planning/decision, and his allowing the airplane to exceed its design stress limits, which resulted in overload failure of the right outboard wind section and left horizontal stabilizer. Factors related to the accident were: the adverse…Oct 27, 1993 · XBHOM · DestroyedNTSB CHI94LA026Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Saint Paul, MNother maintenance personnel's improper maintenance installation and fuel system line fitting undertorqued. Factors related to the accident were the dark night, along with the fence and posts which were contacted.Oct 27, 1993 · N6333Y · Substantial damageNTSB NYC94LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Centreville, MDThe loss of engine power for undetermined reasons.Oct 25, 1993 · N16493 · DestroyedNTSB MIA94LA011Accident · Minor injuriesLimited investigationFinal reportCessna AT188B · Zellwood, FLPartial loss of engine power for undetermined reasons.Oct 24, 1993 · N731MF · Destroyed