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 NYC06LA091Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Passadumkeag, METhe partially blocked fuel line, which resulted in fuel starvation and a subsequent loss of engine power. Factors in the accident included inadequate maintenance, and the unsuitable terrain.Apr 10, 2006 · N714EJ · Substantial damageNTSB CHI06CA107Accident · No injuriesData collectionFinal reportCessna 150 · Sandstone, MNThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A contributing factor was the unsuitable terrain encountered during the forced landing.Apr 10, 2006 · N50970 · Substantial damageNTSB NYC06LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Norfolk, VAThe pilot's failure to maintain aircraft control during a single-engine go-around. A factor was the partial loss of engine power.Apr 7, 2006 · N7812Y · Substantial damageNTSB DFW06LA101Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Kerrville, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Apr 7, 2006 · N142SF · Substantial damageNTSB ATL06LA061Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Folkston, GAThe total loss of engine power due to the failure of the compressor turbine blades due to high temperature exposure.Apr 5, 2006 · N3096H · Substantial damageNTSB DCA06FA033Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC10 · Memphis, TNThe rupture of a fatigue crack in the forward air seal tooth serration of the No. 3 engine low pressure turbine stage 1 disk that initiated due to an improper weld repair performed during original manufacture. The improper weld repair changed the material…Apr 4, 2006 · N386FE · Substantial damageNTSB ANC06LA043Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Iliamna, AKThe pilot's delayed use of carburetor heat, which resulted in a loss of engine power during cruise, and an in-flight collision with snow-covered terrain. Factors associated with the accident were an unfavorable wind, and the pilot's inadvertent stall of the…Apr 3, 2006 · N36291 · Substantial damageNTSB MIA06LA077Accident · 2 fatalLimited investigationFinal reportMarvin T Eiland SparrowHawk · Ona, FLThe in-flight loss of control for undetermined reasons during a normal descent, resulting in an uncontrolled descent, and in-flight collision with terrain.Mar 31, 2006 · N41964 · Substantial damageNTSB DEN06CA054Accident · No injuriesData collectionFinal reportCessna 170B · Benton, KSthe pilot's failure to maintain directional control of the airplane resulting in a ground loop. Contributing factors include the inadequate preflight inspection, the pilot's failure to properly latch the cowling, and the pilot's diverted attention to the open…Mar 31, 2006 · N2359J · Substantial damageNTSB NYC06LA086Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Clay Township, PAA loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.Mar 30, 2006 · N346DC · Substantial damageNTSB LAX06FA133Accident · 1 fatalField investigationFinal reportRockwell 112 TCA · La Canada, CAThe pilot's failure to maintain aircraft control and an adequate airspeed during climb to cruise that led to a stall/spin. Contributing to the accident were the clouds and the pilot's physiological state.Mar 30, 2006 · N4641W · DestroyedNTSB LAX06CA140Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Victorville, CAan in-flight collision with a bird.Mar 30, 2006 · N7086Z · Substantial damageNTSB LAX06FA131Accident · 2 fatalField investigationFinal reportCessna 208B · Oak Glen, CAThe pilot's continued flight into instrument meteorological weather conditions and his subsequent failure to maintain an adequate airspeed while maneuvering, that led to a stall/spin.Mar 29, 2006 · N208WE · DestroyedNTSB MIA06LA071Accident · Serious injuriesLimited investigationFinal reportCessna 402C · Dorado, PRThe failure of the pilot to use on-board weather radar equipment for weather avoidance and the pilot's continued operation into known adverse weather conditions, resulting in injury to passengers.Mar 27, 2006 · N223PB · No damageNTSB DFW06CA092Accident · No injuriesData collectionFinal reportWaterwings SeaRey · Vicksburg, MSThe pilot's inadvertent reduction of power resuting in a collision with water. Contributing factors were the low altiude selected and the pilot's inattention.Mar 26, 2006 · N42685 · DestroyedNTSB ANC06LA030Accident · 1 fatalLimited investigationFinal reportMooney M-10 · Salinas, CAThe pilot's continued flight into known adverse weather, and his failure to maintain sufficient airspeed, which resulted in a loss of control and an inadvertent stall/spin during cruise flight. Factors associated with the accident are a low ceiling with…Mar 25, 2006 · N9533V · Substantial damageNTSB CHI06LA095Accident · No injuriesLimited investigationFinal reportCessna 172G · Collins, MOThe pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion, and the loss of engine power during cruise flight. An additional cause was the pilot's improper in-flight decision to continue when he believed his fuel gauges were erratic…Mar 22, 2006 · N4444L · Substantial damageNTSB DFW06LA087Accident · 1 fatalLimited investigationFinal reportWeatherly 201B · Hondo, TXA loss of aircraft control for undetermined reasons.Mar 21, 2006 · N1257W · Substantial damageNTSB LAX06FA130Accident · 2 fatalField investigationFinal reportBeech F33A · Kingman, AZThe noninstrument rated pilot's cruise flight into instrument meteorological conditions, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent, and an in-flight collision with terrain. Factors associated with the…Mar 20, 2006 · N41PT · DestroyedNTSB DEN06LA050Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Emporia, KSthe pilot's attempted flight into adverse weather conditions and improper in-flight planning which resulted in loss of control and subsequent impact with trees. Contributing factors were the pilot's delayed remedial action, the icing and dark night conditions.Mar 20, 2006 · N331FC · Substantial damageNTSB ATL06IA054Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Asheville, NCThe improper installation of the pilot's windshield by company maintenance personnel, which resulted in flame and smoke in the cockpit, and subsequent emergency landing.Mar 19, 2006 · N8783E · Minor damageNTSB NYC06FA079Accident · 1 fatalField investigationFinal reportBeech 56TC · Winfield, WVThe pilot's inadequate preflight preparation to ensure an adequate supply of supplemental oxygen, and his inadequate in-flight planning and decision making, which resulted in exhaustion of his oxygen supply, and incapacitation from hypoxia during cruise…Mar 18, 2006 · N18LL · Substantial damageNTSB ATL06LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180F · Easley, SCLoss of engine power for undetermined reasons which resulted in a forced landing and subsequent in-flight collision with non-suitable terrain.Mar 18, 2006 · N2133T · Substantial damageNTSB CHI06LA099Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Omaha, NEAn inadvertent encounter with unforecast mountain wave turbulence during cruise flight. A contributing factor was the mountain wave (terrain induced) turbulence.Mar 15, 2006 · N518UA · No damageNTSB DFW06FA083Accident · 2 fatalField investigationFinal reportBell 206L-1 · Patterson, LAThe improper installation of an engine fuel line fitting by other maintenance personnel, which resulted in a loose fitting and a loss of engine power during cruise flight. Factors associated with the accident are a tailwind, and the lack of a suitable site…Mar 14, 2006 · N370RL · DestroyedNTSB MIA06LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, FLA loss of engine power due to an oil line leak and oil exhaustion. A contributing factor was the unsuitable terrain on which to make a forced landing.Mar 12, 2006 · N321GS · Substantial damageNTSB ATL06LA051Accident · Serious injuriesLimited investigationFinal reportEakle R Grandin Jr Talon XP · Auburn, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A factor was the improper maintenance inspection of the engine fuel lines resulting in loss of engine power due to a loose fuel line and subsequent fuel starvation.Mar 12, 2006 · N97GE · Substantial damageNTSB ATL06LA050Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Jesup, GAThe loss of engine power due to the fatigue failure of the crankshaft, which resulted in a forced landing, and an in-flight collision with trees. A factor associated with the accident was the failure of other maintenance personnel to comply with the engine…Mar 9, 2006 · N6540X · Substantial damageNTSB ATL06LA049Accident · No injuriesLimited investigationFinal reportErcoupe E · Wetumpka, ALThe failure of the No. 2 exhaust, and intake valves for undetermined reasons, which resulted in a loss of engine power during cruise flight and damage to the airplane during the subsequent forced landing.Mar 8, 2006 · N94840 · Substantial damageNTSB CHI06CA098Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Holly, MIA loss of engine power due to undetermined reasons. Factors associated with the accident were the guard rail and the ditch which the airplane contacted during the forced landing.Mar 7, 2006 · N7810N · Substantial damageNTSB DEN06LA046Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Severance, COfuel exhaustion and the pilot's failure to refuel the airplane. Contributing factors were the inaccurate fuel flow reading and the pilot's incorrect fuel consumption calculations.Mar 5, 2006 · N221RS · Substantial damageNTSB ATL06LA048Accident · Minor injuriesLimited investigationFinal reportJoel H Johnson Rans S-6ES Coyote II · Cartersville, GAThe loss of engine power during cruise flight for undetermined reasons, which resulted in an forced landing, on ground collision with a ditch, and nose over.Mar 5, 2006 · N5196W · Substantial damageNTSB MIA06LA061Accident · No injuriesLimited investigationFinal reportBell 206B · Naples, FLThe pilot's selection of an unsuitable area to make a precautionary landing which resulted in the helicopter rolling into a ditch.Mar 4, 2006 · N6BR · Substantial damageNTSB DFW06CA081Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Texarkana, ARThe loss of engine power due to a cracked cylinder. Contributing factors were the pilot's failure to maintain adequate airspeed.Mar 4, 2006 · N6641Q · Substantial damageNTSB DFW06CA077Accident · No injuriesData collectionFinal reportCessna 182C · Gilliam, LAThe loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to use carburetor heat and the lack of suitable terrain for the forced landing.Mar 4, 2006 · N8519T · Substantial damageNTSB MIA06LA058Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Fort Pierce, FLImproper magneto installation by maintenance personnel, which resulted in the magneto detaching from the engine and subsequent loss of engine power.Mar 1, 2006 · N511G · Substantial damageNTSB CHI06LA088Accident · No injuriesLimited investigationFinal reportIrwin Sonex 2180 · Rockford, ILThe loss of engine power due to the restricted movement of the throttle cable during cruise flight. A factor in the accident was the trees contacted during the forced landing.Feb 27, 2006 · N514KP · Substantial damageNTSB DEN06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Parker, COthe improper maintenance procedures resulting in the unseating of the number two main bearing. Contributing factors include the mechanic's improper troubleshooting procedures, and the pilot's improper decision to continue operating the airplane with known…Feb 25, 2006 · N2939V · Substantial damageNTSB CHI06LA087Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Rockford, OHThe fuel exhaustion due to the inadequate preflight planning/preparation by the pilot-in-command. Additional causes were the inadequately planned approach and improper emergency procedure by the pilot-in-command.Feb 24, 2006 · N6366S · Substantial damageNTSB SEA06FA055Accident · 2 fatalField investigationFinal reportCessna 182P · Goldendale, WAThe pilot's failure to maintain terrain clearance during descent. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making.Feb 23, 2006 · N888SR · DestroyedNTSB SEA06FA054Accident · 1 fatalField investigationFinal reportBeech 58P · Bow, WAThe pilot's failure to maintain aircraft control during the climb to cruise. Contributing factors included a loss of engine power to the right engine folowing a turbocharger failure, instrument meteorological and dark night conditions.Feb 23, 2006 · N469MD · DestroyedNTSB ANC06FA020Accident · 2 fatalField investigationFinal reportRobinson R22 · Scottsdale, AZA loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain rotor rpm, which resulted in an uncontrolled descent and collision with terrain.Feb 22, 2006 · N7512G · DestroyedNTSB DEN06LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Torreon, NMThe jammed magneto drive gear and the fractured camshaft gear, which resulted in the total engine failure. A factor contributing to the accident was the unsuitable dirt road on which the pilot had to force land the airplane.Feb 20, 2006 · N9149W · Substantial damageNTSB MIA06LA056Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Fruitland Park, FLThe fatigue failure of the No. 4 cylinder resulting in a loss of engine power and subsequent forced landing.Feb 18, 2006 · N5262Q · Substantial damageNTSB LAX06CA120Accident · No injuriesData collectionFinal reportCessna 177 · Carefree, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and his failure to refuel the airplane prior to the accident flight.Feb 18, 2006 · N29377 · Substantial damageNTSB MIA06LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lehigh Acres, FLThe loss of engine power for undetermined reasons, resulting in a nose-over during the forced landing.Feb 16, 2006 · N14MA · Substantial damageNTSB LAX06FA113Accident · Serious injuriesField investigationFinal reportCessna 210M · Long Beach, CAan erroneous low fuel quantity indication that led the pilot to attempt a precautionary landing in a congested and less than ideal location. The erroneous fuel level indication was due to multiple anomalies with the alternator installation that precipitated a…Feb 13, 2006 · N6895B · DestroyedNTSB LAX06FA106Accident · 3 fatalField investigationFinal reportCessna 172RG · El Cajon, CAThe pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…Feb 9, 2006 · N9531B · 2 aircraft · DestroyedNTSB DCA06MA022Accident · Minor injuriesClass 1 · MajorFinal reportDouglas DC-8 · Philadelphia, PAan in-flight cargo fire that initiated from an unknown source, which was most likely located within cargo container 12, 13, or 14. Contributing to the loss of the aircraft were the inadequate certification test requirements for smoke and fire detection…Feb 8, 2006 · N748UP · DestroyedNTSB ATL06FA045Accident · 1 fatalField investigationFinal reportSwearingen SA-226-TC · Paris, TNThe pilot's inflight loss of control following a reported fuel asymmetry condition for undetermined reasons.Feb 8, 2006 · N629EK · Destroyed