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 MIA03IA157Incident · No injuriesIncident investigationFinal reportCessna 402C · Arecibo, PRThe pilot’s inadequate in-flight decision, and his failure to refuel, which led to fuel exhaustion and subsequent loss of engine power.Aug 5, 2003 · N371R · No damageNTSB DEN03FA138Accident · 1 fatalField investigationFinal reportWright Hughes 1-B · Yellowstone Nat, WYThe in-flight loss of a propeller counterweight, followed by the pilot's loss of aircraft control during a forced landing attempt and subsequent inadvertent stall/spin to the ground.Aug 5, 2003 · N258Y · DestroyedNTSB CHI03FA246Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Clarkfield, MNThe pilot not maintaining altitude/clearance from terrain and his continued VFR flight into IMC during cruise flight. A factor was the low ceilings.Aug 5, 2003 · N4577T · DestroyedNTSB MIA03LA155Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Charlotte, NCThe pilot-in-command's failure to sufficiently deviate to avoid known weather, and his failure to activate the seatbelt sign to ensure flight attendants and passengers were seated, which resulted in a passenger receiving serious injuries when the flight…Aug 4, 2003 · N7527A · No damageNTSB CHI03LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Lakewood, WIA loss of engine power due to fuel starvation as a result of the pilot's improper use of the fuel system. A related factor was the tree.Aug 4, 2003 · N3575T · Substantial damageNTSB MIA03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Jupiter, FLThe pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.Aug 2, 2003 · N876RD · Substantial damageNTSB FTW03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Alpine, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.Aug 2, 2003 · N251BC · Substantial damageNTSB CHI03LA245Accident · No injuriesLimited investigationFinal reportCessna 150L · Pine Bluff, ARInadequate preflight planning which resulted in fuel exhaustion during the cross country flight. A factor associated with the accident was the rough terrain encountered during the forced landing.Aug 2, 2003 · N6791G · Substantial damageNTSB CHI03LA242Accident · 1 fatalLimited investigationFinal reportTeratorn · Elbow Lake, MNThe pilot's intentional flight into known fog and failure to maintain aircraft control during cruise flight. A factor was the fog, and the low altitude flight.Aug 2, 2003 · UNREG · DestroyedNTSB ANC03LA085Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Anchorage, AKThe pilot's incorrect positioning of the fuel tank selector valve to a nearly empty tank, which resulted in a loss of engine power due to fuel starvation, and subsequent emergency landing at an off-airport site. Factors associated with the accident were the…Aug 1, 2003 · N29CF · Substantial damageNTSB NYC03LA171Accident · 1 fatalLimited investigationFinal reportStewart Hummel Bird · North Baltimore, OHThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall during an emergency landing.Jul 31, 2003 · N7075Y · Substantial damageNTSB LAX03IA252Incident · No injuriesIncident investigationFinal reportBell 222 · Salinas, CAThe fatigue failure (fracture) of the right forward transmission lift link during cruise flight, which resulted in a severe vibration and an emergency landing.Jul 30, 2003 · N29KH · No damageNTSB SEA03LA157Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-24E · Hood River, ORThe pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.Jul 28, 2003 · N24YB · Substantial damageNTSB CHI03LA226Accident · No injuriesLimited investigationFinal reportCessna 177 · Murdock, NEThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident were the trees and unsuitable terrain.Jul 27, 2003 · N2336Y · Substantial damageNTSB SEA03GA153Accident · 1 fatalFinal reportKaman K-1200 · Keller, WACorrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…Jul 26, 2003 · N314KA · DestroyedNTSB NYC03LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Rhinebeck, NYA loss of engine power due to a failure of the number eight cylinder.Jul 26, 2003 · N23820 · Substantial damageNTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.Jul 26, 2003 · N727FT · Substantial damageNTSB MIA03LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Plantation, FLThe pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.Jul 25, 2003 · N72AB · Substantial damageNTSB LAX03LA243Accident · No injuriesLimited investigationFinal reportBeech V35B · Livermore, CAThe pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power during cruise flight.Jul 24, 2003 · N386TC · Substantial damageNTSB LAX03LA242Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane · Winnemucca, NVThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during cruise flight, and subsequent in-flight collision with terrain. A factor associated with the accident is the night light conditions.Jul 24, 2003 · N721SC · Substantial damageNTSB SEA03FA147Accident · No injuriesField investigationFinal reportCessna Citation 525 · Coupeville, WAThe loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…Jul 22, 2003 · N996JR · Substantial damageNTSB NYC03CA169Accident · Serious injuriesData collectionFinal reportBoeing 757-251 · Wadsworth, OHAn in-flight encounter with turbulence.Jul 22, 2003 · N504US · No damageNTSB SEA03LA146Accident · No injuriesLimited investigationFinal reportCessna 182S · Henry's Lake, IDA set of inadequately torqued vacuum pump retaining nuts, leading to the failure of the vacuum pump gasket, resulting in oil exhaustion, which resulted in a loss of engine power during cruise. A ditch and rough uneven terrain were factors.Jul 21, 2003 · N146NE · Substantial damageNTSB IAD03LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Hampton Bays, NYA loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jul 21, 2003 · N155RR · DestroyedNTSB CHI03FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Jackson, MNThe pilot's intentional flight into terrain as an act of suicide.Jul 21, 2003 · N33774 · DestroyedNTSB MIA03LA143Accident · No injuriesLimited investigationFinal reportCessna 172P · Plymouth, FLThe pilot's continue operation with known deficiencies (engine vibration) resulting in a partial loss of engine power during climb after takeoff and overrun of the runway during the aborted takeoff.Jul 20, 2003 · N52186 · Substantial damageNTSB CHI03LA217Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Waverly, IAThe main rotor blade push-pull rods being corroded, sustaining fatigue, and separating in cruise and the main rotor blade contacting the tail boom during the emergency landing. Factors were the diminished aircraft control and the vibrations encountered during…Jul 20, 2003 · N51699 · Substantial damageNTSB LAX03LA217Accident · Minor injuriesLimited investigationFinal reportRans S-10 Sakota/A · Paulden, AZa loss of engine power due to fuel starvation for undetermined reasons.Jul 19, 2003 · N222EJ · Substantial damageNTSB DEN03FA133Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Steamboat Sprng, COThe pilot's failure to maintain terrain clearance. Contributing factors include the pilot's inadequate preflight planning/preparation, high density altitude, and mountainous conditions.Jul 19, 2003 · N742BM · DestroyedNTSB ATL03LA118Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Hendersonville, NCThe pilot's inadequate preflight planning/preparation of fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion. A factor in the accident was pilot impairment due to alcohol consumption.Jul 19, 2003 · N411BT · Substantial damageNTSB SEA03LA164Accident · No injuriesLimited investigationFinal reportBeech A35 · Freeland, WAA partially blocked fuel injector which led to an over temperature condition in the cylinders resulting in a loss of engine power during cruise flight. Sandy terrain conditions for the landing was a factor.Jul 18, 2003 · N8598A · Substantial damageNTSB FTW03LA188Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Kerrville, TXThe loss of engine power due to the failure of the number three cylinder as the result of undertorqued cylinder bolts. A contributing factor was the lack of suitable terrain for the forced landing.Jul 18, 2003 · N353JT · Substantial damageNTSB LAX03LA235Accident · No injuriesLimited investigationFinal reportRobinson R44 · Happy Jack, AZthe partial loss of engine power due to an excessively lean mixture for undetermined reasons during cruise flight.Jul 17, 2003 · N8329B · Substantial damageNTSB CHI03LA237Accident · Serious injuriesLimited investigationFinal reportBoeing B777-222 · Chicago, ILThe turbulence encountered during the descent which seriously injured a passenger returning to her seat after the seat belt sign was activated. A factor was that it was not possible for the returning passenger to comply with the lit seat belt sign.Jul 17, 2003 · N779UA · No damageNTSB DEN03LA130Accident · No injuriesLimited investigationFinal reportAerostar RX-8 · Snowmass Villag, COthe failure of the pilot of balloon #2 to maintain clearance from balloon #1 while overtaking him.Jul 16, 2003 · N35965 · 2 aircraft · Substantial damageNTSB CHI03LA213Accident · 1 fatalLimited investigationFinal reportAllenberg Swick BC 12-D · Winsted, MNThe inadequate aircraft preflight by both pilots of the closed main fuel valve which led to fuel starvation of the engine. Additional causes were the lack of recent experience in the accident airplane and the inadvertent stall by both pilots after a loss of…Jul 16, 2003 · N7895A · DestroyedNTSB ANC03LA076Accident · 4 fatalLimited investigationFinal reportCessna 401 · Gustavus, AKThe pilot's inadequate in-flight decision making process, and failure to refuel the airplane prior to fuel exhaustion, which resulted in a total loss of engine power. A factor associated with the accident was the lack of a suitable forced landing site.Jul 14, 2003 · N6296Q · DestroyedNTSB NYC03CA156Accident · Minor injuriesData collectionFinal reportMooney M20C · Utica, OHThe pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A factor was the unsuitable terrain.Jul 13, 2003 · N33WL · Substantial damageNTSB MIA03FA141Accident · 2 fatalClass 1 · FieldFinal reportCessna 402C · Treasure Cay, Bahamasthe in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…Jul 13, 2003 · N314AB · Substantial damageNTSB IAD03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Burnet, TXThe pilot's failure to properly manage the airplane's fuel supply which led to the total loss of engine power, due to fuel starvation. A factor contributing to the accident was the presence of trees in the landing area used by the pilot to perform the…Jul 12, 2003 · N2463M · Substantial damageNTSB SEA03LA132Accident · Serious injuriesLimited investigationFinal reportHanks Avid Flyer · Toledo, WAThe pilot's failure to maintain aircraft control during a simulated emergency descent. Inadequate remedial action was a factor.Jul 10, 2003 · N3086G · Substantial damageNTSB ANC03LA073Accident · Minor injuriesLimited investigationFinal reportBell 206B · Aniak, AKThe compressor discharge pressure line (Pc line) B-nut coming loose at the fuel control unit, which resulted in a total loss of engine power, and subsequent in-flight collision with trees during an autorotation. A factor associated with the accident was the…Jul 10, 2003 · N111MT · Substantial damageNTSB NYC03LA155Accident · Serious injuriesLimited investigationFinal reportBeech BE-56TC · Bethany, WVA total loss of power in the right engine for undetermined reasons. A factor was a partial loss of power in the left engine due to a loose oil line.Jul 9, 2003 · N156DK · Substantial damageNTSB ANC03LA071Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Kotzebue, AKThe airplane encountered unforecast turbulence, which resulted in serious injury to the pilot.Jul 9, 2003 · N410GV · No damageNTSB SEA03LA129Accident · No injuriesLimited investigationFinal reportCessna 182J · Athol, IDThe failure of one of the number five connecting rod cap bolts during cruise flight due to the associated number five rod cap bolt nut being insufficiently torqued at the last major overhaul. Factors include a culvert alongside the road where the pilot found…Jul 5, 2003 · N3367F · Substantial damageNTSB NYC03FA148Accident · 2 fatalField investigationFinal reportBeech F-35 · Middlesboro, KYThe pilot's improper decision to descend into clouds, and his exceeding the maximum speed and design stress limits of the airplane, which resulted in an in-flight breakup and subsequent collision with terrain.Jul 5, 2003 · N205 · DestroyedNTSB LAX03LA225Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350BA · Temple Bar, AZthe pilot's failure to follow the published electrical system emergency procedures for a hot battery, and his misjudged landing flare during the terminal phase of the autorotation maneuver at low level.Jul 5, 2003 · N2273A · Substantial damageNTSB DEN03LA120Accident · Serious injuriesLimited investigationFinal reportConn Vans RV-4 · Durango, COpartial propeller blade separation for reasons undetermined, and the pilot's misjudgment of distance and altitude during the forced landing approach that resulted in his overshooting the road on intended landing and colliding with trees. A contributing factor…Jul 5, 2003 · N78DR · Substantial damageNTSB CHI03LA201Accident · 2 fatalLimited investigationFinal reportMcIlraith Sea Rey · Tomah, WIThe loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.Jul 5, 2003 · N216ST · DestroyedNTSB SEA03FA124Accident · 1 fatalField investigationFinal reportBeech A36TC · East Wenatchee, WALoss of engine power due to fuel starvation that resulted from the right wing tank reaching an unusable fuel level. Also causal was an unapproved alteration of the aircraft’s fuel system. Contributing to the accident were the incorrect installation of an…Jul 4, 2003 · N279WP · Substantial damage