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 CHI03LA052Accident · 1 fatalLimited investigationFinal reportHavir Avid Flyer · Cambridge, NEThe inadvertent stall by the pilot following a total loss of engine power and the seizure of the engine. A factor to the accident was the engine overhaul not performed in accordance with the manufacturer's recommendations.Jan 13, 2003 · N248H · DestroyedNTSB SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.Jan 12, 2003 · N6442Q · Substantial damageNTSB LAX03IA098Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Kahului, HIthe flight crew's failure to follow the checklist and detect an out of trim condition prior to takeoff.Jan 12, 2003 · N482HA · No damageNTSB LAX03FA066Accident · 2 fatalField investigationFinal reportCessna 182H · Parker, AZfailure of both pilot's to see and avoid one another while maneuvering in the traffic pattern. A factor in the accident was the inability of the Cessna pilot to communicate on the CTAF frequency due to the limitations of his radios.Jan 11, 2003 · N8567S · 2 aircraft · DestroyedNTSB LAX03FA065Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Westlake Villag, CAa fatigue crack in the propeller hub due to the inadequate design location of the grease fitting and the chamfering process.Jan 11, 2003 · N56484 · DestroyedNTSB DEN03IA033Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Salt Lake City, UTthe arcing wires in the lavatory sensor that resulted in the subsequent fire.Jan 11, 2003 · N551UA · Minor damageNTSB FTW03LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-BA · Venice, LAThe loss of tail rotor drive as a result of baggage coming in contact with the tail rotor blades after the aft cargo door was not secured. A contributing factor was the passenger's failure to follow the procedures for properly securing the helicopter's doors…Jan 9, 2003 · N22TV · DestroyedNTSB FTW03LA080Accident · Serious injuriesLimited investigationFinal reportBell 206B · Putnam, TXthe pilot's failure to properly interpret and confirm a faulty tachometer instrument indication and his improper flare during the ensuing precautionary autorotation, which resulted in a hard landing. Also causal was the failure of the tachometer.Jan 9, 2003 · N115TV · Substantial damageNTSB LAX03FA069Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Flagstaff, AZthe pilot's failure to comply with his instrument clearance route instruction and to maintain his assigned altitude. A factor in the accident was the poor quality of radio communications due to the severance of underground fiber optic voice and data lines for…Jan 8, 2003 · N135LA · DestroyedNTSB FTW03LA077Accident · No injuriesLimited investigationFinal reportCarlisle Comp Air 6 · Groesbeck, TXThe pilot's improper fuel selector position which resulted in the loss of engine power due to fuel starvation. A contributing factor was the soft terrain for the forced landing.Jan 8, 2003 · N628 · Substantial damageNTSB CHI03LA049Accident · No injuriesLimited investigationFinal reportCessna 150J · Garner, IAThe students pilots improper in-flight fuel planning resulting in exhaustion of the fuel supply, and the collapse of the nose gear during the forced landing. Factors were unsuitable landing are encountered by the pilot, the plowed field and the fuel…Jan 8, 2003 · N60834 · Substantial damageNTSB CHI03FA047Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Barrington Hill, ILThe pilot's improper fuel management, which resulted in fuel starvation. An inadequate preflight inspection and the trees encountered during the forced landing were contributing factors.Jan 7, 2003 · N74AA · Substantial damageNTSB LAX03LA059Accident · Serious injuriesLimited investigationFinal reportFarmer R B DA5-A · Apple Valley, CAthe detonation of the number 1 and 3 cylinders and the subsequent over temperature of those cylinders and their corresponding pistons.Jan 4, 2003 · N7053U · Substantial damageNTSB LAX03FA060Accident · 1 fatalField investigationFinal reportSchweizer 269C · Collinsville, CAA loss of engine power for undetermined reasons, and the pilot's failure to maintain main rotor rpm during the subsequent autorotation. A factor in the accident was the unsuitable nature of the terrain for a forced landing.Jan 4, 2003 · N98TH · DestroyedNTSB FTW03LA075Accident · No injuriesLimited investigationFinal reportCessna 401 · Mc Allen, TXThe pilot's failure to manually extend the landing gear to the full down and locked position. A contributing faction was a loss of electrical power, which resulted in the failure of the landing gear to extend.Jan 4, 2003 · N968JW · Substantial damageNTSB MIA03LA044Accident · No injuriesLimited investigationFinal reportCessna 150K · Jessup, GAThe loss of engine power for undetermined reasons. A contributing factor was unsuitable terrain.Jan 3, 2003 · N6098G · Substantial damageNTSB ATL03LA029Accident · No injuriesLimited investigationFinal reportMielec PZL-M-18 · Immokalee, FLThe pilot's inadequate in-flight planning/decision by his improper fuel management which resulted in fuel starvation. Also causal was the pilot's inadequate preflight planning which resulted in his failure to perform fuel consumption calculations and…Jan 3, 2003 · N45051 · Substantial damageNTSB SEA03LA023Accident · No injuriesLimited investigationFinal reportBell 47G · Idaho Falls, IDIn-flight loss of engine power for undetermined reasons.Jan 2, 2003 · N4759R · Substantial damageNTSB DEN03LA027Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH2000 · Milford, UTthe inadequate altitude chosen by the flight instructor, resulting in inadequate clearance and subsequent collision with mountainous terrain. Contributing factors were the instructor's failure to consult pertinent VFR sectional charts for the area, and the…Jan 2, 2003 · N8500R · DestroyedNTSB MIA03LA035Accident · Minor injuriesLimited investigationFinal reportLonnie Johnson RV6A · Peachtree City, GAThe failure of the pilot to activate carburetor heat control during cruise flight after experiencing a loss of engine rpm, inadequate carburetor heat system by the builder, and the unsuitable terrain encountered by the pilot-in-command during the forced…Jan 1, 2003 · N559LJ · Substantial damageNTSB ATL03FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Austell, GAThe pilot's inadequate preflight and in-flight planning/decision that resulted in fuel exhaustion, and subsequent loss of engine power.Dec 31, 2002 · N5118G · Substantial damageNTSB LAX03LA056Accident · No injuriesLimited investigationFinal reportNicholson Lancair 320 · Corona, CAThe pilot/builder's improper maintenance procedure for reattaching a high-pressure oil line, which resulted in the oil line disconnecting during flight, followed by a loss of oil and engine seizure.Dec 30, 2002 · N364M · Substantial damageNTSB FTW03LA070Accident · No injuriesLimited investigationFinal reportCessna T207 · Brownsville, TXThe loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing.Dec 30, 2002 · N1599U · Substantial damageNTSB DEN03FA028Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Steamboat Spgs, COthe pilot's inadequate in-flight planning/decision making resulting in insufficient altitude to fly over the mountain, and the subsequent inadvertent stall/mush into tree covered mountainous terrain. Contributing factors were the tail wind and high density…Dec 29, 2002 · N7989C · DestroyedNTSB ANC03LA021Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Nikolai, AKAn improper and undocumented major repair of the elevator torque tube support assembly by an unknown person, which resulted in an in-flight disconnection of the airplane's right elevator, and a jammed rudder. A factor associated with the accident is the…Dec 28, 2002 · N3904 · Substantial damageNTSB DEN03FA025Accident · 2 fatalField investigationFinal reportCessna 421 · Akron, COThe fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the…Dec 25, 2002 · N421D · DestroyedNTSB ATL03LA031Accident · No injuriesLimited investigationFinal reportBeech F-35 · Hollywood, FLThe pilot exceeded the design limits of the airplane which resulted in an in flight structural failure.Dec 25, 2002 · N4268B · Substantial damageNTSB SEA03LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Boise, IDThe failure of the operator's maintenance personnel to properly rig the left/right seat twistgrip throttles to the engine fuel control, the pilot in command's failure to adhere to the rotorcraft flight manual, and the check pilot's premature flare during the…Dec 24, 2002 · N8366F · Substantial damageNTSB LAX03FA054Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Dolan Springs, AZthe pilot's inadequate visual lookout and failure to maintain clearance from power lines. A factor was the pilot's decision to conduct cruise flight at a low altitude.Dec 23, 2002 · N888KB · DestroyedNTSB FTW03LA066Accident · No injuriesLimited investigationFinal reportHughes 369E · Fritch, TXThe loss of engine power due to the failure of the generator input drive-end bearing, which resulted in excessive vibrations that induced a fatigue fracture of the Pc line leading to the engine fuel control unit. A contributing factor was the lack of suitable…Dec 22, 2002 · N5234Y · Substantial damageNTSB CHI03LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Carleton, MIThe #2 cylinder exhaust valve failed due to undetermined reasons. A factor associated with the accident was the soft terrain encountered during the forced landing.Dec 22, 2002 · N8555W · Substantial damageNTSB IAD03FA024Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Woodbury, CTAn engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain.Dec 21, 2002 · N8168G · DestroyedNTSB ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.Dec 21, 2002 · N47420 · DestroyedNTSB FTW03LA061Accident · 1 fatalLimited investigationFinal reportCreekmore Team Rocket F-1 · Rosenberg, TXThe in-flight separation of the vertical stabilizer as a result of the builder's failure to install the upper attachment fitting for the vertical fin aft spar.Dec 20, 2002 · N140TC · DestroyedNTSB CHI03LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Osage Beach, MOFuel Starvation due to the failure of the mechanical fuel pump and the inoperable electric fuel pump caused by the electrical system failure. Factors were the unsuitable terrain and the trees.Dec 20, 2002 · N3236Y · Substantial damageNTSB SEA03LA019Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC-135 P1 · Loon Lake, WAThe pilot's inadvertent flight into instrument meteorological conditions (IMC) while in cruise flight, and an excessive descent rate. Factors include falling snow, whiteout conditions and dark night conditions.Dec 18, 2002 · N311MS · Substantial damageNTSB MIA03LA028Accident · No injuriesLimited investigationFinal reportBeech A36 · Laurens, SCImproper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation…Dec 15, 2002 · N12MB · Substantial damageNTSB MIA03LA033Accident · No injuriesLimited investigationFinal reportBeech 200 · Jacksonville, FLFailure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing.Dec 14, 2002 · N623VP · Substantial damageNTSB MIA03LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-150 · Cashiers, NCThe pilot's inadequate in-flight decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain terrain clearance. Contributing factors were a low ceiling and mountainous terrain.Dec 14, 2002 · N5899W · Substantial damageNTSB FTW03LA060Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Bryson, TXthe pilot's inadequate inflight planning and decision which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane and dark night conditions were contributing factors.Dec 14, 2002 · N8925W · Substantial damageNTSB MIA03FA024Accident · 2 fatalField investigationFinal reportAaa Aircraft Leasing 192 · Miami, FLThe inflight fire of undetermined origin, which resulted in pilot incapacitation, loss of aircraft control and an inflight collision with a building.Dec 6, 2002 · N192FW · DestroyedNTSB DEN03FA023Accident · 1 fatalField investigationFinal reportRockwell Commander 114 · Hot Springs, ARthe loss of engine power due to the failure of the engine ignition system's single-drive dual-magneto, and the magneto's improper installation by unknown maintenance personnel. Contributing factors were the improper installation of the magneto by unknown…Dec 6, 2002 · N314M · DestroyedNTSB CHI03IA033Incident · No injuriesIncident investigationFinal reportHughes OH-6 · Moberly, MOThe loss of tail rotor effectiveness during cruise flight due to the bellcrank pivot pin becoming separated from the non-rotational swashplate. The plain brass liner of the non-rotating swashplate and the bellcrank pivot pin were worn.Dec 5, 2002 · N353RK · Minor damageNTSB SEA03LA016Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Tekoa, WAThe pilot's failure to maintain clearance from the terrain while attempting to fly a non-IFR equipped aircraft solely by reference to its instruments after the aircraft's windshield became coated with freezing rain in cruise flight. A factor was the pilot's…Dec 4, 2002 · C-FIIF · Substantial damageNTSB NYC03LA028Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Dalton, MAThe pilot's inadequate preflight inspection of the aircraft, which resulted in a total loss of engine power due to fuel contamination. A factor was the cold air temperature.Dec 4, 2002 · C-FXJK · Substantial damageNTSB FTW03FA055Accident · 1 fatalField investigationFinal reportCessna 421C · Tajique, NMThe pilot's failure to maintain terrain clearance. 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.Dec 4, 2002 · N3855C · DestroyedNTSB MIA03LA023Accident · Minor injuriesLimited investigationFinal reportBeech 35-B33 · Gainesville, GAa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.Dec 3, 2002 · N8578M · Substantial damageNTSB FTW03LA056Accident · No injuriesLimited investigationFinal reportCessna 172M · Vici, OKThe pilot's departure and continued flight into adverse weather conditions. Contributing factors were the icing conditions, and the lack of suitable terrain for the precautionary landing.Dec 3, 2002 · N4470R · Substantial damageNTSB SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.Nov 30, 2002 · N313FC · DestroyedNTSB SEA03TA014Accident · No injuriesFinal reportHughes OH-6A · Snohomish, WALoss of engine power for undetermined reasons while in cruise flight. A tree was a factor.Nov 29, 2002 · N13SD · Substantial damage