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 CHI94LA242Accident · No injuriesLimited investigationFinal reportGrumman FM-2 · Woodburn, INthe total failure of the throttle linkage arm.Jul 22, 1994 · L1PP · Substantial damageNTSB CHI94LA236Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Cottage Hill, ILthe pilot inadequate preflight planning/preparation and his inaccurate fuel consumption calculations.Jul 22, 1994 · N7101M · Substantial damageNTSB SEA94LA187Accident · No injuriesLimited investigationFinal reportBeech P-35 · Laramie, WYLoss of engine power for undetermined reasons. Factors include fence posts struck during rollout at the emergency landing site.Jul 21, 1994 · N9768Y · Substantial damageNTSB ANC94LA091Accident · No injuriesLimited investigationFinal reportCessna T207A · Haines, AKFuel starvation as a result of the pilot's improper in-flight planning/decision and his failure to follow the procedures contained in the airplane checklist for engine failure.Jul 21, 1994 · CFHOI · Substantial damageNTSB ANC94LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe failure of the throttle control lever arm as a result of the improper 100 hour inspection by company maintenance personnel.Jul 18, 1994 · N4685F · Substantial damageNTSB LAX94LA286Accident · 2 fatalLimited investigationFinal reportCessna 150D · Carrville, CAa loss of engine power for undetermined reasons. The mountainous terrain and lack of a suitable forced landing area within gliding distance was a factor in the accident.Jul 16, 1994 · N6052T · DestroyedNTSB ATL94LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Vidalia, GAThe pilot's inadequate preflight planning, and his failure to refuel the aircraft, resulting in fuel exhaustion and engine stoppage. A factor were the trees at the forced landing area.Jul 16, 1994 · N6074G · Substantial damageNTSB NYC94LA129Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Stevensville, MDInadequate maintenance by which undertorquing of the accessory gear retaining bolt resulted in fatigue failure of the bolt and the subsequent loss of engine power.Jul 15, 1994 · N515TN · Substantial damageNTSB MIA94FA179Accident · 1 fatalField investigationFinal reportCessna 172XP · Indian Shores, FLA bird collision, which resulted in pilot incapacitation.Jul 15, 1994 · N2827V · DestroyedNTSB FTW94MA235Accident · 3 fatalMajor investigationFinal reportAerospatiale AS350D · Hanalei, HIFailure of the engine-driven fuel pump, which resulted in the loss of power, and the lack of aircraft flotation equipment. Factors related to the accident were: flight over water adjacent to terrain that afforded no suitable forced landing site, and the lack…Jul 15, 1994 · N151BH · Substantial damageNTSB FTW94LA238Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Winchester, ARThe loss of power due to the number one cylinder head cracking. A factor was the lack of suitable terrain for the forced landing.Jul 15, 1994 · N4903X · Substantial damageNTSB FTW94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Tulsa, OKThe loss of engine power for undetermined reasons. The lack of terrain suitable for a forced landing was a factor.Jul 14, 1994 · N5193W · Substantial damageNTSB NYC94FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Trout Run, PAthe delayed decision of the pilot to deviate from known weather which resulted in an inflight loss of control and impact with terrain.Jul 13, 1994 · N3150E · DestroyedNTSB FTW94FA231Accident · 4 fatalField investigationFinal reportAerospatiale AS-350B1 · Galveston, TXInadequate torquing of the left lateral servo by maintenance personnel, which allowed it to become disconnected from the controls, leading to an in-flight loss of control.Jul 13, 1994 · N350WM · DestroyedNTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.Jul 12, 1994 · N60426 · Substantial damageNTSB FTW94LA230Accident · Serious injuriesLimited investigationFinal reportNorth American Navion 4 · Dupont, LAThe loss of engine power due to inadequate maintenance adjustment of accessory drive starter gear screws which disengaged in flight. Factors were the lack of suitable terrain for the forced landing and non compliance with the applicable service letter.Jul 12, 1994 · N8648H · Substantial damageNTSB SEA94LA176Accident · No injuriesLimited investigationFinal reportBambrick Corben ACE · Arlington, WAFuel starvation due to the builders' inadequate design of the fuel system. Factors include high ambient temperatures during the climb, and a fence in the field where the forced landing took place.Jul 11, 1994 · CFKEZ · Substantial damageNTSB LAX94LA281Accident · Minor injuriesLimited investigationFinal reportSam Hale LONG-EZ · Camarillo, CAfuel starvation due to improper fuel management by the pilot.Jul 11, 1994 · N353H · Substantial damageNTSB LAX94LA280Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Tucson, AZAn engine power loss from fuel exhaustion due to the pilot's inaccurate fuel consumption calculations.Jul 11, 1994 · N3003S · Substantial damageNTSB CHI94DCQ02Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Colby, KSfuel starvation resulting from the fuel shutoff valve closing as a result of improper adjustment.Jul 11, 1994 · N4367F · Substantial damageNTSB FTW94FA226Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Gulf Of MexicoThe pilot's continued flight into known adverse weather. Factors were the thunderstorms and the pilot's disreqard for the forecasted adverse weather.Jul 10, 1994 · N55120 · DestroyedNTSB MIA94LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Tampa, FLThe pilot-in-command's improper approach during a forced landing following partial loss of engine power. The loss of engine power was a factor.Jul 9, 1994 · N5233R · Substantial damageNTSB ANC94LA078Accident · Serious injuriesLimited investigationFinal reportCessna T207 · Kenai, AKThe failure of the engine crankshaft. Factors in the accident were the pilot's inadequate compensation for the wind conditions and not attaining the proper touchdown point at the suitable landing strip.Jul 9, 1994 · N91056 · Substantial damageNTSB MIA94FA175Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Gulf Of MexicoLoss of engine power due to an undetermined reason. A factor related to the accident was: inadequate passenger briefing by the pilot.Jul 8, 1994 · N3610W · DestroyedNTSB CHI94LA225Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Grand Rapids, MIthe pilot's improper fuel tank selection resulting in fuel starvation.Jul 8, 1994 · N153C · Substantial damageNTSB FTW94LA229Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · South Bend, INThe encounter with unforcasted and unreported turbulence.Jul 7, 1994 · N60SW · No damageNTSB NYC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ellisburg, NYA fuel or fuel system problem that was probably related to the pilot/owner's failure to assure proper maintenance and/or inspection of the airplane before flight. A factor related to the accident was: soft terrain in the emergency landing area.Jul 6, 1994 · N5839P · Substantial damageNTSB MIA94GA174Accident · No injuriesFinal reportAerospatiale AS-350 · Caryville, FLThe pilot's intentional continued flight into instrument meteorological conditions. Contributing to the accident was pilot fatigue.Jul 6, 1994 · N901BA · Substantial damageNTSB MIA94LA173Accident · Serious injuriesLimited investigationFinal reportDouglas DC-9-32 · Valdosta, GAAn encounter with clear air turbulence that was not forecast nor observable on radar.Jul 5, 1994 · N901VJ · No damageNTSB FTW94LA222Accident · No injuriesLimited investigationFinal reportCessna 206E · Cleveland, TXLoss of engine power with the cause undetermined. A factor was the lack of suitable terrain for the forced landing.Jul 5, 1994 · N4945U · Substantial damageNTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.Jul 5, 1994 · N7917D · DestroyedNTSB SEA94FA167Accident · 2 fatalField investigationFinal reportBeech P35 · Cedar City, UTThe pilot's failure to maintain a proper climb rate and clearance from the terrain. Factors in the accident were the high density altitude and the aircraft being above the maximum certificated gross weight.Jul 4, 1994 · N1498G · Substantial damageNTSB LAX94LA274Accident · No injuriesLimited investigationFinal reportHayes Dickey E-RACER · Elko, NVa fatigue fracture and separation of the propeller flange from an improperly machined propeller extension assembly. Inadequate design, substantiation, and approval of the part design was a factor in the accident.Jul 3, 1994 · N99G · Substantial damageNTSB LAX94FA271Accident · 2 fatalField investigationFinal reportCessna 195A · Santa Paula, CAthe noninstrument-rated pilot's intentional VFR flight into IMC conditions and the resultant in-flight loss of control.Jul 3, 1994 · N9300A · DestroyedNTSB FTW94LA221Accident · No injuriesLimited investigationFinal reportBell OH-13E · Mountain View, ARThe fuel exhaustion as result of a struck fuel drain valve. Factors were the high density altitude, and the unsuitable terrain at the pilot's disposal for the forced landing.Jul 3, 1994 · N39WL · Substantial damageNTSB CHI94LA219Accident · No injuriesLimited investigationFinal reportCessna 150M · Waseca, MNinadequate preflight planning/preparation and the pilot's failure to refuel the airplane. Factors related to the accident were a poorly planned forced landing approach and high vegetation.Jul 3, 1994 · N63277 · Substantial damageNTSB NYC94LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Tinton Falls, NJThe loss of engine power for undetermined reasons.Jul 1, 1994 · N6979X · Substantial damageNTSB NYC94LA103Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Monmouth Beach, NJA power loss due to fuel starvation, for undetermined reasons. A factor was the night conditions.Jul 1, 1994 · N6375P · DestroyedNTSB NYC94FA106Accident · No injuriesField investigationFinal reportSikorsky S-76B · Newport, RIthe failure of the left hand helical gear in the main gear box (MGB), due to undertorqued attaching bolts installed by the manufacturer, which resulted in a partial MGB failure. This failure resulted in the loss of the number one engine, illumination of the…Jun 30, 1994 · N76UT · Substantial damageNTSB BFO94LA124Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sandy Hook, NJThe loss of engine power for reasons undetermined and the inability of the pilot to feather the propeller.Jun 30, 1994 · N7041Y · DestroyedNTSB NYC94LA111Accident · Serious injuriesLimited investigationFinal reportBoeing 767-200 · East Hampton, NYIn-flight encounter with turbulence in the vicinity of thunderstorms. A factor related to the accident was: improper planning/decision by the pilot(s).Jun 29, 1994 · N606TW · No damageNTSB MIA94FA169Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-11 · CaribbeanThe reserve first officer's unauthorized movement of the first officer's seat during flight which resulted in the first officer's legs being forced against the control column, pushing it forward, and disconnecting the autopilot. This resulted in the aircraft…Jun 29, 1994 · N1752K · Minor damageNTSB BFO94FA121Accident · 3 fatalField investigationFinal reportBeech 58TC · St Marys, WVAn in-flight fire of undetermined origin, prior to the in-flight breakup.Jun 29, 1994 · N333TK · DestroyedNTSB FTW94FA212Accident · Serious injuriesField investigationFinal reportPiper PA-46-350P · Akron, COThe loss of engine power due to oil exhaustion which resulted from a failed oil scraper ring. A factor was unsuitable terrain for a forced landing.Jun 25, 1994 · N51CC · Substantial damageNTSB CHI94DCJ02Accident · Minor injuriesFinal reportMueller Q2 · Utica, NEThe failure of the carburetor float valve. A related factor is the high vegetation at the landing site.Jun 25, 1994 · N524WM · DestroyedNTSB ATL94LA126Accident · Serious injuriesLimited investigationFinal reportGreen Starduster TOO · Chattanooga, TNThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall, and collision with terrain.Jun 25, 1994 · N11TG · Substantial damageNTSB SEA94LA157Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORFuel exhaustion due to a false indication on the fuel quantity sensor.Jun 24, 1994 · N59187 · Substantial damageNTSB CHI94DCJ01Accident · Serious injuriesFinal reportMustari Dragonfly Mark II · Scottsbluff, NEthe private pilot's inadequate preflight planning/preparation. A related factor is the high density altitude.Jun 24, 1994 · N3147B · DestroyedNTSB LAX94LA263Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cloverdale, CALoss of engine power for an unknown reason.Jun 23, 1994 · N8549C · Substantial damageNTSB MIA94LA165Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Sarasota, FLAltitude misjudged by the pilot.Jun 22, 1994 · N520TC · Substantial damage