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 LAX01LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anza, CAThe pilot's failure to maintain control of the airplane following the opening of the cockpit/cabin door. The door came open because of improperly installed upholstery, which resulted in the inability to lock the door.Mar 14, 2001 · N333PE · Substantial damageNTSB IAD01LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Huntington, WVThe pilot's inadequate preflight inspection, which resulted in residual fuel contamination and a subsequent engine failure. Factors included corroded fuel filler necks and rain the previous evening.Mar 14, 2001 · N6584F · Substantial damageNTSB DEN01FA070Accident · 4 fatalField investigationFinal reportBeech A36 · Jackson Hole, WYthe pilot's continued VFR flight into instrument meteorological conditions which resulted in an inflight collision with terrain during cruise flight. Factors were the pilot's inadequate preflight planning in that he failed to familiarize himself with the…Mar 12, 2001 · N1080A · DestroyedNTSB MIA01LA097Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Orlando, FLa fire due to a broken and separated turbocharger exhaust which allowed hot exhaust to ignite the engine shroud.Mar 11, 2001 · N5687H · DestroyedNTSB DEN01LA067Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Buffalo, WYfailure of the rotor drive system clutch assembly which rendered the aircraft uncontrollable.Mar 11, 2001 · N144MB · Substantial damageNTSB DEN01FA066Accident · 1 fatalField investigationFinal reportCessna T210L · Howard, COthe pilot's continuation of a VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance. Contributing factors were his failure to obtain a preflight weather briefing, and his failure to obtain any in-flight…Mar 10, 2001 · N222ED · DestroyedNTSB CHI01LA101Accident · No injuriesLimited investigationFinal reportCessna P206 · Derby, KSThe misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.Mar 10, 2001 · N2507X · Substantial damageNTSB CHI01FA100Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Erhard, MNThe pilot's failure to maintain aircraft control. Factors relating to the accident were the pilot's encounter with known adverse weather conditions, the low ceiling, the pilot disregarding the weather observation information obtained prior to the flight, and…Mar 10, 2001 · N55893 · DestroyedNTSB LAX01FA113Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Essex, CARupture of the fuel injection flow divider diaphragm due to improper manufacture of the raw material stock from which the diaphragm was fabricated. The diaphragm tear resulted in complete engine power loss, which required the pilot to descend into an…Mar 9, 2001 · N1965H · DestroyedNTSB LAX01FA112Accident · 1 fatalField investigationFinal reportNorth American Navion · Santa Ysabel, CAthe pilot's continued VFR flight into IFR conditions, which resulted in a loss of control due to spatial disorientation.Mar 9, 2001 · N91445 · DestroyedNTSB DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.Mar 9, 2001 · N1121J · Substantial damageNTSB SEA01LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Saint Helens, ORthe pilot's improper use of the carburetor heat while attempting to determine if there was ice accumulating in the carburetor throat. Factors include flight in conditions conducive to carburetor icing, and a fence running across the field in which the forced…Mar 8, 2001 · N6337P · Substantial damageNTSB SEA01FA060Accident · 1 fatalField investigationFinal reportCessna U206G · Mica, WAThe pilot's continued flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, drizzle/mist, rising terrain, and the non-availability of a functioning transponder.Mar 8, 2001 · CGISV · Substantial damageNTSB LAX01LA110Accident · 2 fatalLimited investigationFinal reportJones RV-6A · Inyokern, CAthe in-flight collision with mountainous terrain during a forced landing following a loss of engine power resulting from the pilot's inadequate weather evaluation, continued flight into icing weather conditions, his delay in carburetor heat use, and his delay…Mar 7, 2001 · N46KA · Substantial damageNTSB CHI01LA099Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Dekalb, ILFuel starvation, the pilot not switching the fuel selector to the other fuel tank, and the pilot not maintaining control of the airplane through the forced landing attempt. Factors relating to this accident were the pilot's inadequate fuel management, the…Mar 7, 2001 · N9886U · Substantial damageNTSB SEA01LA057Accident · No injuriesLimited investigationFinal reportCassutt II · Moses Lake, WAFailure of a wrist pin plug in the engine, resulting in partial blockage of the engine lubrication system and partial failure of the engine connecting rod bearings; and the pilot's subsequent failure to maintain adequate airspeed during a forced landing…Mar 4, 2001 · N1431 · Substantial damageNTSB LAX01LA108Accident · Minor injuriesLimited investigationFinal reportHarlow Lancair ES · Marana, AZFailure of the propeller reduction drive unit which resulted in drive belt and pulley failure and a subsequent loss of thrust requiring an emergency landing on soft terrain. The reason for the bearing and/or belt failure was not determined. A factor was the…Mar 4, 2001 · N350N · Substantial damageNTSB LAX01LA107Accident · No injuriesLimited investigationFinal reportChristian Rans S-12 · Ramona, CAThe in-flight failure of the engine crankshaft for undetermined reasons.Mar 3, 2001 · N12FC · Substantial damageNTSB ANC01LA039Accident · No injuriesLimited investigationFinal reportHelio H-295 · Clear, AKThe shifting of engine connecting rod bearings, and the fracture of an engine connecting rod.Mar 3, 2001 · N42DC · Substantial damageNTSB FTW01LA074Accident · No injuriesLimited investigationFinal reportCessna 182P · Tuttle, OKfuel exhaustion due to a loose fuel cap as a result of the pilot's inadequate preflight. A contributory factor was the lack of suitable terrain for the forced landing.Mar 2, 2001 · N4721K · Substantial damageNTSB IAD01LA035Accident · No injuriesLimited investigationFinal reportCessna 210 · Newark, OHImproper maintenance, which resulted in the failure of the instrument panel shock mounts.Mar 1, 2001 · N3738Y · Substantial damageNTSB DEN01LA059Accident · Serious injuriesLimited investigationFinal reportMeshko Zenair CH-701 · Hudson, COthe loss of engine power as a result of detonation. A contributing factor was the unsuitable terrain on which to make a forced landing.Mar 1, 2001 · N4386W · Substantial damageNTSB DEN01FA058Accident · 1 fatalField investigationFinal reportBell 412SP · Grand Junction, COthe pilot's failure to maintain rotor speed during an intentional autorotation, which resulted in a loss of control.Feb 28, 2001 · N412SM · DestroyedNTSB LAX01LA105Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-120 · Monterey, CAmoisture contamination of the elevator trim actuators, which allowed the units to freeze at altitude resulting in an abrupt pitch change when the units thawed at lower altitudes.Feb 26, 2001 · N288SW · No damageNTSB DEN01LA055Accident · No injuriesLimited investigationFinal reportCessna 172F · Larkspur, COthe flight instructor inadvertently stalling the airplane during a forced landing. Contributing factors were fuel exhaustion due to inadvertent opening of the fuel drain, lack of familiarity with the airplane, inadequate supervision of the flight, and the…Feb 26, 2001 · N8389U · Substantial damageNTSB DEN01FA056Accident · 1 fatalField investigationFinal reportBeech V35B · Green River, UTthe pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.Feb 26, 2001 · N4637M · DestroyedNTSB NYC01LA080Accident · No injuriesLimited investigationFinal reportCessna 172I · Suffolk, VAThe pilot's improper in-flight planning/decision and his failure to refuel, which resulted in fuel exhaustion.Feb 25, 2001 · N46115 · Substantial damageNTSB MIA01LA085Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Whitesburg, GAThe improper emergency procedure performed by the pilot due to his electing to perform a run-on landing resulting in excessive airspeed at touchdown and subsequent roll-over following ground contact with grass. A contributing factor was the inadequate…Feb 24, 2001 · N5307V · Substantial damageNTSB MIA01LA082Accident · 4 fatalLimited investigationFinal reportBeech 36 · Tybee Island, GAThe flights entry into a descending right turn for undetermined reasons resulting in the flight crashing into the ocean.Feb 19, 2001 · N7703R · DestroyedNTSB CHI01FA113Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Norris, SDThe pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.Feb 19, 2001 · N9927S · DestroyedNTSB CHI01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Overton, NEThe open exhaust valve. Factors relating to the accident were the sticking exhaust valve guide and the snow drift the airplane encountered during the precautionary landing.Feb 18, 2001 · N5886Z · Substantial damageNTSB MIA01LA081Accident · No injuriesLimited investigationFinal reportCessna 182H · Weaver, ALDamage to the No. 4 cylinder intake valve push rod tube at an undetermined time which resulted in the push rod rubbing on the push rod tube and failing due to wear, resulting in loss of engine power and damage to the airplane during a forced landing in a…Feb 17, 2001 · N8556S · Substantial damageNTSB FTW01LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA32-R-301T · Haslet, TXthe improper installation of the oil filter bypass valve by an unknown person, which resulted in the loss of engine oil and subsequent loss of total power during a normal descent. A contributing factor to the accident was the lack of suitable terrain for the…Feb 17, 2001 · N8355L · Substantial damageNTSB FTW01FA069Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Borger, TXthe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain obstacle clearance. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing and the dark night conditions.Feb 16, 2001 · N4002M · DestroyedNTSB FTW01LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKthe pilot's delay in switching the fuel selector, which resulted in fuel starvation in cruise flight.Feb 12, 2001 · N2457Q · Substantial damageNTSB CHI01LA088Accident · No injuriesLimited investigationFinal reportMooney M20K · New Hudson, MIInadequate preflight planning/preparation which resulted in an adequate fuel supply for the flight and subsequently in fuel starvation. A factor associated with the accident was the steep bank which the airplane contacted during the forced landing.Feb 10, 2001 · N1157P · Substantial damageNTSB FTW01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Bishop, TXthe pilot's failure to maintain altitude and clearance from terrain. Contributing factors were the pilot's diverted attention and the low ceiling.Feb 8, 2001 · N5695G · Substantial damageNTSB CHI01LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mitchell, SDThe pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.Feb 7, 2001 · N10ET · Substantial damageNTSB MIA01LA073Accident · No injuriesLimited investigationFinal reportCessna A150K · Cabo Rojo, PRThe failure of the pilot to use carburetor heat during descent resulting in loss of engine power due to carburetor icing and the airplane colliding with a fence and nosing over during a forced landing.Feb 6, 2001 · N5915J · Substantial damageNTSB ATL01LA031Accident · Serious injuriesLimited investigationFinal reportSorrell SNS-2 Guppy · Raymond, MSThe failure of the rudder horn bracket, that resulted in the inflight loss of control.Feb 6, 2001 · N6334F · DestroyedNTSB ANC01LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Anvik, AKThe pilot's continued VFR flight into instrument meteorological conditions, and subsequent in-flight collision with terrain during descent. Factors in the accident were the presence of fog, and snow-covered terrain.Feb 6, 2001 · N3334M · Substantial damageNTSB LAX01LA088Accident · No injuriesLimited investigationFinal reportFish RV6 · Georgetown, CAThe total loss of engine power due to fracture and separation of the engine crankshaft.Feb 5, 2001 · N1198N · Substantial damageNTSB MIA01FA071Accident · 2 fatalField investigationFinal reportMooney M20R · Bluffton, SCThe pilot's failure to maintain control due to spatial disorientation.Feb 4, 2001 · N88FJ · DestroyedNTSB SEA01LA045Accident · No injuriesLimited investigationFinal reportAlexander MA-5 Charger · Spanaway, WAthe pilot's failure to apply carburetor heat prior to takeoff while operating in serious carburetor icing conditions. Factors include operating in serious carburetor icing conditions, and rough/uneven terrain in the area of the forced landing.Feb 3, 2001 · N58LA · Substantial damageNTSB LAX01LA085Accident · No injuriesLimited investigationFinal reportCessna T210M · Kelseyville, CAThe failure of the pilot to comply with emergency procedures contained in the Pilot's Operating Handbook, which resulted in an excessively rich mixture and loss of engine power.Feb 3, 2001 · N761SE · Substantial damageNTSB FTW01LA067Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS.125-700A · New Orleans, LAthe pilot-in-command's inadequate preflight inspection, which resulted in a flight with a blocked fuel tank vent. A contributing factor was maintenance personnel's failure to remove the tape covering the fuel tank vent following a pressure test.Feb 3, 2001 · N190WC · Substantial damageNTSB ATL01LA029Accident · Minor injuriesLimited investigationFinal reportRobert D. Wood Velocity Xlfg · Sebastian, FLThe manufacturer's inadequate design of the winglet/rudder assembly, and inadequate bonding techniques for metal to fiber structures, which resulted in control surface flutter.Feb 3, 2001 · N658SE · Substantial damageNTSB LAX01LA089Accident · Minor injuriesLimited investigationFinal reportArthur Dragonfly · Marana, AZA total loss of engine power for undetermined reasons. Contributing to the accident was the rough/uneven terrain.Feb 2, 2001 · N29KK · Substantial damageNTSB NYC01LA074Accident · No injuriesLimited investigationFinal reportBeech B-19 · Louisa, VAThe pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.Feb 1, 2001 · N9746L · Substantial damageNTSB FTW01LA057Accident · Minor injuriesLimited investigationFinal reportBeech BE-58 · Brinkley, ARthe pilot's poor inflight planning and decision making which resulted in his executing a precautionary landing in a soft field. A contributing factor was the lack of suitable terrain for the precautionary landing.Feb 1, 2001 · N448DH · Substantial damage