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 CHI92DCD01Accident · 1 fatalFinal reportRaymond Bristow Rand KR-2 · Boone, IAFailure of the pilot to maintain aircraft control. A factor in the accident is total failure of the airplane canopy.Feb 3, 1992 · N1066 · DestroyedNTSB CHI92LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Cedar Rapids, IAA result of the pilot-in-command not understanding the airplanes emergency procedures and not performing the appropriate emergency procedures. A factor associated with the accident was an electrical system failure.Feb 2, 1992 · N427KP · Substantial damageNTSB MIA92LA076Accident · Minor injuriesLimited investigationFinal reportAero Mercantil Gavilan 358 EL-1 · Columbus, MSFatigue failure of the crankshaft due to improper engine assembly by the manufacturer.Feb 1, 1992 · N3500Z · Substantial damageNTSB FTW92FA064Accident · 2 fatalField investigationFinal reportCessna 182 · Bartlesville, OKThe pilot's failure to maintain terrain clearance. A factor was the dark night.Feb 1, 1992 · N6444A · DestroyedNTSB ATL92FA042Accident · No injuriesField investigationFinal reportCessna T210L · Georgetown, SCThe failure of overhaul personnel to properly torque the engine case rear thru bolts.Feb 1, 1992 · N732HG · Substantial damageNTSB MIA92LA073Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Alpha · Juno Beach, FLImproper collective and cyclic control inputs and poor in-flight planning decision by the pilot-in-command.Jan 31, 1992 · N85570 · Substantial damageNTSB FTW92LA063Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Canyon Lake, TXThe pilot's failure to properly monitor his fuel consumption and his failure to divert to an alternate airport prior to running out of gas.Jan 31, 1992 · HK369 · Substantial damageNTSB SEA92FA105Accident · 1 fatalField investigationFinal reportCessna 182R · Garrison, MTPoor inflight planning/decision. Factors to the accident were: icing conditions, dark night, flight into known adverse weather and an inadequate weather evaluation.Jan 30, 1992 · N8267E · DestroyedNTSB SEA92FA041Accident · 2 fatalField investigationFinal reportPiper PA-23-180 · Gold Bar, WAThe pilot becoming inadvertently lost/disoriented. The environmental conditions were factors in the accident.Jan 30, 1992 · CFDFV · DestroyedNTSB MIA92FA072Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Malabar, FLA divergence of the main rotor from its normal plane of rotation for an undetermined reason which resulted in mast bumping and a main rotor blade contact with the cockpit area.Jan 30, 1992 · N2313G · DestroyedNTSB BFO92LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · West Hempstead, NYLoss of engine power for an unknown reason. The lack of suitable terrain for an emergency landing was a related factor.Jan 30, 1992 · N7673U · Substantial damageNTSB MIA92FA070Accident · 3 fatalField investigationFinal reportCessna 337 · Moore Haven, FLThe pilot-in-command's in flight loss of control due to spatial disorientation. Contributing to the accident was the pilot-in-command's lack of total experience in night flight, and the lack of natural horizon or surface reference while flying over a sparsely…Jan 29, 1992 · N2211X · DestroyedNTSB CHI92IA079Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355F1 · Lansing, MIA fatigue failure of a fuel system line fitting during cruise flight.Jan 26, 1992 · N101UM · Minor damageNTSB FTW92LA060Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe pilot in command failed to properly monitor the fuel consumption rate of the airplane when he perceived that it might be higher than normal. The engine failure was a result of fuel exhaustion, aggravated by possible fuel siphoning from the tanks.Jan 25, 1992 · N88ES · Substantial damageNTSB MIA92FA067Accident · 2 fatalField investigationFinal reportCessna 402-C · Clewiston, FLPilot-in-command's improper inflight decision to attempt to descend and remain in VFR conditions in an area of thunderstorms and heavy rain. Contributing to the accident was the pilot-in-command's loss of control in flight.Jan 24, 1992 · N2714A · DestroyedNTSB MIA92IA065Incident · No injuriesIncident investigationFinal reportBoeing 757-23APF · Miami, FLThe pilot-in-command's improper supervision of the co-pilot/first officer. This resulted in a total loss of engine power on both engines while at low power settings in known icing conditions for failure to follow checklist procedures.Jan 23, 1992 · N572CA · No damageNTSB BFO92LA024Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbus, OHFuel starvation in both engines, due to the pilot's improper positioning of the engine or fuel controls.Jan 23, 1992 · N8434H · Substantial damageNTSB CHI92LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe pilot's delayed application of carburetor heat.Jan 20, 1992 · N152BA · Substantial damageNTSB SEA92IA040Incident · Minor injuriesIncident investigationFinal reportPiper PA-28R-200 · Anacortes, WAA bird impacting the aircraft.Jan 19, 1992 · N2742R · Minor damageNTSB LAX92LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Pinyon, CAThe flight instructor's inadequate in-flight planning to enter a mountainous area at a low altitude, and his improper handling of the airplane. Factors which contributed to the accident related to the instructor's lowering of the wing flaps during a time when…Jan 19, 1992 · N50810 · Substantial damageNTSB CHI92LA074Accident · No injuriesLimited investigationFinal reportCessna 175 · Warren, MIA loss of engine power as a result of a connecting rod failure. Factors related to the accident were the power lines and trees in the path of the selected emergency landing site.Jan 19, 1992 · N8293T · Substantial damageNTSB DEN92FA028Accident · No injuriesField investigationFinal reportBeech 35 · Nucla, COImproper static balance of the ruddervators following rebuilding/repainting, which resulted in empennage flutter.Jan 18, 1992 · N3342V · Substantial damageNTSB BFO92FA022Accident · 1 fatalField investigationFinal reportHughes 369D · Edison, NJThe blockage of the fuel nozzle which resulted in partial loss of engine power. Contributing was the pilot's failure to maintain rotor RPM.Jan 15, 1992 · N8674F · DestroyedNTSB SEA92LA039Accident · 1 fatalLimited investigationFinal reportErcoupe 415-C · Hansville, WAThe inadequate preflight preparation and improper inflight decision by the student pilot who was not qualified to conduct the flight. A factor relating to the accident was the adverse weather conditions.Jan 14, 1992 · N86964 · DestroyedNTSB LAX92LA093Accident · 5 fatalLimited investigationFinal reportCessna 310Q · Honolulu, HIThe pilot's continuation of VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. Factors which contributed to the accident were: the adverse weather conditions and the pilot's failure to obtain…Jan 14, 1992 · N787AM · DestroyedNTSB FTW92LA056Accident · No injuriesLimited investigationFinal reportCessna 205A · Spring, TXThe partial power loss due to cylinder fatigue and resultant engine vibrations. Factors were the oil covered windshield restricting the pilot's vision and the wet terrain.Jan 14, 1992 · N8352Z · Substantial damageNTSB SEA92LA037Accident · No injuriesLimited investigationFinal reportCessna 150L · Tacoma, WAThe pilot's improper use of remedial action when he encountered carburetor icing. Factors include carburetor ice and carburetor icing conditions.Jan 13, 1992 · N11632 · Substantial damageNTSB MIA92LA061Accident · 1 fatalLimited investigationFinal reportCessna 172G · Atlantic Ocean (Atlantic Ocean)Loss of engine power due to undetermined reasons.Jan 13, 1992 · N121L · Substantial damageNTSB MIA92FA062Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Homestead, FLThe non-instrument rated pilot's continued VFR flight into instrument flight conditions resulting in spatial disorientation and inflight loss of control.Jan 13, 1992 · N2606Y · DestroyedNTSB LAX92FA092Accident · 2 fatalField investigationFinal reportCessna T210L · Temple Bar, AZFatigue failure of the turbocharger's turbine shaft due to inadequate maintenance, and the pilot's improper in-flight planning/decision after experiencing a turbocharger failure. A factor related to the accident was: the lack of information in the pilot…Jan 13, 1992 · N22592 · DestroyedNTSB CHI92LA071Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Grand Rapids, MNThe pilot's lack of familiarity with aircraft systems which resulted in his failure to extend the landing gear by the alternate system. A factor was the loss of engine power.Jan 13, 1992 · N255W · Substantial damageNTSB ATL92FA039Accident · 5 fatalField investigationFinal reportCessna 421C · Atlantic Ocean (Atlantic Ocean)The pilot's inadequate weather evaluation, and his continued flight into known adverse weather conditions. Factors were: the improper weather briefing by a flight service station specialist, and level iii thunderstorms.Jan 13, 1992 · N40JK · DestroyedNTSB LAX92LA089Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe failure of the carburetor heat box attach straps which allowed the carburetor heat box to separate from the exhaust system heat muff and rendered the carburetor heat system inoperative. The engine then lost power due to carburetor ice.Jan 12, 1992 · N1571E · Substantial damageNTSB LAX92FA090Accident · 7 fatalField investigationFinal reportCessna 425 · Las Vegas, NVThe pilot's failure to maintain aircraft control due to spatial disorientation. Factors in this accident were: 1) the pilot's failure to obtain a preflight weather briefing and to properly evaluate the existing weather conditions prior to flight, and 2)…Jan 12, 1992 · N425BN · DestroyedNTSB ATL92LA038Accident · No injuriesLimited investigationFinal reportBeech J-35 · Knoxville, TNThe manufacturer's failure to provide adequate torque information which resulted in the loss of torque on the cylinder hold down nuts and the complete loss of engine power.Jan 12, 1992 · N185Y · Substantial damageNTSB MIA92FA058Accident · 1 fatalField investigationFinal reportCessna 402B · Lantana, FLThe pilot in commands failure to maintain airspeed above single engine minimum control speed resulting in an inflight loss of control and collision with terrain. Contributing to the accident was the pilot in command's failure to declare an emergency and…Jan 11, 1992 · N3767C · DestroyedNTSB LAX92FA088Accident · 5 fatalField investigationFinal reportBell 206BIII · Crockett, CAThe pilot's failure to maintain vigilant watch for obstructions while intentionally cruising slowly at a low altitude. A factor was the power line was supported by distant towers, and the line was not conspicuous.Jan 11, 1992 · N95AT · DestroyedNTSB ATL92LA035Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Millen, GAThe pilot's failure to properly use carburetor heat during icing conditions which resulted in the formation of carburetor ice and subsequent loss of engine power.Jan 11, 1992 · N5866R · Substantial damageNTSB SEA92LA058Accident · No injuriesLimited investigationFinal reportCessna 207 · Seattle, WAThe cargo door unlatched for undetermined reasons.Jan 9, 1992 · N91056 · Substantial damageNTSB MIA92LA057Accident · 1 fatalLimited investigationFinal reportWalter R. Penney VARI-EZE · Lamar, MSThe pilot in commands departure into and continued flight in instrument meteorological conditions while operating under visual flight rules resulting in an inflight collision with trees and then the ground.Jan 8, 1992 · N12WP · DestroyedNTSB LAX92LA084Accident · No injuriesLimited investigationFinal reportCessna 172H · Arcata, CACarburetor icing and the failure of the pilot to use carburetor heat.Jan 8, 1992 · N1608F · Substantial damageNTSB CHI92IA068Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Fort Wayne, INFailure of company maintenance personnel to maintain the airplane in accordance with existing service bulletins.Jan 8, 1992 · N852AW · No damageNTSB MIA92LA056Accident · Minor injuriesLimited investigationFinal reportAero Commander 560E · Boca Raton, FLImproper fuel tank selector position of both engines resulting in total loss of engine power due to fuel starvation. Also, failure of the pilot to perform the emergency procedures following the loss of power from both engines.Jan 6, 1992 · N8434C · Substantial damageNTSB LAX92LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Altadena, CAThe pilot's improper use of the fuel selector by selecting an empty tank. Contributing to the accident was the pilot's decision to operate the airplane with a known deficiency without having maintenance performed to determine the cause of a previous loss of…Jan 6, 1992 · N2638R · Substantial damageNTSB LAX92FA082Accident · 4 fatalField investigationFinal reportCessna 421C · Mammoth Lakes, CAThe failure of the pilot to plan and conduct his departure flight to avoid high mountainous terrain, during which the pilot became lost/disoriented. Contributing to the accident was self induced pressure to depart before the arrival of a snow storm.Jan 5, 1992 · N2654M · DestroyedNTSB DEN92LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Falcon, COEngine failure over unsuitable terrain due to fuel exhaustion. Factors were: pilot inexperience and becoming lost and disoriented.Jan 4, 1992 · N774WS · Substantial damageNTSB DEN92FA024Accident · 3 fatalField investigationFinal reportCessna 421B · Steamboat Spgs, COAirframe ice and the pilot's failure to remove it. Factors were: aircraft weight exceeded and lack of pilot certification.Jan 4, 1992 · N1974G · DestroyedNTSB DEN92IA025Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Denver, COAn electrical short circuit in a main wire bundle due to chafing of the bundle on airframe structural members.Jan 3, 1992 · N343UA · Minor damageNTSB LAX92LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lodi, CAThe pilot's improper use of the carburetor heat control and delay in flaring the helicopter for an autorotative touchdown. Carburetor icing conditions and the soft terrain were contributing factors in the accident.Jan 1, 1992 · N889KT · Substantial damageNTSB ATL92FA032Accident · Serious injuriesField investigationFinal reportPiper PA 28-140 · Blythe, GAThe pilot's failure to apply carburetor heat during the before takeoff check as part of the ground check. A factor was weather conditions favorable for the formation of carburetor ice.Dec 30, 1991 · N1733T · Substantial damage