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 NYC01LA025Accident · No injuriesLimited investigationFinal reportCessna 172M · Camp Springs, MDThe pilot's improper in-flight decision to operate close behind a large airplane at the same altitude, which resulted in a wake turbulence encounter.Oct 19, 2000 · N950ME · Substantial damageNTSB MIA01FA006Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F2 · Burlington, NCThe mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…Oct 17, 2000 · N355DU · DestroyedNTSB CHI01MA011Accident · 3 fatalClass 1 · MajorFinal reportCessna 335 · Hillsboro, MOThe pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.Oct 17, 2000 · N8354N · DestroyedNTSB NYC01LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Southborough, MAA failed connecting rod assembly, with the initiating event undetermined.Oct 15, 2000 · N4381S · Substantial damageNTSB ATL01LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Homer, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.Oct 14, 2000 · N18130 · Substantial damageNTSB FTW01LA009Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30 · Waller, TXthe loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.Oct 12, 2000 · N4882V · Substantial damageNTSB CHI01LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, MIthe pilot's inaccurate preflight planning. Factors were the fuel exhaustion, the trees, and the bright night condition.Oct 12, 2000 · N732FL · Substantial damageNTSB DEN01FA003Accident · 1 fatalField investigationFinal reportCessna R-182 · Grants, NMthe pilot's continued VFR flight into IMC during cruise. Contributing factors were the dark night light conditions, and the cloudy weather conditions.Oct 11, 2000 · N182BG · DestroyedNTSB MIA01LA002Accident · No injuriesLimited investigationFinal reportHarwell/Gardner WAG-AERO Cubby · Stockbridge, GAThe pilot's failure to maintain a visual lookout during a forced landing resulting in an on-ground collision with a berm on landing roll out. Contributing to the accident was a reported loss of engine power for undetermined reasons.Oct 10, 2000 · N909GH · Substantial damageNTSB FTW01FA007Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Cotulla, TXThe pilot's failure to refuel the airplane which resulted in fuel exhaustion and subsequent loss of engine power. Also contributing to the accident was the pilot's failure to feather the engine.Oct 10, 2000 · N3390P · Substantial damageNTSB LAX01FA006Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369E · Kernville, CAThe pilot's improper storage of personal items and his inadequate preflight inspection, which resulted in the unlatching of the left rear cabin door during flight and allowing a plastic garment bag to blow out and strike the tail rotor.Oct 8, 2000 · N819CE · Substantial damageNTSB CHI01LA003Accident · No injuriesLimited investigationFinal reportCessna 182 · Noblesville, INCarburetor icing and the pilot's inadequate in-flight planning by his delayed use of carburetor heat. A factor associated with the accident was the unsuitable terrain.Oct 8, 2000 · N8907X · Substantial damageNTSB CHI01LA004Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Sparta, WIthe pilot's inaccurate fuel consumption calculations, improper fuel management, inadequate in-flight planning/decision, flight to destination alternate not performed, and the discontinued planned approach to the initially selected runway. Contributing factors…Oct 7, 2000 · N13214 · DestroyedNTSB ANC01LA003Accident · Minor injuriesLimited investigationFinal reportHelio H-295 · Port Alsworth, AKThe pilot's inadequate preflight inspection, which failed to remove all water from the fuel system. A factor associated with the accident was unsuitable terrain for a forced landing.Oct 6, 2000 · N295BA · Substantial damageNTSB NYC01LA003Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Haverford Twp., PAA loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.Oct 5, 2000 · N704ST · Substantial damageNTSB LAX01FA003Accident · 1 fatalField investigationFinal reportCessna 182S · Santa Rosa, CAthe pilot's loss of airplane control due to spatial disorientation. A related factor was the low ceiling.Oct 4, 2000 · N2373D · DestroyedNTSB FTW01LA005Accident · 2 fatalLimited investigationFinal reportHolt Thorpe T-18C · Imperial, TXthe failure of the propeller blade due to fatigue, which originated from a corrosion crack. A contributory factor was the pilot/owner's failure to ensure that the propeller was overhauled at the manufacturer's recommended interval.Oct 4, 2000 · N85LH · DestroyedNTSB CHI01LA002Accident · 1 fatalLimited investigationFinal reportMoseler RAF 2000 GTX SE · Muskegon, MIThe main rotor contacting with the vertical stabilizer, the loss of the vertical stabilizer, and the aircraft control not possible by the pilot.Oct 4, 2000 · N1187Z · DestroyedNTSB ATL01LA004Accident · No injuriesLimited investigationFinal reportJoseph A. Grimaud Seawind 3000 · Chapin, SCA total loss of engine power for undetermined reasons. A factor was the trees.Oct 3, 2000 · N98GG · Substantial damageNTSB NYC01LA002Accident · Serious injuriesLimited investigationFinal reportMaule M-5 · Leicester, MAThe pilot's failure to properly manage the fuel onboard the airplane, which resulted in fuel starvation, and a total loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while maneuvering for a field.Oct 2, 2000 · N5638D · Substantial damageNTSB LAX01FA001Accident · 4 fatalField investigationFinal reportBeech A36TC · San Juan Batist, CAthe pilot's in-flight decision to continue flight into instrument weather conditions at an altitude that did not maintain an adequate terrain clearance, which resulted in a collision with terrain. Factors were a dark night, clouds, fog, mountainous terrain,…Oct 2, 2000 · N36TV · DestroyedNTSB FTW01LA004Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Jasper, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions, which resulted in his failure to maintain control of the helicopter. Factors were the fog and the pilot's lack of instrument flight experience.Oct 2, 2000 · N321CA · Substantial damageNTSB LAX00FA354Accident · 1 fatalField investigationFinal reportPiper PA-38 · San Luis Obispo, CAThe pilot's failure to maintain clearance from terrain while turning to reverse course following inadvertent nighttime flight into instrument meteorological conditions. A factor in the accident was the pilot's lack of experience in nighttime operations.Oct 1, 2000 · N2493G · DestroyedNTSB ATL01IA001Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Birmingham, ALThe failure of maintenace personnel to follow fleet campaign directive on how to install a certificate holder.Oct 1, 2000 · N69826 · Minor damageNTSB FTW00LA272Accident · Serious injuriesLimited investigationFinal reportPorterfield LP65 · Corsicana, TXThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion. A factor was the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.Sep 30, 2000 · N25563 · Substantial damageNTSB CHI00LA311Accident · No injuriesLimited investigationFinal reportCessna 150H · Michigan City, INfuel contamination (water) and the pilot exceeding his landing field distance. Factors relating to this accident were the pilot inadequate preflight planning/preparation, his having to select an unsuitable landing area, the short landing area, and the marsh.Sep 30, 2000 · N50318 · Substantial damageNTSB ATL00LA094Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Homosassa, FLThe pilot's inadvertent flight into instrument meteorological conditions and subsequently exhausting his fuel supply. Factors were his failure to obtain a weather briefing, the weather conditions which included clouds and obscuration, the residence and the…Sep 30, 2000 · N2234K · Substantial damageNTSB SEA00LA194Accident · No injuriesLimited investigationFinal reportCessna 172K · Burns, ORThe separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.Sep 28, 2000 · N84034 · Substantial damageNTSB IAD00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Owingsville, KYA loss of engine power due to water contamination of the fuel. Also causal in the accident was the pilot/owner's failure to repair the inoperative fuel cap.Sep 27, 2000 · N94326 · Substantial damageNTSB MIA00LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 777-223 · Miami, FLan in-flight encounter with turbulence.Sep 26, 2000 · N789AN · No damageNTSB SEA00LA185Accident · Serious injuriesLimited investigationFinal reportRowe Pietenpol · Raymond, WAThe pilot's failure to maintain an airspeed above power-off stall speed (Vso) while attempting a forced landing after a total loss of engine power, and his failure to move the fuel selector switch to the 'ON' position prior to takeoff. Factors include the…Sep 23, 2000 · N5079R · Substantial damageNTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.Sep 23, 2000 · N3483A · Substantial damageNTSB DEN00LA176Accident · No injuriesLimited investigationFinal reportBell 206B · Rawlins, WYThe company dispatching, and the pilot initiating, flight into known adverse weather with an aircraft which did not have the required anti-ice equipment installed. A factor was snow conditions.Sep 22, 2000 · N32FR · Substantial damageNTSB SEA00TA182Accident · No injuriesFinal reportBell 206-L4 · Atlanta, IDThe pilot's failure to maintain clearance from an object. Trees and inadequate ground communications were a factor.Sep 21, 2000 · N3310 · Substantial damageNTSB MIA00LA267Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GAan in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.Sep 20, 2000 · N172DZ · No damageNTSB ANC00FA128Accident · 1 fatalField investigationFinal reportCessna 207 · Aniak, AKThe pilot's decision to initiate visual flight into dark night instrument meteorological conditions. Factors associated with the accident are a low ceiling, a dark night, the pilot's failure to follow regulatory procedures and directives, and his self-induced…Sep 20, 2000 · N42472 · DestroyedNTSB LAX00FA342Accident · Minor injuriesField investigationFinal reportSikorsky/Orlando S-55 · Hoover Dam, AZ**This report was modified on 2/23/2016. Please refer to the public docket for this accident for more information.** The failure of Papillon maintenance personnel to recognize the significance of the increasing metal in the oil analysis test results and the…Sep 18, 2000 · N17754 · Substantial damageNTSB FTW00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blanchard, LAThe student pilot's failure to refuel, which resulted in fuel exhaustion. Factors were the dark night light conditions and lack of suitable terrain for the forced landing.Sep 18, 2000 · N6107Q · Substantial damageNTSB LAX00LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Prescott, AZAn improper engine installation by other maintenance personnel that resulted in a fuel leak at the main fuel line fitting to the carburetor and subsequent fuel exhaustion during cruise flight.Sep 17, 2000 · N6303C · Substantial damageNTSB ATL00LA092Accident · Serious injuriesLimited investigationFinal reportBombardier CRJ · Atlanta, GAThe inadvertent flight into turbulent weather conditions.Sep 17, 2000 · N853AS · No damageNTSB DEN00LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sheridan, WYThe pilot's improper inflight decision to enter a canyon at an altitude insufficient to clear rising terrain. A factor was the aircraft's climb performance being exceeded due to the rising terrain.Sep 15, 2000 · N6130H · Substantial damageNTSB DEN00LA167Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe unsuitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the engine oil pump and the dark night light conditions.Sep 10, 2000 · N1036V · Substantial damageNTSB ATL00LA088Accident · No injuriesLimited investigationFinal reportCessna 188 · Tampa, FLThe failure of the number six-piston connecting rod that resulted in the total loss of engine power.Sep 10, 2000 · N9977G · Substantial damageNTSB LAX00LA329Accident · No injuriesLimited investigationFinal reportBeech A36TC · Minden, NVthe failure of the pilot to follow the pilot operating handbook procedures and to refuel the airplane.Sep 7, 2000 · N7110M · Substantial damageNTSB LAX00LA328Accident · 1 fatalLimited investigationFinal reportHughes 269C · Rancho Murieta, CAThe pilot's inadequate visual lookout during cruise, which subsequently led to a wire strike.Sep 7, 2000 · N50638 · DestroyedNTSB DEN00LA165Accident · Serious injuriesLimited investigationFinal reportGulfstream G-IV · Sheridan, WYthe pilot's inadvertent flight into unforecasted turbulent weather conditions. A contributing factor was the turbulence.Sep 6, 2000 · N1625 · No damageNTSB NYC00FA248Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · South Kingstown, RIThe pilot's loss of control, and his subsequent overstress of the airplane after a vacuum system failure during flight in instrument meteorological conditions. Factors included the instrument meteorological conditions, a sheared coupling on the vacuum pump,…Sep 3, 2000 · N8230G · DestroyedNTSB LAX00LA356Accident · No injuriesLimited investigationFinal reportCessna 177B · Hinkley, CALoss of engine power due to fuel exhaustion when the pilot became lost and disoriented.Sep 2, 2000 · N30955 · Substantial damageNTSB CHI00LA285Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Cape Girardeau, MOthe pilot's improper decision to continue the flight when the fuel sight gauge indicated empty and the exhausted fuel supply. A factor was the corn crop.Sep 2, 2000 · N66607 · Substantial damageNTSB NYC00LA246Accident · Minor injuriesLimited investigationFinal reportCessna 310G · Seven Springs, PAThe pilot's failure to maintain the manufacture's recommended safe single-engine airspeed, which resulted in a velocity-minimum-control roll to the right. A factor in the accident was the pilot's failure to maintain a proper glide path to his intended…Sep 1, 2000 · N8978Z · Substantial damage