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 CHI99LA020Accident · 1 fatalLimited investigationFinal reportBecker Wag Aero Super Sport · Hamilton, NDthe fatigue failure of the lower wing strut attachment bracket.Nov 3, 1998 · N285BB · DestroyedNTSB ANC99LA011Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Willow, AKA loss of engine power due to an undetermined reason. A factor associated with the accident was unsuitable terrain for a forced landing.Nov 3, 1998 · N5129Y · Substantial damageNTSB MIA99FA027Accident · 2 fatalField investigationFinal reportCessna C-182Q · Piedmont, ALThe pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.Nov 2, 1998 · N735JZ · DestroyedNTSB FTW99FA018Accident · 1 fatalField investigationFinal reportMorrisey Rutan Long EZE · Alvin, TXLoss of engine power for undetermined reasons.Nov 2, 1998 · N21EE · DestroyedNTSB DCA99MA007Accident · Minor injuriesMajor investigationFinal reportBoeing 737-200 · Atlanta, GA(1) the capping of the incorrect hydraulic line by mechanics, which led to the failure of hydraulic system A; (2) the mechanics' lack of experience working with the Boeing 737 hydraulic system; and (3) the maintenance controller's failure to ascertain more…Nov 1, 1998 · EICJW · Substantial damageNTSB LAX99FA020Accident · 3 fatalField investigationFinal reportCessna 182Q · Nixon, NVThe noninstrument rated pilot's failure to maintain control of the airplane during an attempted flight into adverse weather which resulted in inadvertent VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's failure to…Oct 29, 1998 · N95726 · DestroyedNTSB DEN99LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Tooele, UTThe pilot's VFR flight into IMC and his failure to maintain adequate terrain clearance. Contributng factors were fog, low ceilings, high terrain, the pilot's lack of familiarity with the geographic environment and his misinterpretation of terrain features on…Oct 29, 1998 · N3034B · DestroyedNTSB ATL99FA011Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Roswell, GAA loss of engine power due to the failure of the number five connecting rod assembly as a result of fatigue cracks that were initiated in areas of galling. A factor was the lack of suitable terrain for a forced landing.Oct 28, 1998 · N8554C · DestroyedNTSB MIA99LA017Accident · No injuriesLimited investigationFinal reportReinhold Revolution Mini 500 · Hickory, NCThe seizure of the rear piston in the cylinder barrel resulting in total loss of engine power and an autorotation which resulted in main rotor contact with the tail boom while touching down on unsuitable terrain.Oct 26, 1998 · N500GQ · Substantial damageNTSB ANC99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Noorvik, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were a dark night and low ceilings.Oct 26, 1998 · N9400M · Substantial damageNTSB LAX99LA015Accident · Minor injuriesLimited investigationFinal reportBeech 36 · Palmdale, CAThe pilot's improper management of his fuel supply which resulted in fuel starvation. Factors in the accident were the inadequate annual inspection which resulted in fuel siphoning, and a high reading fuel gage.Oct 25, 1998 · N36EL · Substantial damageNTSB LAX99LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Reno, NVThe pilot's disregard for five weather briefings and his attempted flight into known adverse weather conditions.Oct 24, 1998 · N2164T · DestroyedNTSB CHI99LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Clinton, IAthe failure of the 90 degree gearbox for reasons undetermined. Factors were the failure of the gearbox, and it not being possible for the pilot to maintain control of the aircraft.Oct 24, 1998 · N9739C · Substantial damageNTSB SEA99LA006Accident · No injuriesLimited investigationFinal reportCessna 172G · Vancouver, WARefueling was not preformed which subsequently led to fuel exhaustion. Factors include the student pilot's inadequate preflight planing/preparation.Oct 23, 1998 · N3765L · Substantial damageNTSB SEA99GA007Accident · 1 fatalFinal reportCessna 182P · Deming, WATerrain clearance was not maintained for undetermined reasons. Mountainous terrain was a factor.Oct 23, 1998 · N1324M · DestroyedNTSB CHI99LA010Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Duluth, MNThe inadequate airspeed by the pilot-in-command. Contributing factors were the gusts and the trees.Oct 22, 1998 · N95196 · Substantial damageNTSB LAX99IA013Incident · No injuriesIncident investigationFinal reportBoeing MD-11 · Honolulu, HIA jammed spoiler control pulley system caused by a shop rag left in an area of recent maintenance. Neither the maintenance organization nor the mechanic responsible could be determined.Oct 21, 1998 · N581FE · No damageNTSB DEN99LA015Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Englewood, COThe undertorquing of the camshaft gear retaining bolts during engine overhaul by maintenance personnel. A factor was the unsuitable terrain for a forced landing.Oct 21, 1998 · N6405U · Substantial damageNTSB DEN99LA014Accident · No injuriesLimited investigationFinal reportBeech B200 · Rio Rancho, NMThe pilot's inadequate preflight of the aircraft, resulting in fuel supply exhaustion.Oct 20, 1998 · N50PM · DestroyedNTSB FTW99LA014Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Farmerville, LAThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight. Factors were the pilot's failure to verify the refueling of the airplane and the lack of suitable terrain for the forced landing.Oct 19, 1998 · N4796N · Substantial damageNTSB DEN99FA012Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Buffalo, WYThe non-instrument rated pilot's initiated flight into adverse weather conditions and inadvertently flew into IMC weather conditions. Factors were the low ceiling weather conditions, the dark night light conditions, and a non operating VOR navigational aid.Oct 19, 1998 · N8537N · DestroyedNTSB MIA99LA007Accident · No injuriesLimited investigationFinal reportAyres S2R · Frisco City, ALThe pilot's failure to maintain airspeed on climb out resulting in an inadvertent stall, and subsequent in-flight collision with terrain.Oct 14, 1998 · N3093B · DestroyedNTSB IAD99LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Dunkirk, NYThe pilot's inadequate fuel management that resulted in fuel starvation. Factors in the accident were the improperly timed magneto and an engine driven fuel pump leak.Oct 14, 1998 · N8619N · Substantial damageNTSB IAD99FA005Accident · 1 fatalField investigationFinal reportCessna R172K · Bowie, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Also causal was the pilot's poor in-flight planning/decision, and his continued VFR flight into instrument meteorological conditions. A related factor was the fog.Oct 13, 1998 · N736KL · DestroyedNTSB DEN99LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Jackson Hole, WYThe pilot's inability to maintain adequate airspeed which resulted in an inadvertent stall/mush. Factors contributing to the accident were the unfavorable weather condition, mountain wave and the high density altitude.Oct 13, 1998 · N569C · DestroyedNTSB LAX99LA007Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Lost Hills, CAA loss of engine power due to fatigue failure of the number 4 cylinder articulating rod.Oct 10, 1998 · N1087D · Substantial damageNTSB FTW99FA001Accident · 1 fatalField investigationFinal reportBell 407 · Vermilion 331the failure of both pilots to see and avoid each other's aircraft during cruise flight. Factors were the failure of both pilots to use a known safety advisory recommendation and the failure of both operators to implement the recommendation as a company…Oct 5, 1998 · N403PH · 2 aircraft · DestroyedNTSB DEN99LA003Accident · Serious injuriesLimited investigationFinal reportCameron N-120 · Albuquerque, NMThe balloon's encounter with unforecasted wind shear and the subsequent inadvertent collision with terrain. A factor was the pilot's inability to control the balloon's descent.Oct 4, 1998 · N1607G · No damageNTSB IAD99LA002Accident · No injuriesLimited investigationFinal reportNavion A · Jaffrey, NHThe pilot's inadequate aircraft preflight and subsequent failure to refuel the aircraft resulting in fuel exhaustion. A factor was the lack of suitable terrain to execute a forced landing.Oct 3, 1998 · N4285K · Substantial damageNTSB FTW99LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Horizon City, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. Factors were the unfavorable wind condition and the lack of suitable terrain for the forced landing.Oct 3, 1998 · N8194W · Substantial damageNTSB LAX99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAContinued VFR flight by the pilot into instrument meteorological conditions (IMC) at night over mountainous terrain. The pilot's use of unclear language when stating his intentions to air traffic control was a factor.Oct 2, 1998 · N957AF · DestroyedNTSB FTW99LA003Accident · No injuriesLimited investigationFinal reportBeech M35 · Carter, OKFuel starvation. Factors were; the pilot's self induced pressure to fly the aircraft when maintenance had not been completed, poor judgement by the pilot to commence and continue flight with known deficiencies in the aircraft, and the lack of suitable terrain…Oct 2, 1998 · N9838R · Substantial damageNTSB LAX99FA001Accident · 1 fatalField investigationFinal reportAero Commander 680 FPL · Palm Springs, CAThe pilot's failure to properly use the manual turbocharger wastegates and to monitor the manifold pressure during takeoff.Oct 1, 1998 · N5YZ · DestroyedNTSB LAX98FA312Accident · 1 fatalField investigationFinal reportCessna 152 · Avalon, CAThe pilot's failure to maintain adequate altitude/clearance. Contributing to the accident were the hilly and mountainous terrain and glare from the setting sun.Oct 1, 1998 · N49770 · DestroyedNTSB SEA98LA192Accident · Minor injuriesLimited investigationFinal reportMayala Dragonfly · Avon, MTFailure of the engine crankshaft aft oil seal resulting in the loss of engine oil, and rough terrain during the forced landing.Sep 30, 1998 · N4478V · DestroyedNTSB MIA98LA254Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Oxford, MSThe pilot's failure to maintain directional control due to vibration from the main rotor blade for undetermined reasons. A related finding was the improper repair of a crack in the laminant of the blue main rotor blade by other maintenance personnel.Sep 29, 1998 · N755E · Substantial damageNTSB CHI98LA366Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Point Lookout, MOThe pilot's continued flight with a known deficiency in equipment. Contributing to the accident was the maintenance adjustment that was not completed by the mechanic.Sep 29, 1998 · N8946M · Substantial damageNTSB FTW98LA412Accident · No injuriesLimited investigationFinal reportCessna 152 · Durango, COImproper maintenance by an unknown person and the subsequent throttle cable disconnect due to a castellated nut separation. Factors were the none suitable soft terrain for the forced landing, and the failure of the nose wheel landing gear during the landing…Sep 27, 1998 · N4568F · Substantial damageNTSB LAX98LA309Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13H · Gilroy, CAThe pilot's loss of control for undetermined reasons.Sep 26, 1998 · N1001G · DestroyedNTSB LAX98FA306Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Hawthorne, NVThe pilot's disregard of the weather briefing information and his decision to attempt flight into forecast adverse weather conditions, which led to an encounter with icing conditions beyond the performance capability of the aircraft. The pilot's disregard for…Sep 26, 1998 · N554MB · DestroyedNTSB CHI98LA367Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-220T · Schofield, WIThe inadvertent deactivation of the fuel selector and the emergency procedure not followed by the pilot-in-command. The tree was a contributing factor.Sep 26, 1998 · N900JH · Substantial damageNTSB FTW98LA410Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mart, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Sep 25, 1998 · N983X · Substantial damageNTSB LAX98FA297Accident · 2 fatalField investigationFinal reportBeech 35-B33 · San Jose, CAthe pilot's loss of aircraft control and entry into a spiral dive for undetermined reasons. The dark night lighting conditions and the pilot's probable low recent flight experience were factors in this accident.Sep 19, 1998 · N486W · DestroyedNTSB FTW98FA392Accident · Serious injuriesField investigationFinal reportPiper PA-20-180 · Thornton, COThe separation of a propeller blade due to corrosion initiated fatigue, followed by the separation of several of the engine's mounts, and the subsequent inability of the pilot to control the aircraft. A contributing factor was the trees.Sep 19, 1998 · N6028D · DestroyedNTSB CHI98FA353Accident · 1 fatalField investigationFinal reportBarklage Revolution Mini 500 · Cahokia, ILA loss of engine power due to cold seizure of the power-takeoff cylinder. A factor contributing to the accident was the power lines.Sep 19, 1998 · N611AB · DestroyedNTSB FTW98LA404Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Duck Creek, UTLoose intake valve rocker arm studs that allowed a loss of compression and a loss of oil. A factor was unsuitable terrain on which to make a forced landing and poles next to a cattle guard.Sep 18, 1998 · N8252S · Substantial damageNTSB ATL98GA127Accident · 1 fatalFinal reportGovernment Aircraft Fact N22S · Caribbean SeaThe failure of the pilot-in-command of the other aircraft (N6305U) to maintain physical clearance from N6302W. Contributing factors were the inadequate visual lookout of all four pilots involved.Sep 18, 1998 · N6305U · 2 aircraft · DestroyedNTSB SEA98LA181Accident · Serious injuriesLimited investigationFinal reportKelly Kolb Mark III · Cashmere, WAFuel starvation caused by the partial blockage of the fuel pump chambers as a result of the misalignment of the fuel pump front cover by the pilot/builder. Factors include trees in the area in which the pilot attempted the forced landing.Sep 17, 1998 · N62691 · Substantial damageNTSB CHI98FA349Accident · 3 fatalField investigationFinal reportBeech 58 · Oakdale, WIThe installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.Sep 16, 1998 · N4574Q · DestroyedNTSB SEA98LA177Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Spray, ORA partial loss of engine power, and the pilot's subsequent misjudgment of clearance with a transmission wire during a precautionary landing approach. The reason for the power loss was not determined; however, the pilot reported that it was not of a mechanical…Sep 14, 1998 · N8666K · Substantial damage