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 DCA02MA003Accident · 10 fatalMajor investigationFinal reportCessna 208 · Dillingham, AKan in-flight loss of control resulting from upper surface ice contamination that the pilot-in-command failed to detect during his preflight inspection of the airplane. Contributing to the accident was the lack of a preflight inspection requirement for CE-208…Oct 10, 2001 · N9530F · DestroyedNTSB FTW02LA006Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS355F1 · Rosebud, TXThe pilots impairment due to drugs. Contributing factors were the dark night light conditions, the pilot's failure to refuel, resulting in the total loss of engine power due to fuel exhaustion, and the pilot's misjudged landing flare.Oct 8, 2001 · N911BB · Substantial damageNTSB CHI02LA002Accident · No injuriesLimited investigationFinal reportWorner 1000 STU · Liberal, KSThe pilot's inadvertent flight into adverse weather conditions during cruise flight and the unsuitable landing area encountered during the uncontrolled descent. Factors relating to this accident were the high wind, the pilot's unsuccessful attempt to…Oct 7, 2001 · D-OAGH · Substantial damageNTSB SEA02LA003Accident · Minor injuriesLimited investigationFinal reportEllsberg One Design · Bend, ORthe separation of a propeller counterweight mounting bracket due to incorrect mounting bolt torque. Factors include significant powerplant vibration during the forced landing, no suitable landing area, and soft terrain next to the narrow road on which the…Oct 6, 2001 · N55TE · Substantial damageNTSB NYC02LA005Accident · Serious injuriesLimited investigationFinal reportReindl CGS Hawk A · Fayetteville, OHThe owner/mechanic's inadequate annual inspection. A factor related to the accident was the rotted fuel line which separated from it's connection at the fuel pump.Oct 5, 2001 · N3963W · Substantial damageNTSB IAD02FA002Accident · 2 fatalField investigationFinal reportCessna 210M · Pittsfield, PAThe pilot's loss of control in flight due to spatial disorientation, and his subsequent overstress of the airplane during a recovery attempt. A factor in the accident was the pilot's use of inappropriate medications.Oct 5, 2001 · N6053B · DestroyedNTSB IAD02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Phillips, MELoss of engine power due to a blockage of the left fuel tank vent line with mud, and the subsequent inadvertent stall.Oct 4, 2001 · N7591X · Substantial damageNTSB NYC02LA027Accident · No injuriesLimited investigationFinal reportLet Blanik L 33 Solo · Windsor, VAThe pilot's inadequate preflight inspection, which resulted in a loose battery charger becoming entangled in the rudder pedals during a spin recovery, and a subsequent overstress of the glider. Factors included the loose battery charger, and the non-standard…Oct 3, 2001 · N388BA · Substantial damageNTSB FTW02LA002Accident · Serious injuriesLimited investigationFinal reportHamilton Genesis · Grants, NMthe loose throttle cable resulting in a partial loss of engine power. Contributing factors were the pilot's failure to perform the required yearly condition inspection prior to flight and the lack of suitable terrain for the forced landing.Oct 3, 2001 · N715MP · Substantial damageNTSB CHI02FA001Accident · 1 fatalField investigationFinal reportEnstrom F-28A · Attica, MIThe reported loss of engine power due to fuel exhaustion during cruise flight, the pilot not performing an autorotation, the pilot not maintaining rotor RPM during his emergency descent, and the pilot not maintaining control of the helicopter. A factor was…Oct 3, 2001 · N137E · Substantial damageNTSB NYC02LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Ashland, METhe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Oct 2, 2001 · N2528M · Substantial damageNTSB NYC02LA002Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Hudson, NHThe pilot/owner's failure to properly identify the inoperative engine prior to feathering the wrong propeller, and his lack of familiarity with the required corrective procedures. A factor was the initial engine failure.Oct 2, 2001 · N8393H · Substantial damageNTSB SEA02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lindsay, MTThe pilot's failure to maintain an altitude clear of terrain. A factor was intentional low altitude flight.Oct 1, 2001 · N3910F · DestroyedNTSB LAX01FA306Accident · Minor injuriesField investigationFinal reportBell 206B · Hilo, HIThe failure of the mechanic to secure the No. 8 bearing thrust nut during maintenance work, which resulted in the total failure of the first stage turbine wheel shaft. Also causal was his misjudgment of his height during the flare resulting in a hard landing.…Sep 30, 2001 · N206KS · DestroyedNTSB CHI01FA329Accident · 3 fatalField investigationFinal reportCessna 414 Riley Super-8 · Marshfield, WIThe pilot's failure to maintain adequate airspeed (Vmc) which resulted in a loss of control. Contributing factors were the improper in-flight planning/decision not to land at a closer airport and the lack of recent experience in multiengine airplanes by the…Sep 29, 2001 · N414NG · DestroyedNTSB FTW01LA207Accident · No injuriesLimited investigationFinal reportAyres S2R-T11 · Spur, TXthe loss of engine power while in cruise flight for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Sep 19, 2001 · N40173 · Substantial damageNTSB CHI01LA318Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR-20 · St. Bonifacius, MNImproper servicing of the airplane by other maintenance personnel, inadequate inspection of the airplane by the other maintenance personnel prior to the airplane's flight, and the unsuitable terrain encountered during the forced landing. Factors relating to…Sep 19, 2001 · N747TW · Substantial damageNTSB ATL01LA110Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLThe improper installation of the engine vacuum pump by maintenance personnel which resulted in oil exhaustion and the subsequent loss of engine power. A factor was the none-suitable terrain.Sep 17, 2001 · N158RA · Substantial damageNTSB LAX01LA286Accident · 1 fatalLimited investigationFinal reportCessna 172L · Tucson, AZthe pilot's controlled descent into a residence for undetermined reasons.Sep 16, 2001 · N4312Q · DestroyedNTSB DCA01MA065Accident · 44 fatalMajor investigationFinal reportBoeing 757 · Shanksville, PAThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…Sep 11, 2001 · N591UA · DestroyedNTSB DCA01MA064Accident · 64 fatalMajor investigationFinal reportBoeing 757-200 · Arlington, VAThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…Sep 11, 2001 · N644AA · DestroyedNTSB DCA01MA063Accident · 65 fatalMajor investigationFinal reportBoeing 767-200ER · New York City, NYThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…Sep 11, 2001 · N612UA · DestroyedNTSB DCA01MA060Accident · 92 fatalMajor investigationFinal reportBoeing 767-200ER · New York City, NYThe Safety Board did not determine the probable cause and does not plan to issue a report or open a public docket. The terrorist attacks of September 11, 2001 are under the jurisdiction of the Federal Bureau of Investigation. The Safety Board provided…Sep 11, 2001 · N334AA · DestroyedNTSB NYC01LA226Accident · Serious injuriesLimited investigationFinal reportMurray JN4-D · Morrisdale, PAFailure of the ignition coil, which resulted in a loss of engine power. A factor was the 10-foot corn in the forced landing field.Sep 9, 2001 · N176TP · Substantial damageNTSB ATL01FA105Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Byhalia, MSThe pilot's improper evaluation of weather conditions which lead to an inflight encounter with turbulent weather resulting in an in flight break up of the airframe, and subsequent uncontrolled descent into terrain. A factor was the pilot's drug impairment.Sep 8, 2001 · N8398Z · DestroyedNTSB CHI01FA312Accident · Serious injuriesField investigationFinal reportPiper PA-32R-301T · Downers Grove, ILthe improper preflight planning/preparation and the short field take off/procedure not followed by the pilot. Contributing factors were the airplane's forward center of gravity, the variable gusting wind and improper weight and balance calculations by…Sep 7, 2001 · N81557 · DestroyedNTSB ANC01LA138Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-3 · Cordova, AKThe loss of engine power during cruise due to the fracture of an engine cylinder exhaust valve.Sep 7, 2001 · N254AW · Substantial damageNTSB ATL01LA103Accident · Serious injuriesLimited investigationFinal reportNorth American P51-D · Lincolnton, NCA cooling system failure, that resulted in a total loss of coolant and the subsequent loss of engine power. A factor was the lack of suitable terrain for an emergency landing.Sep 6, 2001 · N551CB · DestroyedNTSB LAX01LA300Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Cottonwood, AZThe pilot's failure to obtain/maintain a proper descent rate, as well as prematurely starting his decent during nighttime operations, subsequently colliding with 60-foot power lines 4 miles from the airport.Sep 5, 2001 · N3250S · Substantial damageNTSB LAX01LA289Accident · No injuriesLimited investigationFinal reportCessna 150J · Sonoma, CAFuel exhaustion due to the pilot's inadequate preflight fuel consumption calculations and failure to ensure that adequate fuel was onboard the airplane prior to departure. A factor in the accident was the pilot's continued use of the airplane with known…Sep 5, 2001 · N51256 · Substantial damageNTSB ANC01LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKA loss of engine power during cruise flight for an undertermined reason.Sep 5, 2001 · N74806 · Substantial damageNTSB NYC01LA220Accident · No injuriesLimited investigationFinal reportAndre Mini Max 1500R · Chesapeake, VAThe pilot's failure to follow the engine manufacturer's descent procedure, which resulted in a lean mixture condition and subsequent engine seizure.Sep 3, 2001 · N962JA · Substantial damageNTSB NYC01LA221Accident · No injuriesLimited investigationFinal reportde Havilland DHC-94 Moth Minor · Farmington, PAThe in-flight separation of a propeller blade, which resulted in a forced landing to unsuitable terrain. A factor related to the accident was the plowed field.Sep 2, 2001 · N9403 · Substantial damageNTSB ANC01LA141Accident · No injuriesLimited investigationFinal reportJacobs KE-1-A · Willow, AKA loss of engine power during cruise flight for an undertermined reason.Sep 1, 2001 · N24KJ · Substantial damageNTSB SEA01MA163Accident · 3 fatalMajor investigationFinal reportKawasaki KV-107-II · Emigrant, MTThe loss of control during cruise/climb flight for undetermined reasons.Aug 31, 2001 · N186CH · DestroyedNTSB IAD01LA102Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ-135ER · Richmond, VAInadequate company procedures/directives, which resulted in the flight attendant leaving her seat prematurely, while the airplane was still in an area of turbulence.Aug 30, 2001 · N25504 · No damageNTSB ATL01LA098Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Eagleville, TNThe loss of thermals during the glider flight that resulted in the collision with high vegetation while maneuvering for an emergency landing. A factor was high vegetation.Aug 26, 2001 · N121FL · Substantial damageNTSB ATL01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Homerville, GAThe improper replacement of an accessory drive component with an unapproved part by maintenance personnel, which resulted in a fatigue fracture of the component and loss of engine power. The airplane subsequently collided with power lines and trees during an…Aug 26, 2001 · N2116G · Substantial damageNTSB SEA01LA157Accident · No injuriesLimited investigationFinal reportSuper Quickie 2 · Bonney Lake, WAImproper carburetor adjustment resulting in a total loss of engine power while in a descent configuration. Factors include an excessively lean mixture setting and unsuitable terrain for landing.Aug 25, 2001 · N34DQ · Substantial damageNTSB LAX01LA288Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Camarillo, CAThe improper fabrication/reassembly and inspection of the engine throttle control linkage during aircraft restoration by the operator, and the failure of the operator's inspection personnel to detect the error during subsequent annual inspections.Aug 25, 2001 · N48742 · Substantial damageNTSB FTW01LA195Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Cameron, LAfuel contamination due to the combination of DIEGME, water, and bacterial growth, which resulted in formation of an apple-jelly type material that blocked the fuel nozzle screen and led to a loss of engine power.Aug 24, 2001 · N350AL · DestroyedNTSB CHI01FA290Accident · 1 fatalField investigationFinal reportNavion L-17B · Newaygo, MIThe pilot inadvertently positioning the fuel selector in an intermediate position, resulting in a loss of engine power. An additional cause was the pilot's failure to verify the fuel selector position during the engine restart attempt. Factors to the accident…Aug 23, 2001 · N1017B · Substantial damageNTSB FTW01FA188Accident · 1 fatalField investigationFinal reportCessna 152 · Weatherford, TXThe student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by…Aug 22, 2001 · N4755B · DestroyedNTSB MIA01LA224Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Needles, CAan inadvertent in-flight encounter with turbulence.Aug 20, 2001 · N605AW · No damageNTSB MIA01LA222Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Mitchell, GAThe poor in-flight planning by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.Aug 19, 2001 · N232CD · Substantial damageNTSB ATL01FA094Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Rienzi, MSThe pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition.Aug 19, 2001 · N57297 · DestroyedNTSB FTW01LA200Accident · No injuriesLimited investigationFinal reportCessna 182A · Salado, TXA loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005.Aug 18, 2001 · N4795D · Substantial damageNTSB DEN01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Rock Springs, WYthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent failure of a connecting rod during cruise flight. A contributing factor was the…Aug 18, 2001 · N3015L · Substantial damageNTSB CHI01LA285Accident · Serious injuriesLimited investigationFinal reportWaters Avid Bandit · Northville, MIfuel starvation due to the pilot's improper fuel calculations. A factor was the concrete building.Aug 18, 2001 · N62PT · Substantial damageNTSB CHI01LA284Accident · Minor injuriesLimited investigationFinal reportCameron Balloons Shuttle 90 · Centralia, ILThe balloon envelope fire. A contributing factor was the flammability of the envelope.Aug 18, 2001 · N8094S · Destroyed