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 IAD98LA009Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Smoketown, PAThe pilot in command's (CFI) improper management of the fuel supply, which resulted in fuel exhaustion of the selected tank and the subsequent loss of engine power.Oct 30, 1997 · N600WL · Substantial damageNTSB CHI98FA028Accident · 6 fatalField investigationFinal reportBeech BE 58 · New Berlin, ILA loss of engine power due to separation of the left engine's number 2 connecting rod as a result of fatigue failure. Also causal was the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Contributing to the accident was the…Oct 30, 1997 · N472TL · DestroyedNTSB LAX98LA026Accident · Minor injuriesLimited investigationFinal reportStriplin Lone Ranger Slvr CLD · Agua Dulce, CAFailure of the propeller system/drive assembly, and the pilot's failure to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection of the propeller system was a contributing factor.Oct 29, 1997 · N4478Y · DestroyedNTSB CHI98LA027Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Augusta, KSfailure of the aircraft owner to reinstall the quick release hinge pins/safety pins, and failure of the pilot to notice the missing pins during the aircraft preflight, which resulted in separation of the main entry door during flight.Oct 29, 1997 · N7505F · Substantial damageNTSB LAX98FA031Accident · 4 fatalField investigationFinal reportCessna U206B · Markleeville, CAthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the excessive gross weight of the airplane, the high density altitude, and the…Oct 27, 1997 · N4982F · DestroyedNTSB SEA98LA008Accident · 1 fatalLimited investigationFinal reportBeckham RV-4 · Scio, ORThe pilot-in-command's loss of control of the aircraft for undetermined reasons.Oct 26, 1997 · N160HB · DestroyedNTSB NYC98FA020Accident · 1 fatalField investigationFinal reportCessna 172E · Elkton, VAThe pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..Oct 26, 1997 · N3097U · DestroyedNTSB FTW98FA031Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Hazen, ARThe pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the make and model of aircraft, the pilot's lack of total night flight experience, and the dark night conditions,Oct 25, 1997 · N8146R · DestroyedNTSB NYC98FA018Accident · No injuriesField investigationFinal reportEnstrom F-28C · Fairview, PAinadequate maintenance, which led to detonation and a melted piston, and subsequent power loss.Oct 24, 1997 · N1944J · Substantial damageNTSB MIA98FA015Accident · 2 fatalField investigationFinal reportCessna 172M · Rabun Gap, GAThe pilot's continued flight under visual flight rules into known instrument meteorological conditions and his failure to maintain a safe altitude for terrain clearance resulting in the aircraft colliding with trees and the ground on the side of a mountain.Oct 24, 1997 · N1499U · DestroyedNTSB SEA98LA007Accident · 2 fatalLimited investigationFinal reportCessna 185A · Damascus, ORfailure of the pilot to maintain sufficient altitude/clearance from terrain. Factors relating to the accident included: darkness, and hilly/mountainous terrain.Oct 23, 1997 · N714 · DestroyedNTSB ANC98FA006Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Juneau, AKThe pilot's intentional flight into adverse weather. Related factors were the low ceilings, mountainous terrain, and self induced pressure by the pilot to complete the flight and return for the evening.Oct 23, 1997 · N30505 · DestroyedNTSB ANC98LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Naknek, AKThe loss of engine power due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the lack of suitable terrain for a forced landing.Oct 21, 1997 · N7049K · Substantial damageNTSB NYC98LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Scottsville, VAimproper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.Oct 20, 1997 · N2200J · Substantial damageNTSB NYC98FA016Accident · 1 fatalField investigationFinal reportCessna 182P · Morgantown, WVThe loss of engine power due to carburetor ice and the pilot's failure to follow ATC instructions during the emergency descent.Oct 20, 1997 · N9388G · DestroyedNTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.Oct 20, 1997 · N6206K · DestroyedNTSB CHI98LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · St Charles, MOfailure of the alternator's front bearing, depletion of battery power, and failure of the emergency landing gear extension handcrank to engage during the pilot's attempt to perform the emergency procedure.Oct 20, 1997 · N9449V · Substantial damageNTSB SEA98LA006Accident · No injuriesLimited investigationFinal reportBell 47-G3B · Winston, MTFuel starvation due to fuel flow restriction from a failed carburetor automatic mixture control device. Factors include night light conditions for the forced landing.Oct 19, 1997 · N47AH · Substantial damageNTSB FTW98LA022Accident · No injuriesLimited investigationFinal reportCessna 150G · Tyler, TXThe failure of the of pilot of the departing Cessna to follow standard departure procedures and his disorientation while navigating to locate a highway. A factor was the failure of both pilots to maintain visual lookout.Oct 19, 1997 · N3916J · 2 aircraft · Minor damageNTSB ATL98LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Miami, FLexcessive wear to the number one valve stem and valve stem keepers that resulted in the separation of the valve assembly.Oct 19, 1997 · N7814U · Substantial damageNTSB MIA98LA013Accident · No injuriesLimited investigationFinal reportCessna 172G · Panacea, FLThe pilot's improper use of carburetor heat resulting in loss of engine power due to carburetor icing and an in flight collision with trees during a forced landing.Oct 17, 1997 · N4690L · Substantial damageNTSB CHI98LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Quincy, ILimproper in-flight planning/decision by the flight instructor (CFI), by switching 'OFF' the fuel selector valve of the single-engine airplane (starving the engine of fuel) to 'simulate' an emergency. Factors relating to the accident were: the soft and uneven…Oct 17, 1997 · N68299 · DestroyedNTSB FTW98IA019Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Seattle, WAMaintenance personnel's failure to properly secure the left off-wing slide door after routine slide replacement, allowing an inflight separation of the slide. Factors were inadequate training of maintenance personnel and inadequate written instructions by the…Oct 16, 1997 · N581UA · Minor damageNTSB FTW98TA051Incident · No injuriesFinal reportCessna P210N · Bryce Canyon, UTThe failure of the resistor (inverter) in the door seal pressurization air pump due to continuous operation. Factors were a failure in the door seal pressurization system, its inadequate design by the manufacturer, its inadequate written instructions for…Oct 15, 1997 · N731NX · Minor damageNTSB NYC98LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittsfield, MAThe pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.Oct 14, 1997 · N62264 · Substantial damageNTSB LAX98FA008Accident · 1 fatalField investigationFinal reportAdrian Davis LONG-EZ · Pacific Grove, CAthe pilot's diversion of attention from the operation of the airplane and his inadvertent application of right rudder that resulted in the loss of airplane control while attempting to manipulate the fuel selector handle. Also, the Board determined that the…Oct 13, 1997 · N555JD · DestroyedNTSB SEA98FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Leadore, IDthe pilot's inadvertent entry into instrument meteorological conditions, and his failure to maintain clearance from wooded terrain in the area where he was maneuvering. Factors relating to the accident include: darkness, low ceiling, and high/mountainous…Oct 11, 1997 · N2938B · DestroyedNTSB LAX98LA025Accident · No injuriesLimited investigationFinal reportCiernia GLASAIR-III · Desert Center, CAA loss of engine power due to the eventual loss of electrical power which resulted from the pilot's failure to ensure the alternator switch was on as specified in the before starting checklist. The inoperative alternator out warning light was a factor in this…Oct 11, 1997 · N153JC · Substantial damageNTSB LAX98FA006Accident · 1 fatalField investigationFinal reportCessna 152 · Julian, CAThe pilot's inadequate in-flight planning which resulted in VFR flight into instrument meteorological conditions and the loss of aircraft control. Contributing was the pilot's overconfidence in his ability, clouds, and rain.Oct 11, 1997 · N67293 · DestroyedNTSB CHI98LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Williston, NDthe pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.Oct 11, 1997 · N9691P · Substantial damageNTSB MIA98LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Gulf Of Mexicoloss of engine power for undetermined reason(s), which resulted in a forced landing (ditching) at sea.Oct 9, 1997 · N7198D · Substantial damageNTSB CHI98LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Liberty, NEA loss of engine power for undetermined reasons.Oct 9, 1997 · N4027L · Substantial damageNTSB CHI98LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Charlotte, MIimproper positioning of the fuel selector by the second pilot, which resulted in fuel starvation; inadequate supervision by the pilot-in-command; and failure of the flight crew to follow the published emergency procedures for loss of engine power.Oct 9, 1997 · N54738 · Substantial damageNTSB DCA98MA002Accident · 9 fatalMajor investigationFinal reportCessna 208B · Montrose, COthe pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…Oct 8, 1997 · N12022 · DestroyedNTSB MIA98FA007Accident · 3 fatalField investigationFinal reportBeech 35-C33A · Robbins, NCfailure of the pilots in both aircraft to see-and-avoid each other's airplane (inadequate visual lookout), and failure of the Beech pilot to operate his airplane at a correct Visual Flight Rules (VFR) cruising altitude for his route of flight.Oct 7, 1997 · N2050W · 2 aircraft · DestroyedNTSB FTW98LA007Accident · Serious injuriesLimited investigationFinal reportBeech G18S · Crosbyton, TXInadequate maintenance which resulted in diminished carburetor heat effectiveness due to missing alternate air doors. Contributing were conducive carburetor icing weather conditions, low ceilings during the emergency descent, and the lack of suitable terrain…Oct 6, 1997 · N9312Y · Substantial damageNTSB CHI98FA017Accident · No injuriesField investigationFinal reportBeech G35 · Poplar Grove, ILflutter for an undetermined reason, which resulted in structural damage to the aft fuselage.Oct 6, 1997 · N129B · Substantial damageNTSB FTW98LA005Accident · No injuriesLimited investigationFinal reportCessna 175A · Bentonville, ARThe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Oct 5, 1997 · N7091E · DestroyedNTSB NYC98LA005Accident · No injuriesLimited investigationFinal reportCessna 120 · Mineral Wells, WVA loss of engine power to a blockage in the carburetor resulting in fuel starvation.Oct 4, 1997 · N76898 · Substantial damageNTSB LAX98LA001Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Burbank, CAA loss of engine power for undetermined reasons.Oct 3, 1997 · N2483B · Substantial damageNTSB IAD98LA002Accident · No injuriesLimited investigationFinal reportHughes 269A · Campbellsville, KYThe pilot refueled the helicopter with jet fuel instead of avgas, which resulted in a loss of engine power. A related factor was the unsuitable terrain.Oct 3, 1997 · N269SS · Substantial damageNTSB MIA98LA002Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Cross City, FLThe in-flight encounter with turbulence associated with a nearby level 6 thunderstorm with moderate rain while deviating.Oct 2, 1997 · N33502 · No damageNTSB CHI98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Nebraska City, NEthe pilot's improper positioning of the fuel slector to a tank which contained only unusable fuel.Oct 2, 1997 · N1092X · Substantial damageNTSB NYC98LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Gt. Barrington, MAslippage of the number 2 main bearing for undetermined reason(s) which resulted in a broken crankshaft.Oct 1, 1997 · N29134 · Substantial damageNTSB FTW97LA371Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Santa Rosa, NMimproper planning/decision by the pilot, which led to fuel exhaustion, loss of engine power, and a forced landing. A related factor was the lack of suitable terrain for the forced landing.Sep 30, 1997 · N260MT · Substantial damageNTSB CHI97LA302Accident · Serious injuriesLimited investigationFinal reportRans S-11 Pursuit · Hays, KSfailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. The pilot's lack of experience in the make and model of airplane was a related factor.Sep 29, 1997 · N4299Y · Substantial damageNTSB FTW97LA367Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Mora, NMloss of power in the right engine for undetermined reason(s). Related factors were: that the power loss occurred above the airplane's single engine service ceiling (at high density altitude), and the lack of suitable terrain for a forced landing.Sep 28, 1997 · N365C · DestroyedNTSB ATL97LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fulton, MSThe excessively rich mixture produced by the carburetor, which led to the fuel exhaustion.Sep 28, 1997 · N35652 · Substantial damageNTSB IAD97FA123Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Pittsfield, MAThe first pilot's improper procedures for an autorotation, and improper flare which resulted in a hard landing. Also causal was the second pilot's inadequate remedial action.Sep 27, 1997 · N5045F · DestroyedNTSB ATL97LA142Accident · No injuriesLimited investigationFinal reportBeech 33 · Winston-Salem, NCthe pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.Sep 27, 1997 · N331DP · Substantial damage