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 DEN00FA086Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Estes Park, COA descent below the surrounding terrain, by the pilot, in IMC conditions. Factors were high mountainous terrain, clouds, inaccurate weather evaluation by the pilot, and the pilot's flight into IMC conditions.Apr 30, 2000 · N7421S · DestroyedNTSB CHI00LA127Accident · Minor injuriesLimited investigationFinal reportFairchild PT-26B · Winn, MIthe pilot's inadequate fuel management. Factors to the accident were fuel starvation, the low altitude at the time of the loss of engine power, remedial action not possible by the pilot, and the unsuitable terrain for landing encountered by the pilot.Apr 30, 2000 · N53366 · Substantial damageNTSB MIA00FA141Accident · 2 fatalField investigationFinal reportNorth American SNJ-5 · Elk Park, NCThe inflight loss of control for undetermined reasons resulting in the airplane colliding with mountainous terrain during the uncontrolled descent.Apr 28, 2000 · N3187G · DestroyedNTSB DEN00FA078Accident · No injuriesField investigationFinal reportDouglas DC-8-62F · Denver, COThe failure of the clamp that secured the high-pressure bleed air duct to the high-pressure relief valve. Factors were the resulting excessive pressurization of the engine nacelle, and the subsequent separation of the engine cowling.Apr 28, 2000 · N990CF · Substantial damageNTSB NYC00LA121Accident · No injuriesLimited investigationFinal reportCessna 150D · Waynesville, OHThe pilot's inadequate preflight, and the water that remained in the fuel system after the preflight.Apr 26, 2000 · N4182U · Substantial damageNTSB FTW00LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Hunter, OKThe pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.Apr 26, 2000 · N76176 · Substantial damageNTSB FTW00LA131Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Lancaster, TXthe loss of engine power for undetermined reasons.Apr 25, 2000 · N5269C · Substantial damageNTSB ATL00FA048Accident · 3 fatalField investigationFinal reportEurocopter BK117-A3 · St. Petersburg, FLThe pilot's failure to maintain clearance that resulted in the in-flight collision with a tower.Apr 25, 2000 · N428MB · DestroyedNTSB SEA00LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Ashland, ORThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. Unsuitable terrain for a landing was a contributing factor.Apr 24, 2000 · N55PJ · Substantial damageNTSB NYC00FA119Accident · 2 fatalField investigationFinal reportBeech N35 · Conicville, VAThe pilot's in-flight decision to continue flight into IMC conditions, and his failure to maintain control of the airplane. Factors related to the accident were the failure of the vacuum pump and the pilot's lack of recent instrument time.Apr 22, 2000 · N1253Z · DestroyedNTSB LAX00FA170Accident · 2 fatalField investigationFinal reportEmigh Trojan A2 · Brentwood, CAthe pilot's failure to maintain control of the airplane.Apr 22, 2000 · N8324H · DestroyedNTSB LAX00FA168Accident · 1 fatalField investigationFinal reportBeech D35 · Agua Dulce, CAThe pilot's failure to maintain terrain clearance while cruising up a mountain pass, on a dark night, in IMC conditions, and his improper in-flight decision to perform a VFR flight in the inclement weather.Apr 22, 2000 · N2086D · DestroyedNTSB NYC00FA118Accident · 5 fatalField investigationFinal reportMooney M20J · Norton, VAThe pilot's improper weather evaluation, which resulted in a loss of aircraft control. Factors in this accident were icing conditions, and aircraft loading which exceed the airplane's weight and balance limitations.Apr 21, 2000 · N5632H · DestroyedNTSB LAX00LA167Accident · No injuriesLimited investigationFinal reportEurocopter AS-350 BA · Kahului, HIFailure of the manufacturer to ensure proper quality control of the ignition solenoid housing chamfer area, which allowed for insufficient clamping forces between the ignition solenoid housing and T-fitting, and the eventual separation of the T-fitting, loss…Apr 21, 2000 · N6094H · Substantial damageNTSB LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.Apr 21, 2000 · N152SC · Substantial damageNTSB LAX00LA162Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Lodi, CAA loss of engine power for undetermined reasons.Apr 20, 2000 · N3629F · Substantial damageNTSB FTW00LA127Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Tomball, TXEngine seizure due to the rupture of an oil cooler line.Apr 19, 2000 · N7038V · Substantial damageNTSB DEN00FA074Accident · No injuriesField investigationFinal reportBell 206L-3 · Lakewood, COThe complete loss of the tail rotor blades due to a fatigue failure of one blade. Factors were sloping and rough uneven terrain for the ensuing forced landing.Apr 18, 2000 · N937S · Substantial damageNTSB LAX00LA157Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Yreka, CAthe total loss of engine power while in cruise flight due to the fatigue failure of the engine's anti-ice bleed air line, which resulted in the pilot's inability to utilize the engine anti-ice system. Contributing factors were the icing conditions and the…Apr 17, 2000 · N1682U · Substantial damageNTSB LAX00LA156Accident · No injuriesLimited investigationFinal reportBell 407 · Grand Canyon, AZThe failure and subsequent disintegration of the oil cooler fan forward hanger bearing.Apr 16, 2000 · N175PA · Substantial damageNTSB NYC00LA114Accident · No injuriesLimited investigationFinal reportLoomis Sidewinder · Cincinnati, OHA partial power loss for undetermined reasons.Apr 15, 2000 · N13545 · Substantial damageNTSB LAX00LA155Accident · Minor injuriesLimited investigationFinal reportSmith RV-4 · Willows, CADisconnection of the elevator push rod due to the owner/builder's improper installation of the rear jam nut on the elevator pushrod.Apr 15, 2000 · N63SM · Substantial damageNTSB CHI00LA112Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Kankakee, ILthe misjudged glidepath by the pilot. Factors were the failure of the impeller seal resulting in a total loss of engine oil and subsequent engine failure, the plowed farm field, and the lack of suitable terrain for the forced landing.Apr 15, 2000 · N82AW · DestroyedNTSB NYC00FA112Accident · 1 fatalField investigationFinal reportCessna 172H · Grottoes, VAThe pilot's loss of control of the airplane in instrument meteorological conditions, which resulted in an inadvertent stall/spin. Factors included the pilot's lack of instrument time under actual conditions, and his lack of recent instrument flight experience.Apr 14, 2000 · N1404F · DestroyedNTSB CHI00FA111Accident · No injuriesField investigationFinal reportBell 222U · St. Paul, MNThe loss of clamp-up force between the transmission case and the pylon mounted actuator support assembly which resulted in fatigue failure of the threaded studs and dowel pins, the failure of the flight control system, helicopter control not being possible…Apr 14, 2000 · N225LL · Substantial damageNTSB MIA00LA132Accident · Serious injuriesLimited investigationFinal reportHartline Glastar · Woodstock, ALa total engine failure for undetermined reason, resulting in a forced landing and subsequent impact with a tree.Apr 13, 2000 · N897G · Substantial damageNTSB SEA00LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Auburn, WAThe pilot's failure to follow aircraft operating procedures by not raising the flaps during the go-around maneuver. Contributing factors were the pilot's failure to adhere to the balked landing checklist (FLAPS to 20) resulting in degraded climb performance,…Apr 12, 2000 · N9301U · Substantial damageNTSB MIA00LA130Accident · Minor injuriesLimited investigationFinal reportScott Vans RV-4 · Natchez, MSan inadvertent stall at too low altitude to allow recovery. Factors in this accident were fog and low ceilings.Apr 12, 2000 · N123SC · Substantial damageNTSB IAD00TA040Accident · No injuriesFinal reportCessna 182RG · Cleveland, OHthe pilot's intentional flight into known icing conditions which resulted in an inadvertent stall/mush and hard landing. A factor in the accident was the icing conditions.Apr 12, 2000 · N6183T · Substantial damageNTSB ANC00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Aleknagik, AKThe first pilot's (pilot-in-command) inadequate evaluation of the weather, and failure to maintain an adequate altitude above the ground. Factors in the accident were low ceilings, and snow-covered terrain.Apr 12, 2000 · N6119W · Substantial damageNTSB SEA00LA068Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-45A Ogar · Libby, MTA crack in the propeller blade that developed into a complete separation of the blade.Apr 8, 2000 · N54AS · Substantial damageNTSB SEA00LA066Accident · No injuriesLimited investigationFinal reportBeech A200 · Seattle, WAThe pilot's failure to properly follow pre-takeoff checklists (resulting in the engine starters remaining engaged after engine start, generators not being activated, discharge of the aircraft battery and consequent total electrical failure during flight with…Apr 8, 2000 · N258AG · Substantial damageNTSB FTW00LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lubbock, TXThe pilot's incorrect positioning of the fuel selector which resulted in fuel starvation. Factors were the pilot's lack of familiarity with the fuel system due to an inadequate checkout by a flight instructor, and the lack of suitable terrain for the forced…Apr 7, 2000 · N5682T · Substantial damageNTSB NYC00IA116Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1125 · Pine Knot, KYThe partial failure of an inverter and the inadequate design of the electrical circuit breaker system.Apr 3, 2000 · N511WA · No damageNTSB LAX00LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Dallas, TXThe en route cruise encounter with forecast moderate turbulence.Apr 3, 2000 · N910AW · No damageNTSB FTW00FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech M35 · Gulf Of Mexicothe pilot's continued flight of the airplane into known adverse weather conditions resulting in the pilot's loss of control of the aircraft. Contributing factors were the severe turbulence and windshear.Apr 3, 2000 · N9778R · DestroyedNTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…Apr 2, 2000 · N3377H · DestroyedNTSB LAX00LA153Accident · No injuriesLimited investigationFinal reportQuicksilver Sprint 2 · Fresno, CAThe overheating and seizure of the number 2 piston for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which led to an inadvertent stall/mush.Apr 2, 2000 · UNREG · Substantial damageNTSB FTW00FA113Accident · 2 fatalField investigationFinal reportVans RV-6T · Pettigrew, ARthe pilot's continued flight into known adverse weather and his failure to maintain obstacle clearance. Contributing factors were adverse weather conditions, and the pilot's disregard for the forecasted adverse weather.Apr 2, 2000 · N96VA · DestroyedNTSB CHI00LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pine City, MNA loss of engine power due to the failure of the number four cylinder's exhaust valve spring and exhaust valve. Contributing to the accident were, the barbwire fence and the clump of high vegetation encountered by the airplane.Apr 2, 2000 · N54454 · Substantial damageNTSB NYC00LA115Accident · No injuriesLimited investigationFinal reportMooney M-20F · Parker, PAThe pilot's failure to maintain an adequate visual lookout, due to his distraction with a flock of birds. A factor was the pilot's improper in flight decision to continue the simulated engine failure to too low of an altitude.Apr 1, 2000 · N737HB · Substantial damageNTSB IAD00IA032Incident · No injuriesIncident investigationFinal reportBoeing 767-332 · New York City, NYThe first officer's failure to maintain control of the airplane during climb out over water at night, which was a result of spatial disorientation. Factors in the incident were the cloud layer and dark night.Mar 31, 2000 · N182DN · No damageNTSB ANC00TA039Accident · No injuriesFinal reportBell 206B · Manokotak, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings and snow, and snow-covered terrain.Mar 30, 2000 · N5006R · Substantial damageNTSB MIA00LA123Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Leesburg, GAThe failure of the pilot to maintain clearance during a spray pass resulting in the in-flight collision with the raised rows of the field.Mar 29, 2000 · N4089Q · Substantial damageNTSB NYC00LA103Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Renick, WVThe pilot's improper weather evaluation, and subsequent improper decision to fly into forecast and known icing conditions that exceeded the capability of the airplane to maintain flight. A factor was the icing conditions.Mar 28, 2000 · N1830Q · Substantial damageNTSB LAX00LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Corona, CAThe pilot's inadequate weather evaluation, and his improper remedial actions that led to a precautionary landing and subsequent attempted takeoff from unsuitable terrain.Mar 25, 2000 · N7354A · Substantial damageNTSB FTW00LA106Accident · Minor injuriesLimited investigationFinal reportWard Acro · Beasley, TXThe loss of engine power for an undetermined reason.Mar 25, 2000 · N79RW · Substantial damageNTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.Mar 25, 2000 · N6375H · Substantial damageNTSB LAX00LA139Accident · No injuriesLimited investigationFinal reportScovil KR-2 · Tonopah, AZThe fuel control metering unit becoming disengaged and the inadvertent use of the fuel supply during flight.Mar 24, 2000 · N73BP · Substantial damageNTSB MIA00LA114Accident · No injuriesLimited investigationFinal reportMckinnis Steen Skybolt · Tuscaloosa, ALa loss of engine power during climb due to fuel starvation which was caused by a fuel leak in the gascolator as a result of improper maintenance by the operator that resulted in the pilot making a forced landing during which the airplane sustained substantial…Mar 20, 2000 · N75CM · Substantial damage