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 FTW97FA014Accident · 1 fatalField investigationFinal reportMbb BO-105 CBS-4 · Cameron, LAthe pilot's failure to maintain clearance with terrain for undetermined reasons. Contributing factors were the dark night and pilot fatigue.Oct 10, 1996 · N299EH · DestroyedNTSB FTW97LA013Accident · No injuriesLimited investigationFinal reportDickson RV-3A · Rosharon, TXThe pilot's failure to follow procedures and directives in that he did not use carburetor heat and he did not periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the transmission wire.Oct 9, 1996 · N3920P · DestroyedNTSB CHI97LA006Accident · Minor injuriesLimited investigationFinal reportCallair B1A · Nebraska City, NEa supercharger bearing failure. A factor was the excessive sink rate during the forced landing.Oct 9, 1996 · N6203X · Substantial damageNTSB SEA97FA006Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Cle Elum, WAThe pilot's physical impairment of judgment and performance, his decision to fly while impaired, and his subsequent failure to maintain control of the aircraft which led to the aircraft's design stress limits being exceeded and inflight separation of the…Oct 8, 1996 · N666HL · Substantial damageNTSB NYC97FA004Accident · 2 fatalField investigationFinal reportBeech F33A · Doylesburg, PAcontinued VFR flight by the pilot into instrument meteorological conditions, and his failure to maintain altitude and/or clearance from high terrain. Factors relating to the accident were: darkness, low ceiling, fog, and high (mountainous) terrain along the…Oct 8, 1996 · N2154L · DestroyedNTSB LAX97LA011Accident · Serious injuriesLimited investigationFinal reportRichards Lancair IVP · Camarillo, CAThe loss of engine power for undetermined reasons.Oct 8, 1996 · N477RM · DestroyedNTSB LAX97LA007Accident · No injuriesLimited investigationFinal reportCessna 172C · Mesa, AZthe pilot's improper use (positioning) of the fuel selector, which resulted in fuel starvation and loss of engine power.Oct 7, 1996 · N1332Y · Substantial damageNTSB LAX97LA006Accident · No injuriesLimited investigationFinal reportBell 47G-5A · King City, CAthe pilot's failure to maintain adequate rotor rpm during the takeoff initial climb.Oct 7, 1996 · N8135J · Substantial damageNTSB FTW97LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gulf Of Mexicofuel exhaustion due to the pilot's inadequate in-flight fuel consumption calculations.Oct 7, 1996 · N5525L · Substantial damageNTSB FTW97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 175B · Mount Pleasant, TXThe total loss of engine power due to the #3 connecting rod separation resulting in engine seizure. Factors were the dark night and the lack of suitable terrain for the forced landing.Oct 7, 1996 · N8171T · Substantial damageNTSB SEA97LA004Accident · No injuriesLimited investigationFinal reportCrouch Avid Mark IV · Stanwood, WAfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of engine power. A factor relating to the accident was: the pilot's failure to attain the proper touchdown point on suitable terrain during the…Oct 6, 1996 · N518DC · Substantial damageNTSB IAD97LA002Accident · No injuriesLimited investigationFinal reportCessna 150H · Sunbury, PAfailure of the cluster gear attaching bolts (of which one failed from fatigue), resulting in a disconnect of the gear and loss of engine power. An obstruction (rock) in the emergency landing area was a related factor.Oct 5, 1996 · N6741S · Substantial damageNTSB FTW97LA007Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 Saeta · Elk City, OKThe loss of aircraft control due to a fuel imbalance as a result of a partial failure of the fuel jettison system. A factor was that fuel could not be transferred from the left wing tip fuel tank to the rear fuselage fuel tank.Oct 5, 1996 · N3179K · Substantial damageNTSB SEA97LA002Accident · No injuriesLimited investigationFinal reportRockwell S2R · Glide, ORfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of power. Factors relating to the accident were: false indications of cockpit fuel gauges and unsuitable terrain for a forced landing.Oct 4, 1996 · N8957Q · Substantial damageNTSB SEA97FA001Accident · 3 fatalField investigationFinal reportBoeing Vertol BV-107 II · Canby, ORfailure of maintenance personnel to install a cotter pin in a clevis bolt in the flight control system, which resulted in the aft directional and lateral control output pushrod to become disconnected from a bellcrank in the forward portion of the first stage…Oct 4, 1996 · N196CH · DestroyedNTSB FTW97IA003Incident · No injuriesIncident investigationFinal reportBeech 1900D · Pueblo, COPartial incapacitation of the flightcrew for unknown reasons.Oct 4, 1996 · N154ZV · No damageNTSB LAX97LA008Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Kona, HIloss of engine power for undetermined reason(s).Oct 3, 1996 · N1365R · DestroyedNTSB LAX97LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Plymouth, CAfailure of the #3 exhaust valve, which resulted in loss of engine power, a forced landing, and subsequent collision with a fence post.Oct 3, 1996 · N5705U · Substantial damageNTSB NYC96LA189Accident · No injuriesLimited investigationFinal reportCessna 172K · Deal, NJthe pilot's improper decision/planning, which resulted in fuel exhaustion and a subsequent forced landing.Sep 28, 1996 · N84593 · Substantial damageNTSB CHI96FA353Accident · 4 fatalField investigationFinal reportCessna 195 · Greenville, MOthe pilot's decision to fly into known adverse weather which resulted in an overload failure and separation of the left wing.Sep 26, 1996 · N195WR · DestroyedNTSB SEA96LA223Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Paisley, ORTotal loss of engine power secondary to geartrain failure.Sep 25, 1996 · N8822W · Substantial damageNTSB IAD96LA154Accident · No injuriesLimited investigationFinal reportCessna 182 · Kansas, OHthe pilot's improper inflight planning/decision, which resulted in fuel exhaustion during cruise flight and subsequent loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.Sep 25, 1996 · N6336A · Substantial damageNTSB IAD96LA153Accident · No injuriesLimited investigationFinal reportCessna 188 · Pataskala, OHdeterioration and fuel leakage from an engine fuel hose (with a service life that had been exceed, due to inadequate maintenance), which resulted in an engine compartment fire and subsequent damage to the airplane.Sep 25, 1996 · N3619J · Substantial damageNTSB SEA96LA219Accident · Minor injuriesLimited investigationFinal reportKaman HH-43 B/F · Troy, MTfailure of the freewheeling sprag unit bearings for undetermined reasons.Sep 23, 1996 · N4069R · Substantial damageNTSB FTW96FA399Accident · 1 fatalField investigationFinal reportAyres S2R-T45 · Granger, TXthe pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…Sep 23, 1996 · N3107B · DestroyedNTSB FTW96LA396Accident · No injuriesLimited investigationFinal reportCoursey Prostar PT-2 · Rio Rancho, NMfatigue failure of the engine oil cooler coil, which resulted in an oil leak, oil starvation, loss of engine power, and a subsequent forced landing. Factors relating to the accident were: the proximity of a truck on the highway and soft terrain that was…Sep 22, 1996 · N822CF · Substantial damageNTSB CHI96LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Germantown Hill, ILthe pilot's inadequate fuel supply and his misjudging distance and altitude. The trees were a factor.Sep 22, 1996 · N904SW · Substantial damageNTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.Sep 22, 1996 · N66338 · Substantial damageNTSB CHI96FA348Accident · 1 fatalField investigationFinal reportCessna 172F · Saint Clair, MNa loss of power due to the engine's #2 cylinder exhaust valve stuck open, and the pilot's failure to maintain airspeed.Sep 22, 1996 · N5373R · DestroyedNTSB LAX96FA339Accident · 1 fatalField investigationFinal reportCessna T207A · Littlefield, AZThe pilot's failure to maintain clearance with terrain during descent for undetermined reasons. Contributing factors were the dark night and mountainous terrain.Sep 21, 1996 · N6468H · DestroyedNTSB IAD96LA150Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Templeton, MAthe student pilot's improper in-flight decision to continued the cross-country flight into night conditions, and his inability to find the destination (or an alternate airport) in a timely manner, which resulted in fuel exhaustion, forced landing, and…Sep 21, 1996 · N2607J · DestroyedNTSB IAD96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Richwood, WVimproper in-flight planning/decision by the flight crew, and inadequate supervision by the check pilot, which resulted in the flight crew's failure to maintain altitude/clearance from trees on rising terrain. A factor relating to the accident was:…Sep 21, 1996 · N848LF · Substantial damageNTSB FTW96LA397Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Lonestar, TXThe loss of engine power due to the pilot's improper fuel consumption calculations resulting in the fuel exhaustion. A factor was the unsuitable terrain for the forced landing.Sep 21, 1996 · N369PT · Substantial damageNTSB LAX96LA343Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Truckee, CAThe inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.Sep 20, 1996 · N840DC · 2 aircraft · Substantial damageNTSB ATL96LA131Accident · No injuriesLimited investigationFinal reportBeech A23 · Tarboro, NCfatigue failure of the propeller blade. Factors relating to the accident were: corrosion pit(s) on the propeller blade, and inadequate maintenance/inspection of the propeller.Sep 20, 1996 · N8879M · Substantial damageNTSB ATL96LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Georgetown, SCfailure of maintenance personnel to comply with an airworthiness directive, requiring periodic magneto inspections; inadequate annual inspection of the airplane by (other) maintenance personnel; and subsequent failure of the impulse coupling in the left…Sep 19, 1996 · N9VM · Substantial damageNTSB LAX96LA338Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAA separation of a connecting rod due to a lack of internal lubrication from a blocked oil passage after a bearing had shifted on its journal.Sep 18, 1996 · N94381 · Substantial damageNTSB FTW96LA391Accident · Serious injuriesLimited investigationFinal reportTubb AIR Commander 532 · Magnolia, ARThe loss of engine power due to the loss of coolant, as a result of a leak in the radiator. A factor was the lack of suitable terrain for the forced landing.Sep 18, 1996 · N7136C · Substantial damageNTSB FTW96IA389Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie AE 340-300 · San Antonio, TXturbulence, and failure of passengers to properly fasten their seat belts and properly hold lap children after the captain announced expected turbulence.Sep 18, 1996 · DAIGK · No damageNTSB ANC96LA157Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKthe pilot's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion. A factor associated with the accident was: the erroneous (false) indication of the fuel sight tubes.Sep 16, 1996 · N7658H · Substantial damageNTSB CHI96LA340Accident · No injuriesLimited investigationFinal reportCessna 150 · Wonder Lake, ILa blocked exhaust pipe as a result of an inadequate weld repair to the muffler.Sep 14, 1996 · N1381Q · Substantial damageNTSB FTW96LA386Accident · Minor injuriesLimited investigationFinal reportBell 206L-1/C-30P · Morgan City, LAThe loss of tail rotor control as result of a tail rotor blade strike by an undetermined object. A factor was the lack of suitable terrain for the forced landing.Sep 13, 1996 · N2654 · Substantial damageNTSB CHI96LA335Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Janesville, WIfuel exhaustion as a result of an inadequate preflight by the pilot in command.Sep 13, 1996 · N27299 · Substantial damageNTSB ANC96LA154Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cantwell, AKthe pilot's continued VFR flight into instrument meteorological conditions (IMC). The terrain conditions, low ceiling, fog, and whiteout conditions were related factors.Sep 13, 1996 · N7982J · DestroyedNTSB FTW96LA385Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Hamburg, ARThe loss of tail rotor control as result of a tail rotor blade strike by a partially disconnected ballast weight, due to a disconnected pin. A factor was the lack of suitable terrain for the forced landing.Sep 12, 1996 · N156HA · Substantial damageNTSB SEA96LA212Accident · 1 fatalLimited investigationFinal reportGrazier Quickie 2 · Superior, MTloss of engine power after takeoff for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering to return to the departure airport, which resulted in a stall and collision with wooded terrain.Sep 11, 1996 · N73QQ · Substantial damageNTSB FTW96LA384Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Sprngs, COThe improper installation of the propeller governor by company maintenance personnel, resulting in the total loss of oil and engine seizure. Factors were the pilot's misjudgment of altitude and airspeed, causing him to make a forced landing on unsuitable…Sep 11, 1996 · N2797V · Substantial damageNTSB NYC96LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Closter, NJThe pilot's improper fuel management, which resulted in a power loss due to fuel exhaustion, followed by the airplane striking a tree during a forced landing.Sep 9, 1996 · N1792T · Substantial damageNTSB CHI96LA331Accident · No injuriesLimited investigationFinal reportCessna 182 · Eden Prairie, MNthe pilot's misjudging the fuel supply and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.Sep 8, 1996 · N5401B · Substantial damageNTSB ANC96TA148Accident · No injuriesFinal reportPiper PA-18 · Elmendorf, AKloss of engine power due to fuel starvation, which resulted from improper positioning of the fuel tank selector; inadequate supervision by the flight instructor (CFI); and the flight crew's improper emergency procedure.Sep 8, 1996 · N4372A · Substantial damage