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 FTW93IA118Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Houston, TXEncounter with turbulence. A factor was the loss of electrical powerApr 7, 1993 · CFOOA · No damageNTSB DEN93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Llano, TXThe pilot's continued VFR flight into IMC. Factors were: low ceiling, dark night, and the pilot's lack of total instrument time.Apr 7, 1993 · N81527 · DestroyedNTSB SEA93LA087Accident · No injuriesLimited investigationFinal reportCessna T210M · Scappose, WAClearance from objects was not maintained. The pilot's poor inflight planning and the weather conditions were factors.Apr 6, 1993 · N16CE · Substantial damageNTSB DCA93MA037Accident · 2 fatalClass 1 · MajorFinal reportMcdonnell Douglas MD-11 · Shemya, AKThe national transportation safety board determines that the probable cause of this accident was the inadequate design of the flap/slat actuation handle by the Douglas aircraft company that allowed the handle to be easily and inadvertently dislodged from the…Apr 6, 1993 · B2171 · Minor damageNTSB CHI93LA136Accident · No injuriesLimited investigationFinal reportCessna T210 · Philadelphia, ILThe pilot's failure to ensure an adequate fuel supply to complete the flight.Apr 6, 1993 · N6471N · Substantial damageNTSB LAX93LA164Accident · No injuriesLimited investigationFinal reportRoy Rey Avid Flyer · Wasco, CACarburetor icing. Factors relating to the accident were the lack of a carburetor heat control system and the freshly plowed field.Apr 5, 1993 · N827H · Substantial damageNTSB NYC93LA067Accident · Minor injuriesLimited investigationFinal reportSilva Seawind 3000 · Coatesville, PAImproper adjustment setting of the propeller pitch change mechanism and/or propeller governor output pressure, which resulted in a loss of positive thrust and a forced landing.Apr 3, 1993 · N465W · Substantial damageNTSB ANC93FA050Accident · 2 fatalField investigationFinal reportCessna 207 · Nome, AKThe pilot initiated VFR flight into instrument meteorological and whiteout conditions. Factors which contributed to the accident were: inadequate supervision of the pilot by the company, inadequate oversight by the federal aviation administration, the pilot's…Apr 3, 1993 · N6467H · DestroyedNTSB ATL93MA068Accident · 4 fatalMajor investigationFinal reportFairchild SA227-TT · Blountville, TNFailure of the pilot to follow procedures concerning use of the engine inlet anti-ice system and/or continuous ignition while operating in icing conditions, which resulted in probable ice ingestion and loss of engine power; and the pilot's failure to maintain…Apr 2, 1993 · N500AK · DestroyedNTSB FTW93FA115Accident · Minor injuriesField investigationFinal reportChance Vought F4U-4 · Breckenridge, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landingApr 1, 1993 · N68HP · Substantial damageNTSB DEN93FA038Accident · 3 fatalField investigationFinal reportAerospatiale SA316B · Aspen, COFailure of the flight control lower mixing unit due to fatigue, which resulted in the loss of control.Apr 1, 1993 · N3153R · DestroyedNTSB DCA93MA033Accident · No injuriesClass 1 · MajorFinal reportBoeing 747-121 · Anchorage, AKThe lateral separation of the no. 2 engine pylon due to an encounter with severe or possibly extreme turbulence that resulted in dynamic multi-axis lateral loadings that exceeded the ultimate lateral load-carrying capability of the pylon, which was already…Mar 31, 1993 · N473EV · Substantial damageNTSB CHI93IA124Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Moline, ILThe passenger's failure to extinguish a cigarette before placing it into the lavatory waste bin. Factors related to the incident were: an inoperative smoke detector in the lavatory, the manufacturer's inadequate maintenance program, and inadequate review of…Mar 31, 1993 · N426TE · No damageNTSB LAX93FA165Accident · 1 fatalField investigationFinal reportCessna 152 · Dunsmuir, CAAn inadvertent encounter with rain and icing conditions. Factors in this accident included environmental conditions consisting of rain, icing, and darkness, and the pilot's overconfidence in his abilities to deal with the encountered weather conditions.Mar 30, 1993 · N89174 · DestroyedNTSB SEA93FA084Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Estacada, ORFailure of the pilot to maintain proper clearance (and/or altitude) from moutainous terrain. Factors related to the accident were: darkness, clouds, low ceilings, and the high (mountainous) terrain in the area of the accident site.Mar 29, 1993 · N63888 · DestroyedNTSB LAX93LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Fresno, CAthe improper installation of an electrical wire bundle, and, the chaffing and subsequent arcing of the wires against a fuel line which resulted in a fire.Mar 29, 1993 · N758XY · Substantial damageNTSB NYC93FA066Accident · 6 fatalField investigationFinal reportPiper PA-23-250 · Elmwood Park, NJInadequate maintenance and inspection of the fuel injector system resulting in a loss of power of the left engine, and the failure of the pilot to maintain minimum control speed which resulted in a flat spin. A factor which contributed to the accident was the…Mar 28, 1993 · N6382Y · Substantial damageNTSB CHI93LA123Accident · Minor injuriesLimited investigationFinal reportRockwell 100 · Topinabee, MIthe total loss of engine power due to failure of the oil line to the oil pressure gauge. A factor relating to the accident was no suitable terrain on which to make a forced landing.Mar 28, 1993 · N4017X · Substantial damageNTSB CHI93LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Marysville, INThe pilot's failure to use carburetor heat while flying in carburetor icing conditions.Mar 27, 1993 · N3439Z · Substantial damageNTSB BFO93LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lewisburg, OHThe pilot experienced spatial disorientation. Contributing to the accident was the dark night and inadvertent flight into instrument meteorological conditions.Mar 26, 1993 · N73436 · Substantial damageNTSB LAX93LA166Accident · 1 fatalLimited investigationFinal reportBell 47G2A · Pacific Ocean (Pacific Ocean)The passenger's failure to adhere to the pilot's instructions. Factors which contributed to the accident were: the language/communications difficulty between the pilot & the passenger, and the bird strike.Mar 24, 1993 · N8493E · Minor damageNTSB MIA93LA090Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Jacksonville, FLThe operator's lack of adequate instructions to crewmembers as to when flight attendants can resume cabin duties after being told to be seated by the captain.Mar 23, 1993 · N928HA · No damageNTSB BFO93IA057Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE3201 · Rochester, NYFailure of the main cabin door to be adequately secured for flight for an unknown REAS0N.Mar 23, 1993 · N496UE · Minor damageNTSB BFO93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Monticello, MEA disconnection of the fuel line, which resulted in fuel starvation and loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.Mar 22, 1993 · N41422 · Substantial damageNTSB BFO93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Babylon, NYThe loss of engine power due to the intake valve failure.Mar 22, 1993 · N56153 · Substantial damageNTSB CHI93IA127Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILThe local controller's failure to maintain 3 miles radar separation between two airplanes. A factor related to the incident was the local controller's delay in remedial action.Mar 21, 1993 · N374MQ · No damageNTSB ANC93LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Drift River, AKThe pilots inadvertent VFR flight into IMC conditions. Factors were the rising terrain and the whiteout conditions.Mar 20, 1993 · N72999 · Substantial damageNTSB MIA93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Madison, MSInduction air control/system partial failure, induction air control/system leak, and the lack of suitable terrain for the forced landing.Mar 19, 1993 · N66388 · Substantial damageNTSB LAX93FA154Accident · 2 fatalField investigationFinal reportCessna 172M · White Water, CAThe pilot's failure to see and avoid the tower due to drug impairment. Factors which contributed to the accident were: the low altitude and the dawn light condition.Mar 19, 1993 · N12587 · DestroyedNTSB ANC93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Anchorage, AKThe complete loss of engine power due to undetermined reasons. Factor was the deep water forced landing area.Mar 19, 1993 · N4182M · DestroyedNTSB SEA93LA078Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Quincy, WAUnsuitable terrain encountered during a forced landing after an engine cylinder assembly had separated. Factors include a snowbank.Mar 18, 1993 · N7503L · Substantial damageNTSB LAX93LA181Accident · Minor injuriesLimited investigationFinal reportCessna U-206G · Yuma, AZAn inadequate annual inspection which led to a loss of the electrical system due to loose alternator belt, and the pilot's failure to attain the proper touchdown point during a night precautionary landing on an unlit runway.Mar 16, 1993 · N733TH · Substantial damageNTSB MIA93LA085Accident · No injuriesLimited investigationFinal reportCessna 150M · Fort Pierce, FLInaccurate fuel consumption calculations, resulting in fuel exhaustion.Mar 15, 1993 · N6168K · Substantial damageNTSB LAX93LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lake Havasu, AZThe improper welding of the inboard boss by an unknown person resulting in a fatigue failure on the inboard boss. A factor related to the accident was the vehicle that was struck during the forced landing.Mar 15, 1993 · N466KT · Substantial damageNTSB FTW93FA105Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Radium Springs, NMA total failure of the airplane's vacuum system. Factors which contributed to the accident were: the dark night, snow, the pilot's loss of aircraft control, and the pilot's lack of experience in flying in actual intrument meteorological conditions.Mar 15, 1993 · N47402 · DestroyedNTSB FTW93FA103Accident · 4 fatalField investigationFinal reportBeech 58 · Grants, NMThe pilot's inadequate preflight planning/preparation and the selection of an altitude that would not provide terrain clearance along his planned route. Factors were the dark night conditions and the mountainous terrain.Mar 15, 1993 · N4320W · DestroyedNTSB LAX93LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Gila Bend, AZThe failure of maintenance personnel to perform mandatory service bulletins during the annual inspection 20 flying hours prior to the accident which resulted in the carburetor's primary venturi becoming loose.Mar 14, 1993 · N4070F · Substantial damageNTSB LAX93FA149Accident · 3 fatalField investigationFinal reportCessna 421C · Eagle Mountain, CAFailure of the left elevator for undetermined reason(s), which resulted in flutter and failure of the empennage, and subsequent uncontrolled collision with the terrain.Mar 12, 1993 · N2656N · DestroyedNTSB MIA93LA084Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Village Of Golf, FLThe pilot-in-command's improper movement of the fuel selector valve resulting in fuel starvation, forced landing, and an in-flight collision with terrain.Mar 10, 1993 · N6998Q · Substantial damageNTSB FTW93FA100Accident · Serious injuriesField investigationFinal reportBoeing 727-200 · Houston, TXThe failure of the pilot of the T-38A to follow flight advisories. A factor which contributed to the accident was the development of a letter of agreement between the FAA and NASA which was not in accordance with ICAO procedures.Mar 9, 1993 · N79754 · No damageNTSB ANC93LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Port Alsworth, AKThe non instrument rated pilot in command entering instrument meteorological conditions. A factor in the accident was the snow/whiteout condition.Mar 8, 1993 · N9737G · Substantial damageNTSB FTW93LA097Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Plano, TXFuel starvation induced power loss resultant from failure of the pilot to switch the fuel selector to the proper fuel tank. Factors were the dark night conditions and lack of suitable terrain for a forced landingMar 7, 1993 · N6088S · Substantial damageNTSB FTW93FA096Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXThe pilot's failure to maintain control of the airplane for undetermined reasonsMar 6, 1993 · N222UF · DestroyedNTSB FTW93LA095Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Midlothian, TXThe loss of engine power and the pilot's failure to refuel. A factor was the inadvertent stall during the flare touchdownMar 5, 1993 · N800VT · Substantial damageNTSB FTW93LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, TXFuel starvation power loss due to carburetor restriction from a foreign object, the inadequate inspection and improper overhaul of the carburetor by other maintenance personnelMar 3, 1993 · N8071E · Substantial damageNTSB DEN93LA030Accident · No injuriesLimited investigationFinal reportCessna T210N · Walsh, COA complete power loss from mechanical failure. A factor was: a pond, which the aircraft entered during landing roll.Mar 3, 1993 · N5367A · Substantial damageNTSB SEA93FA071Accident · 2 fatalField investigationFinal reportCessna 402B · Oakley, UTPoor inflight planning/decision. Factors to the accident were: dark night condition and terrain clearance was not maintained.Mar 2, 1993 · N3103P · DestroyedNTSB BFO93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Petersburg, OHLoss of engine power due to undetermined reasons. A factor related to the accident was the short, soft, hilly terrain condition in the emergency landing area.Mar 1, 1993 · N5523L · Substantial damageNTSB SEA93LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe failure of the engine oil pump impeller.Feb 28, 1993 · N12698 · Substantial damageNTSB MIA93LA076Accident · Minor injuriesLimited investigationFinal reportHuddleston-Bell 47G2 · Rio Grande, PRPoor in-flight planning by the pilot-in-command. Contributing to the accident was the flight's lack of total experience.Feb 28, 1993 · N37870 · Substantial damage