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 LAX03FA008Accident · 1 fatalField investigationFinal reportCessna 150F · Julian, CAan in-flight loss of control for undetermined reasons.Oct 14, 2002 · N8735G · DestroyedNTSB DEN03LA006Accident · No injuriesLimited investigationFinal reportMooney M20B · Loa, UTthe pilot's inadvertent placement of the fuel selector position in the off position. A contributing factor was the pilot's lack of familiarity with the aircraft.Oct 14, 2002 · N74530 · Substantial damageNTSB IAD03LA006Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · South Vienna, OHThe improper installation of the single drive, dual magneto, which resulted in its separation from the engine and a subsequent total loss of engine power. Factors included the crops in the forced landing field, and the night lighting conditions.Oct 13, 2002 · N7510V · Substantial damageNTSB SEA03LA002Accident · Serious injuriesLimited investigationFinal reportGentry Vari-Eze · Shine, WALoss of engine power for undetermined reasons during cruise. Trees and objects near the roadway were factors.Oct 12, 2002 · N24BG · Substantial damageNTSB LAX03FA005Accident · 1 fatalField investigationFinal reportGrumman AA-5A · Phoenix, AZfailure of the lubricating system resulting in a total loss of engine power and an off airport forced landing.Oct 12, 2002 · N9566U · DestroyedNTSB IAD03FA004Accident · 1 fatalField investigationFinal reportCessna 182S · Brownville Jct, METhe pilot's failure to maintain sufficient altitude while flying in mountainous terrain at night. A factor was the night lighting conditions.Oct 12, 2002 · N100TY · DestroyedNTSB FTW03LA011Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Vinson, OKThe pilot's inadvertent flight into adverse weather conditions during cruise resulting in his failure to maintain control of the helicopter, and his failure to maintain rotor rpm. Contributing factors relating to the accident included the frontal activity…Oct 12, 2002 · N9008H · Substantial damageNTSB ANC03IA001Incident · No injuriesIncident investigationFinal reportBoeing 747-400 · Anchorage, AKThe fatigue fracture of the lower rudder power control module manifold, which resulted in a lower rudder hardover.Oct 10, 2002 · N661US · No damageNTSB ATL03FA002Accident · 1 fatalField investigationFinal reportBeech K35 · Jellico, TNThe pilot's incapacitation in flight due to a heart attack resulting in an in-flight loss of control, and collision with terrain. A factor was the pilot acting as a pilot-in-command with a known medical grounding condition.Oct 9, 2002 · N5350E · DestroyedNTSB CHI03LA006Accident · No injuriesLimited investigationFinal reportWolf Rotorway Exec-162F · Gregory, MIFailure of the secondary drive shaft, which resulted in a complete loss of power to the main rotor, and a high forward airspeed on touchdown, causing the helicopter to flip forward.Oct 7, 2002 · N1955Z · Substantial damageNTSB FTW03LA005Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Lewisville, TXThe improper reinstallation of the left aileron by maintenance personnel. A contributing factor was the non-suitable terrain for the forced landing.Oct 3, 2002 · N1223S · Substantial damageNTSB CHI03FA003Accident · 1 fatalField investigationFinal reportPiper PA-18A · Garden City, KSThe inadequate preflight planning/preparation and visual flight rules flight into instrument meteorological conditions by the pilot. The clouds, mist, and night conditions were contributing factors.Oct 2, 2002 · N3279Z · DestroyedNTSB SEA02LA187Accident · No injuriesLimited investigationFinal reportMooney M20J · Oakley, IDFailure (fracture) of the two number four piston compression rings, leading to the erosion of a section of the piston sidewall, resulting in the exhaustion of the engine's oil supply during cruise flight, followed by a forced landing on a country road.…Sep 30, 2002 · N4232H · Substantial damageNTSB SEA02FA185Accident · 2 fatalField investigationFinal reportCessna 172S · Medford, ORTerrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.Sep 30, 2002 · N514SP · Substantial damageNTSB ANC02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ekwok, AKA partial separation of one propeller blade during cruise flight.Sep 30, 2002 · N723C · Substantial damageNTSB SEA02LA184Accident · No injuriesLimited investigationFinal reportCessna 182 · Estacada, ORThe entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.Sep 29, 2002 · N5337B · DestroyedNTSB LAX02LA298Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lucerne Valley, CAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.Sep 28, 2002 · N6412A · Substantial damageNTSB CHI02LA297Accident · No injuriesLimited investigationFinal reportJonas Nieuport · Creve Coeur, MOThe installation of improper carburetor jets resulting in an improper fuel mixture and loss of engine power.Sep 28, 2002 · N678DJ · Substantial damageNTSB LAX02LA296Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Valley Center, CAthe pilot's inadequate preflight planning/preparation by not verifying the fuel supply, and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the pilot's decision to initiate…Sep 25, 2002 · N60LW · Substantial damageNTSB LAX02LA295Accident · No injuriesLimited investigationFinal reportBell 206L-1 · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.Sep 25, 2002 · N601GM · Substantial damageNTSB NYC02LA195Accident · 1 fatalLimited investigationFinal reportPaiement Rans S-12 · Mercer, METhe pilot's improper in-flight decision, and failure to maintain adequate clearance, which resulted in a collision with a wire during a low altitude flight.Sep 24, 2002 · N7011Y · Substantial damageNTSB MIA02FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Yeehaw Junction, FLthe pilot's continued flight into known severe weather, resulting in an in-flight separation of the right wing, vertical stabilizer and the stabilator. Factors in this accident were heavy thunderstorm, and failure of the FAA controllers to provide the pilot…Sep 24, 2002 · N106JG · DestroyedNTSB FTW02FA262Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Chromo, COThe flight instructor's failure to maintain clearance with the mountainous terrain during the cross-country flight. A contributing factor was the dark night light conditions.Sep 24, 2002 · N6227J · DestroyedNTSB ATL02LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring City, TNThe flight instructor's failure to follow standard training procedures that resulted in the loss of engine power during a simulated loss of engine power.Sep 24, 2002 · N46656 · Substantial damageNTSB LAX02LA292Accident · No injuriesLimited investigationFinal reportCessna 172RG · Del Mar, CAThe loss of engine power due to failure of the number three connecting rod cap. Also causal was the failure of the pilot of a previous flight to report an engine overspeed event precluding the performance of the appropriate maintenance inspection.Sep 21, 2002 · N6303V · Substantial damageNTSB LAX02LA291Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-42-2 Jantar · Hemet, CAthe pilot's failure to maintain an adequate terrain clearance altitude.Sep 21, 2002 · N131AS · Substantial damageNTSB LAX02LA290Accident · No injuriesLimited investigationFinal reportCessna 172G · Vail, AZThe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.Sep 18, 2002 · N2982U · Substantial damageNTSB IAD02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Edinburg, VAA loss of engine power for undetermined reasons.Sep 18, 2002 · N5033H · Substantial damageNTSB ATL02LA170Accident · 1 fatalLimited investigationFinal reportMikoyan Gurevich Mig-15 · Whiteville, NCThe pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation which resulted in a loss of control and the subsequent collision with the ground .Sep 18, 2002 · N151MG · DestroyedNTSB CHI02LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369D · O'Neill, NEA loss of engine power due to turbine blade separation as a result of hot corrosion damage to the turbine blades. Contributing to the accident was the pilot misjudging the flare at the completion of the autorotation resulting in a hard landing. The dark night…Sep 17, 2002 · N500EK · Substantial damageNTSB CHI02LA286Accident · Serious injuriesLimited investigationFinal reportBailey DSA-1 · Washington, IAThe selection of unsuitable terrain and the failure of the oil pressure gage line. Factors were, the pilot/owners failure to obtain an annual condition inspection, and the corn crop.Sep 16, 2002 · N304MB · Substantial damageNTSB CHI02FA284Accident · 2 fatalField investigationFinal reportPilatus PC-12/45 · Westphalia, MOThe pilot's spatial disorientation while turning in a cruise climb in instrument meteorological conditions, which resulted in the pilot's loss of aircraft control, and his failure to recover from a resultant tight descending spiral.Sep 14, 2002 · N451ES · DestroyedNTSB NYC02LA193Accident · Serious injuriesLimited investigationFinal reportI.C.A. Brasov IS-28-B2 · Blairstown, NJThe second pilot's improper in-flight decision to perform a release from the towplane, which did not allow for successful completion of the flight. A factor was the downdrafts.Sep 12, 2002 · N8216Q · Substantial damageNTSB LAX02FA281Accident · Minor injuriesField investigationFinal reportAerospatiale AS350BA · Peach Springs, AZthe pilot's failure to maintain an adequate airspeed and main rotor rpm during the landing approach as prescribed in the hydraulic pump failure emergency procedures found in the rotorcraft flight manual, thus resulting in a loss of control of the aircraft and…Sep 12, 2002 · N357NT · Substantial damageNTSB ATL02LA169Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Morton, MSContamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.Sep 11, 2002 · N5724P · Substantial damageNTSB CHI02FA288Accident · 4 fatalField investigationFinal reportBell 206L-1 · Doland, SDPilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…Sep 10, 2002 · N400SL · DestroyedNTSB LAX02FA278Accident · 1 fatalField investigationFinal reportBeech A36 · Grand Canyon, AZthe pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…Sep 8, 2002 · N8261J · DestroyedNTSB IAD02FA091Accident · 2 fatalField investigationFinal reportPiper PA 32R-301T · Byram Township, NJthe improper manufacturing of the crankshaft gear bolt, which resulted in the failure of the bolt due to hydrogen embrittlement, and the subsequent loss of engine power. Also causal was the engine manufacturer's failure to remove the affected bolts from fixed…Sep 8, 2002 · C-GKLY · DestroyedNTSB NYC02LA185Accident · Serious injuriesLimited investigationFinal reportReiley Seawind 3000 · Bloomingburg, OHThe pilot's inadvertent use of the fuel shutoff valve which resulted in a subsequent total loss of engine power due to fuel starvation.Sep 7, 2002 · N278ER · Substantial damageNTSB NYC02LA184Accident · 1 fatalLimited investigationFinal reportGraham Mini-500 · Renfrew, PAFailure of the main transmission.Sep 7, 2002 · N373TG · Substantial damageNTSB NYC02LA182Accident · Minor injuriesLimited investigationFinal reportDuffy Vans RV-9A · Oxford, OHThe pilot's improper fuel calculations, which resulted in fuel exhaustion and a subsequent total loss of engine power. Factors included an inaccurate fuel gauge indication for undetermined reasons, the pilot's reliance on that indication, the night lighting…Sep 6, 2002 · N945D · Substantial damageNTSB LAX02LA275Accident · No injuriesLimited investigationFinal reportHuene Velocity XL-RG · Fresno, CAAn in-flight exhaust stack separation during descent for landing resulting in loss of engine power and a forced landing to an open field.Sep 6, 2002 · N394BL · DestroyedNTSB FTW02LA250Accident · No injuriesLimited investigationFinal reportGray Rotorway Exec 90 · Las Cruces, NMThe pilot's failure to refuel the helicopter, which resulted in fuel exhaustion.Sep 5, 2002 · N716JB · Substantial damageNTSB MIA02LA166Accident · No injuriesLimited investigationFinal reportBeech C24R · Olar, SCThe pilot's failure to execute the proper remedial action for hydraulic leak fumes in the cockpit, and his decision to perform an immediate precautionary landing to a vacant field, resulting in collision with a tree. A factor in the accident was the…Sep 4, 2002 · N6698D · Substantial damageNTSB CHI02IA275Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Detroit, MIA malfunctioning yaw damper.Sep 4, 2002 · N110XJ · No damageNTSB NYC02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Belmar, NJThe improper use of an fuel additive which resulted in a power loss. A factor was the lack of suitable terrain.Sep 3, 2002 · N5428H · Substantial damageNTSB FTW02LA247Accident · No injuriesLimited investigationFinal reportEurocopter AS350B3 · Eagle Pass, TXThe insufficient length of the stepper motor rack inside the HMU, which caused the red "GOV" light to illuminate and the fuel metering valve to freeze causing the engine to automatically engage the manual mode.Sep 2, 2002 · N747R · Substantial damageNTSB ANC02LA110Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Port Alsworth, AKThe pilot's inadequate evaluation of the area weather conditions, and his subsequent inability to maintain terrain clearance upon encountering a downdraft, which resulted in an in-flight collision with tree-covered mountainous terrain. A factor in the…Sep 1, 2002 · N185CF · Substantial damageNTSB SEA02LA168Accident · Serious injuriesLimited investigationFinal reportNolley BD-5 · Corvallis, ORFuel starvation resulting in a loss of engine power during the aircraft's initial climb. A disconnected fuel line was a factor.Aug 31, 2002 · N50TX · Substantial damageNTSB LAX02LA270Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Fresno, CAa loss of engine power for undetermined reasons.Aug 31, 2002 · N87204 · Substantial damage