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 DEN02LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COA loss of engine power due to fuel exhaustion as a result of leaking fuel caps. Contributing to the accident was the lack of suitable terrain for a forced landing.Jul 26, 2002 · N6887F · Substantial damageNTSB NYC02LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B · Newfield, NYThe pilot's failure to verify the amount of fuel onboard prior to departure, which resulted in a power loss due to fuel exhaustion, and subsequent hard landing. A factor was the lack of a suitable landing area under the helicopter when the power loss occurred.Jul 25, 2002 · C-GMLS · Substantial damageNTSB FTW02LA217Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Eugene Is 192The loss of tail rotor control due to an in-flight collision with an object.Jul 25, 2002 · N3174Y · Substantial damageNTSB CHI02LA212Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Central City, NEThe pilot was not able to maintain clearance with the trees when the airplane encountered a downdraft at a low altitude. An additional cause was the pilot's inadequate evaluation of the approaching weather conditions. Factors associated with the accident were…Jul 25, 2002 · N5296 · Substantial damageNTSB CHI02FA215Accident · 1 fatalField investigationFinal reportPiper PA-30 · Marble Hill, MOThe solid fuel system contamination resulting in a loss of engine power. The inadequate emergency procedures, and the airspeed not maintained by the pilot were additional causes.Jul 25, 2002 · N8563Y · DestroyedNTSB SEA02LA137Accident · No injuriesLimited investigationFinal reportBell 206B · Elsie, ORThe shattering and separation of the forward right (pilot's) windscreen for undetermined reason(s).Jul 24, 2002 · N60PH · Substantial damageNTSB MIA02LA139Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · Santa Rosa Bch, FLThe separation of the canopy for undetermined reasons.Jul 24, 2002 · N1535G · Substantial damageNTSB CHI02LA213Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Malta, ILThe inflight fire and loss of engine power due to undetermined reasons. Factors associated with the accident were the lack of suitable terrain on which to land and the corn crop which was contacted during the landing.Jul 24, 2002 · N1296W · Substantial damageNTSB SEA02LA135Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Medford, ORPower loss during cruise flight for undetermined reasons. Factors include mountainous terrain and trees.Jul 22, 2002 · N58295 · Substantial damageNTSB SEA02LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Pe Ell, WAThe fatigue failure of the number two engine cylinder for undetermined reasons during cruise flight. Factors include high vegetation in the area where the pilot found it necessary to make a forced landing.Jul 20, 2002 · N51286 · Substantial damageNTSB CHI02LA195Accident · No injuriesLimited investigationFinal reportMeyers OTW-145 · Waupun, WIA loss of engine power due to fuel exhaustion as a result of the fuel pump failure. Contributing to the accident was the wheat field.Jul 20, 2002 · N34321 · Substantial damageNTSB CHI02FA234Accident · No injuriesField investigationFinal reportPiper PA-28-180 · Macomb, MIThe cracked vertical stabilizer and the unapproved maintenance modification to the rudder by company maintenance personnel.Jul 20, 2002 · N16319 · Substantial damageNTSB ATL02LA144Accident · 5 fatalLimited investigationFinal reportPiper PA-32RT-300 · Atlantic Ocean, BahamasThe pilot continued VFR flight into IMC and thunderstorm conditions which resulted in spatial disorientation and subsequent loss of control of the airplane.Jul 20, 2002 · N9738C · DestroyedNTSB NYC02FA142Accident · 2 fatalField investigationFinal reportBeech C24R · Grindstone, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.Jul 18, 2002 · N18860 · DestroyedNTSB FTW02LA216Accident · No injuriesLimited investigationFinal reportBell TH-13T · New Iberia, LAThe loss of engine power for undetermined reasons. High vegetation was a factor.Jul 18, 2002 · N99628 · Substantial damageNTSB CHI02FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lee's Summit, MOThe inadequate preflight planning/preparation, the flight into instrument meteorological conditions, and lack of instrument certification by the pilot. Contributing factors were fog/clouds and the pilot's nondisclosure of his physical condition to the Federal…Jul 18, 2002 · N5164L · DestroyedNTSB ANC02LA080Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Cordova, AKThe pilot's selection of an unsuitable runway for takeoff, which precipitated an in-flight loss of control and subsequent collision with terrain.Jul 18, 2002 · N45796 · Substantial damageNTSB MIA02LA136Accident · No injuriesLimited investigationFinal reportYakovlev Yak 52 · Parrish, FLThe in-flight failure of a carburetor/fuel line fitting, resulting in loss of engine power, a forced landing to unsuitable terrain, and a ground collision with a farm vehicle during the emergency landing.Jul 17, 2002 · N2183F · Substantial damageNTSB ATL02FA143Accident · 2 fatalField investigationFinal reportCessna 150G · Duncanville, ALThe pilot's failure to maintain airspeed , which resulted in an inadvertent stall, and subsequent collision with the ground. A contributing factor was low level flight.Jul 17, 2002 · N3400J · DestroyedNTSB SEA02LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Burns, ORThe pilot’s improper decision to continue on en route into an area of forecast reduced visibility without sufficient fuel to divert to a suitable alternate airport, and his subsequent inadvertent exhaustion of the aircraft's fuel supply. Factors include…Jul 16, 2002 · N1248H · Substantial damageNTSB LAX02LA228Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Concord, CAThe main rotor mast support tube failure as a result of fatigue.Jul 15, 2002 · N20256 · Substantial damageNTSB SEA02LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kittitas, WAThe pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.Jul 14, 2002 · N9542S · Substantial damageNTSB FTW02LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Purcell, OKThe in-flight cabin fire as result of non-compliance with an AD and a Service Bulletin. A contributing factor to the accident was night conditions.Jul 14, 2002 · N96PF · DestroyedNTSB DEN02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tooele, UTthe pilot-in-command failure to obtain/maintain proper rate of climb, resulting in a collision with terrain. Contributing factors were the high density altitude and exceeding the airplane's forward center of gravity limit.Jul 14, 2002 · N4690R · Substantial damageNTSB ATL02LA139Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Weaverville, NCThe pilot's inadequate preflight and in-flight planning of fuel to complete the flight that resulted in the exhaustion of the fuel supply.Jul 14, 2002 · N27626 · Substantial damageNTSB NYC02LA139Accident · No injuriesLimited investigationFinal reportMicket Avid Aerobat · Chesapeake, VAA total loss of engine power due to a seized cylinder, and the pilot's improper decision to conduct the flight with a known deficiency to the engine.Jul 13, 2002 · N11BV · Substantial damageNTSB DEN02LA075Accident · Serious injuriesLimited investigationFinal reportAmerican General AA5B · Worland, WYthe pilot's selection of an inadequate altitude for crossing mountainous terrain, resulting in a collision with trees. A contributing factor was the downdraft.Jul 13, 2002 · N28717 · DestroyedNTSB SEA02LA130Accident · No injuriesLimited investigationFinal reportThurmond Moni · Laurel, MTUndertorqued mounting bolts which resulted in fatigue to the wooden propeller blade and subsequent in flight separation of one of the blades while in cruise flight. An improper installation of the propeller assembly and soft terrain encountered during the…Jul 12, 2002 · N9104S · Substantial damageNTSB MIA02FA131Accident · 2 fatalField investigationFinal reportAmerican General AA-5 · Boca Raton, FLThe owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.Jul 12, 2002 · N6024L · Minor damageNTSB SEA02LA126Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Deer Park, WALoss of control for undetermined reasons.Jul 10, 2002 · UNREG · Substantial damageNTSB CHI02LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Gregory, MIAn improper decision by the pilot due to a failure to land at an intermediate airport, and the unsuitable terrain for a forced landing encountered. Contributing factors were the pilot's disorientation (becoming lost), fuel exhaustion, soft terrain encountered…Jul 10, 2002 · N621AF · Substantial damageNTSB CHI02LA186Accident · No injuriesLimited investigationFinal reportCessna 175 · Kaiser/Lake Oza, MOThe pilot's decision to conduct the flight with a known deficiency in the aircraft, a failure by the pilot to execute a precautionary landing due to "sluggish" performance during takeoff, the loss of engine power due to the malfunction of the left magneto,…Jul 9, 2002 · N175HL · Substantial damageNTSB NYC02LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3-C65 · Andover, NJThe flight instructor's delayed remedial action, and the private pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin.Jul 7, 2002 · N9264 · Substantial damageNTSB LAX02LA218Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Compton, CAthe failure and separation of a fan belt for the engine cooling system. A factor in the accident was the inadequate annual inspection 14 hours prior to the accident.Jul 7, 2002 · N2483B · Substantial damageNTSB SEA02FA125Accident · 2 fatalField investigationFinal reportCessna 172N · Otis, ORThe pilot's failure to maintain adequate clearance with power lines while conducting low altitude flight resulting in a loss of control and subsequent collision with terrain. Contributing factors were the pilot's low altitude flight and the power lines.Jul 6, 2002 · N738QT · DestroyedNTSB NYC02LA132Accident · No injuriesLimited investigationFinal reportBeech C23 · Newburyport, MAA power loss for undetermined reason(s), which resulted in a subsequent forced landing to unsuitable terrain. A factor was the unsuitable terrain.Jul 6, 2002 · N823DA · Substantial damageNTSB LAX02LA220Accident · No injuriesLimited investigationFinal reportBushby Mustang M-11 · Pahrump, NVthe failure and separation of a propeller blade for undetermined reasons.Jul 5, 2002 · N30430 · Substantial damageNTSB SEA02FA119Accident · 2 fatalField investigationFinal reportCessna 335 · Tensed, IDAircraft control was not maintained during an emergency landing. A loss of power for undetermined reasons was a factor.Jul 4, 2002 · N27069 · Substantial damageNTSB NYC02LA130Accident · Serious injuriesLimited investigationFinal reportWheeler Volksplane VP-2 · Collins, NYThe separation of an ignition lead to the distributor cap, which resulted in a total loss of engine power. Factors in the accident were trees and power lines.Jul 4, 2002 · N21267 · Substantial damageNTSB NYC02LA129Accident · 1 fatalLimited investigationFinal reportPank KitFox · Sprakers, NYThe pilot's failure to maintain aircraft control. A factor in the accident was the pilot's lack of experience in category of aircraft.Jul 3, 2002 · UNREG · Substantial damageNTSB MIA02LA126Accident · No injuriesLimited investigationFinal reportRockwell International 112TC · Atlantic Ocean (Atlantic Ocean)The pilot's improper planning/decision and insufficient refueling which resulted in the loss of engine power due to fuel exhaustion and the aircraft being ditched in the ocean.Jul 3, 2002 · N4561W · DestroyedNTSB SEA02LA117Accident · No injuriesLimited investigationFinal reportCessna 172 E · Battle Ground, WAImproper maintenance procedures by maintenance personnel, which resulted in an engine oil leak while in flight. A factor was the pilot's misjudgment of distance during the precautionary landing which led to a runway overrun.Jul 2, 2002 · N37065 · Substantial damageNTSB MIA02LA124Accident · No injuriesLimited investigationFinal reportMckean Varieze · Covington, TNThe pilot's improper planned approach following loss of engine power due to fuel starvation resulting in damage to the airplane during an off-airport landing. Contributing to the accident was the pilot's lack of familiarity with the accident airplane.Jul 2, 2002 · N57EZ · Substantial damageNTSB MIA02LA123Accident · Serious injuriesLimited investigationFinal reportCessna CE-182-A · Siler City, NCThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.Jul 2, 2002 · N9996B · Substantial damageNTSB FTW02FA195Accident · 1 fatalField investigationFinal reportBeech H-18 · Tatum, NMThe failure of the pilot to maintain clearance.Jul 1, 2002 · N835K · DestroyedNTSB LAX02FA210Accident · 1 fatalField investigationFinal reportBeech C35 · Chambers, AZThe pilot's loss of airplane control after falling asleep due to fatigue, which resulted in a structural failure of the airframe during a high speed descent after the design stress limits of the aircraft were exceeded.Jun 30, 2002 · N5856C · DestroyedNTSB FTW02FA192Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Gorman, TXThe pilot's loss of control and the exceedence of the design limits of the airplane which resulted in an in-flight break-up. A factor was inadvertent VFR flight into IMC.Jun 30, 2002 · N8681P · DestroyedNTSB CHI02LA179Accident · No injuriesLimited investigationFinal reportWaltz RV-8 · Omaha, NEA loss of engine power due to a loose connecting rod cap bolt and the resulting fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain.Jun 30, 2002 · N877TC · Substantial damageNTSB DEN02LA066Accident · No injuriesLimited investigationFinal reportCessna 172M · Hite, UTthe pilot's improper in-flight planning resulting in fuel exhaustion. A factor relating to the accident was the unsuitable terrain encountered during the forced landing attempt.Jun 29, 2002 · N725EC · Substantial damageNTSB FTW02LA197Accident · No injuriesLimited investigationFinal reportRobinson R44 · Houston, TXThe pilot's loss of control after encountering dynamic rollover during takeoff. A contributing factor was the pilot's inadequate preflight inspection.Jun 28, 2002 · N144WT · Substantial damage