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 ANC14LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182K · Galena, AKA total loss of engine power for undetermined reasons, which necessitated a forced landing on unsuitable terrain, during which the airplane flipped over and became partially submerged in water.Jun 1, 2014 · N2631R · Substantial damageNTSB WPR14FA218Accident · 2 fatalField investigationFinal reportNebert Vans RV-10 · Toledo, ORA total loss of engine power due to fuel starvation because of a blocked fuel line that resulted from the pilot’s improper maintenance practices and the pilot’s subsequent failure to maintain adequate airspeed while attempting a forced landing, which led to…May 31, 2014 · N62DN · Substantial damageNTSB ERA14LA272Accident · Minor injuriesLimited investigationFinal reportLandrum Kelly T Vans RV6 · Suffolk, VAThe pilot/builder's decision to use a lubricant that was not designed for high-speed aviation applications, which resulted in the failure of the propeller needle thrust bearing due to the loss of lubrication from overheating, a total loss of aerodynamic…May 31, 2014 · N6RP · Substantial damageNTSB ANC14LA035Accident · No injuriesLimited investigationFinal reportDehavilland DHC-3T · Homer, AKThe flutter failure of the right elevator servo tab due to the improper fabrication of the servo tab and maintenance personnel’s subsequent failure to detect anomalies with the servo tab.May 30, 2014 · N3125N · Substantial damageNTSB ANC14CA033Accident · No injuriesData collectionFinal reportCessna 172F · Fairbanks, AKThe pilot's improper inflight planning, which resulted in fuel starvation and a loss of engine power. A factor was the pilot's selection of a low cruise flight altitude, which provided little time for the selection of suitable terrain for the forced landing…May 30, 2014 · N8646U · Substantial damageNTSB CEN14LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COThe pilot's failure to adequately monitor the airplane's actual fuel consumption rate, which resulted in a total loss of engine power due to fuel exhaustion.May 28, 2014 · N8808L · Substantial damageNTSB ERA14WA275Accident · 5 fatalForeign investigationBeech B200 · Colonia, UruguayOn May 27, 2014, about 1050 coordinated universal time (UTC), a Beechcraft B200, Argentina registration LV-CNT, was substantially damaged when it impacted the water near Rio de la Plata, Uruguay. The Argentinian pilot and four of the passengers were fatally…May 27, 2014 · LV-CNT · Substantial damageNTSB CEN14LA263Accident · No injuriesLimited investigationFinal reportAero Commander 200D · La Grange, TXThe loss of engine power due to oil starvation for reasons that could not be determined based on the available evidence.May 27, 2014 · N200D · Substantial damageNTSB CEN14LA253Accident · No injuriesLimited investigationFinal reportBeech A36 · Rockdale, TXA loss of engine power for reasons that could not be determined because postaccident testing revealed no anomalies.May 26, 2014 · N188DP · Substantial damageNTSB ERA14CA265Accident · No injuriesData collectionFinal reportDivis S L/Waltrip A J RV 4 · Harpswell, METhe pilot's inadequate preflight and in-flight planning which resulted in total loss of engine power due to fuel exhaustion.May 25, 2014 · N403WD · Substantial damageNTSB WPR14LA208Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.May 24, 2014 · N21048 · Substantial damageNTSB WPR14LA207Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Arvin, CAThe pilot’s failure to reconnect the air-oil separator return line after completing an oil change, which resulted in a total loss of engine power due to oil starvation.May 24, 2014 · N97038 · Substantial damageNTSB ERA14WA264Accident · 2 fatalClass 5 · ForeignBeech 58P · Trinidad, BoliviaMay 23, 2014 · CP-2544 · DestroyedNTSB ERA14FA260Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA1B · Chester, SCThe pilot's inadequate inflight fuel monitoring, which resulted in fuel exhaustion and the subsequent total loss of engine power. Contributing to the accident was the loose fuel cap, which allowed fuel to syphon out in flight.May 23, 2014 · N8890L · Substantial damageNTSB ERA14IA249Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Warren, VTThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.May 21, 2014 · N116WA · Minor damageNTSB CEN14LA244Accident · Minor injuriesLimited investigationFinal reportCrawford Preceptor Ultra PUP · Mabel, MNThe loss of engine power as a result of carburetor icing.May 17, 2014 · N1171Q · Substantial damageNTSB DCA14WA095Incident · No injuriesForeign investigationBoeing 737-800 · Bangkok, ThailandThe Aviation Safety Council (ASC) of Taiwan has notified the NTSB of an incident involving a Boeing 737-800 that occurred on 11 May, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO…May 11, 2014 · B-18601 · No damageNTSB WPR14FA186Accident · 1 fatalField investigationFinal reportCessna T207A · Page, AZThe pilot’s inability to maintain aircraft control due to a partial loss of engine power and an encounter with downdrafts and gusting crosswinds while on final approach to the runway. The reason for the partial loss of engine power could not be determined…May 10, 2014 · N7311U · Substantial damageNTSB ERA14LA227Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Covington, TNThe pilot’s improper preflight and in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power over unsuitable terrain.May 7, 2014 · N4506W · DestroyedNTSB WPR14FA188Accident · 2 fatalField investigationFinal reportMooney M20C · Cody, WYThe non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.May 6, 2014 · N6704U · Substantial damageNTSB CEN14LA241Accident · Serious injuriesLimited investigationFinal reportKinsler Arthur Paul Kinsler Lancair/Mkii · Crivitz, WIThe improper installation of the hose fuel fitting, which resulted in the fitting becoming disconnected and the subsequent loss of engine power due to fuel starvation.May 6, 2014 · N246AK · Substantial damageNTSB WPR14LA240Accident · No injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYMaintenance personnel’s application of insufficient torque to the engine cylinder through bolts during replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 main bearing, the bearing shifting, and a catastrophic engine failure.May 5, 2014 · N323JC · Substantial damageNTSB WPR14LA185Accident · Minor injuriesLimited investigationFinal report177mf Pitts Model 12 · Bluffdale, UTA complete loss of engine power for reasons that could not be determined because of insufficient evidence.May 4, 2014 · N177MF · Substantial damageNTSB ERA14LA223Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hamburg, NYWear in the left cabin door assembly parts, which resulted in the door partially opening in flight, dislodging from the lower door track assembly, and then separating from the helicopter.May 4, 2014 · N504TJ · Substantial damageNTSB ERA14LA219Accident · Serious injuriesLimited investigationFinal reportCzech Sport Aircraft A S Sportcruiser · Advance, NCThe pilot’s failure to apply carburetor heat during a descent with reduced engine power while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power.May 4, 2014 · N162US · Substantial damageNTSB WPR14LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G · El Monte, CAA partial loss of engine power during climbout due to a malfunctioning magneto and spark plugs.May 3, 2014 · N7895B · Substantial damageNTSB CEN14CA227Accident · No injuriesData collectionFinal reportPiper PA 24-250 · New Braunfels, TXThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and inflight decision making.May 2, 2014 · N7308P · Substantial damageNTSB WPR14LA177Accident · Serious injuriesLimited investigationFinal reportAirplane Factory Ltd The Sling · Daggett, CAThe pilots’ failure to maintain clearance from terrain while operating in dark night, visual meteorological conditions. Contributing to the accident was the pilots’ failure to enable the aural terrain warning system.Apr 30, 2014 · N511NG · Substantial damageNTSB OPS14IA007Incident · Minor injuriesIncident investigationFinal reportBoeing 757 · Powhatan, VAThe air traffic controller’s failure to provide required advisories about significant radar-observed convective precipitation along both airplanes’ flight routes and the air route traffic control center’s lack of a program to ensure that air traffic…Apr 29, 2014 · UNK · Minor damageNTSB CEN14FA224Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Highmore, SDThe pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…Apr 28, 2014 · N8700E · DestroyedNTSB CEN14LA218Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wann, OKThe pilot's inadequate preflight inspection and planning and inflight fuel management, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing in an area of unsuitable terrain.Apr 27, 2014 · N3078Y · Substantial damageNTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.Apr 26, 2014 · N911EX · DestroyedNTSB CEN14LA226Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Greenville, TXThe fatigue failure of the No. 4 cylinder exhaust valve due to excessive wear of the corresponding train tappet, which resulted in a total loss of engine power.Apr 25, 2014 · N106SF · Substantial damageNTSB CEN14LA228Accident · Serious injuriesLimited investigationFinal reportBrecher Rotorway Exec · Richwood, OHThe flight instructor’s inadequate autorotation, which resulted in a hard landing and postcrash fire. Contributing was the flight instructor’s lack of experience in performing an autorotation in the accident make and model of helicopter.Apr 24, 2014 · N43691 · Substantial damageNTSB DCA14WA151Accident · 2 fatalForeign investigationPiper PA46 · Kimberley, South AfricaApr 22, 2014 · ZS-LLD · DestroyedNTSB ERA14LA202Accident · No injuriesLimited investigationFinal reportOconnor Paul A Ultimate Aero 10-200 · Saint Albans, VTThe propeller blade’s failure due to fatigue cracks that initiated from pitch change pin attachment holes that had been drilled too deep during manufacture.Apr 18, 2014 · N827D · DestroyedNTSB CEN14LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Searcy, ARThe pilot's inadequate preflight inspection of the airplane, which resulted in oil starvation and a subsequent engine failure.Apr 18, 2014 · N9421X · Substantial damageNTSB WPR14CA168Accident · Minor injuriesData collectionFinal reportLinstrand 240A · Mayer, AZThe balloon's encounter with unexpected increased wind, which resulted in a hard landing on rough terrain.Apr 14, 2014 · N2646Z · Substantial damageNTSB ERA14LA198Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Aguas Buenas, PRThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Apr 13, 2014 · N2875D · Substantial damageNTSB CEN14FA198Accident · 1 fatalField investigationFinal reportBeech C24 · Denton, TXThe pilot mistakenly manipulated the airplane's mixture knob rather than the propeller control knob during the descent, reducing the airplane's mixture knob to where the fuel-air mixture to the engine was too lean, which caused the engine to fail, and the…Apr 13, 2014 · N23984 · Substantial damageNTSB CEN14LA195Accident · No injuriesLimited investigationFinal reportLarsen Mark V · Amelia, OHThe distributor failure, which resulted in a total loss of engine power during cruise climb.Apr 12, 2014 · N87JL · Substantial damageNTSB WPR14FA165Accident · 1 fatalField investigationFinal reportWilliams Myron G Bowers FLY Baby 1A · Mariposa, CAThe partial loss of engine power due to an improperly maintained carburetor and the pilot's subsequent failure to maintain aircraft control.Apr 11, 2014 · N6054Q · Substantial damageNTSB ERA14LA193Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Louisa, VAThe pilot's decision to continue operation of the airplane with known mechanical issues (fluctuating oil pressure and metal in the oil filter), which was the result of undertorqued cylinder through bolts. Contributing to the accident was the mechanic's…Apr 11, 2014 · N156SA · Substantial damageNTSB ERA14FA192Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Hugheston, WVThe pilot's loss of airplane control while operating in instrument flight rules conditions.Apr 11, 2014 · N39965 · DestroyedNTSB ERA14WA207Accident · 4 fatalForeign investigationEmbraer EMB-720D · Aripuanã, BrazilOn April 6, 2014, about 1130 universal coordinated time, an Embraer EMB-720D, Brazilian registration PT-ROS, was destroyed when it impacted trees and terrain near Aripuanã, Brazil. The pilot and three passengers were fatally injured. The flight originated…Apr 6, 2014 · PT-ROS · DestroyedNTSB CEN14LA194Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Lee's Summit, MOThe pilots’ inadequate preflight planning and fuel management, which resulted in fuel exhaustion, a loss of engine power, and a forced landing on a soft field. Contributing to the accident was the flying pilot’s improper use of flaps during the forced landing.Apr 6, 2014 · N761BT · Substantial damageNTSB ERA14WA187Accident · 1 fatalForeign investigationPiper PA-30 · Collagna, ItalyOn April 4, 2014, at 0920 Coordinated Universal Time (UTC), a Piper PA-30, N678AL, was destroyed when it impacted terrain during cruise flight near Collagna, Italy. The pilot, the sole occupant, was fatally injured. The flight was operated by a private…Apr 4, 2014 · N678AL · DestroyedNTSB ERA14LA179Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Clayton, ALMaintenance personnel’s failure to properly torque the engine case through bolts, which resulted in the fatigue fracture of the crankshaft and subsequent total loss of engine power.Apr 3, 2014 · N1631X · Substantial damageNTSB ERA14LA183Accident · No injuriesLimited investigationFinal reportRobert J Reimbold Zenith CH 750 · Venus, FLThe fuel system’s inadequate design, which resulted in negative pressure in the right fuel tank and a total loss of engine power during cruise flight due to fuel starvation.Apr 2, 2014 · N938VP · Substantial damageNTSB WPR14TA149Accident · No injuriesFinal reportBell OH-58A · Tehachapi, CAThe pilot's decision to attempt a mission at night with known en route weather conditions below operating minimums, likely due to self-induced pressure, and then continue flight beyond the alternate landing airport as weather conditions deteriorated, which…Mar 27, 2014 · N497E · Substantial damage