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 MIA97LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Sugarloaf Key, FLa complete loss of engine power due to a disconnected connecting rod cap.Dec 1, 1996 · N9545J · Substantial damageNTSB LAX97LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tusayan, AZFuel exhaustion due to the pilot's inadequate preflight planning and his miscalculation of the fuel required for the flight.Dec 1, 1996 · N3566X · Substantial damageNTSB NYC97LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Long Pond, PAThe pilot's inadequate preflight planning/preparation and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related…Nov 30, 1996 · N4839F · Substantial damageNTSB LAX97LA058Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Scottsdale, AZdetonation/pre-ignition for unknown reason(s), which resulted in failure of the number two piston, loss of engine power, and a subsequent forced landing on rough/uneven desert terrain.Nov 30, 1996 · N4788C · DestroyedNTSB FTW97FA051Accident · 3 fatalField investigationFinal reportEurocopter AS350B2 · High Island A20This case was modified 6/26/2006. The failure of the tail rotor pitch change link due to a fatigue fracture, which resulted in a loss of tail rotor control and separation of the aft tailboom.Nov 28, 1996 · N6100U · DestroyedNTSB CHI97LA037Accident · No injuriesLimited investigationFinal reportCessna 150 · Bowbells, NDthe pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.Nov 27, 1996 · CGOCS · Substantial damageNTSB ATL97LA027Accident · No injuriesLimited investigationFinal reportBeech 35 · Lafayette, GAfailure of maintenance personnel to balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.Nov 27, 1996 · N4523V · Substantial damageNTSB NYC97FA021Accident · 2 fatalField investigationFinal reportCessna 414 · Duo, WVThe pilot's inadequate inflight decision which resulted in VFR flight into instrument meteorological conditions and his failure to maintain adequate terrain clearance which resulted in an inflight collision with terrain. The low ceiling was a factor.Nov 26, 1996 · N73CP · DestroyedNTSB NYC97FA019Accident · No injuriesField investigationFinal reportCessna 172N · Andover, MAfailure of the dual magneto, which resulted in a total loss of engine power, and subsequent collision with trees during a forced landing at night. Darkness and trees in the emergency landing area were related factors.Nov 21, 1996 · N4926G · Substantial damageNTSB LAX97FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Lost Hills, CAThe pilot's continued VFR flight into instrument meteorological conditions, which led to spatial disorientation and loss of aircraft control, and the pilot exceeding the aircraft's design stress limits during an attempted recovery. The noninstrument-rated…Nov 21, 1996 · N8447B · DestroyedNTSB LAX97LA051Accident · Serious injuriesLimited investigationFinal reportBoeing 737-500 · Bishop, CAa clear air turbulence encounter.Nov 20, 1996 · N916UA · No damageNTSB SEA97LA030Accident · No injuriesLimited investigationFinal reportCessna 421B · Olympia, WAinoperative deicing equipment, due to multiple wing boot holes and malfunctioning control/shuttle valves; subsequent build-up of airframe (wing) ice; and failure of the pilot to maintain adequate airspeed during the flare for landing. Factors relating to the…Nov 19, 1996 · N8005Q · Substantial damageNTSB CHI97FA030Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Grand Rapids, MIa passenger sustained a fractured ankle during an emergency evacuation for undetermined reasons.Nov 19, 1996 · N9038U · No damageNTSB MIA97LA024Accident · No injuriesLimited investigationFinal reportCessna 182C · Anderson, SCthe pilot's improper preflight, resulting in the fuel cap(s) not being secured; and subsequent siphoning and loss of fuel, which resulted in loss of engine power, a forced landing, and subsequent collision with a ditch during the emergency landing.Nov 17, 1996 · N8605T · Substantial damageNTSB LAX97FA044Accident · 1 fatalField investigationFinal reportCessna 152 · Gilroy, CAflight by the pilot into into adverse weather conditions, and his failure to maintain altitude or clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.Nov 17, 1996 · N48737 · DestroyedNTSB CHI97IA029Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hopkensville, KYthe materials used in the new windshield, to meet new EPA requirements, were inadequate for the design.Nov 17, 1996 · N841SK · Minor damageNTSB NYC97LA018Accident · No injuriesLimited investigationFinal reportDubis Team Minimax · North Adams, MAfuel contamination, which resulted in a loss of engine power. Factors relating to the accident were: the lack of a drain in the fuel system to properly check the fuel before flight, and the pilot's failure (or inability) to detect the contaminated fuel.Nov 16, 1996 · N4335W · Substantial damageNTSB LAX97LA042Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Apple Valley, CAfuel starvation, due to plugged fuel system vent lines, which resulted in loss of engine power.Nov 15, 1996 · N961T · Substantial damageNTSB IAD97FA022Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · West Milton, OHThe pilot's inability to maintain aircraft control after an undetermined failure of the automatic flight control. A contributing factor was failure of the maintenance technician to have the airplane test flown prior to release.Nov 15, 1996 · N8468H · DestroyedNTSB LAX97LA303Accident · 1 fatalLimited investigationFinal reportFleming Glassair III · Dunsmuir, CAwas the pilot's intentional flight into marginal meteorological conditions in mountainous terrain during dark nighttime conditions.Nov 14, 1996 · N77DF · DestroyedNTSB LAX97LA039Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Hana, HIsubsequent failure of the spur adapter gearshaft (SAG), after 'retaining ring to compressor impeller machining' occurred and allowed the SAG to shift aft. The mechanism which induced the ring to impeller machining was not determined. Mountainous terrain in…Nov 13, 1996 · N8625F · Substantial damageNTSB FTW97FA039Accident · 1 fatalField investigationFinal reportCessna 182Q · Colorado City, TXthe pilot's encounter with instrument meteorological conditions (IMC), and his subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the clouds, low ceilings, and the pilot's lack of recent instrument…Nov 12, 1996 · N5116N · DestroyedNTSB IAD97LA019Accident · 1 fatalLimited investigationFinal reportCessna 150 · Edgerton, OHthe pilot's Inadvertent VFR flight into instrument meteorological conditions resulting in spatial disorientation and subsequent loss of control of the airplane. Factors to this accident were the night conditions and snow.Nov 11, 1996 · N5627E · DestroyedNTSB MIA97LA023Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Brunswick, GAa complete loss of engine power as a result of piston failure, oil starvation, and the subsequent forced landing in unsuitable terrain.Nov 9, 1996 · N86DR · Substantial damageNTSB MIA97LA022Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Columbiana, ALthe pilot's improper use of the fuel selector, which resulted in fuel starvation, and his failure to select a tank with fuel for a restart, which resulted in a failure to restart the engine, a forced landing, and subsequent impact with terrain. High…Nov 9, 1996 · N6026T · Substantial damageNTSB IAD97IA018Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-11 · Dayton, OHFailure of the output drive unit shear pin due to lack of lubrication to the screw actuator assemblies. Contributing to the cause was the aircraft manufacturer's production and inspection personnel failing to lubricate the screw assemblies after initial…Nov 8, 1996 · N814DE · No damageNTSB NYC97FA013Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Lehman Township, PAThe failure of the forward fuselage nose assembly for an undetermined reason, which resulted in an in-flight breakup of the airplane.Nov 6, 1996 · N5671V · DestroyedNTSB CHI97LA021Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Kirksville, MOan improper maintenance overhaul by company maintenance personnel which led to a bearing failure. The soft terrain was a factor.Nov 3, 1996 · N30614 · Substantial damageNTSB LAX97LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Lake Havasu, AZcarburetor ice, and failure of the pilot to use carburetor heat, which resulted in loss of engine power. Factors relating to the accident were: carburetor icing conditions, darkness, and the lack of suitable terrain for a forced landing.Nov 2, 1996 · N2825V · DestroyedNTSB LAX97LA031Accident · 2 fatalLimited investigationFinal reportRainey Rans S-12 · Tucson, AZa broken wire in the ignition coil, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spin and uncontrolled collision with the terrain.Nov 2, 1996 · N95HS · DestroyedNTSB LAX97FA032Accident · 5 fatalField investigationFinal reportPiper PA-34-200 · Halawa, HIthe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain sufficient clearance and/or altitude from mountainous terrain. Factors related to the accident were: darkness, adverse weather conditions, and…Nov 2, 1996 · N1701K · DestroyedNTSB FTW97FA033Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-36 · Boulder, COThe pilot exceeding the design stress limits of the aircraft by performing an aerobatic maneuver, resulting in total failure of the wing spar.Nov 2, 1996 · N3616Z · DestroyedNTSB CHI97LA018Accident · 1 fatalLimited investigationFinal reportFrost RAF 2000 GTX SE · Adrian, MIthe pilot's failure to maintain control of the aircraft. A factor was his lack of familiarity with the airplane.Nov 2, 1996 · N914VT · Substantial damageNTSB ATL97LA012Accident · Serious injuriesLimited investigationFinal reportDouglas C-47 · Dorado, PRfailure of the #11 cylinder on the right (#2) engine, which resulted in an in-flight fire and loss of power in that engine; and a malfunction/failure of the #2 feathering system, which led to a subsequent forced landing before the flight crew could return to…Oct 31, 1996 · N37AP · Substantial damageNTSB ANC97LA005Accident · No injuriesLimited investigationFinal reportKen Seright Rotorway Exec 162F · Haines, AKa leaking coolant hose that saturated the induction air filter and one electronic ignition system with coolant. Unsuitable terrain for a forced landing was a related factor in the accident.Oct 29, 1996 · N711KN · Substantial damageNTSB LAX97FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Indio Hills, CAthe pilot's spatial disorientation which led to a loss of aircraft control, and exceeding the aircraft's structural design limits after the aircraft had entered a descending spiral. The pilot's lack of instrument flight currency and the dark night were…Oct 28, 1996 · N2157P · DestroyedNTSB ATL97LA010Accident · 2 fatalLimited investigationFinal reportLindberg Kitfox IV · Merritt Island, FLA loss of engine power for undetermined reasons and the failure of the pilots to maintain airspeed.Oct 27, 1996 · N11LG · DestroyedNTSB ATL97LA009Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Amelia Island, FLinadequate maintenance/inspection, which resulted in a failure to detect and correct moisture contamination of the left magneto; and/or improper adjustment of the engine fuel pump output, which resulted in excessive fuel pressure.Oct 25, 1996 · N32DG · Substantial damageNTSB FTW97LA028Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Giddings, TXThe loss of engine power as result of an oil leak due to a pinched 'O' ring in the oil filter. Factors were the improper installation of the oil filter, and the lack of suitable terrain for the forced landing.Oct 24, 1996 · N185XX · Substantial damageNTSB CHI97LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mancelona, MIthe worn fuel system pump (actuator arm). A factor was the unsuitable terrain encountered by the pilot.Oct 20, 1996 · N56155 · Substantial damageNTSB SEA97LA015Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Casper, WYloss of power for undetermined reason(s). A factor relating to the accident was: the pilot was operating outside height/velocity curve parameters, when the loss of power occurred.Oct 16, 1996 · N2762G · Substantial damageNTSB LAX97LA019Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Phoenix, AZfailure of the main landing gear to fully engage in the down-and-locked position for undetermined reason(s). Loss of hydraulic pressure to the main gear for undetermined reasons(s) was a related factor.Oct 15, 1996 · N15VZ · Substantial damageNTSB LAX97LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Kingsburg, CAthe student pilot's use of an excessively lean mixture, which led to engine overheating, detonation, subsequent failure of the number 2 piston, and a forced landing.Oct 15, 1996 · N6187K · DestroyedNTSB IAD97LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Germantown, KYimproper maintenance with the installation of an improper oil ring on the number four piston, which led to failure of both the ring and pistion, oil starvation, and subsequent loss of engine power.Oct 13, 1996 · N8299U · Substantial damageNTSB ANC97FA001Accident · 3 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKcontinued flight by the pilot into adverse weather condition, and his failure to maintain adequate altitude/clearance from mountainous terrain. Factors related to the accident were the high/mountainous terrain, and weather conditions that included low…Oct 13, 1996 · N64276 · DestroyedNTSB LAX97LA015Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Agua Dulce, CAinadequate compliance with the applicable airworthiness directive by other maintenance personnel, and the pilot's inadequate preflight inspection which resulted in fuel exhaustion from a deteriorated fuel cap seal.Oct 12, 1996 · N4924D · Substantial damageNTSB CHI97LA009Accident · No injuriesLimited investigationFinal reportHayes Lancair 235 · Kansas City, MOa stuck carburetor float valve which resulted in excessive fuel flow and ultimately fuel exhaustion. A factor related to the accident was the rough terrain on which the forced landing was made.Oct 12, 1996 · N90WH · Substantial damageNTSB LAX97LA001Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Truckee, CAa total loss of engine power for undetermined nonmechanical reasons.Oct 11, 1996 · N9403X · Substantial damageNTSB SEA97LA010Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Prosser, WAfailure of the pilot to maintain clearance from the terrain, while en route to an apple orchard that he intended to spray. A factor relating to the accident was: the turbulent wind condition over the hills.Oct 10, 1996 · N2331Y · Substantial damageNTSB IAD97LA005Accident · No injuriesLimited investigationFinal reportCessna T210M · Mentor, KYthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. Factors relating to the accident were: the inaccurate fuel quantity gage, and the light condition at dusk.Oct 10, 1996 · N6163N · Substantial damage