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 MIA97IA151Incident · No injuriesIncident investigationFinal reportBeech 100 · Kenly, NCInadequate inspection procedures by the airframe manufacturer for failure to require removal of the metal retaining ring to inspect the entire area of the window for cracks.Apr 5, 1997 · N402G · Minor damageNTSB MIA97LA113Accident · No injuriesLimited investigationFinal reportChance Vought F4U · New Smyrna Bch, FLThe pilot's failure to assure that an adequate supply of fuel was on board for the intended flight.Apr 4, 1997 · N45NL · Substantial damageNTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.Apr 3, 1997 · N761VX · Substantial damageNTSB LAX97FA143Accident · 2 fatalField investigationFinal reportCessna T210N · Grand Canyon, AZThe pilot's failure to maintain aircraft control due to spatial disorientation and his lack of proficiency in conducting instrument flight. Contributing were the inoperative alternator, cockpit lighting, and vacuum system.Apr 3, 1997 · N6172C · DestroyedNTSB IAD97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsburgh, PAthe student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.Apr 2, 1997 · N3616J · Substantial damageNTSB CHI97LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Des Moines, IAoil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.Apr 2, 1997 · N9004W · Substantial damageNTSB IAD97FA060Accident · 1 fatalField investigationFinal reportCessna 337D · Hickory, PAServicing of the pilots portable oxygen system with compressed air, which resulted in pilot incapacitation due to Hypoxia.Apr 1, 1997 · N2685S · DestroyedNTSB ATL97LA053Accident · Minor injuriesLimited investigationFinal reportCatchot Hauler · Centerville, ALthe engine manufacturer's failure to install ballast resistors in the ignition system, which resulted in an electrical short in the dual ignition system and subsequent loss of engine power.Apr 1, 1997 · N301A · Substantial damageNTSB LAX97LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Continental, AZloss of engine power as a result of detonation in the number 2 cylinder for undetermined reasons. A factor in the accident was the unsuitable nature of the forced landing area.Mar 31, 1997 · N2226T · Substantial damageNTSB LAX97FA142Accident · 2 fatalField investigationFinal reportCessna P210N · Corona, CAThe pilot's failure to maintain adequate terrain clearance during a nighttime flight at low altitude through a mountainous area. Factors in the accident were the conditions of low clouds and dark light conditions.Mar 31, 1997 · N3894P · DestroyedNTSB NYC97LA066Accident · 2 fatalLimited investigationFinal reportLowe Super Koala · Perry Township, PAimproper construction by the builder which led to the failure of the strut and wing assembly.Mar 30, 1997 · N4424V · Substantial damageNTSB MIA97LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Atlantic Ocean (Atlantic Ocean)loss of engine power for undetermined reason(s). A factor relating to the accident was: the pilot's poor in-flight planning/decision by flying at too low of an altitude to glide to shore for a forced landing.Mar 30, 1997 · N576PR · Substantial damageNTSB MIA97LA106Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Cumming, GAa loss of engine power for an undermined reason, which resulted in a forced landing and subsequent impact with the ground.Mar 30, 1997 · N3201Z · Substantial damageNTSB LAX97LA134Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Oroville, CAa loss of engine power due to connecting rod bolt failure. The reason for the bolt failure was not determined. A contributing factor was the presence of trees in the emergency landing path.Mar 28, 1997 · N86851 · Substantial damageNTSB FTW97LA146Accident · No injuriesLimited investigationFinal reportBeech G33 · Bixby, OKfailure of a number two connecting rod bolt, possibly from being either over-torqued or under-torqued during installation, and failure of the pilot to see-and-avoid the transmission line, while performing a forced landing.Mar 28, 1997 · N166B · Substantial damageNTSB SEA97FA076Accident · 1 fatalField investigationFinal reportCessna 172P · Burlington, WYloss of engine power for undetermined reason(s). The lack of suitable terrain for a forced landing was a related factor.Mar 26, 1997 · N97527 · DestroyedNTSB FTW97LA141Accident · No injuriesLimited investigationFinal reportPiper PA-17 · N Little Rock, ARloss of engine power due to failure of the crankshaft. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Mar 26, 1997 · N4802H · Substantial damageNTSB ATL97LA055Accident · Serious injuriesLimited investigationFinal reportDassault Falcon 900B · Chamblee, GAan encounter with clear air turbulence, which led to injury of the flight attendant. A factor associated with the accident was: that the flight attendant was not being restrained by a seat belt.Mar 26, 1997 · N332MC · No damageNTSB ATL97FA054Accident · 3 fatalField investigationFinal reportBeech V35 · Marco Island, FLinadvertent flight by the pilot into adverse weather conditions (severe thunderstorms), which led the design stress limits of the airplane being exceeded, subsequent in-flight break-up of the airplane, and an uncontrolled collision with water.Mar 25, 1997 · N9049S · DestroyedNTSB ANC97FA037Accident · 2 fatalField investigationFinal reportShort Brothers SC7 · Nunapitchuk, AKinadequate visual look-out by the pilots of both airplanes, which resulted in their failure to see-and-avoid each other's airplanes.Mar 25, 1997 · N451SA · 2 aircraft · DestroyedNTSB SEA97FA075Accident · 4 fatalField investigationFinal reportCessna T210L · Dillon, MTflight by the pilot into adverse weather conditions, and his failure to maintaint altitude/clearance from terrain. The adverse weather condition was a related factor.Mar 23, 1997 · N22219 · DestroyedNTSB NYC97LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bowling Green, OHthe pilot's improper planning/decision, which resulted in airframe ice and the loss of adequate lift to maintain continued flight. The adverse weather (icing) condition was a related factor.Mar 23, 1997 · N6561P · Substantial damageNTSB LAX97LA131Accident · 1 fatalLimited investigationFinal reportZenair 601 · Penn Valley, CALoss of engine power for undetermined reasons. Factors in the accident were the pilot's lack of recent experience, lack of experience in the type aircraft, and physical impairment due to drugs.Mar 23, 1997 · N4073T · DestroyedNTSB MIA97LA126Accident · No injuriesLimited investigationFinal reportSocata TB-21C · Hollywood, FLcontinued flight by the pilot into adverse weather conditions, and the pilot allowing the aircraft to exceed its design stress limits. Weather associated with the thunderstorm was a related factor.Mar 21, 1997 · N55510 · Substantial damageNTSB LAX97LA129Accident · No injuriesLimited investigationFinal reportCessna 150L · Nogales, AZLoss of engine power due to fuel contamination resulting from the pilot's inadequate fuel storage and filtering procedures.Mar 21, 1997 · N21993 · Substantial damageNTSB FTW97LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Durango, COthe pilot's improper planning/decision, and failure to ensure there was sufficient fuel aboard for the flight, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a successful…Mar 21, 1997 · N613CW · Substantial damageNTSB ANC97LA046Accident · No injuriesLimited investigationFinal reportBeech G18S · Nome, AKfracture of a propeller blade tip.Mar 21, 1997 · N555CG · Substantial damageNTSB IAD97GA054Accident · No injuriesFinal reportSchweizer 269C · Cleveland, OHThe engine failure from the rod cap bolt being sheared and the separation of the number two cylinder separating from the crankcase.Mar 20, 1997 · N892CP · Substantial damageNTSB FTW97FA130Accident · 1 fatalField investigationFinal reportCessna 421 · League City, TXThe pilot's failure to refuel the airplane which resulted in the loss of power to the right engine due to fuel exhaustion, and the pilot's failure to maintain airspeed during the single engine landing approach which resulted in a stall/spin.Mar 20, 1997 · N4050L · Substantial damageNTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.Mar 20, 1997 · N5526G · Substantial damageNTSB FTW97LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Fort Collins, COa total loss of power for reasons undetermined. A factor was unsuitable terrain for a forced landing.Mar 19, 1997 · N98150 · Substantial damageNTSB FTW97LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Manchaca, TXThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain obstacle clearance. A factor was the weather condition.Mar 17, 1997 · N6320E · DestroyedNTSB FTW97LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hartsel, COThe pilot's misjudging the proper touchdown point on the dirt road due to excessive airspeed and his failure to deploy flaps. Factors were the partial loss of engine lubricating oil due to the oil filler cap separating because some unknown person failed to…Mar 16, 1997 · N38703 · DestroyedNTSB MIA97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Nashville, TNimproper planning/decision by the pilot, by failing to ensure there was sufficient fuel to reach a suitable landing area, which resulted in fuel exhaustion, loss of engine power, a forced landing, and collision with a tree. The faulty fuel indication was a…Mar 15, 1997 · N2505Q · Substantial damageNTSB MIA97FA097Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Andrews, NCThe pilot's poor in-flight planning in attempting to maintain VFR conditions at night over mountainous terrain, and his failure to maintain clearance from the mountain. Contributing to the accident was: the pilot's inadequate preflight planning for not…Mar 15, 1997 · N8857P · DestroyedNTSB LAX97LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Barbara, CAthe pilot's improper planning/decision, which resulted in loss of engine power, due to fuel exhaustion. His psychological condition was a related factor.Mar 15, 1997 · N7163R · Substantial damageNTSB CHI97FA084Accident · 4 fatalField investigationFinal reportDouglas DC-3C/BT-67R · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.Mar 15, 1997 · TZ389 · 2 aircraft · DestroyedNTSB ANC97IA035Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Kotzebue, AKthe jammed main landing gear which was caused by a binding main landing gear door with a broken hinge. The fractured, inadequate main landing gear door hinge was also causal.Mar 15, 1997 · N3542H · Minor damageNTSB SEA97LA069Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5A · North Bend, ORThe pilot's failure to perform the proper remedial action of applying carburetor heat/alternate induction air after impact ice accumulated on his aircraft's induction air filter. Factors include intentional flight into known adverse weather (icing…Mar 12, 1997 · N26848 · Substantial damageNTSB LAX97LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Winters, CAthe failure of the engine cylinder head assembly due to operational fatigue.Mar 11, 1997 · N36265 · Substantial damageNTSB CHI97LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marquette, MImultiple oil leaks in the engine lubrication system. Factors were the disconnected wet vacuum pump line and the oil exhaustion.Mar 11, 1997 · N171AS · Substantial damageNTSB SEA97FA070Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Boise, IDthe accumulation of airframe ice on the aircraft, and the pilot's delayed remedial action after intentionally flying into forecast adverse weather conditions. The adverse weather (icing) conditions were related factors.Mar 7, 1997 · N7583P · DestroyedNTSB CHI97LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mosinee, WIThe formation of carburetor ice and the instructor pilot's failure to recognize conditions leading to carburetor icing and to take appropriate preventative action. Factors relating to this accident were the late application of carburetor heat, the icing…Mar 7, 1997 · N8259M · Substantial damageNTSB ATL97LA047Accident · Minor injuriesLimited investigationFinal reportConvair 240-27 · Hampton, GAa partial loss of power on one engine for undetermined reason(s), and the pilot's failure to follow aircraft emergency procedures. A factor was inadequate transition/upgrade training.Mar 7, 1997 · N357T · Substantial damageNTSB ANC97FA031Accident · 2 fatalField investigationFinal reportBuesing SX-300 · Sitka, AKthe pilot's failure to properly evaluate the presence of icing conditions, and his failure to comply with procedures to use alternate engine air in icing conditions. Factors relating to the accident were: icing (weather) conditions, the pilot's improper…Mar 7, 1997 · N357SX · DestroyedNTSB NYC97FA057Accident · 2 fatalField investigationFinal reportBeech E-18S · Mabie, WVThe pilot's disregard of the preflight weather briefing for severe weather along his route of flight, and his departure into the known and forecasted severe weather. A factor in the accident was the inadequate FAA oversight of the operator, which fostered an…Mar 6, 1997 · N54BT · DestroyedNTSB ATL97LA045Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Aikens, SCexcessive wear of the fuel metering unit/shaft, which resulted in a fuel leak and premature exhaustion of the fuel supply.Mar 5, 1997 · N7312V · Substantial damageNTSB MIA97LA093Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Nashville, GAa stuck (jammed) fuel selector valve, due to corrosion from a fuel drain spring, which resulted in fuel starvation, loss of engine power, a forced landing, and subsequent impact with trees. A factor relating to the accident was: the pilot's inadequate…Mar 4, 1997 · N3257C · Substantial damageNTSB FTW97LA114Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Jamaica Beach, TXThe pilot's encounter with instrument meteorological conditions, and his subsequent loss of aircraft control due to the loss of visual cues to detect his height above the water. Factors were the low ceilings and fog, and the loss of tail rotor effectiveness.Mar 4, 1997 · N5829D · DestroyedNTSB FTW97LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thibodaux, LAThe failure of maintenance personnel to comply with an airworthiness directive which specified the correct type of oil quick drain valve for this airplane, the installation of an incorrect oil quick drain valve by maintenance personnel, and the subsequent…Mar 4, 1997 · N2654T · Substantial damage