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 SEA97LA216Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Creswell, ORThe pilot's improper fuel management in which the fuel selector was positioned on tank with inadequate fuel resulting in fuel starvation. Also causal was the pilot's failure to perform the pilot operating handbook 'engine failure in flight' procedure. A…Sep 26, 1997 · N6394W · Substantial damageNTSB NYC97LA187Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 · Long Island, NYAn in-flight encounter with clear air turbulence and the passenger's failure to comply with the fasten seatbelt sign.Sep 26, 1997 · N14077 · No damageNTSB LAX97FA331Accident · 1 fatalField investigationFinal reportCessna 172K · Sandy Valley, NVthe pilot's intentional VFR flight into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from mountainous/hilly terrain. Related factors were: the high/mountainous/hilly terrain, and the adverse weather condition (low…Sep 26, 1997 · N84621 · DestroyedNTSB CHI97LA301Accident · No injuriesLimited investigationFinal reportUniversal D-16 · Howell, MIthe emergency landing gear extension system being impeded by flap extension. Factors contributing to this accident are the instructor pilot's intentional feathering of the airplane's left propeller, the instructor pilot's lack of familiarity with the…Sep 25, 1997 · N110N · Substantial damageNTSB NYC97FA186Accident · 1 fatalField investigationFinal reportCessna 172 · Normalville, PAthe pilot's inadequate clearance above an unlighted ridgeline in clouds and fog at night, and his decision to not file an IFR flight plan and his VFR flight into IMC conditions.Sep 24, 1997 · N35405 · DestroyedNTSB NYC97FA185Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Glastenbury, VTthe pilot's improper decision to disregard the weather briefing and continue into adverse weather which resulted in a loss of control. The weather was a factor.Sep 23, 1997 · CGHUE · DestroyedNTSB IAD97FA122Accident · 1 fatalField investigationFinal reportCessna 172P · Airville, PAThe student pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent collision with terrain.Sep 22, 1997 · N55221 · DestroyedNTSB FTW97LA358Accident · No injuriesLimited investigationFinal reportMooney M20C · Pettigrew, ARThe pilot's improper in-flight decision. Factors were the prevailing low ceilings, the inaccurate flight and navigation instruments as result of the failure of the engine accessories vacuum pump and the lack of suitable terrain for the pilot to execute the…Sep 20, 1997 · N7045V · Substantial damageNTSB FTW97LA354Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Houma, LAThe loss of aircraft control resulting from a bird strike that severed the cyclic flight control.Sep 20, 1997 · N210PH · Substantial damageNTSB MIA97LA250Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Miami, FLThe failure of the pilot to properly plan his descent and approach for a forced landing following partial loss of engine power resulting in the aircraft landing short of the intended landing runway. A factor in the accident was improper inspection of the…Sep 19, 1997 · N4315X · Substantial damageNTSB MIA97FA249Accident · 2 fatalField investigationFinal reportCessna 177RG · Sebring, FLcontinued flight by the pilot into adverse weather conditions, and his failure to maintain aircraft control, which resulted in an uncontrolled descent until impact in a lake. The adverse weather condition (thunderstorm) was a related factor.Sep 19, 1997 · N2562V · DestroyedNTSB FTW97FA352Accident · Minor injuriesField investigationFinal reportBell 407 · Grand Isle S108The tail rotor blade strike(s) that severed the aft portion of the tailboom, subsequently rendering the pilot with no tail rotor control while in cruise flight. A factor was the lack of suitable terrain for the forced autorotative landing.Sep 18, 1997 · N467PH · Substantial damageNTSB CHI97LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INthe pilot's improper planning/decision and failure to refuel the airplane in a timely manner, which resulted in fuel exhaustion. A related factor was: trees in the emergency landing area.Sep 18, 1997 · N6421R · Substantial damageNTSB SEA97LA210Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · The Dalles, ORthe pilot-in-command(CFI)'s failure to refuel which subsequently led to fuel exhaustion.Sep 14, 1997 · N357DA · Substantial damageNTSB CHI97LA292Accident · Serious injuriesLimited investigationFinal reportBoeing 747-422 · Grand Forks, NDThe flight attendant's seat belt was not secured. A factor was turbulence in the clouds.Sep 14, 1997 · N175UA · No damageNTSB ANC97LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Healy, AKThe pilot's inadequate preflight which failed to detect water contamination in the fuel tanks. Factors were the worn gaskets on the fuel tank caps, and the pilot's decision to abort the partial power precautionary landing.Sep 14, 1997 · N7894H · Substantial damageNTSB NYC97LA182Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Crimora, VAThe pilot's mismangement of fuel which resulted in fuel exhaustion. Contributing was his inadequate preflight planning that resulted in an inadequate fuel supply..Sep 13, 1997 · N5272X · Substantial damageNTSB MIA97LA243Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Oxford, NCfatigue failure of the No.4 connecting rod in an area where galling had occurred, which resulted in loss of engine power and a forced landing. Related factors were: the pilot's lack of communication by failing to select the proper UNICOM frequency; and his…Sep 13, 1997 · N9385C · Substantial damageNTSB FTW97LA347Accident · No injuriesLimited investigationFinal reportHughes MDL-369HS · Brinkley, ARThe in flight collision of the tail rotor blade with an object that had a brass zipper on it, and the subsequent overload and failure of the tail rotor drive shaft. Factors were the object with the brass zipper on it and the unsuitable terrain for the forced…Sep 12, 1997 · N107CW · Substantial damageNTSB MIA97FA242Accident · 1 fatalField investigationFinal reportMooney M20F · Coral Springs, FLThe pilot's misjudging the distance vs. altitude resulting in the collision with the water short of the intended touchdown point of the rough field. Contributing to the accident was the total loss of engine power due to failure of the No. 3 cylinder…Sep 11, 1997 · N6417Q · Substantial damageNTSB LAX97LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Murrieta, CAfailure of the flight instructor (CFI) to ensure an adequate preflight of the airplane, and his failure to properly quantify or verify the fuel onboard before departing on a dual instruction flight, which resulted in fuel exhaustion and a forced landing.Sep 10, 1997 · N65406 · Substantial damageNTSB FTW97FA340Accident · 3 fatalField investigationFinal reportCessna 182N · Montrose, COInadequate preflight and in-flight planning, preparation and decision making. A related factor was the improper use of flaps.Sep 8, 1997 · N9043G · DestroyedNTSB LAX97LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Madera, CAfuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.Sep 7, 1997 · N81MK · Substantial damageNTSB CHI97LA285Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE-ATP · Peru, ILsudden/unexpected encounter with clear air turbulence.Sep 7, 1997 · N855AW · No damageNTSB CHI97FA283Accident · 1 fatalField investigationFinal reportCessna 177B · Crump, MIContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…Sep 7, 1997 · N34142 · DestroyedNTSB LAX97LA314Accident · Serious injuriesLimited investigationFinal reportHallam RV-6 · Woodlake, CAfailure of the pilot to accurately determine the quantity of fuel onboard the airplane before flight, and subsequent loss of engine power due to fuel starvation, which resulted in a forced landing.Sep 6, 1997 · N93SJ · Substantial damageNTSB CHI97LA284Accident · 2 fatalLimited investigationFinal reportNorth American-Aero Classics P-51D · Monroe, MIthe pilot operating the airplane with a known coolant leak, coolant exhaustion, overheating of the engine, and subsequent failure of a connecting rod, which resulted in a partial loss of engine power; and failure of the pilot to see the powerline. The…Sep 6, 1997 · N6345T · DestroyedNTSB ANC97FA143Accident · 2 fatalField investigationFinal reportAero Commander AC-500A · Ketchikan, AKThe rupture of the right engine fuel supply line as a result of inadequate inspection by the pilot/mechanic, and the pilot's excessive pull up which resulted in exceeding the design stress limits of the airplane. Factors were the improper emergency procedures…Sep 6, 1997 · N543AN · DestroyedNTSB LAX97LA319Accident · No injuriesLimited investigationFinal reportMooney M20E · Gulf Of Ca (Pacific Ocean)The loss of engine power for undetermined reasons.Sep 5, 1997 · N9217V · DestroyedNTSB IAD97LA119Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-F · Carrollton, OHThe pilot's inadequate preflight which resulted in fuel exhaustion.Sep 5, 1997 · N1871K · Substantial damageNTSB FTW97LA338Accident · No injuriesLimited investigationFinal reportBeech V35B · Saguache, CO**This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…Sep 4, 1997 · N7397R · Substantial damageNTSB FTW97LA337Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Saratoga, WYThe pilot's failure to consult airplane performance data based upon the weather conditions that prevailed. Factors were terrain induced turbulence and high density altitude.Sep 3, 1997 · N8731C · Substantial damageNTSB SEA97FA201Accident · 5 fatalField investigationFinal reportCessna 182C · Bremerton, WAThe pilot's failure to maintain adequate airspeed in a climbing turn at low altitude, resulting in a stall and impact with terrain. A factor was the pilot exceeding the aircraft's maximum takeoff gross weight limitation.Sep 1, 1997 · N9015T · DestroyedNTSB CHI97LA275Accident · Minor injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · Blakesburg, IALoss of engine power for undetermined reasons.Sep 1, 1997 · N131G · Substantial damageNTSB NYC97LA175Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Fredericksburg, VAA loss of engine power for undetermined reasons.Aug 31, 1997 · N4376B · Substantial damageNTSB SEA97LA198Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1B · Dayville, ORImproper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…Aug 29, 1997 · N22753 · Substantial damageNTSB LAX97LA312Accident · No injuriesLimited investigationFinal reportCessna T210J · Avra Valley, AZThe pilot became lost/disoriented during his taxiing into the ramp area. Factors in the accident were the lack of taxiway lights, the pilot's lack of familiarity with the layout of the airport, and the airport operator's failure to either identify the…Aug 29, 1997 · N2280R · Substantial damageNTSB LAX97LA307Accident · No injuriesLimited investigationFinal reportCessna T210M · San Martin, CAInstallation of improper connecting hardware by maintenance personnel, and, the inadequate inspection of the installed hardware by inspection personnel resulting in separation of the engine throttle linkage.Aug 29, 1997 · N761HQ · Substantial damageNTSB FTW97LA332Accident · No injuriesLimited investigationFinal reportPitts S-2B · Mountain View, ARFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.Aug 27, 1997 · N9QT · Substantial damageNTSB FTW97LA328Accident · No injuriesLimited investigationFinal reportFingerhut Revolution Mini 500 · Huffman, TXThe disengagement of the helicopter's collective control tube due to improper installation by the builder. Factors were the lack of sufficient information provided by the kit manufacturer and the pilot's inability to cushion the landing.Aug 27, 1997 · N570F · Substantial damageNTSB CHI97FA272Accident · 1 fatalField investigationFinal reportKellums Sonerai 1 · Scottsburg, INa loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed greater than the stalling speed for the airplane. A factor relating to this accident was the student pilot's lack of total experience.Aug 26, 1997 · N76457 · DestroyedNTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.Aug 26, 1997 · N6216Q · Substantial damageNTSB NYC97FA170Accident · 1 fatalField investigationFinal reportCessna 337B · Warren Township, NJthe pilot's loss of control in flight for undetermined reasons and the subsequent collision with terrain.Aug 25, 1997 · N2442S · DestroyedNTSB LAX97LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Mecca, CAfuel exhaustion as a result of the student pilot's inadequate preflight and failure to refuel.Aug 25, 1997 · N152RJ · Substantial damageNTSB LAX97LA304Accident · Serious injuriesLimited investigationFinal reportWalton Velocity STD/FG · Chino Valley, AZa loss of engine power for undetermined reasons.Aug 25, 1997 · N7VX · Substantial damageNTSB LAX97LA302Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Kenwood, CAthe pilot's improper planning/decision, which resulted in fuel exhaustion and a forced landing, due to an inadequate supply of fuel.Aug 25, 1997 · N733QD · Substantial damageNTSB LAX97LA301Accident · No injuriesLimited investigationFinal reportBeech H35 · Goleta, CAwas a loss of engine power for undetermined reasons.Aug 25, 1997 · N222M · DestroyedNTSB SEA97LA195Accident · Serious injuriesLimited investigationFinal reportCessna 170 · Elk City, IDOil starvation of the engine due to undetermined reasons, which led to the failure and separation of a main bearing and a connecting rod. A factor contributing to the accident was the lack of suitable terrain for a successful forced landing.Aug 24, 1997 · N3964V · DestroyedNTSB FTW97LA327Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Terrell, TXthe student pilot's premature flare for landing from an autorotation, and the ensuing loss of rotor rpm, which resulted in a hard landing. A factor relating to the accident was: partial loss of engine power for undetermined reason(s).Aug 24, 1997 · N8057Z · Substantial damageNTSB ATL97LA124Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Anderson, SCthe pilot misjudged distance and speed on final approach to land and failed to attain a proper touchdown point during the landing, which resulted in an overrun of the runway and collision with a fence. A related factor was the loss of engine power during…Aug 24, 1997 · N4668N · Substantial damage