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 MIA04LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Ocala, FLloss of engine power due to oil starvation for undetermined reasons, resulting in an in-flight collision with a fence during a forced landing.Oct 27, 2003 · N4103H · Substantial damageNTSB FTW04LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Henryetta, OKA loss of engine power due to fuel starvation. A contributing factor was the inadequate inflight planning procedures for a cross country flight.Oct 26, 2003 · N8090E · Substantial damageNTSB CHI04LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Ann Arbor, MIThe loss of engine power due to carburetor ice. Weather conditions conducive to the formation of carburetor ice and a roadway were contributing factors.Oct 26, 2003 · N191GC · Substantial damageNTSB LAX04CA024Accident · No injuriesData collectionFinal reportCessna 172N · Fresno, CAthe pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power. Also causal was the pilot's failure to follow engine out emergency procedures as defined by the pilot operating handbook.Oct 25, 2003 · N738YL · Substantial damageNTSB ATL04LA025Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Edgefield, SCThe pilot's failure to follow the checklist to ensure the fuel filler cap was secured resulting in fuel starvation and subsequent loss of engine power.Oct 24, 2003 · N3007R · Substantial damageNTSB DEN04IA014Incident · No injuriesIncident investigationFinal reportLearjet 45 · Denver, COthe failure of the airplane's spoiler system when used as speed brakes due to high resistances in the spoilers' actuator coils.Oct 22, 2003 · N420FX · No damageNTSB FTW04LA013Accident · Minor injuriesLimited investigationFinal reportPrill RV-6 · Snyder, TXThe failure of the propeller blade for undetermined reason. A contributing factor was the lack of suitable terrain.Oct 17, 2003 · N3XS · Substantial damageNTSB FTW04LA011Accident · Minor injuriesLimited investigationFinal reportBeech 65-A90 · Fentress, TXThe loss of engine power for undetermined reasons.Oct 17, 2003 · N511BF · DestroyedNTSB LAX04LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Lancaster, CAA loss of engine power due to thermal fatigue failure of the first stage turbine wheel resulting in release of a section of its rim. The thermal fatigue was due to the engine exceeding its temperature limits during one or more start cycles.Oct 16, 2003 · N700TT · Substantial damageNTSB DEN04LA011Accident · No injuriesLimited investigationFinal reportCessna 177 · Nageezi, NMthe pilot's inadequate preflight planning, inadequate fuel consumption calculations, and improper fuel management. Contributing factors include fuel exhaustion resulting in the loss of power, the lack of suitable terrain for a forced landing and the tree.Oct 16, 2003 · N2246Y · Substantial damageNTSB CHI04LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Davenport, IAA loss of engine power due to fuel starvation as a result of the improper installation of the fuel nozzle. Also causal was the engine manufacturer's improper installation instructions for the nozzle pressure port plug on the fuel manifold valve. A factor…Oct 16, 2003 · N25496 · Substantial damageNTSB CHI04LA023Accident · No injuriesLimited investigationFinal reportCessna A185E · Cedarville, MIA loss of engine power for undetermined reasons. A factor associated with the accident was the rough terrain on which the airplane was landed.Oct 14, 2003 · N3399L · Substantial damageNTSB CHI04LA009Accident · No injuriesLimited investigationFinal reportBeech A33 · Grandview, MOSeparation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.Oct 14, 2003 · N471T · Substantial damageNTSB ATL04LA029Accident · No injuriesLimited investigationFinal reportYakovlev YAK55M · Troy, ALA loss of engine power due to a fractured connecting rod for undetermined reasons.Oct 14, 2003 · N55YA · Substantial damageNTSB CHI04LA011Accident · Minor injuriesLimited investigationFinal reportDomeier RV-7A · Augusta, MOThe failure of the supercharger and alternator drive belts which resulted in foreign object damage to the valve timing system and subsequent loss of engine power, and the unsuitable terrain encountered by the pilot during the forced landing. A factor was the…Oct 13, 2003 · N707DD · Substantial damageNTSB ATL04LA017Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Carrollton, GAA loss of engine power for undetermined reasons.Oct 13, 2003 · N4085H · Substantial damageNTSB ATL04FA016Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Cordesville, SCThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent uncontrolled descent into trees and the ground. A factor was physical impairment.Oct 13, 2003 · N63942 · Substantial damageNTSB LAX04LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe fracture and failure of the left landing gear actuator. Contributing to the accident was the operator's failure to comply with the manufacturer's service bulletin.Oct 12, 2003 · N6543V · Substantial damageNTSB ANC04LA003Accident · Minor injuriesLimited investigationFinal reportFairchild 42 · Wasilla, AKThe inadequate inspection of the carburetor by the aircraft mechanic who had recently worked on the carburetor, which failed to detect a cracked float, resulting in a total loss of engine power during cruise flight. A factor associated with the accident was…Oct 12, 2003 · N106M · Substantial damageNTSB SEA04LA004Accident · No injuriesLimited investigationFinal reportSeabase Magnum · Olney, MTThe pilot's failure to adequately preflight the aircraft to verify the fuel quantity, resulting in fuel exhaustion and the loss of engine power during cruise flight. Contributing factors were the pilot's failure to refuel the aircraft and the soft terrain.Oct 9, 2003 · N1966G · Substantial damageNTSB SEA04FA003Accident · 2 fatalField investigationFinal reportCessna 177B · Chinook, MTThe total loss of engine power in cruise flight due to the separation of the carburetor from its mounting bolts, and the pilot's failure to adequately compensate for strong crosswinds while attempting the subsequent forced landing. Additional factors include…Oct 9, 2003 · N30921 · DestroyedNTSB LAX04LA005Accident · No injuriesLimited investigationFinal reportCessna 182A · Jean, NVthe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.Oct 7, 2003 · N3904D · Substantial damageNTSB CHI04LA005Accident · No injuriesLimited investigationFinal reportWaco CTO · Greenfield, INThe loss of engine power during cruise and subsequent fire for undetermined reasons.Oct 7, 2003 · N9577H · DestroyedNTSB ATL04TA012Accident · No injuriesFinal reportCessna 210L · Tallahassee, FLLoss of engine power due to crankshaft counterweight failure.Oct 7, 2003 · N59063 · Substantial damageNTSB FTW04LA004Accident · 2 fatalLimited investigationFinal reportColliander RV-8 · Van, TXThe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributing factors were the low ceilings, rain, and fog.Oct 6, 2003 · N27JW · DestroyedNTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.Oct 6, 2003 · N4662X · Substantial damageNTSB DEN04LA005Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons LBL · Albuquerque, NMthe inadequate in-flight planning/decision by the pilot. Contributing factors include the inadvertent activation of the deflation line by the pilot and the retaining wall.Oct 5, 2003 · N994AF · No damageNTSB DCA04IA002Incident · No injuriesIncident investigationFinal reportAirbus Industrie A330 · Miami, FLan uncontained engine failure that resulted from the coking (carbon build-up) in a vent tube which led to a fire and the subsequent liberation of the IP turbine blades. Contributing to the cause of the uncontained engine failure was the absence of measures to…Oct 5, 2003 · HB-IQZ · Minor damageNTSB ATL04LA008Accident · No injuriesLimited investigationFinal reportCessna 182H · Knoxville, TNThe pilot's inadequate preflight inspection by his failure to secure the left fuel tank cap which resulted in fuel exhaustion, and the loss of engine power.Oct 5, 2003 · N1919X · Substantial damageNTSB FTW04CA002Accident · No injuriesData collectionFinal reportPrice Cuby Acro Trainer · Canutillo, TXThe pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the pilot's inadequate in-flight planning and decision making.Oct 4, 2003 · N300HS · Substantial damageNTSB NYC04CA001Accident · No injuriesData collectionFinal reportWilliams RV-4 · Metz, WVThe pilot's improper decision to operate without accurate fuel gauges, which resulted in a power loss due to fuel exhaustion, and an off airport landingOct 3, 2003 · N475F · Substantial damageNTSB DEN04FA002Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Teasdale, UTThe student pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the student pilot's inadvertent flight into adverse weather conditions, the low ceiling, the rain, the student…Oct 3, 2003 · N7357W · DestroyedNTSB CHI04LA002Accident · Minor injuriesLimited investigationFinal reportGoldman Dragonfly · Peoria, ILThe loss of power for undetermined reasons and the inadvertent stall of the canard by the pilot on the turn to final during the forced landing, as well as the excessive descent rate causing the aircraft to "pancake" into the ground.Oct 3, 2003 · N222TH · Substantial damageNTSB CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.Oct 3, 2003 · N3772D · Substantial damageNTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.Oct 2, 2003 · N479EV · Minor damageNTSB FTW04LA001Accident · Serious injuriesLimited investigationFinal reportBratton Experimental Homebuilt Swearingen SX300 · Floresville, TXThe separation of one propeller blade while in cruise flight. A factor contributing to the accident was the lack of suitable terrain for the forced landing.Oct 2, 2003 · N301SX · Substantial damageNTSB LAX04FA001Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Corona, CAfailure of the turbocharger exhaust clamp due to a pre-existing weld crack, which allowed the release of high temperature exhaust gasses in the engine compartment, causing an in-flight fire.Oct 1, 2003 · N481CA · DestroyedNTSB DEN04LA001Accident · No injuriesLimited investigationFinal reportElliott Mustang II · Cedar City, UTThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power.Oct 1, 2003 · N9XQ · Substantial damageNTSB ATL03LA151Accident · Serious injuriesLimited investigationFinal reportSheppard S-2 · Obion, TNThe failure of the elevator control pushrod, that resulted in an uncontrolled descent and subsequent in-flight collision with ground.Sep 30, 2003 · N39S · Substantial damageNTSB SEA03LA197Accident · No injuriesLimited investigationFinal reportThompson Avid Flyer · Roche Harbor, WAA complete loss of power due to fuel starvation for undetermined reason(s).Sep 28, 2003 · N6611 · Substantial damageNTSB LAX03LA300Accident · 2 fatalLimited investigationFinal reportMcClanahan Stits Playmate SA-11 · Fontana, CAa loss of engine power due to oil starvation that was the result of misaligned main bearing halves that obstructed the oil galley passages. Since the history of the engine could not be reconstructed, the person or entity responsible for the bearing…Sep 27, 2003 · N9YC · DestroyedNTSB CHI03LA322Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Lincoln, NEThe total loss of engine power due to the fatigue fracture of the engine accessory gear drive. A factor was the concrete marker.Sep 27, 2003 · N6624M · Substantial damageNTSB ATL03FA147Accident · 2 fatalField investigationFinal reportGrumman HU-16C · Fort Pierce, FLA loss of engine power due to the pilot placing the fuel selector in the off position which resulted in fuel starvation to the left engine, after the pilot intentionally shut down the right engine.Sep 25, 2003 · N70258 · DestroyedNTSB ANC03LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nenana, AKThe loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.Sep 24, 2003 · N330T · Substantial damageNTSB CHI03LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chanute, KSThe pilot 's inadequate in-flight planning/decision which resulted in both his in-flight encounter with weather, and the loss of power due to fuel exhaustion. Factors associated with the accident were the night conditions, fog, and the pilot becoming lost and…Sep 22, 2003 · N122CC · Substantial damageNTSB CHI03LA314Accident · No injuriesLimited investigationFinal reportCessna 182S · Joliet, ILThe pilot not performing a go-around when the other airplane taxied onto the landing runway, which resulted in the pilot not attaining the proper touchdown point. Factors to the accident include the failure of the alternator, the complete loss of electrical…Sep 21, 2003 · N775WB · Substantial damageNTSB ATL03LA143Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Summerville, SCA loss of engine power due to the failure of the engine # 6 connecting rod bearing. A factor was the collision with a gate.Sep 20, 2003 · N3721K · Substantial damageNTSB MIA03LA186Accident · Minor injuriesLimited investigationFinal reportS. FL. Ultralights Capella Classic · Port Charlotte, FLThe loss of engine power for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced landing resulting in the airplane cart wheeling and subsequent substantial damage.Sep 19, 2003 · N82536 · Substantial damageNTSB MIA03LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Ocean Springs, MSThe failure of the pilot to transfer fuel from the auxiliary fuel tank to the right main fuel tank in-flight resulting in total loss of engine power due to fuel starvation.Sep 19, 2003 · N79491 · Substantial damageNTSB FTW03LA230Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Wayne, OKA loss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. Factors were the lack of suitable terrain for the forced landing.Sep 19, 2003 · N3336M · Substantial damage