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 DEN92FA076Accident · 4 fatalField investigationFinal reportAero Commander 560-F · Manville, WYA loss of control following flight into weather conditions containing thunderstorms, turbulence and icing conditions. Factors were: inaccurate weather evaluation and flight into known adverse weather by the pilot in command.Jul 23, 1992 · N560CM · DestroyedNTSB BFO92FA109Accident · 2 fatalField investigationFinal reportBeech 58 · Denver, PAThe pilot's loss of aircraft control due to spatial disorientation. The weather conditions were factors that contributed to the accident.Jul 23, 1992 · N66829 · DestroyedNTSB CHI92DEM04Accident · Serious injuriesFinal reportHauser, William C. Cassutt · Winn, MIThe ditch the airplane encountered during the landing roll phase of a forced landing.Jul 22, 1992 · N881 · Substantial damageNTSB BFO92LA112Accident · No injuriesLimited investigationFinal reportJames Snyder Challenger II · Burlington, CTThe loss of engine power for undetermined reasons.Jul 22, 1992 · N602CH · Substantial damageNTSB BFO92LA110Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Belmont, NHInadequate in-flight planning/decision by the pilot.Jul 22, 1992 · N93361 · Substantial damageNTSB ANC92LA109Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Mcgrath, AKThe fire in the engine accessory drive assembly. Factor was the rough an uneven forced landing area.Jul 22, 1992 · N41755 · Substantial damageNTSB ANC92LA108Accident · No injuriesLimited investigationFinal reportCessna 207 · Dillingham, AKThe pilot in command's failure to maintain visual lookout and clearance from terrain. A factor was the pilot diverted his attention to secure a loose fire extinguisher.Jul 20, 1992 · N9975M · Substantial damageNTSB LAX92LA308Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tucson, AZThe pilot's poorly planned approach and failure to attain the proper descent rate. The loss of engine power for undetermined reasons and the rough terrain conditions in the area of the forced landing were factors in the accident.Jul 19, 1992 · N3406Z · Substantial damageNTSB ATL92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Shallotte, NCThe deterioration of the left main fuel bladder which resulted in the premature exhaustion of the fuel supply and the loss of engine power. A factor was soft terrain.Jul 17, 1992 · N160MJ · Substantial damageNTSB LAX92LA299Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Shafter, CAThe pic's poor preflight planning and the pic's and flight instructor/passenger's failure to use the emergency checklist. The loss of engine power due to fuel starvation was a factor in the accident.Jul 16, 1992 · N327PL · Substantial damageNTSB LAX92LA298Accident · No injuriesLimited investigationFinal reportCessna 150L · Pittsburg, CAThe pilot's poor preflight planning/preparation and fuel consumption calculations. The rough/uneven terrain is a factor in this accident.Jul 16, 1992 · N7521G · Substantial damageNTSB ATL92FA139Accident · 2 fatalField investigationFinal reportBeech 58P · Greenville, GAContinued flight by the pilot into an area of known adverse weather, and his failure to maintain control of the aircraft, which resulted in exceeding the design stress limits of the plane and overload failure of the stabilizers and wings. The adverse weather…Jul 15, 1992 · N3810L · DestroyedNTSB LAX92LA322Accident · No injuriesLimited investigationFinal reportBeech A23A · Chico, CA1) The pilot's inadvertent entry into instrument meteorological conditions, 2) his failure to maintain control of the aircraft due to spatial disorientation, 3) the inadvertent entry into a spiral dive at an excessive airspeed, and, 4) the pilot's improper…Jul 12, 1992 · N7904L · Substantial damageNTSB BFO92LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beavertown, PAThe pilot's failure to maintain ground clearance. Contributing to the accident was a downdraft and insufficient altitude.Jul 12, 1992 · N4754Z · DestroyedNTSB SEA92LA149Accident · No injuriesLimited investigationFinal reportCessna 172L · Delta, UTThe failure of an intake valve and the poorly executed forced landing.Jul 11, 1992 · N9871G · Substantial damageNTSB SEA92FA148Accident · 1 fatalField investigationFinal reportCessna 150 · Burns, ORThe failure of the pilot to maintain clearance from wires on a 500 kv electrical power transmission line.Jul 11, 1992 · N5988E · DestroyedNTSB LAX92FA294Accident · 1 fatalField investigationFinal reportBell 206B · Twin Peaks, CAWas the pilot's decision to initiate the flight in known adverse weather and continued VFR flight into instrument meteorological conditions. Contributing to this accident was the low clouds and fog.Jul 11, 1992 · N59484 · DestroyedNTSB CHI92LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Ortonville, MIImproper use of the fuel tank selector switch and inadequate emergency procedures by the pilot in command.Jul 11, 1992 · N6617V · Substantial damageNTSB LAX92LA290Accident · Serious injuriesLimited investigationFinal reportWhigham GW-4 · Warner Springs, CAThe pilot's inadequate preflight planning and preparation. Contributing to this accident was the downdrafts and mountainous terrain.Jul 9, 1992 · N3705 · Substantial damageNTSB LAX92FA289Accident · 1 fatalField investigationFinal reportCessna T210N · Superior, AZAn inadequate major engine overhaul procedure, during which previous crankshaft damage was not detected. Contributing to the accident was a surface initiated fatigue failure of the engine crankshaft.Jul 9, 1992 · N6483C · DestroyedNTSB BFO92LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Clay City, KYFuel starvation for an undetermined reason. Darkness and trees in the emergency landing area were related factors.Jul 9, 1992 · N2857D · DestroyedNTSB BFO92FA094Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-40 · Concord, NHLoss of control during flight for undetermined reason(s).Jul 9, 1992 · N220MA · DestroyedNTSB BFO92FA093Accident · 1 fatalField investigationFinal reportCessna U206F · Portland, MEImproper in-flight planning/decision by the pilot, resulting in fuel starvation due to improper positioning of the fuel selector. Factors related to the accident were: an undetermined electrical failure, and loss of fuel quantity indication.Jul 9, 1992 · CGTCM · Substantial damageNTSB FTW92DPG07Accident · No injuriesFinal reportAyres S2R · Grady, ARThe loss of engine power due to the separation of the number one engine cylinder. A factor was the unsuitable terrain.Jul 8, 1992 · N4979X · Substantial damageNTSB MIA92LA147Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180 · Okeechobee, FLThe failure of the pilot-in-command of N148DP to obtain NOTAM information concerning military routes along his route of flight, resulting in his encounter with a flight of F16 aircraft who were operating on a military route.Jul 7, 1992 · N148DP · Substantial damageNTSB FTW92DPG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power. A factor was the unsuitable terrain.Jul 7, 1992 · N3650N · Substantial damageNTSB BFO92LA090Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodstock, CTThe loss of engine power due to a cracked cylinder and the inadvertent aerodynamic stall that occurred during the precuationary landing.Jul 7, 1992 · N68215 · Substantial damageNTSB BFO92FA088Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Bowling Green, KYThe loss of control in flight due to spatial disorientation/vertigo.Jul 6, 1992 · N188AL · DestroyedNTSB SEA92LA143Accident · Minor injuriesLimited investigationFinal reportBorgaes Avid Flyer "C" · Chiloquin, ORPower loss for undetermined reasons and nose gear separation due to overload. A factor contributing to the accident was: terrain condition - dirt bank.Jul 4, 1992 · N1572T · Substantial damageNTSB CHI92DCD08Accident · Minor injuriesFinal reportJohn Schackel Q2 · Rutland, IAA fatigue failure of the engine crankshaft during cruise flight.Jul 4, 1992 · N84JS · Substantial damageNTSB FTW92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Port Isabel, TXThe loss of power to the right engine due to a fractured crankshaft while the left engine was secured. Factors were the dual students failure to use carburetor heat while performing maneuvers and the unsuitable terrain.Jul 3, 1992 · N46RJ · Substantial damageNTSB CHI92LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Belmont, WIThe pilot's poor planning/decision making. Related factors are the low ceilings and fog, the dark night, the pilot's inaccurate weather evaluation and diverted attention, and the pilot's failure to maintain clearance from the higher terrain encountered.Jul 3, 1992 · N9735J · DestroyedNTSB CHI92LA206Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Janesville, WIThe captain's delay in issuing instructions to the flight attendants to take their seats, and his poor crew coordination. A factor in the accident was the turbulence in clouds.Jul 2, 1992 · N7467U · No damageNTSB SEA92LA142Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Paul, IDLoss of engine power for undetermined reasons and aircraft control not possible by the pilot in command. A factor contributing to the accident was: rough/uneven terrain.Jul 1, 1992 · N5386 · DestroyedNTSB LAX92LA274Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Tulare, CAAn inflight hopper compartment fire due to the incompatibility of the chemical loads, and, the failure of the operator follow the cautionary directives of the chemical manufacturer.Jul 1, 1992 · N8636H · DestroyedNTSB LAX92LA273Accident · No injuriesLimited investigationFinal reportCessna U206E · Mayer, AZThe failure of the engine due to the slippage of the number 2 main bearing and the resultant oil starvation failure of the number 2 connecting rod. The number 2 main bearing slippage was caused by the failure of the pilot/owner to overhaul the engine in a…Jul 1, 1992 · N9455G · Substantial damageNTSB CHI92DCQ05Accident · Serious injuriesFinal reportVirgil Larson Varieze,LONG EZ · Chanute, KSA delamination and inflight separation of a propeller blade during cruise flight.Jul 1, 1992 · N18VL · Substantial damageNTSB BFO92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Greenville, VAThe fatigue failure of the fuel injector fuel line resulting in engine failure. Contributing to the accident was the unsuitable terrain in which the forced landing was made.Jul 1, 1992 · N8141H · Substantial damageNTSB LAX92LA272Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Santa Clarita, CAFuel starvation caused by the inflight separation of the fuel gascolator bowl due to improper component installation.Jun 30, 1992 · N3165H · Substantial damageNTSB FTW92LA174Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Paris, TXFuel exhaustion power loss. Factors were a loose fuel cap, inadequate preflight by the pilot and the lack of suitable terrain.Jun 30, 1992 · N8942R · Substantial damageNTSB SEA92FA140Accident · 1 fatalField investigationFinal reportBeech A36TC · Ballantine, MTThe pilot-in-command's physical impairment and his continued VFR flight into instrument meteorological conditions. Factors relating to the accident were: the weather conditions and the hilly terrain.Jun 29, 1992 · N3696R · DestroyedNTSB NYC92LA134Accident · No injuriesLimited investigationFinal reportCessna 150L · Bethel Park, PAThe failure of the pilot to determine the fuel quantity prior to departure, which resulted in a power loss due to fuel exhaustion, over unsuitable terrain. Factors related to the accident were an improperly reading right fuel gauge, and an improperly adjusted…Jun 29, 1992 · N6849G · Substantial damageNTSB LAX92LA270Accident · No injuriesLimited investigationFinal reportBeech A36 · Brawley, CAFuel starvation due to the pilot's; 1) failure to refuel the aircraft, 2) improper use of the fuel system, and 3) his delayed positioning of the fuel selector valve to a tank containing fuel. A factor in the accident was the pilot's failure to adhere to the…Jun 29, 1992 · N1794W · Substantial damageNTSB LAX92FA267Accident · 2 fatalField investigationFinal reportRobinson R22 · Richmond, CAA divergence of the main rotor from its normal plane of rotation for an undetermined reason(s) which resulted in rotor contact to the tailboom.Jun 29, 1992 · N83858 · DestroyedNTSB ATL92LA133Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuscaloosa, ALThe improper installation of the emergency exit, by an unknown person, which resulted in its separation, in flight.Jun 29, 1992 · N910WT · Substantial damageNTSB MIA92LA143Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · St. ThomasIn-flight fire for undetermined reasons, and in-flight collision with the water.Jun 28, 1992 · N59LD · DestroyedNTSB DEN92IA067Incident · No injuriesIncident investigationFinal reportBell 222UT · Scipio, UTAn encounter with clear air turbulence.Jun 28, 1992 · N222UH · Minor damageNTSB SEA92LA137Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mckinnon, WYWater in the aircraft fuel system which was not purged as a result of the pilot in command's inadequate preflight. Factors contributing to the accident were: trees, a fence and the uneven terrain condition during the landing and rollout.Jun 26, 1992 · N6089A · DestroyedNTSB SEA92LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Rock Springs, WYThe disconnection of the throttle cable and collapse of the nose landing gear. Factors contributing to the accident were: improper maintenance installation by the mechanic whose attention was diverted and the rouh/uneven terrain.Jun 26, 1992 · N2724Q · DestroyedNTSB MIA92FA142Accident · 1 fatalField investigationFinal reportHughes 369HS · Labelle, FLThe pilot-in-command's improper application of collective pitch during an autorotative landing resulting in insufficient rotor RPM and in-flight collision with trees and the terrain. Contributing to the accident was the total loss of engine power due to fuel…Jun 26, 1992 · N9089F · Destroyed