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 CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.Feb 28, 1993 · N704AF · Substantial damageNTSB SEA93LA069Accident · Minor injuriesLimited investigationFinal reportCessna T-210L · Ogden, UTThe loss on engine power from fuel exhaustion due to the inadequate preflt planning/preparation by the PIC and his failure to maintain proper airspeed during an emergency forced landing.Feb 27, 1993 · N2611S · Substantial damageNTSB LAX93LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZLoss of engine power for an undetermined reason.Feb 26, 1993 · N975MA · Substantial damageNTSB MIA93FA073Accident · No injuriesField investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLThe improper use of elevator flight control during the landing by the pilot in command.Feb 23, 1993 · N678DL · Substantial damageNTSB LAX93LA135Accident · Serious injuriesLimited investigationFinal reportDowner Aircraft Industries KR-1 · Prescott, AZThe total loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing area at the time of the power interruption.Feb 23, 1993 · N9HD · DestroyedNTSB LAX93LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Red Mountain, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the aircraft. Factors in the accident were the pilot's inability to see the terrain due to the dark night conditions and the flight's encounter with instrument…Feb 23, 1993 · N5607P · Substantial damageNTSB MIA93LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Raleigh, MSThe fatigue failure of the no. 1 exhaust valve for undetermined reasons, and the lack of suitable terrain for the forced landing.Feb 22, 1993 · N1581M · Substantial damageNTSB LAX93LA132Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe pilots failure to maintain an adequate visual lookout for obstructions while performing a low altitude surveillance operation in a mountainous area, and, his failure to select an altitude sufficient to ensure clearance from all potential obstacles.Feb 22, 1993 · N58240 · Substantial damageNTSB MIA93LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bunnell, FLThe rupture of the oil cooler line at the adel clamp for undetermined reasons, resulting in a loss of engine oil, and a subsequent engine seizure.Feb 20, 1993 · N55737 · Substantial damageNTSB CHI93LA093Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cannonball, NDThe blockage of the inlet air filter from snow.Feb 20, 1993 · N4229P · Substantial damageNTSB LAX93LA126Accident · Minor injuriesLimited investigationFinal reportCessna Soloy TU206G · Cochise, AZThe pilot's continued flight into known forecasted icing conditions, in an airplane not certificated for such flight, which resulted in an engine flameout due to engine ice/water injestion, and the pilot's inability to restart the engine due to inadequate…Feb 19, 1993 · N9987M · Substantial damageNTSB BFO93FA030Accident · 1 fatalField investigationFinal reportAmerican General AG5B · Vergennes, VTVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from snow covered terrain after becoming spatially disoriented in whiteout conditions. The adverse weather and snow covered…Feb 18, 1993 · N1192Z · DestroyedNTSB LAX93FA125Accident · 2 fatalField investigationFinal reportCessna T210M · Coalinga, CAThe pilots inadequate preflight planning and his failure to select a cruise altitude which would ensure adequate terrain clearance during the night cross country. Factors in the accident were: the mountainous nature of the terrain and the dark night light…Feb 16, 1993 · N761NE · DestroyedNTSB MIA93LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Mccoy, FLThe in-flight collision with a large bird.Feb 15, 1993 · N95527 · Substantial damageNTSB LAX93FA119Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Truckee, CAThe pilot's continued VFR flight into instrument meteorological conditions. The adverse weather conditions contributed to the accident.Feb 15, 1993 · N15267 · DestroyedNTSB MIA93LA069Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Sun City, FLThe pilot-in-command's failure to verify fuel load after refueling, which resulted in loss of engine power due to fuel exhaustion.Feb 14, 1993 · N49308 · Substantial damageNTSB DEN93IA027Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Grand Junction, COFailure of the left generator control unit (gcu), integrated drive generator (idg), right (side) engine indicator and crew alert system (eicas), and bus tie bar (btb).Feb 14, 1993 · N508UA · No damageNTSB FTW93LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Magdalena, NMFuel exhaustion power loss due to the pilot's failure to refuel. Factors were the unsuitable terrain and the dark nightFeb 13, 1993 · N2187R · Substantial damageNTSB LAX93LA117Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hughson, CAThe failure of the intake valve. The soft terrain contributed to this accident.Feb 12, 1993 · N62733 · Substantial damageNTSB FTW93LA082Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hillsboro, TXThe power loss due to fuel exhaustion for undetermined reasons. Factors were the dark night conditions and the lack of suitable terrain for the ensuing forced landing.Feb 10, 1993 · N3876Y · Substantial damageNTSB MIA93LA064Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot-in-command's overconfidence in his own abilities and the subsequent failure of both engines due to fuel exhaustion. Contributing factors were the failure of the pilot to perform in-flight fuel consumption calculations, and the unsuitable terrain for…Feb 7, 1993 · N5044Y · DestroyedNTSB LAX93LA191Accident · No injuriesLimited investigationFinal reportBeech F35 · Sandy Valley, NVThe pilot's failure to perform a preflight inspection of the airplane, and to assure that an adequate supply of fuel was on board the aircraft. This subsequently led to an inadequate fuel supply in the left tank, and fuel starvation. A factor related to the…Feb 7, 1993 · N4255B · Substantial damageNTSB LAX93FA110Accident · 4 fatalField investigationFinal reportCessna 172K · Gorman, CAThe pilot's continued flight into known adverse weather conditions and continued visual flight into instrument meteorological conditionsFeb 7, 1993 · N79411 · DestroyedNTSB MIA93LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Ruskin, FLThe failure of the pilot-in-command to monitor fuel quantity resulting in an engine failure due to fuel exhaustion.Feb 4, 1993 · N714YL · Substantial damageNTSB ATL93LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe poor preflight planning by the pilot.Feb 3, 1993 · N757AC · Substantial damageNTSB BFO93LA024Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Lanham, MDThe blockage of the right and left fuel vent line which prevented the flow of fuel to the engine causing total power loss.Jan 31, 1993 · N1383R · DestroyedNTSB LAX93LA107Accident · Serious injuriesLimited investigationFinal reportBell 206B · Parks, AZ1) The pilot not obtaining forecast weather for his route of flight nor his destination 2) the pilot's inflight decision to fly into snow with the helicopter's engine air induction particle separator kit not installed, as required by the Bell 206B pilot's…Jan 30, 1993 · N855B · Substantial damageNTSB CHI93LA083Accident · No injuriesLimited investigationFinal reportCessna 177 · Barrington, ILLoss of engine power due to fuel contamination.Jan 30, 1993 · N29515 · Substantial damageNTSB ANC93LA029Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Port Heiden, AKThe failure of the number 3 cylinder intake valve stem. A factor in the degree of damage the aircraft sustained in the mishap was attributable to the off airport emergency landing on show covered tundra.Jan 29, 1993 · N8327S · Substantial damageNTSB MIA93LA056Accident · 1 fatalLimited investigationFinal reportFerran DOMINATOR-BIG ONE · Apopka, FLUndetermined.Jan 28, 1993 · N4HF · DestroyedNTSB DEN93LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Durango, COPower loss due to water contaminated fuel. A factor was: unsuitable terrain for a forced landing.Jan 28, 1993 · N67492 · Substantial damageNTSB MIA93LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Pascagoula, MSLoss of engine power due to undetected foreign matter contamination of the engine fuel control. The lack of a suitable landing area was a facotr in the accident.Jan 27, 1993 · N6612C · Substantial damageNTSB MIA93LA054Accident · Minor injuriesLimited investigationFinal reportNorth American T-28A · Plantation, FLFailure of the master rod main bearing which resulted in loss of engine power and a subsequent forced landing.Jan 27, 1993 · N203CB · Substantial damageNTSB CHI93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo, MOThe pilot's failure to refuel the airplane prior to fuel exhaustion.Jan 27, 1993 · N5322P · Substantial damageNTSB CHI93LA077Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIThe pilot's failure to properly align the aircraft with the landing area.Jan 26, 1993 · N37224 · Substantial damageNTSB CHI93IA078Incident · No injuriesIncident investigationFinal reportFokker F-28 MK 1000 · Detroit, MIImproper lubrication of the horizontal stabilizer gearbox by company maintenance personnel. A factor was the manufacturer's inadequate service procedure.Jan 26, 1993 · N452US · No damageNTSB SEA93LA055Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Medicine Bow, WYFailure of the #7 cylinder rocker arm. Factors contributing to the accident were unsuitable terrain and dark night conditions.Jan 20, 1993 · N56924 · Substantial damageNTSB LAX93FA096Accident · 1 fatalField investigationFinal reportCessna 172P · Sun City, CAThe pilot's decision to initiate VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, the adverse weather, and the mountainous terrain.Jan 20, 1993 · N53908 · DestroyedNTSB FTW93FA072Accident · 3 fatalField investigationFinal reportBeech V35B · Dixie Inn, LAThe pilot's failure to maintain control for undetermined reasons.Jan 19, 1993 · N74DC · DestroyedNTSB CHI93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Lineville, IACarburetor ice as a result of the pilot-in-command's improper use of carburetor heat.Jan 19, 1993 · N60SX · Substantial damageNTSB ANC93FA027Accident · 1 fatalField investigationFinal reportCessna 310 · Teller, AKThe pilot-in-command's failure to maintain an adequate terrain avoidance altitude. Factors which contributed to the accident were the dark night and featureless snow covered terrain, both which created a 'featureless terrain illusion' which probably led the…Jan 18, 1993 · N1776G · DestroyedNTSB FTW93IA067Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC8-55 · Dfw Airport, TXFailure of an engine turbine wheel for undetermined reasons.Jan 15, 1993 · N8041U · Minor damageNTSB BFO93FA050Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Ligonier, PAVisual flight rules (VFR) flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude from the wooded terrain. The terrain and adverse weather conditions were related factors.Jan 15, 1993 · N28196 · DestroyedNTSB SEA93LA051Accident · No injuriesLimited investigationFinal reportBeech 58P · Hanksville, UTAn improper fuel selector valve position, fuel starvation, and inadequate remedial action. Factors include soft, rough terrain.Jan 14, 1993 · N550TH · Substantial damageNTSB BFO93LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Manorhaven, NYThe partial power loss due to induction system icing and the pilots failure to apply carburetor heat during weather conducive to induction system icing.Jan 14, 1993 · CFAXE · Substantial damageNTSB ATL93LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Goldsboro, NCThe pilot's improper decision in attempting a night landing at an airport without operating runway lights which resulted in a touchdown off the runway. Factors which contributed to the accident were: an airplane lighting malfunction for an undetermined…Jan 14, 1993 · N8409A · Substantial damageNTSB LAX93FA093Accident · 2 fatalField investigationFinal reportBell 206B · Hayward, CAThe pilot's continued flight into known adverse weather conditions and continued VFR flight into instrument meteorological conditions. Contributing to the accident were dark night light conditions and rain.Jan 13, 1993 · N3202A · DestroyedNTSB BFO93FA019Accident · 2 fatalField investigationFinal reportHughes 269C · Tonawanda, NYImproper inflight planning/decision by the pilot and his failure to maintain clearance from an obstacle during flight. Factors related to the accident include poor visibility and weather conditions at dusk, and the pilot's excessive airspeed for the…Jan 11, 1993 · N1088Z · DestroyedNTSB DEN93IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Denver, COMedical incapacitation of the first officer.Jan 9, 1993 · N601UA · No damageNTSB LAX93LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172 · San Jacinto, CAThe flight's encounter with unforecast clear air turbulence.Jan 8, 1993 · N20513 · Destroyed