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 FTW94LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Russellville, ARVFR flight into IMC.Aug 20, 1994 · N41472 · Substantial damageNTSB ATL94LA161Accident · No injuriesLimited investigationFinal reportCessna 207 · Nags Head, NCThe failure of the mixture control cable which resulted in a loss of engine power.Aug 20, 1994 · N1670U · Substantial damageNTSB LAX94LA327Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAthe loss of engine power due to the failure of the number 2 cylinder head. A factor was the dark night conditions which inhibited the pilot's ability to visually detect ground obstructions in the landing area.Aug 19, 1994 · N8843Q · Substantial damageNTSB LAX94LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Riverside, CAa total loss of engine power for undetermined reasons.Aug 19, 1994 · N3415M · Substantial damageNTSB LAX94IA331Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas MD-82 · Reno, NVFailure of the area supervisor/departure controller (supvr/ctlr) to stay at his radar position and ensure that required communications were maintained. Factors related to the incident were: failure of the local tower controller instruct the flightcrew of…Aug 19, 1994 · N954AS · No damageNTSB CHI94LA277Accident · No injuriesLimited investigationFinal reportBeech C90A · Janesville, WIthe pilot-in-command's exceeding the design structural limits of the airplane. Factors were turbulence in clouds and the pilot- in-command;s continued flight into known adverse weather.Aug 19, 1994 · N1553N · Substantial damageNTSB ATL94LA158Accident · No injuriesLimited investigationFinal reportCessna 172XP · Clarksburg, TNThe failure of the alternator drive coupling, and debris from the failed coupling that lodged in the engine oil pump, resulting in a sheared oil pump drive shaft. The engine subsequently failed because of oil starvation.Aug 19, 1994 · N9797V · Substantial damageNTSB FTW94FA272Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Van Horn, TXThe uncorrected descent by the pilot. A factor was the lack of total experience in type aircraft.Aug 18, 1994 · N435FH · DestroyedNTSB ANC94LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Wrangell, AKLoss of engine power for undertermined reasons and the lack of a suitable landing area.Aug 18, 1994 · N78428 · Substantial damageNTSB CHI94LA286Accident · No injuriesLimited investigationFinal reportSnow S2C · Leslie, MOthe separation of the cylinder and subsequent oil leak. A factor to the accident was the pilot's restricted visual outlook.Aug 17, 1994 · N9498R · Substantial damageNTSB LAX94LA324Accident · No injuriesLimited investigationFinal reportCessna 150M · Mettler, CAa loss of engine power due to inadequate and improper maintenance procedures and practices. A factor in the accident was the dark night lighting conditions which inhibited the pilot's ability to select a suitable forced landing area.Aug 16, 1994 · N714GV · Substantial damageNTSB BFO94LA137Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Stewartsville, NJThe loss of engine power for undetermined reason.Aug 16, 1994 · N13CM · Substantial damageNTSB BFO94FA144Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Front Royal, VAThe pilot's failure to maintain adequate clearance, his improper in-flight decision and his inadvertent flight into instrument meteorological conditions (IMC) which resulted in in-flight collision with terrain. The high terrain and weather conditions were…Aug 16, 1994 · N3701W · DestroyedNTSB BFO94FA163Accident · 4 fatalField investigationFinal reportPiper PA-601P · Sea Isle City, NJthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the presence of a level 6 thunderstorm, loss of gyro's for an undetermined reason, and the pilot's poor weather evaluation.Aug 15, 1994 · N3642A · DestroyedNTSB FTW94LA269Accident · Minor injuriesLimited investigationFinal reportRockwell 112A · Eagle Lake, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 14, 1994 · N1315J · Substantial damageNTSB ANC94FA106Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Kenai, AKInadequate engine maintenance and/or inspection, and fatigue cracking of the engine case, which resulted in eventual damage to the #3 cylinder studs/engine through-bolts, subsequent separation of the #3 cylinder and piston, and an in-flight fire.Aug 14, 1994 · N4839S · DestroyedNTSB SEA94LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Redmond, WAFailure of an exhaust valve. A factor to the accident was: wet grass.Aug 13, 1994 · N95285 · Substantial damageNTSB LAX94FA323Accident · 3 fatalField investigationFinal reportLockheed C-130A · Pearblossom, CAthe inflight failure of the right wing due to fatigue cracking in the underside right wing skin and overlying doubler. A factor contributing to the accident was inadequate maintenance procedures to detect fatigue cracking.Aug 13, 1994 · N135FF · DestroyedNTSB BFO94FA135Accident · 3 fatalField investigationFinal reportBell 206L-4 · Whiting, NJThe pilot's improper in-flight planning/decision, flight into instrument meteorological conditions (IMC), and subsequent spatial disorientation, which resulted in loss of aircraft control. Factors related to the accident were: darkness, the adverse weather…Aug 13, 1994 · N124NH · DestroyedNTSB MIA94LA194Accident · Minor injuriesLimited investigationFinal reportAerosport Quail · Waynesboro, MSAn engine failure due to improper maintenance [overhaul] of the engine crankshaft.Aug 11, 1994 · N10JB · Substantial damageNTSB LAX94FA317Accident · No injuriesField investigationFinal reportAerospatiale AS350-D · Kukuihaele, HIa fatigue crack in the 'T' fitting on the power turbine governor pneumatic accumulator. A factor was the rough, rock-covered landing area.Aug 11, 1994 · N889AT · Substantial damageNTSB BFO94LA129Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Bangor, METhe pilot's loss of aircraft control. Factors are dark night conditions, and the pilot's execution of an evasive maneuver.Aug 10, 1994 · N292Q · DestroyedNTSB FTW94LA265Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Texarkana, TXFuel contamination and the improper adjustments made to the carburetor by unidentified maintenance personnel. A factor was the lack of suitable terrain to which a forced landing could be executed.Aug 9, 1994 · N1478S · Substantial damageNTSB CHI94LA274Accident · 1 fatalLimited investigationFinal reportNelson Benson B-8M · Sandwich, ILImproper planning/decision by the pilot (owner/pilot/mechanic), and his improper modification of the flight control system, which resulted in his failure (or inability) to maintain control of the gyrocopter. A factor related to the accident was: the pilot's…Aug 9, 1994 · N26063 · DestroyedNTSB FTW94LA264Accident · No injuriesLimited investigationFinal reportCessna A188B · Sherman, TXThe pilot's failure to refuel the airplane. A factor was the leaking fuel caps.Aug 8, 1994 · N4826R · Substantial damageNTSB NYC94LA158Accident · No injuriesLimited investigationFinal reportStulp Starduster SA 300 · Ottawa, OHinadequate maintenance which resulted in a corroded gascolator fuel screen restriction fuel flow and resulted in fuel starvation.Aug 7, 1994 · N2091 · Substantial damageNTSB ANC94FA100Accident · 6 fatalField investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot of the VFR only flight intentionally entered instrument meteorological conditions. Factors in the accident were the inadequate procedures/directives by the company/operator management concerning continued VFR flight in marginal weather conditions…Aug 7, 1994 · N126UA · DestroyedNTSB LAX94FA309Accident · 3 fatalField investigationFinal reportAero Commander 112 · Mohave Valley, AZFailure of the certified flight instructor to properly judge the flare to avert a hard landing, and the failure of other maintenance personnel to properly repair the engine case halves during engine overhaul. A factor in the accident was the uneven relief of…Aug 6, 1994 · N1018J · DestroyedNTSB FTW94LA261Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Dallas, TXThe loss of engine power due to failure of the starter gear and shaft assembly needle bearing. Factors were the dark night conditions and the lack of suitable terrain for a forced landing.Aug 5, 1994 · N60124 · Substantial damageNTSB ANC94LA097Accident · No injuriesLimited investigationFinal reportCessna 206 · Mosquito Flats, AKThe missing number 6 cylinder piston pin cap and the subsequent failure of the number 6 cylinder connecting rod cap. Also, the lack of suitable landing area for the forced landing.Aug 5, 1994 · N5200X · Substantial damageNTSB NYC94FA148Accident · 1 fatalField investigationFinal reportBeech A100 · Williamstown, MAthe pilot's failure to maintain minimum control speed after an undetermined loss of engine power, which resulted in an inadvertent stall at too low of an altitude to allow recovery.Aug 4, 1994 · N7GA · DestroyedNTSB CHI94LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Richmond, MOa loss of engine power due to fuel starvation, reason undetermined.Aug 3, 1994 · N4854T · Substantial damageNTSB NYC94LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Crown Point, NYThe pilot's failure to maintain adequate terrain clearance. Other related factors are cloud conditions and the pilot's failure to maintain flight in visual meteorological conditions.Aug 2, 1994 · N4887Y · DestroyedNTSB FTW94LA256Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARTotal loss of engine power as the engine seized due to a blower bearing failure. A factor was the lack of suitable terrain for the forced landing.Aug 2, 1994 · N45297 · Substantial damageNTSB SEA94GA203Accident · 1 fatalFinal reportHughes OH-6A · Duchesne, UTThe pilot's improper in-flight planning/decision and failure to maintain sufficient altitude/clearance from the surrounding terrain. Factors related to the accident were: thunderstorms in the area (requiring the pilot to deviate from the desired course), high…Jul 31, 1994 · N12UT · DestroyedNTSB LAX94LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devore, CAwas the failure of the pilot to follow checklist and emergency procedures, which resulted in an improper decision to land on a dirt road within two miles of an airport.Jul 31, 1994 · N2500Y · DestroyedNTSB FTW94LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Silver City, NMThe pilot's failure to refuel and the resultant loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1994 · N5580G · Substantial damageNTSB CHI94LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Fort Wayne, INthe loss of engine power due to the failure of the number one cylinder.Jul 31, 1994 · N32736 · DestroyedNTSB ANC94LA095Accident · No injuriesLimited investigationFinal reportStarman Teirra II · North Pole, AKThe seizure of the no. 2 cylinder as a result of an inadequate cooling system for the high ambient temperature.Jul 31, 1994 · N43111 · Substantial damageNTSB MIA94LA188Accident · Minor injuriesLimited investigationFinal reportPiper J5C · Yazoo City, MSPartial blockage of the carburetor by a wasp nest, which was not visible during preflight, and which resulted in the loss of power.Jul 30, 1994 · N74669 · Substantial damageNTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.Jul 30, 1994 · N84514 · Substantial damageNTSB ATL94GA148Accident · Minor injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for undetermined reasons.Jul 30, 1994 · N789MC · Substantial damageNTSB CHI94LA257Accident · Minor injuriesLimited investigationFinal reportLattimore-Dwyer Breezy · Goshen, INfuel exhaustion which resulted from the pilot's failure to assure an adequate fuel supply for the flight.Jul 29, 1994 · N4029 · Substantial damageNTSB CHI94LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Lomax, ILthe pilot's failure to maintain clearance from a transmission wire, and the pilot's failure to maintain an appropriate altitude. A factor associated with the accident is the transmission wire.Jul 27, 1994 · N9409A · Substantial damageNTSB CHI94LA245Accident · No injuriesLimited investigationFinal reportMooney M20C · Macon, MOthe student pilot's decision to land on a closed runway under construction. A factor associated with the accident is the partial loss of engine power for an undetermined reason.Jul 27, 1994 · N6327Q · Substantial damageNTSB SEA94LA196Accident · No injuriesLimited investigationFinal reportCessna T210M · Rathdrum, IDThe fatigue failure of the crankshaft and a slipped bearing.Jul 26, 1994 · N761TK · Substantial damageNTSB CHI94LA244Accident · No injuriesLimited investigationFinal reportMontana Coyote · Blaine, MNthe loss of engine power due to the blocked vent line.Jul 26, 1994 · N218LW · Substantial damageNTSB NYC94FA135Accident · 2 fatalField investigationFinal reportMooney M20C · Wallingford, CTthe pilot's decision to exhaust the fuel supply in the selected tank in-flight, and his failure to maintain the minimum stall speed during engine out conditions. This resulted in a complete loss of engine power and the inadvertent stall and impact with the…Jul 24, 1994 · N6842N · DestroyedNTSB MIA94LA182Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Atlantic Ocean (Atlantic Ocean)An electrical system short for undetermined reasons.Jul 24, 1994 · N63317 · DestroyedNTSB ATL94LA144Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hephzibah, GAThe pilot's inadequate preflight of the aircraft, resulting in fuel exhaustion, and his improper flare of the helicopter during the autorotation, resulting in a hard landing.Jul 24, 1994 · N4030S · Substantial damage